Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 26 Jul 2006 @ 14:19:25 GMT


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


Subj:   Re: Macro call from JDBC for Tactical Queries
 
From:   Mohommod.Khan

David, I am little confused as to why you will have to use the temp table....If I follow you , what it is doing is to empty the temp table , inserting your desired record and finally reading it that you show using the application interface. Can this not be done using a view or a derived table that you can tune for performance? Have you thought about it? Now if you do need to store the reultset for the application side for whatever the reason can you not do that within the Java application instead of doing it on the DBMS? It may be little faster and better way. Sorry if I have not followed the original thread. 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: 15 Jun 2023