買這商品的人也買了...
-
深入淺出設計模式 (Head First Design Patterns)$880$695 -
重構─改善既有程式的設計, 2/e (Refactoring: Improving The Design of Existing Code)$800$632 -
DB2 Developer's Guide: A Solutions-Oriented Approach to Learning the Foundation and Capabilities of DB2 for z/OS, 6/e (Paperback)$2,980$2,831 -
笑談軟體工程：敏捷開發法的逆襲－導入 Scrum，讓你的軟體開發人生從黑白變彩色！$550$468 -
JavaScript & jQuery: The Missing Manual 國際中文版, 2/e
$580$458 -
![ASP.NET 4.5 專題實務 [I]－C# 入門實戰篇-cover](https://cf-assets1.tenlong.com.tw/images/71291/medium/9789572240601_bc.jpg)
ASP.NET 4.5 專題實務 [I]－C# 入門實戰篇$780$663 -
Arduino 錦囊妙計, 2/e (Arduino Cookbook, 2/e)$980$774 -
無瑕的程式碼－敏捷軟體開發技巧守則 + 番外篇－專業程式設計師的生存之道 (雙書合購)$940$700 -
$403讓 DB2 跑得更快－DB2 內部解析與性能優化 -
Visual C# 2013 程式設計經典 (書附雙光碟 VS 2013 Express 中文版, 範例檔)$650$514 -
$352Splunk 大數據分析(Big Data Analytics Using Splunk: Deriving Operational Intelligence from Social Media, Machine Data, Existing Data Warehouses, and Other Real-Time Streaming Sources) -
敏捷與 Scrum 軟體開發速成 (The Elements of Scrum)$300$234 -
王者歸來－jQuery 開發權威指南$720$612 -
改變世界的九大演算法 : 讓今日電腦無所不能的最強概念 (Nine Algorithms That Changed the Future: The Ingenious Ideas That Drive Today’s Computers)$360$252 -
實戰雲端作業系統建置與維護－VMware vSphere 5.5 虛擬化全面啟動$690$545 -
Java 網路程式設計, 4/e (Java Network Programming, 4/e)$680$537 -
Eclipse 完全攻略(第三版)：從基礎 Java 到 PDE 外掛開發$620$484 -
Continuous Delivery 中文版：利用自動化的建置、測試與部署完美創造出可信賴的軟體發佈 (Continuous Delivery: Reliable Software Releases through Build, Test, and Deployment Automation)$650$507 -
松本行弘談程式世界的未來$450$356 -
啊哈！圖解演算法必學基礎$350$263 -
養成 iOS 8 App 程式設計實力的 25 堂課－最新 Swift 開發教學(A Practical Guide to Building Your First App from Scratch: Beginning iOS 8 Programming with Swift)$580$452 -
晉身世界第一流程式設計師：188 個完美化 JavaScript 的建議$620$558 -
UNIX\Linux 網絡日誌分析與流量監控$474$450 -
Android 程式設計入門、應用到精通--增訂第三版 (適用 5.X~1.X, Android Wear 穿戴式裝置)$560$442 -
Raspberry Pi 2 Model B$1,680$1,596
相關主題
商品描述
The Definitive Solutions-Oriented Guide to IBM® DB2® for z/OS®: Now Fully Updated for Both v9 and v10!
The largest database tuning performance gains can often be obtained from tuning application code, and applications that use SQL to retrieve data are the best candidates for tuning. This well-organized, easy-to-understand reference brings together more than 100 SQL-related skills and techniques that any developer can use to build and optimize DB2 applications for consistently superior performance.
DB2 tuning expert Tony Andrews (“Tony the Tuner”) draws on more than 20 years of DB2-related experience, empowering you to take performance into your own hands, whether you’re writing new software or tuning existing systems. Tony shows you exactly how to clear bottlenecks, resolve problems, and improve both speed and reliability.
This book fully reflects the latest SQL programming best practices for DB2 V9 and DB2 V10 on z/OS: techniques that are taught in no other book and are rarely covered in general DB2 SQL courses. Drawing on his extensive consulting experience and highly praised training with Themis Inc., Tony also presents practical checklists and an invaluable 15-step methodology for optimizing virtually any DB2 application.
Coverage includes
The largest database tuning performance gains can often be obtained from tuning application code, and applications that use SQL to retrieve data are the best candidates for tuning. This well-organized, easy-to-understand reference brings together more than 100 SQL-related skills and techniques that any developer can use to build and optimize DB2 applications for consistently superior performance.
DB2 tuning expert Tony Andrews (“Tony the Tuner”) draws on more than 20 years of DB2-related experience, empowering you to take performance into your own hands, whether you’re writing new software or tuning existing systems. Tony shows you exactly how to clear bottlenecks, resolve problems, and improve both speed and reliability.
This book fully reflects the latest SQL programming best practices for DB2 V9 and DB2 V10 on z/OS: techniques that are taught in no other book and are rarely covered in general DB2 SQL courses. Drawing on his extensive consulting experience and highly praised training with Themis Inc., Tony also presents practical checklists and an invaluable 15-step methodology for optimizing virtually any DB2 application.
Coverage includes
- Empowering developers on knowing what to do and where to look in resolving performance problems in queries or programs
- Providing many programming and SQL coding examples
- Establishing standards and guidelines that lead to high-performance SQL
- Implementing time-efficient code walkthroughs to ensure that your standards are followed
- Focusing on the small number of SQL statements that consume the most resources
- Identifying simple solutions that deliver the most sizable benefits
- Optimizing performance by rewriting query predicates more efficiently
- Providing a better understanding of SQL optimization and Runstat statistics
- Recognizing opportunities to tweak your code more effectively than the Optimizer
- Optimizing SQL code with COBOL applications
- Efficiently checking for the existence of data, rows, or tables
- Using Runstats’ newest capabilities to consistently optimize paths to data
商品描述(中文翻譯)
《IBM® DB2® for z/OS®的明確解決方案導向指南：現已全面更新至v9和v10！》
在調整應用程式代碼方面，最大的資料庫調整效能提升通常可以從調整應用程式代碼中獲得，而使用SQL檢索資料的應用程式是最適合進行調整的候選對象。這本組織良好、易於理解的參考書匯集了100多個與SQL相關的技巧和技術，任何開發人員都可以使用這些技巧和技術來構建和優化DB2應用程式，以實現持續優越的性能。
DB2調整專家Tony Andrews（“調整師Tony”）憑藉20多年的DB2相關經驗，讓您能夠自己掌握性能，無論您是編寫新軟體還是調整現有系統。Tony向您展示了如何清除瓶頸、解決問題以及提高速度和可靠性。
本書完全反映了DB2 V9和DB2 V10在z/OS上的最新SQL編程最佳實踐：這些技巧在其他書籍中並未教授，也很少在一般的DB2 SQL課程中涵蓋。Tony憑藉其豐富的咨詢經驗和受到高度讚譽的Themis Inc.培訓，還提供了實用的檢查清單和一個寶貴的15步優化任何DB2應用程式的方法論。
內容包括：
- 讓開發人員了解在解決查詢或程式性能問題時應該做什麼和在哪裡尋找解決方案
- 提供許多程式編碼和SQL編碼示例
- 建立導致高性能SQL的標準和指南
- 實施時間高效的程式碼遍歷，以確保遵循您的標準
- 專注於消耗最多資源的少數SQL語句
- 確定能夠產生最大效益的簡單解決方案
- 通過更高效地重寫查詢謂詞來優化性能
- 更好地理解SQL優化和Runstat統計資料
- 識別比優化器更有效地微調程式碼的機會
- 通過COBOL應用程式優化SQL代碼
- 高效地檢查資料、行或表的存在性
- 利用Runstats的最新功能，持續優化到資料的路徑
