search

TPC-Council / HammerDB

HammerDB Database Load Testing and Benchmarking Tool
http://www.hammerdb.com
GNU General Public License v3.0
589 stars 119 forks source link

Alter MSSQL TPCH Colstore Index Steps #613

Closed JoshInnis closed 1 year ago

JoshInnis commented 1 year ago

Alter the Steps involved in creating colstore indices. Testing the current process in loading data with Colstore indices created before the data is loaded vs after the data is loaded shows a 10-20x improvement when the index is created after loading the data, when BCP is not used. When BCP is used it is more efficient to create the indices before the data is loaded.

sm-shaw commented 1 year ago

I added needed changes with https://github.com/TPC-Council/HammerDB/pull/613/commits/be2c9d3e51040ed2a850e7fd980a7d35e172d272 and have successfully retested