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

2004-01-25 Thread Sergei Golubchik
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.more as

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

2004-01-23 Thread Stefan Traby
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