Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Meaning of INDEX FULL SCAN

3278558Sep 27 2016 — edited Sep 30 2016

Hi

I get a result from "Explain Plan":

INDEX FULL SCANSGCIIDX_FUNCIONPSVL_TRANSC11142736

I am not sure if INDEX FULL SCAN is correct, is there a problem with this line?

The complete result...

SELECT STATEMENT, GOAL = CHOOSE5313162110
COUNT STOPKEY
  VIEWSGCI5313162110
   COUNT
    VIEWSGCI5313161941
     UNION-ALL
      TABLE ACCESS BY INDEX ROWIDSGCICOMERCIO2130
       INDEX UNIQUE SCANSGCIUK_COMERCIO_CODCOM11
      HASH JOIN OUTER1161290
       HASH JOIN OUTER861116
        NESTED LOOPS
         NESTED LOOPS56864
          INDEX SKIP SCANSGCIIDX_EMPRESAPSV_EMPTRANS1127
          INDEX RANGE SCANSGCIIDX_TXNNOCONTABLE_EMPADQ017
         TABLE ACCESS BY INDEX ROWIDSGCITXNNOCONTABLE4121404
        VIEWSGCI21144788
         WINDOW SORT PUSHED RANK21142736
          INDEX FULL SCANSGCIIDX_FUNCIONPSVL_TRANSC11142736
       INDEX FAST FULL SCANSGCIIDX_POSINFOADICIONAL_ESTD339111339
      TABLE ACCESS BY INDEX ROWIDSGCICOMERCIO2130
       INDEX UNIQUE SCANSGCIUK_COMERCIO_CODCOM11
      TABLE ACCESS BY INDEX ROWIDSGCIENTIDAD2125
       INDEX RANGE SCANSGCIIDX_ENTIDAD_IDADQCODENT11
      HASH JOIN OUTER4271953
       NESTED LOOPS
        NESTED LOOPS3871750
         INDEX SKIP SCANSGCIIDX_EMPRESAPSV_EMPTRANS1127
         INDEX RANGE SCANSGCIIDX_TXNCONTABLE_EMPRESA3613
        TABLE ACCESS BY INDEX ROWIDSGCITXNCONTABLE37143122
       INDEX FAST FULL SCANSGCIIDX_POSINFOADICIONAL_ESTD339111339
This post has been answered by 3278558 on Sep 30 2016
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 28 2016
Added on Sep 27 2016
11 comments
1,471 views