:is there a way to use the date part of a datetime field that
:still uses the
:index on the datetime field? i've tried a few different things
:and it keeps
:saying in the explain it says that its a possible_key, but
:NULL for the key
I'm not sure if this ignores the
is there a way to use the date part of a datetime field that still uses the
index on the datetime field? i've tried a few different things and it keeps
saying in the explain it says that its a possible_key, but NULL for the key
--
mysql, sql, query, sql, sql, sql
.
- Original Message -
From: "Jan Namedyski" [EMAIL PROTECTED]
To: "mysql" [EMAIL PROTECTED]
Sent: Friday, February 16, 2001 21:09
Subject: deleting old records VS. index on datetime field (question about
optimization)
Hi,
I have a table
DAY : DATETIME
CAT_ID : INT
Rolf Hopkins wrote:
That all depends.
Do you need to keep the data for historical purposes?
I don't have to but I want ;-). it means that if speed difference would
be small I will.
Are your queries
running particularly slowly? Have you read the manual about how you can
optimize?
- Original Message -
From: "Jan Namedyski" [EMAIL PROTECTED]
To: "Rolf Hopkins" [EMAIL PROTECTED]
Cc: "mysql" [EMAIL PROTECTED]
Sent: Monday, February 19, 2001 10:02
Subject: Re: deleting old records VS. index on datetime field (question
about optim