SQL Tuning by Dan Tow

Description

A poorly performing database application not only costs users time, but also has an impact on other applications running on the same computer or the same network. SQL Tuning provides an essential next step for SQL developers and database administrators who want to extend their SQL tuning expertise and get the most from their database applications. There are two basic issues to focus on when tuning SQL: how to find and interpret the execution plan of an SQL statement and how to change SQL show more to get a specific alternate execution plan. SQL Tuning provides answers to th show less

Recommendations

The Art of SQL by Stephane Faroult

The Art of SQL

Stephane Faroult

SQL in a Nutshell: A Desktop Quick Reference by Kevin Kline

SQL in a Nutshell: A Desktop Quick Reference

Kevin Kline

Oracle PL/SQL Best Practices by Steven Feuerstein

Oracle PL/SQL Best Practices

Steven Feuerstein

SQL Cookbook by Anthony Molinaro

SQL Cookbook

Anthony Molinaro

Learning SQL by Alan Beaulieu

Learning SQL

Alan Beaulieu

Database in Depth: Relational Theory for Practitioners by C. J. Date

Database in Depth: Relational Theory for Practitioners

C. J. Date

MySQL Cookbook by Paul DuBois

High Performance MySQL: Optimization, Backups, Replication, and Load Balancing by Jeremy D. Zawodny

High Performance MySQL: Optimization, Backups, Replication, and Load Balancing

Jeremy D. Zawodny

Oracle Regular Expressions Pocket Reference by Jonathan Gennick

Oracle Regular Expressions Pocket Reference

Jonathan Gennick

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design by Michael J. Hernandez

Database Design for Mere Mortals: A Hands-On Guide to Relational Database Design

Michael J. Hernandez

MySQL and mSQL by Randy Jay Yarger

MySQL and mSQL

Randy Jay Yarger

Oracle PL/SQL by Example by Benjamin Rosenzweig

Oracle PL/SQL by Example

Benjamin Rosenzweig

Oracle SQL High-Performance Tuning by Guy Harrison

Oracle SQL High-Performance Tuning

Guy Harrison

Oracle PL/SQL for DBAs by Arup Nanda

Oracle PL/SQL for DBAs

Arup Nanda

SQL Pocket Guide by Jonathan Gennick

SQL Pocket Guide

Jonathan Gennick

Programming the Perl DBI by Tim Bunce

Programming the Perl DBI

Tim Bunce

Perl Template Toolkit by Darren Chamberlain

Perl Template Toolkit

Darren Chamberlain

An Introduction to Database Systems by C. J. Date

An Introduction to Database Systems

C. J. Date

Sams Teach Yourself SQL in 10 Minutes (3rd Edition) by Ben Forta

Sams Teach Yourself SQL in 10 Minutes (3rd Edition)

Ben Forta

Oracle DBA Checklists Pocket Reference by Quest Software

Oracle DBA Checklists Pocket Reference

Quest Software

Perl for Oracle DBAs by Andy Duncan

Perl for Oracle DBAs

Andy Duncan

Web Database Applications with PHP and MySQL by Hugh E. Williams

Web Database Applications with PHP and MySQL

Hugh E. Williams

Transact-SQL Cookbook by Ales Spetic

Transact-SQL Cookbook

Ales Spetic

Head First SQL: Your Brain on SQL: A Learner's Guide by Lynn Beighley

Head First SQL: Your Brain on SQL: A Learner's Guide

Lynn Beighley

Mastering Oracle SQL by Sanjay Mishra

Mastering Oracle SQL

Sanjay Mishra

.NET Windows Forms in a Nutshell by Ian Griffiths

.NET Windows Forms in a Nutshell

Ian Griffiths

PHP and MySQL Web Development by Luke Welling

PHP and MySQL Web Development

Luke Welling

SQL for Dummies by Allen G. Taylor

SQL for Dummies

Allen G. Taylor

PHP & MySQL for Dummies by Janet Valade

PHP & MySQL for Dummies

Janet Valade

The Practical SQL Handbook: Using Structured Query Language (3rd Edition) by Judith S. Bowman

The Practical SQL Handbook: Using Structured Query Language (3rd Edition)

Judith S. Bowman

ADO.NET in a Nutshell by Matthew MacDonald

ADO.NET in a Nutshell

Matthew MacDonald

Database System Concepts by Abraham Silberschatz

Database System Concepts

Abraham Silberschatz

Essential System Administration by Æleen Frisch

Essential System Administration

Æleen Frisch

Access Database; Design & Programming by Steven Roman

Access Database; Design & Programming

Steven Roman

Mastering Regular Expressions by Jeffrey E. F. Friedl

Mastering Regular Expressions

Jeffrey E. F. Friedl

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL by Joe Celko

Joe Celko's Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL

Joe Celko

Managing and Using MySQL (2nd Edition) by Tim King

Managing and Using MySQL (2nd Edition)

Tim King

PHP and MySQL for Dynamic Web Sites by Larry Ullman

PHP and MySQL for Dynamic Web Sites

Larry Ullman

Java Database Best Practices by George Reese

Java Database Best Practices

George Reese

MySQL Pocket Reference by George Reese

MySQL Pocket Reference

George Reese

Programming Perl [4th edition, blue camel] by Larry Wall

Programming Perl [4th edition, blue camel]

Larry Wall

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL by Michael J. Hernandez

SQL Queries for Mere Mortals: A Hands-On Guide to Data Manipulation in SQL

Michael J. Hernandez

SQL Performance Tuning by Peter Gulutzan

SQL Performance Tuning

Peter Gulutzan

Fundamentals of Database Systems by Ramez Elmasri

Fundamentals of Database Systems

Computer Networks by Andrew S. Tanenbaum

Computer Networks

Andrew S. Tanenbaum

Sams Teach Yourself SQL in 24 Hours by Ryan Stephens

Sams Teach Yourself SQL in 24 Hours

Ryan Stephens

MySQL in a Nutshell by Russell Dyer

MySQL in a Nutshell

Russell Dyer

Refactoring Databases: Evolutionary Database Design by Scott W. Ambler

Refactoring Databases: Evolutionary Database Design

Scott W. Ambler

Complete Recommendations

Member Reviews

Featured Recent Thumbs

All Ratings
1
1
1
No Rating

1 review

alish 90 reviews

В реальных приложениях, работающих с серверами баз данных, перед разработчиками очень часто встает проблема улучшения производительности SQL-запросов. В этой книге детально и на многочисленных примерах описывается метод, позволяющий кардинально повысить скорость выполнения запросов к базам данных. Прочитав книгу, вы сможете не тратить долгие часы на перебор различных вариантов кода, а максимально show more быстро найти оптимальный способ построения запроса.
Метод настройки SQL-запросов не опирается на случайный или итеративный перебор вариантов кода, а основан на четких и понятных правилах, которые достаточно просты для понимания и основаны на принципах работы SQL-серверов.
Книга будет полезна разработчикам систем, взаимодействующих с базами данных, и всем интересующимся аспектами работы SQL-серверов. show less

Aug 13, 2006Russian

Ratings

annapanna

Jan 14, 2007

gothrabbit 12 reviews