libcats.org
Главная

SQL Performance Tuning

Обложка книги SQL Performance Tuning

SQL Performance Tuning

,
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.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 middlewareWhether 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 popular 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.
EPUB | FB2 | PDF | MOBI | TXT | RTF
* Конвертация файла может нарушить форматирование оригинала. По-возможности скачивайте файл в оригинальном формате.
Популярные книги за неделю:

Каникулы

Автор:
Размер книги: 13 Kb

Ремонт импортных телевизоров

Автор: , Автор:
Категория: civil, civil, hardware
Размер книги: 5.24 Mb

Mein Kampf

Автор:
Категория: fiction
Размер книги: 701 Kb

Conditional Offer

Автор:
Категория: fiction
Размер книги: 286 Kb
Только что пользователи скачали эти книги:

Sams Teach Yourself Mac OS X Leopard All in One

Автор: , Автор:
Категория: Computer science
Размер книги: 83.61 Mb

Primary Care Trust Workforce: Planning and Development

Автор:
Размер книги: 938 Kb

On the Natural Faculties (Loeb Classical Library)

Автор:
Размер книги: 10.93 Mb

Bien débuter avec son Mac

Автор:
Размер книги: 47.37 Mb

Thermochemical Conversion of Biomass to Liquid Fuels and Chemicals

Автор: , Автор: , Автор: , Автор: , Автор:
Размер книги: 40.02 Mb

The New Berlin: Memory, Politics, Place

Автор:
Размер книги: 11.76 Mb

Hick

Автор:
Категория: fiction
Размер книги: 158 Kb

Infection

Автор:
Категория: fiction
Размер книги: 182 Kb