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

Index reportsSQL Server 13ACME-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-155Oracle 2ACME-192-0-2-120 ACME-198-51-100-125PostgreSQL 1ACME-192-0-2-15-PG-5433

Host: 198.51.100.92

Collected: 2026-10-11T18:01:13Z

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 user table
used	58	had a seek, scan or lookup
unused	19	written but never read
cold	71	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
CRED_2370	72	30	15	review the drop candidates above
BILLING	41	38	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 (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
host-262.dbo.BillingQueue.IX_SettlementStaging	11437	never	UNUSED	review, then DROP
CRED_2370.dbo.BillingQueue.IX_CatalogHeader	3830	never	UNUSED	review, then DROP
CRED_2370.dbo.Batch.IX_InvoiceEntry	3805	never	UNUSED	review, then DROP
CRED_2370.dbo.ReconcileLog.IX_CustomerLine	3805	never	UNUSED	review, then DROP
host-262.dbo.LedgerDetail.IX_PolicyAudit	3805	never	UNUSED	review, then DROP
host-262.dbo.SalesLog.IX_WarehouseStaging	3802	never	UNUSED	review, then DROP
host-262.dbo.BatchLine.IX_TicketEntry	3802	never	UNUSED	review, then DROP
CRED_2370.dbo.Catalog.IX_CampaignQueue	0	never	COLD	review, then DROP
CRED_2370.dbo.Catalog.IX_ShipmentAudit	0	never	COLD	review, then DROP
CRED_2370.dbo.Catalog.IX_WarehouseArchive	0	never	COLD	review, then DROP
CRED_2370.dbo.Catalog.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.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
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.VALID	0	never	COLD	review, then DROP

Fragmented (1)

Total 491.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	69.4%	62,946	491.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
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			3805	3805	0	3805	2026-10-12 00:54:22	never	USED	KEEP — table storage
CRED_2370.dbo.Batch.IX_InvoiceEntry	2	NONCLUSTERED			0	0	0	3805	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.Catalog.IX_PricingArchive	1	CLUSTERED	Y		0	15220	228382	0	2026-10-12 01:01:05	never	USED	KEEP — table storage
CRED_2370.dbo.Catalog.IX_CampaignQueue	6	NONCLUSTERED			0	0	0	0	never	2025-01-06 14:05:06	COLD	review, then DROP
CRED_2370.dbo.Catalog.IX_ShipmentAudit	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.Catalog.IX_WarehouseArchive	4	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
CRED_2370.dbo.Catalog.IX_ClaimStaging	5	NONCLUSTERED			0	0	0	0	never	2025-01-06 14:04:52	COLD	review, then DROP
CRED_2370.dbo.Catalog.PK_AssetDetail	2	NONCLUSTERED	Y	Y	228382	0	0	0	2026-10-12 01:01:05	2025-01-06 14:05:08	USED	KEEP — primary key
CRED_2370.dbo.MeterDetail.IX_MeterQueue	1	CLUSTERED	Y		0	26	0	3830	2026-10-11 01:59:59	never	USED	KEEP — table storage
CRED_2370.dbo.MeterDetail.PK_ContractAudit	2	NONCLUSTERED	Y	Y	0	3804	0	3830	2026-10-12 00:54:22	never	USED	KEEP — primary key
CRED_2370.dbo.OrdersDaily.IX_SupplierQueue	3	NONCLUSTERED			3856	3830	0	3830	2026-10-12 00:54:22	never	USED	keep — in use
CRED_2370.dbo.OrdersDaily.PK_CampaignResult	1	CLUSTERED	Y	Y	0	0	0	3830	never	never	UNUSED	KEEP — primary key
CRED_2370.dbo.OrdersDaily.IX_RouteDaily	2	NONCLUSTERED	Y		0	26	0	3830	2026-10-11 01:59:59	never	USED	keep — in use
CRED_2370.dbo.PolicyLine.IX_TicketSnapshot	1	CLUSTERED	Y		159	0	0	0	2026-10-11 13:44:22	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	2587	0	230972	2026-10-12 00:59:22	never	USED	keep — in use
CRED_2370.dbo.Event.IX_ClaimSummary	4	NONCLUSTERED			0	456770	0	0	2026-10-12 01:01:05	never	USED	keep — in use
CRED_2370.dbo.Event.PK_TicketHistory	1	CLUSTERED	Y	Y	230972	0	456770	230972	2026-10-12 01:01:05	never	USED	KEEP — primary key
CRED_2370.dbo.ShipmentMonthly.IX_ForecastQueue	2	NONCLUSTERED			0	26	0	26	2026-10-11 01:59:59	never	USED	keep — in use
CRED_2370.dbo.ShipmentMonthly.PK_SupplierArchive	1	CLUSTERED	Y	Y	0	0	0	26	never	never	UNUSED	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.Keys.PK_LedgerMonthly	1	CLUSTERED	Y	Y	106	159	0	0	2026-10-11 13:44:22	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	11415	0	7610	2026-10-12 00:54:22	never	USED	KEEP — table storage
CRED_2370.dbo.PayrollHistory.PK_CustomerSummary	2	NONCLUSTERED	Y	Y	0	0	0	7610	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	2587	0	233556	2026-10-12 00:59:22	never	USED	keep — in use
CRED_2370.dbo.ShiftStaging.IX_RosterHeader	4	NONCLUSTERED			0	456764	0	0	2026-10-12 01:01:05	never	USED	keep — in use
CRED_2370.dbo.ShiftStaging.PK_CatalogLog	1	CLUSTERED	Y	Y	233556	2587	456764	233556	2026-10-12 01:01:05	never	USED	KEEP — primary key
CRED_2370.dbo.Policies.PK_CatalogResult	1	CLUSTERED	Y	Y	0	7610	0	7610	2026-10-12 00:54:22	2025-01-06 14:15:08	USED	KEEP — primary key
CRED_2370.dbo.LedgerEntry.IX_SettlementQueue	1	CLUSTERED	Y		0	0	0	7610	never	never	UNUSED	KEEP — table storage
CRED_2370.dbo.LedgerEntry.PK_MeterArchive	2	NONCLUSTERED	Y	Y	0	7610	0	7610	2026-10-12 00:54:22	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.Roles.IX_AssetStaging	1	CLUSTERED	Y		0	0	0	0	never	never	COLD	KEEP — table storage
CRED_2370.dbo.Roles.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	3805	never	never	UNUSED	review, then DROP
CRED_2370.dbo.ReconcileLog.PK_RosterLog	1	CLUSTERED	Y	Y	0	41900	0	3805	2026-10-12 01:00:22	never	USED	KEEP — primary key
CRED_2370.dbo.Schedule.IX_TerritoryDetail	2	NONCLUSTERED	Y		0	53	0	0	2026-10-11 13:44:22	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		235992	0	0	7610	2026-10-12 01:01:05	2025-01-06 14:05:08	USED	KEEP — table storage
CRED_2370.dbo.BatchLog.PK_PayrollDaily	2	NONCLUSTERED	Y	Y	0	0	0	7610	never	never	UNUSED	KEEP — primary key
CRED_2370.dbo.Segment.IX_RouteHeader	2	NONCLUSTERED	Y		0	3856	0	3830	2026-10-12 00:54:22	never	USED	keep — in use
CRED_2370.dbo.Segment.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	3830	never	never	UNUSED	KEEP — primary key
CRED_2370.dbo.PolicyStatus.IX_TicketMonthly	2	NONCLUSTERED			3856	0	0	3830	2026-10-12 00:54:22	never	USED	keep — in use
CRED_2370.dbo.PolicyStatus.PK_ClaimDaily	1	CLUSTERED	Y	Y	0	0	0	3830	never	never	UNUSED	KEEP — primary key
CRED_2370.dbo.PolicyStatus.IX_SupplierDetail	3	NONCLUSTERED	Y		0	3856	0	3830	2026-10-12 00:54:22	never	USED	keep — in use
CRED_2370.dbo.OrdersDetail.IX_SupplierDaily	2	NONCLUSTERED			26	0	0	26	2026-10-11 01:59:59	never	USED	keep — in use
CRED_2370.dbo.OrdersDetail.PK_WarehouseLine	1	CLUSTERED	Y	Y	26	0	0	26	2026-10-11 01:59:59	never	USED	KEEP — primary key
CRED_2370.dbo.BillingSnapshot.PK_StaffingArchive	1	CLUSTERED	Y	Y	0	38148	0	0	2026-10-12 01:00:22	never	USED	KEEP — primary key
CRED_2370.dbo.BillingQueue.IX_CatalogHeader	2	NONCLUSTERED			0	0	0	3830	never	never	UNUSED	review, then DROP
CRED_2370.dbo.BillingQueue.PK_RosterLine	1	CLUSTERED	Y	Y	52	3856	0	3830	2026-10-12 00:54:22	never	USED	KEEP — primary key
CRED_2370.dbo.ReconcileHistory.PK_WarehouseLog	1	CLUSTERED	Y	Y	0	53	0	0	2026-10-11 13:44:22	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	53	0	0	2026-10-11 13:44:22	2025-01-06 14:04:53	USED	KEEP — primary key
CRED_2370.dbo.Users.IX_InvoiceQueue	1	CLUSTERED	Y		0	0	0	0	never	2025-01-06 14:04:52	COLD	KEEP — table storage
CRED_2370.dbo.Users.PK_BatchSnapshot	2	NONCLUSTERED	Y	Y	266477	0	0	0	2026-10-12 01:01:05	2025-01-06 14:05:08	USED	KEEP — primary key
host-262.dbo.MeterDetail.IX_MeterQueue	1	CLUSTERED	Y		0	26	0	3830	2026-10-11 01:59:59	never	USED	KEEP — table storage
host-262.dbo.MeterDetail.PK_ContractAudit	2	NONCLUSTERED	Y	Y	0	3804	0	3830	2026-10-12 00:54:22	never	USED	KEEP — primary key
host-262.dbo.OrdersDaily.IX_SupplierQueue	3	NONCLUSTERED			3856	26	0	3830	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.OrdersDaily.PK_CampaignResult	1	CLUSTERED	Y	Y	0	0	0	3830	never	never	UNUSED	KEEP — primary key
host-262.dbo.OrdersDaily.IX_RouteDaily	2	NONCLUSTERED	Y		0	3830	0	3830	2026-10-12 00:54:22	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	3802	0	7607	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.InvoiceSummary.IX_RosterArchive	1	CLUSTERED	Y		3805	0	0	7607	2026-10-12 00:54:22	never	USED	KEEP — table storage
host-262.dbo.InvoiceSummary.IX_ClaimStaging	3	NONCLUSTERED			3805	0	0	7607	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.InvoiceSummary.PK_ContractHeader	2	NONCLUSTERED	Y	Y	0	0	0	7607	never	never	UNUSED	KEEP — primary key
host-262.dbo.CatalogAudit.PK_StaffingEntry	1	CLUSTERED	Y	Y	0	3804	0	3804	2026-10-12 00:54:22	never	USED	KEEP — primary key
host-262.dbo.Segment.IX_RouteHeader	2	NONCLUSTERED	Y		0	3856	0	3830	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.Segment.PK_BatchLine	1	CLUSTERED	Y	Y	0	0	0	3830	never	never	UNUSED	KEEP — primary key
host-262.dbo.PolicyStatus.IX_TicketMonthly	2	NONCLUSTERED			7686	0	0	3830	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.PolicyStatus.PK_ClaimDaily	1	CLUSTERED	Y	Y	0	26	0	3830	2026-10-11 01:59:59	never	USED	KEEP — primary key
host-262.dbo.PolicyStatus.IX_SupplierDetail	3	NONCLUSTERED	Y		0	3830	0	3830	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.LedgerDetail.IX_AssetSummary	1	CLUSTERED	Y		3805	0	0	3805	2026-10-12 00:54:22	never	USED	KEEP — table storage
host-262.dbo.LedgerDetail.IX_ShiftSnapshot	4	NONCLUSTERED			3802	0	0	3805	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.LedgerDetail.IX_OrdersResult	2	NONCLUSTERED			3805	0	0	3805	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.LedgerDetail.IX_PolicyAudit	3	NONCLUSTERED			0	0	0	3805	never	never	UNUSED	review, then DROP
host-262.dbo.TerritoryLine.IX_StaffingHeader	1	CLUSTERED	Y		3805	3805	0	3805	2026-10-12 00:54:22	never	USED	KEEP — table storage
host-262.dbo.BillingQueue.IX_SettlementStaging	3	NONCLUSTERED			0	0	0	11437	never	never	UNUSED	review, then DROP
host-262.dbo.BillingQueue.IX_CatalogHeader	2	NONCLUSTERED			3804	0	0	11437	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.BillingQueue.IX_WarehouseStatus	1	CLUSTERED			52	7659	0	11437	2026-10-12 00:54:22	never	USED	KEEP — table storage
host-262.dbo.SalesLog.IX_WarehouseStaging	3	NONCLUSTERED			0	0	0	3802	never	never	UNUSED	review, then DROP
host-262.dbo.SalesLog.PK_ContractQueue	1	CLUSTERED	Y	Y	0	3802	0	3802	2026-10-12 00:54:22	never	USED	KEEP — primary key
host-262.dbo.SalesLog.IX_SettlementLog	2	NONCLUSTERED	Y		0	3802	0	3802	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.BatchLine.IX_TicketEntry	2	NONCLUSTERED			0	0	0	3802	never	never	UNUSED	review, then DROP
host-262.dbo.BatchLine.IX_PolicyQueue	1	CLUSTERED			3802	0	0	3802	2026-10-12 00:54:22	never	USED	KEEP — table storage
host-262.dbo.BatchLine.PK_SettlementAudit	3	NONCLUSTERED	Y	Y	0	3802	0	3802	2026-10-12 00:54:22	never	USED	KEEP — primary key
host-262.dbo.TicketResult.IX_ClaimSnapshot	2	NONCLUSTERED			3802	3802	0	3802	2026-10-12 00:54:22	never	USED	keep — in use
host-262.dbo.TicketResult.PK_BatchEntry	1	CLUSTERED	Y	Y	0	0	0	3802	never	never	UNUSED	KEEP — primary key
METER.dbo.RosterHeader.PK_BatchResult	1	CLUSTERED	Y	Y	0	0	0	198	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	1256324	0	0	263608	2026-10-12 00:35:05	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.VALID	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.SHIFT.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.TEMPLATE.IX_AssetAudit	1	CLUSTERED	Y	Y	0	0	0	0	never	2025-01-06 14:34:19	COLD	KEEP — primary key
BILLING.dbo.TEMPLATE.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	1485003	0	46	2026-10-11 19:00:05	2026-08-14 07:30:00	USED	keep — in use
BILLING.dbo.PolicyDetail.IX_InvoiceSnapshot	1	CLUSTERED	Y	Y	0	128	0	46	2026-10-12 00:35:05	2026-08-13 08:01:38	USED	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