Hi All, I have a table with 35 columns,3+ million records,1 clustered index unique field. I developed a search application to search the records from this table. As of now the search is very slow. I tried to set the non-clustered index to a column (varchar(255) datatype). Then my search is gets fast for this column. And tried to next column, then its too fast. But my doubts is if i set non-clustered index to 20+ columns that what will happen my large table. The insert/update is happening twice a day in this table. What will be the performance of my table? If too much of non-clustered indexes is worst way then what is alternate one? Please tell me the answer as soon as possible. Awaiting for your valuable response. Thanks in advance Ganesh.