Interested to Buy Any Domain ? << Click Here >> for more details...
does the query needs a hint to access a materialized view?
- 1 Answers
- 3943 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Explain an integrity constrains?
How to write a left outer join with the where clause in oracle?
What is pragma autonomous transaction in oracle?
How to use "out" parameter properly?
What is the difference between column level constraints and table level constraints?
14 Answers IBM, TCS,
How to see the table columns used in an index?
How to rename an index?
Explain the blob datatype?
What is recycle bin in Oracle?
Can we use bind variables in oracle stored procedure?
4. Display the order number and client number from the ORDER table. Output the result in the format. Client <clientno> ordered <orderno>
How many types of segments in Oracle?
Oracle General 
