> 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 ;( If DELETED is set ON, then that's true. Add an index on DELETED() and check the optimization status again.