Subject SQL
Author nxciro

Fb 1.5.1

Do I have a better way to formulate this query
to speed things up ?

select distinct xrnd, count(xrnd) from t1
group by xrnd
order by count(xrnd) desc

there is an index for xrnd
the table currently has 6 million rows

this is the plan : PLAN SORT (SORT (SORT ((T1 NATURAL))))