Database DataWarehousing (MOSC)

MOSC Banner

materialized views and query rewrite questions

edited Jun 1, 2017 5:04AM in Database DataWarehousing (MOSC) 2 commentsAnswered

Hello, Sorry if I picked the wrong group.

I am running 12.1.0.2 Enterprise Edition on SuSE Linux x86_64, 64-bit.

I'm getting a crash course on Materialized Views and have a couple questions.

I created a materialized view without specifying any other parms.  I.e., this statement is

           create materialized view <name> as Select stuff from <table list> where <a bunch of joins>;

1) Query rewrite was disabled by default.  Isn't having query rewrite turned on generally desirable?

2) Documentation says materialized views with query rewrite DISABLED can be refreshed.   Okay, I want my materialized view to be subject to fast refresh.  So this means it will not be eligible for query rewrite operations?  Is this a "you can have one-or-the-other, but not both" kind of thing?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center