SQL Server Performance

Clustered Index Data

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by AstoneJ, Aug 24, 2007.

  1. AstoneJ New Member

    Is there a good article out there on the pro's and con's of clustered indexes, they are obviously the best method of searching, do they take up a lot of room and take a longer time to create? is it more important to put it on a column used most for (like a date that is always used when querying a table) or an int that is sometimes used? those sorts of information/analysis
  2. Luis Martin Moderator

    Check:
    http://www.sql-server-performance.com/articles/per/clustered_indexes_p1.aspx
  3. FrankKalis Moderator

    You should consider subscribing to the blogs of Kimberly Tripp and Greg Linwood. These are kind of opposite opinions on the use of clustered indices and you should read carefully through them and make up your own mind, not blindly follow either this or that side.
  4. satya Moderator

Share This Page