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

Index Usage Report — ACME-198-51-100-182-PGLAB-5433

Host: 198.51.100.182

Collected: 2026-08-24T18:00:51Z

Server dashboard: http://198.51.100.182:8080/report_dba/server-metrics.html?server=ACME-198-51-100-182-PGLAB-5433

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

MetricCountMeaning
indexes_total90every index on a CatalogHistory table
used61had a seek, scan or lookup
unused29written but never read
cold0never read AND never written since restart
disabled0ALTER INDEX ... DISABLE was run
droppable28nonclustered, not unique, no constraint, never read

By database

DatabaseTotalColdDisabledDroppableRecommend action
db_ops890028review the drop candidates above

Drop candidates (28)

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

Indexuser_updateslast_readStateRecommend action
db_ops.db_ops.metric_results.IX_InvoiceMonthly22628202neverUNUSEDreview, then DROP
db_ops.db_ops.TicketDetail.IX_BillingStaging1308732neverUNUSEDreview, then DROP
db_ops.db_ops.BatchLine.IX_TicketHeader1056599neverUNUSEDreview, then DROP
db_ops.db_ops.ShiftHeader.IX_SettlementSummary621926neverUNUSEDreview, then DROP
db_ops.db_ops.SettlementStatus.IX_QuotaQueue57286neverUNUSEDreview, then DROP
db_ops.db_ops.reports.IX_BillingDetail22567neverUNUSEDreview, then DROP
db_ops.db_ops.reports.IX_MeterResult22567neverUNUSEDreview, then DROP
db_ops.db_ops.reports.IX_PayrollLog22567neverUNUSEDreview, then DROP
db_ops.db_ops.SettlementDaily.IX_BillingSnapshot5255neverUNUSEDreview, then DROP
db_ops.db_ops.SettlementDaily.IX_OrdersLog5255neverUNUSEDreview, then DROP
db_ops.db_ops.RouteEntry.IX_CampaignLog3346neverUNUSEDreview, then DROP
db_ops.db_ops.RouteEntry.IX_SupplierSummary3346neverUNUSEDreview, then DROP
db_ops.db_ops.ClaimQueue.IX_MeterMonthly3071neverUNUSEDreview, then DROP
db_ops.db_ops.ClaimQueue.IX_ShiftSummary3071neverUNUSEDreview, then DROP
db_ops.db_ops.ClaimQueue.IX_RouteEntry3071neverUNUSEDreview, then DROP
db_ops.db_ops.PricingResult.IX_ForecastLog1988neverUNUSEDreview, then DROP
db_ops.db_ops.PricingResult.IX_MeterAudit1988neverUNUSEDreview, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogSummary386neverUNUSEDreview, then DROP
db_ops.db_ops.ReconcileArchive.IX_OrdersDaily386neverUNUSEDreview, then DROP
db_ops.db_ops.ReconcileArchive.IX_WarehouseMonthly386neverUNUSEDreview, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogArchive386neverUNUSEDreview, then DROP
db_ops.db_ops.ReconcileArchive.IX_SettlementEntry386neverUNUSEDreview, then DROP
db_ops.db_ops.TerritoryStaging.IX_RosterSnapshot242neverUNUSEDreview, then DROP
db_ops.db_ops.StaffingResult.IX_OrdersQueue207neverUNUSEDreview, then DROP
db_ops.db_ops.PolicyLine.IX_CustomerDetail112neverUNUSEDreview, then DROP
db_ops.db_ops.LedgerArchive.IX_ShipmentEntry15neverUNUSEDreview, then DROP
db_ops.db_ops.LedgerArchive.IX_PricingStaging15neverUNUSEDreview, then DROP
db_ops.db_ops.PricingSummary.IX_TicketArchive12neverUNUSEDreview, then DROP

All indexes (90)

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

IndexidTypeUniqPKConstrFiltDisabledseeksscanslookupsupdateslast_readlast_stats_updateStateRecommend action
db_ops.db_ops.PricingSummary.IX_ForecastEntry121941btreeYY1200122026-08-20T11:04:33.186487+00:00neverUSEDKEEP — primary key
db_ops.db_ops.PricingSummary.IX_TicketArchive121950btree00012neverneverUNUSEDreview, then DROP
db_ops.db_ops.PricingSummary.IX_AssetEntry121949btree29114400122026-08-24T18:00:50.324399+00:00neverUSEDkeep — in use
db_ops.db_ops.PricingSummary.UX_SupplierResult121948btreeYY14554300122026-08-24T18:00:50.136646+00:00neverUSEDkeep — in use
db_ops.db_ops.SettlementDaily.IX_PricingEntry18584btreeYY3730052552026-08-24T00:44:55.256712+00:002026-08-20 23:08:31USEDKEEP — primary key
db_ops.db_ops.SettlementDaily.IX_BillingSnapshot25353btree0005255never2026-08-20 23:08:31UNUSEDreview, then DROP
db_ops.db_ops.SettlementDaily.IX_OrdersLog25352btree0005255never2026-08-20 23:08:31UNUSEDreview, then DROP
db_ops.db_ops.SettlementHistory.IX_AssetHeader87811btreeYY5239003302026-08-24T15:54:58.768604+00:002026-08-24 15:55:08USEDKEEP — primary key
db_ops.db_ops.SettlementHistory.UQ_WarehouseStaging87813btreeYY4835003302026-08-24T15:54:58.768604+00:002026-08-24 15:55:08USEDKEEP — constraint owns it
db_ops.db_ops.CampaignStaging.IX_SalesQueue87884btreeYY8007492026-08-20T10:44:19.186375+00:002026-08-21 01:42:34USEDKEEP — primary key
db_ops.db_ops.CampaignStaging.UQ_MeterSnapshot87886btreeYY16007492026-08-21T03:02:57.549454+00:002026-08-21 01:42:34USEDKEEP — constraint owns it
db_ops.db_ops.SettlementEntry.IX_StaffingDetail87852btreeYY1129007492026-08-24T15:54:25.350164+00:002026-08-21 01:42:33USEDKEEP — primary key
db_ops.db_ops.SettlementEntry.IX_WarehouseEntry87860btree4836007492026-08-24T15:54:58.768604+00:002026-08-21 01:42:33USEDkeep — in use
db_ops.db_ops.SettlementEntry.IX_BillingResult87861btree291007492026-08-24T15:57:44.706379+00:002026-08-21 01:42:33USEDkeep — in use
db_ops.db_ops.SettlementEntry.UX_QuotaMonthly87859btreeYY7783007492026-08-24T15:54:58.768604+00:002026-08-21 01:42:33USEDkeep — in use
db_ops.db_ops.StaffingResult.IX_CatalogDaily87783btreeYY4885002072026-08-24T15:54:58.768604+00:002026-08-24 15:55:08USEDKEEP — primary key
db_ops.db_ops.StaffingResult.IX_InvoiceDetail87785btreeYY280002072026-08-20T08:14:19.790753+00:002026-08-24 15:55:08USEDKEEP — constraint owns it
db_ops.db_ops.StaffingResult.IX_OrdersQueue87787btree000207never2026-08-24 15:55:08UNUSEDreview, then DROP
db_ops.db_ops.WarehouseDetail.IX_PayrollResult25357btree38380054369012026-08-24T11:59:52.418254+00:002026-08-24 08:25:03USEDkeep — in use
db_ops.db_ops.WarehouseDetail.IX_InvoiceHistory25356btree1657880054369012026-08-24T17:59:54.181767+00:002026-08-24 08:25:03USEDkeep — in use
db_ops.db_ops.WarehouseDetail.IX_SettlementDaily25355btree166150054369012026-08-24T17:57:37.615791+00:002026-08-24 08:25:03USEDkeep — in use
db_ops.db_ops.WarehouseDetail.IX_CampaignSummary25354btree80054369012026-08-13T07:02:16.990159+00:002026-08-24 08:25:03USEDkeep — in use
db_ops.db_ops.WarehouseDetail.IX_StaffingDetail18601btreeYY618383130054369012026-08-24T18:00:50.02881+00:002026-08-24 08:25:03USEDKEEP — primary key
db_ops.db_ops.TicketDetail.IX_BillingStaging70751btree0001308732never2026-08-21 04:00:42UNUSEDreview, then DROP
db_ops.db_ops.metric_results.IX_PayrollSnapshot25365btree12305400226282022026-08-24T18:00:37.93082+00:002026-08-24 14:59:09USEDkeep — in use
db_ops.db_ops.metric_results.IX_ReconcileStatus25359btree432300226282022026-08-24T17:14:13.524149+00:002026-08-24 14:59:09USEDkeep — in use
db_ops.db_ops.metric_results.IX_InvoiceMonthly25361btree00022628202never2026-08-24 14:59:09UNUSEDreview, then DROP
db_ops.db_ops.metric_results.IX_StaffingDetail25363btree4534400226282022026-08-24T18:00:50.938241+00:002026-08-24 14:59:09USEDkeep — in use
db_ops.db_ops.metric_results.IX_BillingStaging25358btree103019100226282022026-08-24T17:26:28.984911+00:002026-08-24 14:59:09USEDkeep — in use
db_ops.db_ops.metric_results.IX_ShiftAudit25362btree3600226282022026-08-19T08:32:25.119064+00:002026-08-24 14:59:09USEDkeep — in use
db_ops.db_ops.metric_results.IX_WarehouseSummary25364btree10621200226282022026-08-24T00:32:44.302683+00:002026-08-24 14:59:09USEDkeep — in use
db_ops.db_ops.metric_results.IX_SalesDetail25360btree4049502800226282022026-08-24T18:00:51.632443+00:002026-08-24 14:59:09USEDkeep — in use
db_ops.db_ops.metric_results.IX_BatchResult18615btreeYY753300226282022026-08-24T18:00:10.378372+00:002026-08-24 14:59:09USEDKEEP — primary key
db_ops.db_ops.ContractAudit.IX_OrdersAudit25366btree280085870212026-08-03T03:36:52.358025+00:002026-08-20 22:35:39USEDkeep — in use
db_ops.db_ops.SupplierMonthly.IX_CampaignAudit18631btreeYY33934001851612026-08-24T18:00:10.150783+00:002026-08-23 07:00:48USEDKEEP — primary key
db_ops.db_ops.SettlementStatus.IX_QuotaQueue25367btree00057286never2026-08-24 17:45:09UNUSEDreview, then DROP
db_ops.db_ops.SettlementStatus.IX_CatalogHistory18646btreeYY5729200572862026-08-24T18:00:14.016656+00:002026-08-24 17:45:09USEDKEEP — primary key
db_ops.db_ops.TerritoryStaging.IX_RosterSnapshot25368btree000242never2026-08-01 07:09:36UNUSEDreview, then DROP
db_ops.db_ops.TerritoryStaging.IX_BookingHeader18662btreeYY104620002422026-08-20T10:44:19.186375+00:002026-08-01 07:09:36USEDKEEP — primary key
db_ops.db_ops.reports.IX_PayrollLog121919btree00022567never2026-08-24 11:12:04UNUSEDreview, then DROP
db_ops.db_ops.reports.IX_MeterResult121917btree00022567never2026-08-24 11:12:04UNUSEDreview, then DROP
db_ops.db_ops.reports.IX_BillingDetail121918btree00022567never2026-08-24 11:12:04UNUSEDreview, then DROP
db_ops.db_ops.reports.IX_MeterQueue113506btreeYY450000225672026-08-24T18:00:13.87872+00:002026-08-24 11:12:04USEDKEEP — primary key
db_ops.db_ops.MeterDaily.IX_BookingStaging18693btreeYY56124100552026-08-20T10:44:21.85659+00:002026-08-20 10:44:21USEDKEEP — primary key
db_ops.db_ops.ShiftHeader.IX_SettlementSummary25373btree000621926never2026-08-24 08:29:08UNUSEDreview, then DROP
db_ops.db_ops.ShiftHeader.IX_ContractSummary25374btree979006219262026-08-24T17:23:50.21075+00:002026-08-24 08:29:08USEDkeep — in use
db_ops.db_ops.ShiftHeader.IX_ReconcileHistory25372btree3006219262026-08-05T06:00:55.595592+00:002026-08-24 08:29:08USEDkeep — in use
db_ops.db_ops.ShiftHeader.IX_InvoiceHistory18732btreeYY26006219262026-08-20T10:44:19.186375+00:002026-08-24 08:29:08USEDKEEP — primary key
db_ops.db_ops.RouteEntry.IX_CampaignLog25376btree0003346never2026-08-18 13:45:39UNUSEDreview, then DROP
db_ops.db_ops.RouteEntry.IX_SupplierSummary25375btree0003346never2026-08-18 13:45:39UNUSEDreview, then DROP
db_ops.db_ops.RouteEntry.IX_ReconcileArchive18755btreeYY1985090033462026-08-24T17:23:50.21075+00:002026-08-18 13:45:39USEDKEEP — primary key
db_ops.db_ops.ClaimQueue.IX_MeterMonthly25379btree0003071never2026-08-20 17:01:26UNUSEDreview, then DROP
db_ops.db_ops.ClaimQueue.IX_ShiftSummary25378btree0003071never2026-08-20 17:01:26UNUSEDreview, then DROP
db_ops.db_ops.ClaimQueue.IX_RouteEntry25377btree0003071never2026-08-20 17:01:26UNUSEDreview, then DROP
db_ops.db_ops.ClaimQueue.IX_PolicyHistory18783btreeYY16501070030712026-08-24T18:00:32.107333+00:002026-08-20 17:01:26USEDKEEP — primary key
db_ops.db_ops.BatchLine.IX_TicketHeader25380btree0001056599never2026-08-24 17:17:10UNUSEDreview, then DROP
db_ops.db_ops.BatchLine.IX_BookingSnapshot25381btree30010565992026-07-31T00:49:44.209752+00:002026-08-24 17:17:10USEDkeep — in use
db_ops.db_ops.BatchLine.IX_TicketDaily18807btreeYY260010565992026-08-20T10:44:19.186375+00:002026-08-24 17:17:10USEDKEEP — primary key
db_ops.db_ops.BatchLine.UX_LedgerQueue25382btreeY149010010565992026-08-24T17:59:03.726786+00:002026-08-24 17:17:10USEDkeep — in use
db_ops.db_ops.SupplierDaily.IX_BillingDaily25383btree578499003752026-08-24T18:00:49.831796+00:002026-08-13 08:53:31USEDkeep — in use
db_ops.db_ops.SupplierDaily.IX_SalesHistory18832btreeYY76003752026-08-24T08:30:59.576054+00:002026-08-13 08:53:31USEDKEEP — primary key
db_ops.db_ops.ReconcileArchive.IX_SettlementEntry113480btree000386never2026-08-20 10:44:21UNUSEDreview, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogArchive113484btree000386never2026-08-20 10:44:21UNUSEDreview, then DROP
db_ops.db_ops.ReconcileArchive.IX_WarehouseMonthly113482btree000386never2026-08-20 10:44:21UNUSEDreview, then DROP
db_ops.db_ops.ReconcileArchive.IX_ContractLine113483btree91157003862026-08-24T18:00:49.690991+00:002026-08-20 10:44:21USEDkeep — in use
db_ops.db_ops.ReconcileArchive.IX_OrdersDaily113479btree000386never2026-08-20 10:44:21UNUSEDreview, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogSummary113481btree000386never2026-08-20 10:44:21UNUSEDreview, then DROP
db_ops.db_ops.ReconcileArchive.IX_LedgerEntry113472btreeYY33673101003862026-08-24T18:00:49.613783+00:002026-08-20 10:44:21USEDKEEP — constraint owns it
db_ops.db_ops.ReconcileArchive.IX_ShipmentAudit113470btreeYY20003862026-08-24T08:30:54.472466+00:002026-08-20 10:44:21USEDKEEP — primary key
db_ops.db_ops.RouteLog.IX_InvoiceLine25390btree630010552026-08-13T08:00:29.865931+00:002026-08-24 03:06:58USEDkeep — in use
db_ops.db_ops.RouteLog.IX_CustomerEntry25391btree5786700010552026-08-24T18:00:49.757302+00:002026-08-24 03:06:58USEDkeep — in use
db_ops.db_ops.RouteLog.IX_InvoiceHeader18873btreeYY2340010552026-08-24T03:07:04.942708+00:002026-08-24 03:06:58USEDKEEP — primary key
db_ops.db_ops.PricingResult.IX_PolicyArchive25393btree20019882026-08-13T06:47:04.494598+00:002026-08-14 09:13:59USEDkeep — in use
db_ops.db_ops.PricingResult.IX_ForecastLog25394btree0001988never2026-08-14 09:13:59UNUSEDreview, then DROP
db_ops.db_ops.PricingResult.IX_MeterAudit25392btree0001988never2026-08-14 09:13:59UNUSEDreview, then DROP
db_ops.db_ops.PricingResult.IX_CampaignQueue18890btreeYY18210019882026-08-24T08:58:10.531475+00:002026-08-14 09:13:59USEDKEEP — constraint owns it
db_ops.db_ops.PricingResult.IX_ContractLine18888btreeYY60710019882026-08-24T08:30:49.368099+00:002026-08-14 09:13:59USEDKEEP — primary key
db_ops.db_ops.RouteHeader.IX_StaffingEntry25395btree31762001121262026-08-24T18:00:50.960214+00:002026-08-24 03:09:59USEDkeep — in use
db_ops.db_ops.RouteHeader.IX_CampaignSummary25396btree590318001121262026-08-24T18:00:49.948644+00:002026-08-24 03:09:59USEDkeep — in use
db_ops.db_ops.RouteHeader.IX_LedgerEntry18914btreeYY61720001121262026-08-24T18:00:40.643717+00:002026-08-24 03:09:59USEDKEEP — primary key
db_ops.db_ops.LedgerArchive.IX_ShipmentEntry104930btree00015neverneverUNUSEDreview, then DROP
db_ops.db_ops.LedgerArchive.IX_PricingStaging104931btree00015neverneverUNUSEDreview, then DROP
db_ops.db_ops.LedgerArchive.IX_ShiftStaging104923btreeYY500152026-08-20T10:44:19.186375+00:00neverUSEDKEEP — primary key
db_ops.db_ops.PolicyLine.IX_CustomerDetail104903btree000112never2026-08-21 03:00:35UNUSEDreview, then DROP
db_ops.db_ops.PolicyLine.IX_OrdersDaily104902btree1001122026-08-20T10:44:20.627156+00:002026-08-21 03:00:35USEDkeep — in use
db_ops.db_ops.PolicyLine.UQ_SupplierResult104895btreeYY39001122026-08-21T00:31:30.159445+00:002026-08-21 03:00:35USEDKEEP — constraint owns it
db_ops.db_ops.PolicyLine.IX_BatchResult104893btreeYY44001122026-08-21T00:31:30.2075+00:002026-08-21 03:00:35USEDKEEP — primary key
db_ops.db_ops.ShipmentMonthly.UX_ClaimSummary104869btreeYY2300172026-08-21T02:03:46.090769+00:00neverUSEDkeep — in use
db_ops.db_ops.ShipmentMonthly.IX_CampaignMonthly104867btreeYY16000172026-08-21T03:01:29.020756+00:00neverUSEDKEEP — primary key
TERRITORY.hr.MeterResult.IX_CampaignStaging16399btreeYY0001neverneverUNUSEDKEEP — primary key