What is indexed views?
plz explain with example?
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 |
What are joins in sql and what are the different types of joins?
What stored by the tempdb ? : sql server database administration
what is hash table
How to list all triggers in the database with sys.triggers in ms sql server?
What are ddl (data definition language) statements for tables in ms sql server?
Explain cross join or cartesian product in sql?
What is implicit mode in sql server?
What is the dbcc command and why is it used?
How can you insert null values in a column while inserting the data?
What is Trace flag?
How can you check the level of fragmentation on a table?
What is the best way to move n number of DTS package from one SQLServer to another SQLServer?
Oracle (3253)
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)