Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: QUERY performanace

Re: QUERY performanace

From: Mladen Gogala <mgogala_at_allegientsystems.com>
Date: Thu, 23 Jun 2005 17:00:04 -0400
Message-ID: <42BB22D4.8050606@allegientsystems.com>


Seema Singh wrote:

>
> Can any one please take a look how to make faster or rewrite ?
> thx
>

BBO needs the same data as CBO plus Heineken, thats why it's called Beer Based Optimizer.
So, lemme know the table structure, indexes, constraints (PK, UK), data distribution, cardinality.
Also helpful would be version of the database, a copy of init.ora parameters, the values in
SYS.AUX_STATS$, sort_area_size, hash_area_size, platform, OS, version, hardware
and, do not forget this, a six pack of imported Heineken. BBO will then be able to crunch
the best plan, if in the mood.

-- 
Mladen Gogala
Oracle DBA
Ext. 121


--
http://www.freelists.org/webpage/oracle-l
Received on Thu Jun 23 2005 - 17:05:41 CDT

Original text of this message

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