Multistatement reqeusts: Pros and Cons?

Database
Enthusiast

Multistatement reqeusts: Pros and Cons?

Looking for some help from experts:

 

1. How is Multi statement request processed by Teradata (F6 in SQL Assistant and new statment right after the semicolon in BTEQ)

2. What are the advantages and disadvantages (if any) of a multistatment request... transient journal; are requests processed in parallel or sequentially etc?

3. Any documentation for further reading?

 

select ... from ...
;select .... from ...
;

 

Thanks

 

1 REPLY
Junior Contributor

Re: Multistatement reqeusts: Pros and Cons?

You will probably find answers to all your questions in the manuals Multistatement Requests

 

Btw, F6 is Explain, not Execute Parallel (F9)