does the query needs a hint to access a materialized view?
- 1 Answers
- 3540 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 Parallel Server ?
how to find out largest value in a table
what is cartesian product?
What is Read-Only Transaction ?
What is Hash Cluster ?
How to view the data files in the current database?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?
Why packages are used in oracle?
How do you store pictures in a database?
When do I need to use a semicolon vs a slash in oracle sql?
Create table Employee ( Employee_Id varchar2(8) Constraint emp_id_pk primary key, FirstName varchar2(50), LastName varchar2(50), DeptID Number(5) Constraint dept_id_fk Foreign Key(DeptId) References Department(DeptId) ) Error I am getting: Constraint specification are not allowed here
What is tns name?
Oracle General 
