What does optimizer do when it encounters a bind variable? Does it have
a method of "peeking", like some other databases or it has some
predefined values and percentages? Where are those defined, if they
exist, can someone point the particular part of the code? Are those
values configurable or are they hard-coded?
--
Mladen Gogala
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com
The Leader in Integrated Media Intelligence Solutions