Decide when to create Clustered & when non clustered Index

• JDBA-eqms

  Mr or Mrs. 500

  Points: 529

  More actions

  March 3, 2011 at 2:52 am

  #247554

  hi,

  How & on what parameters we decide, Which index would be created on a column (Clustered or Non Clustered.)

• Bhuvnesh

  SSC Guru

  Points: 59351

  More actions

  March 3, 2011 at 4:26 am

  #1293912

  JDBA-eqms (3/3/2011)

  ---

  hi,

  How & on what parameters we decide, Which index would be created on a column (Clustered or Non Clustered.)

  here is the link which can help you http://sqlinthewild.co.za/index.php/category/sql-server/indexes/

  -------Bhuvnesh----------
  I work only to learn Sql Server...though my company pays me for getting their stuff done;-)