0 - 3 of 3 tags for multi level partitioned primary index
Partitioning in V12, utilising MOD

Sorry for the ancient version, everybody who's moved on!
I am trying to check my maths skills and coming up empty.
Basically, I have read that there is a way to effectively implement v13 multilevel partitioning in v12, via the mod statement.

By colink2000au, 23 Nov 2012 | Tagged: multi level partitioned primary index mulitlevel partitioning partitioning expressions | 3 comments
MPPI consideration (multi level partitioned primary index)

We have a large transaction table for a global implementation is being created that has the columns Region_Id, Location_Id, and Transaction_Dt. The table contains five years of data and the filters will primarily be on the columns identified. In reviewing the data demographics, below things were observed:
• The Region_Id has 10 distinct values
• The Location_Id has 2,000 distinct values
• The Transaction_Dt typically has 200,000 rows per value

What is the optimal implementation in terms of request performance?

By Srihari.teradata, 06 Jan 2012 | Tagged: ppi multi level partitioned primary index mppi | 2 comments
How to Determine Candidates for Multi-Level Partitioned Primary Index with DBQL

One of the more difficult challenges in database management and administration is determining where and how to implement a new RDBMS feature or function. In this presentation we’ll look at the DBQL data available for evaluation of tables and columns used within a workload and how this data can be leveraged for determining candidates for MLPPI (Multi-Level Partitioned Primary Index).

By DebraH, 24 Aug 2011 | Tagged: dbql performance tuning mlppi multi level partitioned primary index