Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Thu, 02 Jun 2005 @ 18:24:39 GMT

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

Subj:   Re: PPI table - empty partitions.
From:   Ballinger, Carrie

In the current software release there is no way for the optimizer to know that those are empty partitions. So there could be a greater risk of less than optimal query plans associated with a PPI table with lots of empty partitions. With join plans, in particular, you might not get the best plans.

In V2R6.1 you will be able to collect statistics at the partition level, which should make this situation better.

Thanks, - Carrie

  <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