Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 28 Aug 2008 @ 17:08:23 GMT


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


Subj:   Re: Running query without using partition on a partition defined column
 
From:   Curley, David

If you can supply even one fixed date against the PPI table it would help. For example, if the PPI table goes back three years and the other table only three months, put in the SQL that the partitioning column is >= 4/1/2008. You can't always do this, but anything you can do to let the optimizer eliminate partitions will help.

If you can, read the Orange Book on PPI Usage - there's a table in it with examples of query speed against non-PPI and different-grained PPI tables. You can get a pretty good sense of how you're hurt by not specifying values against the partitioning column.


Dave



     
  <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