Tag: Tuning

E4 2017 is almost one month away!

E4 2017 is almost one month away!I am looking forward to three days of interesting talks. Register here.

Oracle Extended Statistics

Introduced 11gR1 and based on virtual columns. Allows better selectivity.Condition has the be equality or IN-lists.We should use them when we have issues by an order of magnitude on the cardinality.Types: Column Group: Have to be from same table. Max 32 Expression: CBO does not know how an applied function impacts the cardinality of a ...

%d bloggers like this: