Description
Constant propagation involves substituting attributes which can be statically evaluated in expressions. Its a pretty common optimization in compilers world.
eg.
SELECT * FROM table WHERE i = 5 AND j = i + 3
can be re-written as:
SELECT * FROM table WHERE i = 5 AND j = 8