SELECT /*+ INDEX(SK_SLS_TXN, SK_SLS_TXN_PK) INDEX(SK_ITM, SK_ITM_PK) INDEX(SK_INQUIRY_LN, SK_INQUIRY_LN_PK) */ SAVEDCART_LINE_INC.SAVEDCART_ID, SAVEDCART_LINE_INC.CREATION_DATE, SAVEDCART_LINE_INC.SAVEDCART_LINE_ID, SAVEDCART_LINE_INC.SAVEDCART_PARENT_LINE_ID, SAVEDCART_LINE_INC.ID, SAVEDCART_LINE_INC.SKU, SAVEDCART_LINE_INC.BRANDID, SAVEDCART_LINE_INC.QUANTITY, SAVEDCART_LINE_INC.DESCRIPTION, SAVEDCART_LINE_INC.FAMILYNAME, SAVEDCART_LINE_INC.TITLE, SAVEDCART_LINE_INC.UNITCOST, SAVEDCART_LINE_INC.ORIGINALPRICE, SAVEDCART_LINE_INC.UNADJUSTEDUNITPRICE, SAVEDCART_LINE_INC.ADJUSTEDUNITPRICE, SAVEDCART_LINE_INC.ORDERCODE, SAVEDCART_LINE_INC.IMAGE, SAVEDCART_LINE_INC.SUBCLASSCODE, SAVEDCART_LINE_INC.SUBCLASSDESCRIPTION, SAVEDCART_LINE_INC.CHASSISID, SAVEDCART_LINE_INC.ITEMCATALOGSOURCE, SAVEDCART_LINE_INC.FAMILYID, SAVEDCART_LINE_INC.ISSERVICEMODULE, SAVEDCART_LINE_INC.ISUPSELL, SAVEDCART_LINE_INC.ISSERVICESKU, SAVEDCART_LINE_INC.DISCOUNTCLASS, SAVEDCART_LINE_INC.DW_AUD_ROW_ID, SAVEDCART_LINE_INC.DW_SRC_IUD_CD, SAVEDCART_LINE_INC.DW_SRC_EXTRC_DTTM, SAVEDCART_LINE_INC.DW_SRC_SITE_ID, SAVEDCART_LINE_INC.DW_SRC_APP_TBL_ID, SAVEDCART_LINE_INC.DW_AUD_INS_DTTM, SAVEDCART_LINE_INC.DW_AUD_LD_GRP_VAL, SAVEDCART_LINE_INC.DW_AUD_INS_ACCT_NAME, SAVEDCART_LINE_INC.DW_ENCRYP_KEY_ID, SAVEDCART_LINE_INC.SAVEDCART_LINE_TYPE_CD, SAVEDCART_LINE_INC.UNITWEIGHT, SAVEDCART_LINE_INC.SRC_PK_VAL_INQUIRY_LN, SAVEDCART_LINE_INC.SRC_PK_VAL_INQUIRY_LN_BRAND, SAVEDCART_LINE_INC.SRC_PK_VAL_SLS_TXN, SAVEDCART_LINE_INC.SRC_PK_VAL_PARENT_INQUIRY_LN, SAVEDCART_LINE_INC.SRC_PK_VAL_ITM, SAVEDCART_LINE_INC.SRC_PK_VAL_INQUIRY_LN_TYPE, SAVEDCART_LINE_INC.CHECKSUM_INQUIRY_LN, SK_INQUIRY_LN.SURROGATE_KEY_ID, SK_INQUIRY_LN.SRC_PK_VAL, SK_INQUIRY_LN.PK_HIST_LAST_SEQ, SK_INQUIRY_LN.DELTA_CHKSUM_VAL, SK_ITM.SURROGATE_KEY_ID, SK_ITM.SRC_PK_VAL, SK_ITM.PK_HIST_LAST_SEQ, SK_SLS_TXN.SURROGATE_KEY_ID, SK_SLS_TXN.SRC_PK_VAL, SK_SLS_TXN.PK_HIST_LAST_SEQ_INQ, SK_INQUIRY_LN1.SURROGATE_KEY_ID, SK_INQUIRY_LN1.SRC_PK_VAL, SK_INQUIRY_LN1.PK_HIST_LAST_SEQ 
FROM SAVED_CART_AUD.SAVEDCART_LINE_INC, GLOBAL_KEYS.SK_INQUIRY_LN SK_INQUIRY_LN, GLOBAL_KEYS.SK_ITM, GLOBAL_KEYS.SK_SLS_TXN, GLOBAL_KEYS.SK_INQUIRY_LN SK_INQUIRY_LN1
WHERE SAVEDCART_LINE_INC.SRC_PK_VAL_INQUIRY_LN=SK_INQUIRY_LN.SRC_PK_VAL
AND SAVEDCART_LINE_INC.SRC_PK_VAL_PARENT_INQUIRY_LN=SK_INQUIRY_LN1.SRC_PK_VAL(+)
AND SAVED_CART_AUD.SAVEDCART_LINE_INC.SRC_PK_VAL_SLS_TXN=SK_SLS_TXN.SRC_PK_VAL(+)
AND SAVED_CART_AUD.SAVEDCART_LINE_INC.SRC_PK_VAL_ITM=SK_ITM.SRC_PK_VAL(+)
and mod(SAVEDCART_LINE_INC.SAVEDCART_LINE_ID, 10) = 0;


Plan
SELECT STATEMENT ALL_ROWS Cost: 5,714,775 Bytes: 34,529,432,146 Cardinality: 54,121,367 
 	12 HASH JOIN Cost: 5,714,775 Bytes: 34,529,432,146 Cardinality: 54,121,367 
 	 	9 HASH JOIN OUTER Cost: 1,975,485 Bytes: 2,676,558,538 Cardinality: 4,857,638 
 	 	 	7 NESTED LOOPS OUTER Cost: 1,296,859 Bytes: 212,329,565 Cardinality: 435,995 
 	 	 	 	4 NESTED LOOPS OUTER Cost: 424,547 Bytes: 201,429,690 Cardinality: 435,995 
 	 	 	 	 	1 TABLE ACCESS FULL TABLE SAVED_CART_AUD.SAVEDCART_LINE_INC Cost: 45,011 Bytes: 193,145,785 Cardinality: 435,995 
 	 	 	 	 	3 TABLE ACCESS BY INDEX ROWID TABLE GLOBAL_KEYS.SK_ITM Cost: 2 Bytes: 19 Cardinality: 1 
 	 	 	 	 	 	2 INDEX UNIQUE SCAN INDEX (UNIQUE) GLOBAL_KEYS.SK_ITM_PK Cost: 1 Cardinality: 1 
 	 	 	 	6 TABLE ACCESS BY INDEX ROWID TABLE GLOBAL_KEYS.SK_SLS_TXN Cost: 2 Bytes: 25 Cardinality: 1 
 	 	 	 	 	5 INDEX UNIQUE SCAN INDEX (UNIQUE) GLOBAL_KEYS.SK_SLS_TXN_PK Cost: 1 Cardinality: 1 
 	 	 	8 TABLE ACCESS FULL TABLE GLOBAL_KEYS.SK_INQUIRY_LN Cost: 298,292 Bytes: 7,667,904,000 Cardinality: 119,811,000 
 	 	11 TABLE ACCESS BY INDEX ROWID TABLE GLOBAL_KEYS.SK_INQUIRY_LN Cost: 3,144,287 Bytes: 10,423,557,000 Cardinality: 119,811,000 
 	 	 	10 INDEX FULL SCAN INDEX (UNIQUE) GLOBAL_KEYS.SK_INQUIRY_LN_PK Cost: 132,295 Cardinality: 119,811,000 


Plan
1 Every row in the table SAVED_CART_AUD.SAVEDCART_LINE_INC  is read.
2 Rows were retrieved using the unique index GLOBAL_KEYS.SK_ITM_PK .
3 Rows from table GLOBAL_KEYS.SK_ITM  were accessed using rowid got from an index.
4 For each row returned by step 1 get the matching row from step 3 If there are not matching rows from step 3 return nulls for those columns.
5 Rows were retrieved using the unique index GLOBAL_KEYS.SK_SLS_TXN_PK .
6 Rows from table GLOBAL_KEYS.SK_SLS_TXN  were accessed using rowid got from an index.
7 For each row returned by step 4 get the matching row from step 6 If there are not matching rows from step 6 return nulls for those columns.
8 Every row in the table GLOBAL_KEYS.SK_INQUIRY_LN  is read.
9 Rows from step 7 which matched rows from step 8 were returned (hash join).
10 Rows were retrieved by performing a sequential read of all records in index GLOBAL_KEYS.SK_INQUIRY_LN_PK  in ascending order.
11 Rows from table GLOBAL_KEYS.SK_INQUIRY_LN  were accessed using rowid got from an index.
12 The result sets from steps 9, 11 were joined (hash).
13 Rows were returned by the SELECT statement.