Index question

[Vandy02]

If you have a table with let's say 30 columns and a million plus records:

Which is faster if I am performing a search?

Say on col1, col5, col23

Example 1

Separate indexes for each column

or

An index that includes all three columns?

Thanks,

vandy02

 

[carp]

It depends on the query.