RE: Function based indexes?

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

Other related posts: