Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: QUERY performanace
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-lReceived on Thu Jun 23 2005 - 17:05:41 CDT