Index Usage — ACME-198-51-100-92

Index reportsACME-203-0-113-170 ACME-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-99ACME-198-51-100-92ACME-203-0-113-69 ACME-192-0-2-97 ACME-192-0-2-242 ACME-203-0-113-155

Index Usage Report — ACME-198-51-100-92

Host: 198.51.100.92

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

Server dashboard: http://192.0.2.15:8080/report_dba/server-metrics.html?server=ACME-198-51-100-92

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	148	every index on a CatalogHistory table
used	66	had a seek, scan or lookup
unused	20	written but never read
cold	62	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	23	nonclustered, not unique, no constraint, never read
fragmented	1	above the rebuild threshold

By database

Database	Total	Cold	Droppable	Recommend action
STAFFING	72	30	15	review the drop candidates above
BILLING	41	29	4	review the drop candidates above
ROUTE	32	1	4	review the drop candidates above
POLICY	2	2	0	no action — cold indexes here are constraints or clustered

Drop candidates (23)

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
ROUTE.dbo.BillingQueue.IX_SettlementStaging	4985	never	UNUSED	review, then DROP
STAFFING.dbo.BillingQueue.IX_CatalogHeader	1670	never	UNUSED	review, then DROP
ROUTE.dbo.LedgerDetail.IX_PolicyAudit	1659	never	UNUSED	review, then DROP
STAFFING.dbo.Batch.IX_InvoiceEntry	1659	never	UNUSED	review, then DROP
STAFFING.dbo.ReconcileLog.IX_CustomerLine	1659	never	UNUSED	review, then DROP
ROUTE.dbo.SalesLog.IX_WarehouseStaging	1656	never	UNUSED	review, then DROP
ROUTE.dbo.BatchLine.IX_TicketEntry	1656	never	UNUSED	review, then DROP
BILLING.dbo.PolicyEntry.IX_SettlementAudit	0	never	COLD	review, then DROP
BILLING.dbo.PolicyEntry.IX_ShiftStatus	0	never	COLD	review, then DROP
BILLING.dbo.PolicyEntry.IX_ShipmentDetail	0	never	COLD	review, then DROP
BILLING.dbo.PolicyEntry.IX_WarehouseMonthly	0	never	COLD	review, then DROP
STAFFING.dbo.BookingQueue.IX_CampaignQueue	0	never	COLD	review, then DROP
STAFFING.dbo.BookingQueue.IX_ShipmentAudit	0	never	COLD	review, then DROP
STAFFING.dbo.BookingQueue.IX_WarehouseArchive	0	never	COLD	review, then DROP
STAFFING.dbo.BookingQueue.IX_ClaimStaging	0	never	COLD	review, then DROP
STAFFING.dbo.AssetLine.IX_TicketEntry	0	never	COLD	review, then DROP
STAFFING.dbo.QuotaHeader.IX_ClaimSnapshot	0	never	COLD	review, then DROP
STAFFING.dbo.QuotaHeader.IX_CatalogResult	0	never	COLD	review, then DROP
STAFFING.dbo.History.IX_ClaimStaging	0	never	COLD	review, then DROP
STAFFING.dbo.ShiftStaging.IX_RouteDetail	0	never	COLD	review, then DROP
STAFFING.dbo.ClaimEntry.IX_ForecastHistory	0	never	COLD	review, then DROP
STAFFING.dbo.ClaimEntry.IX_CampaignDetail	0	never	COLD	review, then DROP
STAFFING.dbo.ClaimEntry.IX_PayrollStatus	0	never	COLD	review, then DROP

Fragmented (1)

Total 479.8 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
BILLING\dbo.AssetArchive.IX_SupplierDaily	1/1	CLUSTERED	68.6%	61,415	479.8	2026-06-10 08:01:09	REBUILD

All indexes (148)

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
STAFFING.dbo.BookingAudit.PK_InvoiceLine	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.Batch.IX_ShiftStatus	1	CLUSTERED			1659	1659	0	1659	2026-09-12 00:59:32	never	USED	KEEP — table storage
STAFFING.dbo.Batch.IX_InvoiceEntry	2	NONCLUSTERED			0	0	0	1659	never	never	UNUSED	review, then DROP
STAFFING.dbo.SalesHistory.IX_CampaignArchive	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
STAFFING.dbo.SalesHistory.PK_BatchDetail	2	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.BookingQueue.IX_PricingArchive	1	CLUSTERED	Y		0	6636	99346	0	2026-09-12 01:01:13	never	USED	KEEP — table storage
STAFFING.dbo.BookingQueue.IX_CampaignQueue	6	NONCLUSTERED			0	0	0	0	never	2025-01-06 14:05:06	COLD	review, then DROP
STAFFING.dbo.BookingQueue.IX_ShipmentAudit	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
STAFFING.dbo.BookingQueue.IX_WarehouseArchive	4	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
STAFFING.dbo.BookingQueue.IX_ClaimStaging	5	NONCLUSTERED			0	0	0	0	never	2025-01-06 14:04:52	COLD	review, then DROP
STAFFING.dbo.BookingQueue.PK_AssetDetail	2	NONCLUSTERED	Y	Y	99346	0	0	0	2026-09-12 01:01:13	2025-01-06 14:05:08	USED	KEEP — primary key
STAFFING.dbo.MeterDetail.IX_MeterQueue	1	CLUSTERED	Y		0	11	0	1670	2026-09-11 01:59:59	never	USED	KEEP — table storage
STAFFING.dbo.MeterDetail.PK_ContractAudit	2	NONCLUSTERED	Y	Y	0	1659	0	1670	2026-09-12 00:59:32	never	USED	KEEP — primary key
STAFFING.dbo.OrdersDaily.IX_SupplierQueue	3	NONCLUSTERED			1681	1670	0	1670	2026-09-12 00:59:32	never	USED	keep — in use
STAFFING.dbo.OrdersDaily.PK_CampaignResult	1	CLUSTERED	Y	Y	0	0	0	1670	never	never	UNUSED	KEEP — primary key
STAFFING.dbo.OrdersDaily.IX_RouteDaily	2	NONCLUSTERED	Y		0	11	0	1670	2026-09-11 01:59:59	never	USED	keep — in use
STAFFING.dbo.PolicyLine.IX_TicketSnapshot	1	CLUSTERED	Y		71	0	0	0	2026-09-12 00:29:32	2025-01-06 14:04:52	USED	KEEP — table storage
STAFFING.dbo.PolicyLine.PK_SettlementStaging	2	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.CustomerQueue.PK_BillingLine	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.AssetLine.IX_TicketEntry	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
STAFFING.dbo.AssetLine.IX_StaffingArchive	1	CLUSTERED			0	0	0	0	never	never	COLD	KEEP — table storage
STAFFING.dbo.AssetLine.PK_ContractEntry	3	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.QuotaHeader.IX_ClaimSnapshot	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
STAFFING.dbo.QuotaHeader.IX_CatalogResult	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
STAFFING.dbo.QuotaHeader.PK_BatchEntry	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.Event.IX_RouteStaging	2	NONCLUSTERED			0	1128	0	100474	2026-09-12 00:59:32	never	USED	keep — in use
STAFFING.dbo.Event.IX_ClaimSummary	4	NONCLUSTERED			0	198692	0	0	2026-09-12 01:01:13	never	USED	keep — in use
STAFFING.dbo.Event.PK_TicketHistory	1	CLUSTERED	Y	Y	100474	0	198692	100474	2026-09-12 01:01:13	never	USED	KEEP — primary key
STAFFING.dbo.ShipmentMonthly.IX_ForecastQueue	2	NONCLUSTERED			0	11	0	11	2026-09-11 01:59:59	never	USED	keep — in use
STAFFING.dbo.ShipmentMonthly.PK_SupplierArchive	1	CLUSTERED	Y	Y	0	0	0	11	never	never	UNUSED	KEEP — primary key
STAFFING.dbo.History.IX_RosterMonthly	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
STAFFING.dbo.History.IX_ClaimStaging	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
STAFFING.dbo.History.PK_CatalogQueue	2	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.MeterResult.PK_LedgerMonthly	1	CLUSTERED	Y	Y	48	72	0	0	2026-09-12 00:29:32	2025-01-06 14:05:07	USED	KEEP — primary key
STAFFING.dbo.SupplierAudit.IX_PricingQueue	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
STAFFING.dbo.SupplierAudit.PK_BillingEntry	2	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.PayrollHistory.IX_BillingDaily	1	CLUSTERED			0	4977	0	3318	2026-09-12 00:59:32	never	USED	KEEP — table storage
STAFFING.dbo.PayrollHistory.PK_CustomerSummary	2	NONCLUSTERED	Y	Y	0	0	0	3318	never	never	UNUSED	KEEP — primary key
STAFFING.dbo.StaffingMonthly.IX_ForecastAudit	1	CLUSTERED			0	0	0	0	never	never	COLD	KEEP — table storage
STAFFING.dbo.ShiftStaging.IX_RouteDetail	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
STAFFING.dbo.ShiftStaging.IX_LedgerSummary	3	NONCLUSTERED			0	1128	0	101602	2026-09-12 00:59:32	never	USED	keep — in use
STAFFING.dbo.ShiftStaging.IX_RosterHeader	4	NONCLUSTERED			0	198692	0	0	2026-09-12 01:01:13	never	USED	keep — in use
STAFFING.dbo.ShiftStaging.PK_CatalogLog	1	CLUSTERED	Y	Y	101602	1128	198692	101602	2026-09-12 01:01:13	never	USED	KEEP — primary key
STAFFING.dbo.Policies.PK_CatalogResult	1	CLUSTERED	Y	Y	0	3318	0	3318	2026-09-12 00:59:32	2025-01-06 14:15:08	USED	KEEP — primary key
STAFFING.dbo.LedgerEntry.IX_SettlementQueue	1	CLUSTERED	Y		0	0	0	3318	never	never	UNUSED	KEEP — table storage
STAFFING.dbo.LedgerEntry.PK_MeterArchive	2	NONCLUSTERED	Y	Y	0	3318	0	3318	2026-09-12 00:59:32	never	USED	KEEP — primary key
STAFFING.dbo.ClaimEntry.IX_ForecastHistory	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
STAFFING.dbo.ClaimEntry.IX_CampaignDetail	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
STAFFING.dbo.ClaimEntry.IX_PayrollStatus	4	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
STAFFING.dbo.PricingQueue.IX_AssetStaging	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
STAFFING.dbo.PricingQueue.PK_PricingAudit	2	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.ReconcileLog.IX_CustomerLine	2	NONCLUSTERED			0	0	0	1659	never	never	UNUSED	review, then DROP
STAFFING.dbo.ReconcileLog.PK_RosterLog	1	CLUSTERED	Y	Y	0	18232	0	1659	2026-09-12 01:00:32	never	USED	KEEP — primary key
STAFFING.dbo.Schedule.IX_TerritoryDetail	2	NONCLUSTERED	Y		0	24	0	0	2026-09-12 00:29:32	never	USED	keep — in use
STAFFING.dbo.Schedule.PK_PricingAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.BatchLog.IX_OrdersDaily	1	CLUSTERED	Y		102664	0	0	3318	2026-09-12 01:01:13	2025-01-06 14:05:08	USED	KEEP — table storage
STAFFING.dbo.BatchLog.PK_PayrollDaily	2	NONCLUSTERED	Y	Y	0	0	0	3318	never	never	UNUSED	KEEP — primary key
STAFFING.dbo.OrdersStaging.IX_RouteHeader	2	NONCLUSTERED	Y		0	1681	0	1670	2026-09-12 00:59:32	never	USED	keep — in use
STAFFING.dbo.OrdersStaging.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	1670	never	never	UNUSED	KEEP — primary key
STAFFING.dbo.PolicyStatus.IX_TicketMonthly	2	NONCLUSTERED			1681	0	0	1670	2026-09-12 00:59:32	never	USED	keep — in use
STAFFING.dbo.PolicyStatus.PK_ClaimDaily	1	CLUSTERED	Y	Y	0	0	0	1670	never	never	UNUSED	KEEP — primary key
STAFFING.dbo.PolicyStatus.IX_SupplierDetail	3	NONCLUSTERED	Y		0	1681	0	1670	2026-09-12 00:59:32	never	USED	keep — in use
STAFFING.dbo.OrdersDetail.IX_SupplierDaily	2	NONCLUSTERED			11	0	0	11	2026-09-11 01:59:59	never	USED	keep — in use
STAFFING.dbo.OrdersDetail.PK_WarehouseLine	1	CLUSTERED	Y	Y	11	0	0	11	2026-09-11 01:59:59	never	USED	KEEP — primary key
STAFFING.dbo.BillingSnapshot.PK_StaffingArchive	1	CLUSTERED	Y	Y	0	16599	0	0	2026-09-12 01:00:32	never	USED	KEEP — primary key
STAFFING.dbo.BillingQueue.IX_CatalogHeader	2	NONCLUSTERED			0	0	0	1670	never	never	UNUSED	review, then DROP
STAFFING.dbo.BillingQueue.PK_RosterLine	1	CLUSTERED	Y	Y	22	1681	0	1670	2026-09-12 00:59:32	never	USED	KEEP — primary key
STAFFING.dbo.ReconcileHistory.PK_WarehouseLog	1	CLUSTERED	Y	Y	0	24	0	0	2026-09-12 00:29:32	never	USED	KEEP — primary key
STAFFING.dbo.CustomerMonthly.PK_TerritoryStaging	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
STAFFING.dbo.ShipmentQueue.PK_ClaimStatus	1	CLUSTERED	Y	Y	0	24	0	0	2026-09-12 00:29:32	2025-01-06 14:04:53	USED	KEEP — primary key
STAFFING.dbo.InvoiceHeader.IX_InvoiceQueue	1	CLUSTERED	Y		0	0	0	0	never	2025-01-06 14:04:52	COLD	KEEP — table storage
STAFFING.dbo.InvoiceHeader.PK_BatchSnapshot	2	NONCLUSTERED	Y	Y	115919	0	0	0	2026-09-12 01:01:13	2025-01-06 14:05:08	USED	KEEP — primary key
ROUTE.dbo.MeterDetail.IX_MeterQueue	1	CLUSTERED	Y		0	11	0	1670	2026-09-11 01:59:59	never	USED	KEEP — table storage
ROUTE.dbo.MeterDetail.PK_ContractAudit	2	NONCLUSTERED	Y	Y	0	1659	0	1670	2026-09-12 00:59:32	never	USED	KEEP — primary key
ROUTE.dbo.OrdersDaily.IX_SupplierQueue	3	NONCLUSTERED			1681	11	0	1670	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.OrdersDaily.PK_CampaignResult	1	CLUSTERED	Y	Y	0	0	0	1670	never	never	UNUSED	KEEP — primary key
ROUTE.dbo.OrdersDaily.IX_RouteDaily	2	NONCLUSTERED	Y		0	1670	0	1670	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.CustomerQueue.PK_BillingLine	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
ROUTE.dbo.InvoiceSummary.IX_TerritoryDaily	5	NONCLUSTERED			0	1656	0	3315	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.InvoiceSummary.IX_RosterArchive	1	CLUSTERED	Y		1659	0	0	3315	2026-09-12 00:59:32	never	USED	KEEP — table storage
ROUTE.dbo.InvoiceSummary.IX_ClaimStaging	3	NONCLUSTERED			1659	0	0	3315	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.InvoiceSummary.PK_ContractHeader	2	NONCLUSTERED	Y	Y	0	0	0	3315	never	never	UNUSED	KEEP — primary key
ROUTE.dbo.CatalogAudit.PK_StaffingEntry	1	CLUSTERED	Y	Y	0	1659	0	1659	2026-09-12 00:59:32	never	USED	KEEP — primary key
ROUTE.dbo.OrdersStaging.IX_RouteHeader	2	NONCLUSTERED	Y		0	1681	0	1670	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.OrdersStaging.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	1670	never	never	UNUSED	KEEP — primary key
ROUTE.dbo.PolicyStatus.IX_TicketMonthly	2	NONCLUSTERED			3351	0	0	1670	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.PolicyStatus.PK_ClaimDaily	1	CLUSTERED	Y	Y	0	11	0	1670	2026-09-11 01:59:59	never	USED	KEEP — primary key
ROUTE.dbo.PolicyStatus.IX_SupplierDetail	3	NONCLUSTERED	Y		0	1670	0	1670	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.LedgerDetail.IX_AssetSummary	1	CLUSTERED	Y		1659	0	0	1659	2026-09-12 00:59:32	never	USED	KEEP — table storage
ROUTE.dbo.LedgerDetail.IX_ShiftSnapshot	4	NONCLUSTERED			1656	0	0	1659	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.LedgerDetail.IX_OrdersResult	2	NONCLUSTERED			1659	0	0	1659	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.LedgerDetail.IX_PolicyAudit	3	NONCLUSTERED			0	0	0	1659	never	never	UNUSED	review, then DROP
ROUTE.dbo.TerritoryLine.IX_StaffingHeader	1	CLUSTERED	Y		1659	1659	0	1659	2026-09-12 00:59:32	never	USED	KEEP — table storage
ROUTE.dbo.BillingQueue.IX_SettlementStaging	3	NONCLUSTERED			0	0	0	4985	never	never	UNUSED	review, then DROP
ROUTE.dbo.BillingQueue.IX_CatalogHeader	2	NONCLUSTERED			1659	0	0	4985	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.BillingQueue.IX_WarehouseStatus	1	CLUSTERED			22	3337	0	4985	2026-09-12 00:59:32	never	USED	KEEP — table storage
ROUTE.dbo.SalesLog.IX_WarehouseStaging	3	NONCLUSTERED			0	0	0	1656	never	never	UNUSED	review, then DROP
ROUTE.dbo.SalesLog.PK_ContractQueue	1	CLUSTERED	Y	Y	0	1656	0	1656	2026-09-12 00:59:32	never	USED	KEEP — primary key
ROUTE.dbo.SalesLog.IX_SettlementLog	2	NONCLUSTERED	Y		0	1656	0	1656	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.BatchLine.IX_TicketEntry	2	NONCLUSTERED			0	0	0	1656	never	never	UNUSED	review, then DROP
ROUTE.dbo.BatchLine.IX_PolicyQueue	1	CLUSTERED			1656	0	0	1656	2026-09-12 00:59:32	never	USED	KEEP — table storage
ROUTE.dbo.BatchLine.PK_SettlementAudit	3	NONCLUSTERED	Y	Y	0	1656	0	1656	2026-09-12 00:59:32	never	USED	KEEP — primary key
ROUTE.dbo.TicketResult.IX_ClaimSnapshot	2	NONCLUSTERED			1656	1656	0	1656	2026-09-12 00:59:32	never	USED	keep — in use
ROUTE.dbo.TicketResult.PK_BatchEntry	1	CLUSTERED	Y	Y	0	0	0	1656	never	never	UNUSED	KEEP — primary key
METER.dbo.RosterHeader.PK_BatchResult	1	CLUSTERED	Y	Y	0	0	0	87	never	2025-03-03 15:05:21	UNUSED	KEEP — primary key
POLICY.dbo.ContractMonthly.PK_CampaignSnapshot	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-09-30 15:33:07	COLD	KEEP — primary key
POLICY.dbo.BatchArchive.PK_CustomerMonthly	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-04-07 09:00:09	COLD	KEEP — primary key
BILLING.dbo.SalesAudit.PK_BillingDetail	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.TicketLog.PK_SupplierSummary	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.TerritoryStaging.PK_OrdersQueue	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.SalesSnapshot.IX_BookingDetail	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.BillingSnapshot.PK_AssetLog	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-01-06 14:33:42	COLD	KEEP — primary key
BILLING.dbo.BillingSummary.PK_BatchQueue	1	CLUSTERED	Y	Y	4	4	0	0	2026-09-11 17:39:52	2025-01-06 14:33:42	USED	KEEP — primary key
BILLING.dbo.CatalogSummary.PK_MeterHeader	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.OrdersStaging.IX_TicketArchive	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.AssetArchive.IX_SupplierDaily	1	CLUSTERED	Y	Y	487418	0	0	126996	2026-09-12 00:35:43	2026-06-10 08:01:09	USED	KEEP — primary key
BILLING.dbo.SettlementMonthly.IX_InvoiceLine	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.RosterQueue.IX_ForecastHeader	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
BILLING.dbo.PolicyEntry.IX_SettlementAudit	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
BILLING.dbo.PolicyEntry.PK_AssetDaily	1	CLUSTERED	Y	Y	2	13	0	0	2026-09-11 17:39:51	never	USED	KEEP — primary key
BILLING.dbo.PolicyEntry.IX_ShiftStatus	4	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
BILLING.dbo.PolicyEntry.IX_ShipmentDetail	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
BILLING.dbo.PolicyEntry.IX_WarehouseMonthly	5	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
BILLING.dbo.PayrollDaily.IX_InvoiceStaging	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.PayrollDaily.IX_CatalogDetail	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
BILLING.dbo.CustomerAudit.PK_BatchArchive	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-01-06 14:34:12	COLD	KEEP — primary key
BILLING.dbo.CustomerHistory.PK_MeterDaily	1	CLUSTERED	Y	Y	18	5	0	8	2026-09-11 17:40:27	2025-01-06 14:34:12	USED	KEEP — primary key
BILLING.dbo.BillingDetail.IX_ClaimHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-01-06 14:34:12	COLD	KEEP — primary key
BILLING.dbo.InvoiceDaily.IX_RouteHistory	1	CLUSTERED	Y	Y	0	2	0	0	2026-09-11 17:39:51	2025-01-06 14:34:12	USED	KEEP — primary key
BILLING.dbo.ForecastQueue.PK_CatalogAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.CustomerStatus.IX_BatchArchive	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.PayrollHistory.IX_PricingStatus	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.ShiftDaily.PK_CustomerResult	1	CLUSTERED	Y	Y	0	2	0	0	2026-09-11 17:39:51	2025-01-06 14:34:16	USED	KEEP — primary key
BILLING.dbo.PolicyHistory.PK_RosterDetail	1	CLUSTERED	Y	Y	0	0	0	14	never	2025-01-06 14:34:19	UNUSED	KEEP — primary key
BILLING.dbo.TerritoryLog.PK_BookingHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.QuotaHeader.PK_RosterMonthly	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.QuotaHeader.IX_TerritoryHeader	2	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
BILLING.dbo.BillingSnapshot.IX_AssetAudit	1	CLUSTERED	Y	Y	0	3	26	0	2026-09-11 14:56:04	2025-01-06 14:34:19	USED	KEEP — primary key
BILLING.dbo.BillingSnapshot.IX_CustomerMonthly	2	NONCLUSTERED	Y		0	26	0	0	2026-09-11 14:56:04	2025-01-06 14:34:19	USED	keep — in use
BILLING.dbo.PolicyDetail.IX_BillingLog	2	NONCLUSTERED	Y		0	589837	0	74	2026-09-12 00:35:43	2026-08-14 07:30:00	USED	keep — in use
BILLING.dbo.PolicyDetail.IX_InvoiceSnapshot	1	CLUSTERED	Y	Y	222	93	0	74	2026-09-11 17:39:52	2026-08-13 08:01:38	USED	KEEP — primary key
BILLING.dbo.ReconcileQueue.IX_ShiftDaily	1	CLUSTERED	Y	Y	0	1	0	0	2026-09-11 14:54:22	2025-01-06 14:34:23	USED	KEEP — primary key
BILLING.dbo.MeterQueue.IX_ReconcileStatus	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.BillingAudit.IX_SettlementHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.CustomerSummary.IX_OrdersQueue	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.RosterHeader.PK_RosterSnapshot	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.ClaimArchive.PK_BatchQueue	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
BILLING.dbo.ShiftDetail.IX_ShipmentLog	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key