>Hi everybody,
>
>We're having this problem: our SQL produces ~1000000 records. SQL works fast. Then we need to place this records into Database with predefined structure, indexes, etc. So, firstly it prepares a shell Database and a table and then uses Append from command (runs DeNull program in between). This operation takes already ~15 min. and it's not finished yet. What can you suggest to optimize it?
>
>Thanks in advance.

---

If it's possible to open the target table EXCLUSIVE, that can speed up the process significantly.