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