What do you mean by Indexed Views>

What do you mean by Indexed Views>

Indexed views is bassically are persistent, It can be significantly improve application performance by eliminating the work that the query processor must perform to resolve the views. It is bassically a views but in some cases Its Unlike standard views,Which views like SQL Server resolves the data-access path dynamically at execution time, The new indexed views feature are there which is following here : > we can store views in the database as like as  we can store tables. 

Date:2014-01-09 00:00:00

Post Your Answers

User Email:

User Name:

Related SQL Subjective Links

SQL Subjective interview questions and answers for experienced and fresher