In this article, we will show you how Block-Level Compression, Row-level partitioning, and the selected data block size of a table can affect performance and table size. For this demonstration, we need a test table on which we will make various changes to these settings. Our test table includes customer data and a cut-off date.

Read More