Archives of the TeradataForum

Message Posted: Thu, 13 Mar 2003 @ 08:50:07 GMT


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

Michael Larkins wrote:

The following is exactly what "Teradata SQL - Unleash the Power" says:

Here are some excellent guidelines on what you should collect statistics on:

. All Non-Unique indices

. Non-index join columns

. The Primary Index of small tables

. Primary Index of a Join Index

. Secondary Indices defined on any join index

. Join index columns that frequently appear on any additional join index columns that frequently appear in WHERE search conditions

. Columns that frequently appear in WHERE search conditions or in the WHERE clause of joins

And this happens to be the same in the Teradata manuals ;-)

Dieter


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

Archives

2003 Indexes

Last Modified: 15 Jun 2023