Digging into my memory, seems to me that the optimizer may decide differently on batch vs interactive execution. but it's been a while...
On 1/17/2020 11:49 AM, Vernon Hamberg wrote:
I agree with using Visual Explain - it would show any difference in what the optimizer does.
Of course, when the environment changes, the optimizer might make different choices.
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.