Expert Oracle SQL - Oracle 专家 SQL 解析
5墨值下载
Hasler
Shelve in
Databases/Oracle
User level:
Intermediate–Advanced
SOURCE CODE ONLINE
Expert Oracle SQL: Optimization, Deployment, and Statistics is about optimizing indi-
vidual SQL statements, especially on production database systems. The book begins
by assuming you have already identified a particular SQL statement and are consider-
ing 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 to improve performance when it is too slow,
and 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 prob-
lem 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 and contains two chapters of good information on how
to safely deploy changes into production so that your systems remaining running and
available throughout the deployment process.
The Independent Oracle User Group (IOUG) is a not-for-profit organization that provides
support and education for professional users of Oracle products. Most but not all of our Members are
Database Administrators or other professionals who use Oracle database products and want to know that
Oracle hears their feedback. We make sure your voice matters!
Apress Media LLC is a technical publisher devoted to meeting the needs of IT professionals,
software developers, and programmers, with more than 1,000 books in print and electronic formats.
Apress provides high-quality, no-fluff content that helps serious technology professionals build a
comprehensive pathway to career success.
RELATED
www.allitebooks.com
of 599
5墨值下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论