Re: Creating an index on a view

From: matthew <rogel_at_web.de>
Date: 13 Oct 2005 06:20:47 -0700
Message-ID: <1129209647.228379.297000@g43g2000cwa.googlegroups.com>

Paul wrote:
> Thanks for the response Tony, I thought I had tried this but obviously
> not in the correct way. I now have another issue. The function is not
> deterministic and so cannot be indexed. However, I read that you can
> just tell Oracle the function is deterministic and so I have done this
> and everything appears fine. I am not too happy about this solution
> though.
>
> Does anybody have any thoughts on this?
>
> Thanks
>
> Paul

any thoughts ?
I would not be happy, too
that's for sure

I expect funny (non-deterministic) things to happen Received on Thu Oct 13 2005 - 08:20:47 CDT