Interested to Buy Any Domain ? << Click Here >> for more details...
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
Why I can not enter 0.001 second in date and time literals in ms sql server?
explain different types of constraints? : Sql server database administration
List some of the rules that apply to creating and using a ‘view’
Where are SQL server users names and passwords are stored in sql server?
What is difference between rollback immediate and with no_wait during alter database?
What are the components of dbms?
Tell me what is difference between clustered and non clustered index?
Define msdb database?
can an automatic recovery be initiated by a user? : Sql server administration
sql database suspect We have a sql database that is showing as suspect. How can we recover?
Explain user defined functions?
Where does the copy job runs in the log shipping primary or secondary? : sql server database administration
How can I create a new template for import ? : sql server management studio
How to backup SQL Server Reporting Services ?
query processing
