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博客 ” ，链接：http://blog.itpub.net/12554513/viewspace-674858/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/12554513/viewspace-674858/