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

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

From: Jack <none_at_INVALIDmail.com>
Date: Mon, 15 Oct 2007 11:40:45 GMT
Message-ID: <1lIQi.97$UQ3.41@read3.inet.fi>

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 Received on Mon Oct 15 2007 - 06:40:45 CDT

Original text of this message

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