Database

[{"collection":"collection","count":25,"content":{"A":{"type":"int","max":5},"B":{"type":"int","max":5},"timestamp":{"type":"date","startDate":"2023-01-01T00:00:00Z","endDate":"2024-01-01T00:00:00Z"}},"indexes":[{"name":"a_ts","key":{"A":1,"timestamp":1}},{"name":"b_ts","key":{"B":1,"timestamp":1}}]}]

Query

db.collection.aggregate([{$match:{$or:[{A:3},{B:3}]}},{$sort:{timestamp:1}},{$limit:1000}]).explain()

Result