does the query needs a hint to access a materialized view?
- 1 Answers
- 3985 Views
- I also Faced
- E-Mail Answers
Answer Posted / gautam choudhury
It's important to note that init.ora parameters
query_rewrite_integrity and query_rewrite_enabled are
required to use materialized views and function-based
indexes. if these two parameters are declared then hint is
not required to access a materialized view.
QUERY_REWRITE_INTEGRITY =ENFORCED
QUERY_REWRITE_ENABLED = TRUE
There are three acceptable values for
query_rewrite_integrity:
enforced (default) - Presents materialized view with fresh
data
trusted - Assumes that the materialized view is current
stale_tolerated - Presents materialized view with both
stale and fresh data
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is oracle latest version?
Design database draw er diagram for a certain scenario ?
Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com
How to put more than 1000 values into an oracle in clause?
How to start an oracle instance?
How to use values from other tables in update statements using oracle?
How to select all columns of all rows from a table in oracle?
How to write a left outer join with the where clause in oracle?
