Subject Re: [IBO] Help04. Nested SELECT statements in TIB_Query: PLANs
Author Raymond Kennington
Svein Erling Tysvaer wrote:
> At 23:22 14.10.2002 +0930, you wrote:
> >Is it possible to use nested SELECT statements in TIB_Query?
> Oh, yes, no problem.
> >If so, how does the SQLPlan property affect the query if 3 PLANs are being
> >used: one for
> >the main SELECT and one each of for 2 sub-SELECTs?
> I'm not quite familiar with the SQLPlan property, but if it is the same as
> is shown in IB_SQL after doing a prepare on the DSQL or cursor tab, then it
> first shows the plan for the subselects and below them the plan for the
> main statement. IB_SQL is a brilliant tool for checking your queries before
> they wreak havoc with your server.
So is SQLPlan something that I read and not something that I enter?
Raymond Kennington
Programming Solutions
W2W Team B