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 can I further reduce physical read for this query short of throwing memory at it?

Re: How can I further reduce physical read for this query short of throwing memory at it?

From: Jining Han <jining.han_at_gmail.com>
Date: 13 Feb 2006 21:03:10 -0800
Message-ID: <1139893390.255482.3730@g14g2000cwa.googlegroups.com>


Thanks a lot. I have tried the analytic function (partition over, etc) once, but didn't see lots of improvement. Also, the output looks a little weird in my testings, so I didn't pursue too much. Will fine-tune a little more since I am not getting anywhere right now.

Thanks
JH Received on Mon Feb 13 2006 - 23:03:10 CST

Original text of this message

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