Date |Sat, 4 Aug 2001 12:53:15 +0100
>From |"Tadej Guzej" <[EMAIL PROTECTED]>
Hello!
TG> What is better:
TG> CREATE INDEX ix1(field1, field2, field3);
TG> or
TG> CREATE INDEX ix1(field1), ix2(field2), ix3(field3);
TG> I have a large table of some 30,000,000 records and am wondering
TG> which in
ssage -
From: "Kahled Al Sahmaa" <[EMAIL PROTECTED]>
To: "Tadej Guzej" <[EMAIL PROTECTED]>
Sent: Saturday, August 04, 2001 12:25 PM
Subject: Re: perforamnce
> Hello...
>
> that related to your select statement which you are use, if you have
> field1, fiel
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 st
