Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 25 Mar 2004 @ 15:59:13 GMT

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

Subj:   Re: Syntax Error - Join Index
From:   Victor Sokovin

  I was going by an example on page 12-20 of one of the Database Design documents - it's doing a SUM on a column but doesn't have an alias. The CREATE JOIN INDEX syntax diagram in the DDL manual DOES show the alias, as you pointed out.  

  Just an inconsistency across documents, I guess.  


I agree that the Database Design is inconsistent as far as JI go. The document contains probably the most extensive discussion on JI but the examples ...

Speaking of 12-20, have you noticed that the first example in Sparse Join Indexes is totally wrong? Index J1 will not be used by the query which is mentioned in that example. I have notified NCR about this error and the example will be corrected in one of the subsequent releases. I hope your catch on correlation names in aggregation columns will also be taken on board.

In general, my practical strategy for reading the TD documentation is to start with the latest release (contains less errors with older features), not to get too excited about all the new features and then rewind back to the current release with appropriate changes. I don't know whether there is an online list of known errors in the documentation somewhere on ncr.com. I understand that changing the official documentation on a daily basis would be too expensive but maintaining such a separate list might be a possibility.



  <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: 15 Jun 2023