Optimize query

[Yambu]

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