ASA SQL User's Guide
Monitoring and Improving Performance
Top performance tips
If you find yourself loading huge amounts of information into your database, you can benefit from the special tools provided for these tasks.
If you are loading large files, it is more efficient to create indexes on the table after the data is loaded.
For information on improving bulk operation performance, see Performance considerations of moving data.