Muutke küpsiste eelistusi

Formal SQL Tuning for Oracle Databases: Practical Efficiency - Efficient Practice 1st ed. 2016 [Kõva köide]

4.00/5 (1 hinnangut Goodreads-ist)
, ,
  • Formaat: Hardback, 109 pages, kõrgus x laius: 235x155 mm, kaal: 454 g, 13 Illustrations, color; 55 Illustrations, black and white; XVI, 109 p. 68 illus., 13 illus. in color., 1 Hardback
  • Ilmumisaeg: 26-Sep-2016
  • Kirjastus: Springer-Verlag Berlin and Heidelberg GmbH & Co. K
  • ISBN-10: 3662504162
  • ISBN-13: 9783662504161
Teised raamatud teemal:
  • Kõva köide
  • Hind: 53,33 €*
  • * hind on lõplik, st. muud allahindlused enam ei rakendu
  • Tavahind: 62,74 €
  • Säästad 15%
  • Raamatu kohalejõudmiseks kirjastusest kulub orienteeruvalt 2-4 nädalat
  • Kogus:
  • Lisa ostukorvi
  • Tasuta tarne
  • Tellimisaeg 2-4 nädalat
  • Lisa soovinimekirja
Formal SQL Tuning for Oracle Databases: Practical Efficiency - Efficient Practice 1st ed. 2016Suurem pilt
  • Formaat: Hardback, 109 pages, kõrgus x laius: 235x155 mm, kaal: 454 g, 13 Illustrations, color; 55 Illustrations, black and white; XVI, 109 p. 68 illus., 13 illus. in color., 1 Hardback
  • Ilmumisaeg: 26-Sep-2016
  • Kirjastus: Springer-Verlag Berlin and Heidelberg GmbH & Co. K
  • ISBN-10: 3662504162
  • ISBN-13: 9783662504161
Teised raamatud teemal:
Püsilink: https://www.kriso.ee/db/9783662504161.html
Märksõnad:
The target of SQL tuning is the improvement of the existing execution plan. The authors discuss the removal of brakes in the execution plan. Such "brakes" or bottlenecks can be recognized by a formal analysis of the execution plan. For this purpose no data model knowledge is needed. This is especially beneficial for database administrators because they are usually not or insufficiently familiar with the data model. The book presents numerous practical examples with this method.

Prefaces.- Introduction.- Some thoughts concerning the term "SQL Tuning".- Minimum minimorum to the subject "Execution Plan".- Approaches to formal SQL Tuning.- Bottlenecks in Execution Plans.- Procedure for formal SQL Tuning.- Practical experiences with formal SQL Tuning.- Appendix.- Application of the formal method for analysis of performance issues following Oracle migration.
1 Introduction
1(4)
1.1 Aims and Target Groups
2(1)
1.2 An Overview of the Book
2(1)
1.3 Acknowledgments
3(2)
2 Some Thoughts on the Term "SQL Tuning"
5(6)
2.1 SQL Tuning: Definitions and Objectives
5(1)
2.2 SQL Tuners
6(5)
2.2.1 Oracle
6(2)
2.2.2 Developer
8(1)
2.2.3 Database Administrator
9(2)
3 Minimum Minimorum on the Subject of the "Execution Plan"
11(14)
3.1 Can You Read Execution Plans?
11(1)
3.2 Some Important Details
11(11)
3.2.1 Sections of the Execution Plan
12(8)
3.2.2 Optimizer Estimations and Costs
20(1)
3.2.3 Runtime Statistics
20(2)
3.3 Summary
22(3)
4 Approaches to Formal SQL Tuning
25(6)
4.1 The Objective: Effective SQL Tuning
25(1)
4.2 The Principle: Elimination of "Brakes" in the Execution Plan
26(1)
4.3 The Method: Analysis of Runtime Statistics in the Execution Plan
26(1)
4.4 The Main Criterion: The Runtime Statistic "Cardinality"
27(1)
4.5 The Procedure: An Iterative Process
28(1)
4.6 The Guideline: Tuning Without Changing the SQL Statement
28(3)
5 Bottlenecks in the Execution Plan
31(42)
5.1 "Local" Problems in the Execution Plan
31(17)
5.1.1 A Missing Index
31(4)
5.1.2 A Nonselective Index
35(3)
5.1.3 An Index with a Large Clustering Factor
38(1)
5.1.4 A Sparse Index
39(4)
5.1.5 Nested Loop Join Instead of Hash Join and Vice Versa
43(5)
5.2 "Global" Problems in the Execution Plan
48(22)
5.2.1 Formal Rules for Changing the Table Order in a Join
48(5)
5.2.2 Joins with a Low Number of Hits
53(11)
5.2.3 Joins with a Large Hit Quantity
64(6)
5.3 Summary
70(3)
6 Procedure of Formal SQL Tuning
73(6)
7 Practical Experience with Formal SQL Tuning
79(14)
7.1 Hanno's Experience
79(8)
7.1.1 Statistics on Problem Categories
80(1)
7.1.2 A Small Synthetic Test Case in Respect of a Nonselective Index
81(2)
7.1.3 Practical Example
83(4)
7.2 Victor's Experience
87(6)
7.2.1 The First Practical Example
88(2)
7.2.2 The Second Practical Example
90(3)
8 Closing Remarks
93(4)
Appendix: Application of the Formal Principle for the Analysis of Performance Problems After an Oracle Migration 97(12)
Literature 109
Leonid Nossov was born in Yakutsk, studied mathematics in USSR and has worked in Germany as an Oracle spezialist for several software companies. In the last few years he has been in Advanced Customer Support at Oracle Germany. His work mainly involves performance tuning and troubleshooting. Hanno Ernst comes from Zschopau in the Erz Mountains. Since qualifying as an electronics technician in communications technology at German Telecom he has been in Bamberg at the German Telecom subsidiary T-Systems. His main task is database administration and he is particularly interested in error and performance analysis. Victor Chupis was born in Odessa, USSR. He studied electronics and information technology in Moscow. Since 2001 he has been working for Vodafone Germany. His special fields are database design, operations and performance tuning.