perforamnce

[Tadej Guzej]

What is better:

CREATE INDEX ix1(field1, field2, field3);

or

CREATE INDEX ix1(field1), ix2(field2), ix3(field3);

I have a large table of some 30,000,000 records and am wondering
which indexing gives better performance and why.


How do I optimize search on this table - I'm using lots of OR statements in WHERE 
clause.

Thanks in advance,

Tadej