When adding filters with large results (>100k), queries are a bit slow even with a basic index.
By including accessions in the index, the query planner doesn't need a secondary step to retrieve accessions after finding matches in the indexed filter column. We may also need to adjust the query to remove any unnecessary columns
When adding filters with large results (>100k), queries are a bit slow even with a basic index.
By including accessions in the index, the query planner doesn't need a secondary step to retrieve accessions after finding matches in the indexed filter column. We may also need to adjust the query to remove any unnecessary columns
https://atlasgo.io/guides/postgres/included-columns