| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Function based indexes
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C00CFA.14FD18E4
Content-Type: text/plain;
charset="iso-8859-1"
I'm sorry Helmut I do not have an answer for you.
I wanted to ask the list, has anyone successfully created a function-based index before? I tried to create one on a medium-sized table and it ran for hours and hours. (8.1.5, hp/ux), it was only UPPER(field_name). After watching that run I did not pursue it any further.
Man, Intermedia, fxn-idx's, OAS, all these mediocre-working things in Oracle are leaving a bad taste in my mouth.
-----Original Message-----
From: Helmut Daiminger [mailto:hdaiminger_at_vivonet.com]
Sent: Tuesday, August 22, 2000 5:12 PM
To: Multiple recipients of list ORACLE-L
Subject: Function based indexes
> Hi!
>
> This is 8.1.6 on AIX.
>
> Is there any way that I can put a function based index on
> this expression???
>
> ....
> where table.Closedstamp between
> GETSTOREDATESTR(table.Companyid,table.StoreLocid,'08/01/2000') AND
>
> GETSTOREDATE(table.Companyid,table.StoreLocid,TRUNC(TO_DATE
> ('08/01/2000','MM/DD/YYYY')+1))
>
> Or would it help to put a function based index on the two functions
> GETSTOREDATESTR and GETSTOREDATE.
>
>
> Thanks,
> Helmut
--
Author: Helmut Daiminger
INET: hdaiminger_at_vivonet.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
------_=_NextPart_001_01C00CFA.14FD18E4
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2650.12">
<TITLE>RE: Function based indexes</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>I'm sorry Helmut I do not have an answer for you. =
</FONT>
</P>
<P><FONT SIZE=3D2>I wanted to ask the list, has anyone successfully =
created a function-based index before? I tried to create one on a =
medium-sized table and it ran for hours and hours. (8.1.5, =
hp/ux), it was only UPPER(field_name). After watching that run I =
did not pursue it any further. </FONT></P>
<P><FONT SIZE=3D2>Man, Intermedia, fxn-idx's, OAS, all these =
mediocre-working things in Oracle are leaving a bad taste in my mouth. =
</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Helmut Daiminger [<A =
HREF=3D"mailto:hdaiminger_at_vivonet.com">mailto:hdaiminger_at_vivonet.com</A>=
]</FONT>
<BR><FONT SIZE=3D2>Sent: Tuesday, August 22, 2000 5:12 PM</FONT>
<BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT>
<BR><FONT SIZE=3D2>Subject: Function based indexes</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>> Hi!</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> This is 8.1.6 on AIX.</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> Is there any way that I can put a function =
based index on </FONT>
<BR><FONT SIZE=3D2>> this expression???</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> ....</FONT>
<BR><FONT SIZE=3D2>> where table.Closedstamp between</FONT>
<BR><FONT SIZE=3D2>> =
GETSTOREDATESTR(table.Companyid,table.StoreLocid,'08/01/2000') =
AND</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> =
GETSTOREDATE(table.Companyid,table.StoreLocid,TRUNC(TO_DATE</FONT>
<BR><FONT SIZE=3D2>> ('08/01/2000','MM/DD/YYYY')+1))</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> Or would it help to put a function based index =
on the two functions</FONT>
<BR><FONT SIZE=3D2>> GETSTOREDATESTR and GETSTOREDATE.</FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> </FONT>
<BR><FONT SIZE=3D2>> Thanks,</FONT>
<BR><FONT SIZE=3D2>> Helmut</FONT>
</P>
<P><FONT SIZE=3D2>-- </FONT>
<BR><FONT SIZE=3D2>Author: Helmut Daiminger</FONT>
<BR><FONT SIZE=3D2> INET: hdaiminger_at_vivonet.com</FONT>
</P>
<P><FONT SIZE=3D2>Fat City Network Services -- (858) =
538-5051 FAX: (858) 538-5051</FONT>
<BR><FONT SIZE=3D2>San Diego, =
California -- Public Internet =
access / Mailing Lists</FONT>
<BR><FONT =
SIZE=3D2>---------------------------------------------------------------=
-----</FONT>
<BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an =
E-Mail message</FONT>
<BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of =
'ListGuru') and in</FONT>
<BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB =
ORACLE-L</FONT>
<BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =
from). You may</FONT>
<BR><FONT SIZE=3D2>also send the HELP command for other information =
Received on Wed Aug 23 2000 - 07:02:58 CDT
 |
 |