SQLite Forum

Min/max and index usage?
Separate queries for `min` and `max` both use the index, just picking its first and last entry. The combined query doesn't use the index and instead performs a full scan, because the planner is not smart enough to use the same index twice for the same table, in different directions.