Basically the data is chunked into smaller sets that Postgres can filter though and more intelligently decide which sets to scan and which to skip. Where the Sequential Scan will touch every single row in the table.
To read:-
Basically, the data is chunked into smaller sets that Postgres can filter through and more intelligently decide which sets to scan and which to skip. Where the Sequential Scan will touch every single row in the table.
Please correct:-
Basically the data is chunked into smaller sets that Postgres can filter though and more intelligently decide which sets to scan and which to skip. Where the Sequential Scan will touch every single row in the table.
To read:-
Basically, the data is chunked into smaller sets that Postgres can filter through and more intelligently decide which sets to scan and which to skip. Where the Sequential Scan will touch every single row in the table.
Thanks,
Daniel