Post reply

Which type of index to use??

  • September 3, 2011 at 4:35 am

    #150471

    Hi All,

    I need one help in deciding index to be used in my table. I have a table with around 200,000 records and there is a column 'FileName'(datatype: nvarchar(50)).As of now there are no indexes defined on this table.I use the column 'FileName' in filtering the records as well as deleting the records at later stage in my SSIS application.

    The values in the 'FileName' column are not unique i.e in the table there would be 100 records with one file name and another 100 records with another file name.

    I need to define an index for this table on 'FileName' column.I'm not sure whether to go for a Clustered index or non clustered index or not.

    Please advice which one to go for and why.

    Thanks,

    Sam

  • September 3, 2011 at 8:59 am

    #1376773

    Please don't cross post. It just wastes peoples time and fragments replies.

    No replies to this thread please. Direct replies to: http://qa.sqlservercentral.com/Forums/Topic1169597-361-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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