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

    pjsiong-JavaNet

      Hi,

      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

      Capture.JPG

       

      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?

       

      Thanks

       

      Vincent

        1 2 Previous Next