Archives of the TeradataForum

Message Posted: Wed, 13 Jun 2007 @ 10:55:04 GMT

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

Dear John,

The row is assigned to a Partition based on the complete value of "store_id" column. If you do a substring or like function giving partial value to the optimizer then the optimizer cannot be sure in which partition the row will lie as partial value can be part of any partition. Therefore, the optimizer decides to do a Full table scan.

If that is what you do in most of your queries, see if you can decompose the column "store_id" and then redefine the partition or create 'valued ordered NUSI'.

With Thanks & Regards,

Rajesh Jain

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