Topic: Filling of the big table with full-text query search
In a DB there is table FTI_TABLE (ID bigint, TextFTI NVARCHAR (4000)), on column TextFTI the full-text index is constructed.
Daily (time a day) is imported to this table about 200 million lines, the data never changes and is not deleted, only the INSERTION.
I selected strategy, manual change tracking and once a week start of additional filling of an index.
But faced a problem that if an index not and procedure of an insertion of the data time of filling of the table can began increases from 1 o'clock to 3-5. What me does not arrange, can eat any alternative methods of magnification of speed of performance of the described task?