Never mind. New MySQL has "force index" option.
Thanks for your help Brent.
Anan T.
-Original Message-----
From: Tongprasith, Anan
Sent: Thursday, September 11, 2003 3:32 PM
To: Brent Baisley
Cc: [EMAIL PROTECTED]
Subject: RE: Query optimizer decision to use index depends on data?
idn't help.
Anan T.
-Original Message-
From: Brent Baisley [mailto:[EMAIL PROTECTED]
Sent: Thursday, September 11, 2003 2:18 PM
To: Tongprasith, Anan
Cc: [EMAIL PROTECTED]
Subject: Re: Query optimizer decision to use index depends on data?
I don't think so. Based on what I'v
I have two tables which are exactly the same but have different set of data on them. I
wrote a query and used EXPLAIN to see how it would run on each table.
It turn out that the same query will use index on one table but not the other. So I
delete all data on the "bad" table (the one that won't u
