1The Full Table Scan
If you write WHERE last_name = 'Smith', the database has to read every single row on the hard drive to find the Smiths. This is a 'Full Table Scan' and it is very slow. If you create an 'Index' on the last_name column, the database creates a B-Tree, allowing it to instantly jump to the Smiths without scanning the whole table.
