there is no answer - or benchmark - you're asking the wrong question. Partitioning is a decision based upon scale ,architecture and application requirements. The performance, in a sense, is gained from the management of data - e.g. not one big table. In sql 2008 filtered and compressed indexes can be useful when using partitions - there are a few things to consider when using partitions though - like maintaining them.
[font="Comic Sans MS"]The GrumpyOldDBA[/font]
www.grumpyolddba.co.uk
http://sqlblogcasts.com/blogs/grumpyolddba/