Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 29 Sep 2004 @ 13:58:40 GMT


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


Subj:   Extra secondary index on large table
 
From:   Anomy Anom

<-- Anonymously Posted: Wednesday, September 29, 2004 09:12 -->

Hi,

We have had a request from some of our Business Users to add an extra secondary index to one of our larger tables.

The table is 460gb in size, and we load approx. 15m rows at day to it. Loads are done throughout the day every 2 hours.

The table has a partitioned primary index on date, and also has 1 existing secondary index. There is also one Hash Index (6gb) and one Join Index (200gb) on the table.

We know there will be an overhead to adding another secondary index, but is it possible to estimate what this might be? Obviously, our ideal would be to copy the table, or even half of it, add the index and test both user queries and loads (we are worried our loads may slow down considerably), however, we do not have sufficient space on our system to do this at present.

Is there any other way of determing the impact?


Many thanks.



     
  <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