Comment on Comparing SQLite, DuckDB and Arrow with UN trade dataComments−HighChaparral4yPossibly nothing more than a side issue, but why are the indexes being created before the bulk insert, rather than after?−fnord1234yAlso, a composite index on (reporter_iso, year) instead of individual indexes would work better in a single group-by afaict.
Comments
Possibly nothing more than a side issue, but why are the indexes being created before the bulk insert, rather than after?
Also, a composite index on (reporter_iso, year) instead of individual indexes would work better in a single group-by afaict.