Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Creating an index on a view
Hi Tony
That's a good point. I believe that you have actually answered my original query so thankyou. I have to use a function in the view, but I cannot index it because it is a non-deterministic function.
The function I have given an example of above could be considered deterministic though I think.
I do not really understand what deterministic functions are or what they are used for as I have never used them before, maybe I should read up on them before posting again. But are you saying that Oracle will not actually bother to look up the data from the tables when the function is executed for the second time if I say it is a deterministic function? This seems wrong to me but then I admit I have not read up about these types of functions yet.
If you could offer any information then I would appreciate it, otherwise I will RTFM!
Thanks, Received on Thu Oct 13 2005 - 11:16:30 CDT
![]() |
![]() |