Re: Function based indexes?

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: RStephenson@xxxxxxxx
  • Date: Tue, 6 Dec 2005 18:52:13 +0000

Have you tried it?


On 12/6/05, Rick Stephenson <RStephenson@xxxxxxxx> 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

Other related posts: