Index Usage — ACME-203-0-113-170

Index reportsACME-203-0-113-170ACME-198-51-100-45 ACME-192-0-2-15-MSSQL25-1433 ACME-198-51-100-66 ACME-198-51-100-210 ACME-198-51-100-60 ACME-192-0-2-243 ACME-203-0-113-99 ACME-198-51-100-92 ACME-203-0-113-69 ACME-192-0-2-97 ACME-192-0-2-242 ACME-203-0-113-155

Index Usage Report — ACME-203-0-113-170

Host: 203.0.113.170

Collected: 2026-09-15T18:01:08Z

Server dashboard: http://192.0.2.15:8080/report_dba/server-metrics.html?server=ACME-203-0-113-170

Fleet inventory: http://192.0.2.15:8080/report_dba/database-inventory.html

They are zeroed by a restart, so user_seeks = 0 means "not used since that instant", not "never used". last_stats_update is a different clock again: it is set by UPDATE STATISTICS / auto-update, not by usage, so a heavily used index can still carry statistics from months ago.

Metric	Count	Meaning
indexes_total	759	every index on a CatalogHistory table
used	674	had a seek, scan or lookup
unused	37	written but never read
cold	48	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	19	nonclustered, not unique, no constraint, never read
fragmented	1	above the rebuild threshold

By database

Database	Total	Cold	Droppable	Recommend action
host-671	19	19	9	review the drop candidates above
host-763	75	9	7	review the drop candidates above
host-885	6	6	3	review the drop candidates above
host-333	8	8	0	no action — cold indexes here are constraints or clustered
host-323	113	2	0	no action — cold indexes here are constraints or clustered
TERRITORY	113	2	0	no action — cold indexes here are constraints or clustered
TERRITORY	113	2	0	no action — cold indexes here are constraints or clustered

Drop candidates (19)

Nonclustered, not unique, not enforcing a constraint, never read. Highest write cost first — that is what the index is charging for.

Index	user_updates	last_read	State	Recommend action
host-763.audit.ShipmentStaging.IX_WarehouseEntry	159848	never	UNUSED	review, then DROP
host-763.audit.tasks.IX_ShipmentEntry	32276	never	UNUSED	review, then DROP
host-763.audit.jobs.IX_MeterStaging	221	never	UNUSED	review, then DROP
host-763.audit.SalesDaily.IX_PolicySummary	221	never	UNUSED	review, then DROP
host-671.dbo.BookingMonthly.IX_PricingLog	0	never	COLD	review, then DROP
host-671.dbo.ShipmentHistory.IX_LedgerStatus	0	never	COLD	review, then DROP
host-671.dbo.ShipmentHistory.IX_SalesEntry	0	never	COLD	review, then DROP
host-671.dbo.PricingHistory.IX_LedgerHeader	0	never	COLD	review, then DROP
host-671.dbo.MeterLog.IX_BatchQueue	0	never	COLD	review, then DROP
host-671.dbo.PricingArchive.IX_BillingSnapshot	0	never	COLD	review, then DROP
host-671.dbo.BatchHistory.IX_StaffingStaging	0	never	COLD	review, then DROP
host-671.dbo.OrdersStatus.IX_PricingResult	0	never	COLD	review, then DROP
host-671.dbo.BillingMonthly.IX_SettlementEntry	0	never	COLD	review, then DROP
host-885.dbo.OrdersResult.IX_StaffingDetail	0	never	COLD	review, then DROP
host-885.dbo.OrdersResult.IX_ContractArchive	0	never	COLD	review, then DROP
host-885.dbo.OrdersResult.IX_ClaimArchive	0	never	COLD	review, then DROP
host-763.audit.RouteEntry.IX_ClaimSnapshot	0	never	COLD	review, then DROP
host-763.audit.ShiftSummary.IX_BookingHeader	0	never	COLD	review, then DROP
host-763.audit.PayrollSnapshot.IX_ReconcileHistory	0	never	COLD	review, then DROP

Fragmented (1)

Total 8.9 MB of index to rebuild. Fragmentation is measured in LIMITED mode, so record count and page density are not collected — they need a SAMPLED scan.

Index	Part	Type	Frag	Pages	Size MB	Stats updated	Action
host-671\dbo.PricingHistory.PK_PolicyDaily	1/1	CLUSTERED	66.6%	1,133	8.9	2025-10-24 14:05:34	REBUILD

All indexes (759)

Every index on the instance, including the healthy ones — the answer to "is THIS index used?" has to be here, not only the problems.

Index	id	Type	Uniq	PK	seeks	scans	lookups	updates	last_read	last_stats_update	State	Recommend action
host-333.dbo.LedgerLog.PK_OrdersDetail	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-333.dbo.CustomerLog.PK_ForecastSummary	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-10-24 13:45:54	COLD	KEEP — primary key
host-333.dbo.ClaimResult.PK_LedgerResult	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-333.dbo.ShiftDetail.PK_WarehouseMonthly	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-333.dbo.TicketHistory.PK_MeterHeader	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-333.dbo.node.PK_BookingSnapshot	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-333.dbo.ShipmentQueue.PK_LedgerSummary	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-10-24 13:45:56	COLD	KEEP — primary key
host-333.dbo.ClaimArchive.PK_PayrollSnapshot	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-671.dbo.BookingMonthly.IX_PricingLog	2	NONCLUSTERED			0	0	0	0	never	2025-10-24 13:45:54	COLD	review, then DROP
host-671.dbo.BookingMonthly.PK_CatalogArchive	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-671.dbo.ShipmentHistory.IX_LedgerStatus	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-671.dbo.ShipmentHistory.IX_SalesEntry	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-671.dbo.ShipmentHistory.PK_SalesEntry	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-671.dbo.ClaimMonthly.PK_CatalogAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-671.dbo.PricingHistory.IX_LedgerHeader	2	NONCLUSTERED			0	0	0	0	never	2026-03-11 10:53:18	COLD	review, then DROP
host-671.dbo.PricingHistory.PK_PolicyDaily	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-10-24 14:05:34	COLD	KEEP — primary key
host-671.dbo.ShiftLog.PK_PolicyStaging	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-671.dbo.MeterLog.IX_BatchQueue	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-671.dbo.MeterLog.PK_SettlementEntry	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-671.dbo.PricingArchive.IX_BillingSnapshot	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-671.dbo.PricingArchive.PK_SettlementDaily	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-671.dbo.BatchHistory.IX_StaffingStaging	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-671.dbo.BatchHistory.PK_TicketStatus	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-671.dbo.OrdersStatus.IX_PricingResult	2	NONCLUSTERED			0	0	0	0	never	2025-10-24 13:45:54	COLD	review, then DROP
host-671.dbo.OrdersStatus.PK_SupplierSnapshot	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-671.dbo.BillingMonthly.IX_SettlementEntry	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-671.dbo.BillingMonthly.PK_SettlementEntry	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-885.dbo.OrdersResult.IX_QuotaSnapshot	5	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
host-885.dbo.OrdersResult.IX_StaffingDetail	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-885.dbo.OrdersResult.IX_ContractArchive	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-885.dbo.OrdersResult.IX_ClaimArchive	4	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-885.dbo.OrdersResult.PK_StaffingStatus	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-885.dbo.ReconcileLine.PK_ClaimArchive	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
host-323.app.RosterDaily.PK_TicketAudit	1	CLUSTERED	Y	Y	227	115	0	32	2026-09-15 20:52:27	2026-09-13 01:00:18	USED	KEEP — primary key
host-323.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	226	0	0	32	2026-09-15 20:52:27	2026-09-13 01:00:18	USED	KEEP — primary key
host-323.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	226	0	0	32	2026-09-15 20:52:27	2026-09-13 01:00:18	USED	KEEP — primary key
host-323.app.SalesSummary.PK_OrdersAudit	1	CLUSTERED	Y	Y	0	32	0	32	2026-06-27 01:02:00	2026-09-13 01:00:18	USED	KEEP — primary key
host-323.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	194	32	0	32	2026-09-15 20:52:27	2026-09-13 01:00:19	USED	KEEP — primary key
host-323.app.SettlementEntry.PK_TicketQueue	1	CLUSTERED	Y	Y	0	32	0	32	2026-06-27 01:02:00	2026-09-13 01:00:19	USED	KEEP — primary key
host-323.app.BatchQueue.PK_LedgerResult	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:00	2026-09-13 01:00:19	USED	KEEP — primary key
host-323.dbo.AssetSnapshot.PK_PayrollHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-323.report.ContractSnapshot.PK_ContractResult	1	CLUSTERED	Y	Y	210	0	0	32	2026-09-15 20:51:07	2026-09-13 01:00:19	USED	KEEP — primary key
host-323.report.PolicyHistory.PK_TicketAudit	1	CLUSTERED	Y	Y	32	32	0	32	2026-06-27 01:02:20	2026-09-13 01:00:19	USED	KEEP — primary key
host-323.report.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	29	450	0	32	2026-09-15 01:30:09	2026-09-13 01:00:19	USED	KEEP — primary key
host-323.report.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	242	221	0	32	2026-09-15 20:52:27	2026-09-13 01:00:20	USED	KEEP — primary key
host-323.report.AssetLine.PK_ContractDetail	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:08	2026-09-13 01:00:20	USED	KEEP — primary key
host-323.report.TicketAudit.PK_PricingLog	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-323.report.CampaignQueue.PK_InvoiceMonthly	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	2026-09-13 01:00:20	USED	KEEP — primary key
host-323.report.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	23	121	0	32	2026-09-15 01:30:02	2026-09-13 01:00:20	USED	KEEP — primary key
host-323.report.BatchLog.PK_SalesMonthly	1	CLUSTERED	Y	Y	0	32	0	32	2026-06-27 01:02:23	2026-09-13 01:00:20	USED	KEEP — primary key
host-323.report.TicketMonthly.PK_SupplierLine	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:17	2026-09-13 01:00:20	USED	KEEP — primary key
host-323.report.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	32	111	0	32	2026-09-15 01:30:00	2026-09-13 01:00:20	USED	KEEP — primary key
host-323.report.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	143	112	0	32	2026-09-15 01:30:02	2026-09-13 01:00:20	USED	KEEP — primary key
host-323.report.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	32	112	0	32	2026-09-15 01:30:02	2026-09-13 01:00:20	USED	KEEP — primary key
host-323.report.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	15	241	0	32	2026-09-15 01:30:07	2026-09-13 01:00:21	USED	KEEP — primary key
host-323.report.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	20	235	0	32	2026-09-15 01:30:07	2026-09-13 01:00:21	USED	KEEP — primary key
host-323.report.WarehouseStatus.PK_MeterResult	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:24	2026-09-13 01:00:21	USED	KEEP — primary key
host-323.report.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	30	114	0	32	2026-09-15 01:30:07	2026-09-13 01:00:21	USED	KEEP — primary key
host-323.report.CustomerStatus.PK_SalesDetail	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:24	2026-09-13 01:00:21	USED	KEEP — primary key
host-323.report.MeterStatus.PK_OrdersLog	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:25	never	USED	KEEP — primary key
host-323.report.QuotaQueue.PK_BookingQueue	1	CLUSTERED	Y	Y	1	32	0	32	2026-06-27 01:02:25	never	USED	KEEP — primary key
host-323.report.CatalogSummary.PK_AssetLog	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:19	2026-09-13 01:00:21	USED	KEEP — primary key
host-323.report.TicketHeader.PK_PolicyResult	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:23	2026-09-13 01:00:21	USED	KEEP — primary key
host-323.report.RouteHeader.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:32	never	USED	KEEP — primary key
host-323.report.PolicyHistory.PK_CampaignQueue	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:29	never	USED	KEEP — primary key
host-323.report.ForecastHistory.PK_SupplierHistory	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:24	2026-09-13 01:00:21	USED	KEEP — primary key
host-323.report.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	16	576	0	32	2026-09-15 01:30:06	2026-09-13 01:00:21	USED	KEEP — primary key
host-323.report.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	59	1168	0	32	2026-09-15 20:52:27	2026-09-13 01:00:21	USED	KEEP — primary key
host-323.report.TicketLine.PK_CustomerEntry	1	CLUSTERED	Y	Y	0	31	0	31	2026-06-26 01:02:51	2026-09-13 01:00:22	USED	KEEP — primary key
host-323.report.AssetSnapshot.PK_SalesAudit	1	CLUSTERED	Y	Y	29	62	0	31	2026-09-15 20:51:48	2026-09-13 01:00:22	USED	KEEP — primary key
host-323.report.MeterAudit.PK_ShiftEntry	1	CLUSTERED	Y	Y	10	22	0	32	2026-06-27 01:02:25	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.PolicyEntry.PK_RouteResult	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:24	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.SalesEntry.PK_WarehouseMonthly	1	CLUSTERED	Y	Y	31	1	0	32	2026-06-27 01:02:25	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.MeterArchive.PK_LedgerStatus	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.StaffingHistory.PK_ShipmentArchive	1	CLUSTERED	Y	Y	14	18	0	32	2026-06-27 01:02:20	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.BookingQueue.PK_AssetHeader	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:03	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.ShiftDaily.PK_ClaimAudit	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:03	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.InvoiceAudit.PK_PolicyDaily	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:08	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	28	116	0	32	2026-09-15 01:30:07	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	62	362	0	32	2026-09-15 20:52:27	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	32	111	0	32	2026-09-15 01:30:00	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.ShiftMonthly.PK_PricingArchive	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:03	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.ContractMonthly.PK_CustomerDaily	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:03	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.SalesAudit.PK_BatchArchive	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:12	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.MeterSnapshot.PK_StaffingQueue	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:03	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	31	336	0	32	2026-09-15 01:30:04	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	31	224	0	32	2026-09-15 01:30:03	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	32	112	0	32	2026-09-15 01:30:02	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.ReconcileHistory.PK_StaffingDaily	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:09	2026-09-13 01:00:23	USED	KEEP — primary key
host-323.report.ClaimDetail.PK_RosterLog	1	CLUSTERED	Y	Y	28	3	0	31	2026-06-26 01:02:51	2026-09-13 01:00:24	USED	KEEP — primary key
host-323.report.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	24	227	0	31	2026-09-15 01:33:54	2026-09-13 01:00:24	USED	KEEP — primary key
host-323.report.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	9	132	0	31	2026-09-15 01:32:10	2026-09-13 01:00:25	USED	KEEP — primary key
host-323.report.InvoiceHistory.PK_StaffingQueue	1	CLUSTERED	Y	Y	31	0	0	31	2026-06-26 01:02:51	2026-09-13 01:00:25	USED	KEEP — primary key
host-323.report.BookingDetail.PK_RosterResult	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	2026-09-13 01:00:25	USED	KEEP — primary key
host-323.report.QuotaSummary.PK_RosterStatus	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	2026-09-13 01:00:25	USED	KEEP — primary key
host-323.report.WarehouseEntry.PK_ShiftDetail	1	CLUSTERED	Y	Y	6	25	0	31	2026-06-26 01:02:51	2026-09-13 01:00:25	USED	KEEP — primary key
host-323.report.RosterSummary.PK_PricingMonthly	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:04	2026-09-13 01:00:25	USED	KEEP — primary key
host-323.report.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	32	110	0	32	2026-09-15 01:34:11	2026-09-13 01:00:25	USED	KEEP — primary key
host-323.report.CampaignQueue.PK_PayrollEntry	1	CLUSTERED	Y	Y	31	0	0	31	2026-06-26 01:03:02	2026-09-13 01:00:25	USED	KEEP — primary key
host-323.report.ClaimStaging.PK_SupplierHeader	1	CLUSTERED	Y	Y	23	8	0	31	2026-06-26 01:03:00	2026-09-13 01:00:26	USED	KEEP — primary key
host-323.report.PayrollMonthly.PK_MeterSnapshot	1	CLUSTERED	Y	Y	0	31	0	31	2026-06-26 01:03:01	2026-09-13 01:00:26	USED	KEEP — primary key
host-323.report.StaffingQueue.PK_CatalogLine	1	CLUSTERED	Y	Y	31	0	0	31	2026-06-26 01:03:01	never	USED	KEEP — primary key
host-323.report.RosterEntry.PK_BookingStatus	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	2026-09-13 01:00:26	USED	KEEP — primary key
host-323.report.AssetStatus.PK_TicketEntry	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:11	2026-09-13 01:00:26	USED	KEEP — primary key
host-323.report.AssetLine.PK_ForecastSummary	1	CLUSTERED	Y	Y	31	0	0	31	2026-06-26 01:02:58	2026-09-13 01:00:26	USED	KEEP — primary key
host-323.report.TicketQueue.PK_CatalogAudit	1	CLUSTERED	Y	Y	31	0	0	31	2026-06-26 01:02:59	2026-09-13 01:00:26	USED	KEEP — primary key
host-323.report.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	6	135	0	31	2026-09-15 01:33:54	2026-09-13 01:00:27	USED	KEEP — primary key
host-323.report.CustomerLog.PK_BillingEntry	1	CLUSTERED	Y	Y	37	11	0	32	2026-09-15 20:52:27	2026-09-13 01:00:27	USED	KEEP — primary key
host-323.report.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	32	194	0	32	2026-09-15 20:52:27	2026-09-13 01:00:27	USED	KEEP — primary key
host-323.report.LedgerStaging.PK_ForecastEntry	1	CLUSTERED	Y	Y	24	8	0	32	2026-06-27 01:02:23	2026-09-13 01:00:28	USED	KEEP — primary key
host-323.report.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	144	0	0	32	2026-09-15 01:30:02	2026-09-13 01:00:27	USED	KEEP — primary key
host-323.report.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	432	311	0	128	2026-09-15 20:51:09	2026-09-13 01:00:27	USED	KEEP — primary key
host-323.report.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	36	509	0	32	2026-09-15 20:51:09	2026-09-13 01:00:28	USED	KEEP — primary key
host-323.report.ShiftSnapshot.PK_BillingResult	1	CLUSTERED	Y	Y	1	35	0	35	2026-06-30 01:01:17	2026-09-13 01:00:28	USED	KEEP — primary key
host-323.report.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	20	320	0	34	2026-09-15 20:52:27	2026-09-13 01:00:28	USED	KEEP — primary key
host-323.report.CustomerStatus.PK_PayrollLog	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:10	2026-09-13 01:00:28	USED	KEEP — primary key
host-323.report.ForecastSummary.PK_BatchQueue	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-323.report.MeterHistory.PK_LedgerQueue	1	CLUSTERED	Y	Y	52	634	0	112	2026-09-15 20:52:27	2026-09-13 01:00:28	USED	KEEP — primary key
host-323.report.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	31	176	11	62	2026-09-15 20:52:27	2026-09-13 01:00:29	USED	KEEP — primary key
host-323.report.ForecastLine.UX_ShiftQueue	2	NONCLUSTERED	Y		481	111	0	62	2026-09-15 20:52:27	2026-09-13 01:00:32	USED	keep — in use
host-323.report.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	16	110	0	110	2026-09-15 20:52:27	2026-09-13 01:00:34	USED	KEEP — primary key
host-323.report.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	31	164	0	62	2026-09-15 01:30:12	2026-09-13 01:00:35	USED	KEEP — primary key
host-323.report.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	61	298	0	62	2026-09-15 20:51:48	2026-09-13 01:00:36	USED	KEEP — primary key
host-323.report.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	29	284	0	62	2026-09-15 01:35:39	2026-09-13 01:00:36	USED	KEEP — primary key
host-323.report.SettlementHeader.PK_CatalogHistory	1	CLUSTERED	Y	Y	31	62	0	62	2026-06-26 01:06:04	never	USED	KEEP — primary key
host-323.report.ShiftStaging.PK_RosterArchive	1	CLUSTERED	Y	Y	32	391	0	62	2026-09-15 01:34:13	2026-09-13 01:00:40	USED	KEEP — primary key
host-323.report.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			49	0	0	111	2026-09-15 01:30:01	2026-09-13 01:00:42	USED	keep — in use
host-323.report.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	174	49	111	2026-09-15 01:30:07	2026-09-13 01:00:41	USED	KEEP — primary key
host-323.report.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	18	220	0	110	2026-09-15 01:35:47	2026-09-13 01:00:42	USED	KEEP — primary key
host-323.report.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	62	174	0	220	2026-09-15 20:52:27	2026-09-13 01:00:44	USED	KEEP — primary key
host-323.report.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	20	3225	0	2150	2026-09-15 01:34:12	2026-09-13 01:00:44	USED	KEEP — primary key
host-323.report.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	110	0	110	2026-09-15 01:35:21	2026-09-13 01:00:45	USED	KEEP — primary key
host-323.report.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	21	220	0	110	2026-09-15 01:35:39	2026-09-13 01:00:46	USED	KEEP — primary key
host-323.report.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	35	1765	0	222	2026-09-15 20:51:07	2026-09-13 01:00:46	USED	KEEP — primary key
host-323.report.BatchStaging.PK_CampaignHeader	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-27 01:02:20	never	USED	KEEP — primary key
host-323.report.CustomerDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	0	32	0	895	2026-06-27 01:02:23	2026-09-13 01:00:47	USED	KEEP — primary key
host-323.report.PolicyEntry.PK_QuotaMonthly	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-27 01:02:24	never	USED	KEEP — primary key
host-323.report.MeterEntry.PK_RosterStatus	1	CLUSTERED	Y	Y	0	32	0	1100	2026-06-27 01:02:24	2026-09-16 01:00:22	USED	KEEP — primary key
host-323.report.AssetLine.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-27 01:02:24	never	USED	KEEP — primary key
host-323.report.SupplierHeader.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	31	0	184	2026-06-26 01:03:02	2026-09-16 01:00:22	USED	KEEP — primary key
host-323.report.SupplierResult.PK_StaffingDaily	1	CLUSTERED	Y	Y	0	31	0	18767	2026-06-26 01:03:00	2026-09-16 01:00:26	USED	KEEP — primary key
host-323.report.BookingResult.PK_ClaimLog	1	CLUSTERED	Y	Y	0	31	0	0	2026-06-26 01:03:01	never	USED	KEEP — primary key
host-323.report.InvoiceEntry.PK_ForecastLine	1	CLUSTERED	Y	Y	0	31	0	0	2026-06-26 01:03:01	never	USED	KEEP — primary key
host-323.report.ReconcileLog.PK_CampaignQueue	1	CLUSTERED	Y	Y	0	31	0	0	2026-06-26 01:02:58	2026-09-13 01:00:54	USED	KEEP — primary key
host-323.report.OrdersArchive.PK_ContractAudit	1	CLUSTERED	Y	Y	0	31	0	0	2026-06-26 01:02:59	2026-09-13 01:00:54	USED	KEEP — primary key
host-323.report.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	64	0	3089	2026-06-27 01:02:28	2026-09-16 01:00:27	USED	KEEP — primary key
host-707.dbo.PricingEntry.PK_ClaimQueue	1	CLUSTERED	Y	Y	277	124	0	314	2026-09-16 01:00:39	2026-09-13 01:00:56	USED	KEEP — primary key
host-707.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	398	never	2026-09-16 01:00:28	UNUSED	KEEP — primary key
host-707.dbo.SalesLine.PK_ContractMonthly	1	CLUSTERED	Y	Y	7321	4	0	3260	2026-09-16 01:00:15	2026-09-13 01:00:57	USED	KEEP — primary key
host-707.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	5	0	7240	2026-05-27 17:08:46	2026-09-16 01:00:28	USED	KEEP — primary key
host-707.dbo.RosterQueue.PK_TerritoryDaily	1	CLUSTERED	Y	Y	5937	9	0	2801	2026-06-30 01:01:22	2026-09-13 01:00:58	USED	KEEP — primary key
host-707.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	0	0	5602	never	2026-09-13 01:00:58	UNUSED	KEEP — primary key
host-707.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	4640	464	0	4640	2026-09-15 20:19:27	2026-09-13 01:00:58	USED	KEEP — primary key
host-707.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	320	0	4640	2026-09-15 01:35:38	2026-09-16 01:00:28	USED	KEEP — primary key
host-707.dbo.Source.PK_QuotaDaily	1	CLUSTERED	Y	Y	0	122	0	0	2026-09-16 01:00:06	2026-09-13 01:00:58	USED	KEEP — primary key
host-888.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y	0	62	0	112	2026-06-27 01:02:01	2026-09-16 01:00:29	USED	KEEP — primary key
host-888.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y	0	64	0	1	2026-06-27 01:02:01	never	USED	KEEP — primary key
host-888.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y	0	64	0	71	2026-06-27 01:02:00	2026-09-16 01:00:29	USED	KEEP — primary key
host-888.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y	32	64	0	7	2026-06-27 01:02:00	2026-09-13 01:00:59	USED	KEEP — primary key
host-888.app.WarehouseStatus.PK_BatchDaily	1	CLUSTERED	Y	Y	32	64	0	2	2026-06-27 01:02:00	never	USED	KEEP — primary key
host-888.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y	0	96	0	5	2026-06-27 01:02:00	2026-09-13 01:00:59	USED	KEEP — primary key
host-888.app.SalesLine.PK_PricingDetail	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-13 01:00:59	UNUSED	KEEP — primary key
host-888.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-13 01:00:59	UNUSED	KEEP — primary key
host-888.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-13 01:00:59	UNUSED	KEEP — primary key
host-888.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-13 01:00:59	UNUSED	KEEP — primary key
host-888.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-13 01:00:59	UNUSED	KEEP — primary key
host-888.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-13 01:00:59	UNUSED	KEEP — primary key
host-888.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-13 01:01:00	UNUSED	KEEP — primary key
host-888.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y	0	64	0	5	2026-06-27 01:02:00	2026-09-16 01:00:29	USED	KEEP — primary key
host-888.report.WarehouseMonthly.PK_LedgerStaging	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-888.report.SalesDetail.PK_ShiftEntry	1	CLUSTERED	Y	Y	31	62	0	0	2026-06-27 01:02:20	never	USED	KEEP — primary key
host-888.report.PolicySummary.PK_ContractHistory	1	CLUSTERED	Y	Y	0	62	0	15	2026-06-27 01:02:16	never	USED	KEEP — primary key
host-888.report.BatchDaily.PK_InvoiceEntry	1	CLUSTERED	Y	Y	0	62	0	1	2026-06-27 01:02:11	never	USED	KEEP — primary key
host-888.report.ShipmentAudit.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:08	never	USED	KEEP — primary key
host-888.report.BookingResult.PK_BookingHistory	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-888.report.InvoiceQueue.PK_SettlementHistory	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-888.report.QuotaMonthly.PK_ReconcileDaily	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:19	never	USED	KEEP — primary key
host-888.report.PayrollSummary.PK_StaffingLine	1	CLUSTERED	Y	Y	31	62	0	0	2026-06-27 01:02:23	never	USED	KEEP — primary key
host-888.report.RouteHistory.PK_TicketEntry	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:17	never	USED	KEEP — primary key
host-888.report.AssetSummary.PK_QuotaArchive	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-888.report.WarehouseEntry.PK_CampaignStaging	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
host-888.report.TerritoryEntry.PK_SettlementEntry	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:07	never	USED	KEEP — primary key
host-888.report.MeterResult.PK_ContractDaily	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:25	never	USED	KEEP — primary key
host-888.report.PayrollHeader.PK_TerritoryQueue	1	CLUSTERED	Y	Y	0	62	0	28	2026-06-27 01:02:25	never	USED	KEEP — primary key
host-888.report.RosterResult.PK_AssetQueue	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:24	never	USED	KEEP — primary key
host-888.report.MeterAudit.PK_SettlementQueue	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:24	never	USED	KEEP — primary key
host-888.report.ShiftLine.PK_BatchLog	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:24	never	USED	KEEP — primary key
host-888.report.CampaignHeader.PK_MeterSummary	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:25	never	USED	KEEP — primary key
host-888.report.MeterStatus.PK_ShiftStaging	1	CLUSTERED	Y	Y	31	62	0	0	2026-06-27 01:02:25	never	USED	KEEP — primary key
host-888.report.ForecastHeader.PK_ShiftLine	1	CLUSTERED	Y	Y	0	62	0	2	2026-06-27 01:02:19	never	USED	KEEP — primary key
host-888.report.AssetDaily.PK_ShiftLine	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:23	never	USED	KEEP — primary key
host-888.report.StaffingDaily.PK_ContractStatus	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:32	never	USED	KEEP — primary key
host-888.report.ClaimResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:29	never	USED	KEEP — primary key
host-888.report.PricingDaily.PK_SettlementLog	1	CLUSTERED	Y	Y	0	62	0	1	2026-06-27 01:02:24	never	USED	KEEP — primary key
host-888.report.PolicyLog.PK_BatchQueue	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:20	never	USED	KEEP — primary key
host-888.report.MeterHistory.PK_ShiftHistory	1	CLUSTERED	Y	Y	0	62	0	29	2026-06-27 01:02:28	never	USED	KEEP — primary key
host-888.report.TerritoryLine.PK_ShipmentAudit	1	CLUSTERED	Y	Y	31	62	0	36	2026-06-26 01:02:52	2026-09-13 01:01:00	USED	KEEP — primary key
host-888.report.SettlementQueue.PK_PayrollStaging	1	CLUSTERED	Y	Y	0	62	0	33	2026-06-26 01:02:55	2026-09-13 01:01:00	USED	KEEP — primary key
host-888.report.TicketQueue.PK_CatalogStaging	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:25	never	USED	KEEP — primary key
host-888.report.OrdersEntry.PK_RosterMonthly	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:24	never	USED	KEEP — primary key
host-888.report.CampaignHistory.PK_ShipmentStatus	1	CLUSTERED	Y	Y	0	62	0	15	2026-06-27 01:02:25	never	USED	KEEP — primary key
host-888.report.TicketLine.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-888.report.BatchAudit.PK_BookingDetail	1	CLUSTERED	Y	Y	0	62	0	3303	2026-06-26 01:03:41	2026-09-13 01:01:01	USED	KEEP — primary key
host-888.report.PolicyHistory.PK_CampaignStatus	1	CLUSTERED	Y	Y	8	108	0	711	2026-06-26 01:05:53	2026-09-13 01:01:03	USED	KEEP — primary key
host-888.report.BillingEntry.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	124	0	296	2026-06-26 01:05:59	2026-09-13 01:01:03	USED	KEEP — primary key
host-888.report.BillingAudit.PK_SettlementAudit	1	CLUSTERED	Y	Y	0	124	0	290	2026-06-26 01:06:03	2026-09-13 01:01:03	USED	KEEP — primary key
host-888.report.ShipmentStaging.PK_QuotaLine	1	CLUSTERED	Y	Y	0	124	0	0	2026-06-26 01:06:04	never	USED	KEEP — primary key
host-888.report.SalesLine.PK_ReconcileDetail	1	CLUSTERED	Y	Y	31	93	0	3503	2026-06-26 01:05:38	2026-09-13 01:01:05	USED	KEEP — primary key
host-888.report.ReconcileDetail.PK_BillingSummary	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:20	never	USED	KEEP — primary key
host-888.report.PolicyEntry.PK_PayrollEntry	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
host-888.report.ReconcileStaging.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
host-888.report.ShipmentQueue.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	0	62	0	1	2026-06-27 01:02:08	never	USED	KEEP — primary key
host-888.report.MeterStatus.PK_PricingMonthly	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:29	never	USED	KEEP — primary key
host-888.report.ShiftResult.PK_SalesHistory	1	CLUSTERED	Y	Y	0	62	0	5	2026-06-27 01:02:09	never	USED	KEEP — primary key
host-888.report.Level.PK_AssetSnapshot	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:10	never	USED	KEEP — primary key
host-888.report.CampaignHeader.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
host-888.report.WarehouseHeader.PK_InvoiceDetail	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
host-888.report.QuotaEntry.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	62	0	1	2026-06-27 01:02:12	never	USED	KEEP — primary key
host-888.report.QuotaStatus.PK_StaffingMonthly	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
host-888.report.Position.PK_TerritoryDaily	1	CLUSTERED	Y	Y	0	62	0	9	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-888.report.CampaignQueue.PK_PolicyHistory	1	CLUSTERED	Y	Y	0	62	0	9	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-888.report.RouteQueue.PK_ReconcileStatus	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:05	never	USED	KEEP — primary key
host-888.report.RosterQueue.PK_SalesStatus	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:09	never	USED	KEEP — primary key
host-888.report.TicketAudit.PK_PricingHeader	1	CLUSTERED	Y	Y	0	62	0	21	2026-06-26 01:02:52	2026-09-13 01:01:07	USED	KEEP — primary key
host-888.report.CustomerLog.PK_LedgerStatus	1	CLUSTERED	Y	Y	0	62	0	31	2026-06-26 01:02:51	2026-09-13 01:01:07	USED	KEEP — primary key
host-888.report.SupplierStaging.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	32	0	31	2026-06-26 01:02:51	2026-09-13 01:01:07	USED	KEEP — primary key
host-888.report.PolicyLine.PK_StaffingStaging	1	CLUSTERED	Y	Y	0	62	0	11	2026-06-26 01:02:51	never	USED	KEEP — primary key
host-888.report.RouteStaging.PK_AssetDetail	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-888.report.CatalogSnapshot.PK_TicketHeader	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-888.report.BillingDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y	0	62	0	31	2026-06-26 01:02:52	2026-09-13 01:01:07	USED	KEEP — primary key
host-888.report.CampaignAudit.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:04	never	USED	KEEP — primary key
host-888.report.PricingArchive.PK_ShipmentHistory	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:14	never	USED	KEEP — primary key
host-888.report.SalesStatus.PK_BillingLog	1	CLUSTERED	Y	Y	0	62	0	11	2026-06-26 01:03:02	2026-09-13 01:01:07	USED	KEEP — primary key
host-888.report.SettlementQueue.PK_RouteHistory	1	CLUSTERED	Y	Y	0	62	0	15	2026-06-26 01:03:00	2026-09-13 01:01:07	USED	KEEP — primary key
host-888.report.MeterHistory.PK_ForecastLine	1	CLUSTERED	Y	Y	23	70	0	15	2026-06-26 01:03:01	2026-09-13 01:01:07	USED	KEEP — primary key
host-888.report.ShipmentAudit.PK_SalesArchive	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-26 01:03:01	never	USED	KEEP — primary key
host-888.report.ForecastAudit.PK_MeterSummary	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
host-888.report.PayrollLine.PK_ForecastResult	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:11	never	USED	KEEP — primary key
host-888.report.SupplierArchive.PK_BatchDaily	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-26 01:02:58	never	USED	KEEP — primary key
host-888.report.CustomerSnapshot.PK_BatchResult	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-26 01:02:59	never	USED	KEEP — primary key
host-888.report.CampaignResult.PK_ShiftEntry	1	CLUSTERED	Y	Y	0	62	0	82	2026-06-26 01:02:58	2026-09-13 01:01:07	USED	KEEP — primary key
host-888.report.BookingStaging.PK_RouteMonthly	1	CLUSTERED	Y	Y	0	62	0	4	2026-06-27 01:02:10	never	USED	KEEP — primary key
host-888.report.SupplierResult.PK_OrdersDaily	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:14	never	USED	KEEP — primary key
host-888.report.ShiftResult.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:23	never	USED	KEEP — primary key
host-888.report.ShiftDaily.PK_SettlementResult	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:02	never	USED	KEEP — primary key
host-888.report.PayrollHistory.PK_ClaimArchive	1	CLUSTERED	Y	Y	31	62	0	28	2026-06-27 01:02:34	never	USED	KEEP — primary key
host-888.report.CatalogSummary.PK_RouteHistory	1	CLUSTERED	Y	Y	0	62	0	28	2026-06-27 01:02:30	never	USED	KEEP — primary key
host-888.report.TicketMonthly.PK_RouteEntry	1	CLUSTERED	Y	Y	30	68	0	27	2026-06-30 01:01:17	2026-09-13 01:01:07	USED	KEEP — primary key
host-888.report.BillingQueue.PK_PolicyMonthly	1	CLUSTERED	Y	Y	0	65	0	27	2026-06-27 01:02:25	never	USED	KEEP — primary key
host-888.report.QuotaResult.PK_InvoiceResult	1	CLUSTERED	Y	Y	0	62	0	1	2026-06-27 01:02:10	never	USED	KEEP — primary key
host-763.audit.OrdersLog.PK_BookingMonthly	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-763.audit.MeterHistory.PK_TerritoryStatus	1	CLUSTERED	Y	Y	0	529	0	0	2026-09-16 01:00:08	2026-09-13 01:00:02	USED	KEEP — primary key
host-763.audit.TerritorySnapshot.PK_PayrollDaily	1	CLUSTERED	Y	Y	9715	0	0	0	2026-09-16 01:00:09	2026-09-13 01:00:02	USED	KEEP — primary key
host-763.audit.ReconcileLine.PK_TicketAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-763.audit.ReconcileLine.IX_SalesArchive	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
host-763.audit.PricingResult.PK_SupplierAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	2026-09-13 01:00:02	UNUSED	KEEP — primary key
host-763.audit.PricingResult.IX_MeterSummary	2	NONCLUSTERED	Y		6076	16368	0	0	2026-09-16 01:00:07	2026-09-13 01:00:02	USED	keep — in use
host-763.audit.CampaignSnapshot.PK_PricingEntry	1	CLUSTERED	Y	Y	0	2	0	0	2026-05-27 23:09:59	never	USED	KEEP — primary key
host-763.audit.CampaignSnapshot.IX_SalesSnapshot	2	NONCLUSTERED	Y		2	0	0	0	2026-05-27 23:09:59	never	USED	keep — in use
host-763.audit.LedgerEntry.PK_ShiftAudit	1	CLUSTERED	Y	Y	0	1	0	0	2026-05-27 23:09:41	never	USED	KEEP — primary key
host-763.audit.RouteMonthly.PK_SettlementStatus	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-763.audit.RouteMonthly.IX_SalesAudit	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
host-763.audit.RouteMonthly.PK_ForecastHeader	1	CLUSTERED	Y	Y	2	1	0	0	2026-05-27 23:09:59	never	USED	KEEP — primary key
host-763.audit.RouteMonthly.IX_SalesLog	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
host-763.audit.RouteLine.IX_BatchDaily	3	NONCLUSTERED			0	112	0	1787093	2026-09-16 00:00:00	2026-09-16 01:00:02	USED	keep — in use
host-763.audit.RouteLine.IX_QuotaQueue	2	NONCLUSTERED			112	0	0	1787093	2026-09-16 00:00:00	2026-09-16 01:00:04	USED	keep — in use
host-763.audit.RouteLine.PK_BatchResult	1	CLUSTERED	Y	Y	0	0	0	1787093	never	2026-09-16 01:00:01	UNUSED	KEEP — primary key
host-763.audit.RouteEntry.IX_ClaimSnapshot	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-763.audit.StaffingArchive.IX_ShipmentLog	2	NONCLUSTERED			112	112	0	915879	2026-09-16 00:00:00	2026-09-16 01:00:13	USED	keep — in use
host-763.audit.StaffingArchive.PK_TicketResult	1	CLUSTERED	Y	Y	1787003	0	0	915879	2026-09-16 01:00:43	2026-09-16 01:00:09	USED	KEEP — primary key
host-763.audit.ShiftSummary.IX_MeterResult	2	NONCLUSTERED			1	0	0	0	2026-05-28 09:59:18	never	USED	keep — in use
host-763.audit.ShiftSummary.IX_BookingHeader	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-763.audit.SupplierLog.IX_CatalogEntry	2	NONCLUSTERED			115	0	0	110764	2026-09-16 00:00:00	2026-09-16 01:00:15	USED	keep — in use
host-763.audit.SupplierLog.PK_ShiftLine	1	CLUSTERED	Y	Y	0	0	3	110764	2026-05-28 09:58:23	2026-09-16 01:00:14	USED	KEEP — primary key
host-763.audit.PricingAudit.PK_RouteSummary	1	CLUSTERED	Y	Y	110652	110654	0	2068	2026-09-16 01:00:43	2026-09-13 01:00:10	USED	KEEP — primary key
host-763.audit.BatchSnapshot.PK_StaffingSnapshot	1	CLUSTERED	Y	Y	0	4	0	112	2026-05-28 09:58:07	never	USED	KEEP — primary key
host-763.audit.BatchSnapshot.IX_BatchSnapshot	2	NONCLUSTERED			111	1	0	112	2026-09-16 00:00:00	never	USED	keep — in use
host-763.audit.MeterDaily.PK_ForecastStatus	1	CLUSTERED	Y	Y	0	112	0	112	2026-09-16 00:00:00	never	USED	KEEP — primary key
host-763.audit.StaffingSummary.PK_InvoiceStaging	1	CLUSTERED	Y	Y	0	619	0	112	2026-09-16 01:00:09	never	USED	KEEP — primary key
host-763.audit.CampaignDaily.IX_LedgerMonthly	2	NONCLUSTERED			2268	0	0	3151	2026-09-16 01:00:08	2026-09-16 01:00:16	USED	keep — in use
host-763.audit.CampaignDaily.IX_ClaimQueue	3	NONCLUSTERED			6456	0	0	3151	2026-09-16 01:00:08	2026-09-16 01:00:16	USED	keep — in use
host-763.audit.CampaignDaily.PK_PricingLine	1	CLUSTERED	Y	Y	3038	1	7094	8217	2026-09-16 01:00:08	2026-09-16 01:00:15	USED	KEEP — primary key
host-763.audit.WarehouseMonthly.IX_CampaignLine	2	NONCLUSTERED			111	1	0	112	2026-09-16 00:00:00	never	USED	keep — in use
host-763.audit.WarehouseMonthly.PK_TerritoryStatus	1	CLUSTERED	Y	Y	0	1014	0	112	2026-09-16 01:00:09	never	USED	KEEP — primary key
host-763.audit.executions.PK_TerritoryLog	1	CLUSTERED	Y	Y	116282	238	0	619	2026-09-16 01:00:45	2026-09-16 01:00:18	USED	KEEP — primary key
host-763.audit.InvoiceLine.PK_PayrollAudit	1	CLUSTERED	Y	Y	0	113	0	113	2026-09-16 00:00:00	never	USED	KEEP — primary key
host-763.audit.SettlementEntry.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	3148	5376	0	2026-09-16 01:00:08	never	USED	KEEP — primary key
host-763.audit.SettlementEntry.IX_PricingHistory	2	NONCLUSTERED	Y		5376	0	0	0	2026-09-16 01:00:08	never	USED	keep — in use
host-763.audit.AssetSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	20	8	9	0	2026-05-28 10:40:11	2026-09-13 01:00:13	USED	KEEP — primary key
host-763.audit.AssetSummary.IX_SalesLog	2	NONCLUSTERED	Y		1564	2	0	0	2026-09-16 01:00:08	2026-09-13 01:00:13	USED	keep — in use
host-763.audit.QuotaLog.PK_ClaimStatus	1	CLUSTERED	Y	Y	221	221	0	221	2026-09-15 15:35:04	never	USED	KEEP — primary key
host-763.audit.SalesQueue.PK_CustomerStaging	1	CLUSTERED	Y	Y	0	0	0	221	never	never	UNUSED	KEEP — primary key
host-763.audit.jobs.PK_AssetSummary	1	CLUSTERED	Y	Y	0	442	0	221	2026-09-15 15:35:04	never	USED	KEEP — primary key
host-763.audit.jobs.IX_MeterStaging	2	NONCLUSTERED			0	0	0	221	never	never	UNUSED	review, then DROP
host-763.audit.BillingLine.PK_StaffingStatus	1	CLUSTERED	Y	Y	442	0	0	221	2026-09-15 15:35:04	never	USED	KEEP — primary key
host-763.audit.ContractDetail.PK_ForecastLog	1	CLUSTERED	Y	Y	159848	0	0	159848	2026-09-16 01:00:24	2026-09-13 01:00:13	USED	KEEP — primary key
host-763.audit.AssetSnapshot.PK_CustomerSnapshot	1	CLUSTERED	Y	Y	322003	0	0	320424	2026-09-16 01:00:58	2026-09-13 01:00:13	USED	KEEP — primary key
host-763.audit.RouteAudit.IX_PayrollLog	2	NONCLUSTERED			1014	113	0	16481	2026-09-16 01:00:08	2026-09-13 01:00:13	USED	keep — in use
host-763.audit.RouteAudit.PK_BatchLine	1	CLUSTERED	Y	Y	0	2547	1014	16487	2026-09-16 01:00:08	2026-09-13 01:00:13	USED	KEEP — primary key
host-763.audit.BatchDetail.PK_BillingEntry	1	CLUSTERED	Y	Y	35969	351	0	130	2026-09-16 01:00:08	2026-09-13 01:00:14	USED	KEEP — primary key
host-763.audit.BatchLog.IX_ShiftLog	2	NONCLUSTERED			155	0	0	915880	2026-09-16 00:00:00	2026-09-16 01:00:19	USED	keep — in use
host-763.audit.BatchLog.PK_MeterStatus	1	CLUSTERED	Y	Y	915767	0	42	915880	2026-09-16 01:00:43	2026-09-16 01:00:18	USED	KEEP — primary key
host-763.audit.PayrollSnapshot.IX_ReconcileHistory	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-763.audit.PayrollSnapshot.IX_SettlementAudit	2	NONCLUSTERED			3	0	0	0	2026-05-28 10:00:59	never	USED	keep — in use
host-763.audit.SalesEntry.IX_SupplierQueue	2	NONCLUSTERED			1563	223	0	619	2026-09-16 01:00:45	2026-09-16 01:00:21	USED	keep — in use
host-763.audit.SalesEntry.PK_SupplierAudit	1	CLUSTERED	Y	Y	0	10	0	619	2026-05-28 11:00:16	2026-09-16 01:00:21	USED	KEEP — primary key
host-763.audit.InvoiceSnapshot.PK_PayrollArchive	1	CLUSTERED	Y	Y	0	269	17623	625	2026-09-16 01:00:45	2026-09-16 01:00:21	USED	KEEP — primary key
host-763.audit.InvoiceSnapshot.IX_ShipmentLog	2	NONCLUSTERED	Y		17623	112	0	625	2026-09-16 01:00:45	2026-09-16 01:00:21	USED	keep — in use
host-763.audit.BillingResult.IX_RouteLine	2	NONCLUSTERED			0	32166	0	1358	2026-09-16 00:56:26	2026-09-16 01:00:21	USED	keep — in use
host-763.audit.BillingResult.PK_RosterQueue	1	CLUSTERED	Y	Y	3698677	161	0	101311	2026-09-16 01:00:45	2026-09-16 01:00:21	USED	KEEP — primary key
host-763.audit.BatchLog.IX_LedgerDetail	2	NONCLUSTERED			508	234	0	129	2026-09-16 01:00:07	2026-09-13 01:00:17	USED	keep — in use
host-763.audit.BatchLog.PK_SupplierArchive	1	CLUSTERED	Y	Y	0	2	4	129	2026-05-28 10:40:11	2026-09-13 01:00:17	USED	KEEP — primary key
host-763.audit.TicketHeader.PK_ShipmentHistory	1	CLUSTERED	Y	Y	0	5374	0	0	2026-09-16 01:00:08	2026-09-13 01:00:17	USED	KEEP — primary key
host-763.audit.TicketHeader.IX_ShiftAudit	2	NONCLUSTERED	Y		5374	0	0	0	2026-09-16 01:00:08	2026-09-13 01:00:17	USED	keep — in use
host-763.audit.SettlementAudit.IX_CampaignHistory	3	NONCLUSTERED			1032	113	0	6	2026-09-16 01:00:08	2026-09-13 01:00:17	USED	keep — in use
host-763.audit.SettlementAudit.PK_CustomerLine	1	CLUSTERED	Y	Y	25856	19	11	6	2026-09-16 01:00:08	2026-09-13 01:00:17	USED	KEEP — primary key
host-763.audit.SettlementAudit.IX_CatalogLine	2	NONCLUSTERED	Y		11	0	0	0	2026-05-28 10:40:11	2026-09-13 01:00:17	USED	keep — in use
host-763.audit.tasks.PK_LedgerArchive	1	CLUSTERED	Y	Y	0	32276	0	32276	2026-09-16 00:56:26	never	USED	KEEP — primary key
host-763.audit.tasks.IX_SettlementEntry	2	NONCLUSTERED			0	442	0	32276	2026-09-15 15:35:04	never	USED	keep — in use
host-763.audit.tasks.IX_ShipmentEntry	3	NONCLUSTERED			0	0	0	32276	never	never	UNUSED	review, then DROP
host-763.audit.SalesDaily.PK_CatalogHistory	1	CLUSTERED	Y	Y	0	0	0	221	never	never	UNUSED	KEEP — primary key
host-763.audit.SalesDaily.IX_PolicySummary	2	NONCLUSTERED			0	0	0	221	never	never	UNUSED	review, then DROP
host-763.audit.QuotaLog.PK_RosterResult	1	CLUSTERED	Y	Y	0	112	0	112	2026-09-16 00:00:00	never	USED	KEEP — primary key
host-763.audit.ShipmentStaging.IX_WarehouseEntry	2	NONCLUSTERED			0	0	0	159848	never	never	UNUSED	review, then DROP
host-763.audit.ReconcileDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	479953	111	0	160257	2026-09-16 01:00:24	2026-09-13 01:00:17	USED	KEEP — primary key
TERRITORY.app.RosterDaily.PK_TicketAudit	1	CLUSTERED	Y	Y	51	124	0	20	2026-09-15 01:30:06	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	55	3	0	19	2026-09-12 11:19:00	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	58	0	0	19	2026-09-12 11:19:00	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.app.SalesSummary.PK_OrdersAudit	1	CLUSTERED	Y	Y	0	19	0	19	2026-06-13 05:28:43	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	39	19	0	19	2026-09-12 11:19:00	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.app.SettlementEntry.PK_TicketQueue	1	CLUSTERED	Y	Y	0	19	0	19	2026-06-13 05:28:43	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.app.BatchQueue.PK_LedgerResult	1	CLUSTERED	Y	Y	19	0	0	19	2026-06-13 05:28:43	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.dbo.AssetSnapshot.PK_PayrollHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
TERRITORY.report.ContractSnapshot.PK_ContractResult	1	CLUSTERED	Y	Y	54	0	0	17	2026-09-12 11:14:08	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.report.PolicyHistory.PK_TicketAudit	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:28:59	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.report.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	23	456	0	17	2026-09-15 01:30:08	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.report.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	60	224	0	17	2026-09-15 01:41:23	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ContractDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.report.TicketAudit.PK_PricingLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:54	2026-09-13 01:01:50	USED	KEEP — primary key
TERRITORY.report.CampaignQueue.PK_InvoiceMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-09-13 01:01:51	USED	KEEP — primary key
TERRITORY.report.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	10	123	0	17	2026-09-15 01:30:02	2026-09-13 01:01:51	USED	KEEP — primary key
TERRITORY.report.BatchLog.PK_SalesMonthly	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:29:03	2026-09-13 01:01:51	USED	KEEP — primary key
TERRITORY.report.TicketMonthly.PK_SupplierLine	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-09-13 01:01:51	USED	KEEP — primary key
TERRITORY.report.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	17	113	0	17	2026-09-15 01:30:00	2026-09-13 01:01:51	USED	KEEP — primary key
TERRITORY.report.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	130	116	0	17	2026-09-15 01:30:02	2026-09-13 01:01:51	USED	KEEP — primary key
TERRITORY.report.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	17	116	0	17	2026-09-15 01:30:02	2026-09-13 01:01:51	USED	KEEP — primary key
TERRITORY.report.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	15	234	0	17	2026-09-15 01:30:06	2026-09-13 01:01:51	USED	KEEP — primary key
TERRITORY.report.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	14	231	0	17	2026-09-15 01:30:06	2026-09-13 01:01:52	USED	KEEP — primary key
TERRITORY.report.WarehouseStatus.PK_MeterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:07	2026-09-13 01:01:52	USED	KEEP — primary key
TERRITORY.report.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	10	123	0	17	2026-09-15 01:30:06	2026-09-13 01:01:52	USED	KEEP — primary key
TERRITORY.report.CustomerStatus.PK_SalesDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:13	2026-09-13 01:01:52	USED	KEEP — primary key
TERRITORY.report.MeterStatus.PK_OrdersLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:59	2026-09-13 01:01:52	USED	KEEP — primary key
TERRITORY.report.QuotaQueue.PK_BookingQueue	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:28:58	2026-09-13 01:01:52	USED	KEEP — primary key
TERRITORY.report.CatalogSummary.PK_AssetLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:12	2026-09-13 01:01:52	USED	KEEP — primary key
TERRITORY.report.TicketHeader.PK_PolicyResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:13	2026-09-13 01:01:52	USED	KEEP — primary key
TERRITORY.report.RouteHeader.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:12	2026-09-13 01:01:53	USED	KEEP — primary key
TERRITORY.report.PolicyHistory.PK_CampaignQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:59	2026-09-13 01:01:53	USED	KEEP — primary key
TERRITORY.report.ForecastHistory.PK_SupplierHistory	1	CLUSTERED	Y	Y	16	1	0	17	2026-06-13 05:29:08	2026-09-13 01:01:53	USED	KEEP — primary key
TERRITORY.report.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	10	587	0	17	2026-09-15 01:30:05	2026-09-13 01:01:54	USED	KEEP — primary key
TERRITORY.report.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	134	945	0	17	2026-09-15 01:43:48	2026-09-13 01:01:54	USED	KEEP — primary key
TERRITORY.report.TicketLine.PK_CustomerEntry	1	CLUSTERED	Y	Y	1	17	0	17	2026-06-13 05:30:17	2026-09-13 01:01:55	USED	KEEP — primary key
TERRITORY.report.AssetSnapshot.PK_SalesAudit	1	CLUSTERED	Y	Y	16	11	0	17	2026-09-12 11:17:00	2026-09-13 01:01:55	USED	KEEP — primary key
TERRITORY.report.MeterAudit.PK_ShiftEntry	1	CLUSTERED	Y	Y	14	3	0	17	2026-06-13 05:28:59	2026-09-13 01:01:56	USED	KEEP — primary key
TERRITORY.report.PolicyEntry.PK_RouteResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:09	2026-09-13 01:01:56	USED	KEEP — primary key
TERRITORY.report.SalesEntry.PK_WarehouseMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:08	2026-09-13 01:01:56	USED	KEEP — primary key
TERRITORY.report.MeterArchive.PK_LedgerStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-09-13 01:01:56	USED	KEEP — primary key
TERRITORY.report.StaffingHistory.PK_ShipmentArchive	1	CLUSTERED	Y	Y	9	8	0	17	2026-06-13 05:29:03	2026-09-13 01:01:56	USED	KEEP — primary key
TERRITORY.report.BookingQueue.PK_AssetHeader	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-13 01:01:56	USED	KEEP — primary key
TERRITORY.report.ShiftDaily.PK_ClaimAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-13 01:01:56	USED	KEEP — primary key
TERRITORY.report.InvoiceAudit.PK_PolicyDaily	1	CLUSTERED	Y	Y	16	1	0	17	2026-06-13 05:28:50	2026-09-13 01:01:56	USED	KEEP — primary key
TERRITORY.report.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	10	123	0	17	2026-09-15 01:30:06	2026-09-13 01:01:56	USED	KEEP — primary key
TERRITORY.report.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	20	342	0	17	2026-09-15 01:36:45	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	17	113	0	17	2026-09-15 01:30:00	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.ShiftMonthly.PK_PricingArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.ContractMonthly.PK_CustomerDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.SalesAudit.PK_BatchArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.MeterSnapshot.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	24	338	0	17	2026-09-15 01:30:03	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	22	224	0	17	2026-09-15 01:30:03	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	17	116	0	17	2026-09-15 01:30:02	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.ReconcileHistory.PK_StaffingDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.ClaimDetail.PK_RosterLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:18	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	17	224	0	17	2026-09-15 01:41:21	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	17	113	0	18	2026-09-15 01:36:45	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.InvoiceHistory.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:18	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.BookingDetail.PK_RosterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:53	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.QuotaSummary.PK_RosterStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.WarehouseEntry.PK_ShiftDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:18	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.RosterSummary.PK_PricingMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	17	112	0	17	2026-09-15 01:41:22	2026-09-13 01:01:57	USED	KEEP — primary key
TERRITORY.report.CampaignQueue.PK_PayrollEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:21	2026-09-13 01:01:58	USED	KEEP — primary key
TERRITORY.report.ClaimStaging.PK_SupplierHeader	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:20	2026-09-13 01:01:59	USED	KEEP — primary key
TERRITORY.report.PayrollMonthly.PK_MeterSnapshot	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:30:21	2026-09-13 01:01:59	USED	KEEP — primary key
TERRITORY.report.StaffingQueue.PK_CatalogLine	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:21	never	USED	KEEP — primary key
TERRITORY.report.RosterEntry.PK_BookingStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-09-13 01:01:59	USED	KEEP — primary key
TERRITORY.report.AssetStatus.PK_TicketEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:54	2026-09-13 01:01:59	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ForecastSummary	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:21	2026-09-13 01:02:00	USED	KEEP — primary key
TERRITORY.report.TicketQueue.PK_CatalogAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:20	2026-09-13 01:02:00	USED	KEEP — primary key
TERRITORY.report.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	17	112	0	17	2026-09-15 01:41:21	2026-09-13 01:02:01	USED	KEEP — primary key
TERRITORY.report.CustomerLog.PK_BillingEntry	1	CLUSTERED	Y	Y	17	2	0	17	2026-09-12 11:19:00	2026-09-13 01:02:01	USED	KEEP — primary key
TERRITORY.report.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	17	39	0	17	2026-09-12 11:19:00	2026-09-13 01:02:01	USED	KEEP — primary key
TERRITORY.report.LedgerStaging.PK_ForecastEntry	1	CLUSTERED	Y	Y	13	4	0	17	2026-06-13 05:29:07	2026-09-13 01:02:04	USED	KEEP — primary key
TERRITORY.report.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	133	0	0	17	2026-09-15 01:30:02	2026-09-13 01:02:01	USED	KEEP — primary key
TERRITORY.report.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	312	86	0	68	2026-09-15 01:30:08	2026-09-13 01:02:02	USED	KEEP — primary key
TERRITORY.report.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	40	365	0	17	2026-09-15 01:30:03	2026-09-13 01:02:02	USED	KEEP — primary key
TERRITORY.report.ShiftSnapshot.PK_BillingResult	1	CLUSTERED	Y	Y	1	17	0	17	2026-06-13 05:29:08	2026-09-13 01:02:03	USED	KEEP — primary key
TERRITORY.report.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	12	157	0	17	2026-09-15 01:30:00	2026-09-13 01:02:03	USED	KEEP — primary key
TERRITORY.report.CustomerStatus.PK_PayrollLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:54	2026-09-13 01:02:03	USED	KEEP — primary key
TERRITORY.report.ForecastSummary.PK_BatchQueue	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
TERRITORY.report.MeterHistory.PK_LedgerQueue	1	CLUSTERED	Y	Y	39	289	0	113	2026-09-15 01:46:05	2026-09-13 01:02:04	USED	KEEP — primary key
TERRITORY.report.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	114	145	2	34	2026-09-15 01:46:05	2026-09-13 01:02:25	USED	KEEP — primary key
TERRITORY.report.ForecastLine.UX_ShiftQueue	10	NONCLUSTERED	Y		358	113	0	34	2026-09-15 01:41:23	2026-09-13 01:02:40	USED	keep — in use
TERRITORY.report.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	2	112	0	112	2026-09-15 01:39:48	2026-09-13 01:02:43	USED	KEEP — primary key
TERRITORY.report.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	16	129	0	32	2026-09-15 01:30:09	2026-09-13 01:02:43	USED	KEEP — primary key
TERRITORY.report.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	22	254	0	32	2026-09-15 01:30:37	2026-09-13 01:02:44	USED	KEEP — primary key
TERRITORY.report.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	29	243	0	32	2026-09-15 01:46:05	2026-09-13 01:02:44	USED	KEEP — primary key
TERRITORY.report.SettlementHeader.PK_CatalogHistory	1	CLUSTERED	Y	Y	29	19	0	32	2026-06-12 03:23:02	2026-09-13 01:02:44	USED	KEEP — primary key
TERRITORY.report.ShiftStaging.PK_RosterArchive	1	CLUSTERED	Y	Y	19	365	0	36	2026-09-15 01:41:23	2026-09-13 01:02:52	USED	KEEP — primary key
TERRITORY.report.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			67	0	0	112	2026-09-15 01:30:02	2026-09-13 01:02:54	USED	keep — in use
TERRITORY.report.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	161	67	112	2026-09-15 01:30:06	2026-09-13 01:02:54	USED	KEEP — primary key
TERRITORY.report.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	0	224	0	112	2026-09-15 01:46:07	2026-09-13 01:02:55	USED	KEEP — primary key
TERRITORY.report.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	83	143	0	224	2026-09-15 01:41:22	2026-09-13 01:02:55	USED	KEEP — primary key
TERRITORY.report.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	3	2016	0	1344	2026-09-15 01:41:23	2026-09-13 01:02:55	USED	KEEP — primary key
TERRITORY.report.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	112	0	112	2026-09-15 01:46:01	2026-09-13 01:02:55	USED	KEEP — primary key
TERRITORY.report.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	0	224	0	112	2026-09-15 01:46:05	2026-09-13 01:02:56	USED	KEEP — primary key
TERRITORY.report.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	38	789	0	226	2026-09-15 01:46:05	2026-09-13 01:02:56	USED	KEEP — primary key
TERRITORY.report.BatchStaging.PK_CampaignHeader	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:28:59	2026-09-13 01:02:56	USED	KEEP — primary key
TERRITORY.report.CustomerDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:29:03	2026-09-13 01:02:56	USED	KEEP — primary key
TERRITORY.report.PolicyEntry.PK_QuotaMonthly	1	CLUSTERED	Y	Y	0	17	0	10	2026-06-13 05:29:07	2026-09-13 01:02:56	USED	KEEP — primary key
TERRITORY.report.MeterEntry.PK_RosterStatus	1	CLUSTERED	Y	Y	0	17	0	30	2026-06-13 05:29:13	2026-09-13 01:02:56	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	17	0	11	2026-06-13 05:29:09	2026-09-13 01:02:57	USED	KEEP — primary key
TERRITORY.report.SupplierHeader.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	17	0	151	2026-06-13 05:30:21	2026-09-16 01:00:59	USED	KEEP — primary key
TERRITORY.report.SupplierResult.PK_StaffingDaily	1	CLUSTERED	Y	Y	0	17	0	2695	2026-06-13 05:30:20	2026-09-16 01:01:04	USED	KEEP — primary key
TERRITORY.report.BookingResult.PK_ClaimLog	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:30:21	never	USED	KEEP — primary key
TERRITORY.report.InvoiceEntry.PK_ForecastLine	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:30:21	never	USED	KEEP — primary key
TERRITORY.report.ReconcileLog.PK_CampaignQueue	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:30:21	2026-09-13 01:03:04	USED	KEEP — primary key
TERRITORY.report.OrdersArchive.PK_ContractAudit	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:30:20	2026-09-13 01:03:06	USED	KEEP — primary key
TERRITORY.report.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	34	0	111552	2026-06-13 05:29:33	2026-09-16 01:01:07	USED	KEEP — primary key
CUSTOMER.dbo.PricingEntry.PK_ClaimQueue	1	CLUSTERED	Y	Y	21	27	0	41	2026-06-13 07:23:43	2026-09-13 01:03:09	USED	KEEP — primary key
CUSTOMER.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	43	never	2026-09-13 01:03:09	UNUSED	KEEP — primary key
CUSTOMER.dbo.SalesLine.PK_ContractMonthly	1	CLUSTERED	Y	Y	3572	2	0	1612	2026-06-13 05:28:37	2026-09-13 01:03:09	USED	KEEP — primary key
CUSTOMER.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	0	0	3224	never	2026-09-13 01:03:09	UNUSED	KEEP — primary key
CUSTOMER.dbo.RosterQueue.PK_TerritoryDaily	1	CLUSTERED	Y	Y	3258	1	0	1509	2026-06-13 07:23:41	2026-09-13 01:03:09	USED	KEEP — primary key
CUSTOMER.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	0	0	3019	never	2026-09-13 01:03:09	UNUSED	KEEP — primary key
CUSTOMER.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	13337	1334	0	13337	2026-09-15 23:27:05	2026-09-13 01:03:09	USED	KEEP — primary key
CUSTOMER.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	10	0	13337	2026-07-27 11:26:57	2026-09-16 01:01:08	USED	KEEP — primary key
CUSTOMER.dbo.Source.PK_QuotaDaily	1	CLUSTERED	Y	Y	0	22	0	0	2026-06-13 03:00:02	2026-09-13 01:03:10	USED	KEEP — primary key
CAMPAIGN.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y	0	32	0	36	2026-06-13 05:28:44	never	USED	KEEP — primary key
CAMPAIGN.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y	0	38	0	3	2026-06-13 05:28:43	never	USED	KEEP — primary key
CAMPAIGN.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 05:28:42	never	USED	KEEP — primary key
CAMPAIGN.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y	6	51	0	6	2026-06-13 05:28:43	never	USED	KEEP — primary key
CAMPAIGN.app.WarehouseStatus.PK_BatchDaily	1	CLUSTERED	Y	Y	19	38	0	6	2026-06-13 05:28:43	never	USED	KEEP — primary key
CAMPAIGN.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y	0	57	0	7	2026-06-13 05:28:43	never	USED	KEEP — primary key
CAMPAIGN.app.SalesLine.PK_PricingDetail	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-13 01:03:12	UNUSED	KEEP — primary key
CAMPAIGN.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-13 01:03:12	UNUSED	KEEP — primary key
CAMPAIGN.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-13 01:03:12	UNUSED	KEEP — primary key
CAMPAIGN.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-13 01:03:12	UNUSED	KEEP — primary key
CAMPAIGN.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-13 01:03:12	UNUSED	KEEP — primary key
CAMPAIGN.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-13 01:03:12	UNUSED	KEEP — primary key
CAMPAIGN.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-13 01:03:12	UNUSED	KEEP — primary key
CAMPAIGN.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y	0	38	0	1	2026-06-13 05:28:43	never	USED	KEEP — primary key
CAMPAIGN.report.WarehouseMonthly.PK_LedgerStaging	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.report.SalesDetail.PK_ShiftEntry	1	CLUSTERED	Y	Y	0	48	0	0	2026-06-13 05:28:59	never	USED	KEEP — primary key
CAMPAIGN.report.PolicySummary.PK_ContractHistory	1	CLUSTERED	Y	Y	0	32	0	6	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.report.BatchDaily.PK_InvoiceEntry	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:54	never	USED	KEEP — primary key
CAMPAIGN.report.ShipmentAudit.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.report.BookingResult.PK_BookingHistory	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:54	never	USED	KEEP — primary key
CAMPAIGN.report.InvoiceQueue.PK_SettlementHistory	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.report.QuotaMonthly.PK_ReconcileDaily	1	CLUSTERED	Y	Y	0	32	0	76	2026-06-13 05:29:10	never	USED	KEEP — primary key
CAMPAIGN.report.PayrollSummary.PK_StaffingLine	1	CLUSTERED	Y	Y	0	48	0	0	2026-06-13 05:29:03	never	USED	KEEP — primary key
CAMPAIGN.report.RouteHistory.PK_TicketEntry	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:56	never	USED	KEEP — primary key
CAMPAIGN.report.AssetSummary.PK_QuotaArchive	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:52	never	USED	KEEP — primary key
CAMPAIGN.report.WarehouseEntry.PK_CampaignStaging	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.report.TerritoryEntry.PK_SettlementEntry	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.report.MeterResult.PK_ContractDaily	1	CLUSTERED	Y	Y	0	32	0	32	2026-06-13 05:29:09	never	USED	KEEP — primary key
CAMPAIGN.report.PayrollHeader.PK_TerritoryQueue	1	CLUSTERED	Y	Y	0	32	0	39	2026-06-13 05:29:05	never	USED	KEEP — primary key
CAMPAIGN.report.RosterResult.PK_AssetQueue	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:29:07	never	USED	KEEP — primary key
CAMPAIGN.report.MeterAudit.PK_SettlementQueue	1	CLUSTERED	Y	Y	0	32	0	19	2026-06-13 05:29:08	never	USED	KEEP — primary key
CAMPAIGN.report.ShiftLine.PK_BatchLog	1	CLUSTERED	Y	Y	0	32	0	1	2026-06-13 05:29:13	never	USED	KEEP — primary key
CAMPAIGN.report.CampaignHeader.PK_MeterSummary	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:59	never	USED	KEEP — primary key
CAMPAIGN.report.MeterStatus.PK_ShiftStaging	1	CLUSTERED	Y	Y	0	48	0	0	2026-06-13 05:28:58	never	USED	KEEP — primary key
CAMPAIGN.report.ForecastHeader.PK_ShiftLine	1	CLUSTERED	Y	Y	0	32	0	1	2026-06-13 05:29:12	never	USED	KEEP — primary key
CAMPAIGN.report.AssetDaily.PK_ShiftLine	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:29:13	never	USED	KEEP — primary key
CAMPAIGN.report.StaffingDaily.PK_ContractStatus	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:29:12	never	USED	KEEP — primary key
CAMPAIGN.report.ClaimResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:59	never	USED	KEEP — primary key
CAMPAIGN.report.PricingDaily.PK_SettlementLog	1	CLUSTERED	Y	Y	0	32	0	3	2026-06-13 05:29:08	never	USED	KEEP — primary key
CAMPAIGN.report.PolicyLog.PK_BatchQueue	1	CLUSTERED	Y	Y	0	32	0	20	2026-06-13 05:29:08	never	USED	KEEP — primary key
CAMPAIGN.report.MeterHistory.PK_ShiftHistory	1	CLUSTERED	Y	Y	0	32	0	67	2026-06-13 05:28:59	never	USED	KEEP — primary key
CAMPAIGN.report.TerritoryLine.PK_ShipmentAudit	1	CLUSTERED	Y	Y	16	32	0	12	2026-06-13 05:30:17	never	USED	KEEP — primary key
CAMPAIGN.report.SettlementQueue.PK_PayrollStaging	1	CLUSTERED	Y	Y	0	32	0	11	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.report.TicketQueue.PK_CatalogStaging	1	CLUSTERED	Y	Y	0	32	0	13	2026-06-13 05:28:59	never	USED	KEEP — primary key
CAMPAIGN.report.OrdersEntry.PK_RosterMonthly	1	CLUSTERED	Y	Y	0	32	0	1	2026-06-13 05:29:09	never	USED	KEEP — primary key
CAMPAIGN.report.CampaignHistory.PK_ShipmentStatus	1	CLUSTERED	Y	Y	0	32	0	3	2026-06-13 05:29:08	never	USED	KEEP — primary key
CAMPAIGN.report.TicketLine.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.report.BatchAudit.PK_BookingDetail	1	CLUSTERED	Y	Y	0	32	0	8063	2026-06-13 05:41:23	never	USED	KEEP — primary key
CAMPAIGN.report.PolicyHistory.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	49	0	16	2026-06-12 03:21:18	2026-09-13 01:03:13	USED	KEEP — primary key
CAMPAIGN.report.BillingEntry.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	63	0	3329	2026-06-12 03:22:23	2026-09-13 01:03:15	USED	KEEP — primary key
CAMPAIGN.report.BillingAudit.PK_SettlementAudit	1	CLUSTERED	Y	Y	0	64	0	15	2026-06-12 03:22:41	2026-09-13 01:03:16	USED	KEEP — primary key
CAMPAIGN.report.ShipmentStaging.PK_QuotaLine	1	CLUSTERED	Y	Y	0	64	0	0	2026-06-12 03:23:02	never	USED	KEEP — primary key
CAMPAIGN.report.SalesLine.PK_ReconcileDetail	1	CLUSTERED	Y	Y	17	44	0	10582	2026-06-13 05:44:29	2026-09-13 01:03:32	USED	KEEP — primary key
CAMPAIGN.report.ReconcileDetail.PK_BillingSummary	1	CLUSTERED	Y	Y	0	32	0	20	2026-06-13 05:29:03	never	USED	KEEP — primary key
CAMPAIGN.report.PolicyEntry.PK_PayrollEntry	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.report.ReconcileStaging.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.report.ShipmentQueue.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	0	32	0	5	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.report.MeterStatus.PK_PricingMonthly	1	CLUSTERED	Y	Y	0	32	0	20	2026-06-13 05:29:10	never	USED	KEEP — primary key
CAMPAIGN.report.ShiftResult.PK_SalesHistory	1	CLUSTERED	Y	Y	0	32	0	6	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.report.Level.PK_AssetSnapshot	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:56	never	USED	KEEP — primary key
CAMPAIGN.report.CampaignHeader.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.report.WarehouseHeader.PK_InvoiceDetail	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.report.QuotaEntry.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:56	never	USED	KEEP — primary key
CAMPAIGN.report.QuotaStatus.PK_StaffingMonthly	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.report.Position.PK_TerritoryDaily	1	CLUSTERED	Y	Y	0	32	0	5	2026-06-13 05:28:55	never	USED	KEEP — primary key
CAMPAIGN.report.CampaignQueue.PK_PolicyHistory	1	CLUSTERED	Y	Y	0	32	0	5	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.report.RouteQueue.PK_ReconcileStatus	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:46	never	USED	KEEP — primary key
CAMPAIGN.report.RosterQueue.PK_SalesStatus	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.report.TicketAudit.PK_PricingHeader	1	CLUSTERED	Y	Y	0	32	0	5	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.report.CustomerLog.PK_LedgerStatus	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.report.SupplierStaging.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	16	0	12	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.report.PolicyLine.PK_StaffingStaging	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.report.RouteStaging.PK_AssetDetail	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:53	never	USED	KEEP — primary key
CAMPAIGN.report.CatalogSnapshot.PK_TicketHeader	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:56	never	USED	KEEP — primary key
CAMPAIGN.report.BillingDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y	0	32	0	6	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.report.CampaignAudit.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.report.PricingArchive.PK_ShipmentHistory	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:57	never	USED	KEEP — primary key
CAMPAIGN.report.SalesStatus.PK_BillingLog	1	CLUSTERED	Y	Y	0	32	0	4	2026-06-13 05:30:21	never	USED	KEEP — primary key
CAMPAIGN.report.SettlementQueue.PK_RouteHistory	1	CLUSTERED	Y	Y	0	32	0	4	2026-06-13 05:30:20	never	USED	KEEP — primary key
CAMPAIGN.report.MeterHistory.PK_ForecastLine	1	CLUSTERED	Y	Y	13	35	0	4	2026-06-13 05:30:21	never	USED	KEEP — primary key
CAMPAIGN.report.ShipmentAudit.PK_SalesArchive	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:30:21	never	USED	KEEP — primary key
CAMPAIGN.report.ForecastAudit.PK_MeterSummary	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:56	never	USED	KEEP — primary key
CAMPAIGN.report.PayrollLine.PK_ForecastResult	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:54	never	USED	KEEP — primary key
CAMPAIGN.report.SupplierArchive.PK_BatchDaily	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:30:21	never	USED	KEEP — primary key
CAMPAIGN.report.CustomerSnapshot.PK_BatchResult	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:30:20	never	USED	KEEP — primary key
CAMPAIGN.report.CampaignResult.PK_ShiftEntry	1	CLUSTERED	Y	Y	0	32	0	4	2026-06-13 05:30:17	never	USED	KEEP — primary key
CAMPAIGN.report.BookingStaging.PK_RouteMonthly	1	CLUSTERED	Y	Y	0	32	0	2	2026-06-13 05:28:54	never	USED	KEEP — primary key
CAMPAIGN.report.SupplierResult.PK_OrdersDaily	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:54	never	USED	KEEP — primary key
CAMPAIGN.report.ShiftResult.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	32	0	64	2026-06-13 05:29:12	never	USED	KEEP — primary key
CAMPAIGN.report.ShiftDaily.PK_SettlementResult	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:46	never	USED	KEEP — primary key
CAMPAIGN.report.PayrollHistory.PK_ClaimArchive	1	CLUSTERED	Y	Y	16	32	0	51	2026-06-13 05:30:16	never	USED	KEEP — primary key
CAMPAIGN.report.CatalogSummary.PK_RouteHistory	1	CLUSTERED	Y	Y	0	32	0	29	2026-06-13 05:29:05	never	USED	KEEP — primary key
CAMPAIGN.report.TicketMonthly.PK_RouteEntry	1	CLUSTERED	Y	Y	4	44	0	9	2026-06-13 05:29:08	never	USED	KEEP — primary key
CAMPAIGN.report.BillingQueue.PK_PolicyMonthly	1	CLUSTERED	Y	Y	0	32	0	23	2026-06-13 05:29:00	never	USED	KEEP — primary key
CAMPAIGN.report.QuotaResult.PK_InvoiceResult	1	CLUSTERED	Y	Y	0	32	0	3	2026-06-13 05:28:54	never	USED	KEEP — primary key
TERRITORY.app.RosterDaily.PK_TicketAudit	1	CLUSTERED	Y	Y	31	779	0	17	2026-09-15 10:27:01	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	33	0	0	17	2026-09-15 10:27:01	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	33	0	0	17	2026-09-15 10:27:01	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.app.SalesSummary.PK_OrdersAudit	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:02:39	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	16	17	0	17	2026-09-15 10:27:01	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.app.SettlementEntry.PK_TicketQueue	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:02:39	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.app.BatchQueue.PK_LedgerResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:39	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.dbo.AssetSnapshot.PK_PayrollHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
TERRITORY.report.ContractSnapshot.PK_ContractResult	1	CLUSTERED	Y	Y	31	0	0	17	2026-09-15 10:27:01	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.report.PolicyHistory.PK_TicketAudit	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:02:59	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.report.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	1570	889	0	17	2026-09-15 02:15:15	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.report.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	35	222	0	17	2026-09-15 10:27:01	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ContractDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:47	2026-09-13 01:01:09	USED	KEEP — primary key
TERRITORY.report.TicketAudit.PK_PricingLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:56	2026-09-13 01:01:10	USED	KEEP — primary key
TERRITORY.report.CampaignQueue.PK_InvoiceMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:52	2026-09-13 01:01:10	USED	KEEP — primary key
TERRITORY.report.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	15	779	0	17	2026-09-15 02:15:15	2026-09-13 01:01:10	USED	KEEP — primary key
TERRITORY.report.BatchLog.PK_SalesMonthly	1	CLUSTERED	Y	Y	17	17	0	17	2026-06-13 02:02:59	2026-09-13 01:01:10	USED	KEEP — primary key
TERRITORY.report.TicketMonthly.PK_SupplierLine	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-09-13 01:01:10	USED	KEEP — primary key
TERRITORY.report.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	17	111	0	17	2026-09-15 02:15:01	2026-09-13 01:01:10	USED	KEEP — primary key
TERRITORY.report.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	128	777	0	17	2026-09-15 02:15:15	2026-09-13 01:01:10	USED	KEEP — primary key
TERRITORY.report.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	17	777	0	17	2026-09-15 02:15:15	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	1125	446	0	17	2026-09-15 02:15:15	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	570	335	0	17	2026-09-15 02:15:15	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.WarehouseStatus.PK_MeterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:06	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	15	779	0	17	2026-09-15 02:15:15	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.CustomerStatus.PK_SalesDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:59	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.MeterStatus.PK_OrdersLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:08	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.QuotaQueue.PK_BookingQueue	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:08	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.CatalogSummary.PK_AssetLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:06	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.TicketHeader.PK_PolicyResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:02	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.RouteHeader.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:03	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.PolicyHistory.PK_CampaignQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:07	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.ForecastHistory.PK_SupplierHistory	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:07	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	15	3887	0	17	2026-09-15 02:15:15	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	1346	1019	0	17	2026-09-15 10:27:01	2026-09-13 01:01:11	USED	KEEP — primary key
TERRITORY.report.TicketLine.PK_CustomerEntry	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:13	2026-09-13 01:01:12	USED	KEEP — primary key
TERRITORY.report.AssetSnapshot.PK_SalesAudit	1	CLUSTERED	Y	Y	17	10	0	17	2026-09-15 08:12:17	2026-09-13 01:01:13	USED	KEEP — primary key
TERRITORY.report.MeterAudit.PK_ShiftEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:11	2026-09-13 01:01:13	USED	KEEP — primary key
TERRITORY.report.PolicyEntry.PK_RouteResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:06	2026-09-13 01:01:13	USED	KEEP — primary key
TERRITORY.report.SalesEntry.PK_WarehouseMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:02	2026-09-13 01:01:13	USED	KEEP — primary key
TERRITORY.report.MeterArchive.PK_LedgerStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-09-13 01:01:13	USED	KEEP — primary key
TERRITORY.report.StaffingHistory.PK_ShipmentArchive	1	CLUSTERED	Y	Y	15	2	0	17	2026-06-13 02:03:03	2026-09-13 01:01:13	USED	KEEP — primary key
TERRITORY.report.BookingQueue.PK_AssetHeader	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:45	2026-09-13 01:01:13	USED	KEEP — primary key
TERRITORY.report.ShiftDaily.PK_ClaimAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:42	2026-09-13 01:01:13	USED	KEEP — primary key
TERRITORY.report.InvoiceAudit.PK_PolicyDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:46	2026-09-13 01:01:13	USED	KEEP — primary key
TERRITORY.report.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	15	779	0	17	2026-09-15 02:15:15	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	22	337	0	17	2026-09-15 08:13:21	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	17	111	0	17	2026-09-15 02:15:01	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.ShiftMonthly.PK_PricingArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:42	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.ContractMonthly.PK_CustomerDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:43	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.SalesAudit.PK_BatchArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:49	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.MeterSnapshot.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:42	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	350	1332	0	17	2026-09-15 02:15:15	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	128	777	0	17	2026-09-15 02:15:15	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	17	777	0	17	2026-09-15 02:15:15	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.ReconcileHistory.PK_StaffingDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.ClaimDetail.PK_RosterLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:13	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	17	222	0	17	2026-09-15 02:17:55	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	17	111	0	17	2026-09-15 02:17:01	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.InvoiceHistory.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:13	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.BookingDetail.PK_RosterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:47	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.QuotaSummary.PK_RosterStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.WarehouseEntry.PK_ShiftDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:13	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.RosterSummary.PK_PricingMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:43	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	17	111	0	17	2026-09-15 02:19:18	2026-09-13 01:01:14	USED	KEEP — primary key
TERRITORY.report.CampaignQueue.PK_PayrollEntry	1	CLUSTERED	Y	Y	13	4	0	17	2026-06-13 02:03:17	2026-09-13 01:01:15	USED	KEEP — primary key
TERRITORY.report.ClaimStaging.PK_SupplierHeader	1	CLUSTERED	Y	Y	10	7	0	17	2026-06-13 02:03:17	2026-09-13 01:01:18	USED	KEEP — primary key
TERRITORY.report.PayrollMonthly.PK_MeterSnapshot	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:17	2026-09-13 01:01:18	USED	KEEP — primary key
TERRITORY.report.StaffingQueue.PK_CatalogLine	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:16	never	USED	KEEP — primary key
TERRITORY.report.RosterEntry.PK_BookingStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:52	2026-09-13 01:01:18	USED	KEEP — primary key
TERRITORY.report.AssetStatus.PK_TicketEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:55	2026-09-13 01:01:18	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ForecastSummary	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:16	2026-09-13 01:01:18	USED	KEEP — primary key
TERRITORY.report.TicketQueue.PK_CatalogAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:17	2026-09-13 01:01:18	USED	KEEP — primary key
TERRITORY.report.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	17	111	0	17	2026-09-15 02:17:55	2026-09-13 01:01:19	USED	KEEP — primary key
TERRITORY.report.CustomerLog.PK_BillingEntry	1	CLUSTERED	Y	Y	16	3	0	17	2026-09-15 08:13:21	2026-09-13 01:01:19	USED	KEEP — primary key
TERRITORY.report.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	17	16	0	17	2026-09-15 10:27:01	2026-09-13 01:01:19	USED	KEEP — primary key
TERRITORY.report.LedgerStaging.PK_ForecastEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:12	2026-09-13 01:01:22	USED	KEEP — primary key
TERRITORY.report.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	794	0	0	17	2026-09-15 02:15:15	2026-09-13 01:01:20	USED	KEEP — primary key
TERRITORY.report.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	818	196	0	68	2026-09-15 10:27:01	2026-09-13 01:01:20	USED	KEEP — primary key
TERRITORY.report.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	23	1673	0	17	2026-09-15 10:27:01	2026-09-13 01:01:20	USED	KEEP — primary key
TERRITORY.report.ShiftSnapshot.PK_BillingResult	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:11	2026-09-13 01:01:21	USED	KEEP — primary key
TERRITORY.report.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	17	127	0	17	2026-09-15 10:27:01	2026-09-13 01:01:21	USED	KEEP — primary key
TERRITORY.report.CustomerStatus.PK_PayrollLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-09-13 01:01:21	USED	KEEP — primary key
TERRITORY.report.ForecastSummary.PK_BatchQueue	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
TERRITORY.report.MeterHistory.PK_LedgerQueue	1	CLUSTERED	Y	Y	555	375	0	777	2026-09-15 10:27:01	2026-09-13 01:01:22	USED	KEEP — primary key
TERRITORY.report.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	17	145	2	34	2026-09-15 08:13:21	2026-09-13 01:01:22	USED	KEEP — primary key
TERRITORY.report.ForecastLine.UX_ShiftQueue	8	NONCLUSTERED	Y		451	111	0	34	2026-09-15 08:13:21	2026-09-13 01:01:26	USED	keep — in use
TERRITORY.report.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	2	111	0	111	2026-09-15 08:13:21	2026-09-13 01:01:32	USED	KEEP — primary key
TERRITORY.report.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	30	132	0	34	2026-09-15 02:15:16	2026-09-13 01:01:34	USED	KEEP — primary key
TERRITORY.report.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	23	255	0	34	2026-09-15 08:12:17	2026-09-13 01:01:34	USED	KEEP — primary key
TERRITORY.report.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	34	239	0	34	2026-09-15 02:20:50	2026-09-13 01:01:34	USED	KEEP — primary key
TERRITORY.report.SettlementHeader.PK_CatalogHistory	1	CLUSTERED	Y	Y	15	19	0	34	2026-06-13 02:06:40	2026-09-13 01:01:35	USED	KEEP — primary key
TERRITORY.report.ShiftStaging.PK_RosterArchive	1	CLUSTERED	Y	Y	17	366	0	34	2026-09-15 02:19:20	2026-09-13 01:01:35	USED	KEEP — primary key
TERRITORY.report.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			622	0	0	111	2026-09-15 02:15:15	2026-09-13 01:01:36	USED	keep — in use
TERRITORY.report.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	266	622	111	2026-09-15 02:15:15	2026-09-13 01:01:36	USED	KEEP — primary key
TERRITORY.report.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	3	222	0	111	2026-09-15 02:20:51	2026-09-13 01:01:36	USED	KEEP — primary key
TERRITORY.report.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	79	145	0	222	2026-09-15 08:13:21	2026-09-13 01:01:36	USED	KEEP — primary key
TERRITORY.report.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	4	1998	0	1332	2026-09-15 02:19:19	2026-09-13 01:01:37	USED	KEEP — primary key
TERRITORY.report.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	111	0	111	2026-09-15 02:20:37	2026-09-13 01:01:37	USED	KEEP — primary key
TERRITORY.report.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	4	222	0	111	2026-09-15 02:20:50	2026-09-13 01:01:37	USED	KEEP — primary key
TERRITORY.report.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	14	1305	0	222	2026-09-15 10:27:01	2026-09-13 01:01:37	USED	KEEP — primary key
TERRITORY.report.BatchStaging.PK_CampaignHeader	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:02:59	2026-09-13 01:01:38	USED	KEEP — primary key
TERRITORY.report.CustomerDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:02:59	2026-09-13 01:01:38	USED	KEEP — primary key
TERRITORY.report.PolicyEntry.PK_QuotaMonthly	1	CLUSTERED	Y	Y	0	17	0	60	2026-06-13 02:03:06	2026-09-13 01:01:38	USED	KEEP — primary key
TERRITORY.report.MeterEntry.PK_RosterStatus	1	CLUSTERED	Y	Y	0	17	0	475	2026-06-13 02:02:59	2026-09-13 01:01:38	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:06	2026-09-13 01:01:38	USED	KEEP — primary key
TERRITORY.report.SupplierHeader.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	17	0	334	2026-06-13 02:03:17	2026-09-13 01:01:39	USED	KEEP — primary key
TERRITORY.report.SupplierResult.PK_StaffingDaily	1	CLUSTERED	Y	Y	0	17	0	23803	2026-06-13 02:03:17	2026-09-13 01:01:42	USED	KEEP — primary key
TERRITORY.report.BookingResult.PK_ClaimLog	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:17	never	USED	KEEP — primary key
TERRITORY.report.InvoiceEntry.PK_ForecastLine	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:16	never	USED	KEEP — primary key
TERRITORY.report.ReconcileLog.PK_CampaignQueue	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:16	2026-09-13 01:01:42	USED	KEEP — primary key
TERRITORY.report.OrdersArchive.PK_ContractAudit	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:17	2026-09-13 01:01:42	USED	KEEP — primary key
TERRITORY.report.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	34	0	21809	2026-06-13 02:03:03	2026-09-13 01:01:43	USED	KEEP — primary key
SUPPLIER.dbo.PricingEntry.PK_ClaimQueue	1	CLUSTERED	Y	Y	28	26	0	44	2026-06-13 02:06:44	2026-09-13 01:01:44	USED	KEEP — primary key
SUPPLIER.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	54	never	2026-09-13 01:01:44	UNUSED	KEEP — primary key
SUPPLIER.dbo.SalesLine.PK_ContractMonthly	1	CLUSTERED	Y	Y	3605	1	0	1488	2026-06-13 02:02:26	2026-09-13 01:01:44	USED	KEEP — primary key
SUPPLIER.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	0	0	3018	never	2026-09-13 01:01:44	UNUSED	KEEP — primary key
SUPPLIER.dbo.RosterQueue.PK_TerritoryDaily	1	CLUSTERED	Y	Y	2992	0	0	1496	2026-06-13 02:06:40	2026-09-13 01:01:44	USED	KEEP — primary key
SUPPLIER.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	0	0	2992	never	2026-09-13 01:01:44	UNUSED	KEEP — primary key
SUPPLIER.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	34740	3474	0	34740	2026-09-16 00:59:50	2026-09-13 01:01:45	USED	KEEP — primary key
SUPPLIER.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	641	0	34740	2026-08-21 13:03:55	2026-09-16 01:00:36	USED	KEEP — primary key
SUPPLIER.dbo.Source.PK_QuotaDaily	1	CLUSTERED	Y	Y	0	26	0	0	2026-06-13 02:00:03	2026-09-13 01:01:45	USED	KEEP — primary key
INVOICE.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:02:41	never	USED	KEEP — primary key
INVOICE.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y	0	34	0	0	2026-06-13 02:02:40	never	USED	KEEP — primary key
INVOICE.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y	0	34	0	3	2026-06-13 02:02:38	never	USED	KEEP — primary key
INVOICE.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y	1	50	0	4	2026-06-13 02:02:39	never	USED	KEEP — primary key
INVOICE.app.WarehouseStatus.PK_BatchDaily	1	CLUSTERED	Y	Y	17	34	0	2	2026-06-13 02:02:39	never	USED	KEEP — primary key
INVOICE.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y	0	51	0	4	2026-06-13 02:02:39	never	USED	KEEP — primary key
INVOICE.app.SalesLine.PK_PricingDetail	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-13 01:01:46	UNUSED	KEEP — primary key
INVOICE.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-13 01:01:46	UNUSED	KEEP — primary key
INVOICE.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-13 01:01:46	UNUSED	KEEP — primary key
INVOICE.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-13 01:01:46	UNUSED	KEEP — primary key
INVOICE.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-13 01:01:46	UNUSED	KEEP — primary key
INVOICE.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-13 01:01:46	UNUSED	KEEP — primary key
INVOICE.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-13 01:01:46	UNUSED	KEEP — primary key
INVOICE.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y	0	34	0	1	2026-06-13 02:02:39	never	USED	KEEP — primary key
INVOICE.report.WarehouseMonthly.PK_LedgerStaging	1	CLUSTERED	Y	Y	0	38	0	5	2026-06-13 02:02:52	never	USED	KEEP — primary key
INVOICE.report.SalesDetail.PK_ShiftEntry	1	CLUSTERED	Y	Y	17	38	0	4	2026-06-13 02:02:59	never	USED	KEEP — primary key
INVOICE.report.PolicySummary.PK_ContractHistory	1	CLUSTERED	Y	Y	0	38	0	12	2026-06-13 02:02:52	never	USED	KEEP — primary key
INVOICE.report.BatchDaily.PK_InvoiceEntry	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:47	never	USED	KEEP — primary key
INVOICE.report.ShipmentAudit.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	38	0	5	2026-06-13 02:02:47	never	USED	KEEP — primary key
INVOICE.report.BookingResult.PK_BookingHistory	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:56	never	USED	KEEP — primary key
INVOICE.report.InvoiceQueue.PK_SettlementHistory	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:52	never	USED	KEEP — primary key
INVOICE.report.QuotaMonthly.PK_ReconcileDaily	1	CLUSTERED	Y	Y	0	38	0	28	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.report.PayrollSummary.PK_StaffingLine	1	CLUSTERED	Y	Y	17	38	0	4	2026-06-13 02:03:00	never	USED	KEEP — primary key
INVOICE.report.RouteHistory.PK_TicketEntry	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.report.AssetSummary.PK_QuotaArchive	1	CLUSTERED	Y	Y	0	38	0	5	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.report.WarehouseEntry.PK_CampaignStaging	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:42	never	USED	KEEP — primary key
INVOICE.report.TerritoryEntry.PK_SettlementEntry	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:41	never	USED	KEEP — primary key
INVOICE.report.MeterResult.PK_ContractDaily	1	CLUSTERED	Y	Y	0	38	0	16	2026-06-13 02:02:58	never	USED	KEEP — primary key
INVOICE.report.PayrollHeader.PK_TerritoryQueue	1	CLUSTERED	Y	Y	0	38	0	18	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.report.RosterResult.PK_AssetQueue	1	CLUSTERED	Y	Y	0	38	0	6	2026-06-13 02:03:06	never	USED	KEEP — primary key
INVOICE.report.MeterAudit.PK_SettlementQueue	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:03:12	never	USED	KEEP — primary key
INVOICE.report.ShiftLine.PK_BatchLog	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:02:59	never	USED	KEEP — primary key
INVOICE.report.CampaignHeader.PK_MeterSummary	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:08	never	USED	KEEP — primary key
INVOICE.report.MeterStatus.PK_ShiftStaging	1	CLUSTERED	Y	Y	17	38	0	4	2026-06-13 02:03:08	never	USED	KEEP — primary key
INVOICE.report.ForecastHeader.PK_ShiftLine	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:06	never	USED	KEEP — primary key
INVOICE.report.AssetDaily.PK_ShiftLine	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:02	never	USED	KEEP — primary key
INVOICE.report.StaffingDaily.PK_ContractStatus	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.report.ClaimResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:07	never	USED	KEEP — primary key
INVOICE.report.PricingDaily.PK_SettlementLog	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:07	never	USED	KEEP — primary key
INVOICE.report.PolicyLog.PK_BatchQueue	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:03:07	never	USED	KEEP — primary key
INVOICE.report.MeterHistory.PK_ShiftHistory	1	CLUSTERED	Y	Y	0	38	0	28	2026-06-13 02:02:59	never	USED	KEEP — primary key
INVOICE.report.TerritoryLine.PK_ShipmentAudit	1	CLUSTERED	Y	Y	17	38	0	12	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.report.SettlementQueue.PK_PayrollStaging	1	CLUSTERED	Y	Y	0	38	0	11	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.report.TicketQueue.PK_CatalogStaging	1	CLUSTERED	Y	Y	0	38	0	12	2026-06-13 02:03:11	never	USED	KEEP — primary key
INVOICE.report.OrdersEntry.PK_RosterMonthly	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:06	never	USED	KEEP — primary key
INVOICE.report.CampaignHistory.PK_ShipmentStatus	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 02:03:02	never	USED	KEEP — primary key
INVOICE.report.TicketLine.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.report.BatchAudit.PK_BookingDetail	1	CLUSTERED	Y	Y	0	38	0	2938	2026-06-13 02:04:19	never	USED	KEEP — primary key
INVOICE.report.PolicyHistory.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	72	0	27	2026-06-13 02:06:23	never	USED	KEEP — primary key
INVOICE.report.BillingEntry.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	72	0	585	2026-06-13 02:06:38	never	USED	KEEP — primary key
INVOICE.report.BillingAudit.PK_SettlementAudit	1	CLUSTERED	Y	Y	0	72	0	10	2026-06-13 02:06:40	never	USED	KEEP — primary key
INVOICE.report.ShipmentStaging.PK_QuotaLine	1	CLUSTERED	Y	Y	0	55	0	4	2026-06-13 02:06:40	never	USED	KEEP — primary key
INVOICE.report.SalesLine.PK_ReconcileDetail	1	CLUSTERED	Y	Y	17	54	0	3227	2026-06-13 02:06:11	never	USED	KEEP — primary key
INVOICE.report.ReconcileDetail.PK_BillingSummary	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.report.PolicyEntry.PK_PayrollEntry	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:45	never	USED	KEEP — primary key
INVOICE.report.ReconcileStaging.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:42	never	USED	KEEP — primary key
INVOICE.report.ShipmentQueue.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 02:02:46	never	USED	KEEP — primary key
INVOICE.report.MeterStatus.PK_PricingMonthly	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.report.ShiftResult.PK_SalesHistory	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 02:02:46	never	USED	KEEP — primary key
INVOICE.report.Level.PK_AssetSnapshot	1	CLUSTERED	Y	Y	0	38	0	5	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.report.CampaignHeader.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:42	never	USED	KEEP — primary key
INVOICE.report.WarehouseHeader.PK_InvoiceDetail	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:43	never	USED	KEEP — primary key
INVOICE.report.QuotaEntry.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	38	0	5	2026-06-13 02:02:50	never	USED	KEEP — primary key
INVOICE.report.QuotaStatus.PK_StaffingMonthly	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:42	never	USED	KEEP — primary key
INVOICE.report.Position.PK_TerritoryDaily	1	CLUSTERED	Y	Y	0	38	0	10	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.report.CampaignQueue.PK_PolicyHistory	1	CLUSTERED	Y	Y	0	38	0	10	2026-06-13 02:02:46	never	USED	KEEP — primary key
INVOICE.report.RouteQueue.PK_ReconcileStatus	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:44	never	USED	KEEP — primary key
INVOICE.report.RosterQueue.PK_SalesStatus	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.report.TicketAudit.PK_PricingHeader	1	CLUSTERED	Y	Y	0	38	0	6	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.report.CustomerLog.PK_LedgerStatus	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.report.SupplierStaging.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	21	0	11	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.report.PolicyLine.PK_StaffingStaging	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.report.RouteStaging.PK_AssetDetail	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:47	never	USED	KEEP — primary key
INVOICE.report.CatalogSnapshot.PK_TicketHeader	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.report.BillingDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y	0	38	0	6	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.report.CampaignAudit.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:43	never	USED	KEEP — primary key
INVOICE.report.PricingArchive.PK_ShipmentHistory	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:56	never	USED	KEEP — primary key
INVOICE.report.SalesStatus.PK_BillingLog	1	CLUSTERED	Y	Y	0	38	0	11	2026-06-13 02:03:17	never	USED	KEEP — primary key
INVOICE.report.SettlementQueue.PK_RouteHistory	1	CLUSTERED	Y	Y	0	38	0	18	2026-06-13 02:03:17	never	USED	KEEP — primary key
INVOICE.report.MeterHistory.PK_ForecastLine	1	CLUSTERED	Y	Y	14	41	0	18	2026-06-13 02:03:17	never	USED	KEEP — primary key
INVOICE.report.ShipmentAudit.PK_SalesArchive	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:16	never	USED	KEEP — primary key
INVOICE.report.ForecastAudit.PK_MeterSummary	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:52	never	USED	KEEP — primary key
INVOICE.report.PayrollLine.PK_ForecastResult	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:55	never	USED	KEEP — primary key
INVOICE.report.SupplierArchive.PK_BatchDaily	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:16	never	USED	KEEP — primary key
INVOICE.report.CustomerSnapshot.PK_BatchResult	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:17	never	USED	KEEP — primary key
INVOICE.report.CampaignResult.PK_ShiftEntry	1	CLUSTERED	Y	Y	0	38	0	12	2026-06-13 02:03:15	never	USED	KEEP — primary key
INVOICE.report.BookingStaging.PK_RouteMonthly	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 02:02:55	never	USED	KEEP — primary key
INVOICE.report.SupplierResult.PK_OrdersDaily	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:52	never	USED	KEEP — primary key
INVOICE.report.ShiftResult.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	38	0	12	2026-06-13 02:03:12	never	USED	KEEP — primary key
INVOICE.report.ShiftDaily.PK_SettlementResult	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:42	never	USED	KEEP — primary key
INVOICE.report.PayrollHistory.PK_ClaimArchive	1	CLUSTERED	Y	Y	17	38	0	9	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.report.CatalogSummary.PK_RouteHistory	1	CLUSTERED	Y	Y	0	38	0	13	2026-06-13 02:03:09	never	USED	KEEP — primary key
INVOICE.report.TicketMonthly.PK_RouteEntry	1	CLUSTERED	Y	Y	4	51	0	8	2026-06-13 02:03:11	never	USED	KEEP — primary key
INVOICE.report.BillingQueue.PK_PolicyMonthly	1	CLUSTERED	Y	Y	0	38	0	13	2026-06-13 02:03:09	never	USED	KEEP — primary key
INVOICE.report.QuotaResult.PK_InvoiceResult	1	CLUSTERED	Y	Y	0	38	0	7	2026-06-13 02:02:51	never	USED	KEEP — primary key