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
CISSP Exam Cram 2
CRYPTOGRAPHY
Self-Assessment
System Validation
Message Privacy
Malicious Code
Strategies for Information Technology Governance
Structures, Processes and Relational Mechanisms for IT Governance
Linking the IT Balanced Scorecard to the Business Objectives at a Major Canadian Financial Group
Measuring and Managing E-Business Initiatives Through the Balanced Scorecard
Measuring ROI in E-Commerce Applications: Analysis to Action
The Evolution of IT Governance at NB Power
Snort Cookbook
Logging to a Pager or Cell Phone
Writing Your Own Preprocessor
Installing and Configuring Barnyard
Generating Statistical Output from Snort Logs
Logging Application Traffic
Programming Microsoft ASP.NET 3.5
Working with the Page
Creating Bindable Grids of Data
ASP.NET Mobile Controls
ASP.NET State Management
Creating New ASP.NET Controls
Logistics and Retail Management: Emerging Issues and New Challenges in the Retail Supply Chain
Relationships in the Supply Chain
Fashion Logistics and Quick Response
Logistics in Tesco: Past, Present and Future
The Development of E-tail Logistics
Transforming Technologies: Retail Exchanges and RFID
Lean Six Sigma for Service : How to Use Lean Speed and Six Sigma Quality to Improve Services and Transactions
Getting Faster to Get Better Why You Need Both Lean and Six Sigma
Success Story #1 Lockheed Martin Creating a New Legacy
Phase 3 Mobilization
Phase 4 Performance and Control
Service Process Challenges
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