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

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

Function based indexes?

From: Rick Stephenson <RStephenson_at_Ovid.com>
Date: Tue, 6 Dec 2005 11:45:02 -0700
Message-ID: <1281A180EA0BA140A960BE789EFAD2A80415E104@mx2003slc.wkhmr.loc> 





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

 



--
http://www.freelists.org/webpage/oracle-l


Received on Tue Dec 06 2005 - 12:47:19 CST












Original text of this message













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