If i use below query
Select * from ADJ_ADJSTMNT fetch first 21 rows only with ur;
works fine
But if i use the same query with order by clause like below
Select * from ADJ_ADJSTMNT
order by adj_ca_id
fetch first 21 rows only with ur;
It's very much time consumming.
Pls note that ADJ_ca_id has an primary index,It's must for me to select all records from ADJ rather then some specific fields...