O'Reilly logo

SQL All-in-One For Dummies®, 2nd Edition by Allen G. Taylor

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Book VII

Database Tuning Overview

9780470929964-pp0701.tif

Contents at a Glance

Chapter 1: Tuning the Database

Analyzing the Workload

Considering the Physical Design

Choosing the Right Indexes

Tuning Indexes

Tuning Queries

Tuning Transactions

Separating User Interactions from Transactions

Minimizing Traffic between Application and Server

Precompiling Frequently Used Queries

Chapter 2: Tuning the Environment

Surviving Failures with Minimum Data Loss

Tuning the Recovery System

Tuning the Operating System

Maximizing the Hardware You Have

Adding Hardware

Working in Multiprocessor Environments

Chapter 3: Finding and Eliminating Bottlenecks

Pinpointing the Problem

Determining the Possible Causes of Trouble

Implementing General Pointers: A First Step Toward Improving Performance

Tracking Down Bottlenecks

Analyzing Query Efficiency

Managing Resources Wisely

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required