If there's an index, sqlite will assume that is pretty fast to do many queries like "select * from table where indexed_column = <thing>", and may do something like get all rows from the first table, then for each of those rows, do the above

select * from ...

query replacing the

<thing>