{"product_id":"128640","title":"Friendly SQL Tuning ","description":"\u003ccenter\u003e\u003cdiv style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/tmgdisk01.cafe24.com\/images\/vs\/4172\/sv\/3jX1PGI13Uu2xPsgfOfeoOSx6FiZAU.png?v=1765058853\" style=\"max-width:100%;max-height:10px\"\u003e\u003c\/div\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\u003ccenter\u003e\n\n\u003cdiv style=\"width:95%\"\u003e\n\n\u003cdiv style=\"text-align:center;font-size:30px;font-weight:bolder;line-height:1.6em\"\u003e Friendly SQL Tuning \u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"border-bottom:1px;border-bottom-style:dotted;border-color:;padding-bottom:20px\"\u003e\u003ccenter\u003e\u003ctable align=\"center\" width=\"100%\"\u003e\u003ctbody style=\"border:0px\"\u003e\n\n\u003ctr\u003e\u003ctd align=\"center\" style=\"line-height:1.2em;text-align:center;font-size:18px;color:black;font-weight:bold;padding-bottom:20px;\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\u003ctr\u003e\u003ctd style=\"text-align:center\"\u003e\u003cimg src=\"https:\/\/image.yes24.com\/goods\/61254539\/XL\" style=\"max-width:100%;height:auto\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\n\n\n\u003c\/tbody\u003e\u003c\/table\u003e\u003c\/center\u003e\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;{split_style6}padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e Description \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;word-break:break-all;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eBook Introduction\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\u003cdiv\u003e\u003cdiv\u003e The title of the book was inspired by the corner called “Friendly Economy” in the radio program “Economy in Your Hands,” which I enjoy listening to.\u003cbr\u003e Watching the presenter explain difficult economic issues in a way that was accessible to the general public, I decided, \"I, too, should write a book that explains SQL performance issues in such an easy-to-understand way.\" \u003cbr\u003eThe previous work, 'Oracle Performance Enhancement Principles and Solutions', was originally written for developers, but because it covered DB architecture in too much depth than originally thought, it ended up being read more by DBAs and tuning experts than by developers.\u003cbr\u003e So the new book is called 'Friendly SQL Tuning'.\u003cbr\u003e Oracle Performance Enhancement, written in a friendly and easy-to-understand manner, tailored to developers' needs, by removing unnecessary details and focusing only on the essentials!\u003cbr\u003e\u003cbr\u003e 'Friendly SQL Tuning' is an introductory book to SQL tuning for developers.\u003cbr\u003e As a current tuner who has been providing DB performance consulting for nearly 20 years, I have included stories about DB performance that I would like to share with developers.\u003cbr\u003e The core performance theory remains unchanged, so some of the content is borrowed directly from previous works, but I have tried to supplement the illustrations and explain it in a more easy-to-understand and user-friendly way.\u003cbr\u003e However, this is not a book for beginners in DB programming. \u003cbr\u003eThis book is for those who have accumulated some experience but are constantly struggling to solve performance problems on their own.\u003cbr\u003e Since this book focuses on the core theories of the nationally recognized SQLP (SQL Professional) certification exam, I believe it will serve as a useful reference for those seeking this certification.\u003cbr\u003e Although it focuses on Oracle, it covers performance principles that are common to most DBMSs, so even developers without Oracle experience can follow along without any problems.\u003cbr\u003e I sincerely hope that all developers who build and operate information systems will experience the secret world of SQL tuning through this book and become immersed in its charm.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e For inquiries, please visit http:\/\/www.dbian.net\u003cbr\u003e\n\u003c\/div\u003e\u003c\/div\u003e\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003eindex\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e Chapter 1. SQL Processing and I\/O\u003cbr\u003e 1.1 SQL Parsing and Optimization\u003cbr\u003e 1.1.1 Structured, collective, and declarative query languages\u003cbr\u003e 1.1.2 SQL Optimization\u003cbr\u003e 1.1.3 SQL Optimizer\u003cbr\u003e 1.1.4 Implementation Plan and Costs\u003cbr\u003e 1.1.5 Optimizer Hints\u003cbr\u003e\u003cbr\u003e 1.2 SQL Sharing and Reuse  \u003cbr\u003e1.2.1 Soft parsing vs.\u003cbr\u003e hard parsing\u003cbr\u003e 1.2.2 The Importance of Bind Variables\u003cbr\u003e\u003cbr\u003e 1.3 Data storage structure and I\/O mechanism\u003cbr\u003e 1.3.1 Why SQL is Slow\u003cbr\u003e 1.3.2 Database storage structure\u003cbr\u003e 1.3.3 Block Unit I\/O\u003cbr\u003e 1.3.4 Sequential Access vs.\u003cbr\u003e random access\u003cbr\u003e 1.3.5 Logical I\/O vs.\u003cbr\u003e Physical I\/O\u003cbr\u003e 1.3.6 Single Block I\/O vs.\u003cbr\u003e Multiblock I\/O\u003cbr\u003e 1.3.7 Table Full Scan vs.\u003cbr\u003e Index Range Scan\u003cbr\u003e 1.3.8 Cache Lookup Mechanism\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e Chapter 2.\u003cbr\u003e Index Basics\u003cbr\u003e 2.1 Index Structure and Navigation\u003cbr\u003e 2.1.1 Preview Index Tuning\u003cbr\u003e 2.1.2 Index Structure\u003cbr\u003e 2.1.3 Index Vertical Search\u003cbr\u003e 2.1.4 Index Horizontal Search\u003cbr\u003e 2.1.5 Combined Index Structure and Search\u003cbr\u003e\u003cbr\u003e 2.2 Basic Index Usage\u003cbr\u003e 2.2.1 Using an index\u003cbr\u003e 2.2.2 Why Indexes Cannot Be Range Scanned\u003cbr\u003e 2.2.3 More important index usage conditions\u003cbr\u003e 2.2.4 Omitting sort operations using indexes\u003cbr\u003e 2.2.5 Column processing in the ORDER BY clause\u003cbr\u003e 2.2.6 Column processing in SELECT-LIST\u003cbr\u003e 2.2.7 Automatic type conversion\u003cbr\u003e\u003cbr\u003e 2.3 How to use the index extension function\u003cbr\u003e 2.3.1 Index Range Scan \u003cbr\u003e2.3.2 Index Full Scan\u003cbr\u003e 2.3.3 Index Unique Scan\u003cbr\u003e 2.3.4 Index Skip Scan\u003cbr\u003e 2.3.5 Index Fast Full Scan\u003cbr\u003e 2.3.6 Index Range Scan Descending\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e Chapter 3.\u003cbr\u003e Index Tuning\u003cbr\u003e 3.1 Minimizing table access\u003cbr\u003e 3.1.1 Table Random Access\u003cbr\u003e 3.1.2 Index Clustering Factor\u003cbr\u003e 3.1.3 Index Break-Even Point\u003cbr\u003e 3.1.4 Adding an index column\u003cbr\u003e 3.1.5 Read and process only the index\u003cbr\u003e 3.1.6 Index Structure Table\u003cbr\u003e 3.1.7 Cluster Table\u003cbr\u003e\u003cbr\u003e 3.2 Using partial range processing\u003cbr\u003e 3.2.1 Partial range processing\u003cbr\u003e 3.2.2 Implementing partial range processing\u003cbr\u003e 3.2.3 Principle of Performance Improvement by Partial Range Processing in OLTP Environments\u003cbr\u003e\u003cbr\u003e 3.3 Improving index scan efficiency\u003cbr\u003e 3.3.1 Index Search\u003cbr\u003e 3.3.2 Index Scan Efficiency\u003cbr\u003e 3.3.3 Access Conditions and Filter Conditions\u003cbr\u003e 3.3.4 Clustering by comparison operator type and column order\u003cbr\u003e 3.3.5 Inefficiency that occurs when the index leading column is not an equality (=) condition\u003cbr\u003e 3.3.6 Converting BETWEEN to IN-List\u003cbr\u003e 3.3.7 Using Index Skip Scan\u003cbr\u003e 3.3.8 Is the IN condition '='?\u003cbr\u003e 3.3.9 Comparison of BETWEEN and LIKE scan ranges \u003cbr\u003e3.3.10 Inefficiency caused by overusing range search conditions\u003cbr\u003e 3.3.11 Comparison of the pros and cons of various option condition processing methods\u003cbr\u003e 3.3.12 Index configuration to reduce function call load\u003cbr\u003e\u003cbr\u003e 3.4 Index Design\u003cbr\u003e 3.4.1 Why index design is difficult\u003cbr\u003e 3.4.2 The two most important selection criteria\u003cbr\u003e 3.4.3 Criteria other than scan efficiency\u003cbr\u003e 3.4.4 Strategic Design Beyond Formulas\u003cbr\u003e 3.4.5 Adding a column to omit sort operations\u003cbr\u003e 3.4.6 Combined Index Selectivity\u003cbr\u003e 3.4.7 Removing duplicate indexes\u003cbr\u003e 3.4.8 Creating an index design diagram\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e Chapter 4.\u003cbr\u003e Join Tuning\u003cbr\u003e 4.1 NL Join\u003cbr\u003e 4.1.1 Basic Mechanism\u003cbr\u003e 4.1.2 NL Join Execution Plan Control\u003cbr\u003e 4.1.3 Analysis of the NL Join Execution Process\u003cbr\u003e 4.1.4 NL Join Tuning Points\u003cbr\u003e 4.1.5 Summary of NL Join Features\u003cbr\u003e 4.1.6 NL Join Tuning Practice\u003cbr\u003e 4.1.7 NL Join Expansion Mechanism\u003cbr\u003e\u003cbr\u003e 4.2 Sort Merge Join\u003cbr\u003e 4.2.1 SGA vs. PGA\u003cbr\u003e 4.2.2 Basic Mechanism\u003cbr\u003e 4.2.3 Why Sort Merge Join is Fast\u003cbr\u003e 4.2.4 Main Uses of Sort Merge Join\u003cbr\u003e 4.2.5 Controlling Sort Merge Joins  \u003cbr\u003e4.2.6 Summary of Sort Merge Join Features\u003cbr\u003e\u003cbr\u003e 4.3 Hash Join\u003cbr\u003e 4.3.1 Basic Mechanism\u003cbr\u003e 4.3.2 Why Hash Joins Are Fast\u003cbr\u003e 4.3.3 Handling Large Build Inputs\u003cbr\u003e 4.3.4 Hash Join Execution Plan Control\u003cbr\u003e 4.3.5 Join Method Selection Criteria\u003cbr\u003e\u003cbr\u003e 4.4 Subquery Join\u003cbr\u003e 4.4.1 Why Subquery Transformation is Necessary\u003cbr\u003e 4.4.2 Subqueries and Joins\u003cbr\u003e 4.4.3 Views and Joins\u003cbr\u003e 4.4.4 Scalar Subquery Joins\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e Chapter 5.\u003cbr\u003e Sort tuning\u003cbr\u003e 5.1 Understanding the sort operation\u003cbr\u003e 5.1.1 Sorting Process\u003cbr\u003e 5.1.2 Sort Operation\u003cbr\u003e\u003cbr\u003e 5.2 Writing SQL to prevent sorting\u003cbr\u003e 5.2.1 Union vs.\u003cbr\u003e Union All\u003cbr\u003e 5.2.2 Using Exists\u003cbr\u003e\u003cbr\u003e 5.3 Omitting sort operations using indexes\u003cbr\u003e 5.3.1 Omit Sort Order By\u003cbr\u003e 5.3.2 Top N Queries\u003cbr\u003e 5.3.3 Finding minimum\/maximum values\u003cbr\u003e 5.3.4 History Inquiry\u003cbr\u003e 5.3.5 Omit Sort Group By\u003cbr\u003e\u003cbr\u003e 5.4 Writing SQL to Use Small Sort Areas\u003cbr\u003e 5.4.1 Reducing sort data\u003cbr\u003e 5.4.2 Principle of reducing sort load for Top N queries\u003cbr\u003e 5.4.3 Sorting overhead when not a Top N query\u003cbr\u003e 5.4.4 Top N sort in analytic functions\u003cbr\u003e\u003cbr\u003e \u003cbr\u003eChapter 6. DML Tuning\u003cbr\u003e 6.1 Basic DML Tuning\u003cbr\u003e 6.1.1 Factors Affecting DML Performance\u003cbr\u003e 6.1.2 Database Calls and Performance\u003cbr\u003e 6.1.3 Using Array Processing\u003cbr\u003e 6.1.4 Bulk DML Tuning with Indexes and Constraint Release\u003cbr\u003e 6.1.5 Modifiable Join Views\u003cbr\u003e 6.1.6 Using the MERGE Statement\u003cbr\u003e\u003cbr\u003e 6.2 Utilizing Direct Path I\/O\u003cbr\u003e 6.2.1 Direct Path I\/O\u003cbr\u003e 6.2.2 Direct Path Insert\u003cbr\u003e 6.2.3 Parallel DML\u003cbr\u003e\u003cbr\u003e 6.3 DML Tuning Using Partitions\u003cbr\u003e 6.3.1 Table Partitions\u003cbr\u003e 6.3.2 Index Partitions\u003cbr\u003e 6.3.3 Tuning Bulk UPDATEs Using Partitions\u003cbr\u003e 6.3.4 Tuning Bulk DELETEs Using Partitions\u003cbr\u003e 6.3.5 Tuning Bulk INSERTs Using Partitions\u003cbr\u003e\u003cbr\u003e 6.4 Locks and Transaction Concurrency Control\u003cbr\u003e 6.4.1 Oracle Lock\u003cbr\u003e 6.4.2 Transaction Concurrency Control\u003cbr\u003e 6.4.3 Comparison of INSERT performance by numbering method\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e Chapter 7. SQL Optimizer\u003cbr\u003e 7.1 Statistical Information and Cost Calculation Principles\u003cbr\u003e 7.1.1 Selectivity and Cardinality\u003cbr\u003e 7.1.2 Statistical Information\u003cbr\u003e 7.1.3 Cost Calculation Principle\u003cbr\u003e\u003cbr\u003e 7.2 Understanding the Optimizer\u003cbr\u003e 7.2.1 Optimizer Types\u003cbr\u003e 7.2.2 Optimizer Mode \u003cbr\u003e7.2.3 Factors Affecting the Optimizer\u003cbr\u003e 7.2.4 Optimizer Limitations\u003cbr\u003e 7.2.5 Developer Role\u003cbr\u003e 7.2.6 How to Study to Become a Tuning Expert\u003cbr\u003e\u003cbr\u003e Appendix. SQL Analysis Tools\u003cbr\u003e 1.\u003cbr\u003e Check the execution plan\u003cbr\u003e 2.\u003cbr\u003e AutoTrace\u003cbr\u003e 3. SQL Trace\u003cbr\u003e 4. DBMS_XPLAN package\u003cbr\u003e 5.\u003cbr\u003e Real-time SQL monitoring\u003cbr\u003e 6.\u003cbr\u003e V$SQL\u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003cbr\u003e\u003cdiv\u003e\u003ch5\u003e \u003cb\u003ePublisher's Review\u003c\/b\u003e\n\u003c\/h5\u003e\u003c\/div\u003e\n\u003cdiv\u003e\n\u003cdiv\u003e SQL tuning is not a technical field that can be mastered by memorizing certain formulas or secrets. It is most important to accurately understand the internal execution principles of SQL.\u003cbr\u003e The author of the first and second volumes of 'Oracle Performance Enhancement Principles and Solutions', the best-selling books in the field of database performance, has recently published 'Friendly SQL Tuning' and emphasizes that in order to properly tune SQL, you must have at least a thorough understanding of the contents covered in this book.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e This book is an introductory book on tuning that experts with firsthand experience in the world of SQL tuning can confidently recommend to their fellow developers. \u003cbr\u003eIf you understand the overall flow and context of SQL tuning through this book, you can easily learn about 'Oracle Performance Enhancement Principles and Solutions'.\u003cbr\u003e The specific target audience is as follows, and it will be a must-read, especially for those preparing for the SQLP certification exam.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e - Applicants for the nationally recognized SQLP qualification exam\u003cbr\u003e - Developers and DBAs who want to get started with SQL tuning\u003cbr\u003e - Advanced Database Programmer\u003cbr\u003e - Database designer\u003cbr\u003e\u003cbr\u003e If you have any questions about the book, please contact the author's internet cafe below.\u003cbr\u003e\u003cbr\u003e\u003cbr\u003e DBian Forum http:\/\/www.dbian.net \u003c\/div\u003e\n\u003cdiv\u003e\u003c\/div\u003e\n\u003c\/div\u003e\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cdiv style=\"width:95%;padding-top:20px;padding-bottom:20px\"\u003e\n\n\u003cdiv style=\"text-align:left;font-size:16px;font-weight:bold;padding-bottom:20px\"\u003e GOODS SPECIFICS \u003c\/div\u003e\n\n\u003cdiv style=\"text-align:left;font-size:14px;line-height:1.6em;\"\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eDate of issue:\u003c\/strong\u003e June 1, 2018\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003ePage count, weight, size:\u003c\/strong\u003e 560 pages | 1,064g | 188*245*25mm\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN13:\u003c\/strong\u003e 9791196395704\u003c\/div\u003e\n\n\u003cdiv style=\"width:100%;margin-bottom:5px;line-height:1.6em;font-size:14px\"\u003e - \u003cstrong\u003eISBN10:\u003c\/strong\u003e 1196395705 \u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\n\u003c\/div\u003e\n\n\u003ccenter\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003ccenter\u003e\u003ctable\u003e\u003ctr\u003e\u003ctd style=\"height:10px\"\u003e\u003c\/td\u003e\u003c\/tr\u003e\u003c\/table\u003e\u003c\/center\u003e\n\n\u003cspan\u003e\u003c\/span\u003e\n\n\u003c\/center\u003e\n\n\n\u003c\/center\u003e","brand":"LIBRAIRIE COREENNE","offers":[{"title":"Default Title","offer_id":43893159493674,"sku":"128640","price":50.0,"currency_code":"EUR","in_stock":true}],"thumbnail_url":"\/\/cdn.shopify.com\/s\/files\/1\/0683\/2750\/5962\/files\/afb76c0a97042be89aaa1227dd57627d.jpg?v=1765390674","url":"https:\/\/librairie.coreenne.fr\/en\/products\/128640","provider":"LIBRAIRIE COREENNE","version":"1.0","type":"link"}