(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@(protected)> 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@(protected)] > *Sent:* Tuesday, December 06, 2005 11:52 AM > *To:* Rick Stephenson > *Cc:* oracle-l@(protected) > *Subject:* Re: Function based indexes? > > > > Have you tried it? > > On 12/6/05, *Rick Stephenson* <RStephenson@(protected)> 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
I see you already have numerous replies.<br><br>(I have not had time to check email since this morning)<br><br>Nothing I can add to the voluminous suggestions you have received.<br><br>There is a relevant AskTom article for this IIRC, but I was unable to <br>find it earlier today. Perhaps a glass of Lagavulin will enhance my <br>search engine queries? :)<br><br>Jared<br><br><br><div><span class= "gmail_quote">On 12/6/05, <b class="gmail_sendername">Rick Stephenson</b> < <a href="mailto:RStephenson@(protected)">RStephenson@(protected)</a>> wrote:</span ><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204 ); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
<div>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font -family: Arial; color: navy;">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.</span>< /font></p>
<p><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font -family: Arial; color: navy;">Thanks for your concern,</span></font></p>
<p><font face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial ;">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 <a href="http://9.2.0.3" target="_blank" onclick= "return top.js.OpenExtLink(window,event,this)">9.2.0.3</a>.</span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;">Rick Stephenson</span></font></p>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"> < /span></font></p>
</div>
</span></div>
<p><font face="Times New Roman" size="3"><span style="font-size: 12pt;"><br> <br clear="all"> <span class="q"><br> -- <br> Jared Still<br> Certifiable Oracle DBA and Part Time Perl Evangelist</span></span></font></p>
</div>
</blockquote></div><br><br clear="all"><br>-- <br>Jared Still<br>Certifiable Oracle DBA and Part Time Perl Evangelist<br>
