阅读背景:

比较存储过程性能ex和新版本

来源:互联网 

I did create two new indexes on the tables that are used on a the sp. The new results shows that on the part of problematic joins, the scans are converted to seek. I think seek is better rather than scan operations. On the other hand, the time takes more or less the same duration as it was without new indexes.I did create two new indexes on the tables that




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: