Slide 58
Slide 58 text
SELECT
dbms_stats.create_extended_stats(null,'CUSTOMERS',
'(SUBSTR(CUST_STATE_PROVINCE,1,2))')
FROM dual;
DBMS_STATS.CREATE_EXTENDED_STATS(NULL,'CUSTOMERS','(SUBSTR(CUST_STATE_PROVINCE,1,2))')
___________________________________________________________
SYS_STUAJYEDA$07W8CRW1A18K4Q_G
Option 1 Create Extended Statistics
Solution: Tell Optimizer How Function Affects Column Values
Copyright © 2021, Oracle and/or its affiliates | All Rights Reserved.