Hi Ranganath,
If the column on which u perform ORDER BY has a index then
try using INDEX_ASC or INDEX_DESC optimizer hint in
your SELECT statement to avoid SORT.
hope this may help u.
Arul.
Ranganath K wrote:
Dear DBA Gurus,
I have some static data in two of my tables which
Dear DBA Gurus,
I have some static data in two of my tables which contains lakhs of
records. Is there any way I can sort the data in the two tables and put the
sorted data in the same table or some temporary table without creating a new
one. Why I want this is because when I write a