• Absolutely understand and he said I can just now. So I will get all that together. There certainly wouldn't be a covering index for the query because we would never select * like I have done for this test so this one is going to do a look-up for sure for the non covered columns.

    I don't always test my SQL scripts, but when I do, I test in Production.