Re: how to tunnel very large table's group by statement!

Hi,

if you have to perfrom the query once, that define a large temp (sort area) and live with it, because it sounds that you need a full table scan and by using group by the database has to sort the result, that cost much of ressources.

If you need to perform the query more times, than think to create a materialized view.

Hope that will help, if not describe your situation in a better way.

so long
fari Received on Sun Jun 08 2003 - 05:55:54 CDT