|
|
Archives of the TeradataForum
Message Posted: Thu, 04 Aug 2005 @ 07:44:26 GMT
Subj: | | Re: Subquery in Explain |
|
From: | | Victor Sokovin |
| Subquery is not straight away identified in the explain. You should go by the tables and conditions in the subquery and see how it is being
processed by the optimizer. Optimizer tries different ways of processing a subquery depending on the subquery conditions. | |
The optimizer might even rewrite the query and turn the subquery into a join or something. There seems to be more and more formal algebra
applied to queries with every new release. I wonder if there is any way of digging up that final internally rewritten query.
Regards,
Victor
| |