Group by count() and indexes

Поиск
Список
Период
Сортировка
Искать

Group by count() and indexes

От:
Anuradha Ratnaweera <anuradha@gnu.com>
Дата:

Consider the following query on a large table with lots of different
`id's:

    SELECT id FROM my_table GROUP BY id ORDER BY count(id) LIMIT 10;

It has an (usually unique) 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 work out a patch.

Thanks in advance.

	Anuradha

-- 

Debian GNU/Linux (kernel 2.4.21-pre4)

It is contrary to reasoning to say that there is a vacuum or space in
which there is absolutely nothing.
		-- Descartes

FAQ