Effective MySQL Optimizing SQL Statements (Paperback)

Ronald Bradford

  • 出版商: McGraw-Hill Education
  • 出版日期: 2011-10-19
  • 定價: $1,322
  • 售價: 8.0$1,058
  • 語言: 英文
  • 頁數: 184
  • 裝訂: Paperback
  • ISBN: 0071782796
  • ISBN-13: 9780071782791
  • 相關分類: MySQLSQL
  • 立即出貨 (庫存 < 3)

買這商品的人也買了...

相關主題

商品描述

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撰寫,《Effective MySQL: Optimizing SQL Statements》充滿了詳細的解釋和實用的示例,可以立即應用於改善數據庫和應用程序的性能。這本Oracle Press的書籍以逐步優化SQL的方法,幫助您分析和調整有問題的SQL語句。

本書包括以下內容:
- 辨識收集和診斷問題所需的基本分析命令
- 學習不同的索引理論在MySQL中的應用和表示方式
- 計劃並執行明智的SQL優化
- 創建MySQL索引以提高查詢性能
- 掌握MySQL查詢執行計劃
- 辨識影響SQL執行和性能的關鍵配置變量
- 應用SQL優化生命周期來捕獲、辨識、確認、分析和優化SQL語句並驗證結果
- 通過覆蓋索引和部分索引提高索引利用率
- 學習提高索引效率和簡化SQL語句的隱藏性能技巧