full table scan

A database reading every row of a table to answer a query, instead of using an index to jump to the rows it needs.

In more detail

On a large table it is slow and grows slower as the table grows. Calling ToList before Where in EF Core forces something worse: every row is fetched into the application and filtered in C#.

Related terms

Taught in

References