关于索引一些验证

##删除带索引的表，再创建同名索引表

===============================================================================

相关视图

User_indexes user_ind_columns

 

1.create table test as select * from emp

2.create index ind_test_empno on test(empno);

3.select * from user_ind_columns where table_name='TEST'

4.drop table test;

5. select * from user_ind_columns where Index_name='IND_TEST_EMPNO'

no rows selected

结论，drop表，索引也被删除。Truncate,delete不对索引产生影响

---------------------------------------------------------------------------------------------------------------------------------

 

###改变表名字rename，查看索引。仍存在

===============================================================================

1.alter table test rename to scotttest;

2.Select table_name  from user_ind_columns where Index_name='IND_TEST_EMPNO'

TABLE_NAME

------------------

SCOTTTEST