Spool space in insert statement

General
General covers Articles, Reference documentation, FAQs, Downloads and Blogs that do not belong to a specific subject area. General-purpose Articles about everything and anything
Enthusiast

Spool space in insert statement

 

Hi,

 

If spool space for a user is reduced to 0 so it is possible for the user to run insert queries.

 

Thanks.

2 REPLIES
Teradata Employee

Re: Spool space in insert statement

INSERT VALUES normally does not require spool space, so would be possible even if the user's spool space limit was set to zero.

Enthusiast

Re: Spool space in insert statement

Thanks Fred for the details.

 

Is there any way of identifying which insert requires spool and which does not.