Explain the difference between view and materialized view?
- 1 Answers
- 1009 Views
- I also Faced
- E-Mail Answers
Answer / Suman Shukla
A View is a virtual table created by a SELECT statement that does not store data but instead provides a representation of data from one or more tables in a database. A Materialized View, on the other hand, is a pre-computed and stored version of a view. It physically stores the result set of a query for faster access.n
1. Query Execution:n - View: The SELECT statement is executed every time the view is accessed.n - Materialized View: The data is already pre-computed and stored, so it does not require computation each time it's accessed (faster performance).n
2. Data Consistency:n - View: Since it's a virtual table, there may be a slight delay in retrieving the most up-to-date data.n - Materialized View: The data is updated periodically using refresh functions to ensure data consistency.
| Is This Answer Correct ? | 0 Yes | 0 No |
Suppose if a session fails after loading of 10,000 records in to the target.how can you load the records from 10001 the record when you run the session next time?
What are aggregate tables and aggregate fact tables?
What is confirmed dimension?
What is batch processing?
What Oracle features can be used to optimize my Warehouse system?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is the difference between olap and datawarehosue?
What is difference macros and prompts?
what is difference between scd2 and scd3
Explain what are the various reporting tools in the market?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What is the difference between snowflake and star schema?
Teradata 
