Common GATHER_PLAN_STATISTIC confusion
Most people already know about the very cool GATHER_PLAN_STATISTICS hint. If not, you can see an example here But here’s
Tag: optimizer
SAMPLE costing
People often think when using the SAMPLE clause, that because they are only dealing with a subset of the data,
Optimizer curiosity in 12.1.0.2
For almost as long as I can remember, the optimizer has had a nifty little trick when you (in effect)
WHEN OTHERS … sometimes just not enough
We currently are working on a bug with Oracle Support with dbms_stats in 12.1.0.2. That may be the subject of
The challenge of optimization
With every release of Oracle, more and more power comes to the optimizer. Many of these are new features (such
Learning is not a spectator sport 