DeepSeek-V3 Domain Vocabulary Anchoring With Few-Shot

On non-reasoning models like DeepSeek-V3, providing 2 to 5 worked few-shot examples remains highly valuable when the task uses domain-specific vocabulary or an unusual output format, putting your strongest, most representative example first.

Example 1 (Strongest Representative): Input: "SELECT * FROM orders WHERE status = 'pending'" -> Index Recommendation: CREATE INDEX CONCURRENTLY idx_orders_status_pending ON orders (created_at) WHERE status = 'pending'; Example 2: Input: "SELECT id FROM users WHERE lower(email) = $1" -> Index Recommendation: CREATE UNIQUE INDEX CONCURRENTLY idx_users_email_lower ON users (lower(email)); Task: Provide the exact PostgreSQL index recommendation for: {{SQL_QUERY}}