Re: optimizing/indexing date column

[Chris T]

Thanks for the advice. I ran explain on the select statement :

mysql> EXPLAIN
-> SELECT *
-> FROM history
-> WHERE pid = '003'
-> AND arrival >= '2008-02-04'
-> AND departure <= '2008-02-04'
-> ;
+----+-------------+---------------------+------+---------------------------+------+---------+------+----------+-------------+
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
+----+-------------+---------------------+------+---------------------------+------+---------+------+----------+-------------+
| 1 | SIMPLE | history | ALL | arrival_idx,departure_idx | NULL | NULL | NULL | 42070352 | Using where |
+----+-------------+---------------------+------+---------------------------+------+---------+------+----------+-------------+
1 row in set (0.00 sec)


I'll definitely read that page though, thanks for the link!



Edited 1 time(s). Last edit at 11/15/2011 10:32PM by Chris T.