mirror of
https://github.com/rzuasti/oott.git
synced 2026-07-08 19:21:54 +02:00
rzuastiandClaude Sonnet 4.6
40685837b0
Adds two indexes to eliminate full table scans at scale: - idx_notifications_created_on (created_on DESC) for purge and unfiltered listing - idx_notifications_is_new_created_on (is_new, created_on DESC) for filtered listing Co-Authored-By: Claude Sonnet 4.6 <noreply@anthropic.com>
3 lines
171 B
SQL
3 lines
171 B
SQL
CREATE INDEX idx_notifications_created_on ON notifications (created_on DESC);
|
|
CREATE INDEX idx_notifications_is_new_created_on ON notifications (is_new, created_on DESC);
|