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
    AstoneJ, Aug 24, 2007
    #2

  2. Luis Martin Moderator

    Check:
    http://www.sql-server-performance.com/articles/per/clustered_indexes_p1.aspx
    Luis Martin, Aug 24, 2007
    #3

  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.
    FrankKalis, Aug 27, 2007
    #4

  4. satya Moderator

    satya, Aug 27, 2007
    #5

Share This Page