Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>   <<First <Prev

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.


Jason Swartzbaugh
Solution Architect
Teradata Government Systems

  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020