Tags for dbql performance comparison
Which of the following query will be good in performance??
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
dbql performance comparison
Recursive SQL for Solving Real Business Problems
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...
sql recursive sql dbql performance comparison