Interested to Buy Any Domain ? << Click Here >> for more details...
does the query needs a hint to access a materialized view?
- 1 Answers
- 3801 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 privilege is needed for a user to connect to oracle server?
Explain about your project and its relation to the current job position you are applying to?
What is the difference between I and G in Oracle?
what is dynamic SGA and static SGA
What do you mean by cdb and pdb in oracle 12c?
Using the relations and the rules set out in the notes under each relation, write table create statements for the relations EMPLOYEE, FIRE and DESPATCH. You should aim to provide each constraint with a formal name, for example table_column_pk.
Which is better Oracle or MS SQL? Why?
What are the tools for Oracle ?
What is the best way to do multi-row insert in oracle?
How to view the data files in the current database?
how to handle exceptions in post production
What language does oracle use?
How to handle a single quote in oracle sql?
Can we connect to ORACLE db using Windows Authentication?
What are operators in oracle?
