I've been reading about the benefit of optimizing internal linking structure to prevent pages from going supplemental. The main reason why I'm so concerned about supplemental results is because we are planning to redesign our website using database-driven, dynamically created content. We have a large database of part numbers, and we want to create pages for each one of them. Problem with that is, of course, we're probably going to end up in the sup's. So, my solution to the problem is to use noindex tags for each of those dynamically created pages in order to prevent my link juice from being distributed throughout the pages that I know have duplicate content as opposed to the ones that don't. However, I'm wondering if that is even necessary. From what I've learned about supplementals, Google doesn't remove those pages from the index, they are just "buried" a little deeper. So, if I search for "bluewidget", and that keyphrase is pretty competitive, chances are that my supplemental page won't be able to compete with those that aren't in the sup's. But, because we have a huge list of part #'s and most of them aren't searched for very often, it makes sense that my page, even though it is supplemental, will still rank pretty well due to lack of competition. With that said, the question remains; Do I prevent Google from indexing my duplicate product pages, or do I allow them to be indexed, allow them to go supplemental and see where they end up in the SERP's? Also, does having a greater amount of supplemental pages hurt my overall ranking?
imo you should always try to remove duplicated contents if you can. That will bring heavier rank. However most product pages are not duplicate pages. just look at amazon. It has tons of product pages and although (let's say) most of them are in the supplemental, if the keyword is right it will come up at the top.