Interested to Buy Any Domain ? << Click Here >> for more details...
Why do we use materialized view instead of table or views?
- 1 Answers
- 2 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
