By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
Help with an interesting Postgres question: Why isn't an Index Only Scan used on a partition accessed via the parent table?.
CREATE TABLE
INSERT 0 1
sequencenumber | dpid | companyname | address |
---|---|---|---|
<DpidOwner SequenceNumber="1"> <DPID>PADPIDA2006111001O</DPID> <CompanyName>234AG</CompanyName> <Address>Riedtlistrasse 23, Z�???????�??????�?????�????�???�??�?�¼rich, 8006, CH</Address> </DpidOwner> |
<DPID>PADPIDA2006111001O</DPID> | <CompanyName>234AG</CompanyName> | <Address>Riedtlistrasse 23, Z�???????�??????�?????�????�???�??�?�¼rich, 8006, CH</Address> |
<DpidOwner SequenceNumber="2"> <DPID>PADPIDA2007011501Q</DPID> <CompanyName>OpenIMP</CompanyName> <Address>8-10 Rhoda Street, London, E2 7EF, UK</Address> </DpidOwner> |
<DPID>PADPIDA2007011501Q</DPID> | <CompanyName>OpenIMP</CompanyName> | <Address>8-10 Rhoda Street, London, E2 7EF, UK</Address> |
<DpidOwner SequenceNumber="3"> <DPID>PADPIDA2007040501K</DPID> <CompanyName>The Harry Fox Agency</CompanyName> <Address>711 Third Avenue, 8th Floor, New York, 10017, USA</Address> </DpidOwner> |
<DPID>PADPIDA2007040501K</DPID> | <CompanyName>The Harry Fox Agency</CompanyName> | <Address>711 Third Avenue, 8th Floor, New York, 10017, USA</Address> |
SELECT 3