Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
execute parallel in queryman
- Thread starter bkj123
- Start date
It's the same as a multistatement in BTEQ, just search for multistatement in SQL Manual, Vol. 1
A typical example is several Insert/Selects into an empty table: If you use seperate requests, the first one will be fast, because the table is empty and the insert will need no Transient Journal. But the next Insert is into a table with data, so it's using the TJ.
If you use a multistatement instead *all* Inserts run without TJ.
Dieter
A typical example is several Insert/Selects into an empty table: If you use seperate requests, the first one will be fast, because the table is empty and the insert will need no Transient Journal. But the next Insert is into a table with data, so it's using the TJ.
If you use a multistatement instead *all* Inserts run without TJ.
Dieter
- Status
Similar threads
- Locked
- Question
- Locked
- Question
