"Speak in a moment of anger and you'll deliver the greatest speech you'll ever regret."
There are three types of temporary tables available within Netezza. All of which have advantages over traditional temporary tables.
Derived tables are always local to a single SQL request. They are built dynamically using an additional SELECT within the query. The rows of the derived table are stored in swap and discarded as soon as the query finishes. The DD has no knowledge of derived tables. Therefore, no extra privileges are necessary. Its space comes from the users swap space.
Temporary tables are local to a session rather than a specific query. This means that the table ...