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?.
DOB | First Name | Last Name |
---|---|---|
2010-08-12 | efgh | abcd |
SELECT 1
DOB | First Name | Last Name |
---|---|---|
2009-08-12 | str | xyz |
SELECT 1