>I'm not sure what you mean by "only first time creation of an index take time." I append the 5.5Meg record table once a week with 40Kilo records. Table then auto-re-indexes the 6 indexes. Takes over a half hour. I should mention this is over Novell 4.1 LAN. Difference is remarkable if table is local; only takes a couple of seconds.
There shouldn't be such huge difference between local and network table indexing. In my experince the difference is usually 10-30 times on well configured network.
--sb--