I created a test AJI at the end of last week, but I've since lost the text of the index. In SQL Assistant, I can see the index as part of the table in the tree view navigation pane, but I can't get to a "Generate SQL > Create" option in the right-click menu. The table DDL doesn't include the join indexes either.
Is there a DBC view, like all_source in Oracle, that will allow me to see the text of the join indexes I have defined?
Thanks in advance.
I followed the below steps to get the text of Join Index. In This case, the database where join index resides & the database where the table resides (table that JI was pointing to ) was different:
SELECT * FROM dbc.JoinIndicesV
returns the DatabaseName/TableName for both the JI and it's base tables.