TYVM for the responses! I think I am getter a better understanding of how to deal with this from your suggestions and googling database partitions and indexes.
While my original question's example is wildly unrealistic it is however realistic that my database will have 50,000-100,000 companies with 100-300 products in inventory. Each of...