Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

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


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


Subj:   Re: 5728: Partitioning violation for table TARGET
 
From:   RAJESH JAIN

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020