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 |
|
nitin1111
Starting Member
13 Posts |
 Posted - 2010-06-21 : 05:32:25
|
| Following lines are from cluster key design guidelines."Wide keys are a composite of several columns or several large-size columns. The key values from the clustered index are used by all nonclustered indexes as lookup keys. Any nonclustered indexes defined on the same table will be significantly larger because the nonclustered index entries contain the clustering key and also the key columns defined for that nonclustered index."As per the documents any noncluster index entries contain the clustering key and also the key columns defined for that nonclustered index.Is it mandatory?In our database we have many noncluster indexes w/o cluster key.Please provide your guidanceThank youM.N.Dani |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2010-06-21 : 06:05:11
|
| This is implemented "behind the scenes", you will not see the reference but it's there. The leaf level of a clustered index is the actual data so the nonclustered index simply has a pointer to the data row...- LumbagoMy blog (yes, I have a blog now! just not that much content yet) -> www.thefirstsql.com |
 |
|
|
|
|
|
cluster key design