Wednesday, December 24, 2014

how to check last analyzed table in oracle

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


ANALYZE TABLE command

ANALYZE TABLE <TABLE_NAME> COMPUTE STATISTICS;

No comments:

Post a Comment