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 components of sql server service broker?
What is database replication? What are the different types of replication you can set up in sql server?
What are the requirements to use odbc connections in php scripts?
What’s the use of custom fields in report?
What are the ways available in sql server to execute sql statements?
What do you know about system database? : SQL Server Architecture
What is data source in connection string?
How to sort the query output with order by clauses in ms sql server?
How to create a user to access a database in ms sql server using "create user" statements?
How do I run a trace in sql server?
in the physical file layout, where should the transaction log be stored in relation to the data file?
List all types of constraints in sql server?
how we use window authentication connection with sql server.?
What is the recursive stored procedure in sql server?
What is collation sensitivity?
