Understanding the statistics

From: Shyamala <o_shyam_at_yahoo.com>
Date: 7 Apr 2003 06:41:14 -0700
Message-ID: <9e3c6eb3.0304070541.726c4827@posting.google.com>

Can anyone please help me out in understanding the statistics given below for the same query executed under COST-BASED and RULE-BASED optimizer modes :

Statistics captured when executed using Cost-based optimizer mode :

Statistics

        506  recursive calls
          4  db block gets
        134  consistent gets
          7  physical reads
          0  redo size
       2108  bytes sent via SQL*Net to client
        420  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
         10  sorts (memory)
          0  sorts (disk)
          4  rows processed

Statistics captured when executed using Rule-based optimizer mode :

Statistics

        475  recursive calls
          0  db block gets
      15293  consistent gets
        273  physical reads
          0  redo size
       1946  bytes sent via SQL*Net to client
        420  bytes received via SQL*Net from client
          2  SQL*Net roundtrips to/from client
          4  sorts (memory)
          0  sorts (disk)
          4  rows processed

Which optimizer mode is better for the query under consideration, given the above listed statistics ? Please revert with answers. Received on Mon Apr 07 2003 - 08:41:14 CDT