Interested to Buy Any Domain ? << Click Here >> for more details...
does the query needs a hint to access a materialized view?
- 1 Answers
- 3781 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
What is the use of aggregate functions in oracle?
What is the difference between 10g OEM and 11g OEM?
What different of iner joint & outer joint with example
Display Odd/ Even number of records?
select statement does not retrieve any records. what exception is raised?
What is oracle datasource?
what are archived logs?
9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS
What is the difference between Delete, Truncate and Drop in Oracle?
What is materialized view in Oracle?
What are the various constraints used in oracle?
What is SQL access advisor in Oracle?
Oracle General 
