Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Mon, 04 Nov 2002 @ 17:29:03 GMT


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


Subj:   Re: Secondary Indexes on an Active Data Warehouse
 
From:   Matthew Winter

Hi,

We presently use the FastLoad / Insert - Select method of data loading, as we perform transformations on Teradata before loading the data into the production tables.

We have never used Multiload, as we was advised not to.

Only recently we have been looking at optimising the warehouse for query performance, and therefore we have started to look into adding secondary indexes.

At present we would only like to add one secondary index to one of our largest tables, which we have proven in test will be used by the queries to a positive affect.

Unless we can overcome the performance problem of using secondary indexes, we will have to continue not to use them.


Regards

Matthew Winter

Technical Architect
TPG IS Design Authority
Teradata Certified Professional



     
  <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: 28 Jun 2020