New answers tagged


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 ...


This is a good reference and explanation for row v page (no pun intended) 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 ...


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