Re: SQL prodecure to compute ranking

On 11 Sep 2002, davenespoli_at_hotmail.com wrote:
> 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?

You can use indexes on getting to the data quickly, but you can't create "function based index". You should be able to have a covered index used in satisfying the analytic function, but rarely are "facts" part of an index.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.