Search notes:
Oracle Query Transformation: Predicate Pushing
Index