Answer Posted / anindya basu
An indexed view is a part of the database and is saved to the disc. Creating an index on a view turns the latter into a permanent database object since indexes are so. Consequently every time the view is invoked, it gets loaded from the disc and need not be recreated.
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is a non-clustered index?
What is the minimum recommended amount of ram for sql server 2012 enterprise?
what do you understand by change data capture?
How to transfer an existing table from one schema to another schema in ms sql server?
What are the different normalization forms?
Explain different types of Normalization.
What is "scheduled jobs" or "scheduled tasks"?
How will you add a dimension to cube? : sql server analysis services, ssas
what are the different stages of Report Processing?
What extended events?
Define primary key?
Can you roll back the ddl statement in a trigger?
How to count duplicated values in a column in ms sql server?
In case you have filters in your report, when filters will be applied in cached report instance?
What is a group function explain with an example?