Materialized View Question
"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.