Oracle 11G OCP 1Z0-052 03

（3）While observing the index statistics, you find that an index is highly fragmented, thereby resulting in poor database performance.

Which option would you use to reduce fragmentation without affecting the users who are currently using the index?

A. Validate the index structure using the ANALYZE...INDEX command.

B. Rebuild the index using the ALTER INDEX..REBUILD ONLINE command.

C. Change the block space utilization parameters using the ALTER INDEX command.

答案：（B）

來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/17013648/viewspace-1175060/，如需轉載，請註明出處，否則將追究法律責任。