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...
When you use the Search box in File Explorer, you must type the full search string prior to the program searching for your results
Indicate whether the statement is true or false
Suppose a Web site displayed the following flags:
a. Which flag(s) should Spanish speakers choose? Why?
b. What flag(s) should French speakers choose? Why?
c.What flag(s) should English speakers choose? Why?
d. What is the drawback of this approach?