Database DataWarehousing (MOSC)

MOSC Banner

Materialized View Question

edited Mar 30, 2011 2:40AM in Database DataWarehousing (MOSC) 6 commentsAnswered
 http://download.oracle.com/docs/cd/B19306_01/server.102/b14223/basicmv.htm#sthref421

"However, it is recommended that you try to avoid writing SQL statements that directly reference the materialized view, because then it is difficult to change them without affecting the application. Instead, let query rewrite transparently rewrite your query to use the materialized view."

I want to make sure I understand this correctly.  When building a materialized view make sure you don't

A) Write sql to access the view directly

Simply ensure query_rewrite is set to true

C) Upon setting query rewrite to true, queries that are better suited to use the summary view instead of the base tables will become smart enough to magically use the materialized view instead.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center