overall the run which used by far the most logical I/Os. I thought logica= l I/Os were the most important resource though? = > = > From: Tanel P=F5der <tanel.poder.003@xxxxxxx> > Date: 2004/04/14 Wed PM 06:12:00 EDT > To: <oracle-l@xxxxxxxxxxxxx> > Subject: Re: deciding which query plan to use > = > > However, when I use runstats_pkg, overall resource usage is about 23= 4,000 > higher with the full tablescan an the 170,000 logical I/Os. > = > So which resources usage was higher then? > = > Tanel. > = > = > ---------------------------------------------------------------- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > ---------------------------------------------------------------- > To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx > put 'unsubscribe' in the subject line. > -- > Archives are at //www.freelists.org/archives/oracle-l/ > FAQ is at //www.freelists.org/help/fom-serve/cache/1.html > ----------------------------------------------------------------- > = ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------