本文提供了一种通过添加日志来定位SQL中高成本步骤的方法，并针对静态SQL和使用SESSION表的情况给出了具体的性能优化建议。
1. Add log for the sp and find which step has the high cost.
2. If the step is static sql use <<How to find the root cause of performance for SQL>> to found the root cause.
3. If the step is used SESSION table, we use tmp table replace the static table or there is a method that can get execute plan of SP include SESSION table.
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
