Archives of the TeradataForum
Message Posted: Wed, 13 Jun 2007 @ 10:55:04 GMT
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,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|