Explain indexed view?
Answer / 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 |
What is page in sql server?
What is the new security features added in sql server 2014? : sql server security
What are orphan records?
What stored by the model? : sql server database administration
how to get 25th row in any table in sqlserver can u tell me syntax
What is 'write-ahead log' in sql server 2000 ?
what is the purpose of creating view is sql server 2000
Ms sql server index?
Can we call a function that has out parameter in select statement
what are constraints? : Sql server database administration
What happens if you add a new index to large table?
What happens when converting big values to integers?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)