dataroom/prisma/migrations/20250624042156_viewers_performance_optimization/migration.sql

CREATE INDEX IF NOT EXISTS "View_viewerId_idx" ON "View"("viewerId");

CREATE INDEX IF NOT EXISTS "View_viewedAt_idx" ON "View"("viewedAt" DESC);

CREATE INDEX IF NOT EXISTS "View_viewerId_documentId_idx" ON "View"("viewerId", "documentId");

-- Index for viewer email search
CREATE INDEX IF NOT EXISTS "Viewer_email_prefix_idx" ON "Viewer"(lower("email") text_pattern_ops);

CREATE INDEX IF NOT EXISTS "Viewer_teamId_email_idx" ON "Viewer"("teamId", lower("email"));

-- Additional indexes for sorting optimization
CREATE INDEX IF NOT EXISTS "Viewer_teamId_createdAt_idx" ON "Viewer"("teamId", "createdAt" DESC);

CREATE INDEX IF NOT EXISTS "View_viewerId_viewedAt_idx" ON "View"("viewerId", "viewedAt" DESC) WHERE "documentId" IS NOT NULL;