基于ORACLE特性的SQL语句的分析及优化

ANALYSIS AND OPTIMIZATION OF SQL BASED ON THE FEATURES OF ORACLE

本文主要讨论了如何基于ＯＲＡＣＬＥ的特性对ＳＱＬ语句进行优化调整，并介绍如何利用诊断工具（ＥＸＰＬＡＩＮＰＬＡＮ）分析ＳＱＬ语句以提高其效率．

Based on the features of ORACLE, this paper discusses how to write optimal SQL statements and applications. It also describes how to use ORACLE performance diagnostic tools to identify inefficient statements in application.