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 --- 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. ================================================
