Skip to Main Content
Sams Teach Yourself MySQL in 21 Days, Second Edition
book

Sams Teach Yourself MySQL in 21 Days, Second Edition

by Tony Butcher
December 2002
Beginner content levelBeginner
640 pages
16h 41m
English
Sams
Content preview from Sams Teach Yourself MySQL in 21 Days, Second Edition

Commands for Optimization

Now that you've had a tour of the principal things influencing database performance, it's time to spend a little time looking at the commands MySQL offers for improving the speed of your queries and the design of your tables.

Improving Tables for Joins and Other SELECT Queries: EXPLAIN

You heard previously that it's usually wise to add indexes to a table. In fact, if you are working with relatively large tables, the use of indexes is one of the biggest influencers of overall database performance.

You've read some rules-of-thumb about where to apply indexes—such as wherever a column is named in a WHERE clause, or where that column may be used as part of a join. But how can you be sure that you've applied them correctly? ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Sams Teach Yourself MySQL

Sams Teach Yourself MySQL

Chris Newman
Oracle® Database 10g Insider Solutions

Oracle® Database 10g Insider Solutions

Arun Kumar R., John Kanagaraj, Richard Stroupe
MySQL and mSQL

MySQL and mSQL

Tim King, George Reese, Randy Yarger
Jump Start MySQL

Jump Start MySQL

Timothy Boronczyk

Publisher Resources

ISBN: 0672323923Purchase book