Oh, and one more thing - 10GB is NOT a large database. My guess is that there are MANY other things you should be doing first to improve your performance before even thinking about partitioning.