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
1971
February 25, 2016 12:05AM
1036
February 25, 2016 01:51AM
1058
February 25, 2016 03:51AM
Re: Difference execution plans for same query
1049
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.