Re: Tuning group by sql

Is the question why aren't your indexes used or why is the SQL so slow ? Previous posts explained that sometimes full table scans are actually required.

If you DON'T need the output of this "group by" SQL in a very timely fashion, consider using a snapshot. This would store the result set of your SQL in a real server object and then you could just use select * from <snapshot_object>.

We use many snapshots where data only has to be refreshed every 24 hours.

Cliff Received on Thu Feb 17 2000 - 00:00:00 CST