Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
LearnEveryDay
Starting Member
37 Posts |
 Posted - 2005-06-30 : 10:01:13
|
| Hello Guys,Can you please explain me the difference between the above indexes?Thanks, |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-30 : 10:31:56
|
| Books On Line will explain you in detailMadhivananFailing to plan is Planning to fail |
 |
|
|
LearnEveryDay
Starting Member
37 Posts |
Posted - 2005-06-30 : 10:38:22
|
| Hello Madhi,I read those from sql books online, I dont understand to be honest.Is there any simple way of explanation? any one please?? After I have read those I am really confused??? ;) |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
LearnEveryDay
Starting Member
37 Posts |
Posted - 2005-06-30 : 11:07:39
|
| Hi,Vijayakumare has explained very well there and how jenerous of him, but I followed his samples in my querey analyser but it did not work for me, DBCC TRACEON (3604) just threw errors. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2005-06-30 : 11:20:35
|
| What did you get as error?MadhivananFailing to plan is Planning to fail |
|
|
|
Non-conformer
Starting Member
14 Posts |
Posted - 2005-06-30 : 16:55:17
|
| Quite simply, the Clustered index represents the PHYSICAL ordering of the data as it is stored. A table can have only one clustered index.Non-clustered indexes don't know and don't care how the data is physically stored. You can have as many non-clustered indexes as you want.For a lively debate topic, ask what type of data one should store in a clusted index. |
|
|
|
|
|
|
Anology between clustered and nonclustered index