Interested to Buy Any Domain ? << Click Here >> for more details...
Explain indexed view?
- 1 Answers
- 1429 Views
- I also Faced
- E-Mail Answers
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 |
What command do we use to rename a database?
Explain transaction server consistency?
What is the difference between row_number and dense_rank?
What is the difference between stored procedure and functions?
Why use update_statistics command in sql server?
What is not null constraint?
What is the difference between writing data to mirrored drives versus raid5 drives
Join 3 tables (table1, table2 & table3) in a single query. Inner join should be applied for table1 & table 2 and left outer join for table1 & table3 where table2.dept is ABC
What is the concept of optimization?
Does any body please help me what question's have asked for SSRS in the interview?
How do you send email on SQL Server?
Which command displays the SQL command in the SQL buffer, and then executes it?
-
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)
