Overclocking video cards require software to do it. The last video card overclock I did was on an nVidia GeForce and I had a GPU core unlocker/overclock tool which was a "
use at own risk type of tool". I did this long ago when I needed to increase my FPS and didnt want to spend money on a newer video card. I was able to increase my frame rate from 22 fps to 28 fps, as well as drive the temp up on the GeForce GPU up by 13 degrees C in the process from where it use to idle around 57C. So at 70C it was cooking to squeeze out the slightly better frame rate and get rid of the occasional studder of a fraction of a second freeze frame.
More info here:
http://lifehacker.com/how-to-overclock-your-video-card-and-boost-your-gaming-30799346Personally I no longer overclock video cards. If I need better processing power I will just replace the video card with a new one. I use to stretch the life of a video card, but there is more to video cards than just overclocking them for better frame rates.
Introducing a newer better GPU to your system has the advantages of supporting new shaders etc so you will have better quality if the game is able to tap into this GPU technology on top of the faster frame rate. If you are just on the hunt for a faster frame rate with existing video card then a overclock may be what you could do to push it harder and hotter.
Personally I wouldnt just overclock it to overclock it. I'd run whatever games you will be running and see if they play perfectly fine, and if say on Ultra settings you want to increase your frame rate and are willing to take the chance of cooking the GPU overclock it to squeeze out a better frame rate. But if they play fine, leave it running stock speeds.
One other snafu that I have seen some people run into is that they want to overclock a video card and have very little overclock room to push it harder because the video card manufacturer is already overclocking the GPU for the video card that was purchased. So the gain to be had could be very small before it destabilizes or runs dangerously too hot.