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 |
|
mcm
Starting Member
6 Posts |
 Posted - 2008-07-24 : 11:19:56
|
| in layman's terms, plz explain diff between a clustered and non clustered indextx |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-07-24 : 11:21:27
|
| Did you take a little effort to search before you post here? |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-24 : 11:22:31
|
quote:
Originally posted by mcm
in layman's terms, plz explain diff between a clustered and non clustered indextx
have a look at books online for the explanation and post if you've any doubt after reading it. |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2008-07-24 : 11:22:33
|
quote:
Originally posted by mcm
in layman's terms, plz explain diff between a clustered and non clustered indextx
Do google searchMadhivananFailing to plan is Planning to fail |
|
|
|
mcm
Starting Member
6 Posts |
Posted - 2008-07-24 : 11:28:41
|
| i am looking for a layman's explanation from the forum here and not the techie jargon from books onlinei can access books online if i wanted to |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-24 : 11:32:59
|
quote:
Originally posted by mcm
i am looking for a layman's explanation from the forum here and not the techie jargon from books onlinei can access books online if i wanted to
Ok i will try toClustered index means the table will be sorted physically on the basis of that column. As such you can have only one clustered index in a table.Nonclustered index on the other does not physically sort the data in table. but it will storing the index information seperately. and each of the index value will have pointer to clustered index to access the record. |
|
|
|
|
|
|
clustered index