max / balanced_breakfast

421 B · 10 lines History Blame Raw

1	-- Feature: Composite index for list-items-by-feed query
2	-- Replaces single-column idx_feed_items_feed_id with a composite index
3	-- on (feed_id, published_at DESC) to eliminate the sort step in:
4	-- SELECT * FROM feed_items WHERE feed_id = ? ORDER BY published_at DESC
5
6	DROP INDEX IF EXISTS idx_feed_items_feed_id;
7
8	CREATE INDEX IF NOT EXISTS idx_feed_items_feed_published
9	ON feed_items(feed_id, published_at DESC);
10