hello all, I have a Query on MS-SQL server. Consider that i have a table 'Master' and a field 'Name' in the table. If i have a Queru where i use 'Name' in the where clause. There are around 100000 entries in the table & the data is in such a way that almost all entries are repeated around 1000 times. Will it be helpful if i index this column?? Thanks, Sajee Joseph.