| Subject | Re: [IBO] Help04. Nested SELECT statements in TIB_Query: PLANs |
|---|---|
| Author | Svein Erling Tysvaer |
| Post date | 2002-10-14T14:27:20Z |
At 23:22 14.10.2002 +0930, you wrote:
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.
Set
>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 beingI'm not quite familiar with the SQLPlan property, but if it is the same as
>used: one for
>the main SELECT and one each of for 2 sub-SELECTs?
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.
Set