There are 3 indexes on the tuserprod table,
usergrp, - refers to which usergroup has rights to access this
code_type, - refers to the module that is applicable, ie sales, purchase
prodcode - refers to the inventory item

It's non clustered and non unique.
It was there since the database was created about 2 months back.
Yau