Performance issue with selection of data on a table

Created a clustered index on col1 and col2 but no improvement.

You filter on Col3; and index on Col1+2 won't help here, so your query will cause a full table scan and that can take some time. Additional, you perform a DISTINCT, so SQL Server must first order the data to get the distinct values.

---

Olaf Helper

[ Blog] [ Xing] [ MVP]