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: there are still many cases where the rule-based optimizer will result in faster Oracle queries.

Re: there are still many cases where the rule-based optimizer will result in faster Oracle queries.

From: DA Morgan <damorgan_at_psoug.org>
Date: Tue, 16 Oct 2007 22:40:16 -0700
Message-ID: <1192599608.126418@bubbleator.drizzle.com>


Jack wrote:
> The very same query can be run 1175 times faster ;)
> Server 9.2.0.8
>
> real: 385635
> Statistics
> ----------------------------------------------------------
> 7344195 recursive calls
> 0 db block gets
> 26410200 consistent gets
> 0 physical reads
> 0 redo size
> 1497 bytes sent via SQL*Net to client
> 422 bytes received via SQL*Net from client
> 2 SQL*Net roundtrips to/from client
> 1 sorts (memory)
> 0 sorts (disk)
> 15 rows processed
>
> -------------------------------------------------------------
> After command: alter session set optimizer_goal=ALL_ROWS;
>
> real: 328
> Statistics
> ----------------------------------------------------------
> 108 recursive calls
> 0 db block gets
> 255 consistent gets
> 0 physical reads
> 0 redo size
> 1497 bytes sent via SQL*Net to client
> 422 bytes received via SQL*Net from client
> 2 SQL*Net roundtrips to/from client
> 1 sorts (memory)
> 0 sorts (disk)
> 15 rows processed
>
> Well, it was hole time using RBO, so not comparing to CBO

I hope you aren't confusing what you posted with information supporting your statement.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Wed Oct 17 2007 - 00:40:16 CDT

Original text of this message

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