Recommend indexes for this query pattern based on examples. Examples: Query: SELECT * FROM orders WHERE user_id = ? AND status = ? ORDER BY created_at DESC Index: CREATE INDEX idx_orders_user_status_created ON orders(user_id, status, created_at DESC) Rationale: Composite covers filter + sort, user_id first for selectivity Query: SELECT COUNT(*) FROM events WHERE timestamp > ? AND event_type IN (?) Index: CREATE INDEX idx_events_type_timestamp ON events(event_type, timestamp) Rationale: Type first for IN clause efficiency, timestamp for range scan Query pattern: {{query}} Table schema: {{schema}} Expected cardinality: {{cardinality}} Recommend index with rationale.
Database Index Recommendation
Recommend database indexes based on query patterns using examples.
40 copies0 forks
Share this prompt:
Details
Category
CodingUse Cases
Index design guidanceQuery optimization supportDatabase performance tuning
Works Best With
claude-opus-4.5gpt-5.2gemini-2.0-flash
Created Updated Shared