I did some more digging and it actually tells me exactly what I want. It shows me that I've set up my developers in a very poor fashion

Wow! That's quite the script. I went through it and then ran it on a dev box to see what results I would get and I'm impressed. ...

Yes, the variable types match. I played around with a few different indexes and it looks like I found a good combination. The biggest problems were the bookmark...

Here's the modified query, but it's still taking close to 1 minute to run.

DBCC DROPCLEANBUFFERS WITH NO_INFOMSGS

DECLARE @dlrcode char(10)

DECLARE @vendor_cross varchar(20)

SET @dlrcode = '10201'

SET @vendor_cross = '0973390'

SELECT PS.item_number, PS.order_date, PS.order_number,...

I'll do my best to answer all questions here.

The query should return 14 rows.

sopinh contains 1,062,065 records

sopind contains 4,952,917 records

I did a DBCC SHOWCONTIG on both tables and the scan...

Well, there's an index seek going on for the sopind.item_number field and the bookmark lookup is on that branch. So, I assume that's what you're asking. These are...

What's the best way to get the DDL for you?

The Loginlog table contains 2,025,274 records.

That doesn't make any difference in the query performance.

The query is still performing TABLE SPOOLS and LAZY SPOOLS.

Any other ideas?

StmtText ...