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
can an automatic recovery be initiated by a user? : Sql server administration
How self join is different from outer join?
How do I get to sql server configuration manager?
Comment,Datatypes are unlimited
Can you pass expressions to stored procedure parameters?
How many triggers you can have on a table?
What is sub-query in sql server?
What is encryption key?
What is difference between join and natural join?
How to transfer an existing table from one schema to another schema in ms sql server?
Mention the different authentication modes in sql server.
What is replace and stuff function in sql server?
Define clusters?
How to write a query with an inner join in ms sql server?
Can we call future method from queueable?