Expert Oracle SQL 封面

Expert Oracle SQL

Optimization, Deployment, and Statistics

作 者:
Tony Hasler
日 期:
2013年12月
ISBN:
9781430259770

简介

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.

下载

扫码关注『极客精神』公众号

公众号:极客精神

请在公众号『极客精神』发送消息 bookist.cc 获取提取码

消息“bookist.cc”不区分大小写。提取码有效期为一个月左右,输入后会自动存储在本地,下次无需重复输入。