It is not possible to use an analytic function
form as the definition of a function-based index
(if that was the intent of your question) because
the value returned by an analytic function is, in
general, dependent on the partitioning, ordering
and windowing, and a single new row of data in
the table could change the function value for every
row in the table.
--
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Next Seminar dates:
(see http://www.jlcomp.demon.co.uk/seminar.html )
____England______September 24/26, November 12/14
____USA__________November 7/9 (MI), 19/21 (TX)
The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
Dave Nespoli wrote in message
<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?
>
>-Dave (working with Gary on the problem)
Received on Thu Sep 12 2002 - 16:30:20 CDT
