Table of Contents
Preface p. vii Assessment p. 1 A Simple Example p. 2 Assessing Possible Gains p. 19 Sanity Checks p. 37 Statistics and Data Skewness p. 38 Indexing Review p. 44 Parsing and Bind Variables p. 55 Bulk Operations p. 70 Transaction Management p. 73 User Functions and Views p. 75 User-Defined Functions p. 76 Views p. 103 Testing Framework p. 115 Generating Test Data p. 116 Comparing Alternative Versions p. 132 Statement Refactoring p. 147 Execution Plans and Optimizer Directives p. 148 Analyzing a Slow Query p. 152 Refactoring the Query Core p. 158 Rebuilding the Initial Query p. 176 Task Refactoring p. 179 The SQL Mindset p. 180 Restructuring the Code p. 185 Refactoring Flows and Databases p. 211 Reorganizing Processing p. 212 Shaking Foundations p. 233 How it Works: Refactoring in Practice p. 243 Can You Look at the Database? p. 243 Queries of Death p. 245 All These Fast Queries p. 247 No Obvious Very Wrong Query p. 248 Time to Conclude p. 249 Scripts and Sample Programs p. 251 Tools p. 261 Index p. 269 Table of Contents provided by Ingram. All Rights Reserved.
Series: THEORY IN PRACTICE
Number Of Pages: 277
Published: 1st August 2008
Dimensions (cm): 23.2 x 18.0 x 1.75
Weight (kg): 0.5
This product is categorised byNon-Fiction » Computing & I.T. » Computer Programming & Software Development » Database Programming
Non-Fiction » Computing & I.T. » Databases
Non-Fiction » Computing & I.T. » Databases » Data Warehousing
Non-Fiction » Computing & I.T. » Databases » Database Software
Non-Fiction » Computing & I.T. » O'Reilly
What can you do when database performance doesn't meet expectations? Before you turn to expensive hardware upgrades to solve the problem, reach for this book. "Refactoring SQL Applications" provides a set of tested options for making code modifications to dramatically improve the way your database applications function. Backed by real-world examples, you'll find quick fixes for simple problems, in-depth answers for more complex situations, and complete solutions for applications with extensive problems. Learn to:
Determine if and where you can expect performance gains Apply quick fixes, such as limiting calls to the database in stored functions and procedures Refactor tasks, such as replacing application code by a stored procedure, or replacing iterative, procedural statements with sweeping SQL statements Refactor flow by increasing parallelism and switching business-inducted processing from synchronous to asynchronous Refactor design using schema extensions, regular views, materialized views, partitioning, and more Compare before and after versions of a program to ensure you get the same results once you make modifications
"Refactoring SQL Applications" teaches you to recognize and assess code that needs refactoring, and to understand the crucial link between refactoring and performance. If and when your application bogs down, this book will help you get it back up to speed.