If you're trying to get queries running faster, don't waste your time looking at partitioning, it's not a general performance tuning technique. Performance improvements are possible from partitioning, but it usually requires that the queries are written specifically to take advantage of the partitioning.