SELECT table_name,num_rows,last_analyzed FROM user_TABLES
TABLE_NAME NUM_ROWS LAST_ANALYZED
------------------------------ ---------- -------------
MTHPASSKBS 611 15-SEP-14
SH_NO 6319 19-SEP-14
D_R_D_SEP 280 11-OCT-14
REQ_TRAINEE_T 3152 20-DEC-14
REQUISITION_T 1251 20-DEC-14
EVALUATION_T 1349 20-DEC-14
EVALUATION_WEEK_T 296 20-DEC-14
REGISTRATION_T 1634 20-DEC-14
OFFICEORDER_T 2069 20-DEC-14
MASTER 710 20-DEC-14
10 rows selected
TABLE_NAME NUM_ROWS LAST_ANALYZED
------------------------------ ---------- -------------
MTHPASSKBS 611 15-SEP-14
SH_NO 6319 19-SEP-14
D_R_D_SEP 280 11-OCT-14
REQ_TRAINEE_T 3152 20-DEC-14
REQUISITION_T 1251 20-DEC-14
EVALUATION_T 1349 20-DEC-14
EVALUATION_WEEK_T 296 20-DEC-14
REGISTRATION_T 1634 20-DEC-14
OFFICEORDER_T 2069 20-DEC-14
MASTER 710 20-DEC-14
10 rows selected
ANALYZE TABLE command
ANALYZE TABLE <TABLE_NAME> COMPUTE STATISTICS;
No comments:
Post a Comment