Question on Aggregated Join Index

Database

Question on Aggregated Join Index

I read that it is not recommended to have non-partitioned JI on partitioned base table from a performance point of view. So I have a large table in production with this case. I know I have to test it but want to check with you to see if it is worth spending time to add partitioning on AJI as the performance is ok right now with out the partitioning. 

-Raghu

Tags (1)
2 REPLIES

Re: Question on Aggregated Join Index

Gernally we use Partition column in where clause if we query on paritioned table. To use that advantage, we can make AJI also paritioned. it would be useful when AJI also has lot of records and to avoid unnecessary paritions from search.

However, AJI supposed to have very less data compared to basetable. (as it would already be aggregated). if you feel the base table growth rate is very high and so AJI also, then you can prefer paritioning AJI.

Re: Question on Aggregated Join Index

Thank you Satyanaryana