| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: Bind Variable Peeking Not Working Properly
Hi Daniel,
Are you sire that _optim_peek_user_binds = TRUE ?
If not, then Oracle will use the standart (5%, I beleive) cardinality
of T1.VAL coulmn and thus will favour the Index on S_LST_OF_VAL.VAL
(T1). Normally this table is pretty small (compared to the rest of
the SIEBEL tables).
By replacing :v5 with literal , oracle will check (hard-parse) the
statistics (and the histogramms, if any) and will notice that the
T1.VAL has skewed data distribution und will choose another table as
driving table for the resultset.
If you are running with oprimizer_mode=RULE then Oracle will favour
usage of index on T1.
Could you post the exec plans of the SQL query ?
Reagrds. MILEN Received on Thu Dec 08 2005 - 08:57:40 CST
 |
 |