Re: Question on Buckets and Batches in explain plan

2018-06-14 Thread Adrian Klaver
On 06/14/2018 05:47 PM, Charlin Barak wrote: Hi, I ran a query on two supposedly similarly configured 9.6.8 databases but got two different timings. One ran three times faster than the other. I think the first thing to do would be to verify the configurations in their respective

Question on Buckets and Batches in explain plan

2018-06-14 Thread Charlin Barak
Hi, I ran a query on two supposedly similarly configured 9.6.8 databases but got two different timings. One ran three times faster than the other. The explain plans on both systems look the same except for the Buckets and Batches. Can someone explain what that means and what configuration