|
|
Archives of the TeradataForum
Message Posted: Tue, 27 Nov 2007 @ 23:05:35 GMT
Subj: | | Re: Statistics in BT; ET; |
|
From: | | Christie, Jon |
Hmmm... Even with the DDL -> DML shift you won't be able to get the benefit of the freshly collected stats in a multi-statement request.
Why? Because the optimizer builds a plan for all of the statements in the multi-statement request before the first step is sent off to the
dispatcher. Explain a multi-statement request. You'll see what I mean.
To get a benefit, you'll have to code explicit BT and ET.
| |