diff options
Diffstat (limited to 'backend/db/migrations/006_add_composite_index.sql')
| -rw-r--r-- | backend/db/migrations/006_add_composite_index.sql | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/db/migrations/006_add_composite_index.sql b/backend/db/migrations/006_add_composite_index.sql new file mode 100644 index 0000000..d3d378b --- /dev/null +++ b/backend/db/migrations/006_add_composite_index.sql @@ -0,0 +1 @@ +CREATE INDEX IF NOT EXISTS idx_articles_feed_read_id ON articles(feed_id, is_read, id DESC); |