• 휴리스틱 기반의 쿼리 변환 : 특정 조건을 충족시키는 경우 적용
• 비용 기반의 쿼리 변환 : 비용 추정기가 산출한 비용에 근거하여, 원래 실행 계획보다 더 낮은 비용의 실행 계획이 생성될 경우 적용

쿼리 변환 - 공통 하위 표현식 제거(휴리스틱 기반)

**************************
Predicate Move-Around (PM)
**************************
PM:     PM bypassed: Outer query contains no views.
PM:     PM bypassed: Outer query contains no views.
query block SEL$1 (#0) unchanged
FPD: Considering simple filter push in query block SEL$1 (#0)
"T"."N1"=1
try to generate transitive predicate from check constraints for query block SEL$1 (#0)
finally: "T"."N1"=1

apadrv-start sqlid=13651654030975505982
  :
    call(in-use=2224, alloc=16344), compile(in-use=62784, alloc=64496), execution(in-use=90448, alloc=93528)

*******************************************
Peeked values of the binds in SQL statement
*******************************************

Final query after transformations:******* UNPARSED QUERY IS *******
SELECT "T"."N1" "N1","T"."N2" "N2" FROM "CHRIS"."T" "T" WHERE "T"."N1"=1
kkoqbc: optimizing query block SEL$1 (#0)
        
        :
    call(in-use=2272, alloc=16344), compile(in-use=63728, alloc=64496), execution(in-use=90448, alloc=93528)

kkoqbc-subheap (create addr=0x7f3ca72f5618)
****************
QUERY BLOCK TEXT
****************
SELECT * FROM t WHERE (n1 = 1 AND n2 = 2) OR (n1 = 1)