19 messages in com.mysql.lists.mysqlRe: Optimizing date queries
FromSent OnAttachments
Emil Rasmussen04 Dec 2001 05:48 
Gordan Bobic04 Dec 2001 06:17 
Emil Rasmussen04 Dec 2001 06:58 
Gordan Bobic04 Dec 2001 10:22 
Gordan Bobic04 Dec 2001 10:32 
Emil Rasmussen05 Dec 2001 01:30 
alec...@quantel.com05 Dec 2001 02:20 
Emil Rasmussen05 Dec 2001 02:48 
Gordan Bobic05 Dec 2001 03:06 
Jason Wong05 Dec 2001 03:54 
Emil Rasmussen05 Dec 2001 04:31 
Emil Rasmussen05 Dec 2001 04:33 
Emil Rasmussen05 Dec 2001 04:50 
Jason Wong05 Dec 2001 05:05 
Emil Rasmussen05 Dec 2001 05:23 
alec...@quantel.com05 Dec 2001 05:44 
Marjolein Katsma05 Dec 2001 06:00 
Emil Rasmussen05 Dec 2001 06:30 
Emil Rasmussen05 Dec 2001 07:46 
Subject:Re: Optimizing date queries
From:Marjolein Katsma (webm@javawoman.com)
Date:12/05/2001 06:00:31 AM
List:com.mysql.lists.mysql

Emil,

You might try to split the time stamp into separate date and time columns. That
would allow you to cretae and use an index on time alone.

At 14:24 2001-12-05 +0100, Emil Rasmussen wrote:

WHERE myfield LIKE '________HH____'

However this query will probably not use your index either :)

Yeah, it works, but still, it does not use my index as long as it is working with strings. But neat trick anyway.

Thanks

Regards Emil

-- Emil Rasmussen http://noget.net

--------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive)

To request this thread, e-mail <mysq@lists.mysql.com> To unsubscribe, e-mail
<mysql-unsubscribe-webmaster=java@lists.mysql.com> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php

Marjolein Katsma webm@javawoman.com Java Woman - http://javawoman.com/