does the query needs a hint to access a materialized view?
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 |
types of indexes and the rationale behind choosing a particular index for a situation.
what r routers?
What is an Extent ?
material view and view disadvantages?
How to insert a new row into a table in oracle?
Can we create index on views?
19 Answers CTS, Syntel, TCS,
Who developed oracle & when?
Oracle
0 Answers ABC, Genpact, HUI, Oracle,
hi friends, I have a table A col as status|NUM and value as open |1 open |2 close |3 close |3 the O/P should be open|close 1 |3 2 |4
How to get the Installed Oracle Version Information ?
How to update values on multiple rows in oracle?
what are actual and formal parameters?