All Forums Database
addsmiles 13 posts Joined 01/12
28 Mar 2013
Questions regarding Aggregate Join Index

Dear All,
We are on TD 13 and want to create an AJI, however the number of columns we need to include exceeds the 64 column limit.  Can the gurus help me with some suggestions on the ways around this?
For example, if we build two AJIs with some columns in each to cover all the columns, will a query to fetch data for all the columns utilize these AJIs?
Also are we going to see an increase in the AJI column limit in future TD releases (TD 14 or later)?
Thank you!
 
 
 

KS42982 137 posts Joined 12/12
29 Mar 2013

We had a similar kind of issue couple of years ago. What we did was something like vertical partitioning of the table. Meaning, created another table with the same keys and remaining columns that we need AJI on and joined these 2 tables in a view.

VandeBergB 182 posts Joined 09/06
29 Mar 2013

You can build two JI's to "vertically partition" as KS suggested.  Your explain plan should show a join between the JI's without even accessing the underlying tables, if you've got it built up correctly.

Some drink from the fountain of knowledge, others just gargle.

You must sign in to leave a comment.