Post reply

Clustered or NonClustered Index?

  • March 12, 2009 at 1:49 am

    #207293

    Hi,

    A clustered index is created on primary key by default, however, if I have a query which requires a clustered index for better performance, shall I add subject columns to the PK clustered index or I shall change clustered index on primary key to non clustered and create another clustered index for that query?

  • March 12, 2009 at 3:12 am

    #958137

    That depends on your query .Either you can create a composite key using two columns or a clustered index on that particular column.

    If your queries mainly use that particular column other than present primary key then better create clustered index on that column which uses more frequently.:D

  • March 12, 2009 at 5:51 am

    #958220

    You got it right ratheesh.keep it up :hehe:

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply