does the query needs a hint to access a materialized view?
- 1 Answers
- 3353 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 |
What is autonomous transaction?
What is sequence?
How to retrieve values from data fields in record variables?
Differentiate between function and procedure in oracle.
what is difference between where clause and having clause?
What is an Extent ?
How to write numeric literals in oracle?
What is tns entry?
Explain the different normalization forms?
What is procedure overloading in oracle?
21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.
How to create a stored program unit?
Oracle General 
