New answers tagged

1

In order to make a decision for bunch of tables you can run procedure "sp_estimate_data_compression_savings": exec sys.sp_estimate_data_compression_savings @Schema,@Table,NULL,NULL,ROW; exec sys.sp_estimate_data_compression_savings @Schema,@Table,NULL,NULL,PAGE; That will help you determine savings for each particular table. From my experience PAGE ...


2

This is a good reference and explanation for row v page (no pun intended) compression: http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/how-sql-server-data-compression/ In short though, page compression encompasses the algorithms contained with row level compression and then also covers Prefix compression and Dictionary compression. Prefix and ...


0

I will try to : Create empty table with indexes DISABLE KEYS Load Data myisampack table myisamchk -rq Hopefully myisamchk will build the indexes without ENABLE KEYS



Top 50 recent answers are included