Hour 16. Using Indexes to Improve Performance

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 16. Using Indexes to Improve Performance

During this hour, you learn how to improve SQL statement performance by creating and using indexes.

You begin with the CREATE INDEX command and learn how to use indexes that have been created on tables.

The highlights of this hour include

  • How to create an index

  • How indexes work

  • The different types of indexes

  • When to use indexes

  • When not to use indexes


Team-Fly    
Top
 


Sams Teach Yourself SQL in 24 Hours
Sams Teach Yourself SQL in 24 Hours (5th Edition) (Sams Teach Yourself -- Hours)
ISBN: 0672335417
EAN: 2147483647
Year: 2002
Pages: 275

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net