Razzak, I create the tables and indexes just before I perform the update. However, per your suggestion, I did pack index and the results are the same.
John -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of A. Razzak Memon Sent: Monday, November 09, 2009 11:55 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: Update taking a long time At 11:07 PM 11/9/2009, John Engwer wrote: >UPDATE t2008 SET Receipt ='Y' FROM t2008 t1,t2007 t2 WHERE >t1.CUST_NO = t2.CUST_NO >Using V8, 11/02/2009 build John, Have you PACKed the INDEXes since you have applied the last update? Using the latest update of R:BASE Turbo V-8 (Build: 8.0.22.31102 or higher), try the following: 01. Start RBG8 and CONNect dbname 02. At the R> prompt: SET FEEDBACK ON PACK INDEX CLS SET FEEDBACK OFF 03. Now CREATE the TEMPORARY table accordingly and do the UPDATE as outlined above. See what you get. Very Best R:egards, Razzak. --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
