Parallel Transporter uses more spool than other types of sessions.

Tools & Utilities
Enthusiast

Parallel Transporter uses more spool than other types of sessions.

Any idea why TPT is using more spool than the same query in other tools such a SQL Assistiant?
1 REPLY
Enthusiast

Re: Parallel Transporter uses more spool than other types of sessions.

The question is not very clear. What is the query you submitted ? Which operator are you using in your TPT script ?

If you are using update operator, then it will use more spool space because the protocols between SQLA and Update operator are different.