which currently result in a full table scan on a massive table:
select count(*) as aggregate from `transactions` where `type` = 'billed';
Details
Details
- Reviewers
machniak - Group Reviewers
Restricted Project - Commits
- rK4c0d021c28cb: Add an index to speed up count queries on transactions by type
Diff Detail
Diff Detail
- Repository
- rK kolab
- Lint
Lint Not Applicable - Unit
Tests Not Applicable
Event Timeline
| src/database/migrations/2025_06_04_100000_add_transactions_type_index.php | ||
|---|---|---|
| 17 | This does not make sense as there are no such columns. | |