Just learned today about composite indexing in #sql ( #sqlite in particular). Again something that seem obvious once you know about it but that completely flew over my mind.
Basically using one index over 2 columns can be way better than having 2 distinct indexes for the same query.
I discovered it through the .expert command : https://www.sqlite.org/cli.html#expert that I used like this :
```
>>> .expert
>>> [expensive query]
CREATE INDEX Transcripts_idx_705bb5a0 ON Transcripts(gene, prot);
```

🤯