Archives of the TeradataForum
Message Posted: Thu, 22 Jan 2004 @ 18:56:08 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 27 Dec 2016|