10 Replies Latest reply on May 26, 2015 3:35 AM by teradata0802

    How to see Execution Plan from SQLDevelopper

    teradata0802

      We use Oracle 11gR2 on win2008R2.

       

      I saw Execution Plan from SQLDevelopper for SQL tuning.

       

      it is like below.

       

      TABLE ACCESS PRODUCT BY INDEX ROWID

           Filter Predicates

                OR

                     PRD.PRODUCT_ID is not NULL

           INDEX

                Access Predicates

                     AND

                          PRD.CASE_ID=:B1   (parameter)

                          PRD.Deleted is NULL

       

      If INDEX scan is usable in one of criteria in WHERE phrase, INDEX is used for table scan if all other criteria are not usable for INDEX like  PRD.Deleted is NULL ?