Archives of the TeradataForum

Message Posted: Tue, 15 Jan 2002 @ 16:32:21 GMT

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

I'd advise the addition of 'NOT NULL' to the index columns in each of the table create statements.

This is designed to give the optimiser less work to do as it doesn't have to worry about the potential for nulls. It also precludes skewing on nulls.

Paul Johnson.

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