3 ms·
> A fundamental decision we've made for the pganalyze Indexing Engine is that we break down queries into smaller parts we call "scans". Scans are always on a si
by westurner 3y ago
> A fundamental decision we've made for the pganalyze Indexing Engine is that we break down queries into smaller parts we call "scans". Scans are always on a single table, and you may be familiar with this concept from reading an EXPLAIN plan. For example, in an EXPLAIN plan you could see a Sequential Scan or Index Scan, both representing a different scan method for the same scan on a given table.
Sequential scan == Full table scan:
https://en.wikipedia.org/wiki/Full_table_scan https://en.wikipedia.org/wiki/Full_table_scan
- financltravsty 3y agoYes, and a neat thing about indexes: sometimes it’s faster to do a sequential scan than load an index into memory.
- deleted 3y ago[deleted]