Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!news3.google.com!news.glorb.com!sn-xit-04!sn-xit-08!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.misc Subject: Re: Function based index not being used Date: Thu, 07 Jul 2005 20:17:23 -0700 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1120792649.117678@yasure> User-Agent: Mozilla Thunderbird 1.0.2 (Windows/20050317) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1120697080.070232.8250@g49g2000cwa.googlegroups.com> <1120708000.536299.266260@g47g2000cwa.googlegroups.com> <1120770733.918499.154780@o13g2000cwo.googlegroups.com> In-Reply-To: <1120770733.918499.154780@o13g2000cwo.googlegroups.com> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 17 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.misc:120378 bsandell@gmail.com wrote: > Hi Barbara, > > I really appreciate your help. I followed all of your suggestions, but > still got the same result. I guess I'll have to start decomposing the > user defined function and see if I can figure out what specifically is > causing the problem. Again, I apppreciate your time and insight. > > Bruce Build a simple FBI such as one that returns the constant 1 and see what happens. -- Daniel A. Morgan http://www.psoug.org damorgan@x.washington.edu (replace x with u to respond)