Re: optimizer: GROUP BY unnessesary slow using ANSI notation for redundant group by's.

Hi! On Jan 24, Stefan Traby wrote: > Hi ! > > For my forum system, I use the following query to generate the > main-overview: (using 4.0.16-log) > > select f1.id as BoardId, >f1.name as Board, >f1.more as BoardDesc, >f2.id as AreaId, >f2.name as Area, >f2.

optimizer: GROUP BY unnessesary slow using ANSI notation for redundant group by's.

Hi ! For my forum system, I use the following query to generate the main-overview: (using 4.0.16-log) select f1.id as BoardId, f1.name as Board, f1.more as BoardDesc, f2.id as AreaId, f2.name as Area, f2.more as AreaDesc, count(distinct f3.id) as ThemenC