Optimize query

[Yambu <hyambu@xxxxxxxxx>]

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