1-- Composite index for visitUniqueFromSummary: filters by (user_id, host, visit_date)
2CREATE INDEX IF NOT EXISTS idx_monthly_visits_user_host_date
3ON analytics_monthly_visits (user_id, host, visit_date);
4
5-- Covering index for visitHostFromRaw: filters by (user_id, created_at), groups by host, counts distinct ip_address
6CREATE INDEX IF NOT EXISTS idx_analytics_visits_user_created_host_ip
7ON analytics_visits (user_id, created_at, host, ip_address);