Oracle+SQL优化

《Oracle+SQL优化》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、OracleSQL语句优化整理：黄德承作者：Black_SnailOracleSQL优化目录目录........................................................................................................................................2第1章模块功能概要描述.....................................................................

2、..............................4第2章SQL语句编写注意问题..........................................................................................52.1ISNULL与ISNOTNULL....................................................................................52.2联接列...................

3、...................................................................................................52.3带通配符（%）的like语句..................................................................................62.4Orderby语句.....................................................

4、.................................................62.5NOT.........................................................................................................................62.6IN和EXISTS...........................................................................

5、.............................7第3章SQL语句性能优化..................................................................................................93.1选用合适的ORACLE优化器................................................................................93.2访问Table的方式.............

6、......................................................................................93.3共享SQL语句......................................................................................................103.4选择最有效率的表名顺序(只在基于规则的优化器中有效).............................113.5W

7、HERE子句中的连接顺序.................................................................................123.6SELECT子句中避免使用‘*’.............................................................................133.7减少访问数据库的次数...........................................................

8、.............................133.8使用DECODE函数来减少处理时间..................................................................143.9整合简单,无关联的数据库访问.........