Connected to: DBI:mysql:database=foodmart;host=localhost
Including information for versions: 4.1, 5.0, 5.1
Table List
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| account_parent |
smallint(6) |
|
MUL |
4 |
4 |
4 |
| account_description |
varchar(30) |
Y |
|
32 |
32 |
16* |
| account_rollup |
varchar(30) |
Y |
|
32 |
32 |
4* |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| account_type |
varchar(30) |
Y |
|
32 |
32 |
8* |
| account_id |
smallint(6) |
|
UNI |
4 |
4 |
4 |
| custom_members |
varchar(255) |
Y |
|
256 |
256 |
120* |
| Fixed Size Columns DM/Row
|
|
|
|
368
|
368
|
16
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
148
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_account_parent |
BTREE |
16 |
16 |
16 |
| i_account_id |
BTREE |
N/A |
N/A |
N/A |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
32
|
32
|
32
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| account_account_id$unique |
24 |
24 |
32 |
| This DataMemory/Row
|
416
|
416
|
68
|
| Total DM/Row (inludes DM in other tables)
|
440
|
440
|
100
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_account_parent |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| account_account_id$unique |
29 |
16 |
16 |
| Total Suppt IM/Row
|
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
416 |
416 |
68 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
160 |
Memory Calculations
| No. Rows |
11 |
11 |
11 |
| Rows/32kb DM Page |
78 |
78 |
480 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
204 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| account_id |
smallint(6) |
|
UNI |
4 |
4 |
4 |
| Fixed Size Columns DM/Row
|
|
|
|
12
|
12
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
29 |
16 |
16 |
| Indexes IM/Row |
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
24 |
24 |
32 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
11 |
11 |
11 |
| Rows/32kb DM Page |
1360 |
1360 |
1020 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
282 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| category_id |
varchar(30) |
|
PRI |
32 |
32 |
32 |
| category_parent |
varchar(30) |
|
MUL |
32 |
32 |
32 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| category_description |
varchar(30) |
Y |
|
32 |
32 |
24* |
| category_rollup |
varchar(255) |
Y |
|
256 |
256 |
4* |
| Fixed Size Columns DM/Row
|
|
|
|
360
|
360
|
72
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
28
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_category_parent |
BTREE |
16 |
16 |
16 |
| i_category_id |
BTREE |
N/A |
N/A |
N/A |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
32
|
32
|
32
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| category_category_id$unique |
52 |
52 |
60 |
| This DataMemory/Row
|
408
|
408
|
124
|
| Total DM/Row (inludes DM in other tables)
|
460
|
460
|
184
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_category_parent |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| category_category_id$unique |
57 |
16 |
16 |
| Total Suppt IM/Row
|
57
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
408 |
408 |
124 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
40 |
Memory Calculations
| No. Rows |
4 |
4 |
4 |
| Rows/32kb DM Page |
80 |
80 |
263 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
816 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| category_id |
varchar(30) |
|
PRI |
32 |
32 |
32 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
40
|
40
|
40
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
57 |
16 |
16 |
| Indexes IM/Row |
57
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
52 |
52 |
60 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
4 |
4 |
4 |
| Rows/32kb DM Page |
627 |
627 |
544 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
143 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| currency |
varchar(30) |
Y |
|
32 |
32 |
12* |
| currency_id |
smallint(6) |
|
MUL |
4 |
4 |
4 |
| date |
date |
|
|
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| conversion_ratio |
decimal(10,2) |
|
|
N/A |
N/A |
N/A |
| Fixed Size Columns DM/Row
|
|
|
|
48
|
48
|
16
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
12
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_currency |
BTREE |
N/A |
N/A |
N/A |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
16
|
16
|
16
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| currency_currency_id_date$unique |
28 |
28 |
36 |
| This DataMemory/Row
|
80
|
80
|
52
|
| Total DM/Row (inludes DM in other tables)
|
108
|
108
|
88
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| currency_currency_id_date$unique |
33 |
16 |
16 |
| Total Suppt IM/Row
|
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
80 |
80 |
52 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
20 |
Memory Calculations
| No. Rows |
72 |
72 |
72 |
| Rows/32kb DM Page |
408 |
408 |
627 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
1632 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| currency_id |
smallint(6) |
|
MUL |
4 |
4 |
4 |
| date |
date |
|
|
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
16
|
16
|
16
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
28 |
28 |
36 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
72 |
72 |
72 |
| Rows/32kb DM Page |
1165 |
1165 |
906 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| customer_region_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| address3 |
varchar(30) |
Y |
|
32 |
32 |
4* |
| marital_status |
varchar(30) |
Y |
|
32 |
32 |
4* |
| date_accnt_opened |
date |
|
|
4 |
4 |
4 |
| num_cars_owned |
int(11) |
|
|
4 |
4 |
4 |
| fname |
varchar(30) |
|
MUL |
32 |
32 |
32 |
| total_children |
smallint(6) |
|
|
4 |
4 |
4 |
| ordinal |
int(11) |
|
|
4 |
4 |
4 |
| city |
varchar(30) |
Y |
|
32 |
32 |
12* |
| customer_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| postal_code |
varchar(30) |
|
MUL |
32 |
32 |
32 |
| num_children_at_home |
smallint(6) |
|
MUL |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| mi |
varchar(30) |
Y |
|
32 |
32 |
4* |
| gender |
varchar(30) |
Y |
|
32 |
32 |
4* |
| houseowner |
varchar(30) |
Y |
|
32 |
32 |
4* |
| country |
varchar(30) |
Y |
|
32 |
32 |
8* |
| address4 |
varchar(30) |
Y |
|
32 |
32 |
4* |
| education |
varchar(30) |
Y |
|
32 |
32 |
20* |
| birthdate |
date |
|
|
4 |
4 |
4 |
| member_card |
varchar(30) |
Y |
|
32 |
32 |
8* |
| occupation |
varchar(30) |
Y |
|
32 |
32 |
12* |
| address2 |
varchar(30) |
Y |
|
32 |
32 |
8* |
| account_num |
bigint(20) |
|
MUL |
8 |
8 |
8 |
| yearly_income |
varchar(30) |
Y |
|
32 |
32 |
16* |
| phone1 |
varchar(30) |
Y |
|
32 |
32 |
16* |
| lname |
varchar(30) |
|
MUL |
32 |
32 |
32 |
| state_province |
varchar(30) |
Y |
|
32 |
32 |
4* |
| address1 |
varchar(30) |
Y |
|
32 |
32 |
20* |
| phone2 |
varchar(30) |
Y |
|
32 |
32 |
16* |
| Fixed Size Columns DM/Row
|
|
|
|
688
|
688
|
144
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
164
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_customer_children_at_home |
BTREE |
16 |
16 |
16 |
| i_customer_id |
BTREE |
N/A |
N/A |
N/A |
| i_customer_region_id |
BTREE |
16 |
16 |
16 |
| i_customer_postal_code |
BTREE |
16 |
16 |
16 |
| i_account_num |
BTREE |
16 |
16 |
16 |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| i_customer_lname |
BTREE |
16 |
16 |
16 |
| i_customer_fname |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
112
|
112
|
112
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| customer_customer_id$unique |
24 |
24 |
32 |
| This DataMemory/Row
|
816
|
816
|
276
|
| Total DM/Row (inludes DM in other tables)
|
840
|
840
|
308
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_customer_children_at_home |
N/A |
N/A |
N/A |
| i_customer_region_id |
N/A |
N/A |
N/A |
| i_customer_postal_code |
N/A |
N/A |
N/A |
| i_account_num |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| i_customer_lname |
N/A |
N/A |
N/A |
| i_customer_fname |
N/A |
N/A |
N/A |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| customer_customer_id$unique |
29 |
16 |
16 |
| Total Suppt IM/Row
|
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
816 |
816 |
276 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
176 |
Memory Calculations
| No. Rows |
10281 |
10281 |
10281 |
| Rows/32kb DM Page |
40 |
40 |
118 |
| Fixedsize DataMemory (KB) |
8256 |
8256 |
2816 |
| Rows/32kb Varsize DM Page |
0 |
0 |
185 |
| Varsize DataMemory (KB) |
0 |
0 |
1792 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
336 |
168 |
168 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| customer_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
12
|
12
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
29 |
16 |
16 |
| Indexes IM/Row |
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
24 |
24 |
32 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
10281 |
10281 |
10281 |
| Rows/32kb DM Page |
1360 |
1360 |
1020 |
| Fixedsize DataMemory (KB) |
256 |
256 |
352 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
282 |
512 |
512 |
| IndexMemory (KB) |
296 |
168 |
168 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| week_day |
varchar(30) |
Y |
|
32 |
32 |
12* |
| day |
int(11) |
|
|
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
44
|
44
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
12
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
16
|
16
|
16
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
72 |
72 |
44 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
20 |
Memory Calculations
| No. Rows |
7 |
7 |
7 |
| Rows/32kb DM Page |
453 |
453 |
741 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
1632 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| department_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| department_description |
varchar(30) |
Y |
|
32 |
32 |
24* |
| Fixed Size Columns DM/Row
|
|
|
|
44
|
44
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
24
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_department_id |
BTREE |
N/A |
N/A |
N/A |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
16
|
16
|
16
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| department_department_id$unique |
24 |
24 |
32 |
| This DataMemory/Row
|
72
|
72
|
44
|
| Total DM/Row (inludes DM in other tables)
|
96
|
96
|
76
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| department_department_id$unique |
29 |
16 |
16 |
| Total Suppt IM/Row
|
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
72 |
72 |
44 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
32 |
Memory Calculations
| No. Rows |
12 |
12 |
12 |
| Rows/32kb DM Page |
453 |
453 |
741 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
1020 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| department_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
12
|
12
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
29 |
16 |
16 |
| Indexes IM/Row |
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
24 |
24 |
32 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
12 |
12 |
12 |
| Rows/32kb DM Page |
1360 |
1360 |
1020 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
282 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| store_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| marital_status |
varchar(30) |
Y |
|
32 |
32 |
4* |
| position_id |
int(11) |
|
|
4 |
4 |
4 |
| last_name |
varchar(30) |
Y |
|
32 |
32 |
8* |
| education_level |
varchar(30) |
Y |
|
32 |
32 |
20* |
| supervisor_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| hire_date |
timestamp |
|
|
4 |
4 |
4 |
| employee_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| department_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| gender |
varchar(30) |
Y |
|
32 |
32 |
4* |
| management_role |
varchar(255) |
Y |
|
256 |
256 |
20* |
| full_name |
varchar(30) |
Y |
|
32 |
32 |
16* |
| birth_date |
date |
|
|
4 |
4 |
4 |
| salary |
decimal(10,2) |
|
|
N/A |
N/A |
N/A |
| position_title |
varchar(30) |
Y |
|
32 |
32 |
24* |
| end_date |
timestamp |
|
|
4 |
4 |
4 |
| first_name |
varchar(30) |
Y |
|
32 |
32 |
8* |
| Fixed Size Columns DM/Row
|
|
|
|
520
|
520
|
40
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
104
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_employee_store_id |
BTREE |
16 |
16 |
16 |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| i_employee_id |
BTREE |
N/A |
N/A |
N/A |
| i_employee_department_id |
BTREE |
16 |
16 |
16 |
| i_employee_supervisor_id |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
64
|
64
|
64
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| employee_employee_id$unique |
24 |
24 |
32 |
| This DataMemory/Row
|
600
|
600
|
124
|
| Total DM/Row (inludes DM in other tables)
|
624
|
624
|
156
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_employee_store_id |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| i_employee_department_id |
N/A |
N/A |
N/A |
| i_employee_supervisor_id |
N/A |
N/A |
N/A |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| employee_employee_id$unique |
29 |
16 |
16 |
| Total Suppt IM/Row
|
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
600 |
600 |
124 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
116 |
Memory Calculations
| No. Rows |
1155 |
1155 |
1155 |
| Rows/32kb DM Page |
54 |
54 |
263 |
| Fixedsize DataMemory (KB) |
704 |
704 |
160 |
| Rows/32kb Varsize DM Page |
0 |
0 |
281 |
| Varsize DataMemory (KB) |
0 |
0 |
160 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
40 |
24 |
24 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| employee_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
12
|
12
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
29 |
16 |
16 |
| Indexes IM/Row |
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
24 |
24 |
32 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
1155 |
1155 |
1155 |
| Rows/32kb DM Page |
1360 |
1360 |
1020 |
| Fixedsize DataMemory (KB) |
32 |
32 |
64 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
282 |
512 |
512 |
| IndexMemory (KB) |
40 |
24 |
24 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| time_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| store_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| category_id |
varchar(30) |
Y |
|
32 |
32 |
8* |
| currency_id |
int(11) |
|
|
4 |
4 |
4 |
| amount |
decimal(10,2) |
|
|
N/A |
N/A |
N/A |
| exp_date |
date |
|
|
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| account_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| Fixed Size Columns DM/Row
|
|
|
|
60
|
60
|
28
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
8
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_expense_time_id |
BTREE |
16 |
16 |
16 |
| i_expense_account_id |
BTREE |
16 |
16 |
16 |
| i_expense_store_id |
BTREE |
16 |
16 |
16 |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
64
|
64
|
64
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_expense_time_id |
N/A |
N/A |
N/A |
| i_expense_account_id |
N/A |
N/A |
N/A |
| i_expense_store_id |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
136 |
136 |
108 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
16 |
Memory Calculations
| No. Rows |
2400 |
2400 |
2400 |
| Rows/32kb DM Page |
240 |
240 |
302 |
| Fixedsize DataMemory (KB) |
320 |
320 |
256 |
| Rows/32kb Varsize DM Page |
0 |
0 |
2040 |
| Varsize DataMemory (KB) |
0 |
0 |
64 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
80 |
40 |
40 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| store_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| units_shipped |
int(11) |
|
|
4 |
4 |
4 |
| supply_time |
smallint(6) |
|
|
4 |
4 |
4 |
| store_invoice |
decimal(10,4) |
|
|
N/A |
N/A |
N/A |
| time_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| warehouse_cost |
decimal(10,4) |
|
|
N/A |
N/A |
N/A |
| warehouse_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| units_ordered |
int(11) |
|
|
4 |
4 |
4 |
| product_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| warehouse_sales |
decimal(10,4) |
|
|
N/A |
N/A |
N/A |
| Fixed Size Columns DM/Row
|
|
|
|
36
|
36
|
36
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_inv_1997_warehouse_id |
BTREE |
16 |
16 |
16 |
| i_inv_1997_store_id |
BTREE |
16 |
16 |
16 |
| i_inv_1997_product_id |
BTREE |
16 |
16 |
16 |
| i_inv_1997_time_id |
BTREE |
16 |
16 |
16 |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
80
|
80
|
80
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_inv_1997_warehouse_id |
N/A |
N/A |
N/A |
| i_inv_1997_store_id |
N/A |
N/A |
N/A |
| i_inv_1997_product_id |
N/A |
N/A |
N/A |
| i_inv_1997_time_id |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
132 |
132 |
136 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
11352 |
11352 |
11352 |
| Rows/32kb DM Page |
247 |
247 |
240 |
| Fixedsize DataMemory (KB) |
1472 |
1472 |
1536 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
368 |
184 |
184 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| position_title |
varchar(30) |
Y |
|
32 |
32 |
24* |
| max_scale |
decimal(10,2) |
|
|
N/A |
N/A |
N/A |
| pay_type |
varchar(30) |
Y |
|
32 |
32 |
8* |
| min_scale |
decimal(10,2) |
|
|
N/A |
N/A |
N/A |
| position_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| management_role |
varchar(30) |
Y |
|
32 |
32 |
20* |
| Fixed Size Columns DM/Row
|
|
|
|
108
|
108
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
52
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_position_id |
BTREE |
N/A |
N/A |
N/A |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
16
|
16
|
16
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| position_position_id$unique |
24 |
24 |
32 |
| This DataMemory/Row
|
136
|
136
|
44
|
| Total DM/Row (inludes DM in other tables)
|
160
|
160
|
76
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| position_position_id$unique |
29 |
16 |
16 |
| Total Suppt IM/Row
|
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
136 |
136 |
44 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
60 |
Memory Calculations
| No. Rows |
18 |
18 |
18 |
| Rows/32kb DM Page |
240 |
240 |
741 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
544 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| position_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
12
|
12
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
29 |
16 |
16 |
| Indexes IM/Row |
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
24 |
24 |
32 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
18 |
18 |
18 |
| Rows/32kb DM Page |
1360 |
1360 |
1020 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
282 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| SRP |
decimal(10,2) |
|
|
N/A |
N/A |
N/A |
| product_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| low_fat |
char(1) |
|
|
4 |
4 |
4 |
| shelf_depth |
double |
|
|
8 |
8 |
8 |
| recyclable_package |
char(1) |
|
|
4 |
4 |
4 |
| cases_per_pallet |
smallint(6) |
|
|
4 |
4 |
4 |
| gross_weight |
double |
|
|
8 |
8 |
8 |
| product_class_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| brand_name |
varchar(60) |
|
MUL |
64 |
64 |
64 |
| shelf_width |
double |
|
|
8 |
8 |
8 |
| units_per_case |
smallint(6) |
|
|
4 |
4 |
4 |
| shelf_height |
double |
|
|
8 |
8 |
8 |
| net_weight |
double |
|
|
8 |
8 |
8 |
| product_name |
varchar(60) |
|
MUL |
64 |
64 |
64 |
| SKU |
bigint(20) |
|
MUL |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
208
|
208
|
208
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_inv_1998_brand_name |
BTREE |
16 |
16 |
16 |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| i_product_SKU |
BTREE |
16 |
16 |
16 |
| i_product_name |
BTREE |
16 |
16 |
16 |
| i_product_class_id |
BTREE |
16 |
16 |
16 |
| i_product_id |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
80
|
80
|
80
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| product_product_id$unique |
24 |
24 |
32 |
| This DataMemory/Row
|
304
|
304
|
308
|
| Total DM/Row (inludes DM in other tables)
|
328
|
328
|
340
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_inv_1998_brand_name |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| i_product_SKU |
N/A |
N/A |
N/A |
| i_product_name |
N/A |
N/A |
N/A |
| i_product_class_id |
N/A |
N/A |
N/A |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| product_product_id$unique |
29 |
16 |
16 |
| Total Suppt IM/Row
|
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
304 |
304 |
308 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
1560 |
1560 |
1560 |
| Rows/32kb DM Page |
107 |
107 |
105 |
| Fixedsize DataMemory (KB) |
480 |
480 |
480 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
56 |
32 |
32 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| product_class_id |
int(11) |
|
|
4 |
4 |
4 |
| product_department |
varchar(30) |
Y |
|
32 |
32 |
12* |
| product_family |
varchar(30) |
Y |
|
32 |
32 |
12* |
| product_category |
varchar(30) |
Y |
|
32 |
32 |
16* |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| product_subcategory |
varchar(30) |
Y |
|
32 |
32 |
12* |
| Fixed Size Columns DM/Row
|
|
|
|
140
|
140
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
52
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
16
|
16
|
16
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
172 |
172 |
44 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
64 |
Memory Calculations
| No. Rows |
110 |
110 |
110 |
| Rows/32kb DM Page |
189 |
189 |
741 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
510 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| product_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
12
|
12
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
29 |
16 |
16 |
| Indexes IM/Row |
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
24 |
24 |
32 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
1560 |
1560 |
1560 |
| Rows/32kb DM Page |
1360 |
1360 |
1020 |
| Fixedsize DataMemory (KB) |
64 |
64 |
64 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
282 |
512 |
512 |
| IndexMemory (KB) |
48 |
32 |
32 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| cost |
double |
|
|
8 |
8 |
8 |
| promotion_district_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| end_date |
date |
|
|
4 |
4 |
4 |
| promotion_name |
varchar(30) |
Y |
|
32 |
32 |
16* |
| media_type |
varchar(30) |
Y |
|
32 |
32 |
16* |
| start_date |
date |
|
|
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| promotion_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| Fixed Size Columns DM/Row
|
|
|
|
96
|
96
|
32
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
32
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_promotion_id |
BTREE |
N/A |
N/A |
N/A |
| i_promotion_district_id |
BTREE |
16 |
16 |
16 |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
32
|
32
|
32
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| promotion_promotion_id$unique |
24 |
24 |
32 |
| This DataMemory/Row
|
144
|
144
|
84
|
| Total DM/Row (inludes DM in other tables)
|
168
|
168
|
116
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_promotion_district_id |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| promotion_promotion_id$unique |
29 |
16 |
16 |
| Total Suppt IM/Row
|
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
144 |
144 |
84 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
44 |
Memory Calculations
| No. Rows |
1864 |
1864 |
1864 |
| Rows/32kb DM Page |
226 |
226 |
388 |
| Fixedsize DataMemory (KB) |
288 |
288 |
160 |
| Rows/32kb Varsize DM Page |
0 |
0 |
741 |
| Varsize DataMemory (KB) |
0 |
0 |
96 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
64 |
32 |
32 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| promotion_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| Fixed Size Columns DM/Row
|
|
|
|
12
|
12
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
29 |
16 |
16 |
| Indexes IM/Row |
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
24 |
24 |
32 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
1864 |
1864 |
1864 |
| Rows/32kb DM Page |
1360 |
1360 |
1020 |
| Fixedsize DataMemory (KB) |
64 |
64 |
64 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
282 |
512 |
512 |
| IndexMemory (KB) |
56 |
32 |
32 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| sales_district_id |
int(11) |
|
|
4 |
4 |
4 |
| sales_state_province |
varchar(30) |
Y |
|
32 |
32 |
4* |
| sales_region |
varchar(30) |
Y |
|
32 |
32 |
12* |
| region_id |
int(11) |
|
|
4 |
4 |
4 |
| sales_country |
varchar(30) |
Y |
|
32 |
32 |
8* |
| sales_district |
varchar(30) |
Y |
|
32 |
32 |
12* |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| sales_city |
varchar(30) |
Y |
|
32 |
32 |
12* |
| Fixed Size Columns DM/Row
|
|
|
|
176
|
176
|
16
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
48
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
16
|
16
|
16
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
208 |
208 |
52 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
60 |
Memory Calculations
| No. Rows |
110 |
110 |
110 |
| Rows/32kb DM Page |
156 |
156 |
627 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
544 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| store_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| marital_status |
varchar(30) |
Y |
|
32 |
32 |
4* |
| position_id |
int(11) |
|
|
4 |
4 |
4 |
| last_name |
varchar(30) |
Y |
|
32 |
32 |
8* |
| education_level |
varchar(30) |
Y |
|
32 |
32 |
20* |
| supervisor_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| hire_date |
timestamp |
|
|
4 |
4 |
4 |
| employee_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| department_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| gender |
varchar(30) |
Y |
|
32 |
32 |
4* |
| full_name |
varchar(30) |
Y |
|
32 |
32 |
16* |
| birth_date |
date |
|
|
4 |
4 |
4 |
| salary |
decimal(10,2) |
|
|
N/A |
N/A |
N/A |
| position_title |
varchar(30) |
Y |
|
32 |
32 |
4* |
| end_date |
timestamp |
|
|
4 |
4 |
4 |
| first_name |
varchar(30) |
Y |
|
32 |
32 |
8* |
| Fixed Size Columns DM/Row
|
|
|
|
264
|
264
|
40
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
64
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_reserve_employee_id |
BTREE |
N/A |
N/A |
N/A |
| i_reserve_employee_super_id |
BTREE |
16 |
16 |
16 |
| i_reserve_employee_dept_id |
BTREE |
16 |
16 |
16 |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| i_reserve_employee_store_id |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
64
|
64
|
64
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| reserve_employee_employee_id$unique |
24 |
24 |
32 |
| This DataMemory/Row
|
344
|
344
|
124
|
| Total DM/Row (inludes DM in other tables)
|
368
|
368
|
156
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_reserve_employee_super_id |
N/A |
N/A |
N/A |
| i_reserve_employee_dept_id |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| i_reserve_employee_store_id |
N/A |
N/A |
N/A |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| reserve_employee_employee_id$unique |
29 |
16 |
16 |
| Total Suppt IM/Row
|
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
344 |
344 |
124 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
76 |
Memory Calculations
| No. Rows |
143 |
143 |
143 |
| Rows/32kb DM Page |
94 |
94 |
263 |
| Fixedsize DataMemory (KB) |
64 |
64 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
429 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| employee_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
12
|
12
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
29 |
16 |
16 |
| Indexes IM/Row |
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
24 |
24 |
32 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
143 |
143 |
143 |
| Rows/32kb DM Page |
1360 |
1360 |
1020 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
282 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| vacation_used |
int(11) |
|
|
4 |
4 |
4 |
| currency_id |
int(11) |
|
|
4 |
4 |
4 |
| employee_id |
int(11) |
|
|
4 |
4 |
4 |
| pay_date |
date |
|
|
4 |
4 |
4 |
| vacation_accrued |
int(11) |
|
|
4 |
4 |
4 |
| salary_paid |
decimal(10,4) |
|
|
N/A |
N/A |
N/A |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| overtime_paid |
decimal(10,4) |
|
|
N/A |
N/A |
N/A |
| department_id |
int(11) |
|
|
4 |
4 |
4 |
| Fixed Size Columns DM/Row
|
|
|
|
32
|
32
|
32
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
16
|
16
|
16
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
60 |
60 |
64 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
21252 |
21252 |
21252 |
| Rows/32kb DM Page |
544 |
544 |
510 |
| Fixedsize DataMemory (KB) |
1280 |
1280 |
1344 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
688 |
336 |
336 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| time_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| store_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| unit_sales |
int(11) |
|
|
4 |
4 |
4 |
| customer_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| product_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| store_cost |
decimal(10,4) |
|
|
N/A |
N/A |
N/A |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| store_sales |
decimal(10,2) |
|
|
N/A |
N/A |
N/A |
| promotion_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| Fixed Size Columns DM/Row
|
|
|
|
32
|
32
|
32
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_sales_1997_product_id |
BTREE |
16 |
16 |
16 |
| i_sales_1997_time_id |
BTREE |
16 |
16 |
16 |
| i_sales_1997_store_id |
BTREE |
16 |
16 |
16 |
| i_sales_1997_promotion_id |
BTREE |
16 |
16 |
16 |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| i_sales_1997_customer_id |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
96
|
96
|
96
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_sales_1997_product_id |
N/A |
N/A |
N/A |
| i_sales_1997_time_id |
N/A |
N/A |
N/A |
| i_sales_1997_store_id |
N/A |
N/A |
N/A |
| i_sales_1997_promotion_id |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| i_sales_1997_customer_id |
N/A |
N/A |
N/A |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
140 |
140 |
144 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
269720 |
269720 |
269720 |
| Rows/32kb DM Page |
233 |
233 |
226 |
| Fixedsize DataMemory (KB) |
37056 |
37056 |
38208 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8704 |
4216 |
4216 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| meat_sqft |
double |
|
|
8 |
8 |
8 |
| store_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| store_fax |
varchar(30) |
Y |
|
32 |
32 |
16* |
| last_remodel_date |
date |
|
|
4 |
4 |
4 |
| coffee_bar |
char(1) |
|
|
4 |
4 |
4 |
| store_type |
varchar(30) |
Y |
|
32 |
32 |
16* |
| florist |
char(1) |
|
|
4 |
4 |
4 |
| region_id |
int(11) |
|
MUL |
4 |
4 |
4 |
| store_name |
varchar(30) |
Y |
|
32 |
32 |
12* |
| store_phone |
varchar(30) |
Y |
|
32 |
32 |
16* |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| store_city |
varchar(30) |
Y |
|
32 |
32 |
12* |
| store_street_address |
varchar(30) |
Y |
|
32 |
32 |
20* |
| store_postal_code |
varchar(30) |
Y |
|
32 |
32 |
8* |
| store_sqft |
double |
|
|
8 |
8 |
8 |
| grocery_sqft |
double |
|
|
8 |
8 |
8 |
| store_manager |
varchar(30) |
Y |
|
32 |
32 |
8* |
| store_state |
varchar(30) |
Y |
|
32 |
32 |
8* |
| frozen_sqft |
double |
|
|
8 |
8 |
8 |
| store_number |
int(11) |
|
|
4 |
4 |
4 |
| video_store |
char(1) |
|
|
4 |
4 |
4 |
| salad_bar |
char(1) |
|
|
4 |
4 |
4 |
| first_opened_date |
date |
|
|
4 |
4 |
4 |
| prepared_food |
char(1) |
|
|
4 |
4 |
4 |
| store_country |
varchar(30) |
Y |
|
32 |
32 |
8* |
| Fixed Size Columns DM/Row
|
|
|
|
400
|
400
|
80
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
124
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| i_store_region_id |
BTREE |
16 |
16 |
16 |
| i_store_id |
BTREE |
N/A |
N/A |
N/A |
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
32
|
32
|
32
|
Supporting Tables DataMemory/Row
| Table |
4.1 |
5.0 |
5.1 |
|---|
| store_store_id$unique |
24 |
24 |
32 |
| This DataMemory/Row
|
448
|
448
|
132
|
| Total DM/Row (inludes DM in other tables)
|
472
|
472
|
164
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| i_store_region_id |
N/A |
N/A |
N/A |
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Supporting Tables IndexMemory/Row
| store_store_id$unique |
29 |
16 |
16 |
| Total Suppt IM/Row
|
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
448 |
448 |
132 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
136 |
Memory Calculations
| No. Rows |
25 |
25 |
25 |
| Rows/32kb DM Page |
72 |
72 |
247 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
240 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| store_id |
int(11) |
|
PRI |
4 |
4 |
4 |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| Fixed Size Columns DM/Row
|
|
|
|
12
|
12
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
0
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
N/A |
N/A |
N/A |
| Total Index DM/Row
|
|
0
|
0
|
0
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
29 |
16 |
16 |
| Indexes IM/Row |
29
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
20 |
| NULL Bytes/Row |
0 |
0 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
24 |
24 |
32 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
0 |
| Avg Varside DM/Row |
0 |
0 |
0 |
Memory Calculations
| No. Rows |
25 |
25 |
25 |
| Rows/32kb DM Page |
1360 |
1360 |
1020 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
0 |
| Varsize DataMemory (KB) |
0 |
0 |
0 |
| Rows/8kb IM Page |
282 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| the_day |
varchar(30) |
Y |
|
32 |
32 |
12* |
| month_of_year |
smallint(6) |
|
|
4 |
4 |
4 |
| the_month |
varchar(30) |
Y |
|
32 |
32 |
8* |
| the_date |
date |
|
|
4 |
4 |
4 |
| week_of_year |
int(11) |
|
|
4 |
4 |
4 |
| quarter |
varchar(30) |
Y |
|
32 |
32 |
4* |
| the_year |
smallint(6) |
|
|
4 |
4 |
4 |
| time_id |
int(11) |
|
|
4 |
4 |
4 |
| fiscal_period |
varchar(30) |
Y |
|
32 |
32 |
4* |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| day_of_month |
smallint(6) |
|
|
4 |
4 |
4 |
| Fixed Size Columns DM/Row
|
|
|
|
160
|
160
|
32
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
28
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
16
|
16
|
16
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
192 |
192 |
68 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
40 |
Memory Calculations
| No. Rows |
730 |
730 |
730 |
| Rows/32kb DM Page |
170 |
170 |
480 |
| Fixedsize DataMemory (KB) |
160 |
160 |
64 |
| Rows/32kb Varsize DM Page |
0 |
0 |
816 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
24 |
16 |
16 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| wa_address3 |
varchar(30) |
Y |
|
32 |
32 |
4* |
| warehouse_phone |
varchar(30) |
Y |
|
32 |
32 |
16* |
| warehouse_id |
int(11) |
|
|
4 |
4 |
4 |
| warehouse_postal_code |
varchar(30) |
Y |
|
32 |
32 |
8* |
| warehouse_owner_name |
varchar(30) |
Y |
|
32 |
32 |
4* |
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| warehouse_city |
varchar(30) |
Y |
|
32 |
32 |
12* |
| wa_address4 |
varchar(30) |
Y |
|
32 |
32 |
4* |
| wa_address1 |
varchar(30) |
Y |
|
32 |
32 |
20* |
| warehouse_name |
varchar(60) |
Y |
|
64 |
64 |
24* |
| warehouse_state_province |
varchar(30) |
Y |
|
32 |
32 |
8* |
| warehouse_class_id |
int(11) |
|
|
4 |
4 |
4 |
| stores_id |
int(11) |
|
|
4 |
4 |
4 |
| warehouse_fax |
varchar(30) |
Y |
|
32 |
32 |
16* |
| warehouse_country |
varchar(30) |
Y |
|
32 |
32 |
8* |
| wa_address2 |
varchar(30) |
Y |
|
32 |
32 |
4* |
| Fixed Size Columns DM/Row
|
|
|
|
436
|
436
|
20
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
128
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
16
|
16
|
16
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
4 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
468 |
468 |
56 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
140 |
Memory Calculations
| No. Rows |
24 |
24 |
24 |
| Rows/32kb DM Page |
69 |
69 |
582 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
233 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
DataMemory for Columns
* means varsized DataMemory
| Column Name |
Type |
Varsized |
Key |
4.1 |
5.0 |
5.1 |
|---|
| HIDDEN_NDB_PKEY |
bigint |
|
PRI |
8 |
8 |
8 |
| description |
varchar(30) |
Y |
|
32 |
32 |
16* |
| warehouse_class_id |
int(11) |
|
|
4 |
4 |
4 |
| Fixed Size Columns DM/Row
|
|
|
|
44
|
44
|
12
|
| Varsize Columns DM/Row
|
|
|
|
0
|
0
|
16
|
DataMemory for Indexes
| Index Name |
Type |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
BTREE |
16 |
16 |
16 |
| Total Index DM/Row
|
|
16
|
16
|
16
|
IndexMemory for Indexes
| Index Name |
4.1 |
5.0 |
5.1 |
|---|
| PRIMARY |
33 |
16 |
16 |
| Indexes IM/Row |
33
|
16
|
16
|
Summary (for THIS table)
Fixed Sized Part
|
4.1 |
5.0 |
5.1 |
| Fixed Overhead DM/Row |
12 |
12 |
16 |
| NULL Bytes/Row |
4 |
4 |
0 |
| DataMemory/Row (incl overhead, bitmap, indexes) |
76 |
76 |
44 |
Variable Sized Part
| Varsize Overhead DM/Row |
0 |
0 |
8 |
| Varsize NULL Bytes/Row |
0 |
0 |
4 |
| Avg Varside DM/Row |
0 |
0 |
28 |
Memory Calculations
| No. Rows |
6 |
6 |
6 |
| Rows/32kb DM Page |
429 |
429 |
741 |
| Fixedsize DataMemory (KB) |
32 |
32 |
32 |
| Rows/32kb Varsize DM Page |
0 |
0 |
1165 |
| Varsize DataMemory (KB) |
0 |
0 |
32 |
| Rows/8kb IM Page |
248 |
512 |
512 |
| IndexMemory (KB) |
8 |
8 |
8 |
Parameter Minimum Requirements
* indicates greater than default
| Parameter |
Default |
4.1 |
5.0 |
5.1 |
|---|
| DataMemory (KB) |
81920 |
51072 |
51072 |
48704 |
| NoOfOrderedIndexes |
128 |
64 |
64 |
64 |
| NoOfTables |
128 |
32 |
32 |
32 |
| IndexMemory (KB) |
18432 |
10952 |
5456 |
5456 |
| NoOfUniqueHashIndexes |
64 |
11 |
11 |
11 |
| NoOfAttributes |
1000 |
248 |
248 |
248 |
| NoOfTriggers |
768 |
225 |
225 |
225 |
