Hello Arnon
Structure of table : strings C(10), counts(7)
Indexes: upper(strings), counts
Selects:
select * from test where upper(strings) > [SOMETHING]
select * from test where counts > 34555
That's all and it's partially optimized ;(
Have a happy day
Vladimir Shevchenko
> can you send me the structure, indexes and your SELECT statement
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer