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,
Received on Tue Aug 22 2000 - 12:51:11 CDT