Archives of the TeradataForum

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

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

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>>