The ANALYZE_OBJECT procedure

Author Topic: The ANALYZE_OBJECT procedure  (Read 200 times)

Offline beingchinmayTopic starter

  • Trade Count: (0)
  • Semi-Newbie
  • *
  • Thank You 0
  • Posts: 43
  • Karma: 0
  • Gender: Male
  • I am Chinmay
    • Fat Cutter
The ANALYZE_OBJECT procedure
« on: 10-13-2016, 05:30:37 »
A call to ANALYZE_OBJECT lets you programmatically compute statistics for the specified object. The specification is:

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


 

Related Topics

  Subject / Started by Replies Last post
1 Replies
2141 Views
Last post 08-24-2011, 09:29:23
by takeshiro
4 Replies
7868 Views
Last post 03-10-2016, 02:31:44
by Ghazala
0 Replies
375 Views
Last post 07-21-2015, 04:27:21
by Zinavocouk
0 Replies
269 Views
Last post 10-12-2016, 03:11:56
by beingchinmay