Skip to main content

Seq Scan

Short Description

The Seq Scan node Reads all the pages in the table to return required data

Detailed Description

Reads all the pages in the table to return required data in the order they appear on disc. Filters can be applied to return specified rows, but they must be read first in order to do this. Sequential scans are very efficient at reading small tables and large proportions of large tables. They are not efficient at reading a small number of rows from a large table. In this case, indexed access may be more efficient.

Search online

If this article doesn't have the information you need you can try searching online. Remember, you can contribute suggestions to this page.

DBmarlin Trial