Table partitions work well for this, too. You would do your mass import in a table that would be less likely to affect prod queries. After import, then change t

Table partitions work well for this, too. You would do your mass import in a table that would be less likely to affect prod queries. After import, then change the temp table to extend the parent. After that it is used for queries against the parent.