Effective MySQL Optimizing SQL Statements (Paperback)
暫譯: 有效的 MySQL 優化 SQL 語句 (平裝本)
Ronald Bradford
- 出版商: McGraw-Hill Education
- 出版日期: 2011-10-19
- 定價: $1,322
- 售價: 8.0 折 $1,058
- 語言: 英文
- 頁數: 184
- 裝訂: Paperback
- ISBN: 0071782796
- ISBN-13: 9780071782791
-
相關分類:
MySQL
立即出貨 (庫存 < 3)
買這商品的人也買了...
-
Head First EJB：SCBCD 專業認證指南 (Head First EJB)$880$748 -
聚沙成塔─建置逐層擴充的 Web 2.0 服務 (Building Scalable Web Sites: Building, Scaling, and Optimizing the Next Generation of Web Applications)$680$537 -
$1,140Effective Java, 2/e (Paperback) -
High Performance MySQL: Optimization, Backups, Replication, and More, 2/e$1,760$1,672 -
Introduction to Algorithms, 3/e (IE-Paperback)$1,590$1,558 -
重構─改善既有程式的設計, 2/e (Refactoring: Improving The Design of Existing Code)$800$632 -
MySQL Administrator's Bible (Paperback)$1,980$1,881 -
Linux Kernel Development, 3/e (Paperback)$1,900$1,862 -
世界第一立即有效的 Excel VBA$420$357 -
MongoDB in Action (Paperback)$1,610$1,530 -
一定要學會的 HTML5 + CSS3 網頁設計實作應用$450$351 -
Android 4.X 手機/平板電腦程式設計入門、應用到精通, 2/e (適用 Android 1.X~4.X)$520$411 -
數位學習－觀念、方法、實務、設計與實作, 2/e$480$379 -
High Performance MySQL: Optimization, Backups, and Replication, 3/e (Paperback)$2,240$2,128 -
MySQL Troubleshooting: What To Do When Queries Don't Work (Paperback)$998$945 -
PHP and MongoDB Web Development Beginner's Guide$1,760$1,672 -
最新計算機概論─邁向資訊新世代$620$527 -
實戰雲端作業系統建置與維護－VMware vSphere 5 虛擬化全面啟動
$680$537 -
3 秒鐘搞定 Excel ─資料處理→函數→ VBA$420$332 -
MongoDB 技術手冊 (MongoDB: The Definitive Guide)$450$356 -
Effective MySQL Backup and Recovery (Paperback)$831$788 -
Effective MySQL Replication Techniques in Depth (Paperback)$898$851 -
ASP.NET MVC 4 網站開發美學$680$537 -
無瑕的程式碼－敏捷軟體開發技巧守則 (Clean Code: A Handbook of Agile Software Craftsmanship)$580$452 -
BIM 建築資訊建模手冊, 2/e－寫給業主、專案經理、設計師、工程師以及承包商的 BIM 建築資訊建模指南(BIM Handbook, 2/e)$1,500$1,185
商品描述
The Essential Guide to SQL Statement Optimization
Written by Oracle ACE Director and MySQL expert Ronald Bradford, Effective MySQL: Optimizing SQL Statements is filled with detailed explanations and practical examples that can be applied immediately to improve database and application performances. Featuring a step-by-step approach to SQL optimization, this Oracle Press book helps you to analyze and tune problematic SQL statements.
- Identify the essential analysis commands for gathering and diagnosing issues
- Learn how different index theories are applied and represented in MySQL
- Plan and execute informed SQL optimizations
- Create MySQL indexes to improve query performance
- Master the MySQL query execution plan
- Identify key configuration variables that impact SQL execution and performance
- Apply the SQL optimization lifecycle to capture, identify, confirm, analyze, and optimize SQL statements and verify the results
- Improve index utilization with covering indexes and partial indexes
- Learn hidden performance tips for improving index efficiency and simplifying SQL statements
商品描述(中文翻譯)
《SQL 語句優化的基本指南》
由 Oracle ACE Director 及 MySQL 專家 Ronald Bradford 所著的《有效的 MySQL：優化 SQL 語句》充滿了詳細的解釋和實用的範例，這些內容可以立即應用於改善資料庫和應用程式的性能。本書採用逐步的方法來進行 SQL 優化，幫助您分析和調整有問題的 SQL 語句。
- 確定收集和診斷問題的基本分析命令
- 學習不同的索引理論如何在 MySQL 中應用和表示
- 計劃和執行有根據的 SQL 優化
- 創建 MySQL 索引以改善查詢性能
- 精通 MySQL 查詢執行計劃
- 確定影響 SQL 執行和性能的關鍵配置變數
- 應用 SQL 優化生命週期來捕捉、識別、確認、分析和優化 SQL 語句並驗證結果
- 通過覆蓋索引和部分索引來改善索引的利用率
- 學習隱藏的性能提示，以提高索引效率並簡化 SQL 語句
