Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 09 Jan 2012 @ 15:48:59 GMT


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


Subj:   Re: What is the purpose of PARTITION BY CASE_N
 
From:   Swartzbaugh, Jason

PARTITION BY RANGE_N is probably the more commonly used partitioning expression, but CASE_N is used to define a partitions on data based on an associated condition. It's similar to the CASE expression used in SQL statements.

You probably want to check out the Teradata Database Design manual and look at the section titled "Considerations for Basing the Partitioning Expression on the CASE_N function" section.


Regards,

Jason Swartzbaugh
Solution Architect
Teradata Government Systems



     
  <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