does the query needs a hint to access a materialized view?
- 1 Answers
- 1934 Views
- I also Faced
- E-Mail Answers
Answer / Bijay Kumar
No, by default, Oracle's optimizer can use materialized views without any explicit hint. However, you may use the DBMS_MVIEW.REWRITE_SQL procedure or the MATERIALIZE VIEW STATEMENT hint to force the optimizer to use a specific materialized view.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is difference between truncate and delete?
What is the difference between $oracle_base and $oracle_home?
What is the difference between alert log file and tarce file ?
Explain oracle’s server parameter file.
What are data pump export and import modes?
What are operators in oracle?
Is it possible to insert comments into sql statements return in the data model editor ?
Please explain compound trigger in oracle?
What are named parameters?
What are the arithmetic operations?
What is a View ?
What is the effect of setting the value "ALL_ROWS" for OPTIMIZER_GOAL parameter of the ALTER SESSION command ?
Oracle General 
