What is indexed views?
plz explain with example?
- 2 Answers
- 3927 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mohan
A view with Clustred Index is known as Indexed view.
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / raman
A view with unique Clustred Index is known as Indexed view and its also known as Materialize view
| Is This Answer Correct ? | 0 Yes | 0 No |
Describe the functionalities that views support.
What is the purpose of the master database?
any one can explain Self mapping Delegation Remote Credentials
How do I shrink an ldf file?
what is the maximum size of sql row in mssql?
How will you hide an attribute? : sql server analysis services, ssas
Explain the difference between primary keys and foreign keys?
How do you find the number of rows in a table?
what changed between the previous version of sql server and the current version? : Sql server database administration
what are constraints? Explain different types of constraints? : Sql server database administration
What is the difference between dbcc indexdefrag and dbcc reindex?
What are the system database in sql server 2005?
-
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)
