0 - 2 of 2 tags for dbql performance comparison

I suppose the first one as all the columns in the join are the UPI of both the tables and statistics are also collected on the UPI.

SELECT CWH.ARTCL_NUM
,CWH.SHIP_SITE_NUM
,CWH.RCV_CUST_NUM
,CWH.SHIP_DT
,CWH.TOT_ORD_QTY
,CWH.EXT_DT
,CWH.REC_CRE_TMS
,CWH.REC_CHNG_TMS

Does your data warehouse contain organizational hierarchies, bills-of-material, or transportation networks? If so, you likely have a good candidate business problem for recursive SQL...