How to use Cluster Index and Non-Cluster Index in proper way in MS SQL 2005

• Parmesh Althi

  Old Hand

  Points: 315

  More actions

  July 2, 2008 at 8:17 am

  #188901

  Hi All,

  Kindly Provide any walktroughs about using of Cluster and Non-Cluster Idexes in Proper way. Because we have created indexes on the columns in the database though the performance is not boosted

  Thanks in Adv.

• Steve Jones - SSC Editor

  SSC Guru

  Points: 736504

  More actions

  July 2, 2008 at 9:45 am

  #837315

  This is a very open ended question.

  you might start here: http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/indexcreationguidelines/1389/

  Clustered indexes (only 1 per table) are good for range queries.

  Nonclustered are good for seeks to specific rows.

  You generally want to index on those fields used in WHERE clauses.

• bluepaperbags

  SSCommitted

  Points: 1738

  More actions

  July 2, 2008 at 12:11 pm

  #837384

  U gotta use profiler n performance monitor to test the performance.

  http://www.esri.com/news/arcuser/0102/files/SQLProfiler2.pdf

  http://www.perfassoc.com/jsc/pdf/papers/nt_performance_paper_97.pdf