Re: Prefetch

> Another trick you can use with large data sets like this when you want
> results
> back in seconds is to have regularly updated tables that aggregate the data
> along each column normally aggregated against the main data set.

> Maybe some bright person will prove me wrong by posting some working
> information about how to get these apparently absent features working.

Most people just use simple triggers to maintain aggregate summary tables...

Chris