Expert Oracle SQL: Optimization, Deployment, and Statistics

Tony Hasler

相關主題

商品描述

Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing individual SQL statements, especially on production database systems. This Oracle-specific book begins by assuming you have already identified a particular SQL statement and are considering taking steps to improve its performance. The book describes a systematic process by which to diagnose a problem statement, identify a fix, and to implement that fix safely in a production system. You'll learn not only to improve performance when it is too slow, but also to stabilize performance when it is too variable. You'll learn about system statistics and how the Cost-Based Optimizer uses them to determine a suitable execution plan for a given statement. That knowledge provides the foundation from which to identify the root cause, and to stabilize and improve performance.

Next after identifying a problem and the underlying root cause is to put in place a solution. Expert Oracle SQL: Optimization, Deployment, and Statistics explains how to apply various remedies such as changing the SQL statement, adding hints, changing the physical design, and more, and how they can be brought to bear on fixing a problem once and for all.

Rolling a change out smoothly is an important topic when dealing with tuning and optimization. Expert Oracle SQL: Optimization, Deployment, and Statistics does not let you down in this critical area. The book contains two chapters of good information from an experienced professional on how to safely deploy changes into production so that your systems remaining running and available throughout the deployment process.

  • Describes a systematic approach to tuning Oracle SQL
  • Explains how things are supposed to work, what can go wrong, and how to fix it
  • Takes you through the steps needed to stabilize performance in your production systems

商品描述(中文翻譯)

《Expert Oracle SQL: Optimization, Deployment, and Statistics》是一本關於優化個別SQL語句的書籍,尤其針對生產數據庫系統。這本針對Oracle的書籍假設您已經識別出特定的SQL語句並考慮採取措施來提高其性能。該書描述了一個系統性的過程,用於診斷問題語句,確定解決方案並在生產系統中安全實施該解決方案。您將學習不僅在性能過慢時改善性能,還在性能變動過大時穩定性能。您將了解系統統計信息以及基於成本的優化器如何使用它們來確定給定語句的適當執行計劃。這些知識為識別根本原因、穩定和改善性能提供了基礎。

在識別問題和潛在根本原因之後,下一步是找到解決方案。《Expert Oracle SQL: Optimization, Deployment, and Statistics》解釋了如何應用各種解決方法,例如更改SQL語句、添加提示、更改物理設計等,以解決問題。這些方法可以一勞永逸地解決問題。

在調優和優化時,平穩地推出變更是一個重要的話題。《Expert Oracle SQL: Optimization, Deployment, and Statistics》在這個關鍵領域中不會讓您失望。該書包含了兩章來自經驗豐富的專業人士的有關如何安全地將變更部署到生產環境中的寶貴信息,以確保系統在部署過程中保持運行和可用。

該書的特點包括:
- 描述了調優Oracle SQL的系統性方法
- 解釋了事情應該如何運作,可能出現的問題以及如何解決
- 引導您完成在生產系統中穩定性能所需的步驟