Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 25 Oct 2004 @ 17:31:28 GMT


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


Subj:   Re: Horizontal Rules Based partitions
 
From:   Claybourne Barrineau

Regds,

With the use of check constraints, the optimizer will only scan the required tables assuming the check constrain exists in the table (for instance, if month were part of your transaction table, and you placed a constraint on the month column, then (assuming you specified were month = 6, then the optimizer would ignore the other 11 tables and only scan the table with a check constraint of month = 6.) If you have to join to another table inorder to resolve days to months, then this feature will not work.

Another option would be to merge all twelve tables into a single table, add the month column (if it does not already exist), and use month as the partitioning column.


Hope this helps,

Clay

Claybourne L. Barrineau
Senior Application DBA
Coca-Cola Enterprises, Inc.



     
  <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