What is an indexed view?
Are you preparing for IT certification? With practice questions, study notes, interactive quizzes, tips and technical articles, uCertify PrepKits ensure that you get a solid grasp of core technical concepts to ace your certification exam in first attempt.
What is an indexed view?
Rating:
An indexed view is a view in which data from a single or multiple tables are stored in the form of result set obtained by a query. The performance of a standard view can be improved by creating a unique clustered index on a column. This index stores the result set of the query separately as an object. This helps in the improvement of the query processing as the query optimizer scans the data in the indexed view rather than the tables used in the query to create the view. In the case of standard view, only view definition is stored but the result set is not stored.
Rating:
Was this information helpful?
Other articles
- What is the setupadmin fixed server role?
- What is the SERIALIZABLE isolation level?
- What is an E-R diagram?
- What is Services Console?
- What is SQL Trace?