[lordnacho]

I would guess the most common pitfall is either not having indices or having the wrong kind of index for your query.