Обсуждение: When is it worth it to drop indexes on bulk loads?

Поиск
Список
Период
Сортировка

When is it worth it to drop indexes on bulk loads?

От
Francisco Reyes
Дата:
Any general ideas when it may be worth dropping an index when bulk
loading data?

I have a number of tables which I would be copying over every night from
another system. Some are as small as 50K records while others are 500K+. I
am just curious what is the borderline? 100K rows?

I am using the copy command.