SQL 数据库系统中临时表的用例是什么? [英] What are the use cases for 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 uses of temporary tables in actual softwares working in small and large scale companies.

推荐答案

根据我的经验，临时表通常用于存储一系列复杂的 CREATE 或 UPDATE 查询中的中间计算，这些查询会产生某种分析结果.例如，为 OLAP 数据库创建汇总表.

In my experience, temporary tables are often used to store intermediate calculations in a complex series of CREATE or UPDATE queries that produce some sort of analysis result. An example might be the creation of summary tables for an OLAP database.

在某些情况下，有时也会使用临时表来提高性能.

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

这篇关于SQL 数据库系统中临时表的用例是什么?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！