Tom大师的oracle优化法则
• You should do it in a single SQL statement if at all possible. And believe it or not, it
is almost always possible.
• If you can’t do it in a single SQL Statement, do it in PL/SQL—as little PL/SQL as
possible! Follow the saying that goes “more code = more bugs, less code = less
bugs.”
• If you can’t do it in PL/SQL, try a Java stored procedure. The times this is
necessary are extremely rare nowadays with Oracle9i and above.
• If you can’t do it in Java, do it in a C external procedure. This is most frequently
the approach when raw speed or using a third-party API written in C is needed.
• If you can’t do it in a C external routine, you might want to seriously think about
why it is you need to do it
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/12554513/viewspace-674858/ ，如需转载，请注明出处，否则将追究法律责任。
下一篇：
Tom大师性能分析常用包
请登录后发表评论
登录
全部评论
