Hi All, I have a master table which is huge and I am trying to select all rows and spool a corresponding file. The query uses a order by clause. The primary key is used in it. I tried using oracle hints like index,all rows, rowid etc..but unfortunately there is no performance difference. Can you guys help on this?