Interested to Buy Any Domain ? << Click Here >> for more details...
does the query needs a hint to access a materialized view?
- 1 Answers
- 3852 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 a relational database management system?
Explain the use of show option in imp command.
What is RULE-based approach to optimization ?
Why packages are used in oracle?
After using set unused can we enable the column again to use? Please give me some answers....
How to delete a user account in oracle?
How to connect the oracle server as sysdba?
What are nested tables?
How to write a query with a full outer join in oracle?
Can we connect to ORACLE db using Windows Authentication?
State and explain the different types of data models?
What is oracle and what are its different editions?
Oracle General 
