![]() |
Sorry for the ancient version, everybody who's moved on!
23 Nov 2012
| 3 comments
,
|
![]() |
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: What is the optimal implementation in terms of request performance?
06 Jan 2012
| 2 comments
,
|
![]() |
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).
24 Aug 2011
,
|