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 |
where we have to use ON clause and where we have to use USING clause in JOINS
how the indexes are stored in the Oracle Database?
Can multiple columns be used in group by in oracle?
Explain the difference between a procedure and a function? What do you understand by those terms?
what is the syntax of SELECT command?
Explain the use of tables option in exp command.
Whether any commands are used for months calculation? If so, what are they?
What is the difference between formal parameters and actual parameters?
Explain the types of exception?
What is the usage of control file in oracle?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.