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


摘要
人們?cè)谑褂肧QL時(shí)往往會(huì)陷入一個(gè)誤區(qū)，即太關(guān)注于所得的結(jié)果是否正確，而忽略了不同的實(shí)現(xiàn)方法之間可能存在的性能差異，這種性能差異在大型的或是復(fù)雜的數(shù)據(jù)庫(kù)環(huán)境中（如聯(lián)機(jī)事務(wù)處理OLTP或決策支持系統(tǒng)DSS）中表現(xiàn)得尤為明顯。不良的SQL往往來(lái)自于不恰當(dāng)?shù)乃饕O(shè)計(jì)、不充份的連接條件和不可優(yōu)化的where子句。在對(duì)它們進(jìn)行適當(dāng)?shù)膬?yōu)化后，其運(yùn)行速度將有比較明顯的提高。
為了最有效地優(yōu)化 Microsoft SQL Server 的性能，您必須明確在哪些方面性能可以得到最大程度的改進(jìn)，并集中分析這些方面。否則，您在這些問(wèn)題上可能花費(fèi)大量的時(shí)間和精力，而并不能得到明顯的性能上的提高。
設(shè)計(jì)一個(gè)應(yīng)用系統(tǒng)似乎并不難，但是要想使系統(tǒng)達(dá)到最優(yōu)化的性能并不是一件容易的事。在開(kāi)發(fā)工具、數(shù)據(jù)庫(kù)設(shè)計(jì)、應(yīng)用程序的結(jié)構(gòu)、查詢?cè)O(shè)計(jì)、接口選擇等方面有多種選擇，這取決于特定的應(yīng)用需求以及開(kāi)發(fā)隊(duì)伍的技能。
關(guān)鍵詞：SQL Server數(shù)據(jù)庫(kù) 性能優(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ù)庫(kù)優(yōu)化概述---------------------------------------------------------------------8
第二章 設(shè)計(jì)數(shù)據(jù)庫(kù)-------------------------------------------------------------------------8
2.1 熟悉業(yè)務(wù)系統(tǒng)----------------------------------------------------------------------- 9
2.2 規(guī)范化與逆規(guī)范化------------------------------------------------------------------10
2.3 選擇數(shù)據(jù)類(lèi)型---------------------------------------------------------------------------------10
2.4 選擇索引---------------------------------------------------------------------------------------14
第三章 查詢優(yōu)化----------------------------------------------------------------------------15
3.1 主鍵---------------------------------------------------------------------------------------------15
3.2 通配符------------------------------------------------------------------------------------------19
3.3 視圖---------------------------------------------------------------------------------------------19
3.4 存儲(chǔ)過(guò)程---------------------------------------------------------------------------------------20
第四章 總結(jié)----------------------------------------------------------------------------------21
致謝-------------------------------------------------------------------------------------------- 21