Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: how to configure async io on windows 2003 server ntfs system
Thanks for all your help.
I have another question to consult.
I have a table T1 with 900,000 rows, and join with 2-3 other tables, and retrieve out about 300,000 rows, then do "order by" operations. At last get the first 100 rows. It causes many direct path write and read events.
Do you have any ideas about how to optimize this kind of sql? Received on Mon Nov 21 2005 - 07:00:58 CST