RE: Index on DATETIME column?

At 14:33 -0700 1/22/04, [EMAIL PROTECTED] wrote: Paul wrote: Is there such a thing as an index on the first 8 characters of a DATETIME column? No. Indexes on partial column values are available only for string types. Won't PACK_KEYS=1 help in a situation like this? Yes, but it's a different ques

RE: Index on DATETIME column?

Paul wrote: >> >>Is there such a thing as an index on the first 8 characters >>of a DATETIME column? >No. Indexes on partial column values are available only for string types. Won't PACK_KEYS=1 help in a situation like this? >From the Documentation: 6.5.3 CREATE TABLE Syntax If you don't use P

Re: Index on DATETIME column?

At 14:39 -0600 1/22/04, Eamon Daly wrote: Does it make sense to ever index a DATETIME column? We do a lot of reporting on a large (~10MM records) table where we only need to look at a particular day or two. My selects currently look like: WHERE entered >= 2004012400 AND entered <= 2004012423595

Index on DATETIME column?

Does it make sense to ever index a DATETIME column? We do a lot of reporting on a large (~10MM records) table where we only need to look at a particular day or two. My selects currently look like: WHERE entered >= 2004012400 AND entered <= 20040124235959 Is there such a thing as an index on t