Smalyshev added a project: WDQS-Optimizer.
TASK DETAILhttps://phabricator.wikimedia.org/T166139EMAIL PREFERENCEShttps://phabricator.wikimedia.org/settings/panel/emailpreferences/To: SmalyshevCc: abian, Base, PokestarFan, Smalyshev, Aklapper, Lucas_Werkmeister_WMDE, Jonas, Lahi, Gq86,
Lucas_Werkmeister_WMDE added a comment.
Strange… I had the impression that named subqueries are typically faster, but in this case it doesn’t seem to make much of a difference. I ran both versions 100 times (P5706), and while regular subqueries have a few slow outliers, overall they seem to