Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 17 May 1999 @ 18:45:54 GMT

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

Subj:   Re: Temporary tables for Microstrategy
From:   Eric J. Kohut

The reason for this approach was due to the way Teradata used to execute drop table.

This function used to be very expensive. A delete was much faster. This is why the MSI tool used this approach. It would delete all from the table but leave the table definition to speed up the queries(without the drop on 5-100 tables / Report at 2-25 seconds / drop on a busy system.)

Now that we have Volitile temp tables we should look into using these as an approach to this problem.



  <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