Interview Questions
1. Can we have indexes on Views?
Indexes can be defined on views. Indexed views are a method of storing the result set of the view in the database, thereby
reducing the overhead of dynamically building the result set. An indexed view also automatically reflects modifications made to
the data in the base tables after the index is created.
Submit an interview question
Submitted questions and answers are subject to review and editing, and may or may not be selected for posting, at the sole discretion of w3Sniff.
Get Started
Comments
Leave a Comment