Usually when you do a select, you have to look at all the rows in in the table sequentially, to check whether they need to be included in your results set. This is called a full table scan. The execution time is predictable, but probably slower than using an index