Your manager has asked you to check the index stats for a particular table called Address. You have executed the following query (see below) and it reported that the avg_fragmentation_in_percent is 15%. What should you do?
SELECT * FROM sys.dm_db_index_physical_stats (DB_ID(N'Test'), OBJECT_ID(N'Address'), NULL, NULL , 'DETAILED');

 Posted by Bandi on 7/30/2014 | Category: Sql Server Interview questions | Views: 532 | Points: 40
Select from following answers:
  1. Run ALTER INDEX REBUILD WITH (ONLINE = ON)
  2. Run ALTER INDEX REORGANIZE
  3. Rebuild the table
  4. Nothing, the index fragmentation is at a safe level
  5. All Above

Show Correct Answer


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response