On Tue, Feb 18, 2003 at 10:26:46 +0600,
  Anuradha Ratnaweera <[EMAIL PROTECTED]> wrote:
> My 3rd attempt to post ...
> Consider this query on a large table with lots of different IDs:
>     SELECT id FROM my_table GROUP BY id ORDER BY count(id) LIMIT 10;
> It has an index on id.  Obviously, the index helps to evaluate count(id)
> for a given value of id, but count()s for all the `id's should be
> evaluated, so sort() will take most of the time.
> Is there a way to improve performance of this query?  If not, please
> give some indication to do a workaround on the source itself, so perhaps
> I may be able to come out with a patch.

In 7.4 there is a hash method that can be used for aggregates. This
may help a lot in your case if there aren't a lot of distict IDs.
7.4 is a long way from even a beta, but you still might want to play with
it to see if it will solve your problem down the road.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])

Reply via email to