Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 08 Dec 2009 @ 16:00:32 GMT


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


Subj:   Re: Theoretical collection over collecting stats
 
From:   DWellman

Hi,

The query ** as written ** won't be optimised any differently with statistics or without them. As you've pointed out, if 'col1' is non-indexed then you're looking at an FTS to answer the query.

Although the estimated time and row count may change and the confience may change, the actual run-time won't change at all.

If the query joined 'tbl' with another table then collecting stats may change the access plan, it would depend on how many rows in 'tbl' had the required value.


Cheers,

Dave

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



     
  <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: 15 Jun 2023