SQL Server 數(shù)據(jù)庫管理系統(tǒng)上的SQL查詢優(yōu)化
9900多字 21頁
包括中英文翻譯


摘要
人們在使用SQL時往往會陷入一個誤區(qū)，即太關(guān)注于所得的結(jié)果是否正確，而忽略了不同的實現(xiàn)方法之間可能存在的性能差異，這種性能差異在大型的或是復雜的數(shù)據(jù)庫環(huán)境中（如聯(lián)機事務(wù)處理OLTP或決策支持系統(tǒng)DSS）中表現(xiàn)得尤為明顯。不良的SQL往往來自于不恰當?shù)乃饕O(shè)計、不充份的連接條件和不可優(yōu)化的where子句。在對它們進行適當?shù)膬?yōu)化后，其運行速度將有比較明顯的提高。
為了最有效地優(yōu)化 Microsoft SQL Server 的性能，您必須明確在哪些方面性能可以得到最大程度的改進，并集中分析這些方面。否則，您在這些問題上可能花費大量的時間和精力，而并不能得到明顯的性能上的提高。
設(shè)計一個應(yīng)用系統(tǒng)似乎并不難，但是要想使系統(tǒng)達到最優(yōu)化的性能并不是一件容易的事。在開發(fā)工具、數(shù)據(jù)庫設(shè)計、應(yīng)用程序的結(jié)構(gòu)、查詢設(shè)計、接口選擇等方面有多種選擇，這取決于特定的應(yīng)用需求以及開發(fā)隊伍的技能。
關(guān)鍵詞：SQL Server數(shù)據(jù)庫 性能優(yōu)化 查詢
數(shù)據(jù)查詢 查詢效率 安全性



ABSTRACT

People will often fall into a ill idea while using SQL, namely it is correct to pay close attention to the result to the income very much, and has neglected the performance difference that may exist between different implementation methods , this kind of performance difference behaves particularly obviously in the large-scale or complicated database environment (such as on-line transaction processing OLTP or DSS ). I find bad SQL come from appropriate index design , fill connection terms and where clause that can't be optimized of copy often among working practice. After carrying on proper optimization to them, its speed of operation improves obviously!
In order to optimize the performance of Microsoft SQL Server most effectively, you must define in which respects performance can get maximum improvement , concentrate on analysing these respects. Otherwise, you are on these questions may spend a large amount of time and energy , but can not receive the improvement on obvious performance .
It seems easy to design a application system, but it is not an easy thing to want to make the system reach the performance optimized most. Respect of choosing on developing instrument , database design , structure , inquiry design , interface of the application program etc. has excellent choices, this depends on specific application demand and develops the skill of the team .
Keyword: SQL Server database Performance optimizing Inquiry Data inquiry Inquire about efficiency Security






目 錄
摘 要-------------------------------------------------------------------------------------------1
ABSTRACT-----------------------------------------------------------------------------------2
第一章 綜述 (緒論) ------------------------------------------------------------------------4
1.1 引言----------------------------------------------------------------------------------4
1.2 數(shù)據(jù)庫優(yōu)化概述---------------------------------------------------------------------8
第二章 設(shè)計數(shù)據(jù)庫-------------------------------------------------------------------------8
2.1 熟悉業(yè)務(wù)系統(tǒng)----------------------------------------------------------------------- 9
2.2 規(guī)范化與逆規(guī)范化------------------------------------------------------------------10
2.3 選擇數(shù)據(jù)類型---------------------------------------------------------------------------------10
2.4 選擇索引---------------------------------------------------------------------------------------14
第三章 查詢優(yōu)化----------------------------------------------------------------------------15
3.1 主鍵---------------------------------------------------------------------------------------------15
3.2 通配符------------------------------------------------------------------------------------------19
3.3 視圖---------------------------------------------------------------------------------------------19
3.4 存儲過程---------------------------------------------------------------------------------------20
第四章 總結(jié)----------------------------------------------------------------------------------21
致謝-------------------------------------------------------------------------------------------- 21