does the query needs a hint to access a materialized view?
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
Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).
Why do we use bulk collect in oracle?
What is background process in Oracle?
Is oracle a language?
how to handle exceptions in post production
How to define an anonymous procedure without variables?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
What do you mean by merge in oracle and how can you merge two tables?
How will you identify oracle database software release?
Explain what does a control file contain?
What is the difference between substr and instr?
How to start your 10g xe server?
What are the differences between interval year to month and interval day to second?
What is a package ? What are the advantages of package ?
What is key preserved table?