#DateForumTypeThreadPost
315 Feb 2012 @ 03:58 PSTAnalyticsReplyAJI Hits Report from DBQLObjTbl table - Query? 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 ObjectTable...
215 Feb 2012 @ 02:22 PSTGeneralReplyAJI Thumb rule is to have all the columns used in query (select, where, group by clause) to be in AJIs group by and select clause. E.g. If the query is Select c11, c12, sum(c19) from...
115 Feb 2012 @ 02:14 PSTDatabaseReplyAJI and outer joins queries on Base table OUTER JOINS are not allowed in AJIs. They are only allowed in simple Join Indexes. however, would have loved if this was possible. And of course, AJI with inner join will not be picked ...