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 are the Prerequisites for Replication?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
When to use null data driven subscription?
How to select all columns of all rows from a table with a select statement in ms sql server?
tell me what is blocking and how would you troubleshoot it? : Sql server database administration
How to use subqueries in the from clause in ms sql server?
How to disable triggers using "disable trigger"?
Do you know what are different types of replication in sql server?
How to create an identity column?
How to scale out a federation by Sql statement?
What is difference between stored procedure and user defined function?
What are the features of Embedded SQL
Can We Use Data-grids For Our Report In Ssrs?
How do you migrate data from mssql server to azure?
What are “lost updates”?
