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
Crystal Reports 9 on Oracle (Database Professionals)
Connectivity, Authentication, and Privileges
Oracle SQL
Oracle Advanced SELECT Options
The Crystal Repository
Appendix B Functions
Cisco IP Communications Express: CallManager Express with Cisco Unity Express
Caller Features
Configuring IP Phones and Extensions
Managing Cisco IPC Express with Cisco Partner Applications
Troubleshooting Cisco UE System Features
Table vm_mbxusers
Making Sense of Change Management: A Complete Guide to the Models, Tools and Techniques of Organizational Change
Part I - The Underpinning Theory
Organizational change
Leading change
Restructuring
Cultural change
MySQL Cookbook
Logging Interactive mysql Sessions
Specifying Which Rows to Select
Introduction
Introduction
C.4. Python Resources
Programming .Net Windows Applications
Projects and Solutions
Forms Inheritance
Text Controls
Tabbed Pages
The MainMenu Object
Digital Character Animation 3 (No. 3)
Designing a Character
Understanding Motion
Insects and Spiders
Characters and Story
Developing a Story
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