No Query Rewrite (QSM-01112) When SYSDATE Comparison in WHERE Clause
(Doc ID 1364498.1)
Last updated on JANUARY 05, 2020
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 to 188.8.131.52 [Release 8.1.7 to 11.2]
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Information in this document applies to any platform.
A query would rewrite when an explicit to_date comparison was made in the where clause, but would not rewrite if the 'to_date' conversion was replaced by 'sysdate.'
Here is the materialized view (mview):
Therefore, shouldn't the value of SYSDATE in the query be evaluated when determining if the query will or will not rewrite?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document