Sybase数据库的存储过程性能优化

存储过程中经常会用到游标,用等价的SQL语句来巧妙替换带游标的循环过程,可以显著提高存储过程的性能.12.0版以上Sybase数据库中新支持的CASE语句可以用来构造等价替换游标的高效率SQL语句.CASE语句的语法简单,但用它替换游标富有技巧性,举出两个具体实例.最后,概要提到其他一般的SQL语句优化技巧.

Optimzing performance of Sybase stored procedure

The Cursors was usually used in stored procedure, but if it was replaced the loop block of the cursor with equivalentSQL sentence, the performance of stored procedure would be increased remarkably. The up-to-date CASE sentence of SybaseAdaptive Database Server above version 12 could construct efficient SQL sentence to replace cursor. The syntax of CASEsentence was simple, but using it to replace cursor was skillful, there were two examples in the article to describe this. At theend of the article, it was listed the general skill of optimize SQL.