Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 12 Mar 2003 @ 21:04:00 GMT


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


Subj:   Re: Stats on the PI
 
From:   Michael Larkins

Hi All:

We have never minded being quoted, when it is done correctly.

This is the problem with Anonymous posting, people can say incorrect things without concern for the truth.

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

If you are going to cite a source, please at least get it right.


Thanks,

Mike



     
  <Prev Next>   <<First <Prev Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016