Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> there are still many cases where the rule-based optimizer will result in faster Oracle queries.
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 processedAfter 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 Received on Mon Oct 15 2007 - 06:40:45 CDT