Download Expert Oracle SQL PDF

TitleExpert Oracle SQL
Sub TitleOptimization, Deployment, and Statistics
AuthorTony Hasler
CategoryComputer & Programming
File Size4.6 MB
Total Download388

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.

Similar Free PDFs
Mastering Unreal Engine 4.X

  • 384 Pages
  • 2016
  • English

WildFly Cookbook

  • 604 Pages
  • 2015
  • English

Build an HTML5 Game

  • 220 Pages
  • 2015
  • English

Apple Pay Essentials

  • 84 Pages
  • 2016
  • English

Salt Essentials

  • 178 Pages
  • 2015
  • English

Ethics of Big Data

  • 82 Pages
  • 2012
  • English