Interested to Buy Any Domain ? << Click Here >> for more details...
does the query needs a hint to access a materialized view?
- 1 Answers
- 3779 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 a Redo Log ?
How to get the Installed Oracle Version Information ?
How do we display rows from the table without duplicates?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
various types of joins
What is a proxy object?
Explain what are the characteristics of data files?
What would you do if a database crashes in production?
What are the components of Physical database structure of Oracle Database?
is there a tool to trace queries, like profiler for sql server?
what are different types of locks?
There is a big table with "n" of rows and 40 + columns .It doesn't have primary key.How do you select the primary key. In other words how do you get the duplicate records.
Oracle General 
