Michal,
Tuesday, December 03, 2002, 7:19:08 PM, you wrote:
MF> Its possible to use index on this query ??
MF> select ..
MF> from ..
MF> where timestamp_col<20021101000000 and timestamp_col>20011101000000
MF> I have index on timestamp column, but EXPLAIN says that not using any of
MF> possible keys.
MF> I also try using BETWEEN function instead of two compares, but same result.
Yes, it's possible:
mysql> explain select id from mybox where mydate < 20020610010101 and mydate >
20020101010101\G
*************************** 1. row ***************************
table: mybox
type: range
possible_keys: mydate
key: mydate
key_len: 4
ref: NULL
rows: 20727
Extra: where used
1 row in set (0.01 sec)
What is the output of explain? What is the table structure? What
indexes are in the table? How many rows in the table? What is the
version of MySQL server?
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Egor Egorov
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
<___/ www.mysql.com
---------------------------------------------------------------------
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 <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
