[EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: Re: FW: pls help for index problem
Well, how many records are in the table? How many would be returned by the
query you present?
Is the SQL you show the FULL sql?
What is the output of the EXPLAIN SELECT
What about "SHOW INDEX FROM TAB
Well, how many records are in the table? How many would be returned by the
query you present?
Is the SQL you show the FULL sql?
What is the output of the EXPLAIN SELECT
What about "SHOW INDEX FROM TABLE gw".
b.
kmlau wrote:
> -Original Message-
> From: kmlau [mailto:[EMAIL PROT
-Original Message-
From: kmlau [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, October 24, 2001 9:42 AM
To: 'Bill Adams'
Subject: RE: pls help for index problem
Thanks yr promptly reply !!
It seems no any change(improvement) by running explain again after erase
quotes. I also ran the