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
-
相關分類:
MySQL、SQL
立即出貨 (庫存 < 3)
買這商品的人也買了...
-
$880$748 -
$680$537 -
$1,092Effective Java, 2/e (Paperback)
-
$1,740$1,653 -
$1,590$1,558 -
$800$680 -
$1,881$1,782 -
$1,600$1,520 -
$420$357 -
$1,600$1,520 -
$450$351 -
$520$442 -
$480$408 -
$2,220$2,109 -
$891MySQL Troubleshooting: What To Do When Queries Don't Work (Paperback)
-
$1,600$1,520 -
$620$527 -
$680$578 -
$420$332 -
$450$270 -
$788Effective MySQL Backup and Recovery (Paperback)
-
$851Effective MySQL Replication Techniques in Depth (Paperback)
-
$680$578 -
$580$452 -
$1,500$1,275
商品描述
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