Picture 1 of 1
Gallery
Picture 1 of 1
SQL Tuning: Generating Optimal Execution Plans by Dan Tow (English) Paperback Bo
US $53.80
Approximately£40.03
Condition:
New
A new, unread, unused book in perfect condition with no missing or damaged pages. See the seller's listing for full details.
Oops! Looks like we're having trouble connecting to our server.
Refresh your browser window to try again.
Postage:
Free Economy Shipping.
Located in: Calgary, Alberta, Canada
Delivery:
Estimated between Tue, 6 May and Wed, 14 May to 43230
Returns:
30 days return. Buyer pays for return postage. If you use an eBay delivery label, it will be deducted from your refund amount.
Payments:
Shop with confidence
Seller assumes all responsibility for this listing.
eBay item number:385077294089
Item specifics
- Condition
- ISBN-13
- 9780596005733
- Book Title
- SQL Tuning
- ISBN
- 9780596005733
About this product
Product Identifiers
Publisher
O'reilly Media, Incorporated
ISBN-10
0596005733
ISBN-13
9780596005733
eBay Product ID (ePID)
5947380
Product Key Features
Number of Pages
336 Pages
Language
English
Publication Name
Sql Tuning : Generating Optimal Execution Plans
Publication Year
2003
Subject
Programming Languages / Sql, Data Processing, Databases / Data Mining
Type
Textbook
Subject Area
Computers
Format
Trade Paperback
Dimensions
Item Height
0.9 in
Item Weight
23 Oz
Item Length
9.1 in
Item Width
7 in
Additional Product Features
Intended Audience
Scholarly & Professional
LCCN
2004-299621
Illustrated
Yes
Table Of Content
Dedication Foreword Preface Chapter 1: Introduction Chapter 2: Data-Access Basics Chapter 3: Viewing and Interpreting Execution Plans Chapter 4: Controlling Execution Plans Chapter 5: Diagramming Simple SQL Queries Chapter 6: Deducing the Best Execution Plan Chapter 7: Diagramming and Tuning Complex SQL Queries Chapter 8: Why the Diagramming Method Works Chapter 9: Special Cases Chapter 10: Outside-the-Box Solutions to Seemingly Unsolvable Problems Appendix A: Exercise Solutions Appendix B: The Full Process, End to End Glossary Colophon
Synopsis
A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications.There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use.Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems."Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance., A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. "SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications. There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. "SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use. Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. "SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems." Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, "SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance., A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications. There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL to get a specific alternate execution plan. SQL Tuning provides answers to these questions and addresses a third issue that's even more important: how to find the optimal execution plan for the query to use. Author Dan Tow outlines a timesaving method he's developed for finding the optimum execution plan--rapidly and systematically--regardless of the complexity of the SQL or the database platform being used. You'll learn how to understand and control SQL execution plans and how to diagram SQL queries to deduce the best execution plan for a query. Key chapters in the book include exercises to reinforce the concepts you've learned. SQL Tuning concludes by addressing special concerns and unique solutions to "unsolvable problems." Whether you are a programmer who develops SQL-based applications or a database administrator or other who troubleshoots poorly tuned applications, SQL Tuning will arm you with a reliable and deterministic method for tuning your SQL queries to gain optimal performance., A poorly performing database application not only costsusers time, but has an impact on other applicationsrunning on the same computer or the same network. SQLTuning provides the essential next step for SQLdevelopers and database administrators who want to extendtheir SQL tuning expertise and get the most out of theirdatabase ......
LC Classification Number
QA76.73.S67
Item description from the seller
Seller business information
About this seller
grandeagleretail
98.3% positive Feedback•2.8M items sold
Registered as a business seller
Seller Feedback (1,050,841)
- y***0 (345)- Feedback left by buyer.Past monthVerified purchaseA+++++++seller they gave me a great price and shipped it out immediately and communicated friendly. Shipping was fast and when it arrived it was packaged thoughtfully. The book is brand new and exactly as described. I have come to exect high quality books from them as they are always brand new. I definitely recommend this seller to anyone who wants beautiful books at a great price. Thank you for a great transaction.
- l***r (973)- Feedback left by buyer.Past 6 monthsVerified purchaseA Plus Seller: Transaction Good. Tested Good. Packaged Good. Better than described. Shipping reasonable time. Value contents of book: A Plus. True Life story. From one Autistic person to an other. Right on the money. Jesus Does Talk to People today. Are you listening with a Facilitator and the Spirit guiding, leading, asking Questions? I would not have believed it, until I read it. I have seen it in action. Life Change! Extremely Valuable.
- t***u (125)- Feedback left by buyer.Past 6 monthsVerified purchaseThe book was in excellent condition, quality and appearance excellent as described, and packaged safely in a box very well. Seller shipped immediately and communication and payment transfer was excellent. Great eBayer!!! Price of book was very competitive. A+++++Seed to Harvest by Octavia E. Butler (English) Paperback Book (#396114881909)
More to explore:
- Dan Brown Fiction Paperback Fiction & Non-Fiction Books in English,
- Dan Brown Paperback Fiction & Books,
- Dan Brown Non-Fiction Paperback Fiction & Non-Fiction Books in English,
- Fantasy Fiction Dan Brown Paperback Fiction & Non-Fiction Books in English,
- Dan Abnett Fiction Paperback Fiction & Books,
- Paperback General & Literary Fiction Antiquarian & Collectable Books in English,
- Paperbacks Books in English,
- Dan Abnett Fiction & Fiction Books in English,
- Paperback Fiction Books in English,
- Paperback Language Course in English
Seller Feedback (1,050,841)
- y***0 (345)- Feedback left by buyer.Past monthVerified purchaseA+++++++seller they gave me a great price and shipped it out immediately and communicated friendly. Shipping was fast and when it arrived it was packaged thoughtfully. The book is brand new and exactly as described. I have come to exect high quality books from them as they are always brand new. I definitely recommend this seller to anyone who wants beautiful books at a great price. Thank you for a great transaction.
- l***r (973)- Feedback left by buyer.Past 6 monthsVerified purchaseA Plus Seller: Transaction Good. Tested Good. Packaged Good. Better than described. Shipping reasonable time. Value contents of book: A Plus. True Life story. From one Autistic person to an other. Right on the money. Jesus Does Talk to People today. Are you listening with a Facilitator and the Spirit guiding, leading, asking Questions? I would not have believed it, until I read it. I have seen it in action. Life Change! Extremely Valuable.
- t***u (125)- Feedback left by buyer.Past 6 monthsVerified purchaseThe book was in excellent condition, quality and appearance excellent as described, and packaged safely in a box very well. Seller shipped immediately and communication and payment transfer was excellent. Great eBayer!!! Price of book was very competitive. A+++++Seed to Harvest by Octavia E. Butler (English) Paperback Book (#396114881909)