-- Migration: 003_index_strategy
-- Description: Implementierung der Indexstrategie für Such- und Listenperformance

-- Index für help_requests Tabelle
CREATE INDEX idx_status_created_at ON help_requests(status, created_at DESC);
CREATE INDEX idx_requester_id ON help_requests(requester_id);

-- Index für offers Tabelle
CREATE INDEX idx_request_id_created_at ON offers(request_id, created_at DESC);
CREATE INDEX idx_helper_id_created_at ON offers(helper_id, created_at DESC);

-- Index für reviews Tabelle
CREATE INDEX idx_deal_id ON reviews(deal_id);
CREATE INDEX idx_reviewer_id ON reviews(reviewer_id);
CREATE INDEX idx_reviewee_id ON reviews(reviewee_id);