All Forums Database
N_Raghu 34 posts Joined 12/13
26 Feb 2015
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

-Raghu
Tags:
28 Feb 2015

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.
 

Satyanarayana

N_Raghu 34 posts Joined 12/13
28 Feb 2015

Thank you Satyanaryana

-Raghu

You must sign in to leave a comment.