Temporary objects and access methods

Edit online

Temporary objects are created by the optimizer in order to process a query. In general, these temporary objects are internal objects and cannot be accessed by a user.

Table 1. Temporary object data access methods
Temporary create objects	Scan operations	Probe operations
Temporary hash table	Hash table scan	Hash table probe
Temporary sorted list	Sorted list scan	Sorted list probe
Temporary distinct sorted list	Sorted list scan	N/A
Temporary list	List scan	N/A
Temporary values list	Values list scan	N/A
Temporary row number list	Row number list scan	Row number list probe
Temporary bitmap	Bitmap scan	Bitmap probe
Temporary index	Temporary index scan	Temporary index probe
Temporary buffer	Buffer scan	N/A
Queue	N/A	N/A
Array unnest temporary table	Temporary table scan	N/A
Temporary Indexed List	Temporary Indexed List Scan and Index Merge	N/A
Window	Window scan	N/A