it's the data structure itself that is at fault. Without an index it needs to scan the full table