Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)

Team-Fly    
 
Sams Teach Yourself SQL in 24 Hours, Third Edition

By Ronald R. Plew, Ryan K. Stephens

Table of Contents
Part V.  SQL Performance Tuning

Hour 17. Improving Database Performance

During this hour, you learn how to tune your SQL statement for maximum performance using some very simple methods .

The highlights of this hour include

  • What SQL statement tuning is

  • Database tuning versus SQL statement tuning

  • Formatting your SQL statement

  • Properly joining tables

  • The most restrictive condition

  • Full table scans

  • Invoking the use of indexes

  • Avoiding the use of OR and HAVING

  • Avoiding large sort operations

Team-Fly    
Top
 

Related

Категории