Well, sometimes I use all of the fields in the SELECT statement,
sometimes just one.
How about if I create both indexes?
How would it affect the performance? I don't care about update time as i
insert or update records at night only once a day.
Thanks for the answer
----- Original Message -----
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, field2 and field3 in the where section then the first index:
>
> CREATE INDEX ix1(field1, field2, field3);
>
> will be better for you, but if you are using select statements which has
been
> used one of that fields alon then the secound choice will be better.
>
>
>
> ----- Original Message -----
> Subject: perforamnce
> Sent: Sat, 4 Aug 2001 12:53:15 +0100
> From: "Tadej Guzej" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> >
> >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
> >
>
>
> Sincerely,
> Khaled Al-Sham'aa
> http://www.mazadmaktoob.com
>
> _________________________________________________________
> Send Your favorite Arabic Card from Maktoob Cards,
http://cards.maktoob.com
>
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
