yes it was indexed. I even tried it by creating a clustered index based on the final component and the finished item and it still runs forever and in the...

I added a Clustered Index to the lookup table, and the plan looked better. The Nested Loop went away and the RID Lookup (Heap) went away. What remained was a...