Home Page for the TeradataForum
 
https:

Archives of the TeradataForum

Message Posted: Tue, 03 Sep 2013 @ 16:17:58 GMT


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


Subj:   Re: Query on performance degradation
 
From:   Sughesh.Sumansingh

Hi John,

As you are putting filter, less records will come to spool and performance will get improved.

Even if output is same, query will run faster in second.

You can check the same in explain plan as well.

But as you are putting into a temp table (GTT, DT or VT), the temp table creation time and time to insert records also should be considered.

In this case as you are small number of records, temp table creation may not give any improvement as total of all above time considered with time of execution of old query.

But if you are applying this logic with some millions of records, you can see a considerable improvement in performance with second scenario.

If you are considering only time to execute the main query, second will perform faster.


Thanks,

Sughesh.



     
  <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: 24 Jul 2020