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 |
Why is replication required on the sql server?
there is a trigger defined for insert operations on a table, in an oltp system. The trigger is written to instantiate a com object and pass the newly inserted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? : Sql server database administration
how do u find least salary in a table
Which system tables contain information on privileges granted and privileges obtained
What is the difference between for trigger and after trigger?
How to provide values to user defined function parameters?
what is a deadlock? : Sql server database administration
Hi..here i would like to know the Backup and Restore models?
How many index can be created for single table
4 Answers CarrizalSoft Technologies, Verizon,
What types of integrity are enforced by a foreign-key constraint
What is Inner Join?
What is GUID in sql server?
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)