How to analyze an index using dbms_stats:
BEGIN
SYS.DBMS_STATS.GATHER_INDEX_STATS (
OwnName => 'SCOTT'
,IndName => 'STATUS_IDX_1'
,Estimate_Percent => DBMS_STATS.AUTO_SAMPLE_SIZE
,Degree => DBMS_STATS.DEFAULT_DEGREE
,No_Invalidate => DBMS_STATS.AUTO_INVALIDATE);
END;
/
Official documentation here
No comments:
Post a Comment