Non permanent tablespace is a particular kind of tablespace that’s used to retailer short-term knowledge. This knowledge is usually created through the execution of a question and is deleted when the question is full. Non permanent tablespaces are sometimes used to retailer intermediate outcomes or to retailer knowledge that’s not wanted completely.
There are a number of advantages to utilizing short-term tablespaces. First, they’ll enhance the efficiency of queries by lowering the quantity of knowledge that must be learn from disk. Second, they will help to scale back the quantity of reminiscence that’s utilized by a database server. Third, they’ll make it simpler to handle knowledge that’s not wanted completely.