Re: Function based indexes?
- From: Jared Still <jkstill@xxxxxxxxx>
- To: RStephenson@xxxxxxxx
- Date: Wed, 7 Dec 2005 01:36:08 +0000
I see you already have numerous replies.
(I have not had time to check email since this morning)
Nothing I can add to the voluminous suggestions you have received.
There is a relevant AskTom article for this IIRC, but I was unable to
find it earlier today. Perhaps a glass of Lagavulin will enhance my
search engine queries? :)
Jared
On 12/6/05, Rick Stephenson <RStephenson@xxxxxxxx> wrote:
>
> Yes, but did not get very far in my attempts. My ideas were not
> syntactically correct from the error messages I was getting, so I did not
> know if it was possible. I also tried searching google and asktom to see if
> I could get any light shed on the subject.
>
>
>
> Thanks for your concern,
>
>
>
> Rick Stephenson
>
>
> ------------------------------
>
> *From:* Jared Still [mailto:jkstill@xxxxxxxxx]
> *Sent:* Tuesday, December 06, 2005 11:52 AM
> *To:* Rick Stephenson
> *Cc:* oracle-l@xxxxxxxxxxxxx
> *Subject:* Re: Function based indexes?
>
>
>
> 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
>
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Other related posts:
