| http://www.w3.org/ns/prov#value | - DBMS_STATS allows gathering of both or either statistics.Here is an example showing how the Optimizer can badly estimate cardinality on a non-partition key column in the absence of Table Level statistics.I have used the demo SH.SALES table which is Partitioned by TIME_ID. However, CUST_ID is a very relevant *dimension* column.SQL> desc sh.salesName
|
