AJI Size


AJI Size

I have a table by STR, PRODUCT, DAY and SALE_TYPE and SALES$ that i around 250 GB. I have some column compressed in the table DDL. I create an AJI on top of the table grouping by STR,PRODUCT, DAY and SUM(SALES). Strangley the size of the AJI is much bigger then the size of the table itself around 450 GB

I am suing the standard syntax for creating the AJI. Have you guys had any such prior experineces? This defeats the purpose of AJI as I may as well create a physical table

Let me know if you need any additional details?