Usage of Spool?

Database
Enthusiast

Usage of Spool?

Hi All,

Lets say i have a view like

create view view1 as

sel * from  tab1 inner join tab2 loj tab3;

When user A hits this view, the spool required for the operation "sel * from  tab1 inner join tab2 loj tab3" is taken from user A  or by some other means??

Tags (2)
2 REPLIES
Senior Apprentice

Re: Usage of Spool?

Spool usage for any query will always be based on the submitting user.

Dieter

Enthusiast

Re: Usage of Spool?

Thanks Dieter :)