All geek questions in one place

What are the options for using temporary tables in SQL database systems?

What are the main purposes for which temporary tables are used? I want to know the practical and commercial use of temporary tables in real programs running in small and large companies.

+3
source share
2 answers

In my experience, temporary tables are often used to store intermediate calculations in a complex series of CREATE or UPDATE queries that produce some kind of analysis result. An example would be to create pivot tables for an OLAP database.

Temporary tables are also sometimes used to improve performance in certain situations.

+4
source

CTE ( ) . .

+2

Source: https://habr.com/ru/post/1791639/

More articles:


All Articles