Interested to Buy Any Domain ? << Click Here >> for more details...
does the query needs a hint to access a materialized view?
- 1 Answers
- 3937 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 |
How to connect asp pages to oracle servers?
Is oracle a relational database?
Can we insert data in view oracle?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.
14. Display the item_cost and then round it to the nearest hundred, ten, unit, tenth and hundredth
What are the differences between blob and clob in oracle?
What is use of oracle?
What is a nvl function? How can it be used?
Give the different types of rollback segments.
1) What is dense ranking? 2) Difference between Substring and Instring? 3) Case and Decode? 4) Pseudo column? 5) View vs Materialized views? 6) SQl performance tuning?
What is an oracle cursor variable?
Oracle General 
