Angry Birds of Database Performance Tuning

Tell Others About This Story:

Database developers and DBAs often play the role of gunslinger, or a hired gunman. Someone brought in to ‘kill’ the bad guy, in this case, an under-performing database. Our tools of the trade are not as dramatic as firearms, but we can do just as much damage.

Ever heard of Angry Birds? In this mobile game, users get various weapons (in the form of Angry Birds) to launch at the naughty piggies.

What are your favorite weapons?

Since @oatmeal gave free and open license to his artwork, I felt obligated as a blogger to borrow them! One of the most challenging things for me as a writer is finding relevant, compelling artwork or themes for my posts. So this blog kind of wrote itself!

By the way, we’ve updated our arsenal here at Oracle since I first wrote this post back in 2011. Things like In-Memory, dynamic execution plans, and of course all the goodies in our SQL Tuning pack. But for this post I was going for the more ground-level weapons…

Bird Database Tactic
Indexes Everyone LOVES to use indexes. Powerful, easy to deploy. Work on most levels. Take out all the piggies with one shot, and you get bonus points.
Hints Requires great precision. Some people hate them, others love them. Often seem to fly off with little or no effect.
Parallelism Instead of just 1 little annoying bird, how about 3? Perfect for certain levels, seemingly useless on others.
Common Sense There’s no magic with this bird. You need to solve this level by using your head. This is the entry level bird in the game, and it should be your first weapon of choice in the database too. Instead of using some performance hack or undocumented tweak, maybe you just just ask for less data?
Related Posts Plugin for WordPress, Blogger...
Tell Others About This Story:

Similar Posts by Content Area: , , , ,