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

Index reportsSQL Server 13ACME-203-0-113-170ACME-198-51-100-45 ACME-192-0-2-15-MSSQL25-1433 ACME-198-51-100-66 ACME-192-0-2-136-MSSQLLAB-1433 ACME-198-51-100-210 ACME-198-51-100-60 ACME-192-0-2-243 ACME-203-0-113-99 ACME-203-0-113-69 ACME-192-0-2-97 ACME-192-0-2-242 ACME-203-0-113-155Oracle 3ACME-192-0-2-136-ORALAB-1521 ACME-192-0-2-120 ACME-198-51-100-125PostgreSQL 2ACME-192-0-2-15-PG-5433 ACME-192-0-2-136-PGLAB-5432

Host: 203.0.113.170

Collected: 2026-10-19T18:04:47Z

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 user table
used	678	had a seek, scan or lookup
unused	35	written but never read
cold	46	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	7	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.internal.ShipmentStaging.IX_WarehouseEntry	208806	never	UNUSED	review, then DROP
host-763.internal.tasks.IX_ShipmentEntry	42137	never	UNUSED	review, then DROP
host-763.internal.jobs.IX_MeterStaging	289	never	UNUSED	review, then DROP
host-763.internal.SalesDaily.IX_PolicySummary	289	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.internal.RouteEntry.IX_ClaimSnapshot	0	never	COLD	review, then DROP
host-763.internal.ShiftSummary.IX_BookingHeader	0	never	COLD	review, then DROP
host-763.internal.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	274	149	0	32	2026-10-19 01:30:07	2026-10-18 01:00:20	USED	KEEP — primary key
host-323.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	273	0	0	32	2026-10-12 16:08:09	2026-10-18 01:00:20	USED	KEEP — primary key
host-323.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	273	0	0	32	2026-10-12 16:08:09	2026-10-18 01:00:20	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-10-18 01:00:20	USED	KEEP — primary key
host-323.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	241	32	0	32	2026-10-12 16:08:09	2026-10-18 01:00:20	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-10-18 01:00:20	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-10-18 01:00:20	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	257	0	0	32	2026-10-12 16:08:09	2026-10-18 01:00:21	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-10-18 01:00:21	USED	KEEP — primary key
host-323.report.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	29	586	0	32	2026-10-19 01:30:08	2026-10-18 01:00:21	USED	KEEP — primary key
host-323.report.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	289	289	0	32	2026-10-19 01:31:38	2026-10-18 01:00:21	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-10-18 01:00:21	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-10-18 01:00:21	USED	KEEP — primary key
host-323.report.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	23	155	0	32	2026-10-19 01:30:02	2026-10-18 01:00:21	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-10-18 01:00:21	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-10-18 01:00:21	USED	KEEP — primary key
host-323.report.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	32	145	0	32	2026-10-19 01:30:00	2026-10-18 01:00:21	USED	KEEP — primary key
host-323.report.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	177	146	0	32	2026-10-19 01:30:02	2026-10-18 01:00:21	USED	KEEP — primary key
host-323.report.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	32	146	0	32	2026-10-19 01:30:02	2026-10-18 01:00:21	USED	KEEP — primary key
host-323.report.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	15	309	0	32	2026-10-19 01:30:07	2026-10-18 01:00:21	USED	KEEP — primary key
host-323.report.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	20	303	0	32	2026-10-19 01:30:07	2026-10-18 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-10-18 01:00:21	USED	KEEP — primary key
host-323.report.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	30	148	0	32	2026-10-19 01:30:07	2026-10-18 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-10-18 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-10-18 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-10-18 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-10-18 01:00:21	USED	KEEP — primary key
host-323.report.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	16	746	0	32	2026-10-19 01:30:06	2026-10-18 01:00:21	USED	KEEP — primary key
host-323.report.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	93	1488	0	32	2026-10-19 01:31:50	2026-10-18 01:00:22	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-10-18 01:00:22	USED	KEEP — primary key
host-323.report.AssetSnapshot.PK_SalesAudit	1	CLUSTERED	Y	Y	29	98	0	31	2026-10-12 16:08:25	2026-10-18 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-10-18 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-10-18 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-10-18 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-10-18 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-10-18 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-10-18 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-10-18 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-10-18 01:00:23	USED	KEEP — primary key
host-323.report.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	28	150	0	32	2026-10-19 01:30:07	2026-10-18 01:00:23	USED	KEEP — primary key
host-323.report.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	62	482	0	32	2026-10-19 01:31:04	2026-10-18 01:00:23	USED	KEEP — primary key
host-323.report.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	32	145	0	32	2026-10-19 01:30:00	2026-10-18 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-10-18 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-10-18 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-10-18 01:00:23	USED	KEEP — primary key
host-323.report.MeterSnapshot.PK_StaffingQueue	1	CLUSTERED	Y	Y	32	1	0	32	2026-09-29 08:35:30	2026-10-18 01:00:23	USED	KEEP — primary key
host-323.report.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	31	438	0	32	2026-10-19 01:30:04	2026-10-18 01:00:23	USED	KEEP — primary key
host-323.report.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	31	292	0	32	2026-10-19 01:30:03	2026-10-18 01:00:23	USED	KEEP — primary key
host-323.report.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	32	146	0	32	2026-10-19 01:30:02	2026-10-18 01:00:23	USED	KEEP — primary key
host-323.report.ReconcileHistory.PK_StaffingDaily	1	CLUSTERED	Y	Y	32	1	0	32	2026-09-29 08:35:30	2026-10-18 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-10-18 01:00:24	USED	KEEP — primary key
host-323.report.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	24	295	0	31	2026-10-19 01:31:35	2026-10-18 01:00:24	USED	KEEP — primary key
host-323.report.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	9	167	0	31	2026-10-19 01:31:04	2026-10-18 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-10-18 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-10-18 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-10-18 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-10-18 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-10-18 01:00:25	USED	KEEP — primary key
host-323.report.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	32	144	0	32	2026-10-19 01:31:38	2026-10-18 01:00:25	USED	KEEP — primary key
host-323.report.CampaignQueue.PK_PayrollEntry	1	CLUSTERED	Y	Y	31	1	0	31	2026-10-07 11:35:27	2026-10-18 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-10-18 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-10-18 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-10-18 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-10-18 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-10-18 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-10-18 01:00:26	USED	KEEP — primary key
host-323.report.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	6	170	0	31	2026-10-19 01:31:35	2026-10-18 01:00:26	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-10-18 01:00:27	USED	KEEP — primary key
host-323.report.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	32	241	0	32	2026-10-12 16:08:09	2026-10-18 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-10-18 01:00:28	USED	KEEP — primary key
host-323.report.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	178	0	0	32	2026-10-19 01:30:02	2026-10-18 01:00:27	USED	KEEP — primary key
host-323.report.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	549	356	0	128	2026-10-19 01:30:09	2026-10-18 01:00:27	USED	KEEP — primary key
host-323.report.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	36	658	0	32	2026-10-19 01:30:04	2026-10-18 01:00:28	USED	KEEP — primary key
host-323.report.ShiftSnapshot.PK_BillingResult	1	CLUSTERED	Y	Y	3	36	0	35	2026-10-07 11:35:27	2026-10-18 01:00:28	USED	KEEP — primary key
host-323.report.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	20	401	0	34	2026-10-19 01:30:00	2026-10-18 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-10-18 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	57	828	0	146	2026-10-19 01:32:21	2026-10-18 01:00:28	USED	KEEP — primary key
host-323.report.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	31	211	11	62	2026-10-19 01:31:36	2026-10-18 01:00:29	USED	KEEP — primary key
host-323.report.ForecastLine.UX_ShiftQueue	2	NONCLUSTERED	Y		635	145	0	62	2026-10-19 01:32:16	2026-10-18 01:00:31	USED	keep — in use
host-323.report.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	16	145	0	144	2026-10-19 01:31:26	2026-10-18 01:00:35	USED	KEEP — primary key
host-323.report.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	31	199	0	62	2026-10-19 01:30:10	2026-10-18 01:00:38	USED	KEEP — primary key
host-323.report.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	79	371	0	62	2026-10-19 01:30:17	2026-10-18 01:00:39	USED	KEEP — primary key
host-323.report.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	29	353	0	62	2026-10-19 01:32:16	2026-10-18 01:00:40	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	494	0	62	2026-10-19 01:31:38	2026-10-18 01:00:42	USED	KEEP — primary key
host-323.report.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			83	0	0	145	2026-10-19 01:30:02	2026-10-18 01:00:43	USED	keep — in use
host-323.report.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	209	83	145	2026-10-19 01:30:07	2026-10-18 01:00:43	USED	KEEP — primary key
host-323.report.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	30	289	0	144	2026-10-19 01:32:22	2026-10-18 01:00:43	USED	KEEP — primary key
host-323.report.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	96	209	0	288	2026-10-19 01:31:36	2026-10-18 01:00:44	USED	KEEP — primary key
host-323.report.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	37	3985	0	2656	2026-10-19 01:31:38	2026-10-18 01:00:44	USED	KEEP — primary key
host-323.report.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	145	0	144	2026-10-19 01:32:07	2026-10-18 01:00:46	USED	KEEP — primary key
host-323.report.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	40	288	0	144	2026-10-19 01:32:15	2026-10-18 01:00:46	USED	KEEP — primary key
host-323.report.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	40	2260	0	290	2026-10-19 01:32:21	2026-10-18 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-10-18 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	1128	2026-06-27 01:02:24	2026-10-18 01:00:47	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	199	2026-06-26 01:03:02	2026-10-18 01:00:47	USED	KEEP — primary key
host-323.report.SupplierResult.PK_StaffingDaily	1	CLUSTERED	Y	Y	0	31	0	21790	2026-06-26 01:03:00	2026-10-18 01:01:28	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-10-18 01:01:29	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-10-18 01:01:29	USED	KEEP — primary key
host-323.report.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	64	0	7277	2026-06-27 01:02:28	2026-10-18 01:01:31	USED	KEEP — primary key
host-707.dbo.PricingEntry.PK_ClaimQueue	1	CLUSTERED	Y	Y	379	160	0	416	2026-10-20 01:00:26	2026-10-18 01:01:31	USED	KEEP — primary key
host-707.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	3	0	534	2026-10-07 11:31:07	2026-10-20 01:01:35	USED	KEEP — primary key
host-707.dbo.SalesLine.PK_ContractMonthly	1	CLUSTERED	Y	Y	7457	7	0	3294	2026-10-20 01:00:13	2026-10-18 01:01:31	USED	KEEP — primary key
host-707.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	8	0	7648	2026-10-07 11:33:06	2026-10-20 01:01:35	USED	KEEP — primary key
host-707.dbo.RosterQueue.PK_TerritoryDaily	1	CLUSTERED	Y	Y	5937	11	0	2801	2026-10-07 11:33:06	2026-10-18 01:01:32	USED	KEEP — primary key
host-707.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	2	0	5602	2026-10-07 11:33:06	2026-10-18 01:01:32	USED	KEEP — primary key
host-707.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	6050	606	0	6050	2026-10-19 22:32:03	2026-10-18 01:01:32	USED	KEEP — primary key
host-707.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	1541	0	6050	2026-10-19 22:32:03	2026-10-20 01:01:35	USED	KEEP — primary key
host-707.dbo.Source.PK_QuotaDaily	1	CLUSTERED	Y	Y	0	156	0	0	2026-10-20 01:00:07	2026-10-18 01:01:32	USED	KEEP — primary key
host-888.app.Account.PK_SettlementResult	1	CLUSTERED	Y	Y	0	62	0	146	2026-06-27 01:02:01	2026-10-20 01:01:37	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	105	2026-06-27 01:02:00	2026-10-20 01:01:37	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-10-18 01:01:33	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-10-18 01:01:33	USED	KEEP — primary key
host-888.app.SalesLine.PK_PricingDetail	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-18 01:01:33	UNUSED	KEEP — primary key
host-888.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-18 01:01:33	UNUSED	KEEP — primary key
host-888.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-18 01:01:33	UNUSED	KEEP — primary key
host-888.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-18 01:01:33	UNUSED	KEEP — primary key
host-888.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-18 01:01:33	UNUSED	KEEP — primary key
host-888.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-18 01:01:33	UNUSED	KEEP — primary key
host-888.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-18 01:01:34	UNUSED	KEEP — primary key
host-888.app.Permission.PK_ClaimHeader	1	CLUSTERED	Y	Y	0	64	0	5	2026-06-27 01:02:00	2026-10-18 01:01:34	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.Company.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-10-18 01:01:34	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-10-18 01:01:34	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	64	0	3303	2026-10-07 11:45:04	2026-10-18 01:01:37	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-10-18 01:01:37	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-10-18 01:01:37	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-10-18 01:01:38	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-10-18 01:01:40	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	63	0	0	2026-09-29 08:35:33	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	63	0	0	2026-09-29 08:35:32	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-10-18 01:01:57	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-10-18 01:01:57	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-10-18 01:01:57	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-10-18 01:01:57	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-10-18 01:01:57	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-10-18 01:01:57	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-10-18 01:01:57	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-10-18 01:01:57	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	70	0	27	2026-10-07 11:33:51	2026-10-18 01:01:57	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.internal.OrdersLog.PK_BookingMonthly	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-763.internal.MeterHistory.PK_TerritoryStatus	1	CLUSTERED	Y	Y	0	597	0	0	2026-10-20 01:00:08	2026-10-18 01:00:00	USED	KEEP — primary key
host-763.internal.TerritorySnapshot.PK_PayrollDaily	1	CLUSTERED	Y	Y	11041	1	0	0	2026-10-20 01:00:09	2026-10-18 01:00:01	USED	KEEP — primary key
host-763.internal.ReconcileLine.PK_TicketAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-763.internal.ReconcileLine.IX_SalesArchive	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
host-763.internal.PricingResult.PK_SupplierAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	2026-10-18 01:00:01	UNUSED	KEEP — primary key
host-763.internal.PricingResult.IX_MeterSummary	2	NONCLUSTERED	Y		6892	16368	0	0	2026-10-20 01:00:07	2026-10-18 01:00:01	USED	keep — in use
host-763.internal.CampaignSnapshot.PK_PricingEntry	1	CLUSTERED	Y	Y	0	6	0	0	2026-09-29 08:35:04	never	USED	KEEP — primary key
host-763.internal.CampaignSnapshot.IX_SalesSnapshot	2	NONCLUSTERED	Y		6	0	0	0	2026-09-29 08:35:04	never	USED	keep — in use
host-763.internal.LedgerEntry.PK_ShiftAudit	1	CLUSTERED	Y	Y	0	1	0	0	2026-05-27 23:09:41	never	USED	KEEP — primary key
host-763.internal.RouteMonthly.PK_SettlementStatus	1	CLUSTERED	Y	Y	0	1	0	0	2026-09-29 08:35:04	never	USED	KEEP — primary key
host-763.internal.RouteMonthly.IX_SalesAudit	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
host-763.internal.RouteMonthly.PK_ForecastHeader	1	CLUSTERED	Y	Y	6	1	0	0	2026-09-29 08:35:04	never	USED	KEEP — primary key
host-763.internal.RouteMonthly.IX_SalesLog	2	NONCLUSTERED	Y		0	1	0	0	2026-09-29 08:35:04	never	USED	keep — in use
host-763.internal.RouteLine.IX_BatchDaily	3	NONCLUSTERED			0	146	0	1898137	2026-10-20 00:00:00	2026-10-20 01:00:29	USED	keep — in use
host-763.internal.RouteLine.IX_QuotaQueue	2	NONCLUSTERED			146	0	0	1898137	2026-10-20 00:00:00	2026-10-20 01:00:34	USED	keep — in use
host-763.internal.RouteLine.PK_BatchResult	1	CLUSTERED	Y	Y	0	0	0	1898137	never	2026-10-20 01:00:27	UNUSED	KEEP — primary key
host-763.internal.RouteEntry.IX_ClaimSnapshot	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-763.internal.StaffingArchive.IX_ShipmentLog	2	NONCLUSTERED			146	146	0	930057	2026-10-20 00:00:00	2026-10-20 01:00:58	USED	keep — in use
host-763.internal.StaffingArchive.PK_TicketResult	1	CLUSTERED	Y	Y	1898015	0	0	930057	2026-10-20 01:00:29	2026-10-20 01:00:54	USED	KEEP — primary key
host-763.internal.ShiftSummary.IX_MeterResult	2	NONCLUSTERED			2	0	0	0	2026-09-29 08:35:33	never	USED	keep — in use
host-763.internal.ShiftSummary.IX_BookingHeader	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-763.internal.SupplierLog.IX_CatalogEntry	2	NONCLUSTERED			152	0	0	112702	2026-10-20 00:00:00	2026-10-20 01:01:03	USED	keep — in use
host-763.internal.SupplierLog.PK_ShiftLine	1	CLUSTERED	Y	Y	0	3	6	112702	2026-10-07 11:48:00	2026-10-20 01:01:01	USED	KEEP — primary key
host-763.internal.PricingAudit.PK_RouteSummary	1	CLUSTERED	Y	Y	112556	112561	0	2068	2026-10-20 01:00:29	2026-10-18 01:00:13	USED	KEEP — primary key
host-763.internal.BatchSnapshot.PK_StaffingSnapshot	1	CLUSTERED	Y	Y	0	4	0	146	2026-05-28 09:58:07	never	USED	KEEP — primary key
host-763.internal.BatchSnapshot.IX_BatchSnapshot	2	NONCLUSTERED			145	1	0	146	2026-10-20 00:00:00	never	USED	keep — in use
host-763.internal.MeterDaily.PK_ForecastStatus	1	CLUSTERED	Y	Y	0	146	0	146	2026-10-20 00:00:00	never	USED	KEEP — primary key
host-763.internal.StaffingSummary.PK_InvoiceStaging	1	CLUSTERED	Y	Y	0	721	0	146	2026-10-20 01:00:09	never	USED	KEEP — primary key
host-763.internal.CampaignDaily.IX_LedgerMonthly	2	NONCLUSTERED			2574	0	0	3593	2026-10-20 01:00:07	2026-10-20 01:01:04	USED	keep — in use
host-763.internal.CampaignDaily.IX_ClaimQueue	3	NONCLUSTERED			7341	0	0	3593	2026-10-20 01:00:08	2026-10-20 01:01:04	USED	keep — in use
host-763.internal.CampaignDaily.PK_PricingLine	1	CLUSTERED	Y	Y	3446	1	8047	9339	2026-10-20 01:00:08	2026-10-20 01:01:03	USED	KEEP — primary key
host-763.internal.WarehouseMonthly.IX_CampaignLine	2	NONCLUSTERED			145	1	0	146	2026-10-20 00:00:00	never	USED	keep — in use
host-763.internal.WarehouseMonthly.PK_TerritoryStatus	1	CLUSTERED	Y	Y	0	1150	0	146	2026-10-20 01:00:09	never	USED	KEEP — primary key
host-763.internal.executions.PK_TerritoryLog	1	CLUSTERED	Y	Y	118945	307	0	721	2026-10-20 01:00:30	2026-10-20 01:01:05	USED	KEEP — primary key
host-763.internal.InvoiceLine.PK_PayrollAudit	1	CLUSTERED	Y	Y	0	147	0	147	2026-10-20 00:00:00	never	USED	KEEP — primary key
host-763.internal.SettlementEntry.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	3562	6144	0	2026-10-20 01:00:08	never	USED	KEEP — primary key
host-763.internal.SettlementEntry.IX_PricingHistory	2	NONCLUSTERED	Y		6144	0	0	0	2026-10-20 01:00:08	never	USED	keep — in use
host-763.internal.AssetSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	20	8	9	0	2026-05-28 10:40:11	2026-10-18 01:00:16	USED	KEEP — primary key
host-763.internal.AssetSummary.IX_SalesLog	2	NONCLUSTERED	Y		1769	4	0	0	2026-10-20 01:00:08	2026-10-18 01:00:16	USED	keep — in use
host-763.internal.QuotaLog.PK_ClaimStatus	1	CLUSTERED	Y	Y	289	289	0	289	2026-10-19 15:34:57	never	USED	KEEP — primary key
host-763.internal.SalesQueue.PK_CustomerStaging	1	CLUSTERED	Y	Y	0	0	0	289	never	never	UNUSED	KEEP — primary key
host-763.internal.jobs.PK_AssetSummary	1	CLUSTERED	Y	Y	0	578	0	289	2026-10-19 15:34:57	never	USED	KEEP — primary key
host-763.internal.jobs.IX_MeterStaging	2	NONCLUSTERED			0	0	0	289	never	never	UNUSED	review, then DROP
host-763.internal.BillingLine.PK_StaffingStatus	1	CLUSTERED	Y	Y	578	0	0	289	2026-10-19 15:34:57	never	USED	KEEP — primary key
host-763.internal.ContractDetail.PK_ForecastLog	1	CLUSTERED	Y	Y	208806	0	0	208806	2026-10-20 01:04:26	2026-10-18 01:00:16	USED	KEEP — primary key
host-763.internal.AssetSnapshot.PK_CustomerSnapshot	1	CLUSTERED	Y	Y	420092	0	0	418308	2026-10-20 01:04:27	2026-10-18 01:00:16	USED	KEEP — primary key
host-763.internal.RouteAudit.IX_PayrollLog	2	NONCLUSTERED			1150	147	0	16515	2026-10-20 01:00:08	2026-10-18 01:00:16	USED	keep — in use
host-763.internal.RouteAudit.PK_BatchLine	1	CLUSTERED	Y	Y	0	2888	1150	16521	2026-10-20 01:00:08	2026-10-18 01:00:16	USED	KEEP — primary key
host-763.internal.BatchDetail.PK_BillingEntry	1	CLUSTERED	Y	Y	36418	454	0	164	2026-10-20 01:00:08	2026-10-18 01:00:17	USED	KEEP — primary key
host-763.internal.BatchLog.IX_ShiftLog	2	NONCLUSTERED			190	0	0	930058	2026-10-20 00:00:00	2026-10-20 01:01:15	USED	keep — in use
host-763.internal.BatchLog.PK_MeterStatus	1	CLUSTERED	Y	Y	929911	2	43	930058	2026-10-20 01:00:29	2026-10-20 01:01:13	USED	KEEP — primary key
host-763.internal.PayrollSnapshot.IX_ReconcileHistory	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-763.internal.PayrollSnapshot.IX_SettlementAudit	2	NONCLUSTERED			3	0	0	0	2026-05-28 10:00:59	never	USED	keep — in use
host-763.internal.SalesEntry.IX_SupplierQueue	2	NONCLUSTERED			1776	291	0	721	2026-10-20 01:00:30	2026-10-20 01:01:16	USED	keep — in use
host-763.internal.SalesEntry.PK_SupplierAudit	1	CLUSTERED	Y	Y	0	10	0	721	2026-05-28 11:00:16	2026-10-20 01:01:16	USED	KEEP — primary key
host-763.internal.InvoiceSnapshot.PK_PayrollArchive	1	CLUSTERED	Y	Y	0	338	19980	727	2026-10-20 01:00:30	2026-10-20 01:01:16	USED	KEEP — primary key
host-763.internal.InvoiceSnapshot.IX_ShipmentLog	2	NONCLUSTERED	Y		19980	146	0	727	2026-10-20 01:00:30	2026-10-20 01:01:16	USED	keep — in use
host-763.internal.operations.IX_RouteLine	2	NONCLUSTERED			0	41993	0	1596	2026-10-20 01:03:04	2026-10-20 01:01:16	USED	keep — in use
host-763.internal.operations.PK_RosterQueue	1	CLUSTERED	Y	Y	3859737	205	0	131472	2026-10-20 01:03:04	2026-10-20 01:01:16	USED	KEEP — primary key
host-763.internal.BatchLog.IX_LedgerDetail	2	NONCLUSTERED			576	303	0	163	2026-10-20 01:00:07	2026-10-18 01:00:19	USED	keep — in use
host-763.internal.BatchLog.PK_SupplierArchive	1	CLUSTERED	Y	Y	0	2	4	163	2026-05-28 10:40:11	2026-10-18 01:00:19	USED	KEEP — primary key
host-763.internal.TicketHeader.PK_ShipmentHistory	1	CLUSTERED	Y	Y	0	6138	0	0	2026-10-20 01:00:08	2026-10-18 01:00:19	USED	KEEP — primary key
host-763.internal.TicketHeader.IX_ShiftAudit	2	NONCLUSTERED	Y		6138	0	0	0	2026-10-20 01:00:08	2026-10-18 01:00:19	USED	keep — in use
host-763.internal.SettlementAudit.IX_CampaignHistory	3	NONCLUSTERED			1168	151	0	6	2026-10-20 01:00:08	2026-10-18 01:00:20	USED	keep — in use
host-763.internal.SettlementAudit.PK_CustomerLine	1	CLUSTERED	Y	Y	26895	20	11	6	2026-10-20 01:00:08	2026-10-18 01:00:20	USED	KEEP — primary key
host-763.internal.SettlementAudit.IX_CatalogLine	2	NONCLUSTERED	Y		11	0	0	0	2026-05-28 10:40:11	2026-10-18 01:00:20	USED	keep — in use
host-763.internal.tasks.PK_LedgerArchive	1	CLUSTERED	Y	Y	0	42137	0	42137	2026-10-20 01:03:04	never	USED	KEEP — primary key
host-763.internal.tasks.IX_SettlementEntry	2	NONCLUSTERED			0	578	0	42137	2026-10-19 15:34:57	never	USED	keep — in use
host-763.internal.tasks.IX_ShipmentEntry	3	NONCLUSTERED			0	0	0	42137	never	never	UNUSED	review, then DROP
host-763.internal.SalesDaily.PK_CatalogHistory	1	CLUSTERED	Y	Y	0	0	0	289	never	never	UNUSED	KEEP — primary key
host-763.internal.SalesDaily.IX_PolicySummary	2	NONCLUSTERED			0	0	0	289	never	never	UNUSED	review, then DROP
host-763.internal.QuotaLog.PK_RosterResult	1	CLUSTERED	Y	Y	0	146	0	146	2026-10-20 00:00:00	never	USED	KEEP — primary key
host-763.internal.ShipmentStaging.IX_WarehouseEntry	2	NONCLUSTERED			0	0	0	208806	never	never	UNUSED	review, then DROP
host-763.internal.ReconcileDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	626827	145	0	209215	2026-10-20 01:04:26	2026-10-18 01:00:20	USED	KEEP — primary key
TERRITORY.app.RosterDaily.PK_TicketAudit	1	CLUSTERED	Y	Y	58	158	0	20	2026-10-19 01:30:05	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	62	3	0	19	2026-10-08 15:31:55	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	65	0	0	19	2026-10-08 15:31:55	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.app.SalesSummary.PK_OrdersAudit	1	CLUSTERED	Y	Y	0	19	0	19	2026-06-13 05:28:43	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	46	19	0	19	2026-10-08 15:31:55	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.app.SettlementEntry.PK_TicketQueue	1	CLUSTERED	Y	Y	0	19	0	19	2026-06-13 05:28:43	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.app.BatchQueue.PK_LedgerResult	1	CLUSTERED	Y	Y	19	0	0	19	2026-06-13 05:28:43	2026-10-18 01:02:45	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	61	0	0	17	2026-10-08 15:31:56	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.report.PolicyHistory.PK_TicketAudit	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:28:59	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.report.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	23	592	0	17	2026-10-19 01:30:06	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.report.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	67	292	0	17	2026-10-19 01:33:15	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ContractDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.report.TicketAudit.PK_PricingLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:54	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.report.CampaignQueue.PK_InvoiceMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-10-18 01:02:45	USED	KEEP — primary key
TERRITORY.report.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	10	157	0	17	2026-10-19 01:30:02	2026-10-18 01:02:46	USED	KEEP — primary key
TERRITORY.report.BatchLog.PK_SalesMonthly	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:29:03	2026-10-18 01:02:46	USED	KEEP — primary key
TERRITORY.report.TicketMonthly.PK_SupplierLine	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-10-18 01:02:46	USED	KEEP — primary key
TERRITORY.report.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	17	147	0	17	2026-10-19 01:30:00	2026-10-18 01:02:46	USED	KEEP — primary key
TERRITORY.report.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	164	150	0	17	2026-10-19 01:30:02	2026-10-18 01:02:46	USED	KEEP — primary key
TERRITORY.report.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	17	150	0	17	2026-10-19 01:30:02	2026-10-18 01:02:46	USED	KEEP — primary key
TERRITORY.report.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	15	302	0	17	2026-10-19 01:30:05	2026-10-18 01:02:46	USED	KEEP — primary key
TERRITORY.report.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	14	299	0	17	2026-10-19 01:30:05	2026-10-18 01:02:46	USED	KEEP — primary key
TERRITORY.report.WarehouseStatus.PK_MeterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:07	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	10	157	0	17	2026-10-19 01:30:05	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.CustomerStatus.PK_SalesDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:13	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.MeterStatus.PK_OrdersLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:59	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.QuotaQueue.PK_BookingQueue	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:28:58	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.CatalogSummary.PK_AssetLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:12	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.TicketHeader.PK_PolicyResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:13	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.RouteHeader.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:12	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.PolicyHistory.PK_CampaignQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:59	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.ForecastHistory.PK_SupplierHistory	1	CLUSTERED	Y	Y	16	1	0	17	2026-06-13 05:29:08	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	10	757	0	17	2026-10-19 01:30:04	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	168	1224	0	17	2026-10-19 01:33:44	2026-10-18 01:02:47	USED	KEEP — primary key
TERRITORY.report.TicketLine.PK_CustomerEntry	1	CLUSTERED	Y	Y	1	17	0	17	2026-06-13 05:30:17	2026-10-18 01:02:48	USED	KEEP — primary key
TERRITORY.report.AssetSnapshot.PK_SalesAudit	1	CLUSTERED	Y	Y	16	11	0	17	2026-09-12 11:17:00	2026-10-18 01:02:48	USED	KEEP — primary key
TERRITORY.report.MeterAudit.PK_ShiftEntry	1	CLUSTERED	Y	Y	14	3	0	17	2026-06-13 05:28:59	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.PolicyEntry.PK_RouteResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:09	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.SalesEntry.PK_WarehouseMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:08	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.MeterArchive.PK_LedgerStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.StaffingHistory.PK_ShipmentArchive	1	CLUSTERED	Y	Y	9	8	0	17	2026-06-13 05:29:03	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.BookingQueue.PK_AssetHeader	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.ShiftDaily.PK_ClaimAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.InvoiceAudit.PK_PolicyDaily	1	CLUSTERED	Y	Y	16	1	0	17	2026-06-13 05:28:50	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	10	157	0	17	2026-10-19 01:30:05	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	20	444	0	17	2026-10-19 01:32:06	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	17	147	0	17	2026-10-19 01:30:00	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.ShiftMonthly.PK_PricingArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.ContractMonthly.PK_CustomerDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.SalesAudit.PK_BatchArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.MeterSnapshot.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	24	440	0	17	2026-10-19 01:30:03	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	22	292	0	17	2026-10-19 01:30:03	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	17	150	0	17	2026-10-19 01:30:02	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.ReconcileHistory.PK_StaffingDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-10-18 01:02:49	USED	KEEP — primary key
TERRITORY.report.ClaimDetail.PK_RosterLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:18	2026-10-18 01:02:50	USED	KEEP — primary key
TERRITORY.report.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	17	292	0	17	2026-10-19 01:33:15	2026-10-18 01:02:50	USED	KEEP — primary key
TERRITORY.report.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	17	147	0	18	2026-10-19 01:32:06	2026-10-18 01:02:50	USED	KEEP — primary key
TERRITORY.report.InvoiceHistory.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:18	2026-10-18 01:02:50	USED	KEEP — primary key
TERRITORY.report.BookingDetail.PK_RosterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:53	2026-10-18 01:02:50	USED	KEEP — primary key
TERRITORY.report.QuotaSummary.PK_RosterStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-10-18 01:02:50	USED	KEEP — primary key
TERRITORY.report.WarehouseEntry.PK_ShiftDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:18	2026-10-18 01:02:50	USED	KEEP — primary key
TERRITORY.report.RosterSummary.PK_PricingMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-10-18 01:02:50	USED	KEEP — primary key
TERRITORY.report.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	17	146	0	17	2026-10-19 01:33:15	2026-10-18 01:02:50	USED	KEEP — primary key
TERRITORY.report.CampaignQueue.PK_PayrollEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:21	2026-10-18 01:02:50	USED	KEEP — primary key
TERRITORY.report.ClaimStaging.PK_SupplierHeader	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:20	2026-10-18 01:02:51	USED	KEEP — primary key
TERRITORY.report.PayrollMonthly.PK_MeterSnapshot	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:30:21	2026-10-18 01:02:51	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-10-18 01:02:51	USED	KEEP — primary key
TERRITORY.report.AssetStatus.PK_TicketEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:54	2026-10-18 01:02:51	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ForecastSummary	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:21	2026-10-18 01:02:51	USED	KEEP — primary key
TERRITORY.report.TicketQueue.PK_CatalogAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:20	2026-10-18 01:02:51	USED	KEEP — primary key
TERRITORY.report.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	17	146	0	17	2026-10-19 01:33:15	2026-10-18 01:02:51	USED	KEEP — primary key
TERRITORY.report.CustomerLog.PK_BillingEntry	1	CLUSTERED	Y	Y	17	2	0	17	2026-09-12 11:19:00	2026-10-18 01:02:51	USED	KEEP — primary key
TERRITORY.report.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	17	46	0	17	2026-10-08 15:31:55	2026-10-18 01:02:51	USED	KEEP — primary key
TERRITORY.report.LedgerStaging.PK_ForecastEntry	1	CLUSTERED	Y	Y	13	4	0	17	2026-06-13 05:29:07	2026-10-18 01:02:54	USED	KEEP — primary key
TERRITORY.report.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	167	0	0	17	2026-10-19 01:30:02	2026-10-18 01:02:51	USED	KEEP — primary key
TERRITORY.report.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	394	86	0	68	2026-10-19 01:30:06	2026-10-18 01:02:52	USED	KEEP — primary key
TERRITORY.report.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	46	468	0	17	2026-10-19 01:30:03	2026-10-18 01:02:52	USED	KEEP — primary key
TERRITORY.report.ShiftSnapshot.PK_BillingResult	1	CLUSTERED	Y	Y	1	17	0	17	2026-06-13 05:29:08	2026-10-18 01:02:53	USED	KEEP — primary key
TERRITORY.report.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	12	198	0	17	2026-10-19 01:30:00	2026-10-18 01:02:53	USED	KEEP — primary key
TERRITORY.report.CustomerStatus.PK_PayrollLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:54	2026-10-18 01:02:53	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	45	365	0	147	2026-10-19 01:35:43	2026-10-18 01:02:54	USED	KEEP — primary key
TERRITORY.report.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	148	179	2	34	2026-10-19 01:35:42	2026-10-18 01:04:06	USED	KEEP — primary key
TERRITORY.report.ForecastLine.UX_ShiftQueue	10	NONCLUSTERED	Y		460	147	0	34	2026-10-19 01:33:15	2026-10-18 01:04:17	USED	keep — in use
TERRITORY.report.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	2	146	0	146	2026-10-19 01:32:41	2026-10-18 01:04:21	USED	KEEP — primary key
TERRITORY.report.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	16	163	0	32	2026-10-19 01:30:06	2026-10-18 01:04:22	USED	KEEP — primary key
TERRITORY.report.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	22	322	0	32	2026-10-19 01:30:21	2026-10-18 01:04:22	USED	KEEP — primary key
TERRITORY.report.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	29	311	0	32	2026-10-19 01:35:42	2026-10-18 01:04:23	USED	KEEP — primary key
TERRITORY.report.SettlementHeader.PK_CatalogHistory	1	CLUSTERED	Y	Y	29	19	0	32	2026-06-12 03:23:02	2026-10-18 01:04:23	USED	KEEP — primary key
TERRITORY.report.ShiftStaging.PK_RosterArchive	1	CLUSTERED	Y	Y	19	467	0	36	2026-10-19 01:33:15	2026-10-18 01:04:26	USED	KEEP — primary key
TERRITORY.report.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			101	0	0	146	2026-10-19 01:30:02	2026-10-18 01:04:27	USED	keep — in use
TERRITORY.report.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	195	101	146	2026-10-19 01:30:05	2026-10-18 01:04:27	USED	KEEP — primary key
TERRITORY.report.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	0	292	0	146	2026-10-19 01:35:44	2026-10-18 01:04:27	USED	KEEP — primary key
TERRITORY.report.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	117	177	0	292	2026-10-19 01:33:15	2026-10-18 01:04:27	USED	KEEP — primary key
TERRITORY.report.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	3	2628	0	1752	2026-10-19 01:33:15	2026-10-18 01:04:27	USED	KEEP — primary key
TERRITORY.report.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	146	0	146	2026-10-19 01:35:39	2026-10-18 01:04:28	USED	KEEP — primary key
TERRITORY.report.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	0	292	0	146	2026-10-19 01:35:42	2026-10-18 01:04:28	USED	KEEP — primary key
TERRITORY.report.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	45	1001	0	294	2026-10-19 01:35:43	2026-10-18 01:04:28	USED	KEEP — primary key
TERRITORY.report.BatchStaging.PK_CampaignHeader	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:28:59	2026-10-18 01:04:28	USED	KEEP — primary key
TERRITORY.report.CustomerDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:29:03	2026-10-18 01:04:28	USED	KEEP — primary key
TERRITORY.report.PolicyEntry.PK_QuotaMonthly	1	CLUSTERED	Y	Y	0	17	0	10	2026-06-13 05:29:07	2026-10-18 01:04:28	USED	KEEP — primary key
TERRITORY.report.MeterEntry.PK_RosterStatus	1	CLUSTERED	Y	Y	0	17	0	30	2026-06-13 05:29:13	2026-10-18 01:04:28	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	17	0	1111	2026-06-13 05:29:09	2026-10-19 01:02:05	USED	KEEP — primary key
TERRITORY.report.SupplierHeader.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	17	0	196	2026-06-13 05:30:21	2026-10-18 01:04:29	USED	KEEP — primary key
TERRITORY.report.SupplierResult.PK_StaffingDaily	1	CLUSTERED	Y	Y	0	17	0	3319	2026-06-13 05:30:20	2026-10-18 01:04:40	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-10-18 01:04:41	USED	KEEP — primary key
TERRITORY.report.OrdersArchive.PK_ContractAudit	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:30:20	2026-10-18 01:04:41	USED	KEEP — primary key
TERRITORY.report.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	34	0	139114	2026-06-13 05:29:33	2026-10-20 01:04:05	USED	KEEP — primary key
CUSTOMER.dbo.PricingEntry.PK_ClaimQueue	1	CLUSTERED	Y	Y	21	27	0	41	2026-06-13 07:23:43	2026-10-18 01:04:45	USED	KEEP — primary key
CUSTOMER.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	43	never	2026-10-18 01:04:45	UNUSED	KEEP — primary key
CUSTOMER.dbo.SalesLine.PK_ContractMonthly	1	CLUSTERED	Y	Y	3572	2	0	1612	2026-06-13 05:28:37	2026-10-18 01:04:45	USED	KEEP — primary key
CUSTOMER.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	0	0	3224	never	2026-10-18 01:04:46	UNUSED	KEEP — primary key
CUSTOMER.dbo.RosterQueue.PK_TerritoryDaily	1	CLUSTERED	Y	Y	3258	1	0	1509	2026-06-13 07:23:41	2026-10-18 01:04:46	USED	KEEP — primary key
CUSTOMER.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	0	0	3019	never	2026-10-18 01:04:46	UNUSED	KEEP — primary key
CUSTOMER.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	17407	1741	0	17407	2026-10-19 23:27:08	2026-10-18 01:04:46	USED	KEEP — primary key
CUSTOMER.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	170	0	17407	2026-10-07 11:27:06	2026-10-20 01:04:06	USED	KEEP — primary key
CUSTOMER.dbo.Source.PK_QuotaDaily	1	CLUSTERED	Y	Y	0	22	0	0	2026-06-13 03:00:02	2026-10-18 01:04:46	USED	KEEP — primary key
CAMPAIGN.app.Account.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-10-18 01:04:48	UNUSED	KEEP — primary key
CAMPAIGN.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-18 01:04:48	UNUSED	KEEP — primary key
CAMPAIGN.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-18 01:04:48	UNUSED	KEEP — primary key
CAMPAIGN.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-18 01:04:48	UNUSED	KEEP — primary key
CAMPAIGN.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-18 01:04:48	UNUSED	KEEP — primary key
CAMPAIGN.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-18 01:04:49	UNUSED	KEEP — primary key
CAMPAIGN.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-18 01:04:49	UNUSED	KEEP — primary key
CAMPAIGN.app.Permission.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.Company.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-10-18 01:04:49	USED	KEEP — primary key
CAMPAIGN.report.BillingEntry.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	63	0	3329	2026-06-12 03:22:23	2026-10-18 01:04:53	USED	KEEP — primary key
CAMPAIGN.report.BillingAudit.PK_SettlementAudit	1	CLUSTERED	Y	Y	0	64	0	15	2026-06-12 03:22:41	2026-10-18 01:04:53	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-10-18 01:05:23	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	35	1017	0	17	2026-10-19 02:15:11	2026-10-18 01:01:58	USED	KEEP — primary key
TERRITORY.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	37	0	0	17	2026-10-17 08:34:05	2026-10-18 01:01:58	USED	KEEP — primary key
TERRITORY.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	37	0	0	17	2026-10-17 08:34:05	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.app.SalesSummary.PK_OrdersAudit	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:02:39	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	20	17	0	17	2026-10-17 08:34:05	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.app.SettlementEntry.PK_TicketQueue	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:02:39	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.app.BatchQueue.PK_LedgerResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:39	2026-10-18 01:01:59	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	35	0	0	17	2026-10-17 08:34:06	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.report.PolicyHistory.PK_TicketAudit	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:02:59	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.report.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	2046	1161	0	17	2026-10-19 02:15:11	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.report.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	39	290	0	17	2026-10-19 02:16:32	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ContractDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:47	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.report.TicketAudit.PK_PricingLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:56	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.report.CampaignQueue.PK_InvoiceMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:52	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.report.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	15	1017	0	17	2026-10-19 02:15:10	2026-10-18 01:01:59	USED	KEEP — primary key
TERRITORY.report.BatchLog.PK_SalesMonthly	1	CLUSTERED	Y	Y	17	17	0	17	2026-06-13 02:02:59	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.TicketMonthly.PK_SupplierLine	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	17	145	0	17	2026-10-19 02:15:00	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	162	1015	0	17	2026-10-19 02:15:10	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	17	1015	0	17	2026-10-19 02:15:10	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	1465	582	0	17	2026-10-19 02:15:11	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	740	437	0	17	2026-10-19 02:15:11	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.WarehouseStatus.PK_MeterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:06	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	15	1017	0	17	2026-10-19 02:15:11	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.CustomerStatus.PK_SalesDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:59	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.MeterStatus.PK_OrdersLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:08	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.QuotaQueue.PK_BookingQueue	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:08	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.CatalogSummary.PK_AssetLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:06	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.TicketHeader.PK_PolicyResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:02	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.RouteHeader.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:03	2026-10-18 01:02:00	USED	KEEP — primary key
TERRITORY.report.PolicyHistory.PK_CampaignQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:07	2026-10-18 01:02:01	USED	KEEP — primary key
TERRITORY.report.ForecastHistory.PK_SupplierHistory	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:07	2026-10-18 01:02:01	USED	KEEP — primary key
TERRITORY.report.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	15	5077	0	17	2026-10-19 02:15:11	2026-10-18 01:02:01	USED	KEEP — primary key
TERRITORY.report.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	1754	1329	0	17	2026-10-19 02:16:43	2026-10-18 01:02:01	USED	KEEP — primary key
TERRITORY.report.TicketLine.PK_CustomerEntry	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:13	2026-10-18 01:02:02	USED	KEEP — primary key
TERRITORY.report.AssetSnapshot.PK_SalesAudit	1	CLUSTERED	Y	Y	17	10	0	17	2026-09-15 08:12:17	2026-10-18 01:02:02	USED	KEEP — primary key
TERRITORY.report.MeterAudit.PK_ShiftEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:11	2026-10-18 01:02:02	USED	KEEP — primary key
TERRITORY.report.PolicyEntry.PK_RouteResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:06	2026-10-18 01:02:02	USED	KEEP — primary key
TERRITORY.report.SalesEntry.PK_WarehouseMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:02	2026-10-18 01:02:02	USED	KEEP — primary key
TERRITORY.report.MeterArchive.PK_LedgerStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-10-18 01:02:02	USED	KEEP — primary key
TERRITORY.report.StaffingHistory.PK_ShipmentArchive	1	CLUSTERED	Y	Y	15	2	0	17	2026-06-13 02:03:03	2026-10-18 01:02:02	USED	KEEP — primary key
TERRITORY.report.BookingQueue.PK_AssetHeader	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:45	2026-10-18 01:02:02	USED	KEEP — primary key
TERRITORY.report.ShiftDaily.PK_ClaimAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:42	2026-10-18 01:02:02	USED	KEEP — primary key
TERRITORY.report.InvoiceAudit.PK_PolicyDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:46	2026-10-18 01:02:02	USED	KEEP — primary key
TERRITORY.report.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	15	1017	0	17	2026-10-19 02:15:11	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	22	439	0	17	2026-10-19 02:15:51	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	17	145	0	17	2026-10-19 02:15:00	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.ShiftMonthly.PK_PricingArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:42	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.ContractMonthly.PK_CustomerDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:43	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.SalesAudit.PK_BatchArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:49	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.MeterSnapshot.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:42	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	452	1740	0	17	2026-10-19 02:15:11	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	162	1015	0	17	2026-10-19 02:15:11	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	17	1015	0	17	2026-10-19 02:15:10	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.ReconcileHistory.PK_StaffingDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.ClaimDetail.PK_RosterLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:13	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	17	290	0	17	2026-10-19 02:16:18	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	17	145	0	17	2026-10-19 02:15:51	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.InvoiceHistory.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:13	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.BookingDetail.PK_RosterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:47	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.QuotaSummary.PK_RosterStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.WarehouseEntry.PK_ShiftDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:13	2026-10-18 01:02:03	USED	KEEP — primary key
TERRITORY.report.RosterSummary.PK_PricingMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:43	2026-10-18 01:02:04	USED	KEEP — primary key
TERRITORY.report.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	17	145	0	17	2026-10-19 02:16:32	2026-10-18 01:02:04	USED	KEEP — primary key
TERRITORY.report.CampaignQueue.PK_PayrollEntry	1	CLUSTERED	Y	Y	13	4	0	17	2026-06-13 02:03:17	2026-10-18 01:02:04	USED	KEEP — primary key
TERRITORY.report.ClaimStaging.PK_SupplierHeader	1	CLUSTERED	Y	Y	10	7	0	17	2026-06-13 02:03:17	2026-10-18 01:02:06	USED	KEEP — primary key
TERRITORY.report.PayrollMonthly.PK_MeterSnapshot	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:17	2026-10-18 01:02:06	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-10-18 01:02:06	USED	KEEP — primary key
TERRITORY.report.AssetStatus.PK_TicketEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:55	2026-10-18 01:02:06	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ForecastSummary	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:16	2026-10-18 01:02:06	USED	KEEP — primary key
TERRITORY.report.TicketQueue.PK_CatalogAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:17	2026-10-18 01:02:06	USED	KEEP — primary key
TERRITORY.report.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	17	145	0	17	2026-10-19 02:16:18	2026-10-18 01:02:07	USED	KEEP — primary key
TERRITORY.report.CustomerLog.PK_BillingEntry	1	CLUSTERED	Y	Y	16	3	0	17	2026-09-15 08:13:21	2026-10-18 01:02:07	USED	KEEP — primary key
TERRITORY.report.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	17	20	0	17	2026-10-17 08:34:05	2026-10-18 01:02:07	USED	KEEP — primary key
TERRITORY.report.LedgerStaging.PK_ForecastEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:12	2026-10-18 01:02:09	USED	KEEP — primary key
TERRITORY.report.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	1032	0	0	17	2026-10-19 02:15:10	2026-10-18 01:02:07	USED	KEEP — primary key
TERRITORY.report.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	1062	232	0	68	2026-10-19 02:15:11	2026-10-18 01:02:07	USED	KEEP — primary key
TERRITORY.report.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	25	2185	0	17	2026-10-19 02:15:11	2026-10-18 01:02:08	USED	KEEP — primary key
TERRITORY.report.ShiftSnapshot.PK_BillingResult	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:11	2026-10-18 01:02:08	USED	KEEP — primary key
TERRITORY.report.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	17	165	0	17	2026-10-19 02:15:00	2026-10-18 01:02:08	USED	KEEP — primary key
TERRITORY.report.CustomerStatus.PK_PayrollLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-10-18 01:02:08	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	727	483	0	1015	2026-10-19 02:16:58	2026-10-18 01:02:09	USED	KEEP — primary key
TERRITORY.report.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	17	179	2	34	2026-10-19 02:16:20	2026-10-18 01:02:20	USED	KEEP — primary key
TERRITORY.report.ForecastLine.UX_ShiftQueue	8	NONCLUSTERED	Y		587	145	0	34	2026-10-19 02:16:58	2026-10-18 01:02:21	USED	keep — in use
TERRITORY.report.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	2	145	0	145	2026-10-19 02:15:55	2026-10-18 01:02:22	USED	KEEP — primary key
TERRITORY.report.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	30	166	0	34	2026-10-19 02:15:11	2026-10-18 01:02:23	USED	KEEP — primary key
TERRITORY.report.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	23	323	0	34	2026-10-19 02:15:19	2026-10-18 01:02:23	USED	KEEP — primary key
TERRITORY.report.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	34	307	0	34	2026-10-19 02:16:58	2026-10-18 01:02:24	USED	KEEP — primary key
TERRITORY.report.SettlementHeader.PK_CatalogHistory	1	CLUSTERED	Y	Y	15	19	0	34	2026-06-13 02:06:40	2026-10-18 01:02:24	USED	KEEP — primary key
TERRITORY.report.ShiftStaging.PK_RosterArchive	1	CLUSTERED	Y	Y	17	468	0	34	2026-10-19 02:16:32	2026-10-18 01:02:24	USED	KEEP — primary key
TERRITORY.report.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			826	0	0	145	2026-10-19 02:15:11	2026-10-18 01:02:25	USED	keep — in use
TERRITORY.report.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	334	826	145	2026-10-19 02:15:11	2026-10-18 01:02:25	USED	KEEP — primary key
TERRITORY.report.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	3	290	0	145	2026-10-19 02:16:58	2026-10-18 01:02:25	USED	KEEP — primary key
TERRITORY.report.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	113	179	0	290	2026-10-19 02:16:31	2026-10-18 01:02:25	USED	KEEP — primary key
TERRITORY.report.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	4	2610	0	1740	2026-10-19 02:16:32	2026-10-18 01:02:25	USED	KEEP — primary key
TERRITORY.report.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	145	0	145	2026-10-19 02:16:51	2026-10-18 01:02:26	USED	KEEP — primary key
TERRITORY.report.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	4	290	0	145	2026-10-19 02:16:58	2026-10-18 01:02:26	USED	KEEP — primary key
TERRITORY.report.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	18	1703	0	290	2026-10-19 02:16:58	2026-10-18 01:02:26	USED	KEEP — primary key
TERRITORY.report.BatchStaging.PK_CampaignHeader	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:02:59	2026-10-18 01:02:27	USED	KEEP — primary key
TERRITORY.report.CustomerDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:02:59	2026-10-18 01:02:27	USED	KEEP — primary key
TERRITORY.report.PolicyEntry.PK_QuotaMonthly	1	CLUSTERED	Y	Y	0	17	0	60	2026-06-13 02:03:06	2026-10-18 01:02:27	USED	KEEP — primary key
TERRITORY.report.MeterEntry.PK_RosterStatus	1	CLUSTERED	Y	Y	0	17	0	475	2026-06-13 02:02:59	2026-10-18 01:02:27	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:06	2026-10-18 01:02:27	USED	KEEP — primary key
TERRITORY.report.SupplierHeader.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	17	0	473	2026-06-13 02:03:17	2026-10-18 01:02:27	USED	KEEP — primary key
TERRITORY.report.SupplierResult.PK_StaffingDaily	1	CLUSTERED	Y	Y	0	17	0	24885	2026-06-13 02:03:17	2026-10-18 01:02:37	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-10-18 01:02:38	USED	KEEP — primary key
TERRITORY.report.OrdersArchive.PK_ContractAudit	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:17	2026-10-18 01:02:38	USED	KEEP — primary key
TERRITORY.report.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	34	0	25516	2026-06-13 02:03:03	2026-10-20 01:02:46	USED	KEEP — primary key
SUPPLIER.dbo.PricingEntry.PK_ClaimQueue	1	CLUSTERED	Y	Y	28	26	0	44	2026-06-13 02:06:44	2026-10-18 01:02:41	USED	KEEP — primary key
SUPPLIER.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	54	never	2026-10-18 01:02:41	UNUSED	KEEP — primary key
SUPPLIER.dbo.SalesLine.PK_ContractMonthly	1	CLUSTERED	Y	Y	3605	1	0	1488	2026-06-13 02:02:26	2026-10-18 01:02:41	USED	KEEP — primary key
SUPPLIER.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	0	0	3018	never	2026-10-18 01:02:41	UNUSED	KEEP — primary key
SUPPLIER.dbo.RosterQueue.PK_TerritoryDaily	1	CLUSTERED	Y	Y	2992	0	0	1496	2026-06-13 02:06:40	2026-10-18 01:02:41	USED	KEEP — primary key
SUPPLIER.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	0	0	2992	never	2026-10-18 01:02:41	UNUSED	KEEP — primary key
SUPPLIER.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	51070	5107	0	51070	2026-10-20 01:04:11	2026-10-18 01:02:41	USED	KEEP — primary key
SUPPLIER.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	2911	0	51070	2026-09-29 19:04:00	2026-10-20 01:02:47	USED	KEEP — primary key
SUPPLIER.dbo.Source.PK_QuotaDaily	1	CLUSTERED	Y	Y	0	26	0	0	2026-06-13 02:00:03	2026-10-18 01:02:41	USED	KEEP — primary key
INVOICE.app.Account.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-10-18 01:02:42	UNUSED	KEEP — primary key
INVOICE.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-18 01:02:42	UNUSED	KEEP — primary key
INVOICE.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-18 01:02:42	UNUSED	KEEP — primary key
INVOICE.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-18 01:02:42	UNUSED	KEEP — primary key
INVOICE.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-18 01:02:43	UNUSED	KEEP — primary key
INVOICE.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-18 01:02:43	UNUSED	KEEP — primary key
INVOICE.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-18 01:02:43	UNUSED	KEEP — primary key
INVOICE.app.Permission.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.Company.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