|
-
Example about tis post:
SQL> select index_name, last_analyzed from user_indexes where table_name = 'EMPS';
INDEX_NAME LAST_ANAL
------------------------------ ---------
EMPS_PK 16-AUG-02
IDX_DEP_ID_EMP 16-AUG-02
IDX_FIRST_NAME 16-AUG-02
IDX_JOB_ID_EMP 16-AUG-02
IDX_U_LAST_NAME 16-AUG-02
SQL> analyze table emps delete statistics;
SQL> select index_name, last_analyzed from user_indexes where table_name = 'EMPS';
INDEX_NAME LAST_ANAL
------------------------------ ---------
EMPS_PK
IDX_DEP_ID_EMP
IDX_FIRST_NAME
IDX_JOB_ID_EMP
IDX_U_LAST_NAME
SQL> analyze table emps compute statistics;
Table analyzed.
SQL> select index_name, last_analyzed from user_indexes where table_name = 'EMPS';
INDEX_NAME LAST_ANAL
------------------------------ ---------
EMPS_PK 16-AUG-02
IDX_DEP_ID_EMP 16-AUG-02
IDX_FIRST_NAME 16-AUG-02
IDX_JOB_ID_EMP 16-AUG-02
IDX_U_LAST_NAME 16-AUG-02
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|