Re: performance regression, 7.2.3 -> 7.3b5 w/ VIEW

Am Mittwoch, 13. November 2002 07:22 schrieb Ross J. Reedstrom:
> Hey Hackers -
...
>
> CREATE VIEW current_modules AS
>        SELECT * FROM modules m
>               WHERE module_ident =
>                     (SELECT max(module_ident) FROM modules
>                             WHERE m.moduleid = moduleid GROUP BY moduleid);
>
...

I just wonder if you really need the GROUP BY. The subselect should return
exactly one row and so max does without GROUP BY: CREATE VIEW current_modules AS        SELECT * FROM modules m
     WHERE module_ident =                     (SELECT max(module_ident) FROM modules                             WHERE
m.moduleid= moduleid); 


Tommi

--
Dr. Eckhardt + Partner GmbH
http://www.epgmbh.de