Question

Which of the following query enables the IX_Employee_OrganizationLevel_OrganizationNode index on the Employee table?

(a) DBCC DBREINDEX (“Employee”, IX_Employee_OrganizationLevel_OrganizationNode);

(b) DBCC REINDEX (“Employee”, IX_Employee_OrganizationLevel_OrganizationNode);

(c) DBCC DBINDEX (“Employee”, IX_Employee_OrganizationLevel_OrganizationNode);

(d) All of the mentioned

This question was posed to me in examination.

This is a very interesting question from Indexing Strategies topic in chapter Performance Tuning and Optimization of SQL Server

Answer 1

The correct choice is (a) DBCC DBREINDEX (“Employee”, IX_Employee_OrganizationLevel_OrganizationNode);

The best I can explain: DBCC DBREINDEX rebuilds one or more indexes for a table in the specified database.