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
for a query like this, would you create a seperate index for each column you are calling in select portion?Code MySQL:
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.