Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 18 Dec 2012 @ 09:43:24 GMT


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


Subj:   Perf Issues in Empty partition Scan
 
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, December 18, 2012 04:29 -->

Dear Experts,

I have a table with many advanced [around more than 400] empty paritions on DATE_fld column. But when i give the condition 'DATE_fld >DATE' [current date], its obvious it will scan all post partitions after the date given. [My PPI is on DAY basis]

But is there any performance issues when the query scans a lots of empty partitions ?

I know that it might sometimes will mislead for making suboptimal plan choices. But still want other thoughts...



     
  <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