Clustered Indexes

[Paul Nockolds]

Can anyone help ?

If you have a clustered index on an identity field are appends then forced onto the last page anyway because of the identity field order. So is there any advanbtage of having a clustered identity field ?

[Kenneth Wilhelmsson]

No. Clustered index on an identity is always (almost) a waste. Place your clustered index where it will do most good for your users/apps.

/Kenneth

------------
Paul Nockolds at 3/19/99 4:37:46 AM

Can anyone help ?

If you have a clustered index on an identity field are appends then forced onto the last page anyway because of the identity field order. So is there any advanbtage of having a clustered identity field ?

[david]

------------
Paul Nockolds at 3/19/99 4:37:46 AM

Can anyone help ?

If you have a clustered index on an identity field are appends then forced onto the last page anyway because of the identity field order. So is there any advanbtage of having a clustered identity field ?


I typically use clustered indexes on columns that I want to retrieve a range of items in sorted order. Good example is zip code. If you need to retrieve a range of identity fields from a query then clustered makes sense, otherwise non-clustered will work fine and updates will probably run faster.