|
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.
,
26 Feb 2015
| 2 comments
|
|
|
|
|
|
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)
,
26 Aug 2013
|
|
This session provides information on the basic concepts of Partitioned Primary Indexes.
,
25 Feb 2013
| 12 comments
|
|
|
Hi, 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.
,
28 Nov 2011
| 1 comment
|
|
|
This is more than an overview of the Indexes that are available in Teradata and how they work.
,
06 Apr 2011
| 3 comments
|
|
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
,
26 Jul 2010
|
|
|
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. 1)Does the columns of query should match with AJI columns?
,
15 May 2010
| 2 comments
|