Clustered Columnstore Index: Massively Parallel Trickle Insert

added by DotNetKicks
6/4/2018 9:51:20 PM

1 Kicks, 1451 Views

A traditional scenario of loading data into CCI is a nightly load from one or more data files containing millions of rows. Recommended technique is to load the data with batchsize >= 102400 as explained https://blogs.msdn.microsoft.com/sqlserverstorageengine/2014/07/27/clustered-column-store-index-bulk-loading-the-data/. However, we are seeing many scenarios where data source is parallel data stream (i.e.


0 comments