Data Vault Administrator Guide

6.5 HotFix 1
- 6.5.1
- 6.5
- 6.4.4
- 6.4.3 HotFix 1
- 6.4.3

Back Next

After Data Repartitioning

You repartition the data files by the purchase order date. After you repartition the data files, the data files are grouped by the purchase order date.

The following table shows a sample of the data files after you repartition the data files:

Data File	Purchase Order Date	Range of Values
1	9/01/10, 9/02/10, 9/15/10, 9/30/10	9/01/10 - 9/30/10
2	10/15/10, 10/31/10, 10/05/10, 10/01/10	10/01/10 - 10/31/10
3	11/24/10, 11/02/10, 11/28/10, 11/24/10	11/02/10 - 11/28/10
4	12/24/10, 12/31/10, 12/24/10, 12/28/10	12/24/10 - 12/31/10

When you run a query to select the 12/24/10 date, the query only selects data file 4. The query performance increases because the query selects a smaller amount of data files.

Data Repartitioning Example

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal