Hello.
Add composite index (tValidFrom, tValidTo) and use constant or variable
instead of now(). Force MySQL to use this composite index.
Mattias HÃ¥kansson wrote:
> Hello People,
>
> I have some indexing problem on using the fieldtype 'date' as
> restriction in a query.
> I use MySQL
Hello People,
I have some indexing problem on using the fieldtype 'date' as
restriction in a query.
I use MySQL Server version: 4.0.20
The table I have consists of roughly over 200.000 rows about 37 fields and
it looks sort of like this:
mysql> desc the_table;
++--