Interested to Buy Any Domain ? << Click Here >> for more details...
does the query needs a hint to access a materialized view?
- 1 Answers
- 3832 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
Are truncate and delete commands same? If so why?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
Will you be able to store pictures in the database?explain.
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
Query to retrieve record for a many to many relationship ?
What is user managed backup in Oracle?
What is connection pooling in oracle?
What is the relation of a user account and a schema in oracle?
Explain the use of file option in exp command.
What is an oracle transaction?
What is a nvl function?
How to view existing locks on the database?
What are data pump export and import modes?
What is an oracle and why it is used?
What is an oracle function?
