SELECT COUNT.PROPOSED_DESIGNATION, COUNT.PROPOSED_FEED_DIR, COUNT.PROPOSED_HIGH, COUNT.PROPOSED_LOW, COUNT.G3E_FID, COUNT.SEQ FROM GC_COUNT COUNT, GC_NR_CONNECT NODEEDGE WHERE (COUNT.G3E_FNO = NODEEDGE.G3E_FNO AND COUNT.G3E_FID = NODEEDGE.G3E_FID) AND ((NODEEDGE.IN_FNO = 10800 AND NODEEDGE.IN_FID = 176704 AND COUNT.PROPOSED_FEED_DIR = 'R') OR (NODEEDGE.OUT_FNO = 10800 AND NODEEDGE.OUT_FID = 176704 AND COUNT.PROPOSED_FEED_DIR = 'F')) ORDER BY COUNT.G3E_FID, COUNT.SEQ

PROPOSED_DESIGNATION PROPOSED_FEED_DIR PROPOSED_HIGH PROPOSED_LOW G3E_FID SEQ
0 rows returned.

Statistics
     807   Consistent Gets
     0   Db Block Gets
     0   Index Fast Full Scans (direct Read)
     0   Index Fast Full Scans (full)
     0   Index Fast Full Scans (rowid Ranges)
     803   Physical Reads
     0   Recursive Calls
     0   Sorts (disk)
     1   Sorts (memory)
     0   Sorts (rows)

Execution Plan:
Operation Object Name Optimizer Rows Bytes Cost
SELECT STATEMENT    CHOOSE

1

72

8

    SORT ORDER BY    

1

72

8

        FILTER     

            HASH JOIN     

1

72

5

                TABLE ACCESS FULL B$GC_NR_CONNECT ANALYZED

5

185

2

                TABLE ACCESS FULL B$GC_COUNT ANALYZED

2

70

2

            TABLE ACCESS BY INDEX ROWID B$GC_NR_CONNECT ANALYZED

1

7

·167

                NESTED LOOPS     

1

7

·1364045

                    COLLECTION ITERATOR PICKLER FETCH GETLTTMAP  

                    INDEX RANGE SCAN IDX_B$GC_NR_CONNECT_LTTID ANALYZED

1

·5

            COLLECTION ITERATOR PICKLER FETCH GETLTTMAP  

            TABLE ACCESS BY INDEX ROWID B$GC_COUNT ANALYZED

1

8

·2069

                NESTED LOOPS     

1

8

·16899581

                    COLLECTION ITERATOR PICKLER FETCH GETLTTMAP  

                    INDEX RANGE SCAN IDX_B$GC_COUNT_LTTID ANALYZED

1

            COLLECTION ITERATOR PICKLER FETCH GETLTTMAP  

Total:

16

501

·18265842

Execution Time: 0:00:01