0 - 8 of 8 tags for aji

I read that it is not recommended to have non-partitioned JI on partitioned base table from a performance point of view. So I have a large table in production with this case.

Hello All -


I am testing AJI usage on a query and am trying to understand why the using the analytics would ignore the AJI….

The following query snapshot uses the JI (JI3_TRANS_DETAIL_GL)

This session provides information on the basic concepts of Partitioned Primary Indexes.


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.


This is more than an overview of the Indexes that are available in Teradata and how they work.

The Teradata Database offers a unique native capability, the Aggregate Join Index (AJI), to help support multi-dimensional Business Intelligence solutions.  An AJI is an aggregated result set saved as an index in the database.  The AJI will be used automatically by the Teradata Optimizer when like columns and aggregates are made frequently within a query

I m currently working on AJI,I wonder how the quires hit the AJI.I will get report from cognos, It consists of quires. I should run EXPLAIN on each quirey whether it hits the AJI or not?

My question is?

Suppose I created one AJI for example as shown below. Now, i got quirey from cognos.
wht r the conditions for a qury to hit the AJI?

1)Does the columns of query should match with AJI columns?
2)Does the columns of query should match with AJI join coumns?
3)Does the columns of AJI should match with where condition of query?