Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Fri, 25 Nov 2011 @ 21:54:46 GMT

  <Prev Next>   <<First <Prev

Subj:   Re: Stats on fields in where condition
From:   Dave Wellman


Sobhan makes a valid point. What have you tried ?

However, to answer your question you need to really compare explain plans before/after. Stats only help you if they change the structure of the explain plan. By structure I refer to the order in which tables are accessed, the join strategy that is used, which indexes are used.

Standard recommendations for stats include "collect on selection columns where the data values are skewed". Does this column meet that criteria? If not then they probably won't affect the performance of the query.



Ward Analytics Ltd - Information in motion (www.ward-analytics.com)

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