List:General Discussion« Previous MessageNext Message »
From:Michal Franc Date:December 3 2002 5:19pm
Subject:Index timestamp column
View as plain text  
Its possible to use index on this query ??

select .. 
from .. 
where   timestamp_col<20021101000000  and  timestamp_col>20011101000000

I have index on timestamp column, but EXPLAIN says that not using any of
possible keys.
I also try using BETWEEN function instead of two compares, but same result.
Index timestamp columnMichal Franc3 Dec
  • re: Index timestamp columnEgor Egorov5 Dec