DBA > Job Interview Questions > Microsoft SQL Server FAQs

Is it possible to build an index on a view

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

Is it possible to build an index on a view

Answer
Yes

Explanation
Yes, an index can be put on a view but the first index must be a unique clustered index.

(Continued on next question...)

Other Job Interview Questions