Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 22 Jan 2004 @ 18:56:08 GMT

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

Subj:   Re: Misunderstanding of join index
From:   Ballinger, Carrie


You are correct in your assessment.

The statement in the SQL documentation that says "Do not specify a WHERE clause for a single-table join index" is an error in the manual, a hangover from a previous release where that was true. If you are building single-table sparse join indexes, as Clay points out, you need and can use the WHERE clause.

This oversight has been corrected (removed) in future SQL Reference documentation. Check out the 5.1 edition, on page 1-186. It's not there.

Thanks, --Carrie

  <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: 27 Dec 2016