| Dictionary compression mainly helps to search duplicate values on the pages and stores them in CI. The main difference between prefix and dictionary compression is that we can do prefix only on a single column at a time but dictionary compression we can do this for complete page. | | |