Hi,

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

Code MySQL:
select col1, col2, col3 ....
from mytable
inner join othertable on
mytable.field=othertable.field
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.
Thanks