Should tables be clustered?

  • There are some great threads on this site but this has to be one of the stars.  A great explanation guys.  Thanks.

  • cannot resist adding my two pennys worth in such exalted company. As Will Summers alludes to in his post, if with your chosen clustered index new values could not be added out of order (eg clustered on an identity column) you should not set fillfactor as the table will not be subject to page splitting.

    In my experience the best index improvements I have seen in terms of reducing i/o is from using covering indexes.

    ---------------------------------------------------------------------

Viewing 2 posts - 16 through 16 (of 16 total)

You must be logged in to reply to this topic. Login to reply