What should you do if logical fragmentation of indexes is above 30 percent?
What will be an ideal response?
Rebuilding the index using the ALTER INDEX REBUILD statement drops and re-creates the index from scratch and should be considered for indexes where the logical fragmentation is above 30 percent. Rebuilding indexes can be done with the database online or offline. However, due to the system overhead involved, it is recommended that you undertake this activity during a maintenance window when the database is offline.
You might also like to view...
Because of its purpose, the ____ stage is the appropriate place for cybersecurity professionals to be involved in software assurance.
A. review B. specification C. design D. testing
A series of steps that describe what a computer must do to solve a problem or perform a task is a(n) ________.
a. system procedure b. algorithm c. function d. scenario
A(n) alarming event is an event with negative consequences that could threaten the organization's information assets or operations.__________________
Answer the following statement true (T) or false (F)
How does hardware asset management affect security?
A. Through assessing the purpose of hardware before it is acquired B. By reducing the likelihood of hardware-focused attacks C. By replacing hardware as it becomes three years old D. By preventing the use of cheap equipment through minimal cost vs. performance metrics