I just wanted to know that SQL Statement
INSERT INTO TABLE1 SELECT * FROM TABLE2, will work same like bulk insert ?
If no, Is there any way exclude index while inserting records. Process is inserting 150 Millions data in one execution.
We are planning to create stage table (Which will not have any index
Table1), then transfer it from stage table to target table (Which will have index
We are not in the situation to create flat file from the process.
But we are looking something that can speed up process when we transfer data from
Table1(not indexed) to
Any way to use