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