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

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Function based indexes?

Re: Function based indexes?

From: Jared Still <jkstill_at_gmail.com>
Date: Tue, 6 Dec 2005 18:52:13 +0000
Message-ID: <bf46380512061052y4efba93y7d8c20b6d1cf9a3@mail.gmail.com>


Have you tried it?

On 12/6/05, Rick Stephenson <RStephenson_at_ovid.com> wrote:
>
> Is there a way to create an index on a column and only index those where
> the value meets a certain expression? For example, if I have a numeric
> column, can I just have the index built for those values that equal 1? I
> don't query on any other value, so I don't want to consume the space for the
> other values. I am running EE 9.2.0.3.
>
>
>
> Thanks,
>
>
>
> Rick Stephenson
>
>
>

--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l
Received on Tue Dec 06 2005 - 12:54:27 CST

Original text of this message

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