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