Explain indexed view?
- 1 Answers
- 1077 Views
- I also Faced
- E-Mail Answers
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 |
Can group functions be mixed with non-group selection fields in ms sql server?
How many types of stored procedures are there in sql server?
Can we linked SharePoint to a SQL database?
0 Answers Sans Pareil IT Services,
How to create function without parameter in sql server?
What is cursors?
What is sparse columns of sql server 2008?
Explain what is dbcc?
How do you simulate a deadlock for testing purposes
why would you call update statistics? : Sql server database administration
Explain how many types of relationship?
How to use old values to define new values in update statements in ms sql server?
How to generate the Reports for the Database? I need an Example for it.Will we manually do this or else any script is there? Please let me know ASAP...
-
Oracle (3258) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3328)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
