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-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-15T18:01:09Z

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.

> **Short sample — do not drop anything on the strength of this report.** The counters cover only 0.5 day(s) of the 7 that make a full business week. A weekly report, a month-end close or a quarterly batch has not necessarily run yet, so an index serving one of them still reads as cold. Use this to see the shape of the instance; re-read it after the sample is complete before dropping anything.

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

By database

Database	Total	Cold	Droppable	Recommend action
CRED_2370	72	34	17	review the drop candidates above
BILLING	41	39	4	review the drop candidates above
host-262	32	1	4	review the drop candidates above
POLICY	2	2	0	no action — cold indexes here are constraints or clustered

Drop candidates (25)

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

Index	user_updates	last_read	State	Recommend action
host-262.dbo.BillingQueue.IX_SettlementStaging	201	never	UNUSED	review, then DROP
CRED_2370.dbo.Batch.IX_InvoiceEntry	67	never	UNUSED	review, then DROP
CRED_2370.dbo.ReconcileLog.IX_CustomerLine	67	never	UNUSED	review, then DROP
CRED_2370.dbo.BillingQueue.IX_CatalogHeader	67	never	UNUSED	review, then DROP
host-262.dbo.LedgerDetail.IX_PolicyAudit	67	never	UNUSED	review, then DROP
host-262.dbo.SalesLog.IX_WarehouseStaging	67	never	UNUSED	review, then DROP
host-262.dbo.BatchLine.IX_TicketEntry	67	never	UNUSED	review, then DROP
CRED_2370.dbo.BookingQueue.IX_CampaignQueue	0	never	COLD	review, then DROP
CRED_2370.dbo.BookingQueue.IX_ShipmentAudit	0	never	COLD	review, then DROP
CRED_2370.dbo.BookingQueue.IX_WarehouseArchive	0	never	COLD	review, then DROP
CRED_2370.dbo.BookingQueue.IX_ClaimStaging	0	never	COLD	review, then DROP
CRED_2370.dbo.AssetLine.IX_TicketEntry	0	never	COLD	review, then DROP
CRED_2370.dbo.QuotaHeader.IX_ClaimSnapshot	0	never	COLD	review, then DROP
CRED_2370.dbo.QuotaHeader.IX_CatalogResult	0	never	COLD	review, then DROP
CRED_2370.dbo.ShipmentMonthly.IX_ForecastQueue	0	never	COLD	review, then DROP
CRED_2370.dbo.History.IX_ClaimStaging	0	never	COLD	review, then DROP
CRED_2370.dbo.ShiftStaging.IX_RouteDetail	0	never	COLD	review, then DROP
CRED_2370.dbo.ClaimEntry.IX_ForecastHistory	0	never	COLD	review, then DROP
CRED_2370.dbo.ClaimEntry.IX_CampaignDetail	0	never	COLD	review, then DROP
CRED_2370.dbo.ClaimEntry.IX_PayrollStatus	0	never	COLD	review, then DROP
CRED_2370.dbo.OrdersDetail.IX_SupplierDaily	0	never	COLD	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

Fragmented (1)

Total 481.3 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.7%	61,602	481.3	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
CRED_2370.dbo.BookingAudit.PK_InvoiceLine	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.Batch.IX_ShiftStatus	1	CLUSTERED			67	67	0	67	2026-09-16 00:53:28	never	USED	KEEP — table storage
CRED_2370.dbo.Batch.IX_InvoiceEntry	2	NONCLUSTERED			0	0	0	67	never	never	UNUSED	review, then DROP
CRED_2370.dbo.SalesHistory.IX_CampaignArchive	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
CRED_2370.dbo.SalesHistory.PK_BatchDetail	2	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.BookingQueue.IX_PricingArchive	1	CLUSTERED	Y		0	268	4064	0	2026-09-16 01:01:03	never	USED	KEEP — table storage
CRED_2370.dbo.BookingQueue.IX_CampaignQueue	6	NONCLUSTERED			0	0	0	0	never	2025-01-06 14:05:06	COLD	review, then DROP
CRED_2370.dbo.BookingQueue.IX_ShipmentAudit	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.BookingQueue.IX_WarehouseArchive	4	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.BookingQueue.IX_ClaimStaging	5	NONCLUSTERED			0	0	0	0	never	2025-01-06 14:04:52	COLD	review, then DROP
CRED_2370.dbo.BookingQueue.PK_AssetDetail	2	NONCLUSTERED	Y	Y	4064	0	0	0	2026-09-16 01:01:03	2025-01-06 14:05:08	USED	KEEP — primary key
CRED_2370.dbo.MeterDetail.IX_MeterQueue	1	CLUSTERED	Y		0	0	0	67	never	never	UNUSED	KEEP — table storage
CRED_2370.dbo.MeterDetail.PK_ContractAudit	2	NONCLUSTERED	Y	Y	0	67	0	67	2026-09-16 00:53:28	never	USED	KEEP — primary key
CRED_2370.dbo.OrdersDaily.IX_SupplierQueue	3	NONCLUSTERED			67	67	0	67	2026-09-16 00:53:28	never	USED	keep — in use
CRED_2370.dbo.OrdersDaily.PK_CampaignResult	1	CLUSTERED	Y	Y	0	0	0	67	never	never	UNUSED	KEEP — primary key
CRED_2370.dbo.OrdersDaily.IX_RouteDaily	2	NONCLUSTERED	Y		0	0	0	67	never	never	UNUSED	review carefully — unique
CRED_2370.dbo.PolicyLine.IX_TicketSnapshot	1	CLUSTERED	Y		3	0	0	0	2026-09-15 13:43:24	2025-01-06 14:04:52	USED	KEEP — table storage
CRED_2370.dbo.PolicyLine.PK_SettlementStaging	2	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.CustomerQueue.PK_BillingLine	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.AssetLine.IX_TicketEntry	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.AssetLine.IX_StaffingArchive	1	CLUSTERED			0	0	0	0	never	never	COLD	KEEP — table storage
CRED_2370.dbo.AssetLine.PK_ContractEntry	3	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.QuotaHeader.IX_ClaimSnapshot	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.QuotaHeader.IX_CatalogResult	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.QuotaHeader.PK_BatchEntry	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.Event.IX_RouteStaging	2	NONCLUSTERED			0	46	0	4110	2026-09-16 00:58:28	never	USED	keep — in use
CRED_2370.dbo.Event.IX_ClaimSummary	4	NONCLUSTERED			0	8128	0	0	2026-09-16 01:01:03	never	USED	keep — in use
CRED_2370.dbo.Event.PK_TicketHistory	1	CLUSTERED	Y	Y	4110	0	8128	4110	2026-09-16 01:01:03	never	USED	KEEP — primary key
CRED_2370.dbo.ShipmentMonthly.IX_ForecastQueue	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.ShipmentMonthly.PK_SupplierArchive	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.History.IX_RosterMonthly	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
CRED_2370.dbo.History.IX_ClaimStaging	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.History.PK_CatalogQueue	2	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.MeterResult.PK_LedgerMonthly	1	CLUSTERED	Y	Y	2	3	0	0	2026-09-15 13:43:23	2025-01-06 14:05:07	USED	KEEP — primary key
CRED_2370.dbo.SupplierAudit.IX_PricingQueue	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
CRED_2370.dbo.SupplierAudit.PK_BillingEntry	2	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.PayrollHistory.IX_BillingDaily	1	CLUSTERED			0	201	0	134	2026-09-16 00:53:28	never	USED	KEEP — table storage
CRED_2370.dbo.PayrollHistory.PK_CustomerSummary	2	NONCLUSTERED	Y	Y	0	0	0	134	never	never	UNUSED	KEEP — primary key
CRED_2370.dbo.StaffingMonthly.IX_ForecastAudit	1	CLUSTERED			0	0	0	0	never	never	COLD	KEEP — table storage
CRED_2370.dbo.ShiftStaging.IX_RouteDetail	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.ShiftStaging.IX_LedgerSummary	3	NONCLUSTERED			0	46	0	4156	2026-09-16 00:58:28	never	USED	keep — in use
CRED_2370.dbo.ShiftStaging.IX_RosterHeader	4	NONCLUSTERED			0	8128	0	0	2026-09-16 01:01:03	never	USED	keep — in use
CRED_2370.dbo.ShiftStaging.PK_CatalogLog	1	CLUSTERED	Y	Y	4156	46	8128	4156	2026-09-16 01:01:03	never	USED	KEEP — primary key
CRED_2370.dbo.Policies.PK_CatalogResult	1	CLUSTERED	Y	Y	0	134	0	134	2026-09-16 00:53:28	2025-01-06 14:15:08	USED	KEEP — primary key
CRED_2370.dbo.LedgerEntry.IX_SettlementQueue	1	CLUSTERED	Y		0	0	0	134	never	never	UNUSED	KEEP — table storage
CRED_2370.dbo.LedgerEntry.PK_MeterArchive	2	NONCLUSTERED	Y	Y	0	134	0	134	2026-09-16 00:53:28	never	USED	KEEP — primary key
CRED_2370.dbo.ClaimEntry.IX_ForecastHistory	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.ClaimEntry.IX_CampaignDetail	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.ClaimEntry.IX_PayrollStatus	4	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.PricingQueue.IX_AssetStaging	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
CRED_2370.dbo.PricingQueue.PK_PricingAudit	2	NONCLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.ReconcileLog.IX_CustomerLine	2	NONCLUSTERED			0	0	0	67	never	never	UNUSED	review, then DROP
CRED_2370.dbo.ReconcileLog.PK_RosterLog	1	CLUSTERED	Y	Y	0	744	0	67	2026-09-16 01:00:28	never	USED	KEEP — primary key
CRED_2370.dbo.Schedule.IX_TerritoryDetail	2	NONCLUSTERED	Y		0	1	0	0	2026-09-15 13:43:28	never	USED	keep — in use
CRED_2370.dbo.Schedule.PK_PricingAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.BatchLog.IX_OrdersDaily	1	CLUSTERED	Y		4198	0	0	134	2026-09-16 01:01:03	2025-01-06 14:05:08	USED	KEEP — table storage
CRED_2370.dbo.BatchLog.PK_PayrollDaily	2	NONCLUSTERED	Y	Y	0	0	0	134	never	never	UNUSED	KEEP — primary key
CRED_2370.dbo.OrdersStaging.IX_RouteHeader	2	NONCLUSTERED	Y		0	67	0	67	2026-09-16 00:53:28	never	USED	keep — in use
CRED_2370.dbo.OrdersStaging.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	67	never	never	UNUSED	KEEP — primary key
CRED_2370.dbo.PolicyStatus.IX_TicketMonthly	2	NONCLUSTERED			67	0	0	67	2026-09-16 00:53:28	never	USED	keep — in use
CRED_2370.dbo.PolicyStatus.PK_ClaimDaily	1	CLUSTERED	Y	Y	0	0	0	67	never	never	UNUSED	KEEP — primary key
CRED_2370.dbo.PolicyStatus.IX_SupplierDetail	3	NONCLUSTERED	Y		0	67	0	67	2026-09-16 00:53:28	never	USED	keep — in use
CRED_2370.dbo.OrdersDetail.IX_SupplierDaily	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.OrdersDetail.PK_WarehouseLine	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.BillingSnapshot.PK_StaffingArchive	1	CLUSTERED	Y	Y	0	678	0	0	2026-09-16 01:00:28	never	USED	KEEP — primary key
CRED_2370.dbo.BillingQueue.IX_CatalogHeader	2	NONCLUSTERED			0	0	0	67	never	never	UNUSED	review, then DROP
CRED_2370.dbo.BillingQueue.PK_RosterLine	1	CLUSTERED	Y	Y	0	67	0	67	2026-09-16 00:53:28	never	USED	KEEP — primary key
CRED_2370.dbo.ReconcileHistory.PK_WarehouseLog	1	CLUSTERED	Y	Y	0	1	0	0	2026-09-15 13:43:28	never	USED	KEEP — primary key
CRED_2370.dbo.CustomerMonthly.PK_TerritoryStaging	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
CRED_2370.dbo.ShipmentQueue.PK_ClaimStatus	1	CLUSTERED	Y	Y	0	1	0	0	2026-09-15 13:43:28	2025-01-06 14:04:53	USED	KEEP — primary key
CRED_2370.dbo.CRED_1060.IX_InvoiceQueue	1	CLUSTERED	Y		0	0	0	0	never	2025-01-06 14:04:52	COLD	KEEP — table storage
CRED_2370.dbo.CRED_1060.PK_BatchSnapshot	2	NONCLUSTERED	Y	Y	4741	0	0	0	2026-09-16 01:01:03	2025-01-06 14:05:08	USED	KEEP — primary key
host-262.dbo.MeterDetail.IX_MeterQueue	1	CLUSTERED	Y		0	0	0	67	never	never	UNUSED	KEEP — table storage
host-262.dbo.MeterDetail.PK_ContractAudit	2	NONCLUSTERED	Y	Y	0	67	0	67	2026-09-16 00:53:28	never	USED	KEEP — primary key
host-262.dbo.OrdersDaily.IX_SupplierQueue	3	NONCLUSTERED			67	0	0	67	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.OrdersDaily.PK_CampaignResult	1	CLUSTERED	Y	Y	0	0	0	67	never	never	UNUSED	KEEP — primary key
host-262.dbo.OrdersDaily.IX_RouteDaily	2	NONCLUSTERED	Y		0	67	0	67	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.CustomerQueue.PK_BillingLine	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-262.dbo.InvoiceSummary.IX_TerritoryDaily	5	NONCLUSTERED			0	67	0	134	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.InvoiceSummary.IX_RosterArchive	1	CLUSTERED	Y		67	0	0	134	2026-09-16 00:53:28	never	USED	KEEP — table storage
host-262.dbo.InvoiceSummary.IX_ClaimStaging	3	NONCLUSTERED			67	0	0	134	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.InvoiceSummary.PK_ContractHeader	2	NONCLUSTERED	Y	Y	0	0	0	134	never	never	UNUSED	KEEP — primary key
host-262.dbo.CatalogAudit.PK_StaffingEntry	1	CLUSTERED	Y	Y	0	67	0	67	2026-09-16 00:53:28	never	USED	KEEP — primary key
host-262.dbo.OrdersStaging.IX_RouteHeader	2	NONCLUSTERED	Y		0	67	0	67	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.OrdersStaging.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	67	never	never	UNUSED	KEEP — primary key
host-262.dbo.PolicyStatus.IX_TicketMonthly	2	NONCLUSTERED			134	0	0	67	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.PolicyStatus.PK_ClaimDaily	1	CLUSTERED	Y	Y	0	0	0	67	never	never	UNUSED	KEEP — primary key
host-262.dbo.PolicyStatus.IX_SupplierDetail	3	NONCLUSTERED	Y		0	67	0	67	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.LedgerDetail.IX_AssetSummary	1	CLUSTERED	Y		67	0	0	67	2026-09-16 00:53:28	never	USED	KEEP — table storage
host-262.dbo.LedgerDetail.IX_ShiftSnapshot	4	NONCLUSTERED			67	0	0	67	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.LedgerDetail.IX_OrdersResult	2	NONCLUSTERED			67	0	0	67	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.LedgerDetail.IX_PolicyAudit	3	NONCLUSTERED			0	0	0	67	never	never	UNUSED	review, then DROP
host-262.dbo.TerritoryLine.IX_StaffingHeader	1	CLUSTERED	Y		67	67	0	67	2026-09-16 00:53:28	never	USED	KEEP — table storage
host-262.dbo.BillingQueue.IX_SettlementStaging	3	NONCLUSTERED			0	0	0	201	never	never	UNUSED	review, then DROP
host-262.dbo.BillingQueue.IX_CatalogHeader	2	NONCLUSTERED			67	0	0	201	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.BillingQueue.IX_WarehouseStatus	1	CLUSTERED			0	134	0	201	2026-09-16 00:53:28	never	USED	KEEP — table storage
host-262.dbo.SalesLog.IX_WarehouseStaging	3	NONCLUSTERED			0	0	0	67	never	never	UNUSED	review, then DROP
host-262.dbo.SalesLog.PK_ContractQueue	1	CLUSTERED	Y	Y	0	67	0	67	2026-09-16 00:53:28	never	USED	KEEP — primary key
host-262.dbo.SalesLog.IX_SettlementLog	2	NONCLUSTERED	Y		0	67	0	67	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.BatchLine.IX_TicketEntry	2	NONCLUSTERED			0	0	0	67	never	never	UNUSED	review, then DROP
host-262.dbo.BatchLine.IX_PolicyQueue	1	CLUSTERED			67	0	0	67	2026-09-16 00:53:28	never	USED	KEEP — table storage
host-262.dbo.BatchLine.PK_SettlementAudit	3	NONCLUSTERED	Y	Y	0	67	0	67	2026-09-16 00:53:28	never	USED	KEEP — primary key
host-262.dbo.TicketResult.IX_ClaimSnapshot	2	NONCLUSTERED			67	67	0	67	2026-09-16 00:53:28	never	USED	keep — in use
host-262.dbo.TicketResult.PK_BatchEntry	1	CLUSTERED	Y	Y	0	0	0	67	never	never	UNUSED	KEEP — primary key
METER.dbo.RosterHeader.PK_BatchResult	1	CLUSTERED	Y	Y	0	0	0	8	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	0	0	0	0	never	2025-01-06 14:33:42	COLD	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	6	0	0	0	2026-09-16 00:36:08	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	0	0	0	0	never	never	COLD	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	0	0	0	0	never	2025-01-06 14:34:12	COLD	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	0	0	0	never	2025-01-06 14:34:12	COLD	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	0	0	0	never	2025-01-06 14:34:16	COLD	KEEP — primary key
BILLING.dbo.PolicyHistory.PK_RosterDetail	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-01-06 14:34:19	COLD	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	0	0	0	never	2025-01-06 14:34:19	COLD	KEEP — primary key
BILLING.dbo.BillingSnapshot.IX_CustomerMonthly	2	NONCLUSTERED	Y		0	0	0	0	never	2025-01-06 14:34:19	COLD	review carefully — unique
BILLING.dbo.PolicyDetail.IX_BillingLog	2	NONCLUSTERED	Y		0	6	0	0	2026-09-16 00:36:08	2026-08-14 07:30:00	USED	keep — in use
BILLING.dbo.PolicyDetail.IX_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	0	0	0	never	2026-08-13 08:01:38	COLD	KEEP — primary key
BILLING.dbo.ReconcileQueue.IX_ShiftDaily	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-01-06 14:34:23	COLD	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