Which statement would you use to correct this amount of external fragmentation?

You are a DBA tasked with maintaining an installation of SQL Server 2005.One of your jobs is to correct the index fragmentation levels for all user tables in your database. During your fragmentation investigation, you determine that an index has external fragmentation levels greater than 30 percent. Which statement would you use to correct this amount of external fragmentation?

You are a DBA tasked with maintaining an installation of SQL Server 2005.One of your jobs is to correct the index fragmentation levels for all user tables in your database. During your fragmentation investigation, you determine that an index has external fragmentation levels greater than 30 percent. Which statement would you use to correct this amount of external fragmentation?

A.
ALTER INDEXREBUIL

B.
ALTER INDEX…REORGANIZE

C.
ALTER INDEXDISABL

D.
ALTER INDEXSET STATISTICS_NORECOMPUTE = O



Leave a Reply 0

Your email address will not be published. Required fields are marked *