• Silly question, how do I read the execution plan to know what columns to index?

    I created two indexes (just eyeballed query and guessed). The first one seems to have improved the query, but the second one (though being used) still doesn't seem to improve anything.

    -- Two indexes created --

    CREATE NONCLUSTERED INDEX [IX_tblCustomer_CustomerId_EmailAddress] ON [dbo].[tblCustomer]

    (

    [CustomerID] ASC,

    [EmailAddress] ASC

    );

    CREATE NONCLUSTERED INDEX [IX_tboWorkOrder_CustomerID_DatabaseInfoId] ON [dbo].[tblWorkOrder]

    (

    [CustomerID] ASC,

    [DatabaseInfoId] ASC

    );

    Thanks,

    Rob