[RBASE-L] - When to Index

[Bruce A. Chitiea]

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