Table: SalesOrderHeader Table: SalesOrderHeader| Property | Value |
|---|---|
| Name | SalesOrderHeader |
| ID | 1010102639 |
| Owner | dbo |
| Schema | Sales |
| Filegroup | PRIMARY |
| Data Size (KB) | 5456 KB |
| Index Size (KB) | 2384 KB |
| Rows | 31465 |
| Unused (KB) | 456 KB |
| ANSI Null On |
|
| Quoted Identifier |
|
| Lock Escalation | TABLE |
| Lock On Bulk Load |
|
| Lob Data Space | |
| Filestream Data Space ID | |
| Has Unchecked Assembly Data |
|
| Text In Row Limit (bytes) | Option not set |
| Large Value Types Out Of Row |
|
| FullText Change Tracking On |
|
| Tracked By Cdc |
|
| Published |
|
| Schema Published |
|
| Replicated |
|
| Replication Filter |
|
| Merge Published |
|
| Sync Tran Subscribed |
|
| MS Shipped |
|
| Modify Date | 8/8/2010 5:23:44 PM |
| Create Date | 8/8/2010 5:21:52 PM |
| Name | Value |
|---|---|
| MS_Description | General sales order information. |
| Column ID | Column Name | Datatype | Nullable | Is Sparse | Is Column Set |
|---|---|---|---|---|---|
| 1 | SalesOrderID | int |
|
|
|
| 2 | RevisionNumber | tinyint |
|
|
|
| 3 | OrderDate | datetime |
|
|
|
| 4 | DueDate | datetime |
|
|
|
| 5 | ShipDate | datetime |
|
|
|
| 6 | Status | tinyint |
|
|
|
| 7 | OnlineOrderFlag | Flag |
|
|
|
| 8 | SalesOrderNumber | nvarchar(25) |
|
|
|
| 9 | PurchaseOrderNumber | OrderNumber |
|
|
|
| 10 | AccountNumber | AccountNumber |
|
|
|
| 11 | CustomerID | int |
|
|
|
| 12 | SalesPersonID | int |
|
|
|
| 13 | TerritoryID | int |
|
|
|
| 14 | BillToAddressID | int |
|
|
|
| 15 | ShipToAddressID | int |
|
|
|
| 16 | ShipMethodID | int |
|
|
|
| 17 | CreditCardID | int |
|
|
|
| 18 | CreditCardApprovalCode | varchar(15) |
|
|
|
| 19 | CurrencyRateID | int |
|
|
|
| 20 | SubTotal | money |
|
|
|
| 21 | TaxAmt | money |
|
|
|
| 22 | Freight | money |
|
|
|
| 23 | TotalDue | money |
|
|
|
| 24 | Comment | nvarchar(128) |
|
|
|
| 25 | rowguid | uniqueidentifier |
|
|
|
| 26 | ModifiedDate | datetime |
|
|
|
| Column | Seed Value | Increment Value | Last Value | Is Not For Replication | Is Computed | Is Sparse | Is Column Set |
|---|---|---|---|---|---|---|---|
| SalesOrderID | 1 | 1 | 75123 |
|
|
|
|
| Name | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|
| PK_SalesOrderHeader_SalesOrderID |
|
MS_Description | Primary key (clustered) constraint |
| Name |
|---|
| SalesOrderID |
| Name | Referenced Object | Update Action | Delete Action |
|---|---|---|---|
| FK_SalesOrderHeader_Address_BillToAddressID | Person.Address | No action | No action |
| FK_SalesOrderHeader_Address_ShipToAddressID | Person.Address | No action | No action |
| FK_SalesOrderHeader_CreditCard_CreditCardID | Sales.CreditCard | No action | No action |
| FK_SalesOrderHeader_CurrencyRate_CurrencyRateID | Sales.CurrencyRate | No action | No action |
| FK_SalesOrderHeader_Customer_CustomerID | Sales.Customer | No action | No action |
| FK_SalesOrderHeader_SalesPerson_SalesPersonID | Sales.SalesPerson | No action | No action |
| FK_SalesOrderHeader_ShipMethod_ShipMethodID | Purchasing.ShipMethod | No action | No action |
| FK_SalesOrderHeader_SalesTerritory_TerritoryID | Sales.SalesTerritory | No action | No action |
| Name | Column ID | Column | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named |
|---|---|---|---|---|---|---|---|---|
| CK_SalesOrderHeader_Status | 6 | Status | ([Status]>=(0) AND [Status]<=(8)) |
|
|
|
|
|
| CK_SalesOrderHeader_SubTotal | 20 | SubTotal | ([SubTotal]>=(0.00)) |
|
|
|
|
|
| CK_SalesOrderHeader_TaxAmt | 21 | TaxAmt | ([TaxAmt]>=(0.00)) |
|
|
|
|
|
| CK_SalesOrderHeader_Freight | 22 | Freight | ([Freight]>=(0.00)) |
|
|
|
|
|
| Name | Definition | Is Disabled | Is Not For Replication | Is Not Trusted | Uses Database Collation | Is System Named |
|---|---|---|---|---|---|---|
| CK_SalesOrderHeader_DueDate | ([DueDate]>=[OrderDate]) |
|
|
|
|
|
| CK_SalesOrderHeader_ShipDate | ([ShipDate]>=[OrderDate] OR [ShipDate] IS NULL) |
|
|
|
|
|
| Name | Column | Definition | Is System Named | Extended Property Name | Extended Property Value |
|---|---|---|---|---|---|
| DF_SalesOrderHeader_RevisionNumber | RevisionNumber | ((0)) |
|
MS_Description | Default constraint value of 0 |
| DF_SalesOrderHeader_OrderDate | OrderDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| DF_SalesOrderHeader_Status | Status | ((1)) |
|
MS_Description | Default constraint value of 1 |
| DF_SalesOrderHeader_OnlineOrderFlag | OnlineOrderFlag | ((1)) |
|
MS_Description | Default constraint value of 1 (TRUE) |
| DF_SalesOrderHeader_SubTotal | SubTotal | ((0.00)) |
|
MS_Description | Default constraint value of 0.0 |
| DF_SalesOrderHeader_TaxAmt | TaxAmt | ((0.00)) |
|
MS_Description | Default constraint value of 0.0 |
| DF_SalesOrderHeader_Freight | Freight | ((0.00)) |
|
MS_Description | Default constraint value of 0.0 |
| DF_SalesOrderHeader_rowguid | rowguid | (newid()) |
|
MS_Description | Default constraint value of NEWID() |
| DF_SalesOrderHeader_ModifiedDate | ModifiedDate | (getdate()) |
|
MS_Description | Default constraint value of GETDATE() |
| Name | Index Type | Primary Key | Unique | Unique Constraint | Ignore Duplicate Key | Disabled |
|---|---|---|---|---|---|---|
| PK_SalesOrderHeader_SalesOrderID | CLUSTERED |
|
|
|
|
|
| AK_SalesOrderHeader_rowguid | NONCLUSTERED |
|
|
|
|
|
| AK_SalesOrderHeader_SalesOrderNumber | NONCLUSTERED |
|
|
|
|
|
| IX_SalesOrderHeader_CustomerID | NONCLUSTERED |
|
|
|
|
|
| IX_SalesOrderHeader_SalesPersonID | NONCLUSTERED |
|
|
|
|
|
| Name | Key Index ID | Is Disabled | Is Not For Replication | Is Not Trusted | Delete Action | Update Action | Is System Named | Referencing Object |
|---|---|---|---|---|---|---|---|---|
| FK_SalesOrderDetail_SalesOrderHeader_SalesOrderID | 1 |
|
|
|
Cascade | No action |
|
Sales.SalesOrderDetail |
| FK_SalesOrderHeaderSalesReason_SalesOrderHeader_SalesOrderID | 1 |
|
|
|
Cascade | No action |
|
Sales.SalesOrderHeaderSalesReason |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| PK_SalesOrderHeader_SalesOrderID | Aug 8 2010 5:23PM | 31465 | 31465 | 3 | 1 | 4 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 3.178134E-05 | 4 | SalesOrderID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 43659 | 0 | 1 | 0 | 1 |
| 75122 | 31462 | 1 | 31462 | 1 |
| 75123 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_SalesOrderHeader_rowguid | Aug 8 2010 5:23PM | 31465 | 31465 | 99 | 1 | 20 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 3.178134E-05 | 16 | rowguid |
| 3.178134E-05 | 20 | rowguid, SalesOrderID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 6a830488-fa82-4d37-9754-000037c51328 | 0 | 1 | 0 | 1 |
| 261d771e-cc53-448d-a962-017f3a5b4beb | 189 | 1 | 189 | 1 |
| 8af2bc25-fe03-41ca-a73b-04d2ecfc9290 | 392 | 1 | 392 | 1 |
| 14d5c405-e0ea-49b8-95d2-05c52003abf3 | 127 | 1 | 127 | 1 |
| a055e9a0-1c67-495d-8091-07e2e3c266fb | 255 | 1 | 255 | 1 |
| ffeeb263-bd89-43fc-b4de-0a450c210f69 | 319 | 1 | 319 | 1 |
| 70b4e328-2452-4551-8a93-0d3910359d4e | 383 | 1 | 383 | 1 |
| 4a1ddcd2-1941-4364-8c17-0e16d6d23933 | 127 | 1 | 127 | 1 |
| 4548b2eb-f198-4fed-a7d1-10cd3f2ed8b1 | 319 | 1 | 319 | 1 |
| e4ce6804-a7f3-4b70-9f8a-11c02fb682b8 | 127 | 1 | 127 | 1 |
| b9dbf028-32ad-45ad-b552-1914f956bf17 | 895 | 1 | 895 | 1 |
| 4bf0100b-0cc1-4faf-ace2-1a0a6748aad6 | 127 | 1 | 127 | 1 |
| 6b1ccc6a-70e5-45f2-9de8-1cc57c34d36b | 319 | 1 | 319 | 1 |
| 54d85045-8ac8-407f-aee0-1eb764c6579d | 255 | 1 | 255 | 1 |
| 74b2f8f1-efa5-4dc2-858e-20c3a956c1b0 | 255 | 1 | 255 | 1 |
| 38d9b541-5ed3-4c37-8356-28466a79b54a | 895 | 1 | 895 | 1 |
| 35b7b1c2-4b65-4813-9ab8-29272dfb0536 | 127 | 1 | 127 | 1 |
| 6a10b133-4b0f-4888-816d-2e99dcbfb742 | 639 | 1 | 639 | 1 |
| 394349fa-9b96-438a-95b5-2ef1afaa2c8d | 63 | 1 | 63 | 1 |
| 6056459a-2c20-4924-914d-3085728ffebe | 191 | 1 | 191 | 1 |
| 1f955a8f-3378-425d-b0a2-34e685715caf | 575 | 1 | 575 | 1 |
| 1d9d0445-1fee-4ce7-96c6-36c75a510a5a | 191 | 1 | 191 | 1 |
| 0c60dcf2-1e77-4069-a196-3cdca9068797 | 767 | 1 | 767 | 1 |
| 1493f509-7582-4982-b543-3e9c3bbe1a56 | 191 | 1 | 191 | 1 |
| 5bde3e51-e4b1-4e76-92b9-43f7adff7bf4 | 703 | 1 | 703 | 1 |
| c373d583-7382-42de-a880-453b538e6423 | 127 | 1 | 127 | 1 |
| 4b926dd2-f908-4c57-a0be-46482fc6063f | 127 | 1 | 127 | 1 |
| dae497d1-36e1-46a3-8e97-481420542b5a | 191 | 1 | 191 | 1 |
| f0f6221d-a0d5-45ea-b8ef-4923ed85e491 | 127 | 1 | 127 | 1 |
| 612ae542-a100-4711-864f-4f3b3e02f5a1 | 703 | 1 | 703 | 1 |
| ca8cdddc-3869-4b6c-b96b-574ff7ab129f | 959 | 1 | 959 | 1 |
| dbb02716-af8d-4983-9e4f-5b818c2c695d | 511 | 1 | 511 | 1 |
| bae05b38-ef83-4e3f-b27a-5c9fc7f17ad7 | 127 | 1 | 127 | 1 |
| e90aecbb-99d9-4325-b804-5ea1e44b63ed | 255 | 1 | 255 | 1 |
| 5e6f6349-fa6e-47b6-8a92-61e9c69717c7 | 383 | 1 | 383 | 1 |
| 17904fb8-8282-48aa-bfbf-66cde548b3d9 | 639 | 1 | 639 | 1 |
| 0fbfa60c-9d93-4b2f-a964-68047803c61d | 127 | 1 | 127 | 1 |
| dd48308e-076f-429c-ae54-6bcf4fecf710 | 511 | 1 | 511 | 1 |
| d1f6404f-dc1d-471b-9f64-6df8ae975ae0 | 255 | 1 | 255 | 1 |
| 50d46196-a648-45d5-8453-6fe2657f7427 | 255 | 1 | 255 | 1 |
| 45ba6848-d68a-48fe-ab14-722c48f80a49 | 255 | 1 | 255 | 1 |
| 011fac11-952d-4504-a089-732234a843f0 | 127 | 1 | 127 | 1 |
| d2025606-e25a-4631-ba1b-744d35fb99ef | 127 | 1 | 127 | 1 |
| 8fad6d64-a927-42a3-b441-754fc1a61078 | 127 | 1 | 127 | 1 |
| 289e2cd8-a0f6-4c43-b217-77a2c29faefd | 255 | 1 | 255 | 1 |
| ad9814c2-2378-46e6-876c-788d56eae8ec | 127 | 1 | 127 | 1 |
| 2026b8d5-8746-4cca-b681-7ba9f3e3173c | 383 | 1 | 383 | 1 |
| 9241d917-043b-4742-a6b2-7dee084af068 | 255 | 1 | 255 | 1 |
| 09621542-8ef7-4a3b-b097-7fd9eb444507 | 255 | 1 | 255 | 1 |
| f7409777-5110-4651-9e01-80ee006506dd | 127 | 1 | 127 | 1 |
| 4f2587d4-ec15-4b7b-a550-822f52600fbd | 127 | 1 | 127 | 1 |
| 3eead0a8-a175-4f3a-a38e-830a0ac25af6 | 127 | 1 | 127 | 1 |
| d8e11bca-905d-4185-a4de-842c4be9616c | 127 | 1 | 127 | 1 |
| c91f7c56-635f-4f63-ae69-861751332659 | 255 | 1 | 255 | 1 |
| 3c18d5c0-b248-4f4f-9f78-8950c9cce6be | 383 | 1 | 383 | 1 |
| ee40d524-3fb7-42a0-87c4-8a33c998dd58 | 127 | 1 | 127 | 1 |
| 65f54c1f-3dcb-44da-b3c7-8b607d0447f3 | 127 | 1 | 127 | 1 |
| f8e712df-9737-40dc-92e0-8c4726e592d7 | 127 | 1 | 127 | 1 |
| 7807c88f-d2fb-4e5b-8c3f-8ea059522cef | 255 | 1 | 255 | 1 |
| cdbf18f3-5222-4cc5-b522-93d2acd63652 | 639 | 1 | 639 | 1 |
| 10a3dcec-bf2b-41aa-a036-94b6057caec7 | 127 | 1 | 127 | 1 |
| 49632c7b-90af-4c6e-bfd3-95d1038895d0 | 127 | 1 | 127 | 1 |
| f3268ac5-1876-4a9c-8198-96bee8cec2e4 | 127 | 1 | 127 | 1 |
| 6cbd5de5-b4f6-4eb2-8d9d-991162c9302e | 255 | 1 | 255 | 1 |
| 565abf6f-e281-4dbc-b93d-9a0820c3c360 | 127 | 1 | 127 | 1 |
| 4058e3a4-eecb-4e98-9bdb-9b608fc33876 | 127 | 1 | 127 | 1 |
| 243f71fc-3085-4815-89d3-9e943c81fac0 | 383 | 1 | 383 | 1 |
| 2650f1df-933d-4c09-b50d-a15708d94835 | 383 | 1 | 383 | 1 |
| 499d9ab4-afa9-447e-9ad8-a25a1d93173a | 127 | 1 | 127 | 1 |
| beea42cf-413c-4cae-a3b3-a5a4673e2968 | 383 | 1 | 383 | 1 |
| c551c3ea-31af-4202-bb1f-a7a905a6272d | 255 | 1 | 255 | 1 |
| 32531535-6a34-4a3d-8ecc-a8c08000c6a8 | 127 | 1 | 127 | 1 |
| c27454b8-6044-43df-967f-add7b20b6ed1 | 639 | 1 | 639 | 1 |
| 42fe21bc-79ac-44ce-aeb9-aec19309498c | 127 | 1 | 127 | 1 |
| 6b6dcb8a-487d-4ff5-a537-afce227f9085 | 127 | 1 | 127 | 1 |
| 4be1b771-cadc-4dd1-9e3a-b103e1b85ebd | 127 | 1 | 127 | 1 |
| e113e543-30b0-4e19-9112-b20f5a47c63d | 127 | 1 | 127 | 1 |
| 95bfeea3-eebe-4a6a-8611-b2fe087cafd4 | 127 | 1 | 127 | 1 |
| 64683869-7ea5-4786-8845-b67ddffa585e | 383 | 1 | 383 | 1 |
| 09521bf2-028a-4b15-b39d-b772078a4174 | 127 | 1 | 127 | 1 |
| 5bd9a2c7-4a7c-421f-8f32-be8ef596ad33 | 895 | 1 | 895 | 1 |
| 880d3a27-70f2-433a-b2bc-bf7a9640b620 | 127 | 1 | 127 | 1 |
| efc71e2d-b22e-4a1b-9255-c6b4f6c0688a | 895 | 1 | 895 | 1 |
| ffa7a4be-6cda-4865-bcc7-c865444604f1 | 191 | 1 | 191 | 1 |
| aee91419-ca68-41e6-a8de-ccd8d600ab77 | 575 | 1 | 575 | 1 |
| aa704095-d64d-494a-9a3f-ce7b1d0e8ea4 | 191 | 1 | 191 | 1 |
| f35c95f6-9277-4466-b0a0-d16090d9660d | 383 | 1 | 383 | 1 |
| f9993438-4814-47df-8ce0-d794b3dcc0b6 | 767 | 1 | 767 | 1 |
| ba88ba4b-4848-4b0a-8f91-dad9a3f4807c | 383 | 1 | 383 | 1 |
| a79a19c3-a11c-47bf-9dbe-ddb4e8e52540 | 383 | 1 | 383 | 1 |
| 79afe36d-5122-496a-8dca-e3dcd098151d | 767 | 1 | 767 | 1 |
| eb4b7732-aa99-49bd-b685-e58730cdd813 | 191 | 1 | 191 | 1 |
| 7425a0bd-4277-4fd6-99c3-ee34d678dc5c | 1087 | 1 | 1087 | 1 |
| 0867326e-e682-4c48-a3ef-f2d016f89b25 | 511 | 1 | 511 | 1 |
| 08552606-33e6-4472-91d0-f6dca2b07f04 | 511 | 1 | 511 | 1 |
| a051d0c7-644c-4983-9f2d-f92016835b3f | 255 | 1 | 255 | 1 |
| 1979ca51-897a-4a82-8dae-fd1259e51ea3 | 511 | 1 | 511 | 1 |
| 8d7aa419-62f6-4129-8104-fffc58687501 | 351 | 1 | 351 | 1 |
| df43118d-c53c-4775-ab74-fffeac56a815 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| AK_SalesOrderHeader_SalesOrderNumber | Aug 8 2010 5:23PM | 31465 | 31465 | 156 | 1 | 18 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 3.178134E-05 | 14 | SalesOrderNumber |
| 3.178134E-05 | 18 | SalesOrderNumber, SalesOrderID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| SO43659 | 0 | 1 | 0 | 1 |
| SO43849 | 189 | 1 | 189 | 1 |
| SO43986 | 136 | 1 | 136 | 1 |
| SO44242 | 255 | 1 | 255 | 1 |
| SO44498 | 255 | 1 | 255 | 1 |
| SO44626 | 127 | 1 | 127 | 1 |
| SO44754 | 127 | 1 | 127 | 1 |
| SO44946 | 191 | 1 | 191 | 1 |
| SO45074 | 127 | 1 | 127 | 1 |
| SO45330 | 255 | 1 | 255 | 1 |
| SO45586 | 255 | 1 | 255 | 1 |
| SO45778 | 191 | 1 | 191 | 1 |
| SO45906 | 127 | 1 | 127 | 1 |
| SO46034 | 127 | 1 | 127 | 1 |
| SO46162 | 127 | 1 | 127 | 1 |
| SO46354 | 191 | 1 | 191 | 1 |
| SO46482 | 127 | 1 | 127 | 1 |
| SO46610 | 127 | 1 | 127 | 1 |
| SO46802 | 191 | 1 | 191 | 1 |
| SO46930 | 127 | 1 | 127 | 1 |
| SO47058 | 127 | 1 | 127 | 1 |
| SO47250 | 191 | 1 | 191 | 1 |
| SO47378 | 127 | 1 | 127 | 1 |
| SO47506 | 127 | 1 | 127 | 1 |
| SO47890 | 383 | 1 | 383 | 1 |
| SO48018 | 127 | 1 | 127 | 1 |
| SO48146 | 127 | 1 | 127 | 1 |
| SO48338 | 191 | 1 | 191 | 1 |
| SO48466 | 127 | 1 | 127 | 1 |
| SO48658 | 191 | 1 | 191 | 1 |
| SO48786 | 127 | 1 | 127 | 1 |
| SO48978 | 191 | 1 | 191 | 1 |
| SO49106 | 127 | 1 | 127 | 1 |
| SO49234 | 127 | 1 | 127 | 1 |
| SO49426 | 191 | 1 | 191 | 1 |
| SO49490 | 63 | 1 | 63 | 1 |
| SO49874 | 383 | 1 | 383 | 1 |
| SO50066 | 191 | 1 | 191 | 1 |
| SO50258 | 191 | 1 | 191 | 1 |
| SO50834 | 575 | 1 | 575 | 1 |
| SO51026 | 191 | 1 | 191 | 1 |
| SO51218 | 191 | 1 | 191 | 1 |
| SO51410 | 191 | 1 | 191 | 1 |
| SO51794 | 383 | 1 | 383 | 1 |
| SO51922 | 127 | 1 | 127 | 1 |
| SO52114 | 191 | 1 | 191 | 1 |
| SO52370 | 255 | 1 | 255 | 1 |
| SO52562 | 191 | 1 | 191 | 1 |
| SO52690 | 127 | 1 | 127 | 1 |
| SO52818 | 127 | 1 | 127 | 1 |
| SO53010 | 191 | 1 | 191 | 1 |
| SO53138 | 127 | 1 | 127 | 1 |
| SO53394 | 255 | 1 | 255 | 1 |
| SO53586 | 191 | 1 | 191 | 1 |
| SO53714 | 127 | 1 | 127 | 1 |
| SO53970 | 255 | 1 | 255 | 1 |
| SO54162 | 191 | 1 | 191 | 1 |
| SO54354 | 191 | 1 | 191 | 1 |
| SO54482 | 127 | 1 | 127 | 1 |
| SO54610 | 127 | 1 | 127 | 1 |
| SO54994 | 383 | 1 | 383 | 1 |
| SO55122 | 127 | 1 | 127 | 1 |
| SO55378 | 255 | 1 | 255 | 1 |
| SO55506 | 127 | 1 | 127 | 1 |
| SO55762 | 255 | 1 | 255 | 1 |
| SO56018 | 255 | 1 | 255 | 1 |
| SO56274 | 255 | 1 | 255 | 1 |
| SO56402 | 127 | 1 | 127 | 1 |
| SO56786 | 383 | 1 | 383 | 1 |
| SO56914 | 127 | 1 | 127 | 1 |
| SO57042 | 127 | 1 | 127 | 1 |
| SO57170 | 127 | 1 | 127 | 1 |
| SO57298 | 127 | 1 | 127 | 1 |
| SO57426 | 127 | 1 | 127 | 1 |
| SO57682 | 255 | 1 | 255 | 1 |
| SO57810 | 127 | 1 | 127 | 1 |
| SO57938 | 127 | 1 | 127 | 1 |
| SO58066 | 127 | 1 | 127 | 1 |
| SO58194 | 127 | 1 | 127 | 1 |
| SO58322 | 127 | 1 | 127 | 1 |
| SO58450 | 127 | 1 | 127 | 1 |
| SO58706 | 255 | 1 | 255 | 1 |
| SO58834 | 127 | 1 | 127 | 1 |
| SO59090 | 255 | 1 | 255 | 1 |
| SO59218 | 127 | 1 | 127 | 1 |
| SO59474 | 255 | 1 | 255 | 1 |
| SO59602 | 127 | 1 | 127 | 1 |
| SO59986 | 383 | 1 | 383 | 1 |
| SO60114 | 127 | 1 | 127 | 1 |
| SO60498 | 383 | 1 | 383 | 1 |
| SO60626 | 127 | 1 | 127 | 1 |
| SO60882 | 255 | 1 | 255 | 1 |
| SO61010 | 127 | 1 | 127 | 1 |
| SO61138 | 127 | 1 | 127 | 1 |
| SO61394 | 255 | 1 | 255 | 1 |
| SO61522 | 127 | 1 | 127 | 1 |
| SO61778 | 255 | 1 | 255 | 1 |
| SO61906 | 127 | 1 | 127 | 1 |
| SO62034 | 127 | 1 | 127 | 1 |
| SO62162 | 127 | 1 | 127 | 1 |
| SO62290 | 127 | 1 | 127 | 1 |
| SO62418 | 127 | 1 | 127 | 1 |
| SO62674 | 255 | 1 | 255 | 1 |
| SO62802 | 127 | 1 | 127 | 1 |
| SO62930 | 127 | 1 | 127 | 1 |
| SO63058 | 127 | 1 | 127 | 1 |
| SO63186 | 127 | 1 | 127 | 1 |
| SO63314 | 127 | 1 | 127 | 1 |
| SO63698 | 383 | 1 | 383 | 1 |
| SO63826 | 127 | 1 | 127 | 1 |
| SO63954 | 127 | 1 | 127 | 1 |
| SO64082 | 127 | 1 | 127 | 1 |
| SO64210 | 127 | 1 | 127 | 1 |
| SO64594 | 383 | 1 | 383 | 1 |
| SO64722 | 127 | 1 | 127 | 1 |
| SO64978 | 255 | 1 | 255 | 1 |
| SO65106 | 127 | 1 | 127 | 1 |
| SO65490 | 383 | 1 | 383 | 1 |
| SO65618 | 127 | 1 | 127 | 1 |
| SO65874 | 255 | 1 | 255 | 1 |
| SO66002 | 127 | 1 | 127 | 1 |
| SO66130 | 127 | 1 | 127 | 1 |
| SO66258 | 127 | 1 | 127 | 1 |
| SO66514 | 255 | 1 | 255 | 1 |
| SO66770 | 255 | 1 | 255 | 1 |
| SO67026 | 255 | 1 | 255 | 1 |
| SO67154 | 127 | 1 | 127 | 1 |
| SO67282 | 127 | 1 | 127 | 1 |
| SO67858 | 575 | 1 | 575 | 1 |
| SO68050 | 191 | 1 | 191 | 1 |
| SO68242 | 191 | 1 | 191 | 1 |
| SO68818 | 575 | 1 | 575 | 1 |
| SO69010 | 191 | 1 | 191 | 1 |
| SO69202 | 191 | 1 | 191 | 1 |
| SO69394 | 191 | 1 | 191 | 1 |
| SO69970 | 575 | 1 | 575 | 1 |
| SO70162 | 191 | 1 | 191 | 1 |
| SO70930 | 767 | 1 | 767 | 1 |
| SO71122 | 191 | 1 | 191 | 1 |
| SO71506 | 383 | 1 | 383 | 1 |
| SO71698 | 191 | 1 | 191 | 1 |
| SO71890 | 191 | 1 | 191 | 1 |
| SO72082 | 191 | 1 | 191 | 1 |
| SO72274 | 191 | 1 | 191 | 1 |
| SO72466 | 191 | 1 | 191 | 1 |
| SO72722 | 255 | 1 | 255 | 1 |
| SO72978 | 255 | 1 | 255 | 1 |
| SO73234 | 255 | 1 | 255 | 1 |
| SO73490 | 255 | 1 | 255 | 1 |
| SO73746 | 255 | 1 | 255 | 1 |
| SO74002 | 255 | 1 | 255 | 1 |
| SO74258 | 255 | 1 | 255 | 1 |
| SO74514 | 255 | 1 | 255 | 1 |
| SO74770 | 255 | 1 | 255 | 1 |
| SO75026 | 255 | 1 | 255 | 1 |
| SO75123 | 96 | 1 | 96 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000008_3C34F16F | Aug 8 2010 5:23PM | 31465 | 31465 | 156 | 1 | 14 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 3.178134E-05 | 14 | SalesOrderNumber |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| SO43659 | 0 | 1 | 0 | 1 |
| SO43849 | 189 | 1 | 189 | 1 |
| SO43986 | 136 | 1 | 136 | 1 |
| SO44242 | 255 | 1 | 255 | 1 |
| SO44498 | 255 | 1 | 255 | 1 |
| SO44626 | 127 | 1 | 127 | 1 |
| SO44754 | 127 | 1 | 127 | 1 |
| SO44946 | 191 | 1 | 191 | 1 |
| SO45074 | 127 | 1 | 127 | 1 |
| SO45330 | 255 | 1 | 255 | 1 |
| SO45586 | 255 | 1 | 255 | 1 |
| SO45778 | 191 | 1 | 191 | 1 |
| SO45906 | 127 | 1 | 127 | 1 |
| SO46034 | 127 | 1 | 127 | 1 |
| SO46162 | 127 | 1 | 127 | 1 |
| SO46354 | 191 | 1 | 191 | 1 |
| SO46482 | 127 | 1 | 127 | 1 |
| SO46610 | 127 | 1 | 127 | 1 |
| SO46802 | 191 | 1 | 191 | 1 |
| SO46930 | 127 | 1 | 127 | 1 |
| SO47058 | 127 | 1 | 127 | 1 |
| SO47250 | 191 | 1 | 191 | 1 |
| SO47378 | 127 | 1 | 127 | 1 |
| SO47506 | 127 | 1 | 127 | 1 |
| SO47890 | 383 | 1 | 383 | 1 |
| SO48018 | 127 | 1 | 127 | 1 |
| SO48146 | 127 | 1 | 127 | 1 |
| SO48338 | 191 | 1 | 191 | 1 |
| SO48466 | 127 | 1 | 127 | 1 |
| SO48658 | 191 | 1 | 191 | 1 |
| SO48786 | 127 | 1 | 127 | 1 |
| SO48978 | 191 | 1 | 191 | 1 |
| SO49106 | 127 | 1 | 127 | 1 |
| SO49234 | 127 | 1 | 127 | 1 |
| SO49426 | 191 | 1 | 191 | 1 |
| SO49490 | 63 | 1 | 63 | 1 |
| SO49874 | 383 | 1 | 383 | 1 |
| SO50066 | 191 | 1 | 191 | 1 |
| SO50258 | 191 | 1 | 191 | 1 |
| SO50834 | 575 | 1 | 575 | 1 |
| SO51026 | 191 | 1 | 191 | 1 |
| SO51218 | 191 | 1 | 191 | 1 |
| SO51410 | 191 | 1 | 191 | 1 |
| SO51794 | 383 | 1 | 383 | 1 |
| SO51922 | 127 | 1 | 127 | 1 |
| SO52114 | 191 | 1 | 191 | 1 |
| SO52370 | 255 | 1 | 255 | 1 |
| SO52562 | 191 | 1 | 191 | 1 |
| SO52690 | 127 | 1 | 127 | 1 |
| SO52818 | 127 | 1 | 127 | 1 |
| SO53010 | 191 | 1 | 191 | 1 |
| SO53138 | 127 | 1 | 127 | 1 |
| SO53394 | 255 | 1 | 255 | 1 |
| SO53586 | 191 | 1 | 191 | 1 |
| SO53714 | 127 | 1 | 127 | 1 |
| SO53970 | 255 | 1 | 255 | 1 |
| SO54162 | 191 | 1 | 191 | 1 |
| SO54354 | 191 | 1 | 191 | 1 |
| SO54482 | 127 | 1 | 127 | 1 |
| SO54610 | 127 | 1 | 127 | 1 |
| SO54994 | 383 | 1 | 383 | 1 |
| SO55122 | 127 | 1 | 127 | 1 |
| SO55378 | 255 | 1 | 255 | 1 |
| SO55506 | 127 | 1 | 127 | 1 |
| SO55762 | 255 | 1 | 255 | 1 |
| SO56018 | 255 | 1 | 255 | 1 |
| SO56274 | 255 | 1 | 255 | 1 |
| SO56402 | 127 | 1 | 127 | 1 |
| SO56786 | 383 | 1 | 383 | 1 |
| SO56914 | 127 | 1 | 127 | 1 |
| SO57042 | 127 | 1 | 127 | 1 |
| SO57170 | 127 | 1 | 127 | 1 |
| SO57298 | 127 | 1 | 127 | 1 |
| SO57426 | 127 | 1 | 127 | 1 |
| SO57682 | 255 | 1 | 255 | 1 |
| SO57810 | 127 | 1 | 127 | 1 |
| SO57938 | 127 | 1 | 127 | 1 |
| SO58066 | 127 | 1 | 127 | 1 |
| SO58194 | 127 | 1 | 127 | 1 |
| SO58322 | 127 | 1 | 127 | 1 |
| SO58450 | 127 | 1 | 127 | 1 |
| SO58706 | 255 | 1 | 255 | 1 |
| SO58834 | 127 | 1 | 127 | 1 |
| SO59090 | 255 | 1 | 255 | 1 |
| SO59218 | 127 | 1 | 127 | 1 |
| SO59474 | 255 | 1 | 255 | 1 |
| SO59602 | 127 | 1 | 127 | 1 |
| SO59986 | 383 | 1 | 383 | 1 |
| SO60114 | 127 | 1 | 127 | 1 |
| SO60498 | 383 | 1 | 383 | 1 |
| SO60626 | 127 | 1 | 127 | 1 |
| SO60882 | 255 | 1 | 255 | 1 |
| SO61010 | 127 | 1 | 127 | 1 |
| SO61138 | 127 | 1 | 127 | 1 |
| SO61394 | 255 | 1 | 255 | 1 |
| SO61522 | 127 | 1 | 127 | 1 |
| SO61778 | 255 | 1 | 255 | 1 |
| SO61906 | 127 | 1 | 127 | 1 |
| SO62034 | 127 | 1 | 127 | 1 |
| SO62162 | 127 | 1 | 127 | 1 |
| SO62290 | 127 | 1 | 127 | 1 |
| SO62418 | 127 | 1 | 127 | 1 |
| SO62674 | 255 | 1 | 255 | 1 |
| SO62802 | 127 | 1 | 127 | 1 |
| SO62930 | 127 | 1 | 127 | 1 |
| SO63058 | 127 | 1 | 127 | 1 |
| SO63186 | 127 | 1 | 127 | 1 |
| SO63314 | 127 | 1 | 127 | 1 |
| SO63698 | 383 | 1 | 383 | 1 |
| SO63826 | 127 | 1 | 127 | 1 |
| SO63954 | 127 | 1 | 127 | 1 |
| SO64082 | 127 | 1 | 127 | 1 |
| SO64210 | 127 | 1 | 127 | 1 |
| SO64594 | 383 | 1 | 383 | 1 |
| SO64722 | 127 | 1 | 127 | 1 |
| SO64978 | 255 | 1 | 255 | 1 |
| SO65106 | 127 | 1 | 127 | 1 |
| SO65490 | 383 | 1 | 383 | 1 |
| SO65618 | 127 | 1 | 127 | 1 |
| SO65874 | 255 | 1 | 255 | 1 |
| SO66002 | 127 | 1 | 127 | 1 |
| SO66130 | 127 | 1 | 127 | 1 |
| SO66258 | 127 | 1 | 127 | 1 |
| SO66514 | 255 | 1 | 255 | 1 |
| SO66770 | 255 | 1 | 255 | 1 |
| SO67026 | 255 | 1 | 255 | 1 |
| SO67154 | 127 | 1 | 127 | 1 |
| SO67282 | 127 | 1 | 127 | 1 |
| SO67858 | 575 | 1 | 575 | 1 |
| SO68050 | 191 | 1 | 191 | 1 |
| SO68242 | 191 | 1 | 191 | 1 |
| SO68818 | 575 | 1 | 575 | 1 |
| SO69010 | 191 | 1 | 191 | 1 |
| SO69202 | 191 | 1 | 191 | 1 |
| SO69394 | 191 | 1 | 191 | 1 |
| SO69970 | 575 | 1 | 575 | 1 |
| SO70162 | 191 | 1 | 191 | 1 |
| SO70930 | 767 | 1 | 767 | 1 |
| SO71122 | 191 | 1 | 191 | 1 |
| SO71506 | 383 | 1 | 383 | 1 |
| SO71698 | 191 | 1 | 191 | 1 |
| SO71890 | 191 | 1 | 191 | 1 |
| SO72082 | 191 | 1 | 191 | 1 |
| SO72274 | 191 | 1 | 191 | 1 |
| SO72466 | 191 | 1 | 191 | 1 |
| SO72722 | 255 | 1 | 255 | 1 |
| SO72978 | 255 | 1 | 255 | 1 |
| SO73234 | 255 | 1 | 255 | 1 |
| SO73490 | 255 | 1 | 255 | 1 |
| SO73746 | 255 | 1 | 255 | 1 |
| SO74002 | 255 | 1 | 255 | 1 |
| SO74258 | 255 | 1 | 255 | 1 |
| SO74514 | 255 | 1 | 255 | 1 |
| SO74770 | 255 | 1 | 255 | 1 |
| SO75026 | 255 | 1 | 255 | 1 |
| SO75123 | 96 | 1 | 96 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| IX_SalesOrderHeader_CustomerID | Aug 8 2010 5:23PM | 31465 | 31465 | 153 | 0.6162394 | 8 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.230399E-05 | 4 | CustomerID |
| 3.178134E-05 | 8 | CustomerID, SalesOrderID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 11000 | 0 | 3 | 0 | 1 |
| 11019 | 47 | 17 | 18 | 2.611111 |
| 11091 | 186 | 28 | 71 | 2.619718 |
| 11142 | 132 | 17 | 50 | 2.64 |
| 11185 | 109 | 27 | 42 | 2.595238 |
| 11223 | 160 | 27 | 37 | 4.324324 |
| 11262 | 125 | 27 | 38 | 3.289474 |
| 11300 | 149 | 27 | 37 | 4.027027 |
| 11331 | 84 | 27 | 30 | 2.8 |
| 11417 | 173 | 7 | 85 | 2.035294 |
| 11439 | 68 | 6 | 21 | 3.238095 |
| 11498 | 140 | 16 | 58 | 2.413793 |
| 11519 | 122 | 16 | 20 | 6.1 |
| 11566 | 105 | 25 | 46 | 2.282609 |
| 11631 | 136 | 16 | 64 | 2.125 |
| 11677 | 127 | 5 | 45 | 2.822222 |
| 11711 | 71 | 27 | 33 | 2.151515 |
| 11769 | 155 | 5 | 57 | 2.719298 |
| 11892 | 284 | 3 | 122 | 2.327869 |
| 11935 | 118 | 1 | 42 | 2.809524 |
| 12008 | 181 | 3 | 72 | 2.513889 |
| 12054 | 92 | 5 | 45 | 2.044445 |
| 12127 | 163 | 1 | 72 | 2.263889 |
| 12196 | 168 | 4 | 68 | 2.470588 |
| 12291 | 196 | 4 | 94 | 2.085106 |
| 12321 | 88 | 5 | 29 | 3.034483 |
| 12363 | 115 | 4 | 41 | 2.804878 |
| 12489 | 222 | 4 | 125 | 1.776 |
| 12559 | 108 | 3 | 69 | 1.565217 |
| 12616 | 113 | 1 | 56 | 2.017857 |
| 12760 | 318 | 4 | 143 | 2.223776 |
| 12880 | 191 | 4 | 119 | 1.605042 |
| 12969 | 166 | 4 | 88 | 1.886364 |
| 13038 | 156 | 3 | 68 | 2.294118 |
| 13096 | 124 | 4 | 57 | 2.175439 |
| 13175 | 182 | 4 | 78 | 2.333333 |
| 13231 | 96 | 4 | 55 | 1.745455 |
| 13270 | 96 | 1 | 38 | 2.526316 |
| 13474 | 314 | 4 | 203 | 1.546798 |
| 13575 | 181 | 4 | 100 | 1.81 |
| 13608 | 78 | 1 | 32 | 2.4375 |
| 13652 | 120 | 1 | 43 | 2.790698 |
| 13756 | 179 | 4 | 103 | 1.737864 |
| 13823 | 127 | 3 | 66 | 1.924242 |
| 13944 | 185 | 4 | 120 | 1.541667 |
| 13988 | 96 | 4 | 43 | 2.232558 |
| 14096 | 227 | 5 | 107 | 2.121495 |
| 14162 | 125 | 3 | 65 | 1.923077 |
| 14265 | 214 | 5 | 102 | 2.098039 |
| 14341 | 168 | 4 | 75 | 2.24 |
| 14612 | 448 | 1 | 270 | 1.659259 |
| 14860 | 449 | 2 | 247 | 1.817814 |
| 14943 | 127 | 1 | 82 | 1.54878 |
| 15048 | 191 | 3 | 104 | 1.836538 |
| 15114 | 126 | 3 | 65 | 1.938462 |
| 15177 | 127 | 1 | 62 | 2.048387 |
| 15521 | 580 | 2 | 343 | 1.690962 |
| 15625 | 192 | 3 | 103 | 1.864078 |
| 15687 | 127 | 3 | 61 | 2.081967 |
| 15932 | 451 | 3 | 244 | 1.848361 |
| 15974 | 63 | 3 | 41 | 1.536585 |
| 16237 | 385 | 1 | 262 | 1.469466 |
| 16513 | 452 | 2 | 275 | 1.643636 |
| 16583 | 127 | 1 | 69 | 1.84058 |
| 16641 | 117 | 1 | 57 | 2.052632 |
| 16758 | 191 | 2 | 116 | 1.646552 |
| 16855 | 132 | 2 | 96 | 1.375 |
| 16959 | 133 | 3 | 103 | 1.291262 |
| 17026 | 68 | 3 | 66 | 1.030303 |
| 17103 | 128 | 3 | 76 | 1.684211 |
| 17181 | 87 | 3 | 77 | 1.12987 |
| 17260 | 157 | 1 | 78 | 2.01282 |
| 17335 | 132 | 1 | 74 | 1.783784 |
| 17551 | 276 | 2 | 215 | 1.283721 |
| 17619 | 70 | 2 | 67 | 1.044776 |
| 17715 | 127 | 2 | 95 | 1.336842 |
| 17788 | 130 | 1 | 72 | 1.805556 |
| 17832 | 70 | 1 | 43 | 1.627907 |
| 17930 | 150 | 1 | 97 | 1.546392 |
| 18047 | 191 | 2 | 116 | 1.646552 |
| 18125 | 84 | 3 | 77 | 1.090909 |
| 18223 | 188 | 1 | 97 | 1.938144 |
| 18294 | 126 | 2 | 70 | 1.8 |
| 18390 | 134 | 2 | 95 | 1.410526 |
| 18452 | 65 | 2 | 61 | 1.065574 |
| 18620 | 203 | 2 | 167 | 1.215569 |
| 18712 | 126 | 2 | 91 | 1.384615 |
| 18749 | 69 | 3 | 36 | 1.916667 |
| 19031 | 330 | 3 | 281 | 1.174377 |
| 19289 | 353 | 2 | 257 | 1.373541 |
| 19339 | 87 | 3 | 49 | 1.77551 |
| 19420 | 107 | 3 | 80 | 1.3375 |
| 19499 | 127 | 2 | 78 | 1.628205 |
| 19585 | 127 | 2 | 85 | 1.494118 |
| 20051 | 632 | 3 | 465 | 1.35914 |
| 20159 | 127 | 2 | 107 | 1.186916 |
| 20245 | 126 | 2 | 85 | 1.482353 |
| 20576 | 383 | 2 | 330 | 1.160606 |
| 20779 | 255 | 1 | 202 | 1.262376 |
| 20862 | 126 | 2 | 82 | 1.536585 |
| 20960 | 127 | 1 | 97 | 1.309278 |
| 21046 | 127 | 1 | 85 | 1.494118 |
| 21248 | 255 | 1 | 201 | 1.268657 |
| 21470 | 255 | 1 | 221 | 1.153846 |
| 21574 | 127 | 1 | 103 | 1.23301 |
| 21807 | 255 | 1 | 232 | 1.099138 |
| 21916 | 127 | 1 | 108 | 1.175926 |
| 22122 | 255 | 1 | 205 | 1.243902 |
| 22344 | 255 | 1 | 221 | 1.153846 |
| 22826 | 511 | 1 | 481 | 1.06237 |
| 23136 | 384 | 1 | 309 | 1.242718 |
| 23267 | 134 | 2 | 130 | 1.030769 |
| 23578 | 383 | 1 | 310 | 1.235484 |
| 23725 | 166 | 2 | 146 | 1.136986 |
| 24159 | 463 | 2 | 433 | 1.069284 |
| 24257 | 127 | 2 | 97 | 1.309278 |
| 24466 | 255 | 2 | 208 | 1.225962 |
| 24754 | 329 | 1 | 287 | 1.146341 |
| 24887 | 135 | 2 | 132 | 1.022727 |
| 25114 | 277 | 2 | 226 | 1.225664 |
| 25400 | 319 | 1 | 285 | 1.119298 |
| 25555 | 155 | 2 | 154 | 1.006493 |
| 25819 | 291 | 2 | 263 | 1.106464 |
| 25916 | 126 | 2 | 96 | 1.3125 |
| 25995 | 135 | 1 | 78 | 1.730769 |
| 26127 | 191 | 1 | 131 | 1.458015 |
| 26276 | 181 | 2 | 148 | 1.222973 |
| 26564 | 383 | 1 | 287 | 1.334495 |
| 26686 | 191 | 1 | 121 | 1.578512 |
| 26841 | 191 | 1 | 154 | 1.24026 |
| 27197 | 383 | 1 | 355 | 1.078873 |
| 27361 | 191 | 1 | 163 | 1.171779 |
| 27672 | 383 | 1 | 310 | 1.235484 |
| 28050 | 383 | 1 | 377 | 1.015915 |
| 28389 | 383 | 1 | 338 | 1.133136 |
| 28749 | 383 | 1 | 359 | 1.066852 |
| 28919 | 191 | 1 | 169 | 1.130177 |
| 29105 | 191 | 1 | 185 | 1.032432 |
| 29270 | 191 | 1 | 164 | 1.164634 |
| 29448 | 191 | 1 | 177 | 1.079096 |
| 29508 | 185 | 10 | 59 | 3.135593 |
| 29603 | 585 | 4 | 94 | 6.223404 |
| 29669 | 383 | 11 | 65 | 5.892308 |
| 29698 | 182 | 12 | 28 | 6.5 |
| 29723 | 188 | 4 | 24 | 7.833333 |
| 29795 | 379 | 8 | 71 | 5.338028 |
| 29857 | 386 | 5 | 61 | 6.327869 |
| 29927 | 382 | 7 | 69 | 5.536232 |
| 29990 | 383 | 6 | 62 | 6.177419 |
| 30023 | 188 | 7 | 32 | 5.875 |
| 30096 | 382 | 9 | 72 | 5.305555 |
| 30117 | 115 | 12 | 20 | 5.75 |
| 30118 | 0 | 8 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| IX_SalesOrderHeader_SalesPersonID | Aug 8 2010 5:23PM | 31465 | 31465 | 18 | 0 | 4.483839 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.05555556 | 0.4838392 | SalesPersonID |
| 3.178134E-05 | 4.483839 | SalesPersonID, SalesOrderID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 0 | 27659 | 0 | 1 | |
| 274 | 0 | 48 | 0 | 1 |
| 275 | 0 | 450 | 0 | 1 |
| 276 | 0 | 418 | 0 | 1 |
| 277 | 0 | 473 | 0 | 1 |
| 278 | 0 | 234 | 0 | 1 |
| 279 | 0 | 429 | 0 | 1 |
| 280 | 0 | 95 | 0 | 1 |
| 281 | 0 | 242 | 0 | 1 |
| 282 | 0 | 271 | 0 | 1 |
| 283 | 0 | 189 | 0 | 1 |
| 284 | 0 | 140 | 0 | 1 |
| 285 | 0 | 16 | 0 | 1 |
| 286 | 0 | 109 | 0 | 1 |
| 287 | 0 | 39 | 0 | 1 |
| 288 | 0 | 130 | 0 | 1 |
| 289 | 0 | 348 | 0 | 1 |
| 290 | 0 | 175 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_0000000D_3C34F16F | Aug 8 2010 5:23PM | 31465 | 31465 | 10 | 0 | 4 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.1 | 4 | TerritoryID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 1 | 0 | 4594 | 0 | 1 |
| 2 | 0 | 352 | 0 | 1 |
| 3 | 0 | 385 | 0 | 1 |
| 4 | 0 | 6224 | 0 | 1 |
| 5 | 0 | 486 | 0 | 1 |
| 6 | 0 | 4067 | 0 | 1 |
| 7 | 0 | 2672 | 0 | 1 |
| 8 | 0 | 2623 | 0 | 1 |
| 9 | 0 | 6843 | 0 | 1 |
| 10 | 0 | 3219 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000010_3C34F16F | Aug 8 2010 5:23PM | 31465 | 31465 | 2 | 0 | 4 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.5 | 4 | ShipMethodID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 1 | 0 | 27659 | 0 | 1 |
| 5 | 0 | 3806 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000013_3C34F16F | Aug 8 2010 5:23PM | 31465 | 31465 | 199 | 0.20521 | 1.776704 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.0003976143 | 1.776704 | CurrencyRateID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 0 | 17489 | 0 | 1 | |
| 2 | 0 | 1 | 0 | 1 |
| 407 | 112 | 22 | 67 | 1.671642 |
| 470 | 17 | 6 | 9 | 1.888889 |
| 821 | 103 | 4 | 54 | 1.907407 |
| 1200 | 90 | 7 | 58 | 1.551724 |
| 1341 | 39 | 6 | 21 | 1.857143 |
| 1603 | 61 | 23 | 37 | 1.648649 |
| 1993 | 109 | 10 | 63 | 1.730159 |
| 2082 | 24 | 10 | 16 | 1.5 |
| 2225 | 47 | 8 | 24 | 1.958333 |
| 2396 | 54 | 8 | 35 | 1.542857 |
| 2559 | 46 | 6 | 24 | 1.916667 |
| 2737 | 54 | 19 | 26 | 2.076923 |
| 3045 | 81 | 11 | 47 | 1.723404 |
| 3252 | 50 | 6 | 24 | 2.083333 |
| 3386 | 34 | 7 | 19 | 1.789474 |
| 3593 | 52 | 8 | 28 | 1.857143 |
| 3716 | 38 | 23 | 17 | 2.235294 |
| 3846 | 33 | 6 | 19 | 1.736842 |
| 4057 | 46 | 11 | 26 | 1.769231 |
| 4387 | 103 | 10 | 52 | 1.980769 |
| 4682 | 93 | 4 | 52 | 1.788462 |
| 4731 | 48 | 9 | 10 | 4.8 |
| 5056 | 120 | 6 | 58 | 2.068965 |
| 5069 | 2 | 23 | 2 | 1 |
| 5399 | 109 | 11 | 53 | 2.056604 |
| 5529 | 52 | 8 | 19 | 2.736842 |
| 5595 | 16 | 7 | 7 | 2.285714 |
| 5740 | 55 | 31 | 25 | 2.2 |
| 6070 | 103 | 26 | 51 | 2.019608 |
| 6277 | 105 | 7 | 37 | 2.837838 |
| 6411 | 62 | 10 | 31 | 2 |
| 6508 | 44 | 6 | 18 | 2.444444 |
| 6651 | 56 | 6 | 27 | 2.074074 |
| 6752 | 34 | 30 | 15 | 2.266667 |
| 6783 | 19 | 9 | 6 | 3.166667 |
| 6904 | 57 | 7 | 25 | 2.28 |
| 6937 | 12 | 7 | 6 | 2 |
| 7060 | 50 | 20 | 21 | 2.380952 |
| 7179 | 57 | 8 | 19 | 3 |
| 7355 | 71 | 6 | 36 | 1.972222 |
| 7465 | 60 | 9 | 24 | 2.5 |
| 7575 | 43 | 9 | 17 | 2.529412 |
| 7731 | 63 | 29 | 25 | 2.52 |
| 7734 | 2 | 9 | 1 | 2 |
| 7850 | 56 | 7 | 25 | 2.24 |
| 7960 | 41 | 7 | 17 | 2.411765 |
| 8072 | 60 | 22 | 24 | 2.5 |
| 8290 | 99 | 7 | 34 | 2.911765 |
| 8400 | 43 | 9 | 15 | 2.866667 |
| 8532 | 118 | 9 | 30 | 3.933333 |
| 8576 | 24 | 5 | 10 | 2.4 |
| 8741 | 104 | 18 | 35 | 2.971429 |
| 8743 | 0 | 39 | 0 | 1 |
| 8757 | 53 | 5 | 4 | 13.25 |
| 8768 | 25 | 4 | 2 | 12.5 |
| 8790 | 43 | 2 | 5 | 8.6 |
| 8807 | 24 | 14 | 3 | 8 |
| 8829 | 43 | 16 | 5 | 8.6 |
| 8862 | 43 | 11 | 7 | 6.142857 |
| 8875 | 20 | 16 | 3 | 6.666667 |
| 8897 | 45 | 4 | 5 | 9 |
| 8908 | 15 | 11 | 2 | 7.5 |
| 8983 | 121 | 11 | 19 | 6.368421 |
| 8996 | 26 | 16 | 3 | 8.666667 |
| 9049 | 103 | 15 | 13 | 7.923077 |
| 9071 | 40 | 15 | 5 | 8 |
| 9084 | 32 | 37 | 3 | 10.66667 |
| 9098 | 53 | 5 | 4 | 13.25 |
| 9115 | 23 | 12 | 3 | 7.666667 |
| 9148 | 55 | 16 | 8 | 6.875 |
| 9159 | 13 | 13 | 2 | 6.5 |
| 9203 | 81 | 23 | 11 | 7.363636 |
| 9225 | 51 | 16 | 5 | 10.2 |
| 9238 | 21 | 11 | 3 | 7 |
| 9269 | 49 | 12 | 7 | 7 |
| 9302 | 76 | 13 | 8 | 9.5 |
| 9335 | 61 | 15 | 8 | 7.625 |
| 9368 | 56 | 17 | 8 | 7 |
| 9401 | 51 | 15 | 8 | 6.375 |
| 9412 | 14 | 18 | 2 | 7 |
| 9425 | 55 | 8 | 4 | 13.75 |
| 9436 | 25 | 5 | 2 | 12.5 |
| 9467 | 56 | 17 | 7 | 8 |
| 9489 | 45 | 22 | 5 | 9 |
| 9524 | 79 | 3 | 9 | 8.777778 |
| 9549 | 49 | 3 | 6 | 8.166667 |
| 9588 | 65 | 16 | 9 | 7.222222 |
| 9610 | 37 | 14 | 5 | 7.4 |
| 9643 | 68 | 15 | 8 | 8.5 |
| 9676 | 53 | 11 | 8 | 6.625 |
| 9687 | 13 | 17 | 2 | 6.5 |
| 9720 | 60 | 14 | 8 | 7.5 |
| 9753 | 62 | 20 | 8 | 7.75 |
| 9755 | 0 | 44 | 0 | 1 |
| 9769 | 45 | 7 | 4 | 11.25 |
| 9819 | 105 | 15 | 11 | 9.545455 |
| 9852 | 61 | 16 | 8 | 7.625 |
| 9874 | 31 | 14 | 5 | 6.2 |
| 9918 | 104 | 17 | 11 | 9.454545 |
| 9942 | 43 | 14 | 6 | 7.166667 |
| 9973 | 50 | 17 | 7 | 7.142857 |
| 9984 | 16 | 15 | 2 | 8 |
| 10006 | 47 | 15 | 5 | 9.4 |
| 10022 | 39 | 5 | 4 | 9.75 |
| 10050 | 58 | 18 | 6 | 9.666667 |
| 10085 | 94 | 37 | 9 | 10.44444 |
| 10116 | 82 | 12 | 8 | 10.25 |
| 10138 | 43 | 18 | 5 | 8.6 |
| 10149 | 25 | 25 | 2 | 12.5 |
| 10171 | 58 | 17 | 5 | 11.6 |
| 10215 | 95 | 23 | 11 | 8.636364 |
| 10250 | 79 | 15 | 9 | 8.777778 |
| 10281 | 62 | 18 | 7 | 8.857142 |
| 10303 | 56 | 15 | 5 | 11.2 |
| 10325 | 38 | 15 | 5 | 7.6 |
| 10336 | 17 | 16 | 2 | 8.5 |
| 10358 | 39 | 13 | 5 | 7.8 |
| 10369 | 12 | 17 | 2 | 6 |
| 10413 | 100 | 20 | 11 | 9.090909 |
| 10424 | 21 | 20 | 2 | 10.5 |
| 10437 | 51 | 5 | 4 | 12.75 |
| 10451 | 32 | 4 | 3 | 10.66667 |
| 10462 | 29 | 3 | 2 | 14.5 |
| 10484 | 55 | 11 | 5 | 11 |
| 10517 | 70 | 4 | 8 | 8.75 |
| 10561 | 115 | 4 | 11 | 10.45455 |
| 10572 | 26 | 4 | 2 | 13 |
| 10589 | 37 | 21 | 3 | 12.33333 |
| 10605 | 45 | 3 | 4 | 11.25 |
| 10633 | 51 | 18 | 6 | 8.5 |
| 10649 | 42 | 4 | 4 | 10.5 |
| 10677 | 50 | 22 | 6 | 8.333333 |
| 10699 | 42 | 18 | 5 | 8.4 |
| 10723 | 60 | 7 | 6 | 10 |
| 10754 | 62 | 20 | 7 | 8.857142 |
| 10767 | 29 | 39 | 3 | 9.666667 |
| 10781 | 53 | 7 | 4 | 13.25 |
| 10820 | 93 | 16 | 9 | 10.33333 |
| 10842 | 52 | 17 | 5 | 10.4 |
| 10864 | 42 | 18 | 5 | 8.4 |
| 10886 | 46 | 17 | 5 | 9.2 |
| 10897 | 11 | 16 | 2 | 5.5 |
| 10919 | 38 | 16 | 5 | 7.6 |
| 10941 | 35 | 17 | 5 | 7 |
| 10974 | 96 | 21 | 8 | 12 |
| 10996 | 43 | 16 | 5 | 8.6 |
| 11051 | 104 | 18 | 14 | 7.428571 |
| 11075 | 63 | 4 | 6 | 10.5 |
| 11086 | 44 | 39 | 3 | 14.66667 |
| 11097 | 51 | 4 | 3 | 17 |
| 11128 | 56 | 12 | 7 | 8 |
| 11172 | 98 | 19 | 11 | 8.909091 |
| 11218 | 126 | 10 | 12 | 10.5 |
| 11249 | 57 | 14 | 7 | 8.142858 |
| 11304 | 127 | 13 | 14 | 9.071428 |
| 11326 | 52 | 15 | 5 | 10.4 |
| 11350 | 63 | 7 | 6 | 10.5 |
| 11381 | 62 | 8 | 7 | 8.857142 |
| 11427 | 117 | 22 | 13 | 9 |
| 11447 | 47 | 29 | 5 | 9.4 |
| 11496 | 126 | 14 | 13 | 9.692307 |
| 11524 | 48 | 17 | 6 | 8 |
| 11548 | 51 | 14 | 6 | 8.5 |
| 11628 | 196 | 13 | 21 | 9.333333 |
| 11656 | 58 | 20 | 6 | 9.666667 |
| 11678 | 49 | 16 | 5 | 9.8 |
| 11700 | 56 | 15 | 5 | 11.2 |
| 11722 | 45 | 19 | 5 | 9 |
| 11744 | 56 | 14 | 5 | 11.2 |
| 11757 | 58 | 39 | 4 | 14.5 |
| 11777 | 62 | 17 | 5 | 12.4 |
| 11801 | 63 | 8 | 6 | 10.5 |
| 11826 | 62 | 6 | 6 | 10.33333 |
| 11848 | 60 | 5 | 5 | 12 |
| 11876 | 62 | 16 | 6 | 10.33333 |
| 11898 | 50 | 14 | 5 | 10 |
| 11920 | 48 | 18 | 5 | 9.6 |
| 11947 | 63 | 6 | 7 | 9 |
| 11997 | 126 | 17 | 12 | 10.5 |
| 12024 | 70 | 7 | 7 | 10 |
| 12046 | 61 | 3 | 5 | 12.2 |
| 12076 | 74 | 7 | 7 | 10.57143 |
| 12096 | 47 | 26 | 5 | 9.4 |
| 12101 | 52 | 18 | 2 | 26 |
| 12129 | 60 | 16 | 6 | 10 |
| 12151 | 48 | 21 | 5 | 9.6 |
| 12173 | 60 | 23 | 5 | 12 |
| 12197 | 59 | 5 | 6 | 9.833333 |
| 12239 | 113 | 21 | 10 | 11.3 |
| 12263 | 70 | 8 | 6 | 11.66667 |
| 12288 | 75 | 8 | 6 | 12.5 |
| 12307 | 61 | 6 | 4 | 15.25 |
| 12329 | 62 | 7 | 5 | 12.4 |
| 12376 | 142 | 8 | 12 | 11.83333 |
| 12406 | 80 | 7 | 7 | 11.42857 |
| 12428 | 46 | 9 | 5 | 9.2 |
| 12431 | 0 | 2 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000011_3C34F16F | Aug 8 2010 5:23PM | 31465 | 31465 | 158 | 0.6267882 | 3.856221 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.439217E-05 | 3.856221 | CreditCardID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 0 | 1131 | 0 | 1 | |
| 1 | 0 | 2 | 0 | 1 |
| 181 | 283 | 12 | 171 | 1.654971 |
| 242 | 82 | 12 | 56 | 1.464286 |
| 319 | 111 | 12 | 74 | 1.5 |
| 397 | 120 | 16 | 73 | 1.643836 |
| 451 | 77 | 8 | 51 | 1.509804 |
| 553 | 132 | 7 | 97 | 1.360825 |
| 626 | 112 | 11 | 69 | 1.623188 |
| 702 | 100 | 3 | 71 | 1.408451 |
| 923 | 331 | 8 | 212 | 1.561321 |
| 1024 | 127 | 3 | 94 | 1.351064 |
| 1129 | 150 | 16 | 97 | 1.546392 |
| 1246 | 177 | 27 | 112 | 1.580357 |
| 1346 | 148 | 12 | 93 | 1.591398 |
| 1417 | 104 | 12 | 68 | 1.529412 |
| 1553 | 186 | 5 | 131 | 1.419847 |
| 1651 | 156 | 8 | 94 | 1.659575 |
| 1720 | 117 | 4 | 65 | 1.8 |
| 1806 | 120 | 3 | 81 | 1.481481 |
| 1862 | 72 | 8 | 54 | 1.333333 |
| 1977 | 179 | 4 | 113 | 1.584071 |
| 2082 | 147 | 8 | 94 | 1.56383 |
| 2233 | 201 | 27 | 139 | 1.446043 |
| 2337 | 168 | 12 | 97 | 1.731959 |
| 2436 | 158 | 5 | 96 | 1.645833 |
| 2504 | 102 | 8 | 66 | 1.545455 |
| 2571 | 92 | 8 | 63 | 1.460317 |
| 2687 | 170 | 6 | 108 | 1.574074 |
| 2759 | 118 | 6 | 68 | 1.735294 |
| 2880 | 170 | 4 | 115 | 1.478261 |
| 2954 | 94 | 3 | 70 | 1.342857 |
| 3032 | 127 | 4 | 76 | 1.671053 |
| 3088 | 91 | 8 | 51 | 1.784314 |
| 3157 | 93 | 8 | 64 | 1.453125 |
| 3235 | 113 | 7 | 72 | 1.569444 |
| 3318 | 123 | 8 | 80 | 1.5375 |
| 3392 | 105 | 4 | 69 | 1.521739 |
| 3510 | 183 | 17 | 107 | 1.71028 |
| 3555 | 60 | 5 | 42 | 1.428571 |
| 3653 | 149 | 4 | 92 | 1.619565 |
| 3729 | 110 | 3 | 75 | 1.466667 |
| 3788 | 103 | 12 | 56 | 1.839286 |
| 3980 | 274 | 12 | 179 | 1.530726 |
| 4052 | 92 | 6 | 67 | 1.373134 |
| 4173 | 169 | 8 | 116 | 1.456897 |
| 4304 | 180 | 8 | 125 | 1.44 |
| 4357 | 81 | 12 | 51 | 1.588235 |
| 4459 | 144 | 11 | 99 | 1.454545 |
| 4552 | 126 | 4 | 90 | 1.4 |
| 4626 | 108 | 7 | 72 | 1.5 |
| 4720 | 132 | 5 | 90 | 1.466667 |
| 4797 | 102 | 5 | 72 | 1.416667 |
| 4845 | 86 | 16 | 45 | 1.911111 |
| 4941 | 143 | 12 | 92 | 1.554348 |
| 4983 | 61 | 8 | 40 | 1.525 |
| 5089 | 147 | 8 | 101 | 1.455446 |
| 5164 | 119 | 12 | 71 | 1.676056 |
| 5343 | 266 | 7 | 164 | 1.621951 |
| 5434 | 123 | 4 | 87 | 1.413793 |
| 5475 | 66 | 27 | 38 | 1.736842 |
| 5570 | 127 | 8 | 89 | 1.426966 |
| 5690 | 185 | 8 | 112 | 1.651786 |
| 5754 | 93 | 8 | 57 | 1.631579 |
| 5868 | 164 | 8 | 107 | 1.53271 |
| 5958 | 122 | 8 | 86 | 1.418605 |
| 6065 | 157 | 12 | 101 | 1.554455 |
| 6169 | 180 | 27 | 100 | 1.8 |
| 6264 | 148 | 11 | 90 | 1.644444 |
| 6386 | 191 | 12 | 117 | 1.632479 |
| 6452 | 77 | 12 | 60 | 1.283333 |
| 6742 | 448 | 4 | 278 | 1.611511 |
| 6920 | 259 | 1 | 170 | 1.523529 |
| 6985 | 128 | 3 | 63 | 2.031746 |
| 7079 | 129 | 4 | 90 | 1.433333 |
| 7158 | 130 | 1 | 74 | 1.756757 |
| 7331 | 265 | 3 | 170 | 1.558824 |
| 7386 | 126 | 3 | 52 | 2.423077 |
| 7475 | 142 | 4 | 86 | 1.651163 |
| 7597 | 172 | 8 | 117 | 1.470086 |
| 7672 | 131 | 4 | 74 | 1.77027 |
| 7764 | 135 | 4 | 90 | 1.5 |
| 7829 | 83 | 10 | 60 | 1.383333 |
| 7898 | 111 | 4 | 68 | 1.632353 |
| 7982 | 122 | 3 | 82 | 1.487805 |
| 8091 | 180 | 4 | 103 | 1.747573 |
| 8672 | 890 | 8 | 560 | 1.589286 |
| 8882 | 304 | 6 | 198 | 1.535354 |
| 9006 | 190 | 27 | 116 | 1.637931 |
| 9267 | 349 | 2 | 246 | 1.418699 |
| 9387 | 189 | 27 | 118 | 1.601695 |
| 9635 | 368 | 8 | 233 | 1.579399 |
| 9734 | 127 | 2 | 90 | 1.411111 |
| 10004 | 418 | 8 | 262 | 1.59542 |
| 10087 | 145 | 17 | 76 | 1.907895 |
| 10163 | 119 | 9 | 71 | 1.676056 |
| 10261 | 150 | 27 | 89 | 1.685393 |
| 10336 | 105 | 8 | 68 | 1.544118 |
| 10453 | 185 | 7 | 112 | 1.651786 |
| 10623 | 250 | 8 | 163 | 1.533742 |
| 10662 | 64 | 8 | 36 | 1.777778 |
| 10762 | 124 | 4 | 91 | 1.362637 |
| 10844 | 127 | 1 | 77 | 1.649351 |
| 10899 | 74 | 7 | 52 | 1.423077 |
| 10987 | 127 | 3 | 84 | 1.511905 |
| 11334 | 514 | 28 | 322 | 1.596273 |
| 11593 | 384 | 1 | 244 | 1.573771 |
| 11745 | 244 | 12 | 142 | 1.71831 |
| 11843 | 181 | 28 | 95 | 1.905263 |
| 11886 | 68 | 12 | 40 | 1.7 |
| 11977 | 127 | 1 | 87 | 1.45977 |
| 12216 | 383 | 1 | 225 | 1.702222 |
| 12395 | 255 | 2 | 166 | 1.536145 |
| 12722 | 513 | 3 | 310 | 1.654839 |
| 12992 | 394 | 3 | 256 | 1.539063 |
| 13064 | 125 | 8 | 66 | 1.893939 |
| 13160 | 139 | 8 | 93 | 1.494624 |
| 13349 | 272 | 4 | 182 | 1.494506 |
| 13712 | 554 | 12 | 343 | 1.61516 |
| 13802 | 124 | 5 | 78 | 1.589744 |
| 13889 | 113 | 16 | 84 | 1.345238 |
| 13971 | 149 | 8 | 80 | 1.8625 |
| 14064 | 134 | 4 | 84 | 1.595238 |
| 14152 | 139 | 4 | 81 | 1.716049 |
| 14226 | 134 | 4 | 70 | 1.914286 |
| 14303 | 126 | 4 | 75 | 1.68 |
| 14401 | 141 | 4 | 94 | 1.5 |
| 14486 | 133 | 4 | 81 | 1.641975 |
| 14559 | 119 | 12 | 67 | 1.776119 |
| 14673 | 174 | 4 | 108 | 1.611111 |
| 14790 | 162 | 4 | 111 | 1.459459 |
| 15008 | 345 | 17 | 203 | 1.699507 |
| 15135 | 191 | 1 | 120 | 1.591667 |
| 15232 | 161 | 12 | 94 | 1.712766 |
| 15442 | 327 | 2 | 200 | 1.635 |
| 15538 | 167 | 9 | 92 | 1.815217 |
| 15648 | 173 | 5 | 106 | 1.632075 |
| 15773 | 172 | 7 | 118 | 1.457627 |
| 15954 | 294 | 8 | 174 | 1.689655 |
| 16336 | 575 | 1 | 361 | 1.592798 |
| 16467 | 183 | 8 | 126 | 1.452381 |
| 16569 | 144 | 8 | 93 | 1.548387 |
| 16703 | 191 | 1 | 131 | 1.458015 |
| 16780 | 118 | 16 | 73 | 1.616438 |
| 17163 | 578 | 1 | 365 | 1.583562 |
| 17368 | 345 | 12 | 198 | 1.742424 |
| 17600 | 325 | 9 | 219 | 1.484018 |
| 17669 | 120 | 12 | 66 | 1.818182 |
| 17784 | 191 | 1 | 107 | 1.785047 |
| 17861 | 121 | 12 | 73 | 1.657534 |
| 18323 | 764 | 12 | 445 | 1.716854 |
| 18432 | 190 | 3 | 105 | 1.809524 |
| 18781 | 575 | 3 | 335 | 1.716418 |
| 18881 | 191 | 1 | 94 | 2.031915 |
| 19013 | 191 | 1 | 125 | 1.528 |
| 19136 | 191 | 1 | 114 | 1.675439 |
| 19236 | 166 | 1 | 93 | 1.784946 |
| 19237 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_0000000F_3C34F16F | Aug 8 2010 5:23PM | 31465 | 31465 | 120 | 0.617071 | 4 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.230399E-05 | 4 | ShipToAddressID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 9 | 0 | 8 | 0 | 1 |
| 423 | 135 | 1 | 45 | 3 |
| 452 | 96 | 12 | 23 | 4.173913 |
| 473 | 131 | 12 | 19 | 6.894737 |
| 497 | 111 | 12 | 19 | 5.842105 |
| 517 | 118 | 12 | 18 | 6.555555 |
| 553 | 187 | 10 | 32 | 5.84375 |
| 567 | 94 | 12 | 12 | 7.833333 |
| 587 | 87 | 12 | 17 | 5.117647 |
| 606 | 120 | 12 | 18 | 6.666667 |
| 631 | 121 | 12 | 21 | 5.761905 |
| 654 | 106 | 3 | 21 | 5.047619 |
| 688 | 155 | 8 | 30 | 5.166667 |
| 717 | 125 | 1 | 22 | 5.681818 |
| 755 | 130 | 12 | 30 | 4.333333 |
| 777 | 150 | 1 | 19 | 7.894737 |
| 798 | 109 | 8 | 18 | 6.055555 |
| 819 | 116 | 3 | 18 | 6.444445 |
| 862 | 236 | 3 | 38 | 6.210526 |
| 889 | 126 | 12 | 21 | 6 |
| 926 | 221 | 12 | 35 | 6.314286 |
| 948 | 71 | 12 | 15 | 4.733333 |
| 1008 | 339 | 8 | 56 | 6.053571 |
| 1032 | 118 | 12 | 20 | 5.9 |
| 1061 | 156 | 11 | 22 | 7.090909 |
| 1076 | 71 | 12 | 12 | 5.916667 |
| 1104 | 137 | 12 | 24 | 5.708333 |
| 11456 | 112 | 7 | 63 | 1.777778 |
| 11696 | 391 | 3 | 239 | 1.635983 |
| 11826 | 181 | 16 | 129 | 1.403101 |
| 12034 | 302 | 1 | 206 | 1.466019 |
| 12129 | 127 | 2 | 94 | 1.351064 |
| 12214 | 126 | 5 | 84 | 1.5 |
| 12350 | 226 | 1 | 135 | 1.674074 |
| 12503 | 223 | 4 | 152 | 1.467105 |
| 12564 | 94 | 2 | 60 | 1.566667 |
| 12965 | 566 | 4 | 400 | 1.415 |
| 13051 | 127 | 2 | 85 | 1.494118 |
| 13153 | 136 | 5 | 100 | 1.36 |
| 13485 | 493 | 2 | 330 | 1.493939 |
| 13550 | 86 | 28 | 64 | 1.34375 |
| 13675 | 190 | 1 | 124 | 1.532258 |
| 13768 | 127 | 2 | 92 | 1.380435 |
| 13910 | 233 | 5 | 141 | 1.652482 |
| 14022 | 156 | 5 | 111 | 1.405405 |
| 14104 | 124 | 4 | 81 | 1.530864 |
| 14167 | 86 | 17 | 61 | 1.409836 |
| 14400 | 320 | 2 | 232 | 1.37931 |
| 14444 | 65 | 27 | 43 | 1.511628 |
| 14539 | 161 | 2 | 93 | 1.731183 |
| 15662 | 1673 | 2 | 1119 | 1.495085 |
| 15711 | 63 | 2 | 48 | 1.3125 |
| 15845 | 190 | 4 | 133 | 1.428571 |
| 15988 | 192 | 2 | 142 | 1.352113 |
| 16432 | 640 | 3 | 443 | 1.444695 |
| 16746 | 468 | 16 | 313 | 1.495208 |
| 16889 | 191 | 2 | 142 | 1.34507 |
| 16941 | 65 | 3 | 51 | 1.27451 |
| 17030 | 129 | 3 | 88 | 1.465909 |
| 17081 | 64 | 2 | 50 | 1.28 |
| 17211 | 191 | 1 | 129 | 1.48062 |
| 17306 | 131 | 3 | 94 | 1.393617 |
| 17410 | 132 | 2 | 103 | 1.281553 |
| 17641 | 325 | 2 | 230 | 1.413043 |
| 17788 | 195 | 2 | 146 | 1.335616 |
| 17878 | 128 | 2 | 89 | 1.438202 |
| 17983 | 136 | 3 | 103 | 1.320388 |
| 18073 | 127 | 2 | 89 | 1.426966 |
| 18281 | 317 | 16 | 206 | 1.538835 |
| 18383 | 137 | 3 | 101 | 1.356436 |
| 18677 | 427 | 3 | 293 | 1.457338 |
| 18738 | 82 | 3 | 60 | 1.366667 |
| 18816 | 132 | 3 | 77 | 1.714286 |
| 19034 | 305 | 3 | 217 | 1.40553 |
| 19117 | 127 | 2 | 82 | 1.54878 |
| 19237 | 169 | 3 | 119 | 1.420168 |
| 19314 | 102 | 3 | 76 | 1.342105 |
| 19507 | 304 | 5 | 192 | 1.583333 |
| 21340 | 2640 | 1 | 1829 | 1.443412 |
| 21552 | 325 | 2 | 211 | 1.540284 |
| 21639 | 169 | 27 | 86 | 1.965116 |
| 21707 | 93 | 16 | 67 | 1.38806 |
| 22133 | 640 | 1 | 425 | 1.505882 |
| 22285 | 253 | 4 | 151 | 1.675497 |
| 22460 | 255 | 1 | 174 | 1.465517 |
| 22542 | 127 | 2 | 81 | 1.567901 |
| 22811 | 384 | 3 | 268 | 1.432836 |
| 22882 | 129 | 1 | 70 | 1.842857 |
| 23407 | 782 | 3 | 524 | 1.492366 |
| 23490 | 129 | 1 | 82 | 1.573171 |
| 23567 | 127 | 1 | 76 | 1.671053 |
| 24073 | 732 | 4 | 505 | 1.449505 |
| 24152 | 127 | 3 | 77 | 1.649351 |
| 24246 | 127 | 2 | 93 | 1.365591 |
| 24521 | 397 | 27 | 274 | 1.448905 |
| 24660 | 191 | 1 | 138 | 1.384058 |
| 24751 | 134 | 3 | 90 | 1.488889 |
| 24879 | 177 | 3 | 127 | 1.393701 |
| 24968 | 136 | 3 | 88 | 1.545455 |
| 25057 | 120 | 27 | 88 | 1.363636 |
| 25161 | 177 | 4 | 103 | 1.718447 |
| 25285 | 178 | 5 | 123 | 1.447155 |
| 25501 | 333 | 5 | 215 | 1.548837 |
| 26226 | 1063 | 2 | 723 | 1.470263 |
| 26364 | 190 | 4 | 136 | 1.397059 |
| 27018 | 962 | 3 | 650 | 1.48 |
| 27138 | 191 | 1 | 119 | 1.605042 |
| 27411 | 384 | 1 | 272 | 1.411765 |
| 27666 | 384 | 2 | 254 | 1.511811 |
| 27772 | 190 | 4 | 105 | 1.809524 |
| 27902 | 190 | 2 | 129 | 1.472868 |
| 28261 | 575 | 3 | 358 | 1.606145 |
| 28803 | 775 | 3 | 541 | 1.432532 |
| 29051 | 384 | 1 | 247 | 1.554656 |
| 29321 | 383 | 2 | 268 | 1.429104 |
| 29449 | 192 | 1 | 126 | 1.52381 |
| 29589 | 190 | 2 | 138 | 1.376812 |
| 29687 | 193 | 1 | 96 | 2.010417 |
| 29882 | 301 | 1 | 193 | 1.559585 |
| 29883 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_0000000E_3C34F16F | Aug 8 2010 5:23PM | 31465 | 31465 | 119 | 0.6184896 | 4 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 5.230399E-05 | 4 | BillToAddressID |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 405 | 0 | 4 | 0 | 1 |
| 445 | 121 | 8 | 33 | 3.666667 |
| 473 | 172 | 12 | 26 | 6.615385 |
| 497 | 111 | 12 | 19 | 5.842105 |
| 517 | 118 | 12 | 18 | 6.555555 |
| 529 | 77 | 12 | 11 | 7 |
| 553 | 105 | 10 | 21 | 5 |
| 567 | 102 | 12 | 13 | 7.846154 |
| 587 | 91 | 12 | 18 | 5.055555 |
| 606 | 120 | 12 | 18 | 6.666667 |
| 631 | 125 | 12 | 22 | 5.681818 |
| 688 | 264 | 8 | 52 | 5.076923 |
| 717 | 125 | 1 | 22 | 5.681818 |
| 746 | 91 | 8 | 22 | 4.136364 |
| 765 | 104 | 12 | 15 | 6.933333 |
| 798 | 187 | 8 | 30 | 6.233333 |
| 829 | 181 | 12 | 27 | 6.703704 |
| 849 | 90 | 12 | 19 | 4.736842 |
| 880 | 179 | 12 | 27 | 6.62963 |
| 907 | 139 | 4 | 24 | 5.791667 |
| 926 | 113 | 12 | 18 | 6.277778 |
| 948 | 75 | 12 | 16 | 4.6875 |
| 1008 | 339 | 8 | 56 | 6.053571 |
| 1032 | 123 | 12 | 21 | 5.857143 |
| 1067 | 186 | 1 | 27 | 6.888889 |
| 1076 | 63 | 12 | 8 | 7.875 |
| 1104 | 137 | 12 | 24 | 5.708333 |
| 11456 | 91 | 7 | 57 | 1.596491 |
| 11572 | 187 | 4 | 115 | 1.626087 |
| 11681 | 164 | 16 | 108 | 1.518519 |
| 12205 | 765 | 1 | 523 | 1.462715 |
| 12350 | 245 | 1 | 144 | 1.701389 |
| 12622 | 405 | 4 | 271 | 1.494465 |
| 13052 | 613 | 2 | 429 | 1.428904 |
| 13153 | 135 | 5 | 100 | 1.35 |
| 13228 | 107 | 5 | 74 | 1.445946 |
| 13396 | 250 | 5 | 167 | 1.497006 |
| 13550 | 215 | 28 | 153 | 1.405229 |
| 13676 | 191 | 1 | 125 | 1.528 |
| 13768 | 126 | 2 | 91 | 1.384615 |
| 13910 | 233 | 5 | 141 | 1.652482 |
| 14022 | 156 | 5 | 111 | 1.405405 |
| 14104 | 124 | 4 | 81 | 1.530864 |
| 14167 | 87 | 17 | 62 | 1.403226 |
| 14400 | 320 | 2 | 232 | 1.37931 |
| 14498 | 173 | 17 | 97 | 1.783505 |
| 15273 | 1168 | 6 | 774 | 1.509044 |
| 15896 | 898 | 2 | 622 | 1.44373 |
| 16042 | 191 | 1 | 145 | 1.317241 |
| 16480 | 638 | 17 | 437 | 1.459954 |
| 16525 | 61 | 6 | 44 | 1.386364 |
| 16746 | 321 | 16 | 220 | 1.459091 |
| 16889 | 191 | 2 | 142 | 1.34507 |
| 16941 | 65 | 3 | 51 | 1.27451 |
| 17030 | 129 | 3 | 88 | 1.465909 |
| 17081 | 64 | 2 | 50 | 1.28 |
| 17211 | 191 | 1 | 129 | 1.48062 |
| 17306 | 131 | 3 | 94 | 1.393617 |
| 17410 | 132 | 2 | 103 | 1.281553 |
| 17595 | 264 | 2 | 184 | 1.434783 |
| 18073 | 655 | 2 | 477 | 1.373166 |
| 18281 | 319 | 16 | 207 | 1.541063 |
| 18383 | 137 | 3 | 101 | 1.356436 |
| 18476 | 137 | 4 | 92 | 1.48913 |
| 18637 | 223 | 5 | 160 | 1.39375 |
| 18682 | 65 | 3 | 44 | 1.477273 |
| 18843 | 256 | 3 | 160 | 1.6 |
| 18952 | 142 | 3 | 108 | 1.314815 |
| 19119 | 247 | 4 | 166 | 1.487952 |
| 19317 | 276 | 5 | 197 | 1.401015 |
| 19403 | 127 | 1 | 85 | 1.494118 |
| 19507 | 167 | 5 | 103 | 1.621359 |
| 20102 | 846 | 2 | 594 | 1.424242 |
| 20201 | 127 | 2 | 98 | 1.295918 |
| 20465 | 383 | 2 | 263 | 1.456274 |
| 20720 | 382 | 2 | 254 | 1.503937 |
| 21340 | 898 | 1 | 619 | 1.450727 |
| 21552 | 325 | 2 | 211 | 1.540284 |
| 21639 | 169 | 27 | 86 | 1.965116 |
| 21707 | 93 | 16 | 67 | 1.38806 |
| 22168 | 688 | 27 | 460 | 1.495652 |
| 22252 | 113 | 16 | 83 | 1.361446 |
| 22506 | 384 | 2 | 253 | 1.517787 |
| 22777 | 388 | 2 | 270 | 1.437037 |
| 22850 | 128 | 1 | 72 | 1.777778 |
| 22935 | 133 | 3 | 84 | 1.583333 |
| 23111 | 254 | 3 | 175 | 1.451429 |
| 23372 | 386 | 3 | 260 | 1.484615 |
| 23534 | 258 | 1 | 161 | 1.602484 |
| 23631 | 144 | 3 | 96 | 1.5 |
| 24002 | 527 | 2 | 370 | 1.424324 |
| 24343 | 515 | 4 | 340 | 1.514706 |
| 24521 | 251 | 27 | 177 | 1.418079 |
| 24660 | 191 | 1 | 138 | 1.384058 |
| 24751 | 134 | 3 | 90 | 1.488889 |
| 24879 | 177 | 3 | 127 | 1.393701 |
| 24968 | 136 | 3 | 88 | 1.545455 |
| 25057 | 120 | 27 | 88 | 1.363636 |
| 25161 | 177 | 4 | 103 | 1.718447 |
| 25257 | 136 | 3 | 95 | 1.431579 |
| 25480 | 343 | 4 | 222 | 1.545045 |
| 26226 | 1099 | 2 | 745 | 1.475168 |
| 26364 | 191 | 4 | 137 | 1.394161 |
| 27013 | 959 | 2 | 648 | 1.479938 |
| 27129 | 191 | 1 | 115 | 1.66087 |
| 27403 | 382 | 2 | 273 | 1.399267 |
| 27528 | 190 | 2 | 124 | 1.532258 |
| 27661 | 191 | 2 | 132 | 1.44697 |
| 27764 | 191 | 1 | 102 | 1.872549 |
| 27893 | 191 | 2 | 128 | 1.492188 |
| 28256 | 580 | 1 | 362 | 1.60221 |
| 28794 | 771 | 3 | 537 | 1.435754 |
| 29173 | 575 | 2 | 378 | 1.521164 |
| 29312 | 193 | 2 | 138 | 1.398551 |
| 29445 | 196 | 3 | 132 | 1.484848 |
| 29585 | 191 | 2 | 139 | 1.374101 |
| 29678 | 191 | 1 | 92 | 2.076087 |
| 29882 | 312 | 1 | 203 | 1.536946 |
| 29883 | 0 | 1 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000003_3C34F16F | Jul 16 2011 12:25PM | 31465 | 31465 | 199 | 0.05197797 | 8 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.0008896797 | 8 | OrderDate |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 7/1/2001 12:00:00 AM | 0 | 43 | 0 | 1 |
| 7/22/2001 12:00:00 AM | 82 | 11 | 20 | 4.1 |
| 8/1/2001 12:00:00 AM | 48 | 80 | 9 | 5.333333 |
| 9/1/2001 12:00:00 AM | 151 | 64 | 29 | 5.206897 |
| 10/1/2001 12:00:00 AM | 142 | 44 | 28 | 5.071429 |
| 10/12/2001 12:00:00 AM | 57 | 12 | 10 | 5.7 |
| 11/1/2001 12:00:00 AM | 88 | 96 | 18 | 4.888889 |
| 12/1/2001 12:00:00 AM | 163 | 68 | 29 | 5.62069 |
| 12/19/2001 12:00:00 AM | 126 | 14 | 17 | 7.411765 |
| 1/1/2002 12:00:00 AM | 90 | 45 | 12 | 7.5 |
| 2/1/2002 12:00:00 AM | 183 | 85 | 30 | 6.1 |
| 2/11/2002 12:00:00 AM | 59 | 12 | 9 | 6.555555 |
| 3/1/2002 12:00:00 AM | 94 | 70 | 17 | 5.529412 |
| 3/24/2002 12:00:00 AM | 142 | 12 | 22 | 6.454545 |
| 4/1/2002 12:00:00 AM | 39 | 42 | 7 | 5.571429 |
| 4/15/2002 12:00:00 AM | 76 | 13 | 13 | 5.846154 |
| 5/1/2002 12:00:00 AM | 113 | 97 | 15 | 7.533333 |
| 5/13/2002 12:00:00 AM | 72 | 13 | 11 | 6.545455 |
| 6/1/2002 12:00:00 AM | 117 | 72 | 18 | 6.5 |
| 6/19/2002 12:00:00 AM | 114 | 13 | 17 | 6.705883 |
| 7/1/2002 12:00:00 AM | 83 | 80 | 11 | 7.545455 |
| 7/15/2002 12:00:00 AM | 115 | 4 | 13 | 8.846154 |
| 8/1/2002 12:00:00 AM | 126 | 148 | 16 | 7.875 |
| 8/23/2002 12:00:00 AM | 187 | 5 | 21 | 8.904762 |
| 9/1/2002 12:00:00 AM | 80 | 113 | 8 | 10 |
| 9/15/2002 12:00:00 AM | 94 | 4 | 13 | 7.230769 |
| 10/1/2002 12:00:00 AM | 98 | 81 | 15 | 6.533333 |
| 10/19/2002 12:00:00 AM | 119 | 12 | 17 | 7 |
| 11/1/2002 12:00:00 AM | 90 | 139 | 12 | 7.5 |
| 11/11/2002 12:00:00 AM | 49 | 11 | 9 | 5.444445 |
| 12/1/2002 12:00:00 AM | 127 | 125 | 19 | 6.68421 |
| 12/7/2002 12:00:00 AM | 47 | 17 | 5 | 9.4 |
| 12/15/2002 12:00:00 AM | 87 | 5 | 7 | 12.42857 |
| 12/21/2002 12:00:00 AM | 60 | 3 | 5 | 12 |
| 1/1/2003 12:00:00 AM | 100 | 73 | 10 | 10 |
| 1/23/2003 12:00:00 AM | 171 | 14 | 21 | 8.142858 |
| 2/1/2003 12:00:00 AM | 51 | 142 | 8 | 6.375 |
| 2/4/2003 12:00:00 AM | 19 | 17 | 2 | 9.5 |
| 3/1/2003 12:00:00 AM | 226 | 115 | 24 | 9.416667 |
| 3/12/2003 12:00:00 AM | 87 | 19 | 10 | 8.7 |
| 3/18/2003 12:00:00 AM | 37 | 15 | 5 | 7.4 |
| 4/1/2003 12:00:00 AM | 105 | 85 | 13 | 8.076923 |
| 4/13/2003 12:00:00 AM | 105 | 18 | 11 | 9.545455 |
| 4/17/2003 12:00:00 AM | 24 | 16 | 3 | 8 |
| 5/1/2003 12:00:00 AM | 120 | 147 | 13 | 9.230769 |
| 5/18/2003 12:00:00 AM | 173 | 2 | 16 | 10.8125 |
| 6/1/2003 12:00:00 AM | 147 | 117 | 13 | 11.30769 |
| 6/8/2003 12:00:00 AM | 61 | 17 | 6 | 10.16667 |
| 6/21/2003 12:00:00 AM | 126 | 16 | 12 | 10.5 |
| 7/1/2003 12:00:00 AM | 86 | 108 | 9 | 9.555555 |
| 7/6/2003 12:00:00 AM | 73 | 6 | 4 | 18.25 |
| 7/11/2003 12:00:00 AM | 68 | 23 | 4 | 17 |
| 7/20/2003 12:00:00 AM | 119 | 24 | 8 | 14.875 |
| 7/24/2003 12:00:00 AM | 41 | 28 | 3 | 13.66667 |
| 8/1/2003 12:00:00 AM | 119 | 232 | 7 | 17 |
| 8/3/2003 12:00:00 AM | 43 | 54 | 1 | 43 |
| 8/6/2003 12:00:00 AM | 88 | 46 | 2 | 44 |
| 8/9/2003 12:00:00 AM | 125 | 51 | 2 | 62.5 |
| 8/12/2003 12:00:00 AM | 79 | 61 | 2 | 39.5 |
| 8/15/2003 12:00:00 AM | 108 | 38 | 2 | 54 |
| 8/19/2003 12:00:00 AM | 163 | 63 | 3 | 54.33333 |
| 8/23/2003 12:00:00 AM | 122 | 41 | 3 | 40.66667 |
| 8/25/2003 12:00:00 AM | 64 | 65 | 1 | 64 |
| 8/28/2003 12:00:00 AM | 107 | 49 | 2 | 53.5 |
| 9/1/2003 12:00:00 AM | 161 | 212 | 3 | 53.66667 |
| 9/4/2003 12:00:00 AM | 110 | 58 | 2 | 55 |
| 9/6/2003 12:00:00 AM | 44 | 46 | 1 | 44 |
| 9/9/2003 12:00:00 AM | 119 | 64 | 2 | 59.5 |
| 9/11/2003 12:00:00 AM | 45 | 37 | 1 | 45 |
| 9/13/2003 12:00:00 AM | 64 | 67 | 1 | 64 |
| 9/17/2003 12:00:00 AM | 161 | 50 | 3 | 53.66667 |
| 9/19/2003 12:00:00 AM | 58 | 72 | 1 | 58 |
| 9/23/2003 12:00:00 AM | 164 | 60 | 3 | 54.66667 |
| 9/25/2003 12:00:00 AM | 51 | 44 | 1 | 51 |
| 9/27/2003 12:00:00 AM | 54 | 62 | 1 | 54 |
| 9/29/2003 12:00:00 AM | 47 | 40 | 1 | 47 |
| 10/1/2003 12:00:00 AM | 54 | 151 | 1 | 54 |
| 10/4/2003 12:00:00 AM | 121 | 50 | 2 | 60.5 |
| 10/6/2003 12:00:00 AM | 58 | 69 | 1 | 58 |
| 10/8/2003 12:00:00 AM | 54 | 77 | 1 | 54 |
| 10/10/2003 12:00:00 AM | 54 | 55 | 1 | 54 |
| 10/13/2003 12:00:00 AM | 98 | 48 | 2 | 49 |
| 10/15/2003 12:00:00 AM | 57 | 63 | 1 | 57 |
| 10/18/2003 12:00:00 AM | 85 | 59 | 2 | 42.5 |
| 10/20/2003 12:00:00 AM | 45 | 53 | 1 | 45 |
| 10/23/2003 12:00:00 AM | 110 | 59 | 2 | 55 |
| 10/26/2003 12:00:00 AM | 93 | 65 | 2 | 46.5 |
| 10/29/2003 12:00:00 AM | 94 | 56 | 2 | 47 |
| 11/1/2003 12:00:00 AM | 105 | 230 | 2 | 52.5 |
| 11/3/2003 12:00:00 AM | 59 | 69 | 1 | 59 |
| 11/5/2003 12:00:00 AM | 58 | 53 | 1 | 58 |
| 11/8/2003 12:00:00 AM | 112 | 41 | 2 | 56 |
| 11/11/2003 12:00:00 AM | 113 | 41 | 2 | 56.5 |
| 11/15/2003 12:00:00 AM | 170 | 61 | 3 | 56.66667 |
| 11/17/2003 12:00:00 AM | 52 | 59 | 1 | 52 |
| 11/20/2003 12:00:00 AM | 119 | 39 | 2 | 59.5 |
| 11/22/2003 12:00:00 AM | 62 | 65 | 1 | 62 |
| 11/24/2003 12:00:00 AM | 54 | 72 | 1 | 54 |
| 11/28/2003 12:00:00 AM | 161 | 75 | 3 | 53.66667 |
| 12/1/2003 12:00:00 AM | 124 | 242 | 2 | 62 |
| 12/4/2003 12:00:00 AM | 129 | 71 | 2 | 64.5 |
| 12/5/2003 12:00:00 AM | 0 | 64 | 0 | 1 |
| 12/7/2003 12:00:00 AM | 81 | 91 | 1 | 81 |
| 12/10/2003 12:00:00 AM | 130 | 52 | 2 | 65 |
| 12/13/2003 12:00:00 AM | 143 | 79 | 2 | 71.5 |
| 12/15/2003 12:00:00 AM | 61 | 79 | 1 | 61 |
| 12/17/2003 12:00:00 AM | 56 | 70 | 1 | 56 |
| 12/19/2003 12:00:00 AM | 69 | 64 | 1 | 69 |
| 12/21/2003 12:00:00 AM | 71 | 66 | 1 | 71 |
| 12/23/2003 12:00:00 AM | 43 | 69 | 1 | 43 |
| 12/26/2003 12:00:00 AM | 134 | 72 | 2 | 67 |
| 12/29/2003 12:00:00 AM | 119 | 77 | 2 | 59.5 |
| 12/31/2003 12:00:00 AM | 60 | 80 | 1 | 60 |
| 1/1/2004 12:00:00 AM | 0 | 140 | 0 | 1 |
| 1/4/2004 12:00:00 AM | 115 | 54 | 2 | 57.5 |
| 1/8/2004 12:00:00 AM | 175 | 75 | 3 | 58.33333 |
| 1/11/2004 12:00:00 AM | 124 | 66 | 2 | 62 |
| 1/14/2004 12:00:00 AM | 100 | 66 | 2 | 50 |
| 1/16/2004 12:00:00 AM | 70 | 75 | 1 | 70 |
| 1/18/2004 12:00:00 AM | 52 | 62 | 1 | 52 |
| 1/20/2004 12:00:00 AM | 49 | 75 | 1 | 49 |
| 1/24/2004 12:00:00 AM | 157 | 67 | 3 | 52.33333 |
| 1/26/2004 12:00:00 AM | 56 | 69 | 1 | 56 |
| 1/28/2004 12:00:00 AM | 55 | 71 | 1 | 55 |
| 2/1/2004 12:00:00 AM | 173 | 244 | 3 | 57.66667 |
| 2/3/2004 12:00:00 AM | 62 | 72 | 1 | 62 |
| 2/5/2004 12:00:00 AM | 54 | 70 | 1 | 54 |
| 2/7/2004 12:00:00 AM | 69 | 67 | 1 | 69 |
| 2/10/2004 12:00:00 AM | 123 | 67 | 2 | 61.5 |
| 2/12/2004 12:00:00 AM | 49 | 58 | 1 | 49 |
| 2/15/2004 12:00:00 AM | 124 | 67 | 2 | 62 |
| 2/17/2004 12:00:00 AM | 52 | 80 | 1 | 52 |
| 2/19/2004 12:00:00 AM | 76 | 69 | 1 | 76 |
| 2/21/2004 12:00:00 AM | 90 | 65 | 1 | 90 |
| 2/24/2004 12:00:00 AM | 113 | 64 | 2 | 56.5 |
| 2/26/2004 12:00:00 AM | 43 | 51 | 1 | 43 |
| 2/28/2004 12:00:00 AM | 73 | 68 | 1 | 73 |
| 3/1/2004 12:00:00 AM | 62 | 245 | 1 | 62 |
| 3/4/2004 12:00:00 AM | 108 | 57 | 2 | 54 |
| 3/7/2004 12:00:00 AM | 120 | 65 | 2 | 60 |
| 3/9/2004 12:00:00 AM | 56 | 77 | 1 | 56 |
| 3/11/2004 12:00:00 AM | 71 | 65 | 1 | 71 |
| 3/13/2004 12:00:00 AM | 64 | 75 | 1 | 64 |
| 3/16/2004 12:00:00 AM | 109 | 55 | 2 | 54.5 |
| 3/19/2004 12:00:00 AM | 115 | 70 | 2 | 57.5 |
| 3/21/2004 12:00:00 AM | 64 | 72 | 1 | 64 |
| 3/24/2004 12:00:00 AM | 126 | 64 | 2 | 63 |
| 3/27/2004 12:00:00 AM | 113 | 76 | 2 | 56.5 |
| 3/30/2004 12:00:00 AM | 123 | 61 | 2 | 61.5 |
| 4/1/2004 12:00:00 AM | 58 | 158 | 1 | 58 |
| 4/3/2004 12:00:00 AM | 64 | 95 | 1 | 64 |
| 4/6/2004 12:00:00 AM | 120 | 68 | 2 | 60 |
| 4/8/2004 12:00:00 AM | 74 | 65 | 1 | 74 |
| 4/11/2004 12:00:00 AM | 126 | 59 | 2 | 63 |
| 4/13/2004 12:00:00 AM | 62 | 48 | 1 | 62 |
| 4/15/2004 12:00:00 AM | 67 | 76 | 1 | 67 |
| 4/18/2004 12:00:00 AM | 127 | 71 | 2 | 63.5 |
| 4/19/2004 12:00:00 AM | 0 | 84 | 0 | 1 |
| 4/22/2004 12:00:00 AM | 115 | 73 | 2 | 57.5 |
| 4/24/2004 12:00:00 AM | 75 | 64 | 1 | 75 |
| 4/25/2004 12:00:00 AM | 0 | 76 | 0 | 1 |
| 4/28/2004 12:00:00 AM | 134 | 84 | 2 | 67 |
| 4/30/2004 12:00:00 AM | 64 | 79 | 1 | 64 |
| 5/1/2004 12:00:00 AM | 0 | 271 | 0 | 1 |
| 5/3/2004 12:00:00 AM | 63 | 71 | 1 | 63 |
| 5/5/2004 12:00:00 AM | 72 | 80 | 1 | 72 |
| 5/7/2004 12:00:00 AM | 71 | 73 | 1 | 71 |
| 5/9/2004 12:00:00 AM | 77 | 82 | 1 | 77 |
| 5/11/2004 12:00:00 AM | 64 | 64 | 1 | 64 |
| 5/13/2004 12:00:00 AM | 77 | 70 | 1 | 77 |
| 5/15/2004 12:00:00 AM | 75 | 76 | 1 | 75 |
| 5/17/2004 12:00:00 AM | 78 | 71 | 1 | 78 |
| 5/20/2004 12:00:00 AM | 118 | 83 | 2 | 59 |
| 5/22/2004 12:00:00 AM | 69 | 59 | 1 | 69 |
| 5/24/2004 12:00:00 AM | 68 | 62 | 1 | 68 |
| 5/26/2004 12:00:00 AM | 69 | 75 | 1 | 69 |
| 5/28/2004 12:00:00 AM | 62 | 71 | 1 | 62 |
| 5/30/2004 12:00:00 AM | 65 | 67 | 1 | 65 |
| 6/1/2004 12:00:00 AM | 83 | 227 | 1 | 83 |
| 6/3/2004 12:00:00 AM | 60 | 68 | 1 | 60 |
| 6/5/2004 12:00:00 AM | 57 | 85 | 1 | 57 |
| 6/7/2004 12:00:00 AM | 87 | 82 | 1 | 87 |
| 6/9/2004 12:00:00 AM | 74 | 68 | 1 | 74 |
| 6/11/2004 12:00:00 AM | 59 | 86 | 1 | 59 |
| 6/14/2004 12:00:00 AM | 123 | 102 | 2 | 61.5 |
| 6/16/2004 12:00:00 AM | 81 | 65 | 1 | 81 |
| 6/18/2004 12:00:00 AM | 86 | 72 | 1 | 86 |
| 6/20/2004 12:00:00 AM | 82 | 75 | 1 | 82 |
| 6/22/2004 12:00:00 AM | 91 | 76 | 1 | 91 |
| 6/24/2004 12:00:00 AM | 62 | 74 | 1 | 62 |
| 6/26/2004 12:00:00 AM | 72 | 79 | 1 | 72 |
| 6/28/2004 12:00:00 AM | 73 | 89 | 1 | 73 |
| 7/1/2004 12:00:00 AM | 119 | 37 | 2 | 59.5 |
| 7/8/2004 12:00:00 AM | 180 | 51 | 6 | 30 |
| 7/13/2004 12:00:00 AM | 117 | 19 | 4 | 29.25 |
| 7/17/2004 12:00:00 AM | 99 | 39 | 3 | 33 |
| 7/24/2004 12:00:00 AM | 183 | 40 | 6 | 30.5 |
| 7/30/2004 12:00:00 AM | 148 | 23 | 5 | 29.6 |
| 7/31/2004 12:00:00 AM | 0 | 40 | 0 | 1 |
| Name | Updated | Rows | Rows Sampled | Steps | Density | Average Key Length | String Index | Filter Expression | Unfiltered Rows |
|---|---|---|---|---|---|---|---|---|---|
| _WA_Sys_00000014_3C34F16F | Jul 18 2011 1:51AM | 31465 | 31465 | 198 | 0.4162014 | 8 |
|
31465 |
| All Density | Average Length | Columns |
|---|---|---|
| 0.0002107482 | 8 | SubTotal |
| Range High Key | Range Rows | Estimated Rows | Distinct Range Rows | Avg Range Rows |
|---|---|---|---|---|
| 1.3740 | 0 | 1 | 0 | 1 |
| 2.2900 | 0 | 139 | 0 | 1 |
| 3.9900 | 2 | 95 | 1 | 2 |
| 4.9900 | 0 | 576 | 0 | 1 |
| 6.2800 | 1 | 137 | 1 | 1 |
| 7.2800 | 0 | 359 | 0 | 1 |
| 7.9500 | 0 | 87 | 0 | 1 |
| 8.9900 | 0 | 186 | 0 | 1 |
| 9.9900 | 0 | 77 | 0 | 1 |
| 12.9400 | 36 | 58 | 4 | 9 |
| 13.9800 | 21 | 201 | 1 | 21 |
| 14.9800 | 14 | 207 | 2 | 7 |
| 15.2300 | 1 | 39 | 1 | 1 |
| 21.4900 | 38 | 122 | 10 | 3.8 |
| 21.9800 | 1 | 161 | 1 | 1 |
| 23.7800 | 40 | 142 | 5 | 8 |
| 23.9700 | 0 | 68 | 0 | 1 |
| 24.9900 | 65 | 231 | 4 | 16.25 |
| 25.4800 | 7 | 70 | 2 | 3.5 |
| 27.2800 | 17 | 202 | 1 | 17 |
| 27.7700 | 0 | 74 | 0 | 1 |
| 28.9800 | 23 | 59 | 5 | 4.6 |
| 28.9900 | 0 | 76 | 0 | 1 |
| 29.4800 | 3 | 78 | 1 | 3 |
| 29.9800 | 34 | 69 | 4 | 8.5 |
| 29.9900 | 0 | 155 | 0 | 1 |
| 31.2700 | 92 | 78 | 3 | 30.66667 |
| 32.2700 | 36 | 89 | 6 | 6 |
| 32.6000 | 123 | 101 | 1 | 123 |
| 33.9800 | 17 | 92 | 2 | 8.5 |
| 34.9800 | 63 | 113 | 3 | 21 |
| 34.9900 | 0 | 180 | 0 | 1 |
| 35.0000 | 0 | 124 | 0 | 1 |
| 36.2700 | 34 | 121 | 4 | 8.5 |
| 36.5900 | 1 | 89 | 1 | 1 |
| 37.2700 | 44 | 132 | 3 | 14.66667 |
| 37.2900 | 0 | 75 | 0 | 1 |
| 38.8800 | 39 | 100 | 5 | 7.8 |
| 38.9800 | 10 | 198 | 2 | 5 |
| 39.9800 | 32 | 578 | 5 | 6.4 |
| 39.9900 | 0 | 104 | 0 | 1 |
| 42.2800 | 42 | 132 | 9 | 4.666667 |
| 44.9800 | 90 | 18 | 10 | 9 |
| 47.9600 | 108 | 6 | 13 | 8.307693 |
| 48.9700 | 20 | 74 | 2 | 10 |
| 49.9700 | 63 | 148 | 6 | 10.5 |
| 49.9900 | 1 | 154 | 1 | 1 |
| 53.9900 | 56 | 154 | 10 | 5.6 |
| 54.9800 | 12 | 46 | 4 | 3 |
| 56.9700 | 27 | 149 | 5 | 5.4 |
| 58.4700 | 20 | 34 | 4 | 5 |
| 58.9800 | 10 | 116 | 3 | 3.333333 |
| 59.9800 | 51 | 86 | 10 | 5.1 |
| 60.4700 | 0 | 101 | 0 | 1 |
| 62.9800 | 61 | 53 | 9 | 6.777778 |
| 63.9700 | 18 | 110 | 2 | 9 |
| 64.4700 | 4 | 70 | 1 | 4 |
| 64.9700 | 1 | 130 | 1 | 1 |
| 67.7618 | 69 | 1 | 13 | 5.307693 |
| 68.9700 | 96 | 196 | 3 | 32 |
| 69.9700 | 15 | 238 | 3 | 5 |
| 69.9900 | 0 | 315 | 0 | 1 |
| 71.5800 | 7 | 114 | 2 | 3.5 |
| 71.9700 | 33 | 67 | 4 | 8.25 |
| 74.9800 | 87 | 193 | 12 | 7.25 |
| 75.9700 | 22 | 40 | 2 | 11 |
| 76.9700 | 16 | 25 | 6 | 2.666667 |
| 78.9800 | 110 | 186 | 9 | 12.22222 |
| 83.9700 | 108 | 28 | 22 | 4.909091 |
| 85.4800 | 47 | 60 | 7 | 6.714286 |
| 88.9800 | 99 | 26 | 13 | 7.615385 |
| 89.9700 | 33 | 51 | 8 | 4.125 |
| 91.9500 | 33 | 16 | 10 | 3.3 |
| 94.4800 | 120 | 56 | 15 | 8 |
| 98.9600 | 91 | 25 | 19 | 4.789474 |
| 103.4800 | 101 | 12 | 21 | 4.809524 |
| 114.4600 | 116 | 10 | 36 | 3.222222 |
| 119.9800 | 79 | 126 | 25 | 3.16 |
| 120.0000 | 0 | 45 | 0 | 1 |
| 123.9800 | 63 | 79 | 18 | 3.5 |
| 128.9700 | 76 | 42 | 18 | 4.222222 |
| 133.4900 | 53 | 23 | 15 | 3.533333 |
| 144.4700 | 73 | 14 | 33 | 2.212121 |
| 159.0000 | 97 | 21 | 38 | 2.552632 |
| 166.2800 | 44 | 16 | 12 | 3.666667 |
| 195.5900 | 102 | 11 | 41 | 2.487805 |
| 249.5428 | 82 | 15 | 39 | 2.102564 |
| 388.7928 | 60 | 21 | 43 | 1.395349 |
| 539.9900 | 120 | 252 | 50 | 2.4 |
| 548.9800 | 1 | 129 | 1 | 1 |
| 553.9700 | 9 | 143 | 4 | 2.25 |
| 561.4800 | 45 | 54 | 8 | 5.625 |
| 562.9600 | 20 | 52 | 2 | 10 |
| 563.7700 | 22 | 51 | 1 | 22 |
| 565.4700 | 72 | 35 | 7 | 10.28571 |
| 567.7600 | 11 | 40 | 2 | 5.5 |
| 574.9800 | 57 | 172 | 11 | 5.181818 |
| 578.4600 | 9 | 27 | 4 | 2.25 |
| 588.9600 | 59 | 106 | 15 | 3.933333 |
| 600.4600 | 120 | 47 | 17 | 7.058824 |
| 603.4900 | 3 | 40 | 3 | 1 |
| 608.9600 | 60 | 31 | 9 | 6.666667 |
| 615.9600 | 61 | 4 | 18 | 3.388889 |
| 628.9700 | 96 | 18 | 27 | 3.555556 |
| 699.0982 | 127 | 259 | 81 | 1.567901 |
| 742.3500 | 38 | 81 | 20 | 1.9 |
| 751.3400 | 22 | 76 | 5 | 4.4 |
| 769.4900 | 58 | 32 | 9 | 6.444445 |
| 777.3400 | 29 | 113 | 4 | 7.25 |
| 782.9900 | 48 | 593 | 7 | 6.857143 |
| 791.3200 | 35 | 21 | 8 | 4.375 |
| 804.4800 | 93 | 33 | 18 | 5.166667 |
| 819.4800 | 108 | 59 | 25 | 4.32 |
| 839.4800 | 87 | 61 | 31 | 2.806452 |
| 848.4700 | 21 | 38 | 11 | 1.909091 |
| 889.4700 | 56 | 14 | 34 | 1.647059 |
| 1000.4375 | 118 | 357 | 47 | 2.510638 |
| 1120.4900 | 49 | 145 | 25 | 1.96 |
| 1149.4700 | 116 | 21 | 16 | 7.25 |
| 1155.4800 | 18 | 264 | 2 | 9 |
| 1164.4700 | 14 | 29 | 7 | 2 |
| 1170.4800 | 28 | 57 | 3 | 9.333333 |
| 1174.4800 | 5 | 131 | 4 | 1.25 |
| 1184.4600 | 87 | 30 | 4 | 21.75 |
| 1205.4700 | 59 | 10 | 18 | 3.277778 |
| 1223.8400 | 61 | 48 | 10 | 6.1 |
| 1249.8400 | 69 | 100 | 22 | 3.136364 |
| 1268.8400 | 50 | 20 | 12 | 4.166667 |
| 1510.0521 | 125 | 3 | 62 | 2.016129 |
| 1700.9900 | 75 | 137 | 46 | 1.630435 |
| 1725.9800 | 75 | 25 | 9 | 8.333333 |
| 1735.9800 | 80 | 185 | 7 | 11.42857 |
| 1750.9800 | 38 | 75 | 9 | 4.222222 |
| 1754.9800 | 4 | 82 | 4 | 1 |
| 1764.9600 | 93 | 44 | 7 | 13.28571 |
| 1783.9600 | 61 | 6 | 12 | 5.083333 |
| 2049.0982 | 116 | 554 | 66 | 1.757576 |
| 2071.4196 | 6 | 521 | 5 | 1.2 |
| 2181.5625 | 17 | 758 | 15 | 1.133333 |
| 2294.9900 | 21 | 139 | 19 | 1.105263 |
| 2297.2800 | 0 | 54 | 0 | 1 |
| 2309.9700 | 34 | 63 | 3 | 11.33333 |
| 2316.9700 | 7 | 57 | 3 | 2.333333 |
| 2319.9900 | 60 | 139 | 3 | 20 |
| 2322.2800 | 0 | 68 | 0 | 1 |
| 2329.9800 | 35 | 107 | 4 | 8.75 |
| 2334.9700 | 94 | 66 | 6 | 15.66667 |
| 2341.9700 | 100 | 46 | 8 | 12.5 |
| 2344.9600 | 57 | 54 | 6 | 9.5 |
| 2351.9600 | 66 | 65 | 6 | 11 |
| 2354.9800 | 11 | 67 | 4 | 2.75 |
| 2357.2800 | 47 | 27 | 5 | 9.4 |
| 2362.2700 | 63 | 29 | 13 | 4.846154 |
| 2369.9600 | 103 | 57 | 20 | 5.15 |
| 2374.9800 | 103 | 37 | 13 | 7.923077 |
| 2376.9600 | 14 | 55 | 2 | 7 |
| 2384.0700 | 68 | 124 | 21 | 3.238095 |
| 2393.0600 | 90 | 152 | 24 | 3.75 |
| 2398.0500 | 106 | 98 | 15 | 7.066667 |
| 2407.0400 | 120 | 33 | 27 | 4.444445 |
| 2419.0600 | 109 | 313 | 29 | 3.758621 |
| 2422.5400 | 51 | 17 | 9 | 5.666667 |
| 2433.0400 | 81 | 63 | 25 | 3.24 |
| 2438.0600 | 11 | 56 | 6 | 1.833333 |
| 2443.3500 | 51 | 543 | 12 | 4.25 |
| 2451.3000 | 69 | 53 | 18 | 3.833333 |
| 2453.0400 | 37 | 39 | 4 | 9.25 |
| 2457.3300 | 7 | 60 | 7 | 1 |
| 2466.3200 | 55 | 27 | 15 | 3.666667 |
| 2475.9500 | 56 | 30 | 10 | 5.6 |
| 2478.3400 | 28 | 80 | 7 | 4 |
| 2482.2300 | 48 | 33 | 8 | 6 |
| 2492.3200 | 38 | 28 | 10 | 3.8 |
| 2511.3200 | 51 | 13 | 23 | 2.217391 |
| 2552.8200 | 127 | 1 | 39 | 3.25641 |
| 3018.9627 | 127 | 1 | 87 | 1.45977 |
| 3374.9900 | 62 | 211 | 52 | 1.192308 |
| 3399.9900 | 11 | 185 | 7 | 1.571429 |
| 3578.2700 | 28 | 1551 | 27 | 1.037037 |
| 4505.9496 | 127 | 1 | 115 | 1.104348 |
| 5275.6329 | 126 | 2 | 96 | 1.3125 |
| 8100.2201 | 255 | 1 | 239 | 1.066946 |
| 10332.0360 | 127 | 1 | 121 | 1.049587 |
| 13652.0424 | 127 | 1 | 125 | 1.016 |
| 18431.5666 | 127 | 1 | 126 | 1.007936 |
| 24624.7060 | 127 | 1 | 127 | 1 |
| 29340.1789 | 127 | 1 | 127 | 1 |
| 33052.7502 | 127 | 1 | 127 | 1 |
| 36242.7108 | 127 | 1 | 127 | 1 |
| 43759.7967 | 255 | 1 | 255 | 1 |
| 48432.5660 | 127 | 1 | 127 | 1 |
| 54073.5739 | 127 | 1 | 127 | 1 |
| 61251.8750 | 127 | 1 | 127 | 1 |
| 70333.2119 | 127 | 1 | 127 | 1 |
| 85561.8259 | 127 | 1 | 127 | 1 |
| 107725.9143 | 127 | 1 | 127 | 1 |
| 206097.4856 | 104 | 1 | 104 | 1 |
| 224356.4831 | 0 | 1 | 0 | 1 |
| Script |
|---|
| SET ANSI_NULLS ON SET QUOTED_IDENTIFIER ON SET ARITHABORT ON CREATE TABLE [Sales].[SalesOrderHeader]( [SalesOrderID] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [RevisionNumber] [tinyint] NOT NULL, [OrderDate] [datetime] NOT NULL, [DueDate] [datetime] NOT NULL, [ShipDate] [datetime] NULL, [Status] [tinyint] NOT NULL, [OnlineOrderFlag] [dbo].[Flag] NOT NULL, [SalesOrderNumber] AS (isnull(N'SO'+CONVERT([nvarchar](23),[SalesOrderID],0),N'*** ERROR ***')), [PurchaseOrderNumber] [dbo].[OrderNumber] NULL, [AccountNumber] [dbo].[AccountNumber] NULL, [CustomerID] [int] NOT NULL, [SalesPersonID] [int] NULL, [TerritoryID] [int] NULL, [BillToAddressID] [int] NOT NULL, [ShipToAddressID] [int] NOT NULL, [ShipMethodID] [int] NOT NULL, [CreditCardID] [int] NULL, [CreditCardApprovalCode] [varchar](15) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [CurrencyRateID] [int] NULL, [SubTotal] [money] NOT NULL, [TaxAmt] [money] NOT NULL, [Freight] [money] NOT NULL, [TotalDue] AS (isnull(([SubTotal]+[TaxAmt])+[Freight],(0))), [Comment] [nvarchar](128) COLLATE SQL_Latin1_General_CP1_CI_AS NULL, [rowguid] [uniqueidentifier] ROWGUIDCOL NOT NULL, [ModifiedDate] [datetime] NOT NULL ) ON [PRIMARY] EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Primary key.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'SalesOrderID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Incremental number to track changes to the sales order over time.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'RevisionNumber' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Dates the sales order was created.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'OrderDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the order is due to the customer.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'DueDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date the order was shipped to the customer.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'ShipDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Order current status. 1 = In process; 2 = Approved; 3 = Backordered; 4 = Rejected; 5 = Shipped; 6 = Cancelled' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'Status' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0 = Order placed by sales person. 1 = Order placed online by customer.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'OnlineOrderFlag' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Unique sales order identification number.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'SalesOrderNumber' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer purchase order number reference. ' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'PurchaseOrderNumber' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Financial accounting number reference.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'AccountNumber' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer identification number. Foreign key to Customer.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'CustomerID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales person who created the sales order. Foreign key to SalesPerson.BusinessEntityID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'SalesPersonID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Territory in which the sale was made. Foreign key to SalesTerritory.SalesTerritoryID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'TerritoryID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer billing address. Foreign key to Address.AddressID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'BillToAddressID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Customer shipping address. Foreign key to Address.AddressID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'ShipToAddressID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping method. Foreign key to ShipMethod.ShipMethodID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'ShipMethodID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Credit card identification number. Foreign key to CreditCard.CreditCardID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'CreditCardID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Approval code provided by the credit card company.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'CreditCardApprovalCode' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Currency exchange rate used. Foreign key to CurrencyRate.CurrencyRateID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'CurrencyRateID' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales subtotal. Computed as SUM(SalesOrderDetail.LineTotal)for the appropriate SalesOrderID.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'SubTotal' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Tax amount.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'TaxAmt' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Shipping cost.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'Freight' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Total due from customer. Computed as Subtotal + TaxAmt + Freight.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'TotalDue' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Sales representative comments.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'Comment' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ROWGUIDCOL number uniquely identifying the record. Used to support a merge replication sample.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'rowguid' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Date and time the record was last updated.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader', @level2type=N'COLUMN',@level2name=N'ModifiedDate' EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'General sales order information.' , @level0type=N'SCHEMA',@level0name=N'Sales', @level1type=N'TABLE',@level1name=N'SalesOrderHeader' |