|
|
|
|
| LEADER |
02900nmm a2200493 u 4500 |
| 001 |
EB001942815 |
| 003 |
EBX01000000000000001105717 |
| 005 |
00000000000000.0 |
| 007 |
cr||||||||||||||||||||| |
| 008 |
210123 ||| eng |
| 020 |
|
|
|a 9780596514976
|
| 020 |
|
|
|a 9780596551773
|
| 020 |
|
|
|a 0596551770
|
| 020 |
|
|
|a 9780596154950
|
| 020 |
|
|
|a 0596514972
|
| 050 |
|
4 |
|a QA76.73.S67
|
| 100 |
1 |
|
|a Faroult, Stéphane
|
| 245 |
0 |
0 |
|a Refactoring SQL applications
|c Stephane Faroult with Pascal L'Hermite
|
| 250 |
|
|
|a 1st ed
|
| 260 |
|
|
|a Sebastopol, Calif.
|b O'Reilly Media
|c 2008
|
| 300 |
|
|
|a xv, 277 pages
|b illustrations
|
| 505 |
0 |
|
|a 1. Assessment -- A Simple Example -- Assessing Possible Gains -- 2. Sanity Checks -- Statistics and Data Skewness -- Indexing Review -- Parsing and Bind Variables -- Bulk Operations -- Transaction Management -- 3. User Functions and Views -- User-Defined Functions -- Views -- 4. Testing Framework -- Generating Test Data -- Comparing Alternative Versions -- 5. Statement Refactoring -- Execution Plans and Optimizer Directives -- Analyzing a Slow Query -- Refactoring the Query Core -- Rebuilding the Initial Query -- 6. Task Refactoring -- The SQL Mindset -- Restructuring the Code -- 7. Refactoring Flows and Databases -- Reorganizing Processing -- Shaking Foundations -- 8. How It Works: Refactoring in Practice -- Can you Look at the Database? -- Queries of Death -- All These Fast Queries -- No Obvious Very Wrong Query -- Time to Conclude -- A. Scripts and Sample Programs -- B. Tools
|
| 653 |
|
|
|a COMPUTERS / Programming Languages / SQL. / bisacsh
|
| 653 |
|
|
|a SQL (Computer program language) / blmlsh
|
| 653 |
|
|
|a Databases
|
| 653 |
|
|
|a SQL (Langage de programmation)
|
| 653 |
|
|
|a Database management / fast
|
| 653 |
|
|
|a Database management / http://id.loc.gov/authorities/subjects/sh85035848
|
| 653 |
|
|
|a Database management / blmlsh
|
| 653 |
|
|
|a SQL (Computer program language) / fast
|
| 653 |
|
|
|a SQL (Computer program language) / http://id.loc.gov/authorities/subjects/sh86006628
|
| 653 |
|
|
|a Bases de données / Gestion
|
| 700 |
1 |
|
|a L'Hermite, Pascal
|
| 041 |
0 |
7 |
|a eng
|2 ISO 639-2
|
| 989 |
|
|
|b OREILLY
|a O'Reilly
|
| 015 |
|
|
|a GBA859174
|
| 776 |
|
|
|z 9780596154950
|
| 776 |
|
|
|z 9780596551773
|
| 776 |
|
|
|z 0596551770
|
| 776 |
|
|
|z 059615495X
|
| 856 |
4 |
0 |
|u https://learning.oreilly.com/library/view/~/9780596514976/?ar
|x Verlag
|3 Volltext
|
| 082 |
0 |
|
|a 005.756
|
| 082 |
0 |
|
|a 658
|
| 520 |
|
|
|a What can you do when database performance doesn't meet expectations? This book offers methods for refactoring (or changing) SQL code to improve performance without altering a database application's purpose -- and helps you do it on a shoestring budget. This isn't a rehash of theory, but a tested set of options for making code modifications to dramatically improve the way your applications function
|