Interested to Buy Any Domain ? << Click Here >> for more details...
does the query needs a hint to access a materialized view?
- 1 Answers
- 3864 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 are the advantages of oracle?
What is the usage of synonyms?
What is the order of defining local variables and sub procedures/functions?
What is oracle join syntax?
What is PL/SQL ?
Explain what are clusters?
How many data types are supported?
Name the three major set of files on disk that compose a database in Oracle?
What are joins, explain all types of joins?
In the oracle version 9.3.0.5.0, what does each number shows?
How to define a sub function?
How to join two tables in a single query using oracle?
Can we write dml statement in function in oracle?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
I creat Credit memo in AR. Now i want revers the Credit Memo.how you can revers that what out any aditional entry.
