Re: Statistical Analysis

Nathan Barnett wrote:
>
> Stephan,
> The SORT is what I'm trying to avoid because I was using a group by to grab
> all the data in the groups that I needed, but it requires a sort to group by
> and this bottlenecked the query. I really just wanted to grab a sample of
> all the rows in the table and then perform the group by on the subset to
> avoid the overhead of sorting the whole table. My query has no where
> clauses and thus must sort through all of the data being analyzed. It then
> aggregates the data in a table that is then being used in the realtime
> queries. The analysis must be able to run every hour.

What about using random() in the WHERE clause?

Regards,
Andrew.
--
_____________________________________________________________________
Andrew McMillan, e-mail: Andrew(at)cat-it(dot)co(dot)nz
Catalyst IT Ltd, PO Box 10-225, Level 22, 105 The Terrace, Wellington
Me: +64 (21) 635 694, Fax: +64 (4) 499 5596, Office: +64 (4) 499 2267