What AQE Actually DoesSpark · medium · ~10 minThe same nightly job runs on two clusters: staging (AQE enabled) and prod (AQE disabled, 'we don't trust new features'). Staging finishes in 22 minutes; prod takes 71 and occasionally OOMs. The SQL is identical. The team asks you to explain the difference precisely — and whether prod should trust it.Evidence

Plan Diff (staging vs prod)

Config

Checkpoints

What are the THREE AQE behaviors visible in the plan diff?

Why could the static (non-AQE) planner not make these calls?

Should prod enable it? Give the senior recommendation including what AQE does NOT fix.