Re: need explanation about an explain plan

2023-07-02 Thread Umut TEKİN
>You could likely get an idea of how the surplus filter is slowing down >execution if you widen the filter to ensure it includes all possible >"ladate" values, run the query, then run the query again without the >date range filter. I would guess it'll only save you a few percent, >but I'm open to b

Re: need explanation about an explain plan

2023-07-02 Thread David Rowley
On Fri, 30 Jun 2023 at 00:42, Umut TEKİN wrote: > @Marc, I think there is no problem.Even though it says it is filtered by > ladate, it is not. Because of the partition. > As you can see for each index scan it uses a different partition and those > partition boundaries are already specified logi