Paste Into from Select Performance SQL Server

Question

I created a query in which I insert the result of a selection from another table into an empty table.

This select takes ~ 20 minutes (30 M rows, 120 columns and Where), but insert takes ~ 1 hour .

Do you have any suggestions for improving it?

What I did, as in the example below.

Insert Into tableA
Select *
From TableB

Appreciate your help!

Answer 1

Drop all indexes on TableA, then paste again:

INSERT INTO tableA
SELECT * FROM TableB

Indexes are known to slow down insertion instructions.

Answer 2

, TableA ( , ..), .

, , TableA. / TableB , . TableB.txt, / TableB.txt TableA. (, SQL Server).

. , BULK_LOGGED, :