Plan SELECT STATEMENT ALL_ROWSCost: 2,119 Cardinality: 85 CPU Cost: 22,398,726 IO Cost: 2,115 9 SORT ORDER BY Cost: 2,119 Cardinality: 85 CPU Cost: 22,398,726 IO Cost: 2,115 8 NESTED LOOPS Cost: 2,118 Cardinality: 85 CPU Cost: 16,554,480 IO Cost: 2,115 5 NESTED LOOPS Cost: 1,948 Cardinality: 85 CPU Cost: 14,624,613 IO Cost: 1,945 2 TABLE ACCESS BY INDEX ROWID TABLE BEACON.AU_BEN Cost: 1,777 Cardinality: 85 CPU Cost: 12,696,446 IO Cost: 1,775 1 INDEX SKIP SCAN INDEX BEACON.AU_BEN_NK1 Search Columns: 1 Cost: 1,697 Cardinality: 85 CPU Cost: 12,087,041 IO Cost: 1,695 4 TABLE ACCESS BY INDEX ROWID TABLE BEACON.AU_BEN_ITEMS Cost: 2 Cardinality: 1 CPU Cost: 22,684 IO Cost: 2 3 INDEX UNIQUE SCAN INDEX (UNIQUE) BEACON.AU_BEN_ITEMS_PK Search Columns: 1 Cost: 1 Cardinality: 1 CPU Cost: 15,293 IO Cost: 1 7 TABLE ACCESS BY INDEX ROWID TABLE BEACON.AU Cost: 2 Cardinality: 1 CPU Cost: 22,704 IO Cost: 2 6 INDEX UNIQUE SCAN INDEX (UNIQUE) BEACON.PK_AU Search Columns: 1 Cost: 1 Cardinality: 1 CPU Cost: 15,293 IO Cost: 1