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
What are the new features are introduced in sql server 2012 reporting services?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
How do you delete a trigger?
How to replace the Query Result 'Null Value' with a text ?
How to drop existing indexes in ms sql server?
What happens if null values are involved in datetime operations?
What are alternate keys?
What is subquery? Explain the properties of a subquery?
What are different types of raid configurations? : SQL Server Architecture
What are points to remember while using the fillfactor argument?
What command would you use to add a column to a table in sql server?
How will you know when statistics on a table are obsolete?
What are ddl triggers and types of ddl trigger?
In how many ways you can invoke ssrs reports?
You want to implement the one-to-many relationship while designing tables. How would you do it?
