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
How to end a stored procedure properly in ms sql server?
Explain indexed views?
What is a result set object returned by mssql_query()?
What is the template in sql?
Which tools are available to manage SQL Azure databases and servers?
What is the difference between char, varchar and nvarchar?
Differentiate between mongodb vs. Sql server?
What is checkpoint in sql server?
optimization techinques
If you lose rights to your sql server instance what are the options to connect to sql server instance? : sql server security
New concepts of sql server 2005 use in your project.
Can You Use Data Mining Models In Ssrs?
How to turn off warning messages during php execution?
Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?
What is view in sql?
