Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 18 Mar 2010 @ 19:18:02 GMT


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


Subj:   Partition on Char field
 
From:   Baig, Mohammad

Dear All,

I am trying to create a partition on char field. I did that using flowing query ,

     PARTITION BY RANGE_N(HASHBUCKET(HASHROW(index column))
                     BETWEEN 0 AND 65535 EACH 1024)

But when I am trying to use that partition it is not getting used.. it is getting used only when a single value is there in the where condition. But if I specify more values in where

It is not considering partitions, it is doing a all-rows scan could you please help me to understand this why it is behaving so??

     Sel * from 
       where index_column = b index_valueb

This works and only one partition is getting selected.

But

     Sel * from 
       where index_column in (b index_value1b , b index_value2b )

For this it is not taking two partitions it is doing a all-rows scan.. b 9


Thanks & Regards

Usman



     
  <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