A question about indexes

[chemicaluser]

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

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

[r937]

@chemicaluser

What is the best way to create indexes? …

with the CREATE INDEX statement

@chemicaluser

for a query like this, would you create a seperate index for each column you are calling in select portion?

columns in the SELECT list do not require indexing

@chemicaluser

or a seperate index for each column you are calling in the where clause

a compound index if possible

any further advice dependent on actual tables and columns, not made up ones

[chemicaluser]

Thanks