Block Level Compression (BLC)

Database

Block Level Compression (BLC)

Working with a customer who is moving from TD13.10 to TD15 and also moving from an appliance 2650 to a 2800. The data will be moved via NPARC and all tables will land on the new system in compressed (BLC) format. Question is, would it make sense to alter all the datablocksizes of the large tables to 255 sectors (130,560 bytes) prior to the NPARC to obtain the optimal compression on the new platform. Almost all the tables on the current system are set at the default of 127 sectors.  Looking for guidance from anyone that has gone through this exercise.  Chet