Index analyzed. no rows selected
| 转到底部 |
In this Document
Applies to:Oracle Database - Enterprise Edition - Version 9.2.0.1 to 11.2.0.3 [Release 9.2 to 11.2]Information in this document applies to any platform. ***Checked for relevance on 27-Jan-2012*** SymptomsA sql command 'analyze index validate structure online' does not populate index_stats or index_histogram while without the online clause it does populate the views. SQL> create table test (id number, text varchar2(9)); SQL> create index test_indx on test(id); SQL> insert into test values (1, 'A'); SQL> insert into test values (2, 'B'); SQL> insert into test values (3, 'C'); SQL> commit; SQL> analyze index test_indx validate structure online; Index analyzed. SQL> select * from index_stats; no rows selected SQL> select * from index_histogram; no rows selected SQL> analyze index test_indx validate structure ; Index analyzed. SQL> select * from index_stats; HEIGHT ---------- ---------- ------------------------------ PARTITION_NAME ------------------------------ ---------- ---------- ----------- ---------- ---------- ---------- ----------- ---------- ----------- --------------- DISTINCT_KEYS MOST_REPEATED_KEY BTREE_SPACE USED_SPACE ------------- ----------------- ----------- ---------- ---------- ------------ BLKS_GETS_PER_ACCESS PRE_ROWS -------------------- ---------- ------------ -------------- ---------------- 1 SQL> select * from index_histogram; REPEAT_COUNT KEYS_WITH_REPEAT_COUNT ------------ ---------------------- 16 rows selected. SQL> |