Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 19 Nov 2008 @ 20:30:56 GMT

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

Subj:   Re: Stats collection on Index Column
From:   Singh, Lakhwant


I also thought the same thing as you have mentioned in your comments. But sometimes it really makes a difference and that difference can be seen in the EXPLAIN plans of various SQL's.

In fact I thought that collecting stats on UPI is also not required as it is always ONE AMP operation. But again, sometimes EXPLAIN shows the difference like "LOW CONFIDENCE" or "HIGH CONFIDENCE".

Lakhwant Singh
Certified Teradata SQL Specialist

  <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: 28 Jun 2020