Navigation: iVend Database Database > Tables > InvBatch Table > Indexes >
iVend 6.6 Database Help
IX_InvBatch Index
Collapse All Expand All
iVend Database Database > InvBatch Table : IX_InvBatch Index |
Properties
File Group |
PRIMARY |
Space Used |
48.00 KB |
Fill Factor |
0 |
Do not Recompute Statistics |
|
Full Text Key |
|
Clustered Index |
|
Primary Key Index |
|
Unique Index |
|
Pad Index |
|
Columns
|
Column |
Description |
Sort Order |
|
BatchNumber |
Value is the unique batch number of product. |
Ascending |
|
WarehouseKey |
Value is the reference key of warehouse where the batch exist. See also Warehouse. |
Ascending |
|
ProductKey |
Value is the reference key of product to which this batch belongs. See also Product. |
Ascending |
Index Statistics
Average key length |
102.00 |
Density |
1.00 |
Rows in the Table |
256 |
Rows Sampled |
256 |
Distribution Steps |
132 |
Updated |
Oct 8 2018 5:57PM |
See Also
Related Objects
© 2019 All Rights Reserved.
Send comments on this topic.