 |
 |
Archives of the TeradataForum
Message Posted: Thu, 02 Oct 2003 @ 10:53:33 GMT
| Subj: | | Re: Derived Tables in V2R5 |
| |
| From: | | Dieter Noeth |
Howard Bradley wrote:
| | The GSC have said that Derived tables are now treated in the same way as VIEWS (sorry if I have over simplified this) and
therefore it is working as designed. | |
Maybe it's working as designed, but *not* working according to SQL:1999 or SQL92. A Derived Table or View must *behave* as
if it was materialized, the optimizer is trying to optimize too much, so it's a bug ;-)
Dieter
| |
