Skip to Main Content
Forums

Oracle Database Discussions

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!

Same SQL but different execution plan

pjsiong-JavaNetFeb 21 2017 — edited Mar 8 2017

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.

pastedImage_1.png

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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 5 2017
Added on Feb 21 2017
#general-database-discussions
19 comments
22,157 views