EXPLAIN - Sequential Scan
This is the simplest way of fetching data from a table: it scans through every page of data sequentially. Like most other scans, this can apply a filter while reading data, but it needs to read the data first and then discard it. A sequential scan has no way to zero in on just the data you want: it always reads everything in the table. This is generally inefficient unless you need a large proportion of the table to answer your query, but is always available and sometimes may be the only option.
- Rows Removed by Filter
Couldn't find what you were looking for or want to talk about something specific?
Start a conversation with us →