I have a view on a table, and if if I have a statement like

select * from viewA
where fieldA = some_value

then it uses the index. As soon as I put order by clause in it

select * from viewA
where fieldA = some_value
order by fieldA

it reads the whole table. Anything I shouldn't be doing/ should be
doing to stop this?

Regards

Sandeep

Software Developer
CFL
sandeep@...
http://www.cfl.co.nz