Why Skew Matters

The Oracle optimizer relies on statistics to estimate how many rows a query will return. If it thinks all values are equally likely (uniform distribution), it may pick a bad plan:

• Use a full table scan instead of an index.

• Choose the wrong join method.

• Under- or over-allocate memory.