Yes, you can see improvement on proc execution time, but not really on CPU or resources because that is what this power save option is doing so your CPU will...
Aren't partitioned views being deprecated anyway? I'm pretty sure I read somewhere where they are being deprecated in 2005 or 2008, but can't find where I read that so...