Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 06 Jul 2005 @ 17:32:58 GMT


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


Subj:   Partitions and indexes
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, July 06, 2005 13:11 -->

Hi All,

I have 2 Qs regarding partitioning.

1. Why is it that a unique primary index cannot be defined if the partitioning column is not included as a part of the PI? I want to understand the "theory" behind this!!

2. Will range partition work only for dates?

a. How do we RANGE partition a set of integers between 1 and 100 in buckets of 10.(i know this can be done using case .. but can it be done through range??)

b. what is the correct way of partitioning character data. lets say i want all names between A and I in one part, J to P in another part etc.


Just asking as a matter of curiosity. I dont have a real world scenario at hand!

Thanks



     
  <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