Question

Which of the following query can enable all indexes on Employee table?

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

(b) DBCC DBREINDEX (“EMP”, ” “);

(c) DBCC DBREINDEX (“HumanResources.Employee”, “ALL”);

(d) None of the mentioned

I got this question by my college professor while I was bunking the class.

The query is from Indexing Strategies in section Performance Tuning and Optimization of SQL Server

Answer 1

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

To elaborate: DBCC DBREINDEX can enable all indexes for a table in the specified database.