You’d likely want a multi-column index - on both (id, created_at) - https://developers.cloudflare.co
You’d likely want a multi-column index - on both (id, created_at) - https://developers.cloudflare.com/d1/learning/using-indexes/#multi-column-indexes
Indexes enable D1 to improve query performance over the indexed columns for common (popular) queries by reducing the amount of data (number of rows) …
