Materialized View Rewrite does NOT occur when the base query has a parallel hint "/*+ PARALLEL */"
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