Interested to Buy Any Domain ? << Click Here >> for more details...
Why do we use materialized view instead of table or views?
- 1 Answers
- 9 Views
- I also Faced
- E-Mail Answers
Answer / Ankit
Materialized views are used in Oracle to improve query performance by pre-computing and storing the results of complex queries. This allows for faster response times when the same query is executed multiple times, as the query only needs to be run once during materialized view refresh. Materialized views can also be updated periodically to reflect changes in the base tables.
| Is This Answer Correct ? | 0 Yes | 0 No |
How can we tune a sql query to optimize the performance of a database?
Explain the oracle real application clusters architecture?
Mention what are the key characteristics of rac or why to use rac?
How is rman better than user-managed backup recovery process?
What are the key components of oracle’s maximum availability architecture?
What are the provisions and resources provided in the oracle’s cloud server?
Mention what are the main components of an oracle rac system?
What is table partitioning?
What is a recovery catalog?
What is the function of grid naming service used in oracle rac
What is a flashback query and when should it be used?
Mention what is oracle real application clusters?
Oracle General 
