asked
massive load
Hi , I have to load one text file of 6 million records once per month into a fact table has 200 Million records and a few indexes to make it usable. With a wizard loader , the load delays 24 hours...so i am thinking on changing the load into a bulk insert into a staging table and then make a insert to the fact table. Will it be faster to load into a intermediate table and then make a insert into the fact table? I have doubts with disabling the indexes of the fact table before loading with the insert and rebuild after the load. I am not sure if rebuild an index of a fact table with 200 million of records... Thanks in advance.
Do you have a dev/test environment? This questions could be answered by simply running the tests and measuring them. If you don't have a dev/test environment... you have a good argument to ask for it! It's really hard to give a certain advice because there are a lot of variables here and need to consider a lot of things (ex. storage underneath, hardware, SQL Server version/edition, instance/db settings, data type, etc).
18 People are following this question.
