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: