Archives of the TeradataForum

Message Posted: Tue, 16 Dec 2003 @ 20:39:43 GMT


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

Subj:		Re: Collect Stats on Single Column SI

From:		Victor Sokovin

John,

When talking about a single-column index, then whether the collect statement is performed on the column or on the index, the two statements are effectively the same thing and whichever one you chose, it only needs to be done once.

There is a 'CREATE INDEX'-style syntax form for collecting statistics on indexes which takes into account such options as UNIQUE/ALL/ORDER BY. They are not available with the COLUMN version.

Ref: SQL Ref - Vol.4 (May 2003), B035-1101-122A, 3-16, p.504.

Regards,

Victor