Sql Performance

Good Articles:

http://www.devshed.com/c/a/MySQL/SQL-Performance-and-Tuning-Considerations/3/

http://www.devshed.com/c/a/MySQL/SQL-Performance-and-Tuning-Considerations/4/

This is a five part article – have a look at the others, but the rest are pretty basic. Note this is also for MySQL, so check any detail.