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
| Metric | Count | Meaning |
|---|---|---|
| indexes_total | 90 | every index on a user table |
| used | 61 | had a seek, scan or lookup |
| unused | 29 | written but never read |
| cold | 0 | never read AND never written since restart |
| disabled | 0 | ALTER INDEX ... DISABLE was run |
| droppable | 28 | nonclustered, not unique, no constraint, never read |
| Database | Total | Cold | Disabled | Droppable | Recommend action |
|---|---|---|---|---|---|
| SETTLEMENT | 89 | 0 | 0 | 28 | review the drop candidates above |
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 |
|---|---|---|---|---|
| SETTLEMENT.SETTLEMENT.metric_results.IX_InvoiceMonthly | 22628202 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.TicketDetail.IX_BillingStaging | 1308732 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.BatchLine.IX_TicketHeader | 1056599 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.ShiftHeader.IX_SettlementSummary | 621926 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.SettlementStatus.IX_QuotaQueue | 57286 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.reports.IX_BillingDetail | 22567 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.reports.IX_MeterResult | 22567 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.reports.IX_PayrollLog | 22567 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.SettlementDaily.IX_BillingSnapshot | 5255 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.SettlementDaily.IX_OrdersLog | 5255 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.RouteEntry.IX_CampaignLog | 3346 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.RouteEntry.IX_SupplierSummary | 3346 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.ClaimQueue.IX_MeterMonthly | 3071 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.ClaimQueue.IX_ShiftSummary | 3071 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.ClaimQueue.IX_RouteEntry | 3071 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.PricingResult.IX_ForecastLog | 1988 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.PricingResult.IX_MeterAudit | 1988 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_CatalogSummary | 386 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_OrdersDaily | 386 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_WarehouseMonthly | 386 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_CatalogArchive | 386 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_SettlementEntry | 386 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.TerritoryStaging.IX_RosterSnapshot | 242 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.StaffingResult.IX_OrdersQueue | 207 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.PolicyLine.IX_CustomerDetail | 112 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.LedgerArchive.IX_ShipmentEntry | 15 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.LedgerArchive.IX_PricingStaging | 15 | never | UNUSED | review, then DROP |
| SETTLEMENT.SETTLEMENT.PricingSummary.IX_TicketArchive | 12 | never | UNUSED | review, then DROP |
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 | Constr | Filt | Disabled | seeks | scans | lookups | updates | last_read | last_stats_update | State | Recommend action |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SETTLEMENT.SETTLEMENT.PricingSummary.IX_ForecastEntry | 121941 | btree | Y | Y | 12 | 0 | 0 | 12 | 2026-08-20T11:04:33.186487+00:00 | never | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.PricingSummary.IX_TicketArchive | 121950 | btree | 0 | 0 | 0 | 12 | never | never | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.PricingSummary.IX_AssetEntry | 121949 | btree | 291144 | 0 | 0 | 12 | 2026-08-24T18:00:50.324399+00:00 | never | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.PricingSummary.UX_SupplierResult | 121948 | btree | Y | Y | 145543 | 0 | 0 | 12 | 2026-08-24T18:00:50.136646+00:00 | never | USED | keep — in use | |||
| SETTLEMENT.SETTLEMENT.SettlementDaily.IX_PricingEntry | 18584 | btree | Y | Y | 373 | 0 | 0 | 5255 | 2026-08-24T00:44:55.256712+00:00 | 2026-08-20 23:08:31 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.SettlementDaily.IX_BillingSnapshot | 25353 | btree | 0 | 0 | 0 | 5255 | never | 2026-08-20 23:08:31 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.SettlementDaily.IX_OrdersLog | 25352 | btree | 0 | 0 | 0 | 5255 | never | 2026-08-20 23:08:31 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.SettlementHistory.IX_AssetHeader | 87811 | btree | Y | Y | 5239 | 0 | 0 | 330 | 2026-08-24T15:54:58.768604+00:00 | 2026-08-24 15:55:08 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.SettlementHistory.UQ_WarehouseStaging | 87813 | btree | Y | Y | 4835 | 0 | 0 | 330 | 2026-08-24T15:54:58.768604+00:00 | 2026-08-24 15:55:08 | USED | KEEP — constraint owns it | |||
| SETTLEMENT.SETTLEMENT.CampaignStaging.IX_SalesQueue | 87884 | btree | Y | Y | 8 | 0 | 0 | 749 | 2026-08-20T10:44:19.186375+00:00 | 2026-08-21 01:42:34 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.CampaignStaging.UQ_MeterSnapshot | 87886 | btree | Y | Y | 16 | 0 | 0 | 749 | 2026-08-21T03:02:57.549454+00:00 | 2026-08-21 01:42:34 | USED | KEEP — constraint owns it | |||
| SETTLEMENT.SETTLEMENT.SettlementEntry.IX_StaffingDetail | 87852 | btree | Y | Y | 1129 | 0 | 0 | 749 | 2026-08-24T15:54:25.350164+00:00 | 2026-08-21 01:42:33 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.SettlementEntry.IX_WarehouseEntry | 87860 | btree | 4836 | 0 | 0 | 749 | 2026-08-24T15:54:58.768604+00:00 | 2026-08-21 01:42:33 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.SettlementEntry.IX_BillingResult | 87861 | btree | 291 | 0 | 0 | 749 | 2026-08-24T15:57:44.706379+00:00 | 2026-08-21 01:42:33 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.SettlementEntry.UX_QuotaMonthly | 87859 | btree | Y | Y | 7783 | 0 | 0 | 749 | 2026-08-24T15:54:58.768604+00:00 | 2026-08-21 01:42:33 | USED | keep — in use | |||
| SETTLEMENT.SETTLEMENT.StaffingResult.IX_CatalogDaily | 87783 | btree | Y | Y | 4885 | 0 | 0 | 207 | 2026-08-24T15:54:58.768604+00:00 | 2026-08-24 15:55:08 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.StaffingResult.IX_InvoiceDetail | 87785 | btree | Y | Y | 280 | 0 | 0 | 207 | 2026-08-20T08:14:19.790753+00:00 | 2026-08-24 15:55:08 | USED | KEEP — constraint owns it | |||
| SETTLEMENT.SETTLEMENT.StaffingResult.IX_OrdersQueue | 87787 | btree | 0 | 0 | 0 | 207 | never | 2026-08-24 15:55:08 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.WarehouseDetail.IX_PayrollResult | 25357 | btree | 3838 | 0 | 0 | 5436901 | 2026-08-24T11:59:52.418254+00:00 | 2026-08-24 08:25:03 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.WarehouseDetail.IX_InvoiceHistory | 25356 | btree | 165788 | 0 | 0 | 5436901 | 2026-08-24T17:59:54.181767+00:00 | 2026-08-24 08:25:03 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.WarehouseDetail.IX_SettlementDaily | 25355 | btree | 16615 | 0 | 0 | 5436901 | 2026-08-24T17:57:37.615791+00:00 | 2026-08-24 08:25:03 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.WarehouseDetail.IX_CampaignSummary | 25354 | btree | 8 | 0 | 0 | 5436901 | 2026-08-13T07:02:16.990159+00:00 | 2026-08-24 08:25:03 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.WarehouseDetail.IX_StaffingDetail | 18601 | btree | Y | Y | 61838313 | 0 | 0 | 5436901 | 2026-08-24T18:00:50.02881+00:00 | 2026-08-24 08:25:03 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.TicketDetail.IX_BillingStaging | 70751 | btree | 0 | 0 | 0 | 1308732 | never | 2026-08-21 04:00:42 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.metric_results.IX_PayrollSnapshot | 25365 | btree | 123054 | 0 | 0 | 22628202 | 2026-08-24T18:00:37.93082+00:00 | 2026-08-24 14:59:09 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.metric_results.IX_ReconcileStatus | 25359 | btree | 4323 | 0 | 0 | 22628202 | 2026-08-24T17:14:13.524149+00:00 | 2026-08-24 14:59:09 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.metric_results.IX_InvoiceMonthly | 25361 | btree | 0 | 0 | 0 | 22628202 | never | 2026-08-24 14:59:09 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.metric_results.IX_StaffingDetail | 25363 | btree | 45344 | 0 | 0 | 22628202 | 2026-08-24T18:00:50.938241+00:00 | 2026-08-24 14:59:09 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.metric_results.IX_BillingStaging | 25358 | btree | 1030191 | 0 | 0 | 22628202 | 2026-08-24T17:26:28.984911+00:00 | 2026-08-24 14:59:09 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.metric_results.IX_ShiftAudit | 25362 | btree | 36 | 0 | 0 | 22628202 | 2026-08-19T08:32:25.119064+00:00 | 2026-08-24 14:59:09 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.metric_results.IX_WarehouseSummary | 25364 | btree | 106212 | 0 | 0 | 22628202 | 2026-08-24T00:32:44.302683+00:00 | 2026-08-24 14:59:09 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.metric_results.IX_SalesDetail | 25360 | btree | 40495028 | 0 | 0 | 22628202 | 2026-08-24T18:00:51.632443+00:00 | 2026-08-24 14:59:09 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.metric_results.IX_BatchResult | 18615 | btree | Y | Y | 7533 | 0 | 0 | 22628202 | 2026-08-24T18:00:10.378372+00:00 | 2026-08-24 14:59:09 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.ContractAudit.IX_OrdersAudit | 25366 | btree | 28 | 0 | 0 | 8587021 | 2026-08-03T03:36:52.358025+00:00 | 2026-08-20 22:35:39 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.SupplierMonthly.IX_CampaignAudit | 18631 | btree | Y | Y | 33934 | 0 | 0 | 185161 | 2026-08-24T18:00:10.150783+00:00 | 2026-08-23 07:00:48 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.SettlementStatus.IX_QuotaQueue | 25367 | btree | 0 | 0 | 0 | 57286 | never | 2026-08-24 17:45:09 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.SettlementStatus.IX_CatalogHistory | 18646 | btree | Y | Y | 57292 | 0 | 0 | 57286 | 2026-08-24T18:00:14.016656+00:00 | 2026-08-24 17:45:09 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.TerritoryStaging.IX_RosterSnapshot | 25368 | btree | 0 | 0 | 0 | 242 | never | 2026-08-01 07:09:36 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.TerritoryStaging.IX_BookingHeader | 18662 | btree | Y | Y | 104620 | 0 | 0 | 242 | 2026-08-20T10:44:19.186375+00:00 | 2026-08-01 07:09:36 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.reports.IX_PayrollLog | 121919 | btree | 0 | 0 | 0 | 22567 | never | 2026-08-24 11:12:04 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.reports.IX_MeterResult | 121917 | btree | 0 | 0 | 0 | 22567 | never | 2026-08-24 11:12:04 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.reports.IX_BillingDetail | 121918 | btree | 0 | 0 | 0 | 22567 | never | 2026-08-24 11:12:04 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.reports.IX_MeterQueue | 113506 | btree | Y | Y | 4500 | 0 | 0 | 22567 | 2026-08-24T18:00:13.87872+00:00 | 2026-08-24 11:12:04 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.MeterDaily.IX_BookingStaging | 18693 | btree | Y | Y | 561241 | 0 | 0 | 55 | 2026-08-20T10:44:21.85659+00:00 | 2026-08-20 10:44:21 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.ShiftHeader.IX_SettlementSummary | 25373 | btree | 0 | 0 | 0 | 621926 | never | 2026-08-24 08:29:08 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.ShiftHeader.IX_ContractSummary | 25374 | btree | 979 | 0 | 0 | 621926 | 2026-08-24T17:23:50.21075+00:00 | 2026-08-24 08:29:08 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.ShiftHeader.IX_ReconcileHistory | 25372 | btree | 3 | 0 | 0 | 621926 | 2026-08-05T06:00:55.595592+00:00 | 2026-08-24 08:29:08 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.ShiftHeader.IX_InvoiceHistory | 18732 | btree | Y | Y | 26 | 0 | 0 | 621926 | 2026-08-20T10:44:19.186375+00:00 | 2026-08-24 08:29:08 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.RouteEntry.IX_CampaignLog | 25376 | btree | 0 | 0 | 0 | 3346 | never | 2026-08-18 13:45:39 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.RouteEntry.IX_SupplierSummary | 25375 | btree | 0 | 0 | 0 | 3346 | never | 2026-08-18 13:45:39 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.RouteEntry.IX_ReconcileArchive | 18755 | btree | Y | Y | 198509 | 0 | 0 | 3346 | 2026-08-24T17:23:50.21075+00:00 | 2026-08-18 13:45:39 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.ClaimQueue.IX_MeterMonthly | 25379 | btree | 0 | 0 | 0 | 3071 | never | 2026-08-20 17:01:26 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.ClaimQueue.IX_ShiftSummary | 25378 | btree | 0 | 0 | 0 | 3071 | never | 2026-08-20 17:01:26 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.ClaimQueue.IX_RouteEntry | 25377 | btree | 0 | 0 | 0 | 3071 | never | 2026-08-20 17:01:26 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.ClaimQueue.IX_PolicyHistory | 18783 | btree | Y | Y | 1650107 | 0 | 0 | 3071 | 2026-08-24T18:00:32.107333+00:00 | 2026-08-20 17:01:26 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.BatchLine.IX_TicketHeader | 25380 | btree | 0 | 0 | 0 | 1056599 | never | 2026-08-24 17:17:10 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.BatchLine.IX_BookingSnapshot | 25381 | btree | 3 | 0 | 0 | 1056599 | 2026-07-31T00:49:44.209752+00:00 | 2026-08-24 17:17:10 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.BatchLine.IX_TicketDaily | 18807 | btree | Y | Y | 26 | 0 | 0 | 1056599 | 2026-08-20T10:44:19.186375+00:00 | 2026-08-24 17:17:10 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.BatchLine.UX_LedgerQueue | 25382 | btree | Y | 14901 | 0 | 0 | 1056599 | 2026-08-24T17:59:03.726786+00:00 | 2026-08-24 17:17:10 | USED | keep — in use | ||||
| SETTLEMENT.SETTLEMENT.SupplierDaily.IX_BillingDaily | 25383 | btree | 578499 | 0 | 0 | 375 | 2026-08-24T18:00:49.831796+00:00 | 2026-08-13 08:53:31 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.SupplierDaily.IX_SalesHistory | 18832 | btree | Y | Y | 76 | 0 | 0 | 375 | 2026-08-24T08:30:59.576054+00:00 | 2026-08-13 08:53:31 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_SettlementEntry | 113480 | btree | 0 | 0 | 0 | 386 | never | 2026-08-20 10:44:21 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_CatalogArchive | 113484 | btree | 0 | 0 | 0 | 386 | never | 2026-08-20 10:44:21 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_WarehouseMonthly | 113482 | btree | 0 | 0 | 0 | 386 | never | 2026-08-20 10:44:21 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_ContractLine | 113483 | btree | 91157 | 0 | 0 | 386 | 2026-08-24T18:00:49.690991+00:00 | 2026-08-20 10:44:21 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_OrdersDaily | 113479 | btree | 0 | 0 | 0 | 386 | never | 2026-08-20 10:44:21 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_CatalogSummary | 113481 | btree | 0 | 0 | 0 | 386 | never | 2026-08-20 10:44:21 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_LedgerEntry | 113472 | btree | Y | Y | 33673101 | 0 | 0 | 386 | 2026-08-24T18:00:49.613783+00:00 | 2026-08-20 10:44:21 | USED | KEEP — constraint owns it | |||
| SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_ShipmentAudit | 113470 | btree | Y | Y | 20 | 0 | 0 | 386 | 2026-08-24T08:30:54.472466+00:00 | 2026-08-20 10:44:21 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.RouteLog.IX_InvoiceLine | 25390 | btree | 63 | 0 | 0 | 1055 | 2026-08-13T08:00:29.865931+00:00 | 2026-08-24 03:06:58 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.RouteLog.IX_CustomerEntry | 25391 | btree | 578670 | 0 | 0 | 1055 | 2026-08-24T18:00:49.757302+00:00 | 2026-08-24 03:06:58 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.RouteLog.IX_InvoiceHeader | 18873 | btree | Y | Y | 234 | 0 | 0 | 1055 | 2026-08-24T03:07:04.942708+00:00 | 2026-08-24 03:06:58 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.PricingResult.IX_PolicyArchive | 25393 | btree | 2 | 0 | 0 | 1988 | 2026-08-13T06:47:04.494598+00:00 | 2026-08-14 09:13:59 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.PricingResult.IX_ForecastLog | 25394 | btree | 0 | 0 | 0 | 1988 | never | 2026-08-14 09:13:59 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.PricingResult.IX_MeterAudit | 25392 | btree | 0 | 0 | 0 | 1988 | never | 2026-08-14 09:13:59 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.PricingResult.IX_CampaignQueue | 18890 | btree | Y | Y | 1821 | 0 | 0 | 1988 | 2026-08-24T08:58:10.531475+00:00 | 2026-08-14 09:13:59 | USED | KEEP — constraint owns it | |||
| SETTLEMENT.SETTLEMENT.PricingResult.IX_ContractLine | 18888 | btree | Y | Y | 6071 | 0 | 0 | 1988 | 2026-08-24T08:30:49.368099+00:00 | 2026-08-14 09:13:59 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.RouteHeader.IX_StaffingEntry | 25395 | btree | 31762 | 0 | 0 | 112126 | 2026-08-24T18:00:50.960214+00:00 | 2026-08-24 03:09:59 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.RouteHeader.IX_CampaignSummary | 25396 | btree | 590318 | 0 | 0 | 112126 | 2026-08-24T18:00:49.948644+00:00 | 2026-08-24 03:09:59 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.RouteHeader.IX_LedgerEntry | 18914 | btree | Y | Y | 61720 | 0 | 0 | 112126 | 2026-08-24T18:00:40.643717+00:00 | 2026-08-24 03:09:59 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.LedgerArchive.IX_ShipmentEntry | 104930 | btree | 0 | 0 | 0 | 15 | never | never | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.LedgerArchive.IX_PricingStaging | 104931 | btree | 0 | 0 | 0 | 15 | never | never | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.LedgerArchive.IX_ShiftStaging | 104923 | btree | Y | Y | 5 | 0 | 0 | 15 | 2026-08-20T10:44:19.186375+00:00 | never | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.PolicyLine.IX_CustomerDetail | 104903 | btree | 0 | 0 | 0 | 112 | never | 2026-08-21 03:00:35 | UNUSED | review, then DROP | |||||
| SETTLEMENT.SETTLEMENT.PolicyLine.IX_OrdersDaily | 104902 | btree | 1 | 0 | 0 | 112 | 2026-08-20T10:44:20.627156+00:00 | 2026-08-21 03:00:35 | USED | keep — in use | |||||
| SETTLEMENT.SETTLEMENT.PolicyLine.UQ_SupplierResult | 104895 | btree | Y | Y | 39 | 0 | 0 | 112 | 2026-08-21T00:31:30.159445+00:00 | 2026-08-21 03:00:35 | USED | KEEP — constraint owns it | |||
| SETTLEMENT.SETTLEMENT.PolicyLine.IX_BatchResult | 104893 | btree | Y | Y | 44 | 0 | 0 | 112 | 2026-08-21T00:31:30.2075+00:00 | 2026-08-21 03:00:35 | USED | KEEP — primary key | |||
| SETTLEMENT.SETTLEMENT.ShipmentMonthly.UX_ClaimSummary | 104869 | btree | Y | Y | 23 | 0 | 0 | 17 | 2026-08-21T02:03:46.090769+00:00 | never | USED | keep — in use | |||
| SETTLEMENT.SETTLEMENT.ShipmentMonthly.IX_CampaignMonthly | 104867 | btree | Y | Y | 160 | 0 | 0 | 17 | 2026-08-21T03:01:29.020756+00:00 | never | USED | KEEP — primary key | |||
| TERRITORY.hr.MeterResult.IX_CampaignStaging | 16399 | btree | Y | Y | 0 | 0 | 0 | 1 | never | never | UNUSED | KEEP — primary key |