migrations/0002_add_indexes.sql 296 B raw
1
-- Add composite index for tie-breaking and efficient sorting
2
CREATE INDEX IF NOT EXISTS idx_scores_score_created
3
  ON scores (score DESC, created_at DESC);
4
5
-- Add index for player lookups (for potential future features)
6
CREATE INDEX IF NOT EXISTS idx_scores_player 
7
  ON scores (player_name);