Skip to Content
Former Member
Oct 25, 2007 at 02:49 PM

Sorting table inserts?


Does anybody know if you gain any efficiency if you sort an internal table before you insert it into a database table? The database table would be empty to begin and then records would be added 5,000 at a time - for a total of up to 850,000 records. Would I gain anything if I inserted the records pre-sorted so that each insert was essentially appending to the end of the database table?

Thank you!