I tend to agree also.  Like Tomm Carr said, automated tools can only do so much.  In this case I would probably have a Primary Clustered index on Vendor_Id, Product_Id...