Questions regarding Aggregate Join Index

Database
Enthusiast

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!

2 REPLIES
Enthusiast

Re: Questions regarding Aggregate Join Index

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.

Enthusiast

Re: Questions regarding Aggregate Join Index

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.