SQL Server Performance

clustered vs non clustered index

Discussion in 'SQL Server 2005 Performance Tuning for DBAs' started by sultani.khalid.af, Mar 16, 2008.

  1. sultani.khalid.af New Member

    hi friends
    on which column we have tu user clustered index and which column we have to use non clustered .it is mention on websites that we have to use clustered index on column used for aggregation and for filtering and searching purpose,and which have max number of unique value.
    shall i use non clustred index on forign key or clustered index?
    on which column i have to use non clustered index.
    thanks in advance.
  2. FrankKalis Moderator

    There is no generally valid answer to this question. You have to build up your own test scenario and experiement with your indices to see which combination gives you the "best" overall performance.
  3. satya Moderator

    I would say it depends based on those queries are fired directly or via a stored procedure or view, as suggested by Frank there is no defiitive answer and you will be best to check the execution plan for better understanding.

Share This Page