CD

Cloudflare Developers•3y ago

elithrar

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

Use indexes · Cloudflare D1 docs

Indexes enable D1 to improve query performance over the indexed columns for common (popular) queries by reducing the amount of data (number of rows) …