1 2 Previous Next 19 Replies Latest reply on Mar 8, 2017 8:40 AM by Hemant K Chitale

    Same SQL but different execution plan



      I run below sql in one of our database and get the execution plan (INDEX FULL SCAN (MIN/MAX) as below,

      the table has one index with columns GROUPID+LINE+PRODUCT+STN+SIDE



      but when I run the same sql in another database, even thought the table structure and index is same, but the execution plan diff.


      Is that something to do with the data in the table?

      In what circumstance Oracle use different execution plan with the same query?





        1 2 Previous Next