The ANALYZE_OBJECT procedure

Started by beingchinmay, 10-13-2016, 05:30:37

Previous topic - Next topic

beingchinmayTopic starter

A call to ANALYZE_OBJECT lets you programmatically compute statistics for the specified object. The specification is:

QuotePROCEDURE DBMS_DDL.ANALYZE_OBJECT
(type VARCHAR2,
schema VARCHAR2,
name VARCHAR2,
method VARCHAR2,
estimate_rows NUMBER DEFAULT NULL,
estimate_percent NUMBER DEFAULT NULL);
C.3