SQL PERFORMANCE TUNING

Publisher: Addison-Wesley Professional; 1st edition
Language: English
ISBN: 0201791692
Paperback: 528 pages
Data: Sept 10, 2002
Format: CHM
Description: SQL Performance Tuning is a reference of applicatory solutions for laboring database professionals live with managing an organization’s critically essential data. Covering today’s most favourite and widely installed database environments, this aggregation is an vital inventiveness for managing and tuning SQL crossways binary platforms.
Packed with tips, techniques, and prizewinning practices, this hands-on pass covers SQL commands and queries over a panoramic arrange of conditions and environments. Every characteristic of the SQL surround is covered, from concurrency curb to optimizationвЂ”and every supply in between. The aggregation includes an overview of apiece of the most widely utilised database direction systems (DBMS) and provides tuning tips for ordinary day-to-day situations.
Topics awninged include:
* General and limited tuning
* General difference 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 curb (locking)
* Clients, servers, and middleware
Whether you are a programmer, consultant, or user, you module encounter SQL Performance Tuning an vital pass to optimizing SQL action crossways today’s favourite database environments.
Throughout SQL Performance Tuning, ideas and techniques are proven on a difference of favourite SQL environments, including IBM DB2, Informix, Ingres, InterBase, Microsoft SQL Server, MySQL, Oracle, and Sybase ASE.