Plan
SELECT STATEMENT HINT: FIRST_ROWSCost: 113,154
27 FILTER
19 NESTED LOOPS Cost: 113,154 Bytes: 4,204 Cardinality: 1
17 NESTED LOOPS Cost: 113,154 Bytes: 4,201 Cardinality: 1
9 SORT UNIQUE Cost: 29,217 Bytes: 2,922,644 Cardinality: 35,642
8 VIEW SUPERMAG.SVCASHCHECKITEMS Cost: 29,217 Bytes: 2,922,644 Cardinality: 35,642
7 HASH UNIQUE Cost: 29,217 Bytes: 1,282,916 Cardinality: 35,642
6 UNION-ALL
4 NESTED LOOPS ANTI Cost: 29,090 Bytes: 1,282,608 Cardinality: 35,628
2 TABLE ACCESS BY INDEX ROWID SUPERMAG.SMCASHCHECKITEMS Cost: 29,088 Bytes: 676,932 Cardinality: 35,628
1 INDEX RANGE SCAN SUPERMAG.SMCASHCHECKITEMS_ART Cost: 48 Cardinality: 35,628
3 INDEX UNIQUE SCAN SUPERMAG.SMCONLINECHECKITEMS_PK Cost: 0 Bytes: 17 Cardinality: 1
5 TABLE ACCESS FULL SUPERMAG.SMONLINECHECKITEMS Cost: 127 Bytes: 308 Cardinality: 14
16 VIEW SUPERMAG.SVCASHCHECKS Cost: 83,506 Bytes: 4,119 Cardinality: 1
15 UNION-ALL
13 NESTED LOOPS ANTI Cost: 83,493 Bytes: 4,229,800 Cardinality: 105,745
11 TABLE ACCESS BY INDEX ROWID SUPERMAG.SMCASHCHECKS Cost: 83,487 Bytes: 2,749,370 Cardinality: 105,745
10 INDEX FULL SCAN SUPERMAG.SMCCASHCHECKS_PK Cost: 17,210 Cardinality: 10,574,471
12 INDEX UNIQUE SCAN SUPERMAG.SMCONLINECHECKS_PK Cost: 0 Bytes: 14 Cardinality: 1
14 TABLE ACCESS FULL SUPERMAG.SMONLINECHECKS Cost: 12 Bytes: 2,475 Cardinality: 75
18 INDEX UNIQUE SCAN SUPERMAG.SMCSTORELOCATIONS_PK Cost: 0 Bytes: 3 Cardinality: 1
23 TABLE ACCESS BY INDEX ROWID SUPERMAG.SMSTORELOCOFF Cost: 1 Bytes: 5 Cardinality: 1
22 INDEX UNIQUE SCAN SUPERMAG.SMCSTORELOCOFF_PK Cost: 0 Cardinality: 1
21 TABLE ACCESS BY INDEX ROWID SUPERMAG.SMSTAFF Cost: 1 Bytes: 10 Cardinality: 1
20 INDEX UNIQUE SCAN SUPERMAG.SMSTAFF_LOGIN Cost: 0 Cardinality: 1
26 INDEX RANGE SCAN SUPERMAG.SMCSTORELOCOFF_PK Cost: 1 Bytes: 2 Cardinality: 1
25 TABLE ACCESS BY INDEX ROWID SUPERMAG.SMSTAFF Cost: 1 Bytes: 10 Cardinality: 1
24 INDEX UNIQUE SCAN SUPERMAG.SMSTAFF_LOGIN Cost: 0 Cardinality: 1