Index and non-key columns in Postgresql

What is a Sequential scan? What is Index Scan? What is Index Only Scan and what are non-key columns? For the demonstration, Please find the table and data query below(it will generate the table and data): CREATE TABLE song( id serial , na...

Rahul Chaudhari

3 min read