ynamically
generated query approach in the interim.
Best regards,
Alastair
Get Outlook for Android<https://aka.ms/ghei36>
From: David Rowley
Sent: Sunday, 14 April, 14:57
Subject: Re: Planner can't seem to use partial function indexes with parameter
from join
To: Alastair McKin
On Sun, 14 Apr 2019 at 21:55, Alastair McKinley
wrote:
> I have reduced my scenario to a minimal test case with inline comments to
> illustrate the issue here
> https://gist.github.com/a-mckinley/1b0e95142789cbc09121b71a83d03f45
>
> Is there something that I am missing to allow the planner to us
Hello all,
I am having quite an interesting problem trying to get the planner to use my
indexes as intended in my setup.
I am using partial functional indexes that have a different function parameter
based on the record type.
A dynamically generated query using unions that are more explicit abo