Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Wed, 17 Jul 2002 @ 18:41:27 GMT


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


Subj:   MultiStatements
 
From:   Santosh X Narayan

I need to update around 2500 rows, in a single shot from VB through ODBC(sent as calls to Upsert Macros). One option I am investigating is using MultiStatements (i.e. putting each statement in a new line beginning with a semicolon).

However, when I tried to execute with or without the semicolon, there didnt seem to be any performance difference.

How can I ascertain that the query will be executed in parallel? Is there any limitation (a) in the number of statements? (b) length of string that the ODBC connection can handle.

What are your suggestions regarding obtaining optimum performance?


Thanks in Advance!

Santosh



     
  <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