adspace


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

does the query needs a hint to access a materialized view?

Question Posted / Bijay Kumar

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956

Design database draw er diagram for a certain scenario ?

4656

What is oracle latest version?

1174

How to use values from other tables in update statements using oracle?

1158

How to select all columns of all rows from a table in oracle?

1132

How to write a left outer join with the where clause in oracle?

1155

How to start an oracle instance?

1103

How to put more than 1000 values into an oracle in clause?

1115