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
INSERT 0 1
INSERT 0 1
INSERT 0 1
INSERT 0 1
| roll_no | name | subject | mark | result | grade |
|---|---|---|---|---|---|
| 1 | J | Math | 90 | P | F |
| 1 | J | English | 80 | P | F |
| 1 | J | Lang | 30 | F | F |
| 1 | J | Science | 60 | P | F |
| 1 | J | History | 70 | P | F |
SELECT 5