Index Usage — ACME-192-0-2-242

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

Host: 192.0.2.242

Collected: 2026-10-02T17:02:03Z

Server dashboard: http://203.0.113.28:8080/report_dba/server-metrics.html?server=ACME-192-0-2-242

Fleet inventory: http://203.0.113.28: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	59	every index on a user table
used	10	had a seek, scan or lookup
unused	26	written but never read
cold	23	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	26	nonclustered, not unique, no constraint, never read

By database

Database	Total	Cold	Disabled	Droppable	Recommend action
host-705	59	23	0	26	review the drop candidates above

Drop candidates (26)

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-705.dbo.AssetArchive.AssetArchive$IX_BillingLog	44386	never	UNUSED	review, then DROP
host-705.dbo.PolicyDetail.PolicyDetail$USERID	128	never	UNUSED	review, then DROP
host-705.dbo.CampaignSnapshot.CampaignSnapshot$M_ID	128	never	UNUSED	review, then DROP
host-705.dbo.ShipmentLine.ShipmentLine$UI_ID	128	never	UNUSED	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$CODEDETAIL	1	never	UNUSED	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$CODENAME	1	never	UNUSED	review, then DROP
host-705.dbo.COMPANY.IX_ForecastArchive	1	never	UNUSED	review, then DROP
host-705.dbo.COMPANY.IX_ReconcileStaging	1	never	UNUSED	review, then DROP
host-705.dbo.COMPANY.IX_CampaignResult	1	never	UNUSED	review, then DROP
host-705.dbo.COMPANY.IX_PolicyEntry	1	never	UNUSED	review, then DROP
host-705.dbo.MeterMonthly.MeterMonthly$COMID	1	never	UNUSED	review, then DROP
host-705.dbo.MeterMonthly.MeterMonthly$DEPTNAME	1	never	UNUSED	review, then DROP
host-705.dbo.BillingLine.BillingLine$UMS_ID	1	never	UNUSED	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$S_GroupID	1	never	UNUSED	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$S_TranferID	1	never	UNUSED	review, then DROP
host-705.dbo.Machine.IX_AssetMonthly	1	never	UNUSED	review, then DROP
host-705.dbo.Machine.IX_RouteHistory	1	never	UNUSED	review, then DROP
host-705.dbo.PolicyHistory.PolicyHistory$USERID	1	never	UNUSED	review, then DROP
host-705.dbo.TicketSnapshot.TicketSnapshot$UMS_ID	0	never	COLD	review, then DROP
host-705.dbo.ShipmentQueue.ShipmentQueue$Leaveid	0	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$HOLIDAYID	0	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$Leaveid	0	never	COLD	review, then DROP
host-705.dbo.PayrollDaily.PayrollDaily$DeptID	0	never	COLD	review, then DROP
host-705.dbo.MODE.IX_PayrollMonthly	0	never	COLD	review, then DROP
host-705.dbo.ReconcileQueue.ReconcileQueue$ID	0	never	COLD	review, then DROP
host-705.dbo.MeterQueue.MeterQueue$ID	0	never	COLD	review, then DROP

All indexes (59)

Every index on the instance, including the healthy ones — the answer to "is THIS index used?" has to be here, not only the problems.

Index	id	Type	Uniq	PK	seeks	scans	lookups	updates	last_read	last_stats_update	State	Recommend action
host-705.dbo.InvoiceDetail.InvoiceDetail$PrimaryKey	1	CLUSTERED	Y	Y	0	10	0	3	2026-01-23 16:00:13	2026-09-26 22:00:03	USED	KEEP — primary key
host-705.dbo.StaffingHeader.StaffingHeader$PrimaryKey	1	CLUSTERED	Y	Y	0	11	0	14	2026-01-23 16:00:13	2026-09-26 22:00:03	USED	KEEP — primary key
host-705.dbo.AssetArchive.AssetArchive$IX_BillingLog	2	NONCLUSTERED			0	0	0	44386	never	2026-10-02 22:00:03	UNUSED	review, then DROP
host-705.dbo.AssetArchive.AssetArchive$IX_SupplierDaily	1	CLUSTERED	Y	Y	0	1519	0	44386	2026-10-02 20:00:00	2026-10-02 22:00:03	USED	KEEP — primary key
host-705.dbo.AssetArchive.AssetArchive$id	3	NONCLUSTERED			0	2072	0	44386	2026-10-02 22:30:02	2026-10-02 22:00:03	USED	keep — in use
host-705.dbo.ShipmentArchive.ShipmentArchive$CODEDETAIL	2	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$CODENAME	3	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.ShipmentArchive.ShipmentArchive$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-26 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.COMPANY.IX_ForecastArchive	2	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.COMPANY.IX_ReconcileStaging	3	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.COMPANY.IX_CampaignResult	4	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.COMPANY.IX_PolicyEntry	5	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.COMPANY.IX_OrdersEntry	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-26 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.MeterMonthly.MeterMonthly$COMID	2	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.MeterMonthly.MeterMonthly$DEPTID	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-26 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.MeterMonthly.MeterMonthly$DEPTNAME	3	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.TicketSnapshot.TicketSnapshot$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.TicketSnapshot.TicketSnapshot$UMS_ID	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.BillingLine.BillingLine$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-26 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.BillingLine.BillingLine$UMS_ID	2	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-26 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.CampaignLog.CampaignLog$S_GroupID	2	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.CampaignLog.CampaignLog$S_TranferID	3	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.ShipmentQueue.ShipmentQueue$Leaveid	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ShipmentQueue.ShipmentQueue$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollHeader.PayrollHeader$HOLIDAYID	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$Leaveid	3	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.PayrollHeader.PayrollHeader$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollDaily.PayrollDaily$DeptID	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.PayrollDaily.PayrollDaily$IX_InvoiceStaging	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PayrollDaily.PayrollDaily$IX_CatalogDetail	3	NONCLUSTERED	Y		0	0	0	0	never	never	COLD	review carefully — unique
host-705.dbo.QuotaHeader.QuotaHeader$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.CustomerHistory.CustomerHistory$Index_A53BD582_2B04_434C	1	CLUSTERED	Y	Y	0	0	0	2	never	2026-09-26 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.MODE.IX_PayrollMonthly	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.MODE.IX_CustomerLine	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.Machine.IX_AssetMonthly	2	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.Machine.IX_ClaimEntry	1	CLUSTERED	Y	Y	45647	1641	0	1	2026-10-02 20:00:02	2026-09-26 22:00:03	USED	KEEP — primary key
host-705.dbo.Machine.IX_RouteHistory	3	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.CatalogAudit.CatalogAudit$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.BillingDetail.BillingDetail$IX_ClaimHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.InvoiceDaily.InvoiceDaily$IX_RouteHistory	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.ShiftDaily.ShiftDaily$Index_599AC926_12D6_44BA	1	CLUSTERED	Y	Y	0	0	0	4	never	2026-09-26 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.CustomerStatus.CustomerStatus$IX_BatchArchive	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.SHIFT.SHIFT$IX_PricingStatus	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PolicyHistory.PolicyHistory$Index_37D84771_AECE_4899	1	CLUSTERED	Y	Y	0	0	0	1	never	2026-09-26 22:00:03	UNUSED	KEEP — primary key
host-705.dbo.PolicyHistory.PolicyHistory$USERID	2	NONCLUSTERED			0	0	0	1	never	2026-09-26 22:00:03	UNUSED	review, then DROP
host-705.dbo.ForecastQueue.ForecastQueue$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.PolicyDetail.PolicyDetail$PrimaryKey	1	CLUSTERED	Y	Y	45648	10	0	128	2026-10-02 20:00:02	2026-10-01 22:00:03	USED	KEEP — primary key
host-705.dbo.PolicyDetail.PolicyDetail$USERID	2	NONCLUSTERED			0	0	0	128	never	2026-10-01 22:00:03	UNUSED	review, then DROP
host-705.dbo.ReconcileQueue.ReconcileQueue$ID	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.ReconcileQueue.ReconcileQueue$IX_ShiftDaily	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.MeterQueue.MeterQueue$ID	2	NONCLUSTERED			0	0	0	0	never	never	COLD	review, then DROP
host-705.dbo.MeterQueue.MeterQueue$PrimaryKey	1	CLUSTERED	Y	Y	0	0	0	0	never	never	COLD	KEEP — primary key
host-705.dbo.CampaignSnapshot.CampaignSnapshot$M_ID	2	NONCLUSTERED			0	0	0	128	never	2026-10-01 22:00:03	UNUSED	review, then DROP
host-705.dbo.CampaignSnapshot.CampaignSnapshot$PrimaryKey	1	CLUSTERED	Y	Y	0	19593	26158	128	2026-10-02 20:00:02	2026-10-01 22:00:03	USED	KEEP — primary key
host-705.dbo.CampaignSnapshot.CampaignSnapshot$UMI_ID	3	NONCLUSTERED			26159	23	0	128	2026-10-02 20:00:02	2026-10-01 22:00:03	USED	keep — in use
host-705.dbo.ShipmentLine.ShipmentLine$PrimaryKey	1	CLUSTERED	Y	Y	0	23	0	128	2026-10-01 14:00:02	2026-10-01 22:00:03	USED	KEEP — primary key
host-705.dbo.ShipmentLine.ShipmentLine$UI_ID	2	NONCLUSTERED			0	0	0	128	never	2026-10-01 22:00:03	UNUSED	review, then DROP
host-705.dbo.ShipmentLine.ShipmentLine$UserMachineID	3	NONCLUSTERED			45647	105	0	128	2026-10-02 20:00:02	2026-10-01 22:00:03	USED	keep — in use