OPERATION

OBJECT_NAME

OPTIONS

CARDINALITY

COST

SELECT STATEMENT

6477

15674

NESTED LOOPS

6477

15674

NESTED LOOPS

6477

15674

HASH JOIN

RIGHT OUTER

6476

9193

Access Predicates

AND

ISS.PRODUCT_ORDER_ID(+)=from$_subquery$_002.PRODUCT_ORDER_ID

ISS.ORDER_ID(+)=from$_subquery$_002.ORDER_ID

VIEW

2198

310

Filter Predicates

ISS.NO(+)=1

WINDOW

SORT PUSHED RANK

2198

310

Filter Predicates

ROW_NUMBER() OVER ( PARTITION BY T.ORDER_ID,T.PRODUCT_ORDER_ID ORDER BY INTERNAL_FUNCTION(T.CHGDATE) DESC )<=1

TABLE ACCESS

ORDER_TRX

FULL

2198

308

Filter Predicates

TRX_TYPE<>'ORDER'

HASH JOIN

RIGHT OUTER

6476

8883

Access Predicates

OPT.ORDER_ID(+)=from$_subquery$_002.ORDER_ID

INDEX

PK_ORDER_POINT_TRX

FAST FULL SCAN

HASH JOIN

RIGHT OUTER

6476

8881

Access Predicates

AND

OPCT.PRODUCT_ORDER_ID(+)=from$_subquery$_002.PRODUCT_ORDER_ID

OPCT.ORDER_ID(+)=from$_subquery$_002.ORDER_ID

INDEX

PK_ORDER_PRODUCT_COUPON_TRX

FAST FULL SCAN

HASH JOIN

6476

8879

Access Predicates

AND

T.ORDER_ID=from$_subquery$_002.ORDER_ID

T.PRODUCT_ORDER_ID=from$_subquery$_002.PRODUCT_ORDER_ID

NESTED LOOPS

5130

103

NESTED LOOPS

113888

103

TABLE ACCESS

DELIVERY_INFO

FULL

28472

103

INDEX

ORDER_TRX_INDEX3

RANGE SCAN

Access Predicates

D.DELIVERY_ID=T.DELIVERY_ID

Filter Predicates

T.DELIVERY_ID IS NOT NULL

TABLE ACCESS

ORDER_TRX

BY INDEX ROWID

Filter Predicates

T.TRX_TYPE='ORDER'

VIEW

35246

8775

COUNT

VIEW

35246

8775

SORT

ORDER BY

35246

8775

HASH JOIN

35246

2242

Access Predicates

P.ORDER_ID=O.ORDER_ID

TABLE ACCESS

ORDER_INFO

FULL

35762

411

TABLE ACCESS

ORDER_PRODUCT_INFO

FULL

35246

309

INDEX

USERS

UNIQUE SCAN

Access Predicates

U.USER_SEQ=from$_subquery$_002.USER_SEQ

TABLE ACCESS

USERS

BY INDEX ROWID

Other XML

{info}

info type="db_version"

11.2.0.4

info type="parse_schema"

"MCADM"

info type="dynamic_sampling"

info type="plan_hash"

3795550634

info type="plan_hash_2"

3154740378

{hint}

SWAP_JOIN_INPUTS(@"SEL$9834E3F4" "O"@"SEL$4")

USE_HASH(@"SEL$9834E3F4" "O"@"SEL$4")

LEADING(@"SEL$9834E3F4" "P"@"SEL$4" "O"@"SEL$4")

FULL(@"SEL$9834E3F4" "O"@"SEL$4")

FULL(@"SEL$9834E3F4" "P"@"SEL$4")

FULL(@"SEL$13" "T"@"SEL$13")

NO_ACCESS(@"SEL$3" "TMP"@"SEL$3")

SWAP_JOIN_INPUTS(@"SEL$58F34D4C" "ISS"@"SEL$12")

SWAP_JOIN_INPUTS(@"SEL$58F34D4C" "OPT"@"SEL$10")

SWAP_JOIN_INPUTS(@"SEL$58F34D4C" "OPCT"@"SEL$8")

NLJ_BATCHING(@"SEL$58F34D4C" "U"@"SEL$6")

USE_NL(@"SEL$58F34D4C" "U"@"SEL$6")

USE_HASH(@"SEL$58F34D4C" "ISS"@"SEL$12")

USE_HASH(@"SEL$58F34D4C" "OPT"@"SEL$10")

USE_HASH(@"SEL$58F34D4C" "OPCT"@"SEL$8")

USE_HASH(@"SEL$58F34D4C" "from$_subquery$_002"@"SEL$2")

NLJ_BATCHING(@"SEL$58F34D4C" "T"@"SEL$1")

USE_NL(@"SEL$58F34D4C" "T"@"SEL$1")

LEADING(@"SEL$58F34D4C" "D"@"SEL$7" "T"@"SEL$1" "from$_subquery$_002"@"SEL$2" "OPCT"@"SEL$8" "OPT"@"SEL$10" "ISS"@"SEL$12" "U"@"SEL$6")

INDEX(@"SEL$58F34D4C" "U"@"SEL$6" ("USERS"."USER_SEQ"))

NO_ACCESS(@"SEL$58F34D4C" "ISS"@"SEL$12")

INDEX_FFS(@"SEL$58F34D4C" "OPT"@"SEL$10" ("ORDER_POINT_TRX"."ORDER_ID" "ORDER_POINT_TRX"."POINT_USE_TRX_ID"))

INDEX_FFS(@"SEL$58F34D4C" "OPCT"@"SEL$8" ("ORDER_PRODUCT_COUPON_TRX"."ORDER_ID" "ORDER_PRODUCT_COUPON_TRX"."PRODUCT_ORDER_ID" "ORDER_PRODUCT_COUPON_TRX"."USER_COUPON_NO"))

NO_ACCESS(@"SEL$58F34D4C" "from$_subquery$_002"@"SEL$2")

INDEX(@"SEL$58F34D4C" "T"@"SEL$1" ("ORDER_TRX"."DELIVERY_ID"))

FULL(@"SEL$58F34D4C" "D"@"SEL$7")

OUTLINE(@"SEL$2")

OUTLINE(@"SEL$1")

MERGE(@"SEL$2")

OUTLINE(@"SEL$F5BB74E1")

OUTLINE(@"SEL$6")

MERGE(@"SEL$F5BB74E1")

OUTLINE(@"SEL$98633BB0")

OUTLINE(@"SEL$7")

MERGE(@"SEL$98633BB0")

OUTLINE(@"SEL$F0098980")

OUTLINE(@"SEL$8")

OUTLINE(@"SEL$9")

MERGE(@"SEL$F0098980")

MERGE(@"SEL$8")

OUTLINE(@"SEL$65EF1D02")

OUTLINE(@"SEL$10")

OUTLINE(@"SEL$11")

MERGE(@"SEL$65EF1D02")

MERGE(@"SEL$10")

OUTLINE(@"SEL$CC7935CF")

OUTLINE(@"SEL$12")

OUTLINE(@"SEL$14")

MERGE(@"SEL$CC7935CF")

MERGE(@"SEL$12")

OUTLINE(@"SEL$FBBF9872")

OUTLINE(@"SEL$15")

OUTLINE(@"SEL$4")

OUTLINE(@"SEL$5")

MERGE(@"SEL$FBBF9872")

OUTLINE_LEAF(@"SEL$58F34D4C")

OUTLINE_LEAF(@"SEL$13")

OUTLINE_LEAF(@"SEL$3")

MERGE(@"SEL$4")

OUTLINE_LEAF(@"SEL$9834E3F4")

ALL_ROWS

OPT_PARAM('_optimizer_use_feedback' 'false')

OPT_PARAM('_optimizer_adaptive_cursor_sharing' 'false')

OPT_PARAM('_optimizer_extended_cursor_sharing_rel' 'none')

OPT_PARAM('_optimizer_extended_cursor_sharing' 'none')

OPT_PARAM('_optim_peek_user_binds' 'false')

DB_VERSION('11.2.0.4')

OPTIMIZER_FEATURES_ENABLE('11.2.0.4')

IGNORE_OPTIM_EMBEDDED_HINTS