Thursday, 8 September 2022

Gather Table Stats in Oracle Database 19c

BEGIN
DBMS_STATS.GATHER_TABLE_STATS (ownname => 'XCSCHEM',
tabname => 'AP_ADDR_ORG',
cascade => true,
method_opt=>'for all indexed columns size 1',
granularity => 'ALL',
estimate_percent =>dbms_stats.auto_sample_size,
degree => 4);
END;
/

No comments:

Post a Comment