PLAN has nothing to do with this.

Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

-- We may not have it all together --
-- But together we have it all --

----- Original Message -----
From: "hkuser2001" <ibo@...>
To: <IBObjects@yahoogroups.com>
Sent: Thursday, November 28, 2002 6:25 AM
Subject: Re: [IBO] skip metadata to increase remote speed?


> --- In IBObjects@y..., Raymond Kennington <progsol@c...> wrote:
> > > Can I make the Query to skip this? Becuase sometimes I only want
> to
> > > run a very simple query, I don't need these metadata. I am afraid
> my
> > > client will not accept the initial delay.
> > >
> >
> > Part of the delay is in determining the PLAN(s).
> >
> > Here's an idea that others will tell you not to do, but has cut the
> preparation-time of queries significantly for me
> > with IB 5.
> >
> > Work out the optimal PLAN for each query and provide it explicitly
> in the SELECT statement.
> >
> > To do this, start with the PLAN that is provided by the tool you
> are using to see what PLAN would currently be used.
> > Mostly, this is the correct PLAN to use. Try this and if it speeds
> up the preparation then use it.
> >
> > For complex queries with JOINs and nested SELECT statements the
> PLAN provided by the above step was sometimes completely
> > wrong (with IB5). Then you'll have to work them out by analysis of
> the JOINs and sub-SELECTs.
> >
> > Please post your results.
> > --
> > Raymond Kennington
> > Programming Solutions
> > W2W Team B
>
> I tried putting the PLAN into the SQL statement but it doesn't help.
> I believe the PLAN is not eating my time because it worked very fast
> locally. So I suspect it generate too many traffic when asking for
> metadata.
>
> Rgds,
> Michael