There are three important spaces:
Permspace : Permanent space for storing objects (users,tables, permanent journals,secondary indexes...etc) . Permanent space always specifies upper limit of the space can be used by database or user.
Spool Space : Space required to run queries. spool is calculated on user basis. It specifies upper limit of space can be used to run his sql queries. it comes from unused permanent space from entire system. As long as there is unused perm space in the system , spool space is available.
Each user have a limit saying how much spool space he can use for his queries.
It also calculated on per AMP basis
Temp Space : For Global Temporary Tables while running queries
No comments:
Post a Comment