What happens when you search for a row without an index?

Without a useful index, the database must scan the table. It reads whole data pages rather than individual rows, so a selective lookup on a large table can require substantial I/O.