Click here to Skip to main content
15,794,275 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi friends,

I want to index some columns in our database. Always, I have SQL with multiple columns in my where clause.

All of those columns are already indexed individually

I am thinking to drop these single column indexes and want to create composite index for these columns i.e. creating single index with several columns rather than several indexes each with one column.

Is this approach fine??

Thanks in advance
Updated 23-Jan-14 23:25pm
Ankur\m/ 24-Jan-14 4:43am    
"All of those columns are already indexed individually"
That is a very BAD design. A lot of indexes will reduce your query performance drastically. Be very wise in choosing an index. Check out execution plans of your poorly performing queries and analyze the correct indexes that are required.
About composite index, Google for "single column index vs composite column index", read the articles. It's very well discussed.

1 solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900