Which of the following is a suggested threshold for performing index fragmentation maintenance?

A. delete and recreate if the fragmentation is more than 10 percent
B. update statistics for fragmentation more than 30 percent
C. rebuild if the fragmentation is less than 5 percent
D. reorganize if the logical fragmentation is between 5 and 30 percent


Answer: D

Computer Science & Information Technology

You might also like to view...

Survey relevant literature and identify various routing strategies in small-world networks. What are the differences between decentralized and lookahead routing algorithms?

What will be an ideal response?

Computer Science & Information Technology

A Facebook ________ is like a(n) virtual group for fans of a given musician, actor, entertainer, writer, celebrity, or company

Fill in the blank(s) with correct word

Computer Science & Information Technology

You can press Esc to turn off Format Painter

Indicate whether the statement is true or false

Computer Science & Information Technology

A copy of Excel can be personalized by adding a(n) ________ in the Excel Options dialog box

A) property B) tag C) user name D) account

Computer Science & Information Technology