I guess we can find out the relevance/ frequency of usage of an AJI from the table DBQLObjTbl. Can someone please let me know how?
The purpose is to find out the unused or less used AJIs in the system and thereby dropping them or finding a way to use.
Appreciate any help in this matter.
Hello, you may use QryLogObjectsV (View on DBQLObjTbl) to find the number of queries that hit each AJI.
In the simplest form the query could look like this:
select ObjectTableName, count(QueryID) as Cnt
group by ObjectTableName
order by Cnt