I am not sure if this would make a difference but don't you need a 1 to 1 relationship between the tables? Maybe the Cust_No is not Unique?
Marc From: John Engwer Sent: Monday, November 09, 2009 10:07 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Update taking a long time 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
