Re: Difference execution plans for same query
Posted by:
Rick James
Date: March 05, 2016 01:19AM
Are the datasets on the two machines identical (or nearly so)? Significant differences in the data, especially for that date range, could easily lead to different explain plans.
Differences in the constants in the query can also lead to different plans. I have seen as many as 6 different plans for the similar queries on the same machine.
Subject
Views
Written By
Posted
1863
February 25, 2016 12:05AM
976
February 25, 2016 01:51AM
997
February 25, 2016 03:51AM
Re: Difference execution plans for same query
990
March 05, 2016 01:19AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.