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 is openrowset sql server?
What is a trigger in sql server?
Can a stored procedure call itself or recursive stored procedure? How many levels sp nesting is possible?
How to rename databases in ms sql server?
When you use @@error and try-catch?
What is a function? Give some example?
What are indexes? When do you need to create Indexes?
4 Answers CarrizalSoft Technologies, HP,
What is the command to change the recovery model?
How self join is different from outer join?
Give me a SQL Query to find out the second largest company?
You are doing log shipping due to some reasons it is failing. How you will proceed from there
1. What is CUBE Operator? 2. what are the new data types are available in sql server 2008? 3. Inisde a nested queries, how many subqueries u can have?
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)