This content has been marked as final. Show 4 replies
Well, binds and histograms don’t mix well, particularly in 10g. This link contains wealth of information about this behavior:
Out of the two options, I would choose option 1. Option 2 might be cumbersome to implement in production.
If you can change the code, you might consider using “pseudo-hints” to have a different execution plan for a wide-range between clause and a narrow-range between clause.