27. In which scenarios would you rebuild an index? (Choose all that a
pply.)
A. when you need to disable the index usage
B. when you need to change storage options
C. when you need to enable index monitoring
D. when you need to move the index to another tablespace
Answer: B, D
哪种情况下需要你需要重建索引
a、当你需要改变存储选项
b、当你需要把索引移动到其它的表空间
index monitoring 是监控一个索引是否被使用。
扩展阅读
http://oracle.chinaitlab.com/optimize/12392.html
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/11312660/viewspace-717684/
,如需转载,请注明出处,否则将追究法律责任。