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 |
How to use “drop” keyword in sql server and give an example?
What is system stored procedures?
Explain user defined functions?
Explain various data region available in ssrs with their use?
What is data source document?
What is log in sql server?
Explain different types of self contained sub query?
In the primary key have a multiple field or not?
Explain Active/Active and Active/Passive cluster configurations?
Why union all is faster than union?
what is Full Text Search ?
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records
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)