SQL Server Performance

Clustered Index

Discussion in 'T-SQL Performance Tuning for Developers' started by max_yogesh2002, Jul 18, 2009.

  1. max_yogesh2002 New Member

    Dear Friend,
    Is this true that Update SQL Query is slower because of Clustered index??????
    currently i have cluster index on ID columns which have the primary key
    How can i indentify the which column should have the Clustered index???
    Thanks
    max_yogesh2002, Jul 18, 2009
    #2

  2. MohammedU New Member

    MohammedU, Jul 19, 2009
    #3

  3. Adriaan New Member

    Clustered indexes should be on a column where the value "never" changes, like an identity column. Once you start changing the column value on a clustered index, the change is repeated on all other indexes on the same table.
    Adriaan, Jul 20, 2009
    #4

Share This Page