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...
mrrahulrc.hashnode.dev3 min read