Re: SQL prodecure to compute ranking

From: gary gibbons <aalegrias_at_yahoo.com>
Date: 11 Sep 2002 08:34:26 -0700
Message-ID: <900c6d6a.0209110734.1c472327@posting.google.com>

I have the impression that you cannot use indexes on the analytic RANK function Is this not true?

thanks

gary gibbons

Galen Boyer <galenboyer_at_hotpop.com> wrote in message news:<u65xd1413.fsf_at_hotpop.com>...
> On Wed, 11 Sep 2002, richard.foote_at_bigpond.com wrote:
> > Hi Galen,
> >
> > Yeah they do, but they also hurt my head trying to worked them all
> > out. Sum and Avg I can cope with but anything else and I just go ga ga
> > ...
>
> Keep on working. They are definitely worth the headaches.
Received on Wed Sep 11 2002 - 10:34:26 CDT