Archives of the TeradataForum

Message Posted: Tue, 14 Nov 2006 @ 14:49:25 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Yes,

----------------------------

Description

Enable Partitioned Primary Indexes for non-compressed Join Indexes Benefits

Enables users to improve query performance by leveraging both Join Index and PPI benefits.PPI JI, especially aggregate PPI JIs (AJIs), can greatly improve the performance of the OLAP queries generated by certain BI tools and analytic applications.

For example, the execution of a certain test query (SELECT) only needs to access 12 out of 192 partitions which saves up to 94% disk reads in a SUM step, compared with a corresponding non-PPI JI which would entail a full table scan.

	<Prev	Next>		<<First	<Prev	Next>	Last>>