Ok. This is a simplified versio of my previous question, because I have simplified the problem
I have two datetime fields in a table.
field1, field2
I have indexes on each of them.
I need all of the records for which field1>field2
So I index on field1>field2
SELE * from Mytable where field1>field2
gives no Rushmore optimization. Why not?
Erik Moore
Clientelligence