Once we run that query, what exactly goes on behind the scenes to find employees
who are named Jesus? Well, the database software would literally have to look at
every single row in the Employee table to see if the Employee_Name for that row is
‘Jesus’. And, because we want every row with the name ‘Jesus’ inside it, we can not
just stop looking once we find just one row with the name ‘Jesus’, because there could
be other rows with the name Jesus. So, every row up until the last row must be
searched – which means thousands of rows in this scenario will have to be examined
by the database to find the rows with the name ‘Jesus’. This is what is called a full
table scan.