Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: how to configure async io on windows 2003 server ntfs system

Re: how to configure async io on windows 2003 server ntfs system

From: lsllcm <lsllcm_at_gmail.com>
Date: 21 Nov 2005 05:00:58 -0800
Message-ID: <1132578058.183602.191240@g44g2000cwa.googlegroups.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US