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
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?
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
You can press Esc to turn off Format Painter
Indicate whether the statement is true or false
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