← Back to team overview

maria-developers team mailing list archive

new histogram code in 10.0.10

 

Hi Sergei,

attached the results from a DBT3/SF30 run vs. 10.0.9 (as released) and
10.0-bzr rev 4128. Both runs use EITS + histograms. I see different
EXPLAIN plans for queries 2, 3, 5, 7, 8, 18 and 21. Execution times only
for few queries:

		10.0.9		rev4128
Q2		44,44,46	44,45,45
Q3		298,298,299	236,243,243
Q5		264,302,303	293,308,308
Q7		199,200,201	204,205,206
Q8		375,375,377	264,274,276
Q18		217,218,221	178,180,182
Q21		251,259,261	258,261,262

Details in attached zip file.


XL

Attachment: histograms_DBT3.zip
Description: Zip archive