Stats with Intelligence

We all know that optimizer stats are vital for the optimizer to produce efficient plans. Histograms provide the optimizer with even more detailed knowledge on the data. But what about the SQL statements that transform the data in predicates, e.g. UPPER() or NVL()? The optimizer can’t make an intelligent decision in those cases. In Oracle 11g, using extended statistics you can actually create that knowledge for the optimizer. In this quick session you will learn what the extended stats are, how to collect them, how to use them (and check for their usage) and so on.

Read the full whitepaper

Premium Content: access is limited to Quest Corporate and Professional members.

Membership has its perks. Get unlimited access to the latest Oracle updates, event session replays, strategic content centers and special members-only programming, plus big discounts on conference registration, with a Quest Corporate or Professional membership. Quest is where you learn.

Stats with Intelligence