Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Function based indexes?
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-lReceived on Tue Dec 06 2005 - 12:54:27 CST
![]() |
![]() |