Community

12.2.0.1 And Later Support (Limited) Extended Stats On Virtual columns / Column Groups of Expressions

(Randolf Geist) I do have a demo as part of my optimizer related workshops that shows the restriction / limitation of DBMS_STATS not supporting extended statistics on virtual columns / group of expressions, so for example the combination of both expressions and column groups, like ((TRUNC(COL1)), (T




Tags: