Archives of the TeradataForum

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

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

Victor,

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>>