資源描述：
《Oracle+SQL優(yōu)化》由會(huì)員上傳分享，免費(fèi)在線閱讀，更多相關(guān)內(nèi)容在行業(yè)資料-天天文庫。
1、OracleSQL語句優(yōu)化整理：黃德承作者：Black_SnailOracleSQL優(yōu)化目錄目錄........................................................................................................................................2第1章模塊功能概要描述.....................................................................
2、..............................4第2章SQL語句編寫注意問題..........................................................................................52.1ISNULL與ISNOTNULL....................................................................................52.2聯(lián)接列...................
3、...................................................................................................52.3帶通配符（%）的like語句..................................................................................62.4Orderby語句.....................................................
4、.................................................62.5NOT.........................................................................................................................62.6IN和EXISTS...........................................................................
5、.............................7第3章SQL語句性能優(yōu)化..................................................................................................93.1選用合適的ORACLE優(yōu)化器................................................................................93.2訪問Table的方式.............
6、......................................................................................93.3共享SQL語句......................................................................................................103.4選擇最有效率的表名順序(只在基于規(guī)則的優(yōu)化器中有效).............................113.5W
7、HERE子句中的連接順序.................................................................................123.6SELECT子句中避免使用‘*’.............................................................................133.7減少訪問數(shù)據(jù)庫的次數(shù)...........................................................
8、.............................133.8使用DECODE函數(shù)來減少處理時(shí)間..................................................................143.9整合簡(jiǎn)單,無關(guān)聯(lián)的數(shù)據(jù)庫訪問.........
