Re: Function based index!

From: Jack <none_at_INVALIDmail.com>
Date: Tue, 26 Sep 2006 12:49:04 GMT
Message-ID: <4l9Sg.145$ls6.80@read3.inet.fi>

"sybrandb" <sybrandb_at_gmail.com> wrote in message news:1159270080.292125.225140_at_e3g2000cwe.googlegroups.com...
>
> Yossarian 99 wrote:
>> Jack wrote:
>>
>> > function-based index is only available in EE-version, at least it has
>> > been
>> > so, if not changed.
>>
>> I just succesfully created a FBI with 9.2 SE and 10.1 SE, does this mean
>> that the system allows me to create the index but it won't use it?
>>
>> --
>> yossarian99_at_operamail.com
>>
>> blind faith in your leaders or
>> in anything will get you killed
>
> Not the reply of Jack is incorrect.
> FBI are from 9i available in SE and EE
> in 8i in EE only, but 8i is desupported anyway, so that shouldn't be an
> issue.
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>

OK, that is true. Remembered that also after posting.

Just a curiois question:
If we are using function in a view, can we make an index or something like that?
OK, I figured at least one way, but not excatly what I wish to get. Received on Tue Sep 26 2006 - 07:49:04 CDT