Thanks Buddy. Totally works in this context. Bruce
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Buddy Walker Sent: Sunday, January 25, 2015 1:38 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: When to Index Bruce What I've done in the past is consider the time it takes to load records into a table that is already indexed and the time it takes to create the index afterwards. If the table isn't going to be used until all the records are loaded then I would create the index after all records are loaded. Buddy -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: Sunday, January 25, 2015 4:16 PM To: RBASE-L Mailing List Subject: [RBASE-L] - When to Index I have a "batch process" looping routine which populates a temp table just created with the CREATE TEMP TABLE command. Is there any "blanket" consensus about WHEN to create indexes? Should I CREATE INDEX(es) before entering the looping routine, or upon loop exit? Thanks much Bruce Chitiea SafeSectors, Inc. eCondoMetrics 909.238.9012 cell
