Archives of the TeradataForum
Message Posted: Tue, 15 Jan 2002 @ 16:32:21 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|