Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 22 May 2001 @ 00:47:14 GMT


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


Subj:   Re: Monitoring long-running queries
 
From:   Eric J. Kohut

Helen,

If this is the case and you didn't really define the Primary Index columns then it chose to use the first column by default which is probably very skewed.

If you did specify a Primary index like your last SQL, then I can't see the problem, but it might show up in the explain.

Good Luck,

Eric

EJK
Eric J. Kohut
Senior Solutions Consultant - Teradata Solutions Group - Retail
Certified Teradata Master
NCR Corp.



     
  <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