Hi
How would you optimize a query with greater than in where clause eg
select * from table1 where id > 1000
and there is an index on id column
regards