Re: SQL prodecure to compute ranking

"Dave Nespoli" <davenespoli_at_hotmail.com> wrote in message news:953a2bc3.0209110750.4a52b98c_at_posting.google.com...
> Analytic functions do the job, but is is possible to index of them?
> They will only be useful if we could build an index which will make
> the execution time quick. I've tried, but it seems it's not allowed.
> Any ideas?

If you have a conventional index on the relevant columns (score?) I'd expect the analytic function to whizz by.

--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************

NB Whizz is a technical term meaning somewhat faster than the non analytic
alternative.