[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
u [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
-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 al
kmlau wrote:
> I encountered a problem about indexing. I want to add index on timerecord
> field in table gw (shown as below) to speed up query relating with time.
> However, I use explain command (explain select * from gw where timerecord =
> '010902') to analyze the performace. As a resul
hi,
I encountered a problem about indexing. I want to add index on timerecord
field in table gw (shown as below) to speed up query relating with time.
However, I use explain command (explain select * from gw where timerecord =
'010902') to analyze the performace. As a result, it seems the q
