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 hr_dataset ("Col1" int, "Col2" varchar(20), "Performance Score" varchar(100));
insert into hr_dataset values(1,'zzz', 'No Need of improvements');
insert into hr_dataset values(2,'ppp', 'blah blah..');
insert into hr_dataset values(3,'qqq', 'Needs improvements');
insert into hr_dataset values(4,'rrr', 'whatever');
Select * from hr_dataset;
Select * from hr_dataset where "Performance Score" like '%Needs improvements%'
1 rows affected
1 rows affected
1 rows affected
1 rows affected
| Col1 | Col2 | Performance Score |
|---|---|---|
| 1 | zzz | No Need of improvements |
| 2 | ppp | blah blah.. |
| 3 | qqq | Needs improvements |
| 4 | rrr | whatever |
| Col1 | Col2 | Performance Score |
|---|---|---|
| 3 | qqq | Needs improvements |