15 lines
664 B
MySQL
15 lines
664 B
MySQL
|
-- 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);
|