Flylib.com
SQL Performance Tuning
SQL Performance Tuning
ISBN: 0201791692
EAN: 2147483647
Year: 2005
Pages: 125
Authors:
Peter Gulutzan
,
Trudy Pelzer
BUY ON AMAZON
SQL Performance Tuning
Table of Contents
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 Averni1
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
SQL Performance Tuning
ISBN: 0201791692
EAN: 2147483647
Year: 2005
Pages: 125
Authors:
Peter Gulutzan
,
Trudy Pelzer
BUY ON AMAZON
ERP and Data Warehousing in Organizations: Issues and Challenges
The Second Wave ERP Market: An Australian Viewpoint
Data Mining for Business Process Reengineering
Healthcare Information: From Administrative to Practice Databases
A Hybrid Clustering Technique to Improve Patient Data Quality
Development of Interactive Web Sites to Enhance Police/Community Relations
Agile Project Management: Creating Innovative Products (2nd Edition)
The Guiding Principles of Agile Project Management
Practice: Product Vision Box and Elevator Test Statement
Individual Performance
Phase: Explore
A Scaled Adaptive Framework
Professional Java Native Interfaces with SWT/JFace (Programmer to Programmer)
SWT Event Handling, Threading, and Displays
Combos and Lists
Other Important SWT Components
Drawing Diagrams with Draw2D
Sample Application
Cisco IP Telephony (CIPT) (Authorized Self-Study) (2nd Edition)
Configuring Cisco Unified CallManager to Support IP Phones
Call Display Restrictions
Cisco IP Manager Assistant Architecture
Sap Bw: a Step By Step Guide for Bw 2.0
Creating an InfoCube
Part II. Advanced Topics
Operational Data Store (ODS)
Object Transport
Section A.1. ASAP for BW
Java All-In-One Desk Reference For Dummies
Book II - Programming Basics
Programming Threads
Book VIII - Files and Databases
Database for $100, Please
Book IX - Fun and Games
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies