without digging too deep (sometimes the simplest solutions are the best) - try to isolate the "OR" conditions from the rest of the WHERE clause...

SELECT PRD_HEADER.prdkey, PRD_summary.prdkey,

PRD_unit.stockID1,PRD_unit.stockID2,PRD_unit.stockID3,

PRD_unit.stockID4,PRD_unit.stockID5,PRD_unit.stockID6

FROM PRD_HEADER INNER...

I've seen it happen where indexes / exec plans got "stale" after backup/restore; SQL totally ignoring existance of indexes, even though they're there and "should" be used.

I'd start with updating...

Mayank P - Clarion, India (10/26/2010)

---

Yes Phil,

... you restore the back up of database db1 to database db2, and after that if you want to enable broker service on database...

I think I found it somewhere on the net... sorry to original author for not including the credits...

but I found it's quite easy to use Table-valued function to handle the...

sharon (4/30/2008)

---

logshipping will work with your maint plan....

all your transcation logbackup iwll be tkane on the priamry server which will then be copied to our stnadby server and applied there....

how...

if you're using OPENQUERY you are executing the SQL "inside" of the AS/400. AS400.S1019865.NSCDEVDATA.WSZZP100 doesn't exist in the AS/400 world. Try this :

Select * from OPENQUERY(AS400, 'UPDATE  NSCDEVDATA/WSZZP100 SET...