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-198-51-100-210 ACME-198-51-100-60 ACME-192-0-2-243 ACME-203-0-113-99 ACME-198-51-100-92 ACME-203-0-113-69 ACME-192-0-2-97 ACME-192-0-2-242 ACME-203-0-113-155Oracle 2ACME-192-0-2-120 ACME-198-51-100-125PostgreSQL 1ACME-192-0-2-15-PG-5433

Host: 203.0.113.170

Collected: 2026-10-11T18:04:53Z

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	197287	never	UNUSED	review, then DROP
host-763.internal.tasks.IX_ShipmentEntry	39817	never	UNUSED	review, then DROP
host-763.internal.jobs.IX_MeterStaging	273	never	UNUSED	review, then DROP
host-763.internal.SalesDaily.IX_PolicySummary	273	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	260	141	0	32	2026-10-11 01:30:07	2026-10-11 01:01:21	USED	KEEP — primary key
host-323.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	259	0	0	32	2026-10-10 13:24:12	2026-10-11 01:01:21	USED	KEEP — primary key
host-323.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	259	0	0	32	2026-10-10 13:24:12	2026-10-11 01:01:21	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-11 01:01:21	USED	KEEP — primary key
host-323.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	227	32	0	32	2026-10-10 13:24:12	2026-10-11 01:01:21	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-11 01:01:21	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-11 01:01:21	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	243	0	0	32	2026-10-10 13:24:12	2026-10-11 01:01:22	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-11 01:01:22	USED	KEEP — primary key
host-323.report.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	29	554	0	32	2026-10-11 01:30:08	2026-10-11 01:01:22	USED	KEEP — primary key
host-323.report.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	275	273	0	32	2026-10-11 01:31:36	2026-10-11 01:01:22	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-11 01:01:22	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-11 01:01:22	USED	KEEP — primary key
host-323.report.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	23	147	0	32	2026-10-11 01:30:03	2026-10-11 01:01:22	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-11 01:01:22	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-11 01:01:22	USED	KEEP — primary key
host-323.report.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	32	137	0	32	2026-10-11 01:30:00	2026-10-11 01:01:22	USED	KEEP — primary key
host-323.report.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	169	138	0	32	2026-10-11 01:30:03	2026-10-11 01:01:22	USED	KEEP — primary key
host-323.report.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	32	138	0	32	2026-10-11 01:30:03	2026-10-11 01:01:22	USED	KEEP — primary key
host-323.report.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	15	293	0	32	2026-10-11 01:30:07	2026-10-11 01:01:22	USED	KEEP — primary key
host-323.report.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	20	287	0	32	2026-10-11 01:30:07	2026-10-11 01:01:22	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-11 01:01:22	USED	KEEP — primary key
host-323.report.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	30	140	0	32	2026-10-11 01:30:07	2026-10-11 01:01:22	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-11 01:01:22	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-11 01:01:23	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-11 01:01:23	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-11 01:01:23	USED	KEEP — primary key
host-323.report.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	16	706	0	32	2026-10-11 01:30:06	2026-10-11 01:01:23	USED	KEEP — primary key
host-323.report.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	85	1410	0	32	2026-10-11 01:31:44	2026-10-11 01:01:23	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-11 01:01:23	USED	KEEP — primary key
host-323.report.AssetSnapshot.PK_SalesAudit	1	CLUSTERED	Y	Y	29	80	0	31	2026-10-02 21:51:57	2026-10-11 01:01:24	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-11 01:01:24	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-11 01:01:24	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-11 01:01:24	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-11 01:01:24	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-11 01:01:24	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-11 01:01:24	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-11 01:01:24	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-11 01:01:25	USED	KEEP — primary key
host-323.report.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	28	142	0	32	2026-10-11 01:30:07	2026-10-11 01:01:25	USED	KEEP — primary key
host-323.report.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	62	449	0	32	2026-10-11 01:30:54	2026-10-11 01:01:25	USED	KEEP — primary key
host-323.report.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	32	137	0	32	2026-10-11 01:30:00	2026-10-11 01:01:25	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-11 01:01:25	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-11 01:01:25	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-11 01:01:25	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-11 01:01:25	USED	KEEP — primary key
host-323.report.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	31	414	0	32	2026-10-11 01:30:05	2026-10-11 01:01:25	USED	KEEP — primary key
host-323.report.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	31	276	0	32	2026-10-11 01:30:04	2026-10-11 01:01:25	USED	KEEP — primary key
host-323.report.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	32	138	0	32	2026-10-11 01:30:03	2026-10-11 01:01:25	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-11 01:01:25	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-11 01:01:25	USED	KEEP — primary key
host-323.report.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	24	279	0	31	2026-10-11 01:31:34	2026-10-11 01:01:26	USED	KEEP — primary key
host-323.report.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	9	159	0	31	2026-10-11 01:30:54	2026-10-11 01:01:27	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-11 01:01:27	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-11 01:01:27	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-11 01:01:27	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-11 01:01:27	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-11 01:01:27	USED	KEEP — primary key
host-323.report.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	32	136	0	32	2026-10-11 01:31:36	2026-10-11 01:01:27	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-11 01:01:27	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-11 01:01:30	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-11 01:01:30	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-11 01:01:30	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-11 01:01:30	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-11 01:01:30	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-11 01:01:30	USED	KEEP — primary key
host-323.report.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	6	162	0	31	2026-10-11 01:31:34	2026-10-11 01:01:30	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-11 01:01:31	USED	KEEP — primary key
host-323.report.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	32	227	0	32	2026-10-10 13:24:12	2026-10-11 01:01:31	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-11 01:01:32	USED	KEEP — primary key
host-323.report.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	170	0	0	32	2026-10-11 01:30:03	2026-10-11 01:01:31	USED	KEEP — primary key
host-323.report.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	519	342	0	128	2026-10-11 01:30:09	2026-10-11 01:01:31	USED	KEEP — primary key
host-323.report.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	36	620	0	32	2026-10-11 01:30:05	2026-10-11 01:01:31	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-11 01:01:31	USED	KEEP — primary key
host-323.report.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	20	379	0	34	2026-10-11 01:30:00	2026-10-11 01:01:32	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-11 01:01:32	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	55	768	0	138	2026-10-11 01:32:01	2026-10-11 01:01:32	USED	KEEP — primary key
host-323.report.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	31	203	11	62	2026-10-11 01:31:35	2026-10-11 01:01:33	USED	KEEP — primary key
host-323.report.ForecastLine.UX_ShiftQueue	2	NONCLUSTERED	Y		594	137	0	62	2026-10-11 01:31:58	2026-10-11 01:01:34	USED	keep — in use
host-323.report.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	16	137	0	136	2026-10-11 01:31:22	2026-10-11 01:01:47	USED	KEEP — primary key
host-323.report.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	31	191	0	62	2026-10-11 01:30:11	2026-10-11 01:01:48	USED	KEEP — primary key
host-323.report.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	70	355	0	62	2026-10-11 01:30:17	2026-10-11 01:01:49	USED	KEEP — primary key
host-323.report.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	29	337	0	62	2026-10-11 01:31:58	2026-10-11 01:01:50	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	470	0	62	2026-10-11 01:31:37	2026-10-11 01:01:52	USED	KEEP — primary key
host-323.report.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			75	0	0	137	2026-10-11 01:30:03	2026-10-11 01:01:53	USED	keep — in use
host-323.report.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	201	75	137	2026-10-11 01:30:07	2026-10-11 01:01:53	USED	KEEP — primary key
host-323.report.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	23	273	0	136	2026-10-11 01:32:02	2026-10-11 01:01:54	USED	KEEP — primary key
host-323.report.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	88	201	0	272	2026-10-11 01:31:35	2026-10-11 01:01:54	USED	KEEP — primary key
host-323.report.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	28	3817	0	2544	2026-10-11 01:31:36	2026-10-11 01:01:54	USED	KEEP — primary key
host-323.report.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	137	0	136	2026-10-11 01:31:47	2026-10-11 01:01:55	USED	KEEP — primary key
host-323.report.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	31	272	0	136	2026-10-11 01:31:58	2026-10-11 01:01:55	USED	KEEP — primary key
host-323.report.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	38	2124	0	274	2026-10-11 01:32:01	2026-10-11 01:01:55	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-11 01:01:56	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-11 01:01:57	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-11 01:01:57	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-11 01:02:20	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-11 01:02:20	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-11 01:02:20	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-11 01:02:21	USED	KEEP — primary key
host-707.dbo.PricingEntry.PK_ClaimQueue	1	CLUSTERED	Y	Y	355	152	0	392	2026-10-12 01:00:22	2026-10-11 01:02:22	USED	KEEP — primary key
host-707.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	3	0	502	2026-10-07 11:31:07	2026-10-12 01:02:12	USED	KEEP — primary key
host-707.dbo.SalesLine.PK_ContractMonthly	1	CLUSTERED	Y	Y	7425	7	0	3286	2026-10-12 01:00:10	2026-10-11 01:02:22	USED	KEEP — primary key
host-707.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	8	0	7552	2026-10-07 11:33:06	2026-10-12 01:02:12	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-11 01:02:22	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-11 01:02:22	USED	KEEP — primary key
host-707.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	5720	573	0	5720	2026-10-11 21:45:45	2026-10-11 01:02:22	USED	KEEP — primary key
host-707.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	1211	0	5720	2026-10-11 21:45:45	2026-10-12 01:02:12	USED	KEEP — primary key
host-707.dbo.Source.PK_QuotaDaily	1	CLUSTERED	Y	Y	0	148	0	0	2026-10-12 01:00:05	2026-10-11 01:02:23	USED	KEEP — primary key
host-888.app.Account.PK_SettlementResult	1	CLUSTERED	Y	Y	0	62	0	138	2026-06-27 01:02:01	2026-10-12 01:02:13	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	97	2026-06-27 01:02:00	2026-10-12 01:02:13	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-11 01:02:23	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-11 01:02:23	USED	KEEP — primary key
host-888.app.SalesLine.PK_PricingDetail	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-11 01:02:24	UNUSED	KEEP — primary key
host-888.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-11 01:02:24	UNUSED	KEEP — primary key
host-888.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-11 01:02:24	UNUSED	KEEP — primary key
host-888.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-11 01:02:24	UNUSED	KEEP — primary key
host-888.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-11 01:02:24	UNUSED	KEEP — primary key
host-888.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-11 01:02:24	UNUSED	KEEP — primary key
host-888.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-10-11 01:02:24	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-11 01:02:24	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-11 01:02:24	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-11 01:02:24	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-11 01:02:26	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-11 01:02:27	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-11 01:02:27	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-11 01:02:27	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-11 01:02:28	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-11 01:02:42	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-11 01:02:42	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-11 01:02:42	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-11 01:02:42	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-11 01:02:42	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-11 01:02:42	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-11 01:02:42	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-11 01:02:42	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-11 01:02:43	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	581	0	0	2026-10-12 01:00:07	2026-10-11 01:00:02	USED	KEEP — primary key
host-763.internal.TerritorySnapshot.PK_PayrollDaily	1	CLUSTERED	Y	Y	10729	1	0	0	2026-10-12 01:00:07	2026-10-11 01:00:02	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-11 01:00:02	UNUSED	KEEP — primary key
host-763.internal.PricingResult.IX_MeterSummary	2	NONCLUSTERED	Y		6700	16368	0	0	2026-10-12 01:00:06	2026-10-11 01:00:02	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	138	0	1872009	2026-10-12 00:00:00	2026-10-12 01:00:23	USED	keep — in use
host-763.internal.RouteLine.IX_QuotaQueue	2	NONCLUSTERED			138	0	0	1872009	2026-10-12 00:00:00	2026-10-12 01:00:28	USED	keep — in use
host-763.internal.RouteLine.PK_BatchResult	1	CLUSTERED	Y	Y	0	0	0	1872009	never	2026-10-11 01:05:59	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			138	138	0	926721	2026-10-12 00:00:00	2026-10-12 01:00:51	USED	keep — in use
host-763.internal.StaffingArchive.PK_TicketResult	1	CLUSTERED	Y	Y	1871895	0	0	926721	2026-10-12 01:00:24	2026-10-12 01:00:46	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			144	0	0	112246	2026-10-12 00:00:00	2026-10-12 01:00:55	USED	keep — in use
host-763.internal.SupplierLog.PK_ShiftLine	1	CLUSTERED	Y	Y	0	3	6	112246	2026-10-07 11:48:00	2026-10-12 01:00:54	USED	KEEP — primary key
host-763.internal.PricingAudit.PK_RouteSummary	1	CLUSTERED	Y	Y	112108	112113	0	2068	2026-10-12 01:00:24	2026-10-11 01:01:05	USED	KEEP — primary key
host-763.internal.BatchSnapshot.PK_StaffingSnapshot	1	CLUSTERED	Y	Y	0	4	0	138	2026-05-28 09:58:07	never	USED	KEEP — primary key
host-763.internal.BatchSnapshot.IX_BatchSnapshot	2	NONCLUSTERED			137	1	0	138	2026-10-12 00:00:00	never	USED	keep — in use
host-763.internal.MeterDaily.PK_ForecastStatus	1	CLUSTERED	Y	Y	0	138	0	138	2026-10-12 00:00:00	never	USED	KEEP — primary key
host-763.internal.StaffingSummary.PK_InvoiceStaging	1	CLUSTERED	Y	Y	0	697	0	138	2026-10-12 01:00:07	never	USED	KEEP — primary key
host-763.internal.CampaignDaily.IX_LedgerMonthly	2	NONCLUSTERED			2502	0	0	3489	2026-10-12 01:00:06	2026-10-12 01:00:56	USED	keep — in use
host-763.internal.CampaignDaily.IX_ClaimQueue	3	NONCLUSTERED			7133	0	0	3489	2026-10-12 01:00:07	2026-10-12 01:00:56	USED	keep — in use
host-763.internal.CampaignDaily.PK_PricingLine	1	CLUSTERED	Y	Y	3350	1	7823	9075	2026-10-12 01:00:07	2026-10-12 01:00:55	USED	KEEP — primary key
host-763.internal.WarehouseMonthly.IX_CampaignLine	2	NONCLUSTERED			137	1	0	138	2026-10-12 00:00:00	never	USED	keep — in use
host-763.internal.WarehouseMonthly.PK_TerritoryStatus	1	CLUSTERED	Y	Y	0	1118	0	138	2026-10-12 01:00:07	never	USED	KEEP — primary key
host-763.internal.executions.PK_TerritoryLog	1	CLUSTERED	Y	Y	118321	291	0	697	2026-10-12 01:00:27	2026-10-12 01:00:58	USED	KEEP — primary key
host-763.internal.InvoiceLine.PK_PayrollAudit	1	CLUSTERED	Y	Y	0	139	0	139	2026-10-12 00:00:00	never	USED	KEEP — primary key
host-763.internal.SettlementEntry.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	3466	5968	0	2026-10-12 01:00:06	never	USED	KEEP — primary key
host-763.internal.SettlementEntry.IX_PricingHistory	2	NONCLUSTERED	Y		5968	0	0	0	2026-10-12 01:00:06	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-11 01:01:07	USED	KEEP — primary key
host-763.internal.AssetSummary.IX_SalesLog	2	NONCLUSTERED	Y		1721	4	0	0	2026-10-12 01:00:06	2026-10-11 01:01:07	USED	keep — in use
host-763.internal.QuotaLog.PK_ClaimStatus	1	CLUSTERED	Y	Y	273	273	0	273	2026-10-11 15:34:58	never	USED	KEEP — primary key
host-763.internal.SalesQueue.PK_CustomerStaging	1	CLUSTERED	Y	Y	0	0	0	273	never	never	UNUSED	KEEP — primary key
host-763.internal.jobs.PK_AssetSummary	1	CLUSTERED	Y	Y	0	546	0	273	2026-10-11 15:34:58	never	USED	KEEP — primary key
host-763.internal.jobs.IX_MeterStaging	2	NONCLUSTERED			0	0	0	273	never	never	UNUSED	review, then DROP
host-763.internal.BillingLine.PK_StaffingStatus	1	CLUSTERED	Y	Y	546	0	0	273	2026-10-11 15:34:58	never	USED	KEEP — primary key
host-763.internal.ContractDetail.PK_ForecastLog	1	CLUSTERED	Y	Y	197287	0	0	197287	2026-10-12 01:04:01	2026-10-11 01:01:08	USED	KEEP — primary key
host-763.internal.AssetSnapshot.PK_CustomerSnapshot	1	CLUSTERED	Y	Y	397015	0	0	395279	2026-10-12 01:04:50	2026-10-11 01:01:08	USED	KEEP — primary key
host-763.internal.RouteAudit.IX_PayrollLog	2	NONCLUSTERED			1118	139	0	16507	2026-10-12 01:00:07	2026-10-11 01:01:08	USED	keep — in use
host-763.internal.RouteAudit.PK_BatchLine	1	CLUSTERED	Y	Y	0	2808	1118	16513	2026-10-12 01:00:07	2026-10-11 01:01:08	USED	KEEP — primary key
host-763.internal.BatchDetail.PK_BillingEntry	1	CLUSTERED	Y	Y	36314	430	0	156	2026-10-12 01:00:06	2026-10-11 01:01:09	USED	KEEP — primary key
host-763.internal.BatchLog.IX_ShiftLog	2	NONCLUSTERED			182	0	0	926722	2026-10-12 00:00:00	2026-10-12 01:01:08	USED	keep — in use
host-763.internal.BatchLog.PK_MeterStatus	1	CLUSTERED	Y	Y	926583	2	43	926722	2026-10-12 01:00:24	2026-10-12 01:01:06	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			1728	275	0	697	2026-10-12 01:00:27	2026-10-12 01:01:09	USED	keep — in use
host-763.internal.SalesEntry.PK_SupplierAudit	1	CLUSTERED	Y	Y	0	10	0	697	2026-05-28 11:00:16	2026-10-12 01:01:09	USED	KEEP — primary key
host-763.internal.InvoiceSnapshot.PK_PayrollArchive	1	CLUSTERED	Y	Y	0	322	19436	703	2026-10-12 01:00:27	2026-10-12 01:01:09	USED	KEEP — primary key
host-763.internal.InvoiceSnapshot.IX_ShipmentLog	2	NONCLUSTERED	Y		19436	138	0	703	2026-10-12 01:00:27	2026-10-12 01:01:09	USED	keep — in use
host-763.internal.operations.IX_RouteLine	2	NONCLUSTERED			0	39681	0	1540	2026-10-12 01:02:40	2026-10-12 01:01:10	USED	keep — in use
host-763.internal.operations.PK_RosterQueue	1	CLUSTERED	Y	Y	3821841	197	0	124376	2026-10-12 01:02:40	2026-10-12 01:01:09	USED	KEEP — primary key
host-763.internal.BatchLog.IX_LedgerDetail	2	NONCLUSTERED			560	287	0	155	2026-10-12 01:00:06	2026-10-11 01:01:20	USED	keep — in use
host-763.internal.BatchLog.PK_SupplierArchive	1	CLUSTERED	Y	Y	0	2	4	155	2026-05-28 10:40:11	2026-10-11 01:01:20	USED	KEEP — primary key
host-763.internal.TicketHeader.PK_ShipmentHistory	1	CLUSTERED	Y	Y	0	5962	0	0	2026-10-12 01:00:06	2026-10-11 01:01:20	USED	KEEP — primary key
host-763.internal.TicketHeader.IX_ShiftAudit	2	NONCLUSTERED	Y		5962	0	0	0	2026-10-12 01:00:06	2026-10-11 01:01:20	USED	keep — in use
host-763.internal.SettlementAudit.IX_CampaignHistory	3	NONCLUSTERED			1136	143	0	6	2026-10-12 01:00:06	2026-10-11 01:01:20	USED	keep — in use
host-763.internal.SettlementAudit.PK_CustomerLine	1	CLUSTERED	Y	Y	26655	20	11	6	2026-10-12 01:00:06	2026-10-11 01:01: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-11 01:01:20	USED	keep — in use
host-763.internal.tasks.PK_LedgerArchive	1	CLUSTERED	Y	Y	0	39817	0	39817	2026-10-12 01:02:40	never	USED	KEEP — primary key
host-763.internal.tasks.IX_SettlementEntry	2	NONCLUSTERED			0	546	0	39817	2026-10-11 15:34:58	never	USED	keep — in use
host-763.internal.tasks.IX_ShipmentEntry	3	NONCLUSTERED			0	0	0	39817	never	never	UNUSED	review, then DROP
host-763.internal.SalesDaily.PK_CatalogHistory	1	CLUSTERED	Y	Y	0	0	0	273	never	never	UNUSED	KEEP — primary key
host-763.internal.SalesDaily.IX_PolicySummary	2	NONCLUSTERED			0	0	0	273	never	never	UNUSED	review, then DROP
host-763.internal.QuotaLog.PK_RosterResult	1	CLUSTERED	Y	Y	0	138	0	138	2026-10-12 00:00:00	never	USED	KEEP — primary key
host-763.internal.ShipmentStaging.IX_WarehouseEntry	2	NONCLUSTERED			0	0	0	197287	never	never	UNUSED	review, then DROP
host-763.internal.ReconcileDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	592270	137	0	197696	2026-10-12 01:04:01	2026-10-11 01:01:20	USED	KEEP — primary key
TERRITORY.app.RosterDaily.PK_TicketAudit	1	CLUSTERED	Y	Y	58	150	0	20	2026-10-11 01:30:05	2026-10-11 01:03:56	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-11 01:03:56	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-11 01:03:56	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-11 01:03:56	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-11 01:03:56	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-11 01:03:57	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-11 01:03:57	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-11 01:03:57	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-11 01:03:57	USED	KEEP — primary key
TERRITORY.report.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	23	560	0	17	2026-10-11 01:30:07	2026-10-11 01:03:57	USED	KEEP — primary key
TERRITORY.report.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	67	276	0	17	2026-10-11 01:33:01	2026-10-11 01:03:57	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-11 01:03:57	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-11 01:03:57	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-11 01:03:57	USED	KEEP — primary key
TERRITORY.report.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	10	149	0	17	2026-10-11 01:30:02	2026-10-11 01:03:57	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-11 01:03:58	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-11 01:03:58	USED	KEEP — primary key
TERRITORY.report.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	17	139	0	17	2026-10-11 01:30:00	2026-10-11 01:03:58	USED	KEEP — primary key
TERRITORY.report.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	156	142	0	17	2026-10-11 01:30:02	2026-10-11 01:03:58	USED	KEEP — primary key
TERRITORY.report.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	17	142	0	17	2026-10-11 01:30:02	2026-10-11 01:03:58	USED	KEEP — primary key
TERRITORY.report.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	15	286	0	17	2026-10-11 01:30:05	2026-10-11 01:03:58	USED	KEEP — primary key
TERRITORY.report.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	14	283	0	17	2026-10-11 01:30:05	2026-10-11 01:03:58	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-11 01:03:58	USED	KEEP — primary key
TERRITORY.report.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	10	149	0	17	2026-10-11 01:30:05	2026-10-11 01:03:58	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-11 01:03:58	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-11 01:03:58	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-11 01:03:58	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-11 01:03:59	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-11 01:03:59	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-11 01:03:59	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-11 01:03:59	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-11 01:03:59	USED	KEEP — primary key
TERRITORY.report.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	10	717	0	17	2026-10-11 01:30:05	2026-10-11 01:03:59	USED	KEEP — primary key
TERRITORY.report.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	160	1160	0	17	2026-10-11 01:33:31	2026-10-11 01:03:59	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-11 01:04:00	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-11 01:04:00	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-11 01:04:01	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-11 01:04:01	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-11 01:04:01	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-11 01:04:01	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-11 01:04:01	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-11 01:04:01	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-11 01:04:01	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-11 01:04:01	USED	KEEP — primary key
TERRITORY.report.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	10	149	0	17	2026-10-11 01:30:05	2026-10-11 01:04:01	USED	KEEP — primary key
TERRITORY.report.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	20	420	0	17	2026-10-11 01:32:00	2026-10-11 01:04:01	USED	KEEP — primary key
TERRITORY.report.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	17	139	0	17	2026-10-11 01:30:00	2026-10-11 01:04:01	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-11 01:04:01	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-11 01:04:01	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-11 01:04:01	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-11 01:04:01	USED	KEEP — primary key
TERRITORY.report.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	24	416	0	17	2026-10-11 01:30:03	2026-10-11 01:04:01	USED	KEEP — primary key
TERRITORY.report.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	22	276	0	17	2026-10-11 01:30:02	2026-10-11 01:04:02	USED	KEEP — primary key
TERRITORY.report.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	17	142	0	17	2026-10-11 01:30:02	2026-10-11 01:04:02	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-11 01:04:02	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-11 01:04:02	USED	KEEP — primary key
TERRITORY.report.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	17	276	0	17	2026-10-11 01:33:01	2026-10-11 01:04:02	USED	KEEP — primary key
TERRITORY.report.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	17	139	0	18	2026-10-11 01:32:00	2026-10-11 01:04:02	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-11 01:04:02	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-11 01:04:02	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-11 01:04:02	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-11 01:04:02	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-11 01:04:02	USED	KEEP — primary key
TERRITORY.report.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	17	138	0	17	2026-10-11 01:33:01	2026-10-11 01:04:02	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-11 01:04:02	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-11 01:04:03	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-11 01:04:03	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-11 01:04:03	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-11 01:04:03	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-11 01:04:03	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-11 01:04:03	USED	KEEP — primary key
TERRITORY.report.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	17	138	0	17	2026-10-11 01:33:01	2026-10-11 01:04:03	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-11 01:04:04	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-11 01:04:04	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-11 01:04:06	USED	KEEP — primary key
TERRITORY.report.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	159	0	0	17	2026-10-11 01:30:02	2026-10-11 01:04:04	USED	KEEP — primary key
TERRITORY.report.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	378	86	0	68	2026-10-11 01:30:07	2026-10-11 01:04:04	USED	KEEP — primary key
TERRITORY.report.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	46	444	0	17	2026-10-11 01:30:03	2026-10-11 01:04:04	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-11 01:04:05	USED	KEEP — primary key
TERRITORY.report.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	12	190	0	17	2026-10-11 01:30:00	2026-10-11 01:04:05	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-11 01:04:06	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	349	0	139	2026-10-11 01:35:20	2026-10-11 01:04:06	USED	KEEP — primary key
TERRITORY.report.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	140	171	2	34	2026-10-11 01:35:19	2026-10-11 01:04:44	USED	KEEP — primary key
TERRITORY.report.ForecastLine.UX_ShiftQueue	10	NONCLUSTERED	Y		436	139	0	34	2026-10-11 01:33:01	2026-10-11 01:04:55	USED	keep — in use
TERRITORY.report.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	2	138	0	138	2026-10-11 01:32:24	2026-10-11 01:04:59	USED	KEEP — primary key
TERRITORY.report.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	16	155	0	32	2026-10-11 01:30:07	2026-10-11 01:04:59	USED	KEEP — primary key
TERRITORY.report.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	22	306	0	32	2026-10-11 01:30:25	2026-10-11 01:05:00	USED	KEEP — primary key
TERRITORY.report.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	29	295	0	32	2026-10-11 01:35:19	2026-10-11 01:05:00	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-11 01:05:01	USED	KEEP — primary key
TERRITORY.report.ShiftStaging.PK_RosterArchive	1	CLUSTERED	Y	Y	19	443	0	36	2026-10-11 01:33:01	2026-10-11 01:05:04	USED	KEEP — primary key
TERRITORY.report.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			93	0	0	138	2026-10-11 01:30:01	2026-10-11 01:05:05	USED	keep — in use
TERRITORY.report.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	187	93	138	2026-10-11 01:30:05	2026-10-11 01:05:05	USED	KEEP — primary key
TERRITORY.report.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	0	276	0	138	2026-10-11 01:35:21	2026-10-11 01:05:05	USED	KEEP — primary key
TERRITORY.report.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	109	169	0	276	2026-10-11 01:33:01	2026-10-11 01:05:05	USED	KEEP — primary key
TERRITORY.report.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	3	2484	0	1656	2026-10-11 01:33:01	2026-10-11 01:05:05	USED	KEEP — primary key
TERRITORY.report.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	138	0	138	2026-10-11 01:35:15	2026-10-11 01:05:06	USED	KEEP — primary key
TERRITORY.report.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	0	276	0	138	2026-10-11 01:35:19	2026-10-11 01:05:06	USED	KEEP — primary key
TERRITORY.report.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	45	961	0	278	2026-10-11 01:35:20	2026-10-11 01:05:06	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-11 01:05:06	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-11 01:05:07	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-11 01:05:07	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-11 01:05:07	USED	KEEP — primary key
TERRITORY.report.AssetLine.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	17	0	11	2026-06-13 05:29:09	2026-10-11 01:05:07	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-11 01:05:07	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-11 01:05:17	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-11 01:05:17	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-11 01:05:18	USED	KEEP — primary key
TERRITORY.report.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	34	0	111588	2026-06-13 05:29:33	2026-10-11 01:05:19	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-11 01:05:20	USED	KEEP — primary key
CUSTOMER.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	43	never	2026-10-11 01:05:21	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-11 01:05:21	USED	KEEP — primary key
CUSTOMER.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	0	0	3224	never	2026-10-11 01:05:21	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-11 01:05:21	USED	KEEP — primary key
CUSTOMER.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	0	0	3019	never	2026-10-11 01:05:21	UNUSED	KEEP — primary key
CUSTOMER.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	16457	1646	0	16457	2026-10-11 23:27:06	2026-10-11 01:05:21	USED	KEEP — primary key
CUSTOMER.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	170	0	16457	2026-10-07 11:27:06	2026-10-12 01:04:09	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-11 01:05:21	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-11 01:05:23	UNUSED	KEEP — primary key
CAMPAIGN.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-11 01:05:23	UNUSED	KEEP — primary key
CAMPAIGN.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-11 01:05:23	UNUSED	KEEP — primary key
CAMPAIGN.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-11 01:05:23	UNUSED	KEEP — primary key
CAMPAIGN.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-11 01:05:23	UNUSED	KEEP — primary key
CAMPAIGN.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-11 01:05:23	UNUSED	KEEP — primary key
CAMPAIGN.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-10-11 01:05:23	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-11 01:05:24	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-11 01:05:31	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-11 01:05:31	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-11 01:05:58	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	34	961	0	17	2026-10-11 02:15:12	2026-10-11 01:02:44	USED	KEEP — primary key
TERRITORY.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	36	0	0	17	2026-10-03 14:14:49	2026-10-11 01:02:44	USED	KEEP — primary key
TERRITORY.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	36	0	0	17	2026-10-03 14:14:49	2026-10-11 01:02:44	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-11 01:02:44	USED	KEEP — primary key
TERRITORY.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	19	17	0	17	2026-10-03 14:14:49	2026-10-11 01:02:44	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-11 01:02:44	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-11 01:02:44	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	34	0	0	17	2026-10-03 14:14:49	2026-10-11 01:02:44	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-11 01:02:44	USED	KEEP — primary key
TERRITORY.report.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	1934	1097	0	17	2026-10-11 02:15:12	2026-10-11 01:02:44	USED	KEEP — primary key
TERRITORY.report.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	38	274	0	17	2026-10-11 02:16:33	2026-10-11 01:02:44	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-11 01:02:44	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-11 01:02:44	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-11 01:02:44	USED	KEEP — primary key
TERRITORY.report.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	15	961	0	17	2026-10-11 02:15:11	2026-10-11 01:02:44	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-11 01:02:45	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-11 01:02:45	USED	KEEP — primary key
TERRITORY.report.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	17	137	0	17	2026-10-11 02:15:00	2026-10-11 01:02:45	USED	KEEP — primary key
TERRITORY.report.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	154	959	0	17	2026-10-11 02:15:11	2026-10-11 01:02:45	USED	KEEP — primary key
TERRITORY.report.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	17	959	0	17	2026-10-11 02:15:11	2026-10-11 01:02:45	USED	KEEP — primary key
TERRITORY.report.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	1385	550	0	17	2026-10-11 02:15:12	2026-10-11 01:02:45	USED	KEEP — primary key
TERRITORY.report.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	700	413	0	17	2026-10-11 02:15:12	2026-10-11 01:02:45	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-11 01:02:45	USED	KEEP — primary key
TERRITORY.report.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	15	961	0	17	2026-10-11 02:15:12	2026-10-11 01:02:45	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-11 01:02:45	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-11 01:02:45	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-11 01:02:45	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-11 01:02:45	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-11 01:02:45	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-11 01:02:45	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-11 01:02:45	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-11 01:02:46	USED	KEEP — primary key
TERRITORY.report.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	15	4797	0	17	2026-10-11 02:15:12	2026-10-11 01:02:46	USED	KEEP — primary key
TERRITORY.report.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	1658	1256	0	17	2026-10-11 02:16:36	2026-10-11 01:02:46	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-11 01:02:46	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-11 01:02:47	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-11 01:02:47	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-11 01:02:47	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-11 01:02:47	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-11 01:02:47	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-11 01:02:47	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-11 01:02:47	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-11 01:02:47	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-11 01:02:47	USED	KEEP — primary key
TERRITORY.report.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	15	961	0	17	2026-10-11 02:15:12	2026-10-11 01:02:47	USED	KEEP — primary key
TERRITORY.report.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	22	415	0	17	2026-10-11 02:15:55	2026-10-11 01:02:47	USED	KEEP — primary key
TERRITORY.report.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	17	137	0	17	2026-10-11 02:15:00	2026-10-11 01:02:47	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-11 01:02:47	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-11 01:02:47	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-11 01:02:47	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-11 01:02:47	USED	KEEP — primary key
TERRITORY.report.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	428	1644	0	17	2026-10-11 02:15:12	2026-10-11 01:02:48	USED	KEEP — primary key
TERRITORY.report.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	154	959	0	17	2026-10-11 02:15:12	2026-10-11 01:02:48	USED	KEEP — primary key
TERRITORY.report.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	17	959	0	17	2026-10-11 02:15:11	2026-10-11 01:02:48	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-11 01:02:48	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-11 01:02:48	USED	KEEP — primary key
TERRITORY.report.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	17	274	0	17	2026-10-11 02:16:14	2026-10-11 01:02:48	USED	KEEP — primary key
TERRITORY.report.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	17	137	0	17	2026-10-11 02:15:55	2026-10-11 01:02:48	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-11 01:02:48	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-11 01:02:48	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-11 01:02:48	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-11 01:02:48	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-11 01:02:48	USED	KEEP — primary key
TERRITORY.report.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	17	137	0	17	2026-10-11 02:16:33	2026-10-11 01:02:48	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-11 01:02:48	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-11 01:02:53	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-11 01:02:53	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-11 01:02:53	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-11 01:02:53	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-11 01:02:53	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-11 01:02:53	USED	KEEP — primary key
TERRITORY.report.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	17	137	0	17	2026-10-11 02:16:14	2026-10-11 01:02:56	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-11 01:02:56	USED	KEEP — primary key
TERRITORY.report.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	17	19	0	17	2026-10-03 14:14:49	2026-10-11 01:02:56	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-11 01:02:57	USED	KEEP — primary key
TERRITORY.report.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	976	0	0	17	2026-10-11 02:15:11	2026-10-11 01:02:56	USED	KEEP — primary key
TERRITORY.report.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	1005	223	0	68	2026-10-11 02:15:12	2026-10-11 01:02:56	USED	KEEP — primary key
TERRITORY.report.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	25	2064	0	17	2026-10-11 02:15:12	2026-10-11 01:02:56	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-11 01:02:57	USED	KEEP — primary key
TERRITORY.report.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	17	156	0	17	2026-10-11 02:15:00	2026-10-11 01:02:57	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-11 01:02:57	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	687	457	0	959	2026-10-11 02:16:51	2026-10-11 01:02:57	USED	KEEP — primary key
TERRITORY.report.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	17	171	2	34	2026-10-11 02:16:15	2026-10-11 01:03:07	USED	KEEP — primary key
TERRITORY.report.ForecastLine.UX_ShiftQueue	8	NONCLUSTERED	Y		555	137	0	34	2026-10-11 02:16:51	2026-10-11 01:03:11	USED	keep — in use
TERRITORY.report.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	2	137	0	137	2026-10-11 02:15:59	2026-10-11 01:03:23	USED	KEEP — primary key
TERRITORY.report.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	30	158	0	34	2026-10-11 02:15:12	2026-10-11 01:03:27	USED	KEEP — primary key
TERRITORY.report.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	23	307	0	34	2026-10-11 02:15:21	2026-10-11 01:03:28	USED	KEEP — primary key
TERRITORY.report.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	34	291	0	34	2026-10-11 02:16:51	2026-10-11 01:03:29	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-11 01:03:29	USED	KEEP — primary key
TERRITORY.report.ShiftStaging.PK_RosterArchive	1	CLUSTERED	Y	Y	17	444	0	34	2026-10-11 02:16:33	2026-10-11 01:03:29	USED	KEEP — primary key
TERRITORY.report.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			778	0	0	137	2026-10-11 02:15:12	2026-10-11 01:03:30	USED	keep — in use
TERRITORY.report.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	318	778	137	2026-10-11 02:15:12	2026-10-11 01:03:30	USED	KEEP — primary key
TERRITORY.report.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	3	274	0	137	2026-10-11 02:16:51	2026-10-11 01:03:30	USED	KEEP — primary key
TERRITORY.report.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	105	171	0	274	2026-10-11 02:16:33	2026-10-11 01:03:31	USED	KEEP — primary key
TERRITORY.report.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	4	2466	0	1644	2026-10-11 02:16:33	2026-10-11 01:03:31	USED	KEEP — primary key
TERRITORY.report.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	137	0	137	2026-10-11 02:16:44	2026-10-11 01:03:31	USED	KEEP — primary key
TERRITORY.report.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	4	274	0	137	2026-10-11 02:16:51	2026-10-11 01:03:31	USED	KEEP — primary key
TERRITORY.report.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	17	1609	0	274	2026-10-11 02:16:51	2026-10-11 01:03:31	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-11 01:03:32	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-11 01:03:32	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-11 01:03:32	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-11 01:03:32	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-11 01:03:32	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-11 01:03:33	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-11 01:03:49	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-11 01:03:50	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-11 01:03:50	USED	KEEP — primary key
TERRITORY.report.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	34	0	21946	2026-06-13 02:03:03	2026-10-11 01:03:51	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-11 01:03:52	USED	KEEP — primary key
SUPPLIER.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	54	never	2026-10-11 01:03:52	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-11 01:03:52	USED	KEEP — primary key
SUPPLIER.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	0	0	3018	never	2026-10-11 01:03:52	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-11 01:03:52	USED	KEEP — primary key
SUPPLIER.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	0	0	2992	never	2026-10-11 01:03:52	UNUSED	KEEP — primary key
SUPPLIER.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	47230	4723	0	47230	2026-10-12 01:04:02	2026-10-11 01:03:52	USED	KEEP — primary key
SUPPLIER.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	2911	0	47230	2026-09-29 19:04:00	2026-10-12 01:02:43	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-11 01:03:53	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-11 01:03:53	UNUSED	KEEP — primary key
INVOICE.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-11 01:03:54	UNUSED	KEEP — primary key
INVOICE.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-11 01:03:54	UNUSED	KEEP — primary key
INVOICE.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-11 01:03:54	UNUSED	KEEP — primary key
INVOICE.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-11 01:03:54	UNUSED	KEEP — primary key
INVOICE.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-11 01:03:54	UNUSED	KEEP — primary key
INVOICE.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-10-11 01:03:54	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