Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Sat, 28 Feb 2004 @ 19:03:20 GMT

  <Prev Next>   <<First <Prev Next> Last>>  

Subj:   Re: Derived tables on V2R5
From:   Victor Sokovin


  What do you mean by "new syntax"?  

  Derived tables have been part of SQL (at least) since SQL-92, but not part of Entry Level (Full Level in SQL-92).  

  Btw, in SQL:1999 it's still not part of Core SQL (Feature F591)  

I used the word "new" in the sense of something uncertain and controversial which divides opinions. I would also apply this word to such things as DAB or SACD. Although there are some people who have adopted them years ago, the majority would still know nothing about them.

Of course, the idea of unnamed views is not new. It is probably so simple that it is hard to say when it was coined for the first time. However, implementation of derived tables has take a surprisingly long time. For instance, Sybase has only introduced them in 12.5.1! There are still RDBMS which do not support this feature at all. Another property which is common for new features is marketing hype surrounding them, like magical performance improvement etc. That's why I'd call derived tables "new", but you decide for yourself.



  <Prev Next>   <<First <Prev Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 23 Jun 2019