material view and view disadvantages?
- 1 Answers
- 1162 Views
- I also Faced
- E-Mail Answers
Answer / Manish Bayalan
In Oracle General, a Material View is a query that displays data from multiple tables related to materials. Some potential disadvantages of using material views include: 1) Performance issues if the view is too complex or contains too much data. 2) Difficulty in maintaining the view when table structures change. 3) Lack of control over individual columns and their formatting.
| Is This Answer Correct ? | 0 Yes | 0 No |
What are the roles of dba?
What is oracle database client?
How to change program global area (pga) in oracle?
How to start a specific oracle instance?
Is it possible to set second Primary Key Constraint in a table in Oracle Database ?
What is a dynamic performance view in oracle?
What is analyze command used for?
How to retrieve data from an cursor to a record?
How many types of database triggers exist?
Can we call a trigger inside a function and function inside a trigger? Give example.
Can a Tablespace hold objects from different Schemes ?
What is java oracle used for?
Oracle General 
