> ... only the first index is opened ... That's right. SQLite uses only one index, and it doesn't keep statistics, so it may pick the wrong index if it has to choose. Try forcing it to use the other index by dropping the one that it's using now.
Changing 'table1, table2 where' to 'table1 join table2 on' is not going to help. Regards
