Parallel Transporter uses more spool than other types of sessions.

Tools
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.