Index Usage — ACME-192-0-2-15-PG-5433

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

Host: 192.0.2.15

Collected: 2026-10-02T17:01:40Z

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

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

Metric	Count	Meaning
indexes_total	287	every index on a user table
used	97	had a seek, scan or lookup
unused	73	written but never read
cold	117	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	133	nonclustered, not unique, no constraint, never read

By database

Database	Total	Cold	Disabled	Droppable	Recommend action
db_ops	287	117	0	133	review the drop candidates above

Drop candidates (133)

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
db_ops.db_ops.metric_results.IX_InvoiceMonthly	6506109	never	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_StaffingDetail	6506109	never	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_ShiftAudit	6506109	never	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_WarehouseSummary	6506109	never	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_ReconcileStatus	2381518	never	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_InvoiceMonthly	2381518	never	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_ShiftAudit	2381518	never	UNUSED	review, then DROP
db_ops.db_ops.ContractAudit.IX_OrdersAudit	1889650	never	UNUSED	review, then DROP
db_ops.db_ops.WarehouseDetail.IX_CampaignSummary	1191076	never	UNUSED	review, then DROP
db_ops.billing.WarehouseDetail.IX_SettlementDaily	468583	never	UNUSED	review, then DROP
db_ops.db_ops.TicketDetail.IX_BillingStaging	155153	never	UNUSED	review, then DROP
db_ops.billing.ClaimQueue.IX_ShiftSummary	127887	never	UNUSED	review, then DROP
db_ops.db_ops.BatchLine.IX_TicketHeader	70637	never	UNUSED	review, then DROP
db_ops.db_ops.BatchLine.IX_BookingSnapshot	70637	never	UNUSED	review, then DROP
db_ops.billing.TicketDetail.IX_BillingStaging	54522	never	UNUSED	review, then DROP
db_ops.db_ops.ShiftHeader.IX_SettlementSummary	47712	never	UNUSED	review, then DROP
db_ops.db_ops.ShiftHeader.IX_ReconcileHistory	47712	never	UNUSED	review, then DROP
db_ops.billing.BatchLine.IX_TicketHeader	37002	never	UNUSED	review, then DROP
db_ops.billing.BatchLine.IX_BookingSnapshot	37002	never	UNUSED	review, then DROP
db_ops.db_ops.SettlementStatus.IX_QuotaQueue	21272	never	UNUSED	review, then DROP
db_ops.billing.reports.IX_PayrollLog	13892	never	UNUSED	review, then DROP
db_ops.billing.reports.IX_MeterResult	13892	never	UNUSED	review, then DROP
db_ops.billing.reports.IX_BillingDetail	13892	never	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_PayrollLog	12690	never	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_MeterResult	12690	never	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_BillingDetail	12690	never	UNUSED	review, then DROP
db_ops.billing.SettlementStatus.IX_QuotaQueue	11730	never	UNUSED	review, then DROP
db_ops.billing.ShiftHeader.IX_SettlementSummary	3871	never	UNUSED	review, then DROP
db_ops.billing.ShiftHeader.IX_ReconcileHistory	3871	never	UNUSED	review, then DROP
db_ops.billing.StaffingResult.IX_OrdersQueue	270	never	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_SettlementEntry	206	never	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_CatalogArchive	206	never	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_WarehouseMonthly	206	never	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_OrdersDaily	206	never	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_CatalogSummary	206	never	UNUSED	review, then DROP
db_ops.db_ops.SettlementDaily.IX_BillingSnapshot	156	never	UNUSED	review, then DROP
db_ops.db_ops.SettlementDaily.IX_OrdersLog	156	never	UNUSED	review, then DROP
db_ops.db_ops.RouteEntry.IX_CampaignLog	142	never	UNUSED	review, then DROP
db_ops.db_ops.RouteEntry.IX_SupplierSummary	142	never	UNUSED	review, then DROP
db_ops.db_ops.SettlementEntry.IX_BillingResult	130	never	UNUSED	review, then DROP
db_ops.billing.TerritoryStaging.IX_RosterSnapshot	96	never	UNUSED	review, then DROP
db_ops.billing.SettlementEntry.IX_BillingResult	94	never	UNUSED	review, then DROP
db_ops.billing.RouteEntry.IX_SupplierSummary	79	never	UNUSED	review, then DROP
db_ops.db_ops.StaffingResult.IX_OrdersQueue	61	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_SettlementEntry	60	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogArchive	60	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_WarehouseMonthly	60	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_OrdersDaily	60	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogSummary	60	never	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_PolicyArchive	56	never	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_ForecastLog	56	never	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_MeterAudit	56	never	UNUSED	review, then DROP
db_ops.billing.SettlementDaily.IX_BillingSnapshot	44	never	UNUSED	review, then DROP
db_ops.billing.SettlementDaily.IX_OrdersLog	44	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_PolicyArchive	25	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_ForecastLog	25	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_MeterAudit	25	never	UNUSED	review, then DROP
db_ops.db_ops.SupplierLog.IX_ContractResult	22	never	UNUSED	review, then DROP
db_ops.billing.AssetAudit.IX_OrdersMonthly	7	never	UNUSED	review, then DROP
db_ops.billing.RouteLog.IX_InvoiceLine	6	never	UNUSED	review, then DROP
db_ops.billing.RouteLog.IX_CustomerEntry	6	never	UNUSED	review, then DROP
db_ops.db_ops.AssetAudit.IX_OrdersMonthly	4	never	UNUSED	review, then DROP
db_ops.db_ops.PricingSummary.IX_TicketArchive	0	never	COLD	review, then DROP
db_ops.db_ops.PricingSummary.IX_AssetEntry	0	never	COLD	review, then DROP
db_ops.db_ops.QuotaHistory.IX_ShiftHistory	0	never	COLD	review, then DROP
db_ops.db_ops.TerritoryStaging.IX_RosterSnapshot	0	never	COLD	review, then DROP
db_ops.db_ops.LedgerArchive.IX_ShipmentEntry	0	never	COLD	review, then DROP
db_ops.db_ops.LedgerArchive.IX_PricingStaging	0	never	COLD	review, then DROP
db_ops.db_ops.PolicyLine.IX_CustomerDetail	0	never	COLD	review, then DROP
db_ops.db_ops.PolicyLine.IX_OrdersDaily	0	never	COLD	review, then DROP
db_ops.report.PricingSummary.IX_TicketArchive	0	never	COLD	review, then DROP
db_ops.report.PricingSummary.IX_AssetEntry	0	never	COLD	review, then DROP
db_ops.report.QuotaHistory.IX_ShiftHistory	0	never	COLD	review, then DROP
db_ops.report.SettlementDaily.IX_BillingSnapshot	0	never	COLD	review, then DROP
db_ops.report.SettlementDaily.IX_OrdersLog	0	never	COLD	review, then DROP
db_ops.report.SettlementEntry.IX_WarehouseEntry	0	never	COLD	review, then DROP
db_ops.report.SettlementEntry.IX_BillingResult	0	never	COLD	review, then DROP
db_ops.report.StaffingResult.IX_OrdersQueue	0	never	COLD	review, then DROP
db_ops.report.WarehouseDetail.IX_PayrollResult	0	never	COLD	review, then DROP
db_ops.report.WarehouseDetail.IX_InvoiceHistory	0	never	COLD	review, then DROP
db_ops.report.WarehouseDetail.IX_SettlementDaily	0	never	COLD	review, then DROP
db_ops.report.WarehouseDetail.IX_CampaignSummary	0	never	COLD	review, then DROP
db_ops.report.TicketDetail.IX_BillingStaging	0	never	COLD	review, then DROP
db_ops.report.metric_results.IX_PayrollSnapshot	0	never	COLD	review, then DROP
db_ops.report.metric_results.IX_ReconcileStatus	0	never	COLD	review, then DROP
db_ops.report.metric_results.IX_InvoiceMonthly	0	never	COLD	review, then DROP
db_ops.report.metric_results.IX_StaffingDetail	0	never	COLD	review, then DROP
db_ops.report.metric_results.IX_BillingStaging	0	never	COLD	review, then DROP
db_ops.report.metric_results.IX_ShiftAudit	0	never	COLD	review, then DROP
db_ops.report.metric_results.IX_WarehouseSummary	0	never	COLD	review, then DROP
db_ops.report.ContractAudit.IX_OrdersAudit	0	never	COLD	review, then DROP
db_ops.report.SettlementStatus.IX_QuotaQueue	0	never	COLD	review, then DROP
db_ops.report.TerritoryStaging.IX_RosterSnapshot	0	never	COLD	review, then DROP
db_ops.report.reports.IX_PayrollLog	0	never	COLD	review, then DROP
db_ops.report.reports.IX_MeterResult	0	never	COLD	review, then DROP
db_ops.report.reports.IX_BillingDetail	0	never	COLD	review, then DROP
db_ops.report.AssetAudit.IX_OrdersMonthly	0	never	COLD	review, then DROP
db_ops.report.ShiftHeader.IX_SettlementSummary	0	never	COLD	review, then DROP
db_ops.report.ShiftHeader.IX_ContractSummary	0	never	COLD	review, then DROP
db_ops.report.ShiftHeader.IX_ReconcileHistory	0	never	COLD	review, then DROP
db_ops.report.RouteEntry.IX_CampaignLog	0	never	COLD	review, then DROP
db_ops.report.RouteEntry.IX_SupplierSummary	0	never	COLD	review, then DROP
db_ops.report.ClaimQueue.IX_MeterMonthly	0	never	COLD	review, then DROP
db_ops.report.ClaimQueue.IX_ShiftSummary	0	never	COLD	review, then DROP
db_ops.report.ClaimQueue.IX_RouteEntry	0	never	COLD	review, then DROP
db_ops.report.BatchLine.IX_TicketHeader	0	never	COLD	review, then DROP
db_ops.report.BatchLine.IX_BookingSnapshot	0	never	COLD	review, then DROP
db_ops.report.SupplierDaily.IX_BillingDaily	0	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_SettlementEntry	0	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_CatalogArchive	0	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_WarehouseMonthly	0	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_ContractLine	0	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_OrdersDaily	0	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_CatalogSummary	0	never	COLD	review, then DROP
db_ops.report.RouteLog.IX_InvoiceLine	0	never	COLD	review, then DROP
db_ops.report.RouteLog.IX_CustomerEntry	0	never	COLD	review, then DROP
db_ops.report.PricingResult.IX_PolicyArchive	0	never	COLD	review, then DROP
db_ops.report.PricingResult.IX_ForecastLog	0	never	COLD	review, then DROP
db_ops.report.PricingResult.IX_MeterAudit	0	never	COLD	review, then DROP
db_ops.report.RouteHeader.IX_StaffingEntry	0	never	COLD	review, then DROP
db_ops.report.RouteHeader.IX_CampaignSummary	0	never	COLD	review, then DROP
db_ops.report.LedgerArchive.IX_ShipmentEntry	0	never	COLD	review, then DROP
db_ops.report.LedgerArchive.IX_PricingStaging	0	never	COLD	review, then DROP
db_ops.report.PolicyLine.IX_CustomerDetail	0	never	COLD	review, then DROP
db_ops.report.PolicyLine.IX_OrdersDaily	0	never	COLD	review, then DROP
db_ops.billing.PricingSummary.IX_TicketArchive	0	never	COLD	review, then DROP
db_ops.billing.QuotaHistory.IX_ShiftHistory	0	never	COLD	review, then DROP
db_ops.billing.ContractAudit.IX_OrdersAudit	0	never	COLD	review, then DROP
db_ops.billing.LedgerArchive.IX_SalesSnapshot	0	never	COLD	review, then DROP
db_ops.billing.LedgerArchive.IX_ShipmentEntry	0	never	COLD	review, then DROP
db_ops.billing.LedgerArchive.IX_PricingStaging	0	never	COLD	review, then DROP
db_ops.billing.PolicyLine.IX_CustomerDetail	0	never	COLD	review, then DROP
db_ops.billing.PolicyLine.IX_OrdersDaily	0	never	COLD	review, then DROP

All indexes (287)

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	seeks	updates	last_read	last_stats_update	State	Recommend action
db_ops.db_ops.PricingSummary.IX_ForecastEntry	49445	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.db_ops.PricingSummary.IX_TicketArchive	49447	btree					0	0	never	never	COLD	review, then DROP
db_ops.db_ops.PricingSummary.IX_AssetEntry	49448	btree					0	0	never	never	COLD	review, then DROP
db_ops.db_ops.PricingSummary.UX_SupplierResult	49449	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
db_ops.db_ops.QuotaHistory.IX_ShiftHistory	248903	btree					0	0	never	never	COLD	review, then DROP
db_ops.db_ops.SettlementDaily.IX_PricingEntry	49348	btree	Y	Y			78	156	2026-10-01T23:07:01.32918+00:00	never	USED	KEEP — primary key
db_ops.db_ops.SettlementDaily.IX_BillingSnapshot	49336	btree					0	156	never	never	UNUSED	review, then DROP
db_ops.db_ops.SettlementDaily.IX_OrdersLog	49343	btree					0	156	never	never	UNUSED	review, then DROP
db_ops.db_ops.SettlementHistory.IX_AssetHeader	49383	btree	Y	Y			258	104	2026-10-01T08:43:56.020082+00:00	2026-09-30 08:10:45	USED	KEEP — primary key
db_ops.db_ops.SettlementHistory.UQ_WarehouseStaging	49390	btree	Y		Y		258	104	2026-10-01T08:43:56.020082+00:00	2026-09-30 08:10:45	USED	KEEP — constraint owns it
db_ops.db_ops.CampaignStaging.IX_SalesQueue	49271	btree	Y	Y			0	130	never	never	UNUSED	KEEP — primary key
db_ops.db_ops.CampaignStaging.UQ_MeterSnapshot	49273	btree	Y		Y		0	130	never	never	UNUSED	KEEP — constraint owns it
db_ops.db_ops.SettlementEntry.IX_StaffingDetail	49299	btree	Y	Y			254	130	2026-10-01T08:43:53.884426+00:00	2026-09-30 08:16:45	USED	KEEP — primary key
db_ops.db_ops.SettlementEntry.IX_WarehouseEntry	49315	btree					258	130	2026-10-01T08:43:56.020082+00:00	2026-09-30 08:16:45	USED	keep — in use
db_ops.db_ops.SettlementEntry.IX_BillingResult	49316	btree					0	130	never	2026-09-30 08:16:45	UNUSED	review, then DROP
db_ops.db_ops.SettlementEntry.UX_QuotaMonthly	49317	btree	Y			Y	1373	130	2026-10-01T08:43:56.020082+00:00	2026-09-30 08:16:45	USED	keep — in use
db_ops.db_ops.StaffingResult.IX_CatalogDaily	49374	btree	Y	Y			258	61	2026-10-01T08:43:56.020082+00:00	2026-09-30 08:10:45	USED	KEEP — primary key
db_ops.db_ops.StaffingResult.IX_InvoiceDetail	49376	btree	Y		Y		0	61	never	2026-09-30 08:10:45	UNUSED	KEEP — constraint owns it
db_ops.db_ops.StaffingResult.IX_OrdersQueue	49320	btree					0	61	never	2026-09-30 08:10:45	UNUSED	review, then DROP
db_ops.db_ops.WarehouseDetail.IX_PayrollResult	46502	btree					2761	1191076	2026-10-02T14:54:27.198532+00:00	2026-10-02 05:53:17	USED	keep — in use
db_ops.db_ops.WarehouseDetail.IX_InvoiceHistory	46505	btree					1369133	1191076	2026-10-02T17:01:39.026036+00:00	2026-10-02 05:53:17	USED	keep — in use
db_ops.db_ops.WarehouseDetail.IX_SettlementDaily	46507	btree					4362	1191076	2026-10-02T16:59:58.571615+00:00	2026-10-02 05:53:17	USED	keep — in use
db_ops.db_ops.WarehouseDetail.IX_CampaignSummary	46509	btree					0	1191076	never	2026-10-02 05:53:17	UNUSED	review, then DROP
db_ops.db_ops.WarehouseDetail.IX_StaffingDetail	46514	btree	Y	Y			21455069	1191076	2026-10-02T17:01:40.269034+00:00	2026-10-02 05:53:17	USED	KEEP — primary key
db_ops.db_ops.WarehouseDetail.UX_SupplierLine	473550	btree	Y			Y	0	1191076	never	2026-10-02 05:53:17	UNUSED	review carefully — unique
db_ops.db_ops.TicketDetail.IX_BillingStaging	46498	btree					0	155153	never	never	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_PayrollSnapshot	49487	btree					37036	6506109	2026-10-02T17:00:29.758713+00:00	2026-10-02 14:41:29	USED	keep — in use
db_ops.db_ops.metric_results.IX_ReconcileStatus	49486	btree					57	6506109	2026-10-02T00:14:46.526947+00:00	2026-10-02 14:41:29	USED	keep — in use
db_ops.db_ops.metric_results.IX_InvoiceMonthly	49484	btree					0	6506109	never	2026-10-02 14:41:29	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_StaffingDetail	49485	btree					0	6506109	never	2026-10-02 14:41:29	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_BillingStaging	49488	btree					544585	6506109	2026-10-02T16:56:10.783194+00:00	2026-10-02 14:41:29	USED	keep — in use
db_ops.db_ops.metric_results.IX_ShiftAudit	49489	btree					0	6506109	never	2026-10-02 14:41:29	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_WarehouseSummary	49490	btree					0	6506109	never	2026-10-02 14:41:29	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_SalesDetail	49491	btree					6087701	6506109	2026-10-02T17:00:58.61902+00:00	2026-10-02 14:41:29	USED	keep — in use
db_ops.db_ops.metric_results.IX_BatchResult	49492	btree	Y	Y			8839	6506109	2026-10-02T17:00:10.404144+00:00	2026-10-02 14:41:29	USED	KEEP — primary key
db_ops.db_ops.ContractAudit.IX_OrdersAudit	47914	btree					0	1889650	never	2026-10-01 03:39:22	UNUSED	review, then DROP
db_ops.db_ops.SupplierMonthly.IX_CampaignAudit	49239	btree	Y	Y			8882	8744	2026-10-02T17:00:58.670587+00:00	2026-09-30 22:06:07	USED	KEEP — primary key
db_ops.db_ops.SettlementStatus.IX_QuotaQueue	49416	btree					0	21272	never	2026-10-02 16:43:31	UNUSED	review, then DROP
db_ops.db_ops.SettlementStatus.IX_CatalogHistory	49420	btree	Y	Y			21272	21272	2026-10-02T17:00:14.865668+00:00	2026-10-02 16:43:31	USED	KEEP — primary key
db_ops.db_ops.TerritoryStaging.IX_RosterSnapshot	49398	btree					0	0	never	never	COLD	review, then DROP
db_ops.db_ops.TerritoryStaging.IX_BookingHeader	49399	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.db_ops.reports.IX_PayrollLog	505334	btree					0	12690	never	2026-10-02 10:20:22	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_MeterResult	505332	btree					0	12690	never	2026-10-02 10:20:22	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_BillingDetail	505333	btree					0	12690	never	2026-10-02 10:20:22	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_MeterQueue	473606	btree	Y	Y			8505	12690	2026-10-02T17:00:14.595179+00:00	2026-10-02 10:20:22	USED	KEEP — primary key
db_ops.db_ops.AssetAudit.IX_OrdersMonthly	285096	btree					0	4	never	never	UNUSED	review, then DROP
db_ops.db_ops.AssetAudit.IX_StaffingDetail	285094	btree	Y	Y			4	4	2026-09-30T08:41:56.654615+00:00	never	USED	KEEP — primary key
db_ops.db_ops.MeterDaily.IX_BookingStaging	49443	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.db_ops.ShiftHeader.IX_SettlementSummary	46624	btree					0	47712	never	2026-10-02 07:09:22	UNUSED	review, then DROP
db_ops.db_ops.ShiftHeader.IX_ContractSummary	46626	btree					284	47712	2026-10-02T16:04:35.526514+00:00	2026-10-02 07:09:22	USED	keep — in use
db_ops.db_ops.ShiftHeader.IX_ReconcileHistory	46627	btree					0	47712	never	2026-10-02 07:09:22	UNUSED	review, then DROP
db_ops.db_ops.ShiftHeader.IX_InvoiceHistory	46631	btree	Y	Y			0	47712	never	2026-10-02 07:09:22	UNUSED	KEEP — primary key
db_ops.db_ops.RouteEntry.IX_CampaignLog	49357	btree					0	142	never	never	UNUSED	review, then DROP
db_ops.db_ops.RouteEntry.IX_SupplierSummary	49358	btree					0	142	never	never	UNUSED	review, then DROP
db_ops.db_ops.RouteEntry.IX_ReconcileArchive	49362	btree	Y	Y			48422	142	2026-10-02T16:04:35.526514+00:00	never	USED	KEEP — primary key
db_ops.db_ops.ClaimQueue.IX_MeterMonthly	35408	btree					24152	140177	2026-10-02T17:01:30.861563+00:00	2026-10-02 12:43:26	USED	keep — in use
db_ops.db_ops.ClaimQueue.IX_ShiftSummary	35410	btree					2	140177	2026-09-30T08:29:42.448423+00:00	2026-10-02 12:43:26	USED	keep — in use
db_ops.db_ops.ClaimQueue.IX_RouteEntry	35411	btree					186233	140177	2026-10-02T17:01:40.719578+00:00	2026-10-02 12:43:26	USED	keep — in use
db_ops.db_ops.ClaimQueue.IX_PolicyHistory	35412	btree	Y	Y			13705627	140177	2026-10-02T17:01:38.710312+00:00	2026-10-02 12:43:26	USED	KEEP — primary key
db_ops.db_ops.ClaimQueue.UX_RouteArchive	473551	btree	Y			Y	1	140177	2026-09-30T08:29:42.448423+00:00	2026-10-02 12:43:26	USED	keep — in use
db_ops.db_ops.BatchLine.IX_TicketHeader	46623	btree					0	70637	never	2026-10-01 23:28:42	UNUSED	review, then DROP
db_ops.db_ops.BatchLine.IX_BookingSnapshot	46630	btree					0	70637	never	2026-10-01 23:28:42	UNUSED	review, then DROP
db_ops.db_ops.BatchLine.IX_TicketDaily	46633	btree	Y	Y			0	70637	never	2026-10-01 23:28:42	UNUSED	KEEP — primary key
db_ops.db_ops.BatchLine.UX_LedgerQueue	46721	btree	Y				4372	70637	2026-10-02T17:01:00.274899+00:00	2026-10-01 23:28:42	USED	keep — in use
db_ops.db_ops.SupplierDaily.IX_BillingDaily	49356	btree					123324	2	2026-10-02T17:01:36.370767+00:00	never	USED	keep — in use
db_ops.db_ops.SupplierDaily.IX_SalesHistory	49359	btree	Y	Y			1	2	2026-10-01T06:35:59.153603+00:00	never	USED	KEEP — primary key
db_ops.db_ops.ReconcileArchive.IX_SettlementEntry	473580	btree					0	60	never	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogArchive	473584	btree					0	60	never	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_WarehouseMonthly	473582	btree					0	60	never	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_ContractLine	473583	btree					123337	60	2026-10-02T17:01:36.243046+00:00	never	USED	keep — in use
db_ops.db_ops.ReconcileArchive.IX_OrdersDaily	473579	btree					0	60	never	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogSummary	473581	btree					0	60	never	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_LedgerEntry	473572	btree	Y		Y		71482414	60	2026-10-02T17:01:36.188509+00:00	never	USED	KEEP — constraint owns it
db_ops.db_ops.ReconcileArchive.IX_ShipmentAudit	473570	btree	Y	Y			47	60	2026-10-01T06:35:50.517347+00:00	never	USED	KEEP — primary key
db_ops.db_ops.RouteLog.IX_InvoiceLine	47988	btree					11	33	2026-10-01T06:35:38.557331+00:00	never	USED	keep — in use
db_ops.db_ops.RouteLog.IX_CustomerEntry	47995	btree					123324	33	2026-10-02T17:01:36.302819+00:00	never	USED	keep — in use
db_ops.db_ops.RouteLog.IX_InvoiceHeader	47998	btree	Y	Y			756	33	2026-10-01T06:35:49.260671+00:00	never	USED	KEEP — primary key
db_ops.db_ops.PricingResult.IX_PolicyArchive	49297	btree					0	25	never	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_ForecastLog	49318	btree					0	25	never	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_MeterAudit	49319	btree					0	25	never	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_CampaignQueue	49321	btree	Y		Y		53	25	2026-10-01T06:35:45.9428+00:00	never	USED	KEEP — constraint owns it
db_ops.db_ops.PricingResult.IX_ContractLine	49326	btree	Y	Y			13	25	2026-10-01T06:35:09.170257+00:00	never	USED	KEEP — primary key
db_ops.db_ops.RouteHeader.IX_StaffingEntry	49237	btree					17492	20735	2026-10-02T17:01:15.619716+00:00	2026-10-01 00:03:11	USED	keep — in use
db_ops.db_ops.RouteHeader.IX_CampaignSummary	49238	btree					123324	20735	2026-10-02T17:01:36.423459+00:00	2026-10-01 00:03:11	USED	keep — in use
db_ops.db_ops.RouteHeader.IX_LedgerEntry	49261	btree	Y	Y			27789	20735	2026-10-02T17:00:16.725468+00:00	2026-10-01 00:03:11	USED	KEEP — primary key
db_ops.db_ops.SupplierLog.IX_ContractResult	314329	btree					0	22	never	never	UNUSED	review, then DROP
db_ops.db_ops.SupplierLog.IX_ForecastLog	314328	btree					11	22	2026-10-01T06:35:38.509031+00:00	never	USED	keep — in use
db_ops.db_ops.SupplierLog.IX_OrdersDaily	314319	btree	Y	Y			0	22	never	never	UNUSED	KEEP — primary key
db_ops.db_ops.SupplierLog.IX_ForecastMonthly	314321	btree	Y		Y		0	22	never	never	UNUSED	KEEP — constraint owns it
db_ops.db_ops.LedgerArchive.IX_ShipmentEntry	49401	btree					0	0	never	never	COLD	review, then DROP
db_ops.db_ops.LedgerArchive.IX_PricingStaging	49402	btree					0	0	never	never	COLD	review, then DROP
db_ops.db_ops.LedgerArchive.IX_ShiftStaging	49408	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.db_ops.PolicyLine.IX_CustomerDetail	49361	btree					0	0	never	never	COLD	review, then DROP
db_ops.db_ops.PolicyLine.IX_OrdersDaily	49364	btree					0	0	never	never	COLD	review, then DROP
db_ops.db_ops.PolicyLine.UQ_SupplierResult	49370	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
db_ops.db_ops.PolicyLine.IX_BatchResult	49372	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.db_ops.ShipmentMonthly.UX_ClaimSummary	49427	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
db_ops.db_ops.ShipmentMonthly.IX_CampaignMonthly	49428	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.PricingSummary.IX_ForecastEntry	305448	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.PricingSummary.IX_TicketArchive	305457	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.PricingSummary.IX_AssetEntry	305456	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.PricingSummary.UX_SupplierResult	305455	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
db_ops.report.QuotaHistory.IX_ShiftHistory	305463	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.SettlementDaily.IX_PricingEntry	305195	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.SettlementDaily.IX_BillingSnapshot	305197	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.SettlementDaily.IX_OrdersLog	305198	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.SettlementHistory.IX_AssetHeader	305249	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.SettlementHistory.UQ_WarehouseStaging	305251	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
db_ops.report.CampaignStaging.IX_SalesQueue	305322	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.CampaignStaging.UQ_MeterSnapshot	305324	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
db_ops.report.SettlementEntry.IX_StaffingDetail	305290	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.SettlementEntry.IX_WarehouseEntry	305298	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.SettlementEntry.IX_BillingResult	305299	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.SettlementEntry.UX_QuotaMonthly	305297	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
db_ops.report.StaffingResult.IX_CatalogDaily	305221	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.StaffingResult.IX_InvoiceDetail	305223	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
db_ops.report.StaffingResult.IX_OrdersQueue	305225	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.WarehouseDetail.IX_PayrollResult	304649	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.WarehouseDetail.IX_InvoiceHistory	304650	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.WarehouseDetail.IX_SettlementDaily	304651	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.WarehouseDetail.IX_CampaignSummary	304652	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.WarehouseDetail.IX_StaffingDetail	304647	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.TicketDetail.IX_BillingStaging	304658	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.metric_results.IX_PayrollSnapshot	305006	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.metric_results.IX_ReconcileStatus	305012	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.metric_results.IX_InvoiceMonthly	305011	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.metric_results.IX_StaffingDetail	305008	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.metric_results.IX_BillingStaging	305009	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.metric_results.IX_ShiftAudit	305010	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.metric_results.IX_WarehouseSummary	305007	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.metric_results.IX_BatchResult	305004	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.ContractAudit.IX_OrdersAudit	305018	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.SupplierMonthly.IX_CampaignAudit	304989	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.SettlementStatus.IX_QuotaQueue	304948	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.SettlementStatus.IX_CatalogHistory	304946	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.TerritoryStaging.IX_RosterSnapshot	304868	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.TerritoryStaging.IX_BookingHeader	304866	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.reports.IX_PayrollLog	305180	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.reports.IX_MeterResult	305178	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.reports.IX_BillingDetail	305179	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.reports.IX_MeterQueue	305171	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.AssetAudit.IX_OrdersMonthly	304849	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.AssetAudit.IX_StaffingDetail	304847	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.MeterDaily.IX_BookingStaging	304627	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.ShiftHeader.IX_SettlementSummary	305115	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ShiftHeader.IX_ContractSummary	305114	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ShiftHeader.IX_ReconcileHistory	305116	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ShiftHeader.IX_InvoiceHistory	305107	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.RouteEntry.IX_CampaignLog	305069	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.RouteEntry.IX_SupplierSummary	305070	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.RouteEntry.IX_ReconcileArchive	305067	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.ClaimQueue.IX_MeterMonthly	304691	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ClaimQueue.IX_ShiftSummary	304692	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ClaimQueue.IX_RouteEntry	304693	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ClaimQueue.IX_PolicyHistory	304689	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.BatchLine.IX_TicketHeader	305045	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.BatchLine.IX_BookingSnapshot	305044	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.BatchLine.IX_TicketDaily	305041	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.BatchLine.UX_LedgerQueue	305043	btree	Y				0	0	never	never	COLD	review carefully — unique
db_ops.report.SupplierDaily.IX_BillingDaily	304824	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.SupplierDaily.IX_SalesHistory	304822	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.ReconcileArchive.IX_SettlementEntry	305145	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_CatalogArchive	305149	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_WarehouseMonthly	305147	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_ContractLine	305148	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_OrdersDaily	305144	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_CatalogSummary	305146	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_BookingStaging	305137	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
db_ops.report.ReconcileArchive.IX_ClaimDetail	305135	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.RouteLog.IX_InvoiceLine	304770	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.RouteLog.IX_CustomerEntry	304769	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.RouteLog.IX_InvoiceHeader	304767	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.PricingResult.IX_PolicyArchive	304713	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.PricingResult.IX_ForecastLog	304712	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.PricingResult.IX_MeterAudit	304714	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.PricingResult.IX_CampaignQueue	304710	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
db_ops.report.PricingResult.IX_ContractLine	304708	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.RouteHeader.IX_StaffingEntry	304798	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.RouteHeader.IX_CampaignSummary	304797	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.RouteHeader.IX_LedgerEntry	304795	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.LedgerArchive.IX_ShipmentEntry	305427	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.LedgerArchive.IX_PricingStaging	305428	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.LedgerArchive.IX_ShiftStaging	305420	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.PolicyLine.IX_CustomerDetail	305400	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.PolicyLine.IX_OrdersDaily	305399	btree					0	0	never	never	COLD	review, then DROP
db_ops.report.PolicyLine.UQ_SupplierResult	305392	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
db_ops.report.PolicyLine.IX_BatchResult	305390	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.report.ShipmentMonthly.UX_ClaimSummary	305366	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
db_ops.report.ShipmentMonthly.IX_CampaignMonthly	305364	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
db_ops.billing.PricingSummary.IX_ForecastEntry	344543	btree	Y	Y			16	0	2026-10-02T09:32:40.413349+00:00	never	USED	KEEP — primary key
db_ops.billing.PricingSummary.IX_TicketArchive	344552	btree					0	0	never	never	COLD	review, then DROP
db_ops.billing.PricingSummary.IX_AssetEntry	344551	btree					281905	0	2026-10-02T17:01:39.676204+00:00	never	USED	keep — in use
db_ops.billing.PricingSummary.UX_SupplierResult	344550	btree	Y			Y	140954	0	2026-10-02T17:01:39.479981+00:00	never	USED	keep — in use
db_ops.billing.QuotaHistory.IX_ShiftHistory	344558	btree					0	0	never	never	COLD	review, then DROP
db_ops.billing.SettlementDaily.IX_PricingEntry	344290	btree	Y	Y			16	44	2026-10-02T09:32:40.413349+00:00	never	USED	KEEP — primary key
db_ops.billing.SettlementDaily.IX_BillingSnapshot	344292	btree					0	44	never	never	UNUSED	review, then DROP
db_ops.billing.SettlementDaily.IX_OrdersLog	344293	btree					0	44	never	never	UNUSED	review, then DROP
db_ops.billing.SettlementHistory.IX_AssetHeader	344344	btree	Y	Y			988	450	2026-10-02T13:23:11.861362+00:00	2026-10-02 13:06:25	USED	KEEP — primary key
db_ops.billing.SettlementHistory.UQ_WarehouseStaging	344346	btree	Y		Y		972	450	2026-10-02T13:23:11.861362+00:00	2026-10-02 13:06:25	USED	KEEP — constraint owns it
db_ops.billing.CampaignStaging.IX_SalesQueue	344417	btree	Y	Y			16	94	2026-10-02T09:32:40.413349+00:00	never	USED	KEEP — primary key
db_ops.billing.CampaignStaging.UQ_MeterSnapshot	344419	btree	Y		Y		0	94	never	never	UNUSED	KEEP — constraint owns it
db_ops.billing.SettlementEntry.IX_StaffingDetail	344385	btree	Y	Y			192	94	2026-10-02T13:05:44.34135+00:00	2026-10-02 13:06:25	USED	KEEP — primary key
db_ops.billing.SettlementEntry.IX_WarehouseEntry	344393	btree					1782	94	2026-10-02T13:23:11.861362+00:00	2026-10-02 13:06:25	USED	keep — in use
db_ops.billing.SettlementEntry.IX_BillingResult	344394	btree					0	94	never	2026-10-02 13:06:25	UNUSED	review, then DROP
db_ops.billing.SettlementEntry.UX_QuotaMonthly	344392	btree	Y			Y	4236	94	2026-10-02T13:23:11.763295+00:00	2026-10-02 13:06:25	USED	keep — in use
db_ops.billing.StaffingResult.IX_CatalogDaily	344316	btree	Y	Y			988	270	2026-10-02T13:23:11.861362+00:00	2026-10-02 13:23:26	USED	KEEP — primary key
db_ops.billing.StaffingResult.IX_InvoiceDetail	344318	btree	Y		Y		0	270	never	2026-10-02 13:23:26	UNUSED	KEEP — constraint owns it
db_ops.billing.StaffingResult.IX_OrdersQueue	344320	btree					0	270	never	2026-10-02 13:23:26	UNUSED	review, then DROP
db_ops.billing.WarehouseDetail.IX_PayrollResult	343701	btree					2387	468583	2026-10-02T16:58:55.910864+00:00	2026-10-02 08:05:20	USED	keep — in use
db_ops.billing.WarehouseDetail.IX_InvoiceHistory	343702	btree					67637	468583	2026-10-02T17:01:31.51078+00:00	2026-10-02 08:05:20	USED	keep — in use
db_ops.billing.WarehouseDetail.IX_SettlementDaily	343703	btree					0	468583	never	2026-10-02 08:05:20	UNUSED	review, then DROP
db_ops.billing.WarehouseDetail.IX_CampaignSummary	343704	btree					11	468583	2026-10-02T13:46:11.188558+00:00	2026-10-02 08:05:20	USED	keep — in use
db_ops.billing.WarehouseDetail.IX_StaffingDetail	343699	btree	Y	Y			14682978	468583	2026-10-02T17:01:39.383977+00:00	2026-10-02 08:05:20	USED	KEEP — primary key
db_ops.billing.WarehouseDetail.UX_SupplierLine	397615	btree	Y			Y	8	468583	2026-10-02T09:32:40.413349+00:00	2026-10-02 08:05:20	USED	keep — in use
db_ops.billing.TicketDetail.IX_BillingStaging	343710	btree					0	54522	never	2026-10-02 13:24:27	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_PayrollSnapshot	344101	btree					2354914	2381518	2026-10-02T17:01:40.891775+00:00	2026-10-02 03:22:43	USED	keep — in use
db_ops.billing.metric_results.IX_ReconcileStatus	344107	btree					0	2381518	never	2026-10-02 03:22:43	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_InvoiceMonthly	344106	btree					0	2381518	never	2026-10-02 03:22:43	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_StaffingDetail	344103	btree					800101	2381518	2026-10-02T17:01:40.853195+00:00	2026-10-02 03:22:43	USED	keep — in use
db_ops.billing.metric_results.IX_BillingStaging	344104	btree					69983	2381518	2026-10-02T16:27:26.697021+00:00	2026-10-02 03:22:43	USED	keep — in use
db_ops.billing.metric_results.IX_ShiftAudit	344105	btree					0	2381518	never	2026-10-02 03:22:43	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_WarehouseSummary	344102	btree					586579	2381518	2026-10-02T17:01:40.853195+00:00	2026-10-02 03:22:43	USED	keep — in use
db_ops.billing.metric_results.IX_BatchResult	344099	btree	Y	Y			4799	2381518	2026-10-02T17:00:04.38915+00:00	2026-10-02 03:22:43	USED	KEEP — primary key
db_ops.billing.ContractAudit.IX_OrdersAudit	344113	btree					0	0	never	never	COLD	review, then DROP
db_ops.billing.SupplierMonthly.IX_CampaignAudit	344084	btree	Y	Y			4778	4667	2026-10-02T17:00:04.19302+00:00	2026-10-02 04:59:13	USED	KEEP — primary key
db_ops.billing.SettlementStatus.IX_QuotaQueue	344043	btree					0	11730	never	2026-10-02 16:54:31	UNUSED	review, then DROP
db_ops.billing.SettlementStatus.IX_CatalogHistory	344041	btree	Y	Y			11730	11730	2026-10-02T17:00:09.309376+00:00	2026-10-02 16:54:31	USED	KEEP — primary key
db_ops.billing.TerritoryStaging.IX_RosterSnapshot	343963	btree					0	96	never	2026-09-30 09:39:47	UNUSED	review, then DROP
db_ops.billing.TerritoryStaging.IX_BookingHeader	343961	btree	Y	Y			96	96	2026-10-02T09:32:40.413349+00:00	2026-09-30 09:39:47	USED	KEEP — primary key
db_ops.billing.reports.IX_PayrollLog	870102	btree					0	13892	never	2026-10-02 09:33:21	UNUSED	review, then DROP
db_ops.billing.reports.IX_MeterResult	870100	btree					0	13892	never	2026-10-02 09:33:21	UNUSED	review, then DROP
db_ops.billing.reports.IX_BillingDetail	870101	btree					0	13892	never	2026-10-02 09:33:21	UNUSED	review, then DROP
db_ops.billing.reports.IX_MeterQueue	862264	btree	Y	Y			214	13892	2026-10-02T17:00:08.165595+00:00	2026-10-02 09:33:21	USED	KEEP — primary key
db_ops.billing.AssetAudit.IX_OrdersMonthly	343944	btree					0	7	never	never	UNUSED	review, then DROP
db_ops.billing.AssetAudit.IX_StaffingDetail	343942	btree	Y	Y			7	7	2026-10-02T13:43:09.843585+00:00	never	USED	KEEP — primary key
db_ops.billing.MeterDaily.IX_BookingStaging	343679	btree	Y	Y			40	40	2026-10-02T09:32:40.805729+00:00	never	USED	KEEP — primary key
db_ops.billing.ShiftHeader.IX_SettlementSummary	344210	btree					0	3871	never	2026-10-01 11:05:26	UNUSED	review, then DROP
db_ops.billing.ShiftHeader.IX_ContractSummary	344209	btree					163	3871	2026-10-02T16:22:08.229303+00:00	2026-10-01 11:05:26	USED	keep — in use
db_ops.billing.ShiftHeader.IX_ReconcileHistory	344211	btree					0	3871	never	2026-10-01 11:05:26	UNUSED	review, then DROP
db_ops.billing.ShiftHeader.IX_InvoiceHistory	344202	btree	Y	Y			16	3871	2026-10-02T09:32:40.413349+00:00	2026-10-01 11:05:26	USED	KEEP — primary key
db_ops.billing.RouteEntry.IX_CampaignLog	344164	btree					11	79	2026-09-28T02:22:52.190773+00:00	2026-10-02 06:55:16	USED	keep — in use
db_ops.billing.RouteEntry.IX_SupplierSummary	344165	btree					0	79	never	2026-10-02 06:55:16	UNUSED	review, then DROP
db_ops.billing.RouteEntry.IX_ReconcileArchive	344162	btree	Y	Y			4289	79	2026-10-02T16:22:08.229303+00:00	2026-10-02 06:55:16	USED	KEEP — primary key
db_ops.billing.ClaimQueue.IX_MeterMonthly	343743	btree					76031	127887	2026-10-02T17:01:04.94938+00:00	2026-10-02 06:46:17	USED	keep — in use
db_ops.billing.ClaimQueue.IX_ShiftSummary	343744	btree					0	127887	never	2026-10-02 06:46:17	UNUSED	review, then DROP
db_ops.billing.ClaimQueue.IX_RouteEntry	343745	btree					140460	127887	2026-10-02T17:01:40.13467+00:00	2026-10-02 06:46:17	USED	keep — in use
db_ops.billing.ClaimQueue.IX_PolicyHistory	343741	btree	Y	Y			7354911	127887	2026-10-02T17:01:40.365943+00:00	2026-10-02 06:46:17	USED	KEEP — primary key
db_ops.billing.ClaimQueue.UX_RouteArchive	397616	btree	Y			Y	10	127887	2026-10-02T09:32:40.413349+00:00	2026-10-02 06:46:17	USED	keep — in use
db_ops.billing.BatchLine.IX_TicketHeader	344140	btree					0	37002	never	2026-10-01 13:09:29	UNUSED	review, then DROP
db_ops.billing.BatchLine.IX_BookingSnapshot	344139	btree					0	37002	never	2026-10-01 13:09:29	UNUSED	review, then DROP
db_ops.billing.BatchLine.IX_TicketDaily	344136	btree	Y	Y			16	37002	2026-10-02T09:32:40.413349+00:00	2026-10-01 13:09:29	USED	KEEP — primary key
db_ops.billing.BatchLine.UX_LedgerQueue	344138	btree	Y				2331	37002	2026-10-02T17:00:05.461175+00:00	2026-10-01 13:09:29	USED	keep — in use
db_ops.billing.SupplierDaily.IX_BillingDaily	343919	btree					42724	48	2026-10-02T17:01:37.372659+00:00	never	USED	keep — in use
db_ops.billing.SupplierDaily.IX_SalesHistory	343917	btree	Y	Y			60	48	2026-10-02T14:02:05.169732+00:00	never	USED	KEEP — primary key
db_ops.billing.ReconcileArchive.IX_SettlementEntry	862238	btree					0	206	never	2026-10-02 09:33:20	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_CatalogArchive	862242	btree					0	206	never	2026-10-02 09:33:20	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_WarehouseMonthly	862240	btree					0	206	never	2026-10-02 09:33:20	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_ContractLine	862241	btree					3262	206	2026-10-02T17:01:37.244618+00:00	2026-10-02 09:33:20	USED	keep — in use
db_ops.billing.ReconcileArchive.IX_OrdersDaily	862237	btree					0	206	never	2026-10-02 09:33:20	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_CatalogSummary	862239	btree					0	206	never	2026-10-02 09:33:20	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_BookingStaging	862230	btree	Y		Y		548088	206	2026-10-02T17:01:37.183976+00:00	2026-10-02 09:33:20	USED	KEEP — constraint owns it
db_ops.billing.ReconcileArchive.IX_ClaimDetail	862228	btree	Y	Y			38	206	2026-10-02T14:01:57.109487+00:00	2026-10-02 09:33:20	USED	KEEP — primary key
db_ops.billing.RouteLog.IX_InvoiceLine	343822	btree					0	6	never	never	UNUSED	review, then DROP
db_ops.billing.RouteLog.IX_CustomerEntry	343821	btree					0	6	never	never	UNUSED	review, then DROP
db_ops.billing.RouteLog.IX_InvoiceHeader	343819	btree	Y	Y			18	6	2026-10-02T14:01:50.126813+00:00	never	USED	KEEP — primary key
db_ops.billing.PricingResult.IX_PolicyArchive	343765	btree					0	56	never	never	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_ForecastLog	343764	btree					0	56	never	never	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_MeterAudit	343766	btree					0	56	never	never	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_CampaignQueue	343762	btree	Y		Y		93	56	2026-10-02T14:01:50.591517+00:00	never	USED	KEEP — constraint owns it
db_ops.billing.PricingResult.IX_ContractLine	343760	btree	Y	Y			1139	56	2026-10-02T14:01:53.089677+00:00	never	USED	KEEP — primary key
db_ops.billing.RouteHeader.IX_StaffingEntry	343893	btree					9492	268822	2026-10-02T17:00:55.549315+00:00	2026-10-02 15:49:31	USED	keep — in use
db_ops.billing.RouteHeader.IX_CampaignSummary	343892	btree					51358	268822	2026-10-02T17:01:37.512726+00:00	2026-10-02 15:49:31	USED	keep — in use
db_ops.billing.RouteHeader.IX_LedgerEntry	343890	btree	Y	Y			232874	268822	2026-10-02T17:00:38.685254+00:00	2026-10-02 15:49:31	USED	KEEP — primary key
db_ops.billing.SupplierLog.IX_ContractResult	343865	btree					518	658	2026-10-02T14:01:53.742624+00:00	2026-10-02 09:38:20	USED	keep — in use
db_ops.billing.SupplierLog.IX_ForecastLog	343864	btree					272	658	2026-10-02T14:01:53.64974+00:00	2026-10-02 09:38:20	USED	keep — in use
db_ops.billing.SupplierLog.IX_OrdersDaily	343855	btree	Y	Y			16	658	2026-10-02T09:32:40.413349+00:00	2026-10-02 09:38:20	USED	KEEP — primary key
db_ops.billing.SupplierLog.IX_ForecastMonthly	343857	btree	Y		Y		0	658	never	2026-10-02 09:38:20	UNUSED	KEEP — constraint owns it
db_ops.billing.LedgerArchive.IX_SalesSnapshot	870103	btree					0	0	never	never	COLD	review, then DROP
db_ops.billing.LedgerArchive.IX_ShipmentEntry	344522	btree					0	0	never	never	COLD	review, then DROP
db_ops.billing.LedgerArchive.IX_PricingStaging	344523	btree					0	0	never	never	COLD	review, then DROP
db_ops.billing.LedgerArchive.IX_ShiftStaging	344515	btree	Y	Y			16	0	2026-10-02T09:32:40.413349+00:00	never	USED	KEEP — primary key
db_ops.billing.PolicyLine.IX_CustomerDetail	344495	btree					0	0	never	never	COLD	review, then DROP
db_ops.billing.PolicyLine.IX_OrdersDaily	344494	btree					0	0	never	never	COLD	review, then DROP
db_ops.billing.PolicyLine.UQ_SupplierResult	344487	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
db_ops.billing.PolicyLine.IX_BatchResult	344485	btree	Y	Y			16	0	2026-10-02T09:32:40.413349+00:00	never	USED	KEEP — primary key
db_ops.billing.ShipmentMonthly.UX_ClaimSummary	344461	btree	Y			Y	14	0	2026-10-02T15:07:19.270719+00:00	never	USED	keep — in use
db_ops.billing.ShipmentMonthly.IX_CampaignMonthly	344459	btree	Y	Y			16	0	2026-10-02T09:32:40.413349+00:00	never	USED	KEEP — primary key