Archives of the TeradataForum
Message Posted: Wed, 30 Mar 2000 @ 00:02:33 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|