ndb_size.pl report for database foodmart (21 tables)
Mon, 2010-03-15 20:08 —
oli
Connected to: DBI:mysql:database=foodmart;host=localhost
Including information for versions: 4.1, 5.0, 5.1
Table List
- account
- account_account_id$unique
- category
- category_category_id$unique
- currency
- currency_currency_id_date$unique
- customer
- customer_customer_id$unique
- days
- department
- department_department_id$unique
- employee
- employee_employee_id$unique
- expense_fact
- inventory_fact
- position
- position_position_id$unique
- product
- product_class
- product_product_id$unique
- promotion
- promotion_promotion_id$unique
- region
- reserve_employee
- reserve_employee_employee_id$unique
- salary
- sales_fact
- store
- store_store_id$unique
- time_by_day
- warehouse
- warehouse_class
account
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 |
account_account_id$unique
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 |
category
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 |
category_category_id$unique
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 |
currency
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 |
currency_currency_id_date$unique
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 |
customer
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 |
customer_customer_id$unique
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 |
days
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 |
department
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 |
department_department_id$unique
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 |
employee
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 |
employee_employee_id$unique
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 |
expense_fact
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 |
inventory_fact
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 |
position
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 |
position_position_id$unique
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 |
product
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 |
product_class
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 |
product_product_id$unique
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 |
promotion
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 |
promotion_promotion_id$unique
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 |
region
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 |
reserve_employee
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 |
reserve_employee_employee_id$unique
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 |
salary
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 |
sales_fact
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 |
store
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 |
store_store_id$unique
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 |
time_by_day
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 |
warehouse
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 |
warehouse_class
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 |
tags:
