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

difference between bind variable and variable

1 Answers   Attra,

---

What is Index Cluster ?

2 Answers  

---

how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?

0 Answers   Sierra Atlantica,

---

What is not equal to in oracle?

0 Answers  

---

What are the different type of Segments ?

2 Answers  

---

structural difference between bitmap and btree index ?

1 Answers   Infosys,

---

What is Hash Cluster ?

2 Answers  

---

how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?

0 Answers   Oracle,

---

how to unbreak sequence numbers during intereptions

1 Answers   Ion Exchange,

---

What is background process in Oracle?

0 Answers   MCN Solutions,

---

Does oracle partitioning improve performance?

0 Answers  

---

What is a table index in oracle?

0 Answers  

---