Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 21 Mar 2002 @ 22:39:45 GMT


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


Subj:   Re: Large Table Join
 
From:   Glenn D. McCall

I am in a similar boat to Geoff, I actually tried this a long long long time ago. I had a table with approx 10 Million rows on a 70 AMP DBC-1012 runing V1r5 i think (I said this was a long long long time ago).

The test was as follows: Run a complex join against this table joining to a number of smaller tables. Split the table into approximately 2 equal halves and run the same query against the two "half tables". I tried both parallel (i.e. two querymans running the same query at the same time) and sequentially The end result was that the two half tables took about 20-30% longer than the one large table.

Disclaimer, this was on a DBC-1012 - things have moved on a long way since then.

I would suggest that you just try it - just like I did.

Good Luck

glenn Mc



     
  <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