Which command takes corrective action on a fragmented index?

A. ALTER INDEX REORGANIZE
B. UPDATE INDEX REBUILD
C. REINDEX DATABASE
D. UPDATE STATISTICS

Answer: A

Computer Science & Information Technology

You might also like to view...

The methodology used to secure an organization can be divided into the following five steps: assessment, policy development, implementation, training, and auditing

Indicate whether the statement is true or false.

Computer Science & Information Technology

The number of _____ needed to describe the characteristics of an object depends on the business requirements of the information system and its users.?

A. ?attributes B. ?packets C. ?indices D. ?keys

Computer Science & Information Technology