All Forums Database
JOE RAMYA 2 posts Joined 05/13
28 May 2013
Need more information about the temporary data retrival of TERADATA views

I knew that TD Views aren't materialized,but, when we query a View where does the temporary data storage happens either in spool or in Temporary space?
Please guide me here!

Shelley 28 posts Joined 09/10
28 May 2013

the result set from the view and anything that happens during the processing of the view (aggregations, etc)  go into spool.
-- Shelley

JOE RAMYA 2 posts Joined 05/13
29 May 2013

Thx Shelly!

quest 20 posts Joined 12/09
06 Jun 2013

Temp space is primarily used by temporary tables which have a persistent definition in the Data Dictionary but within a given session. Once the session is over, they are discarded.
Now coming to your question. Since view (as mentioned by you are not materialized) don't have a definition in the data dictionary and are not persistent ( they are dynamic), it uses only spool space.
Always remember, work space or answer sets for any SQL always uses SPOOL space.

VBurmist 96 posts Joined 12/09
10 Jun 2013

If you would need materialization, then you could use either join indexes, or insert-select into regular tables (both use perm space).

You must sign in to leave a comment.