Database Tuning (MOSC)

MOSC Banner

Materialized View Rewrite does NOT occur when the base query has a parallel hint "/*+ PARALLEL */"

edited Sep 23, 2018 5:04AM in Database Tuning (MOSC) 12 commentsAnswered

Our development environment properly performs the query re-write from a query to use the materialized view.  The production environment does not perform the re-write.  We have been able to determine the query re-write does occur on both environments when the "/*+ PARALLEL */" hint is broken in the query.  On the development environment, the query re-write occurs with or without the parallel hint.  The production environment only performs the query re-write when the hint is removed (or at least broken with a space between the '/*' and the '+'  -- as /*  + PARALLEL */ ).    We do not have

Tagged:

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