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

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

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

Host: 203.0.113.170

Collected: 2026-09-11T18:04:56Z

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

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

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

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

By database

Database	Total	Cold	Droppable	Recommend action
SUPPLIER	19	19	9	review the drop candidates above
PAYROLL	75	9	7	review the drop candidates above
SETTLEMENT	6	6	3	review the drop candidates above
SALES	8	8	0	no action — cold indexes here are constraints or clustered
CAMPAIGN	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
PAYROLL.audit.ShipmentStaging.IX_WarehouseEntry	154093	never	UNUSED	review, then DROP
PAYROLL.audit.tasks.IX_ShipmentEntry	31117	never	UNUSED	review, then DROP
PAYROLL.audit.jobs.IX_MeterStaging	213	never	UNUSED	review, then DROP
PAYROLL.audit.SalesDaily.IX_PolicySummary	213	never	UNUSED	review, then DROP
PAYROLL.audit.PayrollSnapshot.IX_ReconcileHistory	0	never	COLD	review, then DROP
SUPPLIER.dbo.BookingMonthly.IX_PricingLog	0	never	COLD	review, then DROP
SUPPLIER.dbo.ShipmentHistory.IX_LedgerStatus	0	never	COLD	review, then DROP
SUPPLIER.dbo.ShipmentHistory.IX_SalesEntry	0	never	COLD	review, then DROP
SUPPLIER.dbo.PricingHistory.IX_LedgerHeader	0	never	COLD	review, then DROP
SUPPLIER.dbo.MeterLog.IX_BatchQueue	0	never	COLD	review, then DROP
SUPPLIER.dbo.PricingArchive.IX_BillingSnapshot	0	never	COLD	review, then DROP
SUPPLIER.dbo.BatchHistory.IX_StaffingStaging	0	never	COLD	review, then DROP
SUPPLIER.dbo.OrdersStatus.IX_PricingResult	0	never	COLD	review, then DROP
SUPPLIER.dbo.BillingMonthly.IX_SettlementEntry	0	never	COLD	review, then DROP
SETTLEMENT.dbo.OrdersResult.IX_StaffingDetail	0	never	COLD	review, then DROP
SETTLEMENT.dbo.OrdersResult.IX_ContractArchive	0	never	COLD	review, then DROP
SETTLEMENT.dbo.OrdersResult.IX_ClaimArchive	0	never	COLD	review, then DROP
PAYROLL.audit.RouteEntry.IX_ClaimSnapshot	0	never	COLD	review, then DROP
PAYROLL.audit.ShiftSummary.IX_BookingHeader	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
SUPPLIER\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
SALES.dbo.LedgerLog.PK_OrdersDetail	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.CustomerLog.PK_ForecastSummary	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-10-24 13:45:54	COLD	KEEP — primary key
SALES.dbo.ClaimResult.PK_LedgerResult	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ShiftDetail.PK_WarehouseMonthly	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.TicketHistory.PK_MeterHeader	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.node.PK_BookingSnapshot	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ShipmentQueue.PK_LedgerSummary	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-10-24 13:45:56	COLD	KEEP — primary key
SALES.dbo.ClaimArchive.PK_PayrollSnapshot	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER.dbo.BookingMonthly.IX_PricingLog	2	NONCLUSTERED			0	0	0	0	never	2025-10-24 13:45:54	COLD	review, then DROP
SUPPLIER.dbo.BookingMonthly.PK_CatalogArchive	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER.dbo.ShipmentHistory.IX_LedgerStatus	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
SUPPLIER.dbo.ShipmentHistory.IX_SalesEntry	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
SUPPLIER.dbo.ShipmentHistory.PK_SalesEntry	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER.dbo.ClaimMonthly.PK_CatalogAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER.dbo.PricingHistory.IX_LedgerHeader	2	NONCLUSTERED			0	0	0	0	never	2026-03-11 10:53:18	COLD	review, then DROP
SUPPLIER.dbo.PricingHistory.PK_PolicyDaily	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-10-24 14:05:34	COLD	KEEP — primary key
SUPPLIER.dbo.ShiftLog.PK_PolicyStaging	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER.dbo.MeterLog.IX_BatchQueue	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
SUPPLIER.dbo.MeterLog.PK_SettlementEntry	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER.dbo.PricingArchive.IX_BillingSnapshot	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
SUPPLIER.dbo.PricingArchive.PK_SettlementDaily	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER.dbo.BatchHistory.IX_StaffingStaging	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
SUPPLIER.dbo.BatchHistory.PK_TicketStatus	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER.dbo.OrdersStatus.IX_PricingResult	2	NONCLUSTERED			0	0	0	0	never	2025-10-24 13:45:54	COLD	review, then DROP
SUPPLIER.dbo.OrdersStatus.PK_SupplierSnapshot	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER.dbo.BillingMonthly.IX_SettlementEntry	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
SUPPLIER.dbo.BillingMonthly.PK_SettlementEntry	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.dbo.OrdersResult.IX_QuotaSnapshot	5	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
SETTLEMENT.dbo.OrdersResult.IX_StaffingDetail	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
SETTLEMENT.dbo.OrdersResult.IX_ContractArchive	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
SETTLEMENT.dbo.OrdersResult.IX_ClaimArchive	4	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
SETTLEMENT.dbo.OrdersResult.PK_StaffingStatus	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.dbo.ReconcileLine.PK_ClaimArchive	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
CAMPAIGN.app.RosterDaily.PK_TicketAudit	1	CLUSTERED	Y	Y	220	111	0	32	2026-09-11 01:30:09	2026-09-06 01:01:10	USED	KEEP — primary key
CAMPAIGN.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	219	0	0	32	2026-09-10 17:08:32	2026-09-06 01:01:10	USED	KEEP — primary key
CAMPAIGN.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	219	0	0	32	2026-09-10 17:08:32	2026-09-06 01:01:10	USED	KEEP — primary key
CAMPAIGN.app.SalesSummary.PK_OrdersAudit	1	CLUSTERED	Y	Y	0	32	0	32	2026-06-27 01:02:00	2026-09-06 01:01:10	USED	KEEP — primary key
CAMPAIGN.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	187	32	0	32	2026-09-10 17:08:32	2026-09-06 01:01:10	USED	KEEP — primary key
CAMPAIGN.app.SettlementEntry.PK_TicketQueue	1	CLUSTERED	Y	Y	0	32	0	32	2026-06-27 01:02:00	2026-09-06 01:01:10	USED	KEEP — primary key
CAMPAIGN.app.BatchQueue.PK_LedgerResult	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:00	2026-09-06 01:01:10	USED	KEEP — primary key
CAMPAIGN.dbo.AssetSnapshot.PK_PayrollHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CAMPAIGN.STAFFING.ContractSnapshot.PK_ContractResult	1	CLUSTERED	Y	Y	205	0	0	32	2026-09-10 17:08:33	2026-09-06 01:01:10	USED	KEEP — primary key
CAMPAIGN.STAFFING.PolicyHistory.PK_TicketAudit	1	CLUSTERED	Y	Y	32	32	0	32	2026-06-27 01:02:20	2026-09-06 01:01:10	USED	KEEP — primary key
CAMPAIGN.STAFFING.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	29	434	0	32	2026-09-11 01:30:12	2026-09-06 01:01:10	USED	KEEP — primary key
CAMPAIGN.STAFFING.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	233	213	0	32	2026-09-11 01:34:48	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.AssetLine.PK_ContractDetail	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:08	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.TicketAudit.PK_PricingLog	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignQueue.PK_InvoiceMonthly	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	23	117	0	32	2026-09-11 01:30:03	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.BatchLog.PK_SalesMonthly	1	CLUSTERED	Y	Y	0	32	0	32	2026-06-27 01:02:23	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.TicketMonthly.PK_SupplierLine	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:17	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	32	107	0	32	2026-09-11 01:30:00	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	139	108	0	32	2026-09-11 01:30:03	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	32	108	0	32	2026-09-11 01:30:03	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	15	233	0	32	2026-09-11 01:30:09	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	20	227	0	32	2026-09-11 01:30:09	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.WarehouseStatus.PK_MeterResult	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:24	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	30	110	0	32	2026-09-11 01:30:09	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.CustomerStatus.PK_SalesDetail	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:24	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterStatus.PK_OrdersLog	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:25	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.QuotaQueue.PK_BookingQueue	1	CLUSTERED	Y	Y	1	32	0	32	2026-06-27 01:02:25	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CatalogSummary.PK_AssetLog	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:19	2026-09-06 01:01:11	USED	KEEP — primary key
CAMPAIGN.STAFFING.TicketHeader.PK_PolicyResult	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:23	2026-09-06 01:01:12	USED	KEEP — primary key
CAMPAIGN.STAFFING.RouteHeader.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:32	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PolicyHistory.PK_CampaignQueue	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:29	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ForecastHistory.PK_SupplierHistory	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:24	2026-09-06 01:01:12	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	16	556	0	32	2026-09-11 01:30:08	2026-09-06 01:01:12	USED	KEEP — primary key
CAMPAIGN.STAFFING.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	55	1129	0	32	2026-09-11 01:36:42	2026-09-06 01:01:12	USED	KEEP — primary key
CAMPAIGN.STAFFING.TicketLine.PK_CustomerEntry	1	CLUSTERED	Y	Y	0	31	0	31	2026-06-26 01:02:51	2026-09-06 01:01:13	USED	KEEP — primary key
CAMPAIGN.STAFFING.AssetSnapshot.PK_SalesAudit	1	CLUSTERED	Y	Y	29	56	0	31	2026-09-04 08:38:31	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterAudit.PK_ShiftEntry	1	CLUSTERED	Y	Y	10	22	0	32	2026-06-27 01:02:25	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.PolicyEntry.PK_RouteResult	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:24	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.SalesEntry.PK_WarehouseMonthly	1	CLUSTERED	Y	Y	31	1	0	32	2026-06-27 01:02:25	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterArchive.PK_LedgerStatus	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.StaffingHistory.PK_ShipmentArchive	1	CLUSTERED	Y	Y	14	18	0	32	2026-06-27 01:02:20	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.BookingQueue.PK_AssetHeader	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:03	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShiftDaily.PK_ClaimAudit	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:03	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.InvoiceAudit.PK_PolicyDaily	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:08	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	28	112	0	32	2026-09-11 01:30:09	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	58	347	0	32	2026-09-11 01:32:24	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	32	107	0	32	2026-09-11 01:30:00	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShiftMonthly.PK_PricingArchive	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:03	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.ContractMonthly.PK_CustomerDaily	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:03	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.SalesAudit.PK_BatchArchive	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:12	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterSnapshot.PK_StaffingQueue	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:03	2026-09-06 01:01:14	USED	KEEP — primary key
CAMPAIGN.STAFFING.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	31	324	0	32	2026-09-11 01:30:06	2026-09-06 01:01:15	USED	KEEP — primary key
CAMPAIGN.STAFFING.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	31	216	0	32	2026-09-11 01:30:05	2026-09-06 01:01:15	USED	KEEP — primary key
CAMPAIGN.STAFFING.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	32	108	0	32	2026-09-11 01:30:03	2026-09-06 01:01:15	USED	KEEP — primary key
CAMPAIGN.STAFFING.ReconcileHistory.PK_StaffingDaily	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:09	2026-09-06 01:01:15	USED	KEEP — primary key
CAMPAIGN.STAFFING.ClaimDetail.PK_RosterLog	1	CLUSTERED	Y	Y	28	3	0	31	2026-06-26 01:02:51	2026-09-06 01:01:15	USED	KEEP — primary key
CAMPAIGN.STAFFING.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	24	219	0	31	2026-09-11 01:34:23	2026-09-06 01:01:16	USED	KEEP — primary key
CAMPAIGN.STAFFING.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	9	128	0	31	2026-09-11 01:32:24	2026-09-06 01:01:17	USED	KEEP — primary key
CAMPAIGN.STAFFING.InvoiceHistory.PK_StaffingQueue	1	CLUSTERED	Y	Y	31	0	0	31	2026-06-26 01:02:51	2026-09-06 01:01:17	USED	KEEP — primary key
CAMPAIGN.STAFFING.BookingDetail.PK_RosterResult	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	2026-09-06 01:01:17	USED	KEEP — primary key
CAMPAIGN.STAFFING.QuotaSummary.PK_RosterStatus	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	2026-09-06 01:01:17	USED	KEEP — primary key
CAMPAIGN.STAFFING.WarehouseEntry.PK_ShiftDetail	1	CLUSTERED	Y	Y	6	25	0	31	2026-06-26 01:02:51	2026-09-06 01:01:17	USED	KEEP — primary key
CAMPAIGN.STAFFING.RosterSummary.PK_PricingMonthly	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:04	2026-09-06 01:01:17	USED	KEEP — primary key
CAMPAIGN.STAFFING.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	32	106	0	32	2026-09-11 01:34:47	2026-09-06 01:01:17	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignQueue.PK_PayrollEntry	1	CLUSTERED	Y	Y	31	0	0	31	2026-06-26 01:03:02	2026-09-06 01:01:17	USED	KEEP — primary key
CAMPAIGN.STAFFING.ClaimStaging.PK_SupplierHeader	1	CLUSTERED	Y	Y	23	8	0	31	2026-06-26 01:03:00	2026-09-06 01:01:19	USED	KEEP — primary key
CAMPAIGN.STAFFING.PayrollMonthly.PK_MeterSnapshot	1	CLUSTERED	Y	Y	0	31	0	31	2026-06-26 01:03:01	2026-09-06 01:01:19	USED	KEEP — primary key
CAMPAIGN.STAFFING.StaffingQueue.PK_CatalogLine	1	CLUSTERED	Y	Y	31	0	0	31	2026-06-26 01:03:01	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.RosterEntry.PK_BookingStatus	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:13	2026-09-06 01:01:19	USED	KEEP — primary key
CAMPAIGN.STAFFING.AssetStatus.PK_TicketEntry	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:11	2026-09-06 01:01:19	USED	KEEP — primary key
CAMPAIGN.STAFFING.AssetLine.PK_ForecastSummary	1	CLUSTERED	Y	Y	31	0	0	31	2026-06-26 01:02:58	2026-09-06 01:01:19	USED	KEEP — primary key
CAMPAIGN.STAFFING.TicketQueue.PK_CatalogAudit	1	CLUSTERED	Y	Y	31	0	0	31	2026-06-26 01:02:59	2026-09-06 01:01:19	USED	KEEP — primary key
CAMPAIGN.STAFFING.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	6	131	0	31	2026-09-11 01:34:23	2026-09-06 01:01:21	USED	KEEP — primary key
CAMPAIGN.STAFFING.CustomerLog.PK_BillingEntry	1	CLUSTERED	Y	Y	37	9	0	32	2026-07-01 11:43:06	2026-09-06 01:01:21	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	32	187	0	32	2026-09-10 17:08:32	2026-09-06 01:01:21	USED	KEEP — primary key
CAMPAIGN.STAFFING.LedgerStaging.PK_ForecastEntry	1	CLUSTERED	Y	Y	24	8	0	32	2026-06-27 01:02:23	2026-09-06 01:01:23	USED	KEEP — primary key
CAMPAIGN.STAFFING.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	140	0	0	32	2026-09-11 01:30:03	2026-09-06 01:01:21	USED	KEEP — primary key
CAMPAIGN.STAFFING.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	417	308	0	128	2026-09-11 01:30:12	2026-09-06 01:01:21	USED	KEEP — primary key
CAMPAIGN.STAFFING.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	36	492	0	32	2026-09-11 01:30:06	2026-09-06 01:01:22	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShiftSnapshot.PK_BillingResult	1	CLUSTERED	Y	Y	1	35	0	35	2026-06-30 01:01:17	2026-09-06 01:01:22	USED	KEEP — primary key
CAMPAIGN.STAFFING.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	20	309	0	34	2026-09-11 01:30:00	2026-09-06 01:01:22	USED	KEEP — primary key
CAMPAIGN.STAFFING.CustomerStatus.PK_PayrollLog	1	CLUSTERED	Y	Y	32	0	0	32	2026-06-27 01:02:10	2026-09-06 01:01:23	USED	KEEP — primary key
CAMPAIGN.STAFFING.ForecastSummary.PK_BatchQueue	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CAMPAIGN.STAFFING.MeterHistory.PK_LedgerQueue	1	CLUSTERED	Y	Y	46	610	0	108	2026-09-11 01:37:13	2026-09-06 01:01:23	USED	KEEP — primary key
CAMPAIGN.STAFFING.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	31	172	9	62	2026-09-11 01:34:39	2026-09-06 01:01:33	USED	KEEP — primary key
CAMPAIGN.STAFFING.ForecastLine.UX_ShiftQueue	2	NONCLUSTERED	Y		460	107	0	62	2026-09-11 01:37:10	2026-09-06 01:01:36	USED	keep — in use
CAMPAIGN.STAFFING.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	14	106	0	106	2026-09-11 01:32:43	2026-09-06 01:01:52	USED	KEEP — primary key
CAMPAIGN.STAFFING.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	31	160	0	62	2026-09-11 01:30:13	2026-09-06 01:02:00	USED	KEEP — primary key
CAMPAIGN.STAFFING.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	58	287	0	62	2026-09-11 01:30:28	2026-09-06 01:02:03	USED	KEEP — primary key
CAMPAIGN.STAFFING.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	29	276	0	62	2026-09-11 01:37:10	2026-09-06 01:02:04	USED	KEEP — primary key
CAMPAIGN.STAFFING.SettlementHeader.PK_CatalogHistory	1	CLUSTERED	Y	Y	31	62	0	62	2026-06-26 01:06:04	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShiftStaging.PK_RosterArchive	1	CLUSTERED	Y	Y	32	379	0	62	2026-09-11 01:34:49	2026-09-06 01:02:06	USED	KEEP — primary key
CAMPAIGN.STAFFING.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			45	0	0	107	2026-09-11 01:30:03	2026-09-06 01:02:07	USED	keep — in use
CAMPAIGN.STAFFING.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	170	45	107	2026-09-11 01:30:09	2026-09-06 01:02:07	USED	KEEP — primary key
CAMPAIGN.STAFFING.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	18	212	0	106	2026-09-11 01:37:15	2026-09-06 01:02:08	USED	KEEP — primary key
CAMPAIGN.STAFFING.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	56	170	0	212	2026-09-11 01:34:39	2026-09-06 01:02:31	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	20	3129	0	2086	2026-09-11 01:34:49	2026-09-06 01:02:31	USED	KEEP — primary key
CAMPAIGN.STAFFING.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	106	0	106	2026-09-11 01:36:47	2026-09-06 01:02:32	USED	KEEP — primary key
CAMPAIGN.STAFFING.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	21	212	0	106	2026-09-11 01:37:09	2026-09-06 01:02:32	USED	KEEP — primary key
CAMPAIGN.STAFFING.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	33	1712	0	214	2026-09-11 01:37:13	2026-09-06 01:02:32	USED	KEEP — primary key
CAMPAIGN.STAFFING.BatchStaging.PK_CampaignHeader	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-27 01:02:20	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CustomerDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	0	32	0	895	2026-06-27 01:02:23	2026-09-06 01:02:33	USED	KEEP — primary key
CAMPAIGN.STAFFING.PolicyEntry.PK_QuotaMonthly	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-27 01:02:24	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterEntry.PK_RosterStatus	1	CLUSTERED	Y	Y	0	32	0	1078	2026-06-27 01:02:24	2026-09-12 01:01:46	USED	KEEP — primary key
CAMPAIGN.STAFFING.AssetLine.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-27 01:02:24	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.SupplierHeader.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	31	0	172	2026-06-26 01:03:02	2026-09-12 01:02:03	USED	KEEP — primary key
CAMPAIGN.STAFFING.SupplierResult.PK_StaffingDaily	1	CLUSTERED	Y	Y	0	31	0	16132	2026-06-26 01:03:00	2026-09-12 01:02:06	USED	KEEP — primary key
CAMPAIGN.STAFFING.BookingResult.PK_ClaimLog	1	CLUSTERED	Y	Y	0	31	0	0	2026-06-26 01:03:01	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.InvoiceEntry.PK_ForecastLine	1	CLUSTERED	Y	Y	0	31	0	0	2026-06-26 01:03:01	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ReconcileLog.PK_CampaignQueue	1	CLUSTERED	Y	Y	0	31	0	0	2026-06-26 01:02:58	2026-09-06 01:02:39	USED	KEEP — primary key
CAMPAIGN.STAFFING.OrdersArchive.PK_ContractAudit	1	CLUSTERED	Y	Y	0	31	0	0	2026-06-26 01:02:59	2026-09-06 01:02:39	USED	KEEP — primary key
CAMPAIGN.STAFFING.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	64	0	3075	2026-06-27 01:02:28	2026-09-12 01:02:07	USED	KEEP — primary key
PAYROLL.dbo.PricingEntry.PK_ClaimQueue	1	CLUSTERED	Y	Y	265	120	0	302	2026-09-12 01:00:38	2026-09-06 01:02:41	USED	KEEP — primary key
PAYROLL.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	382	never	2026-09-12 01:02:08	UNUSED	KEEP — primary key
PAYROLL.dbo.SalesLine.PK_ContractMonthly	1	CLUSTERED	Y	Y	7305	4	0	3256	2026-09-12 01:00:16	2026-09-06 01:02:41	USED	KEEP — primary key
PAYROLL.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	5	0	7192	2026-05-27 17:08:46	2026-09-12 01:02:08	USED	KEEP — primary key
PAYROLL.dbo.RosterQueue.PK_TerritoryDaily	1	CLUSTERED	Y	Y	5937	9	0	2801	2026-06-30 01:01:22	2026-09-06 01:02:41	USED	KEEP — primary key
PAYROLL.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	0	0	5602	never	2026-09-06 01:02:42	UNUSED	KEEP — primary key
PAYROLL.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	4420	442	0	4420	2026-09-11 20:19:41	2026-09-06 01:02:42	USED	KEEP — primary key
PAYROLL.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	250	0	4420	2026-09-06 20:19:21	2026-09-12 01:02:08	USED	KEEP — primary key
PAYROLL.dbo.Source.PK_QuotaDaily	1	CLUSTERED	Y	Y	0	118	0	0	2026-09-12 01:00:10	2026-09-06 01:02:42	USED	KEEP — primary key
LEDGER.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y	0	62	0	108	2026-06-27 01:02:01	2026-09-12 01:02:09	USED	KEEP — primary key
LEDGER.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y	0	64	0	1	2026-06-27 01:02:01	never	USED	KEEP — primary key
LEDGER.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y	0	64	0	67	2026-06-27 01:02:00	2026-09-12 01:02:15	USED	KEEP — primary key
LEDGER.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y	32	64	0	7	2026-06-27 01:02:00	2026-09-06 01:02:50	USED	KEEP — primary key
LEDGER.app.WarehouseStatus.PK_BatchDaily	1	CLUSTERED	Y	Y	32	64	0	2	2026-06-27 01:02:00	never	USED	KEEP — primary key
LEDGER.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y	0	96	0	5	2026-06-27 01:02:00	2026-09-06 01:02:50	USED	KEEP — primary key
LEDGER.app.SalesLine.PK_PricingDetail	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-06 01:02:51	UNUSED	KEEP — primary key
LEDGER.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-06 01:02:51	UNUSED	KEEP — primary key
LEDGER.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-06 01:02:51	UNUSED	KEEP — primary key
LEDGER.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-06 01:02:51	UNUSED	KEEP — primary key
LEDGER.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-06 01:02:51	UNUSED	KEEP — primary key
LEDGER.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-06 01:02:51	UNUSED	KEEP — primary key
LEDGER.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	32	never	2026-09-06 01:02:51	UNUSED	KEEP — primary key
LEDGER.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y	0	64	0	3	2026-06-27 01:02:00	2026-09-06 01:02:51	USED	KEEP — primary key
LEDGER.STAFFING.WarehouseMonthly.PK_LedgerStaging	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
LEDGER.STAFFING.SalesDetail.PK_ShiftEntry	1	CLUSTERED	Y	Y	31	62	0	0	2026-06-27 01:02:20	never	USED	KEEP — primary key
LEDGER.STAFFING.PolicySummary.PK_ContractHistory	1	CLUSTERED	Y	Y	0	62	0	15	2026-06-27 01:02:16	never	USED	KEEP — primary key
LEDGER.STAFFING.BatchDaily.PK_InvoiceEntry	1	CLUSTERED	Y	Y	0	62	0	1	2026-06-27 01:02:11	never	USED	KEEP — primary key
LEDGER.STAFFING.ShipmentAudit.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:08	never	USED	KEEP — primary key
LEDGER.STAFFING.BookingResult.PK_BookingHistory	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
LEDGER.STAFFING.InvoiceQueue.PK_SettlementHistory	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
LEDGER.STAFFING.QuotaMonthly.PK_ReconcileDaily	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:19	never	USED	KEEP — primary key
LEDGER.STAFFING.PayrollSummary.PK_StaffingLine	1	CLUSTERED	Y	Y	31	62	0	0	2026-06-27 01:02:23	never	USED	KEEP — primary key
LEDGER.STAFFING.RouteHistory.PK_TicketEntry	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:17	never	USED	KEEP — primary key
LEDGER.STAFFING.AssetSummary.PK_QuotaArchive	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
LEDGER.STAFFING.WarehouseEntry.PK_CampaignStaging	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
LEDGER.STAFFING.TerritoryEntry.PK_SettlementEntry	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:07	never	USED	KEEP — primary key
LEDGER.STAFFING.MeterResult.PK_ContractDaily	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:25	never	USED	KEEP — primary key
LEDGER.STAFFING.PayrollHeader.PK_TerritoryQueue	1	CLUSTERED	Y	Y	0	62	0	28	2026-06-27 01:02:25	never	USED	KEEP — primary key
LEDGER.STAFFING.RosterResult.PK_AssetQueue	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:24	never	USED	KEEP — primary key
LEDGER.STAFFING.MeterAudit.PK_SettlementQueue	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:24	never	USED	KEEP — primary key
LEDGER.STAFFING.ShiftLine.PK_BatchLog	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:24	never	USED	KEEP — primary key
LEDGER.STAFFING.CampaignHeader.PK_MeterSummary	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:25	never	USED	KEEP — primary key
LEDGER.STAFFING.MeterStatus.PK_ShiftStaging	1	CLUSTERED	Y	Y	31	62	0	0	2026-06-27 01:02:25	never	USED	KEEP — primary key
LEDGER.STAFFING.ForecastHeader.PK_ShiftLine	1	CLUSTERED	Y	Y	0	62	0	2	2026-06-27 01:02:19	never	USED	KEEP — primary key
LEDGER.STAFFING.AssetDaily.PK_ShiftLine	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:23	never	USED	KEEP — primary key
LEDGER.STAFFING.StaffingDaily.PK_ContractStatus	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:32	never	USED	KEEP — primary key
LEDGER.STAFFING.ClaimResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:29	never	USED	KEEP — primary key
LEDGER.STAFFING.PricingDaily.PK_SettlementLog	1	CLUSTERED	Y	Y	0	62	0	1	2026-06-27 01:02:24	never	USED	KEEP — primary key
LEDGER.STAFFING.PolicyLog.PK_BatchQueue	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:20	never	USED	KEEP — primary key
LEDGER.STAFFING.MeterHistory.PK_ShiftHistory	1	CLUSTERED	Y	Y	0	62	0	29	2026-06-27 01:02:28	never	USED	KEEP — primary key
LEDGER.STAFFING.TerritoryLine.PK_ShipmentAudit	1	CLUSTERED	Y	Y	31	62	0	36	2026-06-26 01:02:52	2026-09-06 01:02:52	USED	KEEP — primary key
LEDGER.STAFFING.SettlementQueue.PK_PayrollStaging	1	CLUSTERED	Y	Y	0	62	0	33	2026-06-26 01:02:55	2026-09-06 01:02:52	USED	KEEP — primary key
LEDGER.STAFFING.TicketQueue.PK_CatalogStaging	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:25	never	USED	KEEP — primary key
LEDGER.STAFFING.OrdersEntry.PK_RosterMonthly	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:24	never	USED	KEEP — primary key
LEDGER.STAFFING.CampaignHistory.PK_ShipmentStatus	1	CLUSTERED	Y	Y	0	62	0	15	2026-06-27 01:02:25	never	USED	KEEP — primary key
LEDGER.STAFFING.TicketLine.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
LEDGER.STAFFING.BatchAudit.PK_BookingDetail	1	CLUSTERED	Y	Y	0	62	0	3303	2026-06-26 01:03:41	2026-09-06 01:02:53	USED	KEEP — primary key
LEDGER.STAFFING.PolicyHistory.PK_CampaignStatus	1	CLUSTERED	Y	Y	8	108	0	711	2026-06-26 01:05:53	2026-09-06 01:02:54	USED	KEEP — primary key
LEDGER.STAFFING.BillingEntry.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	124	0	296	2026-06-26 01:05:59	2026-09-06 01:02:54	USED	KEEP — primary key
LEDGER.STAFFING.BillingAudit.PK_SettlementAudit	1	CLUSTERED	Y	Y	0	124	0	290	2026-06-26 01:06:03	2026-09-06 01:02:54	USED	KEEP — primary key
LEDGER.STAFFING.ShipmentStaging.PK_QuotaLine	1	CLUSTERED	Y	Y	0	124	0	0	2026-06-26 01:06:04	never	USED	KEEP — primary key
LEDGER.STAFFING.SalesLine.PK_ReconcileDetail	1	CLUSTERED	Y	Y	31	93	0	3503	2026-06-26 01:05:38	2026-09-06 01:02:55	USED	KEEP — primary key
LEDGER.STAFFING.ReconcileDetail.PK_BillingSummary	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:20	never	USED	KEEP — primary key
LEDGER.STAFFING.PolicyEntry.PK_PayrollEntry	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
LEDGER.STAFFING.ReconcileStaging.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
LEDGER.STAFFING.ShipmentQueue.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	0	62	0	1	2026-06-27 01:02:08	never	USED	KEEP — primary key
LEDGER.STAFFING.MeterStatus.PK_PricingMonthly	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:29	never	USED	KEEP — primary key
LEDGER.STAFFING.ShiftResult.PK_SalesHistory	1	CLUSTERED	Y	Y	0	62	0	5	2026-06-27 01:02:09	never	USED	KEEP — primary key
LEDGER.STAFFING.Level.PK_AssetSnapshot	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:10	never	USED	KEEP — primary key
LEDGER.STAFFING.CampaignHeader.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
LEDGER.STAFFING.WarehouseHeader.PK_InvoiceDetail	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
LEDGER.STAFFING.QuotaEntry.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	62	0	1	2026-06-27 01:02:12	never	USED	KEEP — primary key
LEDGER.STAFFING.QuotaStatus.PK_StaffingMonthly	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:03	never	USED	KEEP — primary key
LEDGER.STAFFING.Position.PK_TerritoryDaily	1	CLUSTERED	Y	Y	0	62	0	9	2026-06-27 01:02:13	never	USED	KEEP — primary key
LEDGER.STAFFING.CampaignQueue.PK_PolicyHistory	1	CLUSTERED	Y	Y	0	62	0	9	2026-06-27 01:02:13	never	USED	KEEP — primary key
LEDGER.STAFFING.RouteQueue.PK_ReconcileStatus	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:05	never	USED	KEEP — primary key
LEDGER.STAFFING.RosterQueue.PK_SalesStatus	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:09	never	USED	KEEP — primary key
LEDGER.STAFFING.TicketAudit.PK_PricingHeader	1	CLUSTERED	Y	Y	0	62	0	21	2026-06-26 01:02:52	2026-09-06 01:02:56	USED	KEEP — primary key
LEDGER.STAFFING.CustomerLog.PK_LedgerStatus	1	CLUSTERED	Y	Y	0	62	0	31	2026-06-26 01:02:51	2026-09-06 01:02:56	USED	KEEP — primary key
LEDGER.STAFFING.SupplierStaging.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	32	0	31	2026-06-26 01:02:51	2026-09-06 01:02:56	USED	KEEP — primary key
LEDGER.STAFFING.PolicyLine.PK_StaffingStaging	1	CLUSTERED	Y	Y	0	62	0	11	2026-06-26 01:02:51	never	USED	KEEP — primary key
LEDGER.STAFFING.RouteStaging.PK_AssetDetail	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
LEDGER.STAFFING.CatalogSnapshot.PK_TicketHeader	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
LEDGER.STAFFING.BillingDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y	0	62	0	31	2026-06-26 01:02:52	2026-09-06 01:02:56	USED	KEEP — primary key
LEDGER.STAFFING.CampaignAudit.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:04	never	USED	KEEP — primary key
LEDGER.STAFFING.PricingArchive.PK_ShipmentHistory	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:14	never	USED	KEEP — primary key
LEDGER.STAFFING.SalesStatus.PK_BillingLog	1	CLUSTERED	Y	Y	0	62	0	11	2026-06-26 01:03:02	2026-09-06 01:02:56	USED	KEEP — primary key
LEDGER.STAFFING.SettlementQueue.PK_RouteHistory	1	CLUSTERED	Y	Y	0	62	0	15	2026-06-26 01:03:00	2026-09-06 01:02:56	USED	KEEP — primary key
LEDGER.STAFFING.MeterHistory.PK_ForecastLine	1	CLUSTERED	Y	Y	23	70	0	15	2026-06-26 01:03:01	2026-09-06 01:02:56	USED	KEEP — primary key
LEDGER.STAFFING.ShipmentAudit.PK_SalesArchive	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-26 01:03:01	never	USED	KEEP — primary key
LEDGER.STAFFING.ForecastAudit.PK_MeterSummary	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:13	never	USED	KEEP — primary key
LEDGER.STAFFING.PayrollLine.PK_ForecastResult	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:11	never	USED	KEEP — primary key
LEDGER.STAFFING.SupplierArchive.PK_BatchDaily	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-26 01:02:58	never	USED	KEEP — primary key
LEDGER.STAFFING.CustomerSnapshot.PK_BatchResult	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-26 01:02:59	never	USED	KEEP — primary key
LEDGER.STAFFING.CampaignResult.PK_ShiftEntry	1	CLUSTERED	Y	Y	0	62	0	82	2026-06-26 01:02:58	2026-09-06 01:02:57	USED	KEEP — primary key
LEDGER.STAFFING.BookingStaging.PK_RouteMonthly	1	CLUSTERED	Y	Y	0	62	0	4	2026-06-27 01:02:10	never	USED	KEEP — primary key
LEDGER.STAFFING.SupplierResult.PK_OrdersDaily	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:14	never	USED	KEEP — primary key
LEDGER.STAFFING.ShiftResult.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	62	0	27	2026-06-27 01:02:23	never	USED	KEEP — primary key
LEDGER.STAFFING.ShiftDaily.PK_SettlementResult	1	CLUSTERED	Y	Y	0	62	0	0	2026-06-27 01:02:02	never	USED	KEEP — primary key
LEDGER.STAFFING.PayrollHistory.PK_ClaimArchive	1	CLUSTERED	Y	Y	31	62	0	28	2026-06-27 01:02:34	never	USED	KEEP — primary key
LEDGER.STAFFING.CatalogSummary.PK_RouteHistory	1	CLUSTERED	Y	Y	0	62	0	28	2026-06-27 01:02:30	never	USED	KEEP — primary key
LEDGER.STAFFING.TicketMonthly.PK_RouteEntry	1	CLUSTERED	Y	Y	30	68	0	27	2026-06-30 01:01:17	2026-09-06 01:02:57	USED	KEEP — primary key
LEDGER.STAFFING.BillingQueue.PK_PolicyMonthly	1	CLUSTERED	Y	Y	0	65	0	27	2026-06-27 01:02:25	never	USED	KEEP — primary key
LEDGER.STAFFING.QuotaResult.PK_InvoiceResult	1	CLUSTERED	Y	Y	0	62	0	1	2026-06-27 01:02:10	never	USED	KEEP — primary key
PAYROLL.audit.OrdersLog.PK_BookingMonthly	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
PAYROLL.audit.MeterHistory.PK_TerritoryStatus	1	CLUSTERED	Y	Y	0	521	0	0	2026-09-12 01:00:11	2026-09-06 01:00:02	USED	KEEP — primary key
PAYROLL.audit.TerritorySnapshot.PK_PayrollDaily	1	CLUSTERED	Y	Y	9559	0	0	0	2026-09-12 01:00:12	2026-09-06 01:00:02	USED	KEEP — primary key
PAYROLL.audit.ReconcileLine.PK_TicketAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
PAYROLL.audit.ReconcileLine.IX_SalesArchive	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
PAYROLL.audit.PricingResult.PK_SupplierAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	2026-09-06 01:00:02	UNUSED	KEEP — primary key
PAYROLL.audit.PricingResult.IX_MeterSummary	2	NONCLUSTERED	Y		5980	16368	0	0	2026-09-12 01:00:11	2026-09-06 01:00:02	USED	keep — in use
PAYROLL.audit.CampaignSnapshot.PK_PricingEntry	1	CLUSTERED	Y	Y	0	2	0	0	2026-05-27 23:09:59	never	USED	KEEP — primary key
PAYROLL.audit.CampaignSnapshot.IX_SalesSnapshot	2	NONCLUSTERED	Y		2	0	0	0	2026-05-27 23:09:59	never	USED	keep — in use
PAYROLL.audit.LedgerEntry.PK_ShiftAudit	1	CLUSTERED	Y	Y	0	1	0	0	2026-05-27 23:09:41	never	USED	KEEP — primary key
PAYROLL.audit.RouteMonthly.PK_SettlementStatus	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
PAYROLL.audit.RouteMonthly.IX_SalesAudit	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
PAYROLL.audit.RouteMonthly.PK_ForecastHeader	1	CLUSTERED	Y	Y	2	1	0	0	2026-05-27 23:09:59	never	USED	KEEP — primary key
PAYROLL.audit.RouteMonthly.IX_SalesLog	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
PAYROLL.audit.RouteLine.IX_BatchDaily	3	NONCLUSTERED			0	108	0	1774029	2026-09-12 00:00:01	2026-09-12 01:00:23	USED	keep — in use
PAYROLL.audit.RouteLine.IX_QuotaQueue	2	NONCLUSTERED			108	0	0	1774029	2026-09-12 00:00:01	2026-09-12 01:00:27	USED	keep — in use
PAYROLL.audit.RouteLine.PK_BatchResult	1	CLUSTERED	Y	Y	0	0	0	1774029	never	2026-09-12 01:00:20	UNUSED	KEEP — primary key
PAYROLL.audit.RouteEntry.IX_ClaimSnapshot	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
PAYROLL.audit.StaffingArchive.IX_ShipmentLog	2	NONCLUSTERED			108	108	0	914211	2026-09-12 00:00:01	2026-09-12 01:00:56	USED	keep — in use
PAYROLL.audit.StaffingArchive.PK_TicketResult	1	CLUSTERED	Y	Y	1773943	0	0	914211	2026-09-12 01:00:43	2026-09-12 01:00:49	USED	KEEP — primary key
PAYROLL.audit.ShiftSummary.IX_MeterResult	2	NONCLUSTERED			1	0	0	0	2026-05-28 09:59:18	never	USED	keep — in use
PAYROLL.audit.ShiftSummary.IX_BookingHeader	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
PAYROLL.audit.SupplierLog.IX_CatalogEntry	2	NONCLUSTERED			111	0	0	110536	2026-09-12 00:00:01	2026-09-12 01:01:01	USED	keep — in use
PAYROLL.audit.SupplierLog.PK_ShiftLine	1	CLUSTERED	Y	Y	0	0	3	110536	2026-05-28 09:58:23	2026-09-12 01:00:58	USED	KEEP — primary key
PAYROLL.audit.PricingAudit.PK_RouteSummary	1	CLUSTERED	Y	Y	110428	110430	0	2068	2026-09-12 01:00:43	2026-09-06 01:00:56	USED	KEEP — primary key
PAYROLL.audit.BatchSnapshot.PK_StaffingSnapshot	1	CLUSTERED	Y	Y	0	4	0	108	2026-05-28 09:58:07	never	USED	KEEP — primary key
PAYROLL.audit.BatchSnapshot.IX_BatchSnapshot	2	NONCLUSTERED			107	1	0	108	2026-09-12 00:00:01	never	USED	keep — in use
PAYROLL.audit.MeterDaily.PK_ForecastStatus	1	CLUSTERED	Y	Y	0	108	0	108	2026-09-12 00:00:01	never	USED	KEEP — primary key
PAYROLL.audit.StaffingSummary.PK_InvoiceStaging	1	CLUSTERED	Y	Y	0	607	0	108	2026-09-12 01:00:12	never	USED	KEEP — primary key
PAYROLL.audit.CampaignDaily.IX_LedgerMonthly	2	NONCLUSTERED			2232	0	0	3099	2026-09-12 01:00:11	2026-09-12 01:01:03	USED	keep — in use
PAYROLL.audit.CampaignDaily.IX_ClaimQueue	3	NONCLUSTERED			6352	0	0	3099	2026-09-12 01:00:12	2026-09-12 01:01:03	USED	keep — in use
PAYROLL.audit.CampaignDaily.PK_PricingLine	1	CLUSTERED	Y	Y	2990	1	6982	8085	2026-09-12 01:00:12	2026-09-12 01:01:01	USED	KEEP — primary key
PAYROLL.audit.WarehouseMonthly.IX_CampaignLine	2	NONCLUSTERED			107	1	0	108	2026-09-12 00:00:01	never	USED	keep — in use
PAYROLL.audit.WarehouseMonthly.PK_TerritoryStatus	1	CLUSTERED	Y	Y	0	998	0	108	2026-09-12 01:00:12	never	USED	KEEP — primary key
PAYROLL.audit.executions.PK_TerritoryLog	1	CLUSTERED	Y	Y	115970	230	0	607	2026-09-12 01:00:46	2026-09-12 01:01:04	USED	KEEP — primary key
PAYROLL.audit.InvoiceLine.PK_PayrollAudit	1	CLUSTERED	Y	Y	0	109	0	109	2026-09-12 00:00:01	never	USED	KEEP — primary key
PAYROLL.audit.SettlementEntry.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	3100	5288	0	2026-09-12 01:00:11	never	USED	KEEP — primary key
PAYROLL.audit.SettlementEntry.IX_PricingHistory	2	NONCLUSTERED	Y		5288	0	0	0	2026-09-12 01:00:11	never	USED	keep — in use
PAYROLL.audit.AssetSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	20	8	9	0	2026-05-28 10:40:11	2026-09-06 01:01:00	USED	KEEP — primary key
PAYROLL.audit.AssetSummary.IX_SalesLog	2	NONCLUSTERED	Y		1540	2	0	0	2026-09-12 01:00:11	2026-09-06 01:01:00	USED	keep — in use
PAYROLL.audit.QuotaLog.PK_ClaimStatus	1	CLUSTERED	Y	Y	213	213	0	213	2026-09-11 15:35:05	never	USED	KEEP — primary key
PAYROLL.audit.SalesQueue.PK_CustomerStaging	1	CLUSTERED	Y	Y	0	0	0	213	never	never	UNUSED	KEEP — primary key
PAYROLL.audit.jobs.PK_AssetSummary	1	CLUSTERED	Y	Y	0	426	0	213	2026-09-11 15:35:05	never	USED	KEEP — primary key
PAYROLL.audit.jobs.IX_MeterStaging	2	NONCLUSTERED			0	0	0	213	never	never	UNUSED	review, then DROP
PAYROLL.audit.BillingLine.PK_StaffingStatus	1	CLUSTERED	Y	Y	426	0	0	213	2026-09-11 15:35:05	never	USED	KEEP — primary key
PAYROLL.audit.ContractDetail.PK_ForecastLog	1	CLUSTERED	Y	Y	154093	0	0	154093	2026-09-12 01:04:42	2026-09-06 01:01:00	USED	KEEP — primary key
PAYROLL.audit.AssetSnapshot.PK_CustomerSnapshot	1	CLUSTERED	Y	Y	310471	0	0	308916	2026-09-12 01:04:28	2026-09-06 01:01:00	USED	KEEP — primary key
PAYROLL.audit.RouteAudit.IX_PayrollLog	2	NONCLUSTERED			998	109	0	16477	2026-09-12 01:00:11	2026-09-06 01:01:00	USED	keep — in use
PAYROLL.audit.RouteAudit.PK_BatchLine	1	CLUSTERED	Y	Y	0	2507	998	16483	2026-09-12 01:00:11	2026-09-06 01:01:00	USED	KEEP — primary key
PAYROLL.audit.BatchDetail.PK_BillingEntry	1	CLUSTERED	Y	Y	35917	339	0	126	2026-09-12 01:00:11	2026-09-06 01:01:01	USED	KEEP — primary key
PAYROLL.audit.BatchLog.IX_ShiftLog	2	NONCLUSTERED			151	0	0	914212	2026-09-12 00:00:01	2026-09-12 01:01:13	USED	keep — in use
PAYROLL.audit.BatchLog.PK_MeterStatus	1	CLUSTERED	Y	Y	914103	0	42	914212	2026-09-12 01:00:43	2026-09-12 01:01:10	USED	KEEP — primary key
PAYROLL.audit.PayrollSnapshot.IX_ReconcileHistory	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
PAYROLL.audit.PayrollSnapshot.IX_SettlementAudit	2	NONCLUSTERED			3	0	0	0	2026-05-28 10:00:59	never	USED	keep — in use
PAYROLL.audit.SalesEntry.IX_SupplierQueue	2	NONCLUSTERED			1539	215	0	607	2026-09-12 01:00:46	2026-09-12 01:01:14	USED	keep — in use
PAYROLL.audit.SalesEntry.PK_SupplierAudit	1	CLUSTERED	Y	Y	0	10	0	607	2026-05-28 11:00:16	2026-09-12 01:01:14	USED	KEEP — primary key
PAYROLL.audit.InvoiceSnapshot.PK_PayrollArchive	1	CLUSTERED	Y	Y	0	261	17351	613	2026-09-12 01:00:46	2026-09-12 01:01:14	USED	KEEP — primary key
PAYROLL.audit.InvoiceSnapshot.IX_ShipmentLog	2	NONCLUSTERED	Y		17351	108	0	613	2026-09-12 01:00:46	2026-09-12 01:01:14	USED	keep — in use
PAYROLL.audit.BillingResult.IX_RouteLine	2	NONCLUSTERED			0	31011	0	1330	2026-09-12 01:01:15	2026-09-12 01:01:14	USED	keep — in use
PAYROLL.audit.BillingResult.PK_RosterQueue	1	CLUSTERED	Y	Y	3679731	157	0	97766	2026-09-12 01:01:15	2026-09-12 01:01:14	USED	KEEP — primary key
PAYROLL.audit.BatchLog.IX_LedgerDetail	2	NONCLUSTERED			500	226	0	125	2026-09-12 01:00:11	2026-09-06 01:01:08	USED	keep — in use
PAYROLL.audit.BatchLog.PK_SupplierArchive	1	CLUSTERED	Y	Y	0	2	4	125	2026-05-28 10:40:11	2026-09-06 01:01:08	USED	KEEP — primary key
PAYROLL.audit.TicketHeader.PK_ShipmentHistory	1	CLUSTERED	Y	Y	0	5286	0	0	2026-09-12 01:00:11	2026-09-06 01:01:08	USED	KEEP — primary key
PAYROLL.audit.TicketHeader.IX_ShiftAudit	2	NONCLUSTERED	Y		5286	0	0	0	2026-09-12 01:00:11	2026-09-06 01:01:08	USED	keep — in use
PAYROLL.audit.SettlementAudit.IX_CampaignHistory	3	NONCLUSTERED			1016	109	0	6	2026-09-12 01:00:11	2026-09-06 01:01:08	USED	keep — in use
PAYROLL.audit.SettlementAudit.PK_CustomerLine	1	CLUSTERED	Y	Y	25736	19	11	6	2026-09-12 01:00:11	2026-09-06 01:01:08	USED	KEEP — primary key
PAYROLL.audit.SettlementAudit.IX_CatalogLine	2	NONCLUSTERED	Y		11	0	0	0	2026-05-28 10:40:11	2026-09-06 01:01:08	USED	keep — in use
PAYROLL.audit.tasks.PK_LedgerArchive	1	CLUSTERED	Y	Y	0	31117	0	31117	2026-09-12 01:01:15	never	USED	KEEP — primary key
PAYROLL.audit.tasks.IX_SettlementEntry	2	NONCLUSTERED			0	426	0	31117	2026-09-11 15:35:05	never	USED	keep — in use
PAYROLL.audit.tasks.IX_ShipmentEntry	3	NONCLUSTERED			0	0	0	31117	never	never	UNUSED	review, then DROP
PAYROLL.audit.SalesDaily.PK_CatalogHistory	1	CLUSTERED	Y	Y	0	0	0	213	never	never	UNUSED	KEEP — primary key
PAYROLL.audit.SalesDaily.IX_PolicySummary	2	NONCLUSTERED			0	0	0	213	never	never	UNUSED	review, then DROP
PAYROLL.audit.QuotaLog.PK_RosterResult	1	CLUSTERED	Y	Y	0	108	0	108	2026-09-12 00:00:01	never	USED	KEEP — primary key
PAYROLL.audit.ShipmentStaging.IX_WarehouseEntry	2	NONCLUSTERED			0	0	0	154093	never	never	UNUSED	review, then DROP
PAYROLL.audit.ReconcileDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	462688	107	0	154502	2026-09-12 01:04:42	2026-09-06 01:01:08	USED	KEEP — primary key
TERRITORY.app.RosterDaily.PK_TicketAudit	1	CLUSTERED	Y	Y	45	120	0	20	2026-09-11 01:30:08	2026-09-06 01:04:10	USED	KEEP — primary key
TERRITORY.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	49	3	0	19	2026-09-10 08:25:49	2026-09-06 01:04:56	USED	KEEP — primary key
TERRITORY.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	52	0	0	19	2026-09-10 08:25:49	2026-09-06 01:04: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-09-06 01:04:56	USED	KEEP — primary key
TERRITORY.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	33	19	0	19	2026-09-10 08:25:49	2026-09-06 01:04:57	USED	KEEP — primary key
TERRITORY.app.SettlementEntry.PK_TicketQueue	1	CLUSTERED	Y	Y	0	19	0	19	2026-06-13 05:28:43	2026-09-06 01:04: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-09-06 01:04: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.STAFFING.ContractSnapshot.PK_ContractResult	1	CLUSTERED	Y	Y	50	0	0	17	2026-09-10 08:25:49	2026-09-06 01:04:57	USED	KEEP — primary key
TERRITORY.STAFFING.PolicyHistory.PK_TicketAudit	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:28:59	2026-09-06 01:04:57	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	23	440	0	17	2026-09-11 01:30:11	2026-09-06 01:04:57	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	52	216	0	17	2026-09-11 01:42:53	2026-09-06 01:04:57	USED	KEEP — primary key
TERRITORY.STAFFING.AssetLine.PK_ContractDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-09-06 01:04:57	USED	KEEP — primary key
TERRITORY.STAFFING.TicketAudit.PK_PricingLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:54	2026-09-06 01:04:57	USED	KEEP — primary key
TERRITORY.STAFFING.CampaignQueue.PK_InvoiceMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-09-06 01:04:57	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	10	119	0	17	2026-09-11 01:30:04	2026-09-06 01:04:57	USED	KEEP — primary key
TERRITORY.STAFFING.BatchLog.PK_SalesMonthly	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:29:03	2026-09-06 01:04:58	USED	KEEP — primary key
TERRITORY.STAFFING.TicketMonthly.PK_SupplierLine	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-09-06 01:04:58	USED	KEEP — primary key
TERRITORY.STAFFING.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	17	109	0	17	2026-09-11 01:30:00	2026-09-06 01:04:58	USED	KEEP — primary key
TERRITORY.STAFFING.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	126	112	0	17	2026-09-11 01:30:04	2026-09-06 01:04:58	USED	KEEP — primary key
TERRITORY.STAFFING.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	17	112	0	17	2026-09-11 01:30:04	2026-09-06 01:04:58	USED	KEEP — primary key
TERRITORY.STAFFING.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	15	226	0	17	2026-09-11 01:30:08	2026-09-06 01:04:58	USED	KEEP — primary key
TERRITORY.STAFFING.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	14	223	0	17	2026-09-11 01:30:08	2026-09-06 01:04:58	USED	KEEP — primary key
TERRITORY.STAFFING.WarehouseStatus.PK_MeterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:07	2026-09-06 01:04:58	USED	KEEP — primary key
TERRITORY.STAFFING.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	10	119	0	17	2026-09-11 01:30:08	2026-09-06 01:04:59	USED	KEEP — primary key
TERRITORY.STAFFING.CustomerStatus.PK_SalesDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:13	2026-09-06 01:04:59	USED	KEEP — primary key
TERRITORY.STAFFING.MeterStatus.PK_OrdersLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:59	2026-09-06 01:04:59	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaQueue.PK_BookingQueue	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:28:58	2026-09-06 01:04:59	USED	KEEP — primary key
TERRITORY.STAFFING.CatalogSummary.PK_AssetLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:12	2026-09-06 01:04:59	USED	KEEP — primary key
TERRITORY.STAFFING.TicketHeader.PK_PolicyResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:13	2026-09-06 01:04:59	USED	KEEP — primary key
TERRITORY.STAFFING.RouteHeader.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:12	2026-09-06 01:04:59	USED	KEEP — primary key
TERRITORY.STAFFING.PolicyHistory.PK_CampaignQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:59	2026-09-06 01:04:59	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastHistory.PK_SupplierHistory	1	CLUSTERED	Y	Y	16	1	0	17	2026-06-13 05:29:08	2026-09-06 01:04:59	USED	KEEP — primary key
TERRITORY.STAFFING.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	10	567	0	17	2026-09-11 01:30:07	2026-09-06 01:05:00	USED	KEEP — primary key
TERRITORY.STAFFING.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	130	907	0	17	2026-09-11 01:45:42	2026-09-06 01:05:00	USED	KEEP — primary key
TERRITORY.STAFFING.TicketLine.PK_CustomerEntry	1	CLUSTERED	Y	Y	1	17	0	17	2026-06-13 05:30:17	2026-09-06 01:05:00	USED	KEEP — primary key
TERRITORY.STAFFING.AssetSnapshot.PK_SalesAudit	1	CLUSTERED	Y	Y	16	5	0	17	2026-09-10 08:25:56	2026-09-06 01:05:01	USED	KEEP — primary key
TERRITORY.STAFFING.MeterAudit.PK_ShiftEntry	1	CLUSTERED	Y	Y	14	3	0	17	2026-06-13 05:28:59	2026-09-06 01:05:01	USED	KEEP — primary key
TERRITORY.STAFFING.PolicyEntry.PK_RouteResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:09	2026-09-06 01:05:01	USED	KEEP — primary key
TERRITORY.STAFFING.SalesEntry.PK_WarehouseMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:29:08	2026-09-06 01:05:01	USED	KEEP — primary key
TERRITORY.STAFFING.MeterArchive.PK_LedgerStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-09-06 01:05:01	USED	KEEP — primary key
TERRITORY.STAFFING.StaffingHistory.PK_ShipmentArchive	1	CLUSTERED	Y	Y	9	8	0	17	2026-06-13 05:29:03	2026-09-06 01:05:01	USED	KEEP — primary key
TERRITORY.STAFFING.BookingQueue.PK_AssetHeader	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-06 01:05:01	USED	KEEP — primary key
TERRITORY.STAFFING.ShiftDaily.PK_ClaimAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-06 01:05:01	USED	KEEP — primary key
TERRITORY.STAFFING.InvoiceAudit.PK_PolicyDaily	1	CLUSTERED	Y	Y	16	1	0	17	2026-06-13 05:28:50	2026-09-06 01:05:01	USED	KEEP — primary key
TERRITORY.STAFFING.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	10	119	0	17	2026-09-11 01:30:08	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	16	327	0	17	2026-09-11 01:38:08	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	17	109	0	17	2026-09-11 01:30:00	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.ShiftMonthly.PK_PricingArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.ContractMonthly.PK_CustomerDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.SalesAudit.PK_BatchArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.MeterSnapshot.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	24	326	0	17	2026-09-11 01:30:06	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	22	216	0	17	2026-09-11 01:30:06	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	17	112	0	17	2026-09-11 01:30:04	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.ReconcileHistory.PK_StaffingDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:50	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.ClaimDetail.PK_RosterLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:18	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	17	216	0	17	2026-09-11 01:42:52	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	17	109	0	18	2026-09-11 01:38:08	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.InvoiceHistory.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:18	2026-09-06 01:05:02	USED	KEEP — primary key
TERRITORY.STAFFING.BookingDetail.PK_RosterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:53	2026-09-06 01:05:03	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaSummary.PK_RosterStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-09-06 01:05:03	USED	KEEP — primary key
TERRITORY.STAFFING.WarehouseEntry.PK_ShiftDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:18	2026-09-06 01:05:03	USED	KEEP — primary key
TERRITORY.STAFFING.RosterSummary.PK_PricingMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:47	2026-09-06 01:05:03	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	17	108	0	17	2026-09-11 01:42:53	2026-09-06 01:05:03	USED	KEEP — primary key
TERRITORY.STAFFING.CampaignQueue.PK_PayrollEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:21	2026-09-06 01:05:03	USED	KEEP — primary key
TERRITORY.STAFFING.ClaimStaging.PK_SupplierHeader	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:20	2026-09-06 01:05:04	USED	KEEP — primary key
TERRITORY.STAFFING.PayrollMonthly.PK_MeterSnapshot	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 05:30:21	2026-09-06 01:05:04	USED	KEEP — primary key
TERRITORY.STAFFING.StaffingQueue.PK_CatalogLine	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:21	never	USED	KEEP — primary key
TERRITORY.STAFFING.RosterEntry.PK_BookingStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:56	2026-09-06 01:05:04	USED	KEEP — primary key
TERRITORY.STAFFING.AssetStatus.PK_TicketEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:54	2026-09-06 01:05:04	USED	KEEP — primary key
TERRITORY.STAFFING.AssetLine.PK_ForecastSummary	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:21	2026-09-06 01:05:04	USED	KEEP — primary key
TERRITORY.STAFFING.TicketQueue.PK_CatalogAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:30:20	2026-09-06 01:05:04	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	17	108	0	17	2026-09-11 01:42:52	2026-09-06 01:05:04	USED	KEEP — primary key
TERRITORY.STAFFING.CustomerLog.PK_BillingEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:54	2026-09-06 01:05:05	USED	KEEP — primary key
TERRITORY.STAFFING.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	17	33	0	17	2026-09-10 08:25:49	2026-09-06 01:05:05	USED	KEEP — primary key
TERRITORY.STAFFING.LedgerStaging.PK_ForecastEntry	1	CLUSTERED	Y	Y	13	4	0	17	2026-06-13 05:29:07	2026-09-06 01:05:08	USED	KEEP — primary key
TERRITORY.STAFFING.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	129	0	0	17	2026-09-11 01:30:04	2026-09-06 01:05:05	USED	KEEP — primary key
TERRITORY.STAFFING.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	296	86	0	68	2026-09-11 01:30:11	2026-09-06 01:05:06	USED	KEEP — primary key
TERRITORY.STAFFING.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	40	349	0	17	2026-09-11 01:30:06	2026-09-06 01:05:06	USED	KEEP — primary key
TERRITORY.STAFFING.ShiftSnapshot.PK_BillingResult	1	CLUSTERED	Y	Y	1	17	0	17	2026-06-13 05:29:08	2026-09-06 01:05:07	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	12	147	0	17	2026-09-11 01:30:00	2026-09-06 01:05:07	USED	KEEP — primary key
TERRITORY.STAFFING.CustomerStatus.PK_PayrollLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 05:28:54	2026-09-06 01:05:07	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastSummary.PK_BatchQueue	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
TERRITORY.STAFFING.MeterHistory.PK_LedgerQueue	1	CLUSTERED	Y	Y	39	261	0	109	2026-09-11 01:47:56	2026-09-06 01:05:08	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	110	141	0	34	2026-09-11 01:47:55	2026-09-06 01:05:10	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastLine.UX_ShiftQueue	10	NONCLUSTERED	Y		341	109	0	34	2026-09-11 01:42:54	2026-09-06 01:05:18	USED	keep — in use
TERRITORY.STAFFING.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	0	108	0	108	2026-09-11 01:41:28	2026-09-06 01:05:22	USED	KEEP — primary key
TERRITORY.STAFFING.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	16	125	0	32	2026-09-11 01:30:11	2026-09-06 01:05:23	USED	KEEP — primary key
TERRITORY.STAFFING.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	19	246	0	32	2026-09-11 01:30:37	2026-09-06 01:05:23	USED	KEEP — primary key
TERRITORY.STAFFING.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	29	235	0	32	2026-09-11 01:47:55	2026-09-06 01:05:24	USED	KEEP — primary key
TERRITORY.STAFFING.SettlementHeader.PK_CatalogHistory	1	CLUSTERED	Y	Y	29	19	0	32	2026-06-12 03:23:02	2026-09-06 01:05:24	USED	KEEP — primary key
TERRITORY.STAFFING.ShiftStaging.PK_RosterArchive	1	CLUSTERED	Y	Y	19	353	0	36	2026-09-11 01:42:54	2026-09-06 01:05:30	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			63	0	0	108	2026-09-11 01:30:04	2026-09-06 01:05:31	USED	keep — in use
TERRITORY.STAFFING.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	157	63	108	2026-09-11 01:30:08	2026-09-06 01:05:31	USED	KEEP — primary key
TERRITORY.STAFFING.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	0	216	0	108	2026-09-11 01:47:57	2026-09-06 01:05:31	USED	KEEP — primary key
TERRITORY.STAFFING.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	77	139	0	216	2026-09-11 01:42:53	2026-09-06 01:05:31	USED	KEEP — primary key
TERRITORY.STAFFING.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	3	1944	0	1296	2026-09-11 01:42:54	2026-09-06 01:05:31	USED	KEEP — primary key
TERRITORY.STAFFING.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	108	0	108	2026-09-11 01:47:52	2026-09-06 01:05:32	USED	KEEP — primary key
TERRITORY.STAFFING.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	0	216	0	108	2026-09-11 01:47:55	2026-09-06 01:05:32	USED	KEEP — primary key
TERRITORY.STAFFING.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	34	745	0	218	2026-09-11 01:47:56	2026-09-06 01:05:32	USED	KEEP — primary key
TERRITORY.STAFFING.BatchStaging.PK_CampaignHeader	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:28:59	2026-09-06 01:05:32	USED	KEEP — primary key
TERRITORY.STAFFING.CustomerDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:29:03	2026-09-06 01:05:32	USED	KEEP — primary key
TERRITORY.STAFFING.PolicyEntry.PK_QuotaMonthly	1	CLUSTERED	Y	Y	0	17	0	10	2026-06-13 05:29:07	2026-09-06 01:05:32	USED	KEEP — primary key
TERRITORY.STAFFING.MeterEntry.PK_RosterStatus	1	CLUSTERED	Y	Y	0	17	0	30	2026-06-13 05:29:13	2026-09-06 01:05:33	USED	KEEP — primary key
TERRITORY.STAFFING.AssetLine.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	17	0	11	2026-06-13 05:29:09	2026-09-06 01:05:33	USED	KEEP — primary key
TERRITORY.STAFFING.SupplierHeader.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	17	0	137	2026-06-13 05:30:21	2026-09-06 01:05:33	USED	KEEP — primary key
TERRITORY.STAFFING.SupplierResult.PK_StaffingDaily	1	CLUSTERED	Y	Y	0	17	0	2293	2026-06-13 05:30:20	2026-09-06 01:05:36	USED	KEEP — primary key
TERRITORY.STAFFING.BookingResult.PK_ClaimLog	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:30:21	never	USED	KEEP — primary key
TERRITORY.STAFFING.InvoiceEntry.PK_ForecastLine	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:30:21	never	USED	KEEP — primary key
TERRITORY.STAFFING.ReconcileLog.PK_CampaignQueue	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:30:21	2026-09-06 01:05:36	USED	KEEP — primary key
TERRITORY.STAFFING.OrdersArchive.PK_ContractAudit	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 05:30:20	2026-09-06 01:05:37	USED	KEEP — primary key
TERRITORY.STAFFING.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	34	0	111537	2026-06-13 05:29:33	2026-09-10 01:03:13	USED	KEEP — primary key
CUSTOMER.dbo.PricingEntry.PK_ClaimQueue	1	CLUSTERED	Y	Y	21	27	0	41	2026-06-13 07:23:43	2026-09-06 01:05:40	USED	KEEP — primary key
CUSTOMER.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	43	never	2026-09-06 01:05:40	UNUSED	KEEP — primary key
CUSTOMER.dbo.SalesLine.PK_ContractMonthly	1	CLUSTERED	Y	Y	3572	2	0	1612	2026-06-13 05:28:37	2026-09-06 01:05:40	USED	KEEP — primary key
CUSTOMER.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	0	0	3224	never	2026-09-06 01:05:40	UNUSED	KEEP — primary key
CUSTOMER.dbo.RosterQueue.PK_TerritoryDaily	1	CLUSTERED	Y	Y	3258	1	0	1509	2026-06-13 07:23:41	2026-09-06 01:05:40	USED	KEEP — primary key
CUSTOMER.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	0	0	3019	never	2026-09-06 01:05:40	UNUSED	KEEP — primary key
CUSTOMER.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	12857	1286	0	12857	2026-09-11 23:27:03	2026-09-06 01:05:40	USED	KEEP — primary key
CUSTOMER.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	10	0	12857	2026-07-27 11:26:57	2026-09-12 01:04:20	USED	KEEP — primary key
CUSTOMER.dbo.Source.PK_QuotaDaily	1	CLUSTERED	Y	Y	0	22	0	0	2026-06-13 03:00:02	2026-09-06 01:05:40	USED	KEEP — primary key
CAMPAIGN.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y	0	32	0	36	2026-06-13 05:28:44	never	USED	KEEP — primary key
CAMPAIGN.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y	0	38	0	3	2026-06-13 05:28:43	never	USED	KEEP — primary key
CAMPAIGN.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 05:28:42	never	USED	KEEP — primary key
CAMPAIGN.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y	6	51	0	6	2026-06-13 05:28:43	never	USED	KEEP — primary key
CAMPAIGN.app.WarehouseStatus.PK_BatchDaily	1	CLUSTERED	Y	Y	19	38	0	6	2026-06-13 05:28:43	never	USED	KEEP — primary key
CAMPAIGN.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y	0	57	0	7	2026-06-13 05:28:43	never	USED	KEEP — primary key
CAMPAIGN.app.SalesLine.PK_PricingDetail	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-06 01:05:57	UNUSED	KEEP — primary key
CAMPAIGN.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-06 01:05:57	UNUSED	KEEP — primary key
CAMPAIGN.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-06 01:05:57	UNUSED	KEEP — primary key
CAMPAIGN.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-06 01:05:57	UNUSED	KEEP — primary key
CAMPAIGN.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-06 01:05:57	UNUSED	KEEP — primary key
CAMPAIGN.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-06 01:05:57	UNUSED	KEEP — primary key
CAMPAIGN.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	19	never	2026-09-06 01:05:57	UNUSED	KEEP — primary key
CAMPAIGN.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y	0	38	0	1	2026-06-13 05:28:43	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.WarehouseMonthly.PK_LedgerStaging	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.SalesDetail.PK_ShiftEntry	1	CLUSTERED	Y	Y	0	48	0	0	2026-06-13 05:28:59	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PolicySummary.PK_ContractHistory	1	CLUSTERED	Y	Y	0	32	0	6	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.BatchDaily.PK_InvoiceEntry	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:54	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShipmentAudit.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.BookingResult.PK_BookingHistory	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:54	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.InvoiceQueue.PK_SettlementHistory	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.QuotaMonthly.PK_ReconcileDaily	1	CLUSTERED	Y	Y	0	32	0	76	2026-06-13 05:29:10	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PayrollSummary.PK_StaffingLine	1	CLUSTERED	Y	Y	0	48	0	0	2026-06-13 05:29:03	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.RouteHistory.PK_TicketEntry	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:56	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.AssetSummary.PK_QuotaArchive	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:52	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.WarehouseEntry.PK_CampaignStaging	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.TerritoryEntry.PK_SettlementEntry	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterResult.PK_ContractDaily	1	CLUSTERED	Y	Y	0	32	0	32	2026-06-13 05:29:09	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PayrollHeader.PK_TerritoryQueue	1	CLUSTERED	Y	Y	0	32	0	39	2026-06-13 05:29:05	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.RosterResult.PK_AssetQueue	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:29:07	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterAudit.PK_SettlementQueue	1	CLUSTERED	Y	Y	0	32	0	19	2026-06-13 05:29:08	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShiftLine.PK_BatchLog	1	CLUSTERED	Y	Y	0	32	0	1	2026-06-13 05:29:13	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignHeader.PK_MeterSummary	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:59	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterStatus.PK_ShiftStaging	1	CLUSTERED	Y	Y	0	48	0	0	2026-06-13 05:28:58	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ForecastHeader.PK_ShiftLine	1	CLUSTERED	Y	Y	0	32	0	1	2026-06-13 05:29:12	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.AssetDaily.PK_ShiftLine	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:29:13	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.StaffingDaily.PK_ContractStatus	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:29:12	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ClaimResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:59	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PricingDaily.PK_SettlementLog	1	CLUSTERED	Y	Y	0	32	0	3	2026-06-13 05:29:08	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PolicyLog.PK_BatchQueue	1	CLUSTERED	Y	Y	0	32	0	20	2026-06-13 05:29:08	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterHistory.PK_ShiftHistory	1	CLUSTERED	Y	Y	0	32	0	67	2026-06-13 05:28:59	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.TerritoryLine.PK_ShipmentAudit	1	CLUSTERED	Y	Y	16	32	0	12	2026-06-13 05:30:17	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.SettlementQueue.PK_PayrollStaging	1	CLUSTERED	Y	Y	0	32	0	11	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.TicketQueue.PK_CatalogStaging	1	CLUSTERED	Y	Y	0	32	0	13	2026-06-13 05:28:59	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.OrdersEntry.PK_RosterMonthly	1	CLUSTERED	Y	Y	0	32	0	1	2026-06-13 05:29:09	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignHistory.PK_ShipmentStatus	1	CLUSTERED	Y	Y	0	32	0	3	2026-06-13 05:29:08	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.TicketLine.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.BatchAudit.PK_BookingDetail	1	CLUSTERED	Y	Y	0	32	0	8063	2026-06-13 05:41:23	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PolicyHistory.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	49	0	16	2026-06-12 03:21:18	2026-09-06 01:05:58	USED	KEEP — primary key
CAMPAIGN.STAFFING.BillingEntry.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	63	0	3329	2026-06-12 03:22:23	2026-09-06 01:06:00	USED	KEEP — primary key
CAMPAIGN.STAFFING.BillingAudit.PK_SettlementAudit	1	CLUSTERED	Y	Y	0	64	0	15	2026-06-12 03:22:41	2026-09-06 01:06:01	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShipmentStaging.PK_QuotaLine	1	CLUSTERED	Y	Y	0	64	0	0	2026-06-12 03:23:02	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.SalesLine.PK_ReconcileDetail	1	CLUSTERED	Y	Y	17	44	0	10582	2026-06-13 05:44:29	2026-09-06 01:06:04	USED	KEEP — primary key
CAMPAIGN.STAFFING.ReconcileDetail.PK_BillingSummary	1	CLUSTERED	Y	Y	0	32	0	20	2026-06-13 05:29:03	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PolicyEntry.PK_PayrollEntry	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ReconcileStaging.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShipmentQueue.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	0	32	0	5	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterStatus.PK_PricingMonthly	1	CLUSTERED	Y	Y	0	32	0	20	2026-06-13 05:29:10	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShiftResult.PK_SalesHistory	1	CLUSTERED	Y	Y	0	32	0	6	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.Level.PK_AssetSnapshot	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:56	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignHeader.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.WarehouseHeader.PK_InvoiceDetail	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.QuotaEntry.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:56	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.QuotaStatus.PK_StaffingMonthly	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.Position.PK_TerritoryDaily	1	CLUSTERED	Y	Y	0	32	0	5	2026-06-13 05:28:55	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignQueue.PK_PolicyHistory	1	CLUSTERED	Y	Y	0	32	0	5	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.RouteQueue.PK_ReconcileStatus	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:46	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.RosterQueue.PK_SalesStatus	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:50	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.TicketAudit.PK_PricingHeader	1	CLUSTERED	Y	Y	0	32	0	5	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CustomerLog.PK_LedgerStatus	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.SupplierStaging.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	16	0	12	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PolicyLine.PK_StaffingStaging	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.RouteStaging.PK_AssetDetail	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:53	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CatalogSnapshot.PK_TicketHeader	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:56	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.BillingDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y	0	32	0	6	2026-06-13 05:30:18	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignAudit.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:47	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PricingArchive.PK_ShipmentHistory	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:57	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.SalesStatus.PK_BillingLog	1	CLUSTERED	Y	Y	0	32	0	4	2026-06-13 05:30:21	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.SettlementQueue.PK_RouteHistory	1	CLUSTERED	Y	Y	0	32	0	4	2026-06-13 05:30:20	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.MeterHistory.PK_ForecastLine	1	CLUSTERED	Y	Y	13	35	0	4	2026-06-13 05:30:21	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShipmentAudit.PK_SalesArchive	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:30:21	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ForecastAudit.PK_MeterSummary	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:56	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PayrollLine.PK_ForecastResult	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:54	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.SupplierArchive.PK_BatchDaily	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:30:21	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CustomerSnapshot.PK_BatchResult	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:30:20	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CampaignResult.PK_ShiftEntry	1	CLUSTERED	Y	Y	0	32	0	4	2026-06-13 05:30:17	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.BookingStaging.PK_RouteMonthly	1	CLUSTERED	Y	Y	0	32	0	2	2026-06-13 05:28:54	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.SupplierResult.PK_OrdersDaily	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:54	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShiftResult.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	32	0	64	2026-06-13 05:29:12	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.ShiftDaily.PK_SettlementResult	1	CLUSTERED	Y	Y	0	32	0	0	2026-06-13 05:28:46	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.PayrollHistory.PK_ClaimArchive	1	CLUSTERED	Y	Y	16	32	0	51	2026-06-13 05:30:16	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.CatalogSummary.PK_RouteHistory	1	CLUSTERED	Y	Y	0	32	0	29	2026-06-13 05:29:05	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.TicketMonthly.PK_RouteEntry	1	CLUSTERED	Y	Y	4	44	0	9	2026-06-13 05:29:08	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.BillingQueue.PK_PolicyMonthly	1	CLUSTERED	Y	Y	0	32	0	23	2026-06-13 05:29:00	never	USED	KEEP — primary key
CAMPAIGN.STAFFING.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	26	751	0	17	2026-09-11 02:15:12	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.app.SalesStaging.PK_TicketLine	1	CLUSTERED	Y	Y	28	0	0	17	2026-09-10 15:53:37	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.app.StaffingLine.PK_TicketLog	1	CLUSTERED	Y	Y	28	0	0	17	2026-09-10 15:53:37	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.app.SalesSummary.PK_OrdersAudit	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:02:39	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.app.ReconcileDetail.PK_ShiftStaging	1	CLUSTERED	Y	Y	11	17	0	17	2026-09-10 15:53:37	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.app.SettlementEntry.PK_TicketQueue	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:02:39	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.app.BatchQueue.PK_LedgerResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:39	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.dbo.AssetSnapshot.PK_PayrollHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
TERRITORY.STAFFING.ContractSnapshot.PK_ContractResult	1	CLUSTERED	Y	Y	28	0	0	17	2026-09-10 15:53:37	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.STAFFING.PolicyHistory.PK_TicketAudit	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:02:59	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaHeader.PK_RouteResult	1	CLUSTERED	Y	Y	1514	857	0	17	2026-09-11 02:15:13	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaArchive.PK_CustomerQueue	1	CLUSTERED	Y	Y	28	214	0	17	2026-09-11 02:18:50	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.STAFFING.AssetLine.PK_ContractDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:47	2026-09-06 01:02:58	USED	KEEP — primary key
TERRITORY.STAFFING.TicketAudit.PK_PricingLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:56	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.CampaignQueue.PK_InvoiceMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:52	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaLog.PK_ShiftResult	1	CLUSTERED	Y	Y	15	751	0	17	2026-09-11 02:15:12	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.BatchLog.PK_SalesMonthly	1	CLUSTERED	Y	Y	17	17	0	17	2026-06-13 02:02:59	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.TicketMonthly.PK_SupplierLine	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.PayrollArchive.PK_PolicyLine	1	CLUSTERED	Y	Y	17	107	0	17	2026-09-11 02:15:01	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.CampaignStatus.PK_TerritoryArchive	1	CLUSTERED	Y	Y	124	749	0	17	2026-09-11 02:15:12	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.CampaignAudit.PK_LedgerHeader	1	CLUSTERED	Y	Y	17	749	0	17	2026-09-11 02:15:12	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.RouteArchive.PK_BookingMonthly	1	CLUSTERED	Y	Y	1085	430	0	17	2026-09-11 02:15:12	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.AssetDetail.PK_CatalogStatus	1	CLUSTERED	Y	Y	550	323	0	17	2026-09-11 02:15:12	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.WarehouseStatus.PK_MeterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:06	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.LedgerSnapshot.PK_SupplierLine	1	CLUSTERED	Y	Y	15	751	0	17	2026-09-11 02:15:12	2026-09-06 01:02:59	USED	KEEP — primary key
TERRITORY.STAFFING.CustomerStatus.PK_SalesDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:59	2026-09-06 01:03:00	USED	KEEP — primary key
TERRITORY.STAFFING.MeterStatus.PK_OrdersLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:08	2026-09-06 01:03:00	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaQueue.PK_BookingQueue	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:08	2026-09-06 01:03:00	USED	KEEP — primary key
TERRITORY.STAFFING.CatalogSummary.PK_AssetLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:06	2026-09-06 01:03:00	USED	KEEP — primary key
TERRITORY.STAFFING.TicketHeader.PK_PolicyResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:02	2026-09-06 01:03:00	USED	KEEP — primary key
TERRITORY.STAFFING.RouteHeader.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:03	2026-09-06 01:03:00	USED	KEEP — primary key
TERRITORY.STAFFING.PolicyHistory.PK_CampaignQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:07	2026-09-06 01:03:00	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastHistory.PK_SupplierHistory	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:07	2026-09-06 01:03:00	USED	KEEP — primary key
TERRITORY.STAFFING.MeterEntry.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	15	3747	0	17	2026-09-11 02:15:12	2026-09-06 01:03:00	USED	KEEP — primary key
TERRITORY.STAFFING.SalesSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y	1298	978	0	17	2026-09-11 02:19:39	2026-09-06 01:03:00	USED	KEEP — primary key
TERRITORY.STAFFING.TicketLine.PK_CustomerEntry	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:13	2026-09-06 01:03:01	USED	KEEP — primary key
TERRITORY.STAFFING.AssetSnapshot.PK_SalesAudit	1	CLUSTERED	Y	Y	17	6	0	17	2026-08-29 15:30:43	2026-09-06 01:03:01	USED	KEEP — primary key
TERRITORY.STAFFING.MeterAudit.PK_ShiftEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:11	2026-09-06 01:03:01	USED	KEEP — primary key
TERRITORY.STAFFING.PolicyEntry.PK_RouteResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:06	2026-09-06 01:03:01	USED	KEEP — primary key
TERRITORY.STAFFING.SalesEntry.PK_WarehouseMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:02	2026-09-06 01:03:01	USED	KEEP — primary key
TERRITORY.STAFFING.MeterArchive.PK_LedgerStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-09-06 01:03:01	USED	KEEP — primary key
TERRITORY.STAFFING.StaffingHistory.PK_ShipmentArchive	1	CLUSTERED	Y	Y	15	2	0	17	2026-06-13 02:03:03	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.BookingQueue.PK_AssetHeader	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:45	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.ShiftDaily.PK_ClaimAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:42	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.InvoiceAudit.PK_PolicyDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:46	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.PolicyResult.PK_SalesHeader	1	CLUSTERED	Y	Y	15	751	0	17	2026-09-11 02:15:12	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.WarehouseLog.PK_ReconcileAudit	1	CLUSTERED	Y	Y	18	323	0	17	2026-09-11 02:16:46	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.ReconcileResult.PK_MeterArchive	1	CLUSTERED	Y	Y	17	107	0	17	2026-09-11 02:15:01	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.ShiftMonthly.PK_PricingArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:42	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.ContractMonthly.PK_CustomerDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:43	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.SalesAudit.PK_BatchArchive	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:49	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.MeterSnapshot.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:42	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.BatchStatus.PK_TerritoryLine	1	CLUSTERED	Y	Y	338	1284	0	17	2026-09-11 02:15:12	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.BookingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y	124	749	0	17	2026-09-11 02:15:12	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.BillingLog.PK_ClaimDaily	1	CLUSTERED	Y	Y	17	749	0	17	2026-09-11 02:15:12	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.ReconcileHistory.PK_StaffingDaily	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.ClaimDetail.PK_RosterLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:13	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastAudit.PK_WarehouseHistory	1	CLUSTERED	Y	Y	17	214	0	17	2026-09-11 02:17:47	2026-09-06 01:03:02	USED	KEEP — primary key
TERRITORY.STAFFING.CatalogHeader.PK_ShiftMonthly	1	CLUSTERED	Y	Y	17	107	0	17	2026-09-11 02:16:46	2026-09-06 01:03:03	USED	KEEP — primary key
TERRITORY.STAFFING.InvoiceHistory.PK_StaffingQueue	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:13	2026-09-06 01:03:03	USED	KEEP — primary key
TERRITORY.STAFFING.BookingDetail.PK_RosterResult	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:47	2026-09-06 01:03:03	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaSummary.PK_RosterStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-09-06 01:03:03	USED	KEEP — primary key
TERRITORY.STAFFING.WarehouseEntry.PK_ShiftDetail	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:13	2026-09-06 01:03:03	USED	KEEP — primary key
TERRITORY.STAFFING.RosterSummary.PK_PricingMonthly	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:43	2026-09-06 01:03:03	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastDetail.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	17	107	0	17	2026-09-11 02:18:50	2026-09-06 01:03:03	USED	KEEP — primary key
TERRITORY.STAFFING.CampaignQueue.PK_PayrollEntry	1	CLUSTERED	Y	Y	13	4	0	17	2026-06-13 02:03:17	2026-09-06 01:03:03	USED	KEEP — primary key
TERRITORY.STAFFING.ClaimStaging.PK_SupplierHeader	1	CLUSTERED	Y	Y	10	7	0	17	2026-06-13 02:03:17	2026-09-06 01:03:07	USED	KEEP — primary key
TERRITORY.STAFFING.PayrollMonthly.PK_MeterSnapshot	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:17	2026-09-06 01:03:07	USED	KEEP — primary key
TERRITORY.STAFFING.StaffingQueue.PK_CatalogLine	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:16	never	USED	KEEP — primary key
TERRITORY.STAFFING.RosterEntry.PK_BookingStatus	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:52	2026-09-06 01:03:07	USED	KEEP — primary key
TERRITORY.STAFFING.AssetStatus.PK_TicketEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:55	2026-09-06 01:03:07	USED	KEEP — primary key
TERRITORY.STAFFING.AssetLine.PK_ForecastSummary	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:16	2026-09-06 01:03:07	USED	KEEP — primary key
TERRITORY.STAFFING.TicketQueue.PK_CatalogAudit	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:17	2026-09-06 01:03:07	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastEntry.PK_RosterAudit	1	CLUSTERED	Y	Y	17	107	0	17	2026-09-11 02:17:47	2026-09-06 01:03:08	USED	KEEP — primary key
TERRITORY.STAFFING.CustomerLog.PK_BillingEntry	1	CLUSTERED	Y	Y	16	1	0	17	2026-06-13 02:02:55	2026-09-06 01:03:08	USED	KEEP — primary key
TERRITORY.STAFFING.CampaignSummary.PK_RouteDetail	1	CLUSTERED	Y	Y	17	11	0	17	2026-09-10 15:53:37	2026-09-06 01:03:08	USED	KEEP — primary key
TERRITORY.STAFFING.LedgerStaging.PK_ForecastEntry	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:03:12	2026-09-06 01:03:09	USED	KEEP — primary key
TERRITORY.STAFFING.ReconcileLine.PK_PolicyDetail	1	CLUSTERED	Y	Y	766	0	0	17	2026-09-11 02:15:12	2026-09-06 01:03:08	USED	KEEP — primary key
TERRITORY.STAFFING.SettlementEntry.PK_ShiftLine	1	CLUSTERED	Y	Y	784	192	0	68	2026-09-11 02:15:13	2026-09-06 01:03:08	USED	KEEP — primary key
TERRITORY.STAFFING.BillingDetail.PK_TicketStatus	1	CLUSTERED	Y	Y	23	1610	0	17	2026-09-11 02:15:12	2026-09-06 01:03:08	USED	KEEP — primary key
TERRITORY.STAFFING.ShiftSnapshot.PK_BillingResult	1	CLUSTERED	Y	Y	0	17	0	17	2026-06-13 02:03:11	2026-09-06 01:03:09	USED	KEEP — primary key
TERRITORY.STAFFING.QuotaSnapshot.PK_OrdersLog	1	CLUSTERED	Y	Y	17	118	0	17	2026-09-11 02:15:01	2026-09-06 01:03:09	USED	KEEP — primary key
TERRITORY.STAFFING.CustomerStatus.PK_PayrollLog	1	CLUSTERED	Y	Y	17	0	0	17	2026-06-13 02:02:51	2026-09-06 01:03:09	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastSummary.PK_BatchQueue	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
TERRITORY.STAFFING.MeterHistory.PK_LedgerQueue	1	CLUSTERED	Y	Y	535	347	0	749	2026-09-11 02:19:56	2026-09-06 01:03:09	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastLine.PK_StaffingAudit	1	CLUSTERED	Y	Y	17	141	0	34	2026-09-11 02:17:55	2026-09-06 01:03:10	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastLine.UX_ShiftQueue	8	NONCLUSTERED	Y		431	107	0	34	2026-09-11 02:19:56	2026-09-06 01:03:13	USED	keep — in use
TERRITORY.STAFFING.SupplierResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	0	107	0	107	2026-09-11 02:17:01	2026-09-06 01:03:16	USED	KEEP — primary key
TERRITORY.STAFFING.ReconcileDaily.PK_OrdersQueue	1	CLUSTERED	Y	Y	30	128	0	34	2026-09-11 02:15:13	2026-09-06 01:03:18	USED	KEEP — primary key
TERRITORY.STAFFING.WarehouseEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	21	247	0	34	2026-09-11 02:15:31	2026-09-06 01:03:19	USED	KEEP — primary key
TERRITORY.STAFFING.PricingQueue.PK_RouteSnapshot	1	CLUSTERED	Y	Y	34	231	0	34	2026-09-11 02:19:56	2026-09-06 01:03:19	USED	KEEP — primary key
TERRITORY.STAFFING.SettlementHeader.PK_CatalogHistory	1	CLUSTERED	Y	Y	15	19	0	34	2026-06-13 02:06:40	2026-09-06 01:03:20	USED	KEEP — primary key
TERRITORY.STAFFING.ShiftStaging.PK_RosterArchive	1	CLUSTERED	Y	Y	17	354	0	34	2026-09-11 02:18:50	2026-09-06 01:03:20	USED	KEEP — primary key
TERRITORY.STAFFING.ForecastHeader.IX_ReconcileDetail	2	NONCLUSTERED			598	0	0	107	2026-09-11 02:15:12	2026-09-06 01:03:21	USED	keep — in use
TERRITORY.STAFFING.ForecastHeader.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	258	598	107	2026-09-11 02:15:12	2026-09-06 01:03:21	USED	KEEP — primary key
TERRITORY.STAFFING.StaffingStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y	3	214	0	107	2026-09-11 02:19:56	2026-09-06 01:03:21	USED	KEEP — primary key
TERRITORY.STAFFING.LedgerResult.PK_AssetDaily	1	CLUSTERED	Y	Y	73	141	0	214	2026-09-11 02:18:50	2026-09-08 01:02:41	USED	KEEP — primary key
TERRITORY.STAFFING.ShipmentLog.PK_PolicyLog	1	CLUSTERED	Y	Y	4	1926	0	1284	2026-09-11 02:18:50	2026-09-06 01:03:21	USED	KEEP — primary key
TERRITORY.STAFFING.SupplierQueue.PK_SettlementMonthly	1	CLUSTERED	Y	Y	0	107	0	107	2026-09-11 02:19:46	2026-09-06 01:03:31	USED	KEEP — primary key
TERRITORY.STAFFING.PayrollResult.PK_TicketAudit	1	CLUSTERED	Y	Y	4	214	0	107	2026-09-11 02:19:56	2026-09-06 01:03:32	USED	KEEP — primary key
TERRITORY.STAFFING.InvoiceHistory.PK_CampaignDetail	1	CLUSTERED	Y	Y	11	1243	0	214	2026-09-11 02:19:56	2026-09-06 01:03:33	USED	KEEP — primary key
TERRITORY.STAFFING.BatchStaging.PK_CampaignHeader	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:02:59	2026-09-06 01:03:34	USED	KEEP — primary key
TERRITORY.STAFFING.CustomerDetail.PK_WarehouseDetail	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:02:59	2026-09-06 01:03:42	USED	KEEP — primary key
TERRITORY.STAFFING.PolicyEntry.PK_QuotaMonthly	1	CLUSTERED	Y	Y	0	17	0	60	2026-06-13 02:03:06	2026-09-06 01:03:43	USED	KEEP — primary key
TERRITORY.STAFFING.MeterEntry.PK_RosterStatus	1	CLUSTERED	Y	Y	0	17	0	475	2026-06-13 02:02:59	2026-09-06 01:03:44	USED	KEEP — primary key
TERRITORY.STAFFING.AssetLine.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:06	2026-09-06 01:03:44	USED	KEEP — primary key
TERRITORY.STAFFING.SupplierHeader.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	17	0	315	2026-06-13 02:03:17	2026-09-12 01:02:25	USED	KEEP — primary key
TERRITORY.STAFFING.SupplierResult.PK_StaffingDaily	1	CLUSTERED	Y	Y	0	17	0	23784	2026-06-13 02:03:17	2026-09-12 01:02:47	USED	KEEP — primary key
TERRITORY.STAFFING.BookingResult.PK_ClaimLog	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:17	never	USED	KEEP — primary key
TERRITORY.STAFFING.InvoiceEntry.PK_ForecastLine	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:16	never	USED	KEEP — primary key
TERRITORY.STAFFING.ReconcileLog.PK_CampaignQueue	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:16	2026-09-06 01:04:00	USED	KEEP — primary key
TERRITORY.STAFFING.OrdersArchive.PK_ContractAudit	1	CLUSTERED	Y	Y	0	17	0	0	2026-06-13 02:03:17	2026-09-06 01:04:00	USED	KEEP — primary key
TERRITORY.STAFFING.ClaimResult.PK_RosterEntry	1	CLUSTERED	Y	Y	0	34	0	21809	2026-06-13 02:03:03	2026-09-06 01:04:03	USED	KEEP — primary key
SUPPLIER.dbo.PricingEntry.PK_ClaimQueue	1	CLUSTERED	Y	Y	28	26	0	44	2026-06-13 02:06:44	2026-09-06 01:04:03	USED	KEEP — primary key
SUPPLIER.dbo.CatalogEntry.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	54	never	2026-09-06 01:04:04	UNUSED	KEEP — primary key
SUPPLIER.dbo.SalesLine.PK_ContractMonthly	1	CLUSTERED	Y	Y	3605	1	0	1488	2026-06-13 02:02:26	2026-09-06 01:04:04	USED	KEEP — primary key
SUPPLIER.dbo.RosterStaging.PK_ShiftResult	1	CLUSTERED	Y	Y	0	0	0	3018	never	2026-09-06 01:04:04	UNUSED	KEEP — primary key
SUPPLIER.dbo.RosterQueue.PK_TerritoryDaily	1	CLUSTERED	Y	Y	2992	0	0	1496	2026-06-13 02:06:40	2026-09-06 01:04:04	USED	KEEP — primary key
SUPPLIER.dbo.RosterLog.PK_BatchHistory	1	CLUSTERED	Y	Y	0	0	0	2992	never	2026-09-06 01:04:04	UNUSED	KEEP — primary key
SUPPLIER.dbo.ClaimLog.PK_SalesDetail	1	CLUSTERED	Y	Y	32830	3283	0	32830	2026-09-12 01:03:57	2026-09-06 01:04:04	USED	KEEP — primary key
SUPPLIER.dbo.PolicyHeader.PK_BillingStatus	1	CLUSTERED	Y	Y	0	641	0	32830	2026-08-21 13:03:55	2026-09-12 01:02:49	USED	KEEP — primary key
SUPPLIER.dbo.Source.PK_QuotaDaily	1	CLUSTERED	Y	Y	0	26	0	0	2026-06-13 02:00:03	2026-09-06 01:04:04	USED	KEEP — primary key
INVOICE.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:02:41	never	USED	KEEP — primary key
INVOICE.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y	0	34	0	0	2026-06-13 02:02:40	never	USED	KEEP — primary key
INVOICE.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y	0	34	0	3	2026-06-13 02:02:38	never	USED	KEEP — primary key
INVOICE.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y	1	50	0	4	2026-06-13 02:02:39	never	USED	KEEP — primary key
INVOICE.app.WarehouseStatus.PK_BatchDaily	1	CLUSTERED	Y	Y	17	34	0	2	2026-06-13 02:02:39	never	USED	KEEP — primary key
INVOICE.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y	0	51	0	4	2026-06-13 02:02:39	never	USED	KEEP — primary key
INVOICE.app.SalesLine.PK_PricingDetail	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-06 01:04:06	UNUSED	KEEP — primary key
INVOICE.app.WarehouseArchive.PK_SupplierDetail	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-06 01:04:06	UNUSED	KEEP — primary key
INVOICE.app.BookingQueue.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-06 01:04:06	UNUSED	KEEP — primary key
INVOICE.app.ShipmentAudit.PK_ReconcileEntry	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-06 01:04:06	UNUSED	KEEP — primary key
INVOICE.app.PolicyStaging.PK_PricingResult	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-06 01:04:06	UNUSED	KEEP — primary key
INVOICE.app.CatalogLog.PK_ShipmentHeader	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-06 01:04:06	UNUSED	KEEP — primary key
INVOICE.app.ShipmentAudit.PK_ShipmentMonthly	1	CLUSTERED	Y	Y	0	0	0	17	never	2026-09-06 01:04:06	UNUSED	KEEP — primary key
INVOICE.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y	0	34	0	1	2026-06-13 02:02:39	never	USED	KEEP — primary key
INVOICE.STAFFING.WarehouseMonthly.PK_LedgerStaging	1	CLUSTERED	Y	Y	0	38	0	5	2026-06-13 02:02:52	never	USED	KEEP — primary key
INVOICE.STAFFING.SalesDetail.PK_ShiftEntry	1	CLUSTERED	Y	Y	17	38	0	4	2026-06-13 02:02:59	never	USED	KEEP — primary key
INVOICE.STAFFING.PolicySummary.PK_ContractHistory	1	CLUSTERED	Y	Y	0	38	0	12	2026-06-13 02:02:52	never	USED	KEEP — primary key
INVOICE.STAFFING.BatchDaily.PK_InvoiceEntry	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:47	never	USED	KEEP — primary key
INVOICE.STAFFING.ShipmentAudit.PK_QuotaHistory	1	CLUSTERED	Y	Y	0	38	0	5	2026-06-13 02:02:47	never	USED	KEEP — primary key
INVOICE.STAFFING.BookingResult.PK_BookingHistory	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:56	never	USED	KEEP — primary key
INVOICE.STAFFING.InvoiceQueue.PK_SettlementHistory	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:52	never	USED	KEEP — primary key
INVOICE.STAFFING.QuotaMonthly.PK_ReconcileDaily	1	CLUSTERED	Y	Y	0	38	0	28	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.STAFFING.PayrollSummary.PK_StaffingLine	1	CLUSTERED	Y	Y	17	38	0	4	2026-06-13 02:03:00	never	USED	KEEP — primary key
INVOICE.STAFFING.RouteHistory.PK_TicketEntry	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.STAFFING.AssetSummary.PK_QuotaArchive	1	CLUSTERED	Y	Y	0	38	0	5	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.STAFFING.WarehouseEntry.PK_CampaignStaging	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:42	never	USED	KEEP — primary key
INVOICE.STAFFING.TerritoryEntry.PK_SettlementEntry	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:41	never	USED	KEEP — primary key
INVOICE.STAFFING.MeterResult.PK_ContractDaily	1	CLUSTERED	Y	Y	0	38	0	16	2026-06-13 02:02:58	never	USED	KEEP — primary key
INVOICE.STAFFING.PayrollHeader.PK_TerritoryQueue	1	CLUSTERED	Y	Y	0	38	0	18	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.STAFFING.RosterResult.PK_AssetQueue	1	CLUSTERED	Y	Y	0	38	0	6	2026-06-13 02:03:06	never	USED	KEEP — primary key
INVOICE.STAFFING.MeterAudit.PK_SettlementQueue	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:03:12	never	USED	KEEP — primary key
INVOICE.STAFFING.ShiftLine.PK_BatchLog	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:02:59	never	USED	KEEP — primary key
INVOICE.STAFFING.CampaignHeader.PK_MeterSummary	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:08	never	USED	KEEP — primary key
INVOICE.STAFFING.MeterStatus.PK_ShiftStaging	1	CLUSTERED	Y	Y	17	38	0	4	2026-06-13 02:03:08	never	USED	KEEP — primary key
INVOICE.STAFFING.ForecastHeader.PK_ShiftLine	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:06	never	USED	KEEP — primary key
INVOICE.STAFFING.AssetDaily.PK_ShiftLine	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:02	never	USED	KEEP — primary key
INVOICE.STAFFING.StaffingDaily.PK_ContractStatus	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.STAFFING.ClaimResult.PK_OrdersEntry	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:07	never	USED	KEEP — primary key
INVOICE.STAFFING.PricingDaily.PK_SettlementLog	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:07	never	USED	KEEP — primary key
INVOICE.STAFFING.PolicyLog.PK_BatchQueue	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:03:07	never	USED	KEEP — primary key
INVOICE.STAFFING.MeterHistory.PK_ShiftHistory	1	CLUSTERED	Y	Y	0	38	0	28	2026-06-13 02:02:59	never	USED	KEEP — primary key
INVOICE.STAFFING.TerritoryLine.PK_ShipmentAudit	1	CLUSTERED	Y	Y	17	38	0	12	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.STAFFING.SettlementQueue.PK_PayrollStaging	1	CLUSTERED	Y	Y	0	38	0	11	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.STAFFING.TicketQueue.PK_CatalogStaging	1	CLUSTERED	Y	Y	0	38	0	12	2026-06-13 02:03:11	never	USED	KEEP — primary key
INVOICE.STAFFING.OrdersEntry.PK_RosterMonthly	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:06	never	USED	KEEP — primary key
INVOICE.STAFFING.CampaignHistory.PK_ShipmentStatus	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 02:03:02	never	USED	KEEP — primary key
INVOICE.STAFFING.TicketLine.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.STAFFING.BatchAudit.PK_BookingDetail	1	CLUSTERED	Y	Y	0	38	0	2938	2026-06-13 02:04:19	never	USED	KEEP — primary key
INVOICE.STAFFING.PolicyHistory.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	72	0	27	2026-06-13 02:06:23	never	USED	KEEP — primary key
INVOICE.STAFFING.BillingEntry.PK_ForecastHeader	1	CLUSTERED	Y	Y	0	72	0	585	2026-06-13 02:06:38	never	USED	KEEP — primary key
INVOICE.STAFFING.BillingAudit.PK_SettlementAudit	1	CLUSTERED	Y	Y	0	72	0	10	2026-06-13 02:06:40	never	USED	KEEP — primary key
INVOICE.STAFFING.ShipmentStaging.PK_QuotaLine	1	CLUSTERED	Y	Y	0	55	0	4	2026-06-13 02:06:40	never	USED	KEEP — primary key
INVOICE.STAFFING.SalesLine.PK_ReconcileDetail	1	CLUSTERED	Y	Y	17	54	0	3227	2026-06-13 02:06:11	never	USED	KEEP — primary key
INVOICE.STAFFING.ReconcileDetail.PK_BillingSummary	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.STAFFING.PolicyEntry.PK_PayrollEntry	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:45	never	USED	KEEP — primary key
INVOICE.STAFFING.ReconcileStaging.PK_ForecastSnapshot	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:42	never	USED	KEEP — primary key
INVOICE.STAFFING.ShipmentQueue.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 02:02:46	never	USED	KEEP — primary key
INVOICE.STAFFING.MeterStatus.PK_PricingMonthly	1	CLUSTERED	Y	Y	0	38	0	14	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.STAFFING.ShiftResult.PK_SalesHistory	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 02:02:46	never	USED	KEEP — primary key
INVOICE.STAFFING.Level.PK_AssetSnapshot	1	CLUSTERED	Y	Y	0	38	0	5	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.STAFFING.CampaignHeader.PK_CampaignStatus	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:42	never	USED	KEEP — primary key
INVOICE.STAFFING.WarehouseHeader.PK_InvoiceDetail	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:43	never	USED	KEEP — primary key
INVOICE.STAFFING.QuotaEntry.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	38	0	5	2026-06-13 02:02:50	never	USED	KEEP — primary key
INVOICE.STAFFING.QuotaStatus.PK_StaffingMonthly	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:42	never	USED	KEEP — primary key
INVOICE.STAFFING.Position.PK_TerritoryDaily	1	CLUSTERED	Y	Y	0	38	0	10	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.STAFFING.CampaignQueue.PK_PolicyHistory	1	CLUSTERED	Y	Y	0	38	0	10	2026-06-13 02:02:46	never	USED	KEEP — primary key
INVOICE.STAFFING.RouteQueue.PK_ReconcileStatus	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:44	never	USED	KEEP — primary key
INVOICE.STAFFING.RosterQueue.PK_SalesStatus	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.STAFFING.TicketAudit.PK_PricingHeader	1	CLUSTERED	Y	Y	0	38	0	6	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.STAFFING.CustomerLog.PK_LedgerStatus	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.STAFFING.SupplierStaging.PK_PolicySnapshot	1	CLUSTERED	Y	Y	0	21	0	11	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.STAFFING.PolicyLine.PK_StaffingStaging	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.STAFFING.RouteStaging.PK_AssetDetail	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:47	never	USED	KEEP — primary key
INVOICE.STAFFING.CatalogSnapshot.PK_TicketHeader	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:51	never	USED	KEEP — primary key
INVOICE.STAFFING.BillingDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y	0	38	0	6	2026-06-13 02:03:13	never	USED	KEEP — primary key
INVOICE.STAFFING.CampaignAudit.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:43	never	USED	KEEP — primary key
INVOICE.STAFFING.PricingArchive.PK_ShipmentHistory	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:56	never	USED	KEEP — primary key
INVOICE.STAFFING.SalesStatus.PK_BillingLog	1	CLUSTERED	Y	Y	0	38	0	11	2026-06-13 02:03:17	never	USED	KEEP — primary key
INVOICE.STAFFING.SettlementQueue.PK_RouteHistory	1	CLUSTERED	Y	Y	0	38	0	18	2026-06-13 02:03:17	never	USED	KEEP — primary key
INVOICE.STAFFING.MeterHistory.PK_ForecastLine	1	CLUSTERED	Y	Y	14	41	0	18	2026-06-13 02:03:17	never	USED	KEEP — primary key
INVOICE.STAFFING.ShipmentAudit.PK_SalesArchive	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:16	never	USED	KEEP — primary key
INVOICE.STAFFING.ForecastAudit.PK_MeterSummary	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:52	never	USED	KEEP — primary key
INVOICE.STAFFING.PayrollLine.PK_ForecastResult	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:55	never	USED	KEEP — primary key
INVOICE.STAFFING.SupplierArchive.PK_BatchDaily	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:16	never	USED	KEEP — primary key
INVOICE.STAFFING.CustomerSnapshot.PK_BatchResult	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:03:17	never	USED	KEEP — primary key
INVOICE.STAFFING.CampaignResult.PK_ShiftEntry	1	CLUSTERED	Y	Y	0	38	0	12	2026-06-13 02:03:15	never	USED	KEEP — primary key
INVOICE.STAFFING.BookingStaging.PK_RouteMonthly	1	CLUSTERED	Y	Y	0	38	0	8	2026-06-13 02:02:55	never	USED	KEEP — primary key
INVOICE.STAFFING.SupplierResult.PK_OrdersDaily	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:52	never	USED	KEEP — primary key
INVOICE.STAFFING.ShiftResult.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	38	0	12	2026-06-13 02:03:12	never	USED	KEEP — primary key
INVOICE.STAFFING.ShiftDaily.PK_SettlementResult	1	CLUSTERED	Y	Y	0	38	0	4	2026-06-13 02:02:42	never	USED	KEEP — primary key
INVOICE.STAFFING.PayrollHistory.PK_ClaimArchive	1	CLUSTERED	Y	Y	17	38	0	9	2026-06-13 02:03:03	never	USED	KEEP — primary key
INVOICE.STAFFING.CatalogSummary.PK_RouteHistory	1	CLUSTERED	Y	Y	0	38	0	13	2026-06-13 02:03:09	never	USED	KEEP — primary key
INVOICE.STAFFING.TicketMonthly.PK_RouteEntry	1	CLUSTERED	Y	Y	4	51	0	8	2026-06-13 02:03:11	never	USED	KEEP — primary key
INVOICE.STAFFING.BillingQueue.PK_PolicyMonthly	1	CLUSTERED	Y	Y	0	38	0	13	2026-06-13 02:03:09	never	USED	KEEP — primary key
INVOICE.STAFFING.QuotaResult.PK_InvoiceResult	1	CLUSTERED	Y	Y	0	38	0	7	2026-06-13 02:02:51	never	USED	KEEP — primary key