Post reply

Clustered Index.

  • June 20, 2002 at 6:16 am

    #158474

    Clustered indexes are not a good choice for:

    Columns that undergo frequent changes

    This results in the entire row moving (because SQL Server must keep the data values of a row in physical order). This is an important consideration in high-volume transaction processing systems where data tends to be volatile.

    I took the above from Books online. Is this true even if you don't change the columns that make up the clustered index ?

  • June 20, 2002 at 6:47 am

    #431235

    It means that a clustered index is not a good idea on columns that change value frequently. Other columns not in the clustered index can change values as often as you like without any effect on the clustered index.


    Jay Madren

  • June 20, 2002 at 6:59 am

    #431239

    Thanks.

Viewing 3 posts - 1 through 3 (of 3 total)

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