re: Index timestamp column

2002-12-05 Thread Egor Egorov
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<2002110100 and timestamp_col>2001110100 MF> I have index on timestamp column, but EXPLAIN says that not using any of MF> possi

Index timestamp column

2002-12-03 Thread Michal Franc
Its possible to use index on this query ?? select .. from .. where timestamp_col<2002110100 and timestamp_col>2001110100 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