Performance tuning can be daunting but rewarding - I love making systems go faster due to my changes. This is a topic where it really helps to have an understanding of internals and some database theory. Those are often discounted but ignorance of them can make tuning guesswork at best and a time suck with no improvement at worst.