All models tested fell into three performance clusters: the top tier (82%-90% pass rate) includes Opus 4.8, GLM 5.2, and GPT 5.5 (specific configuration); the middle tier (71%-82%) includes Sonnet 4.6, Sonnet 5, and GPT 5.4; the low tier (51%-60%) includes GPT 5.4-mini and Haiku 4.5. Notably, cost is not linearly related to performance—many expensive configurations fall far below the Pareto efficiency line.
Further analysis showed that 61% of Databricks engineers' coding tasks are of medium complexity, with only 12% high complexity, yet previously the most expensive model was used by default. The company plans to route tasks to cheaper tiers based on complexity to optimize total cost. Additionally, token price does not equal actual task cost: token efficiency (e.g., 'token consumption per task') is crucial. In comparisons, Databricks' Pi toolchain sends about 3x less context than Claude Code, making Opus 4.8 2.08x cheaper in 'high effort' mode (85% pass rate vs 87%). GPT 5.5 shows a similar pattern: CodEX uses 1.235 million tokens, while Pi uses only 665,000.