How can you reduce fragmentation of an index without affecting the current transactions that are using the index?

The correct answer is D. Use the ALTER INDEX . . . DEALLOCATE UNUSED command. Use the deallocate_unused_clause to explicitly deallocate unused space at the end of the index and make the freed space available for other segments in the tablespace. If index is range- partitioned or hash-partitioned, then Oracle Database deallocates unused space from each…

Using Indexes and Materialized Views for Tuning

Question

Options

AUse the ANALYZE INDEX . . . command
BUse the ALTER INDEX . . . VALIDATE STRUCTURE command
CUs the ALTER INDEX . . . REBUILD ONLINE command
DUse the ALTER INDEX . . . DEALLOCATE UNUSED command

How the community answered

(34 responses)

A
6% (2)
B
3% (1)
C
9% (3)
D
82% (28)

Explanation

Use the deallocate_unused_clause to explicitly deallocate unused space at the end of the index and make the freed space available for other segments in the tablespace. If index is range- partitioned or hash-partitioned, then Oracle Database deallocates unused space from each index partition. If index is a local index on a composite-partitioned table, then Oracle Database deallocates unused space from each index subpartition. Reference: Oracle Database SQL Language Reference 11g, alter index

Topics

#index fragmentation#ALTER INDEX#REBUILD ONLINE#index maintenance

Community Discussion

No community discussion yet for this question.

Full 1Z0-117 Practice