What Is a Full Table Scan?
In a database, querying a table without an index is generally called a full table scan. Full table scan is the process used by the database server to search each record in the table until all records that meet the given conditions are returned.