I need to consolidate G/L entry table for 16 companies
records are in millions
I have written Insert into Select query with lots of Join statement where I am calling G/L account name, etc from other tables into 1 new consolidated table
It works fine but to speed up
should I simply insert only g/l entry fields first and then update with g/l account name, dimensions,period etc
1 big insert will be better
1. Export original table object
2. Disable SQL maintenance of all secondary keys and Sumindexs
3. Do your import. Not having to update the above for each record will help speed it up.
4. Then re-import the original table object to recreate the keys etc.