Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 30 Mar 2000 @ 00:02:33 GMT

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

Subj:   Re: Re-designing Tables
From:   Richard K. Sumner


To amplify what Mark has sent you. There are secondary performance gains to consider in the choice of the primary index according to how you most often join the tables for reporting or queries. If you can select a like value for a primary index for two tables that you join frequently so that the records from each table hash to the same amp block (clustering your data) you will avoid at least one row redistribution during query. With tables as large as you have mentioned, this can vastly improve system performance.


Rick Sumner

  <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