Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 30 Jan 2003 @ 17:42:34 GMT


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


Subj:   Hey
 
From:   Barbarick, Richard S

Clay,

I've had some small success with JOIN INDEXes. I tried a few HASH INDEXes to avoid some large table redistributions, but I couldn't get the optimizer to use them. So I went to a single table JOIN INDEX and was able to avoid redistribution on the mid-size table in the join. Given enough time, I'll get there.

For Crystal Enterprise, we are ending up writing our own front-end (JSP). Are you using the native Crystal front-end?

Richard Barbarick
BEST DW/DSS



     
  <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: 15 Jun 2023