临时表对提高数据库查询性能的分析

Analysis of Improving Query Function of Database by Using Temporary Table

以行为统计系统为例介绍临时表的使用,并与其他查询方式相比较,说明临时表在数据库查询中的优点及作用,得出了使用临时表可提高数据处理速度,降低设计难度,提高系统性能的结论。

The article takes behavior statistics system as an example to introduce the use of temporary table, and explain temporary table＇s advantages and functions in database by comparing with other query modes. Finally it concludes that using temporary table can speed data processing, reduce design difficulty and enhance system performance.