Hi,
I am having a table with 12 million records.
My query will be always having 2 conditions in WHERE clause.
SELECT * FROM TABLE WHERE c1='some integer' and c2 in (some values)
In this case which index will be appropriate.?
a)Creating separate indexes on c1 and c2
b)creating a compound index on (c1,c2)
What are the things i need to consider before creating index in this case>
Thanks