| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> DBMS_UTILITY ?
dbms_utility.analyze_schema ( '&OWNER',
'ESTIMATE', NULL, 5 ) ;
1) wHAT DOES THAT PROCEDURE DO? I could not find it in the
documentation. Does it analyze all tables in a given user.?? I mean Does it
do the below?
2) Then what is NULL and 5 is used for ?
Analyze table scott.xxx estimate statistics; // repeating
for all tables of user.
Received on Tue Mar 13 2001 - 03:16:43 CST
 |
 |