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

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