Can you include relational data in an index on MS-SQL?
===

I'm on MS Sql Server 2008.

I have a table like so:

    OrderItems
    ===============
    OrderItemID
    InventoryItemID

and another table like so:

    InventoryItems
    ===============
    InventoryItemID
    ItemCode

My query plan shows a lot of time getting sucked into joining the InventoryItemIDs to get the ItemCode for every order item.

I already have a nonclustered that includes both columns on both tables, but would like to make it even faster-- can I "import" the relational ItemCode into the OrderItems table's index?
