Sybase临时表技术的多层级应用研究

Study on multi levels application of Sybase temporary table technology

Sybase临时表用于存储过程或批命令中多个SQL语句间传递数据,可分解事务处理流程,减轻并发压力,改善查询性能。应用临时表,首先提倡多用,使编程思路清晰,优化处理性能;其次要巧用,大幅度提高存储过程执行速度;第3要注意临时表对存储过程预编译执行计划的影响,采用强迫执行计划的策略避免出现应用性能陡降的问题。对这3个层次的应用技术,本文结合实践,给出一些具体样例。

Sybase temporary table used between multiple SQL statements in the stored procedure or SQL batch to transfer data,could be decomposed processes,reduced concurrent pressure to improve query performance. First of all,it was promoted more use of temporary tables,cleared thinking programming ,and optimized processing performance. Second,it must good use temporary tables,so significantly improve that stored procedures and the execution speed. Third,it should pay attention to the impact of pre-compiled execution plan of stored procedure with temporary table,use specific measures to avoid steep drop application performance problems. According to the three levels applying technology,the paper given some actual example on the practice.