The first query performs bad, so we added this index:
alter table DownloadConfirmation add index (downloadCompleted, platform, fulfillerId, executionId);
Afterwards the first query was pretty fast, but for the second one the unperformant index was used.
The first query performs bad, so we added this index:
alter table DownloadConfirm ation add index (downloadCompleted, platform, fulfillerId, executionId);
Afterwards the first query was pretty fast, but for the second one the unperformant index was used.