Subject AW: [firebird-support] how to do a view (or work with) of top 80000 records
Author Alexander Gräf
> -----Ursprüngliche Nachricht-----
> Von: firebird-support@yahoogroups.com
> [mailto:firebird-support@yahoogroups.com] Im Auftrag von Ann
> W. Harrison
> Gesendet: Donnerstag, 23. Juni 2005 00:28
> An: firebird-support@yahoogroups.com
> Betreff: Re: [firebird-support] how to do a view (or work
> with) of top 80000 records
>
> Do you have any idea what the performance of that is likely to be?
>
> Regards,
>
>
> Ann

He will probably find out himself... Combining COUNT, GROUP BY with a join and a subselect is perhaps a bad idea :-)

Cheers, Alex