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)?
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.
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.