Hi David,
Thank you for your reply!
You mean when you change the date equality filter to a more recent date? - This
is correct we have faced this when we change equality filter to more recent
date.
Will be sending explain analyze on the thread when I get that.
We ran analyze many time to see if
On Tue, May 5, 2020 at 6:15 PM Virendra Kumar wrote:
> Optimizer is behaving little weird in the sense that for change in one
> filter
>
You mean when you change the date equality filter to a more recent date?
> it is using NESTED LOOP JOIN and running for over 30 seconds whereas for
> other f
