Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 18 Dec 2012 @ 14:18:42 GMT


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


Subj:   Re: Perf Issues in Empty partition Scan
 
From:   Newell, Ray

If the partitions are empty, there is nothing to scan. There is not reserved space for the empty partitions. But you should always collect stats on the keyword partition. It is very fast, and will tell the optimizer how many partitions are populated so the optimizer can be more aggressive in the plan it chooses.



     
  <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