Kind of depends on the db and engine being used, but for MySQL, this book has been very good in helping me optimize sensitive queries: High Performance MySQL b

Kind of depends on the db and engine being used, but for MySQL, this book has been very good in helping me optimize sensitive queries: High Performance MySQL by Jeremy D. Zawodny