Answer Posted / lekhrajdeshmukh
**A materialized view provides indirect access to table data
by storing the results of a query in a separate schema
object. Unlike an ordinary view, which does not take up any
storage space or contain any data.
**You can define a materialized view on a base table,
partitioned table or view and you can define indexes on a
materialized view.
**Materialized views are schema objects that can be used to
summarize, precompute, replicate, and distribute data. E.g.
to construct a data warehouse
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
Tell me what is normalization? Explain different forms of normalization?
What is difference between clustered and non clustered index?
How to select true false based on column value in sql server?
Explain “not null constraint” in sql server?
What is cursor in ms sql server?
What is open database communication (odbc)?
Are null values the same as that of zero or a blank space?
how would you store your query in an SSRS report or a Database server?
What is query cost in sql server?
What is exporting utility?
How to set the current database in ms sql server?
you added a row to a view, but the row is not shown on the view. Explain how this can happen, and how you can remedy the situation
How to execute the cursor queries with "open" statements?
What is inline table-value user-defined function?
How to add a new dsn with the odbc driver for sql server?
