Usage of Spool?

Database

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
N/A

Re: Usage of Spool?

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

Dieter

Re: Usage of Spool?

Thanks Dieter :)