On Tuesday 07 December 2004 02:51 pm, you wrote:
> mysql> explain select * from queryLog where date_format(queryTime,
> '%Y-%m-%d') =
> '2004-11-16';
> mysql> explain select * from queryLog where queryTime =
> date_format('2004-11-16'
> , '%Y-%m-%d');
> +--+--+---+---
mysql> explain select * from queryLog where date_format(queryTime,
'%Y-%m-%d') =
'2004-11-16';
+--+--+---+--+-+--+--+-+
| table| type | possible_keys | key | key_len | ref | rows |
Extra |
+--+--+---+--
On Tuesday 07 December 2004 02:03 pm, Victor Pendleton wrote:
> A function on the left hand side will nullify the use of an index.
Sides dont matter, a function on an index, no matter what side, will kill an
index.
Jeff
pgpsVFJcgS9kp.pgp
Description: PGP signature
Thanks, works like a charm.
Marc
Dathan Pattishall wrote:
Well 1st of all Date_format doesn't allow the use of a key.
Do this.
SELECT ..
WHERE DateLastRevised >= '2004-12-07' AND DateLastRevisted <
'2004-12-08';
-Original Message-
From: Marc Dumontier [mailto:[EMAIL PROTECTED]
Sent: Tue
--
From: Dathan Pattishall [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 07, 2004 12:05 PM
To: Marc Dumontier; [EMAIL PROTECTED]
Subject: RE: slow date query
Well 1st of all Date_format doesn't allow the use of a key.
Do this.
SELECT ..
WHERE DateLastRevised >= '2004-12-07' A
Well 1st of all Date_format doesn't allow the use of a key.
Do this.
SELECT ..
WHERE DateLastRevised >= '2004-12-07' AND DateLastRevisted <
'2004-12-08';
-Original Message-
From: Marc Dumontier [mailto:[EMAIL PROTECTED]
Sent: Tuesday, December 07, 2004 11:34 AM
To: [EMAIL PROTECTED
A function on the left hand side will nullify the use of an index.
Marc Dumontier wrote:
Hi,
I'd really appreciate any help in speeding up this type of query
SELECT BindId,RecordType from BrowseData WHERE
DATE_FORMAT(DateLastRevised,'%Y-%m-%d') = '2004-12-07';
On a MYISAM table of 122,000 rows, t