Query Rewrite的条件
- Individual materialized views must have the ENABLE QUERY REWRITE clause.
- The session parameter QUERY_REWRITE_ENABLED must be set to TRUE (the default) or FORCE.
- Cost-based optimization must be used by setting the initialization parameter OPTIMIZER_MODE to ALL_ROWS, FIRST_ROWS, or FIRST_ROWS_n.
影响Query Rewrite的参数
- QUERY_REWRITE_ENABLED = TRUE (default), FALSE, or FORCE
- QUERY_REWRITE_INTEGRITY - STALE_TOLERATED, TRUSTED, or ENFORCED (the default)
- OPTIMIZER_MODE = ALL_ROWS (default), FIRST_ROWS, or FIRST_ROWS_n