>>1. Build temp table from table definition
>>2. Import new data provided from outside source
>>3. Index (answering your question, yes, on fresh data)
>>4. Rename old table
>>5. Rename temp table to bring it "live"
>
>Seems to me that this may be faster (and close to what Ken was asking for) if you changed the process to:
>
>1. Build temp table from definition
>2. Index temp table (define indices before import)
>3. Import new data (Fox updates all indexes simultaneously in background)
>4. Rename old table
>5. Rename temp table to live table name
>
>This is untested, just brainstorming, and may be considerably slower, not faster, for all I know. In fact, I may have read tips from various experts (Goley?, Hennig?) that my suggestion is the bad way, and Ken's process is the fast way...
>
>Will be very interested in your reactions...
>
>Rich.
I think that a table with no index will load faster than a table with index. That is why I reccommend to lose the index add the data then add the index back.
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope