Subject Re: [IBO] Help04. Nested SELECT statements in TIB_Query: PLANs
Author Svein Erling Tysvaer
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.