Seo Forum

Web Administration => Databases => Topic started by: beingchinmay on 10-13-2016, 05:30:37

Title: The ANALYZE_OBJECT procedure
Post by: beingchinmay on 10-13-2016, 05:30:37
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