>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.
Rich Addison, Micro Vane, Inc., Kalamazoo, MI
Relax, don't worry, have a homebrew.
- Charlie Papazian, The New Complete Joy of Home Brewing