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 ...
You will probably find answers to all your questions in the manuals Multistatement Requests
Btw, F6 is Explain, not Execute Parallel (F9)