A transformation takes place for this expression:
WHERE column1 = 1 + 2
WHERE column1 = 3
Before you say, “but I never would write 1 + 2 in the first place”, remember what was said earlier about constant propagation. It is quite easy for the optimizer to put such expressions together. This process simplifies the result.
Copyright © 1997, 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices