Effective MySQL Optimizing SQL Statements (Paperback)

Ronald Bradford

  • 出版商: McGraw-Hill Education
  • 出版日期: 2011-10-19
  • 售價: $1,322
  • 貴賓價: 9.5$1,256
  • 語言: 英文
  • 頁數: 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