What is the best way to create indexes? ...
I have a large table with approx 50 columns, 10+ Million Records
I have a few queries that I will be running on the table, for example
select col1, col2, col3 ....
inner join othertable on
where col1=something, col7=something
group by col1, col2
for a query like this, would you create a seperate index for each column you are calling in select portion?
or a seperate index for each column you are calling in the where clause
or a sepeate index for each column in the group by
or an index on multiple columns together (col1, col2, col3, col7)
Any feedback is appritiated.