"Svein Erling Tysvaer" <svein.erling.tysvaer@...> wrote:

>
> I'm surprised that the reported plan
> was incomplete. I just checked through isql, and that tool didn't report
> the full plan either.

AFAIU, either the binary plan representation or the textual one couldn't fit
the passed buffer (depends on a tool, but not more than 64K) and some
entries weren't reported (isc_info_truncated is returned). Not a surprise
for some huge query. Often it causes no plan in the output at all, but if
there are subqueries then only some plan elements could be omitted.


Dmitry