Interested to Buy Any Domain ? << Click Here >> for more details...
does the query needs a hint to access a materialized view?
- 1 Answers
- 3932 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
Is oracle a language?
what is the difference between data migration and production migration.
Give the various exception types.
How to use select statement to count the number of rows in oracle?
What happens if you lost a data file?
How do you store pictures in a database?
Is oracle a programming language?
Explain database link?
Differentiate between pre-select and pre-query?
What is define in oracle?
What is the difference between Delete, Truncate and Drop in Oracle?
Why use resource manager in Oracle?
Explain what does a control file contain?
How can we force the database to use the user specified rollback segment?
How can Oracle users be audited?
