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
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