没有合适的资源?快使用搜索试试~ 我知道了~
SQL Performance Tuning
需积分: 9 11 下载量 30 浏览量
2012-12-04
21:43:04
上传
评论
收藏 2.38MB PDF 举报
温馨提示
试读
373页
SQL Performance Tuning is a handbook of practical solutions for busy database professionals charged with managing an organization's critically important data. Covering today's most popular and widely installed database environments, this book is an indispensable resource for managing and tuning SQL across multiple platforms.
资源推荐
资源详情
资源评论
SQL Performance Tuning
By Peter Gulutzan
, Trudy Pelzer
Publishe
r
: Addison Wesley
Pub Date: September 10, 2002
ISBN: 0-201-79169-2
Pages: 528
SQL Performance Tuning is a handbook of practical solutions for busy database
p
rofessionals charged with managing an organization's critically important data.
Covering today's most popular and widely installed database environments, this book
is an indispensable resource for managing and tuning SQL across multiple platforms.
Packed with tips, techniques, and best practices, this hands-on guide covers SQL
commands and queries over a wide range of conditions and environments. Every facet
of the SQL environment is covered, from concurrency control to optimization—and
every issue in between. The book includes an overview of each of the most widely
used database management systems (DBMS) and provides tuning tips for common
day-to-day situations.
Topics covered include:
• General and specific tuning
• General sort considerations and options
• Joins and subqueries
• Columns and tables
• Indexes, including B-trees and bitmaps
• Constraints and stored procedures
• ODBC and JDBC
• Data changes and concurrency control (locking)
• Clients, servers, and middleware
Whether you are a programmer, consultant, or user, you will find SQL Performance
Tuning an indispensable guide to optimizing SQL performance across today's popular
database environments.
Throughout SQL Performance Tuning, ideas and techniques are tested on a variety of
p
opular SQL environments, including IBM DB2, Informix, Ingres, InterBase,
Microsoft SQL Server, MySQL, Oracle, and Sybase ASE. The book's practical
examples are written in ANSI/ISO Standard SQL: 1999.
Copyright
Preface
You Don't Know that Your DBMS Is Good …
You Know that Even Good Tools Work Better in Skilled Hands …
Acknowledgments
Chapter 1. Facilis Descensus Averni
This Subject Is Important
The Big Eight
Test Results
Portability
Terminology and Expectations
Generalities
Chapter 2. Simple Searches
General Tuning
Specific Tuning
Style Notes
Parting Shots
Chapter 3. ORDER BY
General Sort Considerations
Character Sorts
Other Options
Parting Shots
Chapter 4. GROUP BY
Refresher
Optimal GROUP BY Clauses
Sorting
Set Functions and Summary Aggregates
Parting Shots
Chapter 5. Joins
Join Plan Strategies
Avoid the Join Strategies
Three-Way Joins and Beyond
Old Style versus ANSI Style
Parting Shots
Chapter 6. Subqueries
Refresher
Join versus Subquery
Syntax Choices
Parting Shots
Chapter 7. Columns
How Big Is the Size Factor?
Characters
Temporals
Numbers
Bits
Large Objects
NULLs
Column Order Within Rows
Parting Shots
Chapter 8. Tables
The Storage Hierarchy
Heaps
Clusters
The Normal Forms
Views
Parting Shots
Chapter 9. Indexes
Refresher
B-trees
Types of Indexes
Bitmap Indexes
Other Index Variations
Index Key Values
Parting Shots
Chapter 10. Constraints
NOT NULL
CHECK
FOREIGN KEY
PRIMARY KEY
UNIQUE
Triggers
Disabling Constraints
Client Validations
Redundant SELECT Clauses
Parting Shots
Chapter 11. Stored Procedures
Refresher
Advantages of Stored Procedures
Parting Shots
Chapter 12. ODBC
Refresher
SQLPrepare
Fetch Loops
Data-Change Statements
Catalog Functions
Parting Shots
Chapter 13. JDBC
Connections
Query Prepping
Result Sets
Data Changes
Parting Shots
Chapter 14. Data Changes
Logs
INSERT
UPDATE
DELETE
Ugly Updates
FETCH and Data Changes
COMMIT and ROLLBACK
Parting Shots
Chapter 15. Locks
What Is a Lock?
Isolation Levels
Index Locks
Hot Spots
Optimistic Locking
The Scan Trick
Parting Shots
Chapter 16. Clients and Servers
Middleware
Server Processes and Threads
What Should the Client Do?
Parting Shots
Chapter 17. Cost-Based Optimizers
Cost
Statistics and Histograms
EXPLAIN
Hints
Parting Shots
Appendix A. Further Reading
Appendix B. Glossary
Copyright
Many of the designations used by manufacturers and sellers to distinguish their products are claimed
as trademarks. Where those designations appear in this book, and Addison-Wesley, Inc. was aware of
a trademark claim, the designations have been printed with initial capital letters or in all capitals.
The authors and publisher have taken care in the preparation of this book, but make no expressed or
implied warranty of any kind and assume no responsibility for errors or omissions. No liability is
assumed for incidental or consequential damages in connection with or arising out of the use of the
information or programs contained herein.
The publisher offers discounts on this book when ordered in quantity for bulk purchases and special
sales. For more information, please contact:
U.S. Corporate and Government Sales
(800) 382-3419
corpsales@pearsontechgroup.com
For sales outside of the U.S., please contact:
International Sales
(317) 581-3793
international@pearsontechgroup.com
Visit A-W on the Web: www.awprofessional.com
Library of Congress Cataloging-in-Publication Data
Gulutzan, Peter.
SQL performance tuning / Peter Gulutzan and Trudy Pelzer.
p. m.
Includes bibliographical references and index.
ISBN 0-201-79169-2 (alk. paper)
1. SQL (Computer program language) 2. Relational databases. I. Pelzer, Trudy. II. Title.
QA76.73.S67 G853 2003
005.75'6—dc21
2002074418
Copyright © 2003 Pearson Education, Inc
All rights reserved. No part of this publication may be reproduced, stored in a retrieval system, or
transmitted, in any form, or by any means, electronic, mechanical, photocopying, recording, or
otherwise, without the prior consent of the publisher. Printed in the United States of America.
Published simultaneously in Canada.
剩余372页未读,继续阅读
资源评论
polozhanshen
- 粉丝: 1
- 资源: 26
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功