Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Function based index!

Re: Function based index!

From: Robert Klemme <shortcutter_at_googlemail.com>
Date: Tue, 26 Sep 2006 13:27:21 +0200
Message-ID: <4nsh4pFbi9dfU1@individual.net>


On 26.09.2006 13:02, 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?

I guess not but you can easily verify with an execution plan.

        robert Received on Tue Sep 26 2006 - 06:27:21 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US