Re: QUERY TUNING
From: ddf <oratune_at_msn.com>
Date: Thu, 18 Dec 2008 08:47:04 -0800 (PST)
Message-ID: <7a89b27c-aeeb-4c76-9bc5-627147d5f0e4@m22g2000vbl.googlegroups.com>
Date: Thu, 18 Dec 2008 08:47:04 -0800 (PST)
Message-ID: <7a89b27c-aeeb-4c76-9bc5-627147d5f0e4@m22g2000vbl.googlegroups.com>
On Dec 18, 8:46 am, Mladen Gogala <mgog..._at_yahoo.com> wrote:
> On Thu, 18 Dec 2008 06:22:29 -0800, ddf wrote:
> > Why? What function are you using in your query? I see none.
>
> What do you think that "substr" is?
>
> --http://mgogala.freehostia.com
Something I missed, obviously. :)
However, the FBI isn't used if the query plans posted are, indeed, the query plans generated before and after the FBI was created. There is some other reason this query is performing poorly, and the plan won't show what that is.
David Fitzjarrell Received on Thu Dec 18 2008 - 10:47:04 CST