Need a Non-Unique Index on CSE_PARTS_LIST_COMPONENTS by Org and Item
SummaryTo find obsolete MRO inventory parts we need an index into the CSE_PARTS_LIST_COMPONENTS table to search it effectively
Our client uses the Asset Parts List extensively and associates every MRO item to an asset. (Common items are associated to the warehouse.) Once an asset is retired very likely there could be MRO items associated with that asset in the warehouse taking up space, items that they could sell to recoup some of their cost.
A non-unique index on the CSE_PARTS_LIST_COMPONENTS table by Item_Organization_ID and Item_ID would allow us to quickly compare the warehouse's inventory with the Assets Parts List to see whether these obsolete inventory items exist.