In older versions of Oracle, Column histograms and bind variables were mutually exclusive. To use the histogram, the optimizer needed to know the value of the variables at parse time, but bind variable 'HID" the value until execute time.
BIND VARIABLE PEEKING AND ADAPTIVE CURSOR SHARINGposted Jan 28, 2012, 10:20 AM by Sachchida Ojha [ updated Jan 28, 2012, 10:23 AM ] |