# The Multivac — Evaluation Report

**Evaluation ID:** EVAL-20260318-161904
**Date:** Mar 18, 2026
**Category:** code
**Question ID:** EVAL-20260318-161904

---

## Question

This SQL query takes 45 seconds on a table with 10M rows. Rewrite it to run in under 1 second. Explain your optimization strategy.

```sql
SELECT u.name, u.email,
       (SELECT COUNT(*) FROM orders o WHERE o.user_id = u.id) as order_count,
       (SELECT SUM(amount) FROM orders o WHERE o.user_id = u.id) as total_spent,
       (SELECT MAX(created_at) FROM orders o WHERE o.user_id = u.id) as last_order
FROM users u
WHERE u.created_at > '2024-01-01'
AND (SELECT COUNT(*) FROM orders o WHERE o.user_id = u.id) > 5
ORDER BY total_spent DESC
LIMIT 100;
```

Assume standard B-tree indexes on primary keys only. What indexes would you add?

---

## Winner

**GPT-5.4** (openrouter)
- Winner Score: 9.72
- Matrix Average: 8.27
- Total Judgments: 56

---

## Rankings

| Rank | Model | Provider | Avg Score | Judgments |
|------|-------|----------|-----------|----------|
| 1 | GPT-5.4 | openrouter | 9.72 | 7 |
| 2 | Claude Sonnet 4.6 | openrouter | 9.66 | 7 |
| 3 | MiniMax M1 | openrouter | 9.39 | 7 |
| 4 | MiniMax M2.7 | openrouter | 9.09 | 7 |
| 5 | MiniMax M2.5 | openrouter | 8.96 | 7 |
| 6 | MiniMax-01 | openrouter | 7.90 | 7 |
| 7 | MiniMax M2.1 | openrouter | 7.04 | 7 |
| 8 | MiniMax M2 | MiniMax | 4.41 | 7 |

---

## 10×10 Judgment Matrix

Rows = Judge, Columns = Respondent. Self-judgments excluded (—).

| Judge ↓ / Resp → | MiniMax M2.7 | MiniMax M2.5 | MiniMax M2.1 | MiniMax M2 | MiniMax M1 | MiniMax-01 | Claude Sonnet | GPT-5.4 |
|---|---|---|---|---|---|---|---|---|
| MiniMax M2.7 | — | 8.8 | 7.1 | 4.9 | 10.0 | 8.6 | 9.8 | 9.6 |
| MiniMax M2.5 | 10.0 | — | 6.5 | 4.5 | 9.6 | 8.3 | 10.0 | 9.8 |
| MiniMax M2.1 | 9.2 | 8.6 | — | 2.1 | 10.0 | 8.1 | 10.0 | 10.0 |
| MiniMax M2 | 9.4 | 10.0 | 7.8 | — | 9.8 | 8.4 | 10.0 | 9.6 |
| MiniMax M1 | 9.8 | 9.6 | 8.3 | 4.3 | — | 7.3 | 10.0 | 10.0 |
| MiniMax-01 | 9.8 | 9.6 | 8.6 | 7.6 | 9.8 | — | 10.0 | 9.8 |
| Claude Sonnet | 8.6 | 9.2 | 5.7 | 5.0 | 9.3 | 8.0 | — | 9.3 |
| GPT-5.4 | 7.0 | 7.0 | 5.2 | 2.5 | 7.2 | 6.6 | 7.8 | — |

---

## Methodology

- **10×10 Blind Peer Matrix:** All models answer the same question, then all models judge all responses.
- **5 Criteria:** Correctness, completeness, clarity, depth, usefulness (each scored 1–10).
- **Self-judgments excluded:** Models do not judge their own responses.
- **Weighted Score:** Composite of all 5 criteria.

---

## Citation

The Multivac (2026). Blind Peer Evaluation: EVAL-20260318-161904. app.themultivac.com

## License

Open data. Free to use, share, and build upon. Please cite The Multivac when using this data.

Download raw JSON: https://app.themultivac.com/api/evaluations/EVAL-20260318-161904/results
Full dataset: https://app.themultivac.com/dashboard/export