I am trying to update a column in temporary table t2008 based on data in temporary table t2007. There are about 4000 - 5000 rows in each table and the column CUST_NO is indexed in both tables.
I am trying to figure out why the update takes so long, approximately 3 minutes. That seem like an excessive amount of time with only 4000 rows in the tables. UPDATE t2008 SET Receipt ='Y' FROM t2008 t1,t2007 t2 WHERE t1.CUST_NO = t2.CUST_NO Using V8, 11/02/2009 build John
