adaptive cursor sharing (Oracle)

227 Views Asked by At

If I set CURSOR_SHARING parameter to FORCE, and I issue a statement like

select * from customers where region = 'NORTH'

, then Adaptive cursor sharing happens only if there is a histogram in the REGION column, or it happens irrespective of whether there is a histogram on that column?

Does exist a relationship between cursor_sharing FORCE, Adaptive cursor sharing and histograms, in this case?

Thank you!

0

There are 0 best solutions below