August 2002
Intermediate to advanced
528 pages
10h 12m
English
The next chapter will discuss techniques and tools that can be used to increase the performance of your SQL statements. The chapter will discuss the various indexes that can be used and will also discuss EXPLAIN, which is used to learn what work an SQL statement must perform. Finally, the chapter will discuss when to use a full table scan rather than an index lookup and how to optimize joins, grouping, and sorting operations.