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 2ACME-192-0-2-120 ACME-198-51-100-125PostgreSQL 1ACME-192-0-2-15-PG-5433

Host: 192.0.2.15

Collected: 2026-10-11T18:00:44Z

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

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

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

By database

Database	Total	Cold	Disabled	Droppable	Recommend action
db_ops	288	101	0	121	review the drop candidates above
drs	175	76	0	32	review the drop candidates above

Drop candidates (153)

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_WarehouseSummary	17564994	never	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_InvoiceMonthly	17564994	never	UNUSED	review, then DROP
db_ops.db_ops.ContractAudit.IX_OrdersAudit	5323320	never	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_ReconcileStatus	4804692	never	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_InvoiceMonthly	4804692	never	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_ShiftAudit	4804692	never	UNUSED	review, then DROP
db_ops.db_ops.TicketDetail.IX_BillingStaging	700508	never	UNUSED	review, then DROP
db_ops.db_ops.BatchLine.IX_TicketHeader	357994	never	UNUSED	review, then DROP
db_ops.db_ops.BatchLine.IX_BookingSnapshot	357994	never	UNUSED	review, then DROP
db_ops.billing.TicketDetail.IX_BillingStaging	308224	never	UNUSED	review, then DROP
db_ops.billing.ClaimQueue.IX_ShiftSummary	160088	never	UNUSED	review, then DROP
db_ops.db_ops.SettlementStatus.IX_QuotaQueue	129290	never	UNUSED	review, then DROP
db_ops.db_ops.ShiftHeader.IX_ReconcileHistory	121545	never	UNUSED	review, then DROP
db_ops.db_ops.ShiftHeader.IX_SettlementSummary	121545	never	UNUSED	review, then DROP
db_ops.billing.BatchLine.IX_TicketHeader	86949	never	UNUSED	review, then DROP
db_ops.billing.BatchLine.IX_BookingSnapshot	86949	never	UNUSED	review, then DROP
db_ops.billing.SettlementStatus.IX_QuotaQueue	48695	never	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_PayrollLog	31966	never	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_MeterResult	31966	never	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_BillingDetail	31966	never	UNUSED	review, then DROP
db_ops.billing.reports.IX_BillingDetail	20204	never	UNUSED	review, then DROP
db_ops.billing.ShiftHeader.IX_SettlementSummary	7497	never	UNUSED	review, then DROP
db_ops.billing.ShiftHeader.IX_ReconcileHistory	7497	never	UNUSED	review, then DROP
db_ops.db_ops.SettlementDaily.IX_BillingSnapshot	390	never	UNUSED	review, then DROP
db_ops.db_ops.RouteEntry.IX_CampaignLog	361	never	UNUSED	review, then DROP
db_ops.db_ops.RouteEntry.IX_SupplierSummary	361	never	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_CatalogArchive	336	never	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_WarehouseMonthly	336	never	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_OrdersDaily	336	never	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_CatalogSummary	336	never	UNUSED	review, then DROP
drs.drs.InvoiceHistory.IX_AssetHeader	288	never	UNUSED	review, then DROP
db_ops.db_ops.SettlementEntry.IX_BillingResult	284	never	UNUSED	review, then DROP
db_ops.billing.StaffingResult.IX_OrdersQueue	270	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogArchive	247	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_SettlementEntry	247	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_WarehouseMonthly	247	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_OrdersDaily	247	never	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogSummary	247	never	UNUSED	review, then DROP
db_ops.db_ops.StaffingResult.IX_OrdersQueue	202	never	UNUSED	review, then DROP
db_ops.billing.RouteEntry.IX_SupplierSummary	153	never	UNUSED	review, then DROP
drs.drs.AssetQueue.IX_ReconcileLog	117	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_PolicyArchive	114	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_ForecastLog	114	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_MeterAudit	114	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.PricingResult.IX_PolicyArchive	86	never	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_ForecastLog	86	never	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_MeterAudit	86	never	UNUSED	review, then DROP
db_ops.db_ops.PolicyLine.IX_CustomerDetail	72	never	UNUSED	review, then DROP
db_ops.db_ops.PolicyLine.IX_OrdersDaily	72	never	UNUSED	review, then DROP
db_ops.billing.SettlementDaily.IX_BillingSnapshot	49	never	UNUSED	review, then DROP
db_ops.billing.SettlementDaily.IX_OrdersLog	49	never	UNUSED	review, then DROP
db_ops.billing.PolicyLine.IX_CustomerDetail	33	never	UNUSED	review, then DROP
drs.drs.SettlementHeader.IX_SettlementStaging	31	never	UNUSED	review, then DROP
drs.dbo.MeterDetail.IX_TerritoryResult	25	never	UNUSED	review, then DROP
db_ops.billing.RouteLog.IX_InvoiceLine	9	never	UNUSED	review, then DROP
db_ops.billing.RouteLog.IX_CustomerEntry	9	never	UNUSED	review, then DROP
drs.drs.MeterResult.IX_TicketSummary	8	never	UNUSED	review, then DROP
drs.drs.MeterResult.IX_PricingDaily	8	never	UNUSED	review, then DROP
db_ops.billing.LedgerArchive.IX_ShipmentEntry	4	never	UNUSED	review, then DROP
db_ops.billing.LedgerArchive.IX_PricingStaging	4	never	UNUSED	review, then DROP
db_ops.db_ops.LedgerArchive.IX_SalesSnapshot	3	never	UNUSED	review, then DROP
db_ops.db_ops.LedgerArchive.IX_ShipmentEntry	3	never	UNUSED	review, then DROP
db_ops.db_ops.LedgerArchive.IX_PricingStaging	3	never	UNUSED	review, then DROP
drs.dbo.PolicyResult.IX_BatchSnapshot	2	never	UNUSED	review, then DROP
drs.dbo.PolicyResult.IX_ClaimHistory	2	never	UNUSED	review, then DROP
drs.dbo.query.IX_ShipmentDetail	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.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.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.PricingResult.IX_PolicyArchive	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.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.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_WarehouseSummary	0	never	COLD	review, then DROP
db_ops.report.ContractAudit.IX_OrdersAudit	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.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.PricingResult.IX_ForecastLog	0	never	COLD	review, then DROP
db_ops.report.PricingResult.IX_MeterAudit	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.report.metric_results.IX_ShiftAudit	0	never	COLD	review, then DROP
db_ops.report.RouteLog.IX_CustomerEntry	0	never	COLD	review, then DROP
db_ops.report.RouteLog.IX_InvoiceLine	0	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_CatalogSummary	0	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_OrdersDaily	0	never	COLD	review, then DROP
db_ops.report.ReconcileArchive.IX_ContractLine	0	never	COLD	review, then DROP
db_ops.report.ClaimQueue.IX_MeterMonthly	0	never	COLD	review, then DROP
db_ops.report.ShiftHeader.IX_ContractSummary	0	never	COLD	review, then DROP
db_ops.report.ShiftHeader.IX_SettlementSummary	0	never	COLD	review, then DROP
drs.dbo.tasks.IX_ShiftEntry	0	never	COLD	review, then DROP
drs.dbo.tasks.IX_ShiftLine	0	never	COLD	review, then DROP
drs.dbo.tasks.IX_QuotaHeader	0	never	COLD	review, then DROP
drs.dbo.tasks.IX_ForecastResult	0	never	COLD	review, then DROP
drs.dbo.tasks.IX_InvoiceMonthly	0	never	COLD	review, then DROP
drs.dbo.tasks.IX_OrdersStaging	0	never	COLD	review, then DROP
drs.dbo.tasks.IX_CatalogLog	0	never	COLD	review, then DROP
drs.dbo.PolicyAudit.IX_RosterResult	0	never	COLD	review, then DROP
drs.dbo.PolicyAudit.IX_StaffingMonthly	0	never	COLD	review, then DROP
drs.dbo.RouteStatus.IX_LedgerEntry	0	never	COLD	review, then DROP
drs.dbo.RouteStatus.IX_CustomerMonthly	0	never	COLD	review, then DROP
drs.dbo.InvoiceStaging.IX_SalesArchive	0	never	COLD	review, then DROP
drs.dbo.ClaimSummary.IX_LedgerStatus	0	never	COLD	review, then DROP
drs.dbo.SalesStaging.IX_StaffingLog	0	never	COLD	review, then DROP
drs.dbo.query.IX_ContractStaging	0	never	COLD	review, then DROP
drs.dbo.query.IX_ContractArchive	0	never	COLD	review, then DROP
drs.dbo.BookingSnapshot.IX_MeterStaging	0	never	COLD	review, then DROP
drs.dbo.BookingSnapshot.IX_AssetLog	0	never	COLD	review, then DROP
drs.dbo.TerritorySummary.IX_PayrollArchive	0	never	COLD	review, then DROP
drs.dbo.StaffingResult.IX_RosterResult	0	never	COLD	review, then DROP
drs.dbo.StaffingResult.IX_SupplierQueue	0	never	COLD	review, then DROP
drs.dbo.ReconcileDaily.IX_PricingSnapshot	0	never	COLD	review, then DROP
drs.dbo.SettlementStaging.IX_RouteStatus	0	never	COLD	review, then DROP

All indexes (463)

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			196	390	2026-10-10T23:08:17.074839+00:00	2026-10-08 23:07:45	USED	KEEP — primary key
db_ops.db_ops.SettlementDaily.IX_BillingSnapshot	49336	btree					0	390	never	2026-10-08 23:07:45	UNUSED	review, then DROP
db_ops.db_ops.SettlementDaily.IX_OrdersLog	49343	btree					2	390	2026-10-06T01:51:22.481332+00:00	2026-10-08 23:07:45	USED	keep — in use
db_ops.db_ops.SettlementHistory.IX_AssetHeader	49383	btree	Y	Y			860	341	2026-10-10T04:05:08.116891+00:00	2026-10-09 06:13:51	USED	KEEP — primary key
db_ops.db_ops.SettlementHistory.UQ_WarehouseStaging	49390	btree	Y		Y		860	341	2026-10-10T04:05:08.116891+00:00	2026-10-09 06:13:51	USED	KEEP — constraint owns it
db_ops.db_ops.CampaignStaging.IX_SalesQueue	49271	btree	Y	Y			0	284	never	2026-10-05 06:47:32	UNUSED	KEEP — primary key
db_ops.db_ops.CampaignStaging.UQ_MeterSnapshot	49273	btree	Y		Y		70	284	2026-10-05T04:14:19.368666+00:00	2026-10-05 06:47:32	USED	KEEP — constraint owns it
db_ops.db_ops.SettlementEntry.IX_StaffingDetail	49299	btree	Y	Y			556	284	2026-10-10T04:05:04.885165+00:00	2026-10-05 06:47:32	USED	KEEP — primary key
db_ops.db_ops.SettlementEntry.IX_WarehouseEntry	49315	btree					1217	284	2026-10-10T04:05:08.116891+00:00	2026-10-05 06:47:32	USED	keep — in use
db_ops.db_ops.SettlementEntry.IX_BillingResult	49316	btree					0	284	never	2026-10-05 06:47:32	UNUSED	review, then DROP
db_ops.db_ops.SettlementEntry.UX_QuotaMonthly	49317	btree	Y			Y	4095	284	2026-10-10T04:05:07.922397+00:00	2026-10-05 06:47:32	USED	keep — in use
db_ops.db_ops.StaffingResult.IX_CatalogDaily	49374	btree	Y	Y			860	202	2026-10-10T04:05:08.116891+00:00	2026-10-08 06:30:30	USED	KEEP — primary key
db_ops.db_ops.StaffingResult.IX_InvoiceDetail	49376	btree	Y		Y		0	202	never	2026-10-08 06:30:30	UNUSED	KEEP — constraint owns it
db_ops.db_ops.StaffingResult.IX_OrdersQueue	49320	btree					0	202	never	2026-10-08 06:30:30	UNUSED	review, then DROP
db_ops.db_ops.WarehouseDetail.IX_PayrollResult	46502	btree					4636	3127047	2026-10-11T17:58:28.050949+00:00	2026-10-11 15:57:58	USED	keep — in use
db_ops.db_ops.WarehouseDetail.IX_InvoiceHistory	46505	btree					2915211	3127047	2026-10-11T18:00:44.136781+00:00	2026-10-11 15:57:58	USED	keep — in use
db_ops.db_ops.WarehouseDetail.IX_SettlementDaily	46507	btree					14829	3127047	2026-10-11T17:58:28.050949+00:00	2026-10-11 15:57:58	USED	keep — in use
db_ops.db_ops.WarehouseDetail.IX_CampaignSummary	46509	btree					1	3127047	2026-10-05T02:21:05.388017+00:00	2026-10-11 15:57:58	USED	keep — in use
db_ops.db_ops.WarehouseDetail.IX_StaffingDetail	46514	btree	Y	Y			47866113	3127047	2026-10-11T18:00:44.888285+00:00	2026-10-11 15:57:58	USED	KEEP — primary key
db_ops.db_ops.WarehouseDetail.UX_SupplierLine	473550	btree	Y			Y	0	3127047	never	2026-10-11 15:57:58	UNUSED	review carefully — unique
db_ops.db_ops.TicketDetail.IX_BillingStaging	46498	btree					0	700508	never	2026-10-08 17:48:49	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_PayrollSnapshot	49487	btree					133066	17564994	2026-10-11T18:00:40.18033+00:00	2026-10-10 16:34:33	USED	keep — in use
db_ops.db_ops.metric_results.IX_ReconcileStatus	49486	btree					372	17564994	2026-10-11T00:14:34.935854+00:00	2026-10-10 16:34:33	USED	keep — in use
db_ops.db_ops.metric_results.IX_InvoiceMonthly	49484	btree					0	17564994	never	2026-10-10 16:34:33	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_StaffingDetail	49485	btree					18	17564994	2026-10-09T06:29:14.138574+00:00	2026-10-10 16:34:33	USED	keep — in use
db_ops.db_ops.metric_results.IX_BillingStaging	49488	btree					1311377	17564994	2026-10-11T17:51:35.460051+00:00	2026-10-10 16:34:33	USED	keep — in use
db_ops.db_ops.metric_results.IX_ShiftAudit	49489	btree					4	17564994	2026-10-05T06:26:59.677815+00:00	2026-10-10 16:34:33	USED	keep — in use
db_ops.db_ops.metric_results.IX_WarehouseSummary	49490	btree					0	17564994	never	2026-10-10 16:34:33	UNUSED	review, then DROP
db_ops.db_ops.metric_results.IX_SalesDetail	49491	btree					32483671	17564994	2026-10-11T18:00:44.892449+00:00	2026-10-10 16:34:33	USED	keep — in use
db_ops.db_ops.metric_results.IX_BatchResult	49492	btree	Y	Y			24973	17564994	2026-10-11T18:00:40.958719+00:00	2026-10-10 16:34:33	USED	KEEP — primary key
db_ops.db_ops.ContractAudit.IX_OrdersAudit	47914	btree					0	5323320	never	2026-10-11 02:20:48	UNUSED	review, then DROP
db_ops.db_ops.SupplierMonthly.IX_CampaignAudit	49239	btree	Y	Y			42777	46792	2026-10-11T18:00:40.34433+00:00	2026-10-10 13:57:30	USED	KEEP — primary key
db_ops.db_ops.SettlementStatus.IX_QuotaQueue	49416	btree					0	129290	never	2026-10-11 17:58:57	UNUSED	review, then DROP
db_ops.db_ops.SettlementStatus.IX_CatalogHistory	49420	btree	Y	Y			129290	129290	2026-10-11T18:00:39.744341+00:00	2026-10-11 17:58:57	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	31966	never	2026-10-09 04:40:52	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_MeterResult	505332	btree					0	31966	never	2026-10-09 04:40:52	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_BillingDetail	505333	btree					0	31966	never	2026-10-09 04:40:52	UNUSED	review, then DROP
db_ops.db_ops.reports.IX_MeterQueue	473606	btree	Y	Y			21171	31966	2026-10-11T17:57:59.024872+00:00	2026-10-09 04:40:52	USED	KEEP — primary key
db_ops.db_ops.AssetAudit.IX_OrdersMonthly	285096	btree					1	13	2026-10-05T05:37:17.681809+00:00	never	USED	keep — in use
db_ops.db_ops.AssetAudit.IX_StaffingDetail	285094	btree	Y	Y			13	13	2026-10-09T06:13:39.920472+00:00	never	USED	KEEP — primary key
db_ops.db_ops.MeterDaily.IX_BookingStaging	49443	btree	Y	Y			1	1	2026-10-05T02:32:22.611244+00:00	never	USED	KEEP — primary key
db_ops.db_ops.ShiftHeader.IX_SettlementSummary	46624	btree					0	121545	never	2026-10-09 09:46:59	UNUSED	review, then DROP
db_ops.db_ops.ShiftHeader.IX_ContractSummary	46626	btree					722	121545	2026-10-11T17:19:23.612441+00:00	2026-10-09 09:46:59	USED	keep — in use
db_ops.db_ops.ShiftHeader.IX_ReconcileHistory	46627	btree					0	121545	never	2026-10-09 09:46:59	UNUSED	review, then DROP
db_ops.db_ops.ShiftHeader.IX_InvoiceHistory	46631	btree	Y	Y			0	121545	never	2026-10-09 09:46:59	UNUSED	KEEP — primary key
db_ops.db_ops.RouteEntry.IX_CampaignLog	49357	btree					0	361	never	2026-10-05 09:33:35	UNUSED	review, then DROP
db_ops.db_ops.RouteEntry.IX_SupplierSummary	49358	btree					0	361	never	2026-10-05 09:33:35	UNUSED	review, then DROP
db_ops.db_ops.RouteEntry.IX_ReconcileArchive	49362	btree	Y	Y			123350	361	2026-10-11T17:19:23.612441+00:00	2026-10-05 09:33:35	USED	KEEP — primary key
db_ops.db_ops.ClaimQueue.IX_MeterMonthly	35408	btree					87452	516052	2026-10-11T18:00:35.433631+00:00	2026-10-11 07:45:47	USED	keep — in use
db_ops.db_ops.ClaimQueue.IX_ShiftSummary	35410	btree					2	516052	2026-09-30T08:29:42.448423+00:00	2026-10-11 07:45:47	USED	keep — in use
db_ops.db_ops.ClaimQueue.IX_RouteEntry	35411	btree					422486	516052	2026-10-11T18:00:42.723173+00:00	2026-10-11 07:45:47	USED	keep — in use
db_ops.db_ops.ClaimQueue.IX_PolicyHistory	35412	btree	Y	Y			33027652	516052	2026-10-11T18:00:43.959785+00:00	2026-10-11 07:45:47	USED	KEEP — primary key
db_ops.db_ops.ClaimQueue.UX_RouteArchive	473551	btree	Y			Y	1	516052	2026-09-30T08:29:42.448423+00:00	2026-10-11 07:45:47	USED	keep — in use
db_ops.db_ops.BatchLine.IX_TicketHeader	46623	btree					0	357994	never	2026-10-11 05:16:45	UNUSED	review, then DROP
db_ops.db_ops.BatchLine.IX_BookingSnapshot	46630	btree					0	357994	never	2026-10-11 05:16:45	UNUSED	review, then DROP
db_ops.db_ops.BatchLine.IX_TicketDaily	46633	btree	Y	Y			0	357994	never	2026-10-11 05:16:45	UNUSED	KEEP — primary key
db_ops.db_ops.BatchLine.UX_LedgerQueue	46721	btree	Y				23380	357994	2026-10-11T18:00:15.833403+00:00	2026-10-11 05:16:45	USED	keep — in use
db_ops.db_ops.SupplierDaily.IX_BillingDaily	49356	btree					286261	14	2026-10-11T18:00:44.245733+00:00	never	USED	keep — in use
db_ops.db_ops.SupplierDaily.IX_SalesHistory	49359	btree	Y	Y			7	14	2026-10-10T04:03:28.175294+00:00	never	USED	KEEP — primary key
db_ops.db_ops.ReconcileArchive.IX_SettlementEntry	473580	btree					0	247	never	2026-10-09 06:11:51	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogArchive	473584	btree					0	247	never	2026-10-09 06:11:51	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_WarehouseMonthly	473582	btree					0	247	never	2026-10-09 06:11:51	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_ContractLine	473583	btree					286311	247	2026-10-11T18:00:43.932576+00:00	2026-10-09 06:11:51	USED	keep — in use
db_ops.db_ops.ReconcileArchive.IX_OrdersDaily	473579	btree					0	247	never	2026-10-09 06:11:51	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_CatalogSummary	473581	btree					0	247	never	2026-10-09 06:11:51	UNUSED	review, then DROP
db_ops.db_ops.ReconcileArchive.IX_LedgerEntry	473572	btree	Y		Y		169669307	247	2026-10-11T18:00:43.791617+00:00	2026-10-09 06:11:51	USED	KEEP — constraint owns it
db_ops.db_ops.ReconcileArchive.IX_ShipmentAudit	473570	btree	Y	Y			197	247	2026-10-10T08:09:31.658636+00:00	2026-10-09 06:11:51	USED	KEEP — primary key
db_ops.db_ops.RouteLog.IX_InvoiceLine	47988	btree					61	182	2026-10-10T04:02:57.001339+00:00	2026-10-10 04:03:20	USED	keep — in use
db_ops.db_ops.RouteLog.IX_CustomerEntry	47995	btree					286261	182	2026-10-11T18:00:44.097965+00:00	2026-10-10 04:03:20	USED	keep — in use
db_ops.db_ops.RouteLog.IX_InvoiceHeader	47998	btree	Y	Y			1665	182	2026-10-10T04:03:16.518794+00:00	2026-10-10 04:03:20	USED	KEEP — primary key
db_ops.db_ops.PricingResult.IX_PolicyArchive	49297	btree					0	114	never	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_ForecastLog	49318	btree					0	114	never	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_MeterAudit	49319	btree					0	114	never	never	UNUSED	review, then DROP
db_ops.db_ops.PricingResult.IX_CampaignQueue	49321	btree	Y		Y		337	114	2026-10-10T08:09:27.617291+00:00	never	USED	KEEP — constraint owns it
db_ops.db_ops.PricingResult.IX_ContractLine	49326	btree	Y	Y			50	114	2026-10-10T08:09:27.710259+00:00	never	USED	KEEP — primary key
db_ops.db_ops.RouteHeader.IX_StaffingEntry	49237	btree					44350	48003	2026-10-11T17:59:56.627843+00:00	2026-10-09 19:00:14	USED	keep — in use
db_ops.db_ops.RouteHeader.IX_CampaignSummary	49238	btree					413766	48003	2026-10-11T18:00:44.436614+00:00	2026-10-09 19:00:14	USED	keep — in use
db_ops.db_ops.RouteHeader.IX_LedgerEntry	49261	btree	Y	Y			59354	48003	2026-10-11T18:00:22.840906+00:00	2026-10-09 19:00:14	USED	KEEP — primary key
db_ops.db_ops.SupplierLog.IX_ContractResult	314329	btree					81	120	2026-10-10T04:03:12.777519+00:00	2026-10-06 05:42:20	USED	keep — in use
db_ops.db_ops.SupplierLog.IX_ForecastLog	314328	btree					61	120	2026-10-10T04:02:56.952338+00:00	2026-10-06 05:42:20	USED	keep — in use
db_ops.db_ops.SupplierLog.IX_OrdersDaily	314319	btree	Y	Y			0	120	never	2026-10-06 05:42:20	UNUSED	KEEP — primary key
db_ops.db_ops.SupplierLog.IX_ForecastMonthly	314321	btree	Y		Y		0	120	never	2026-10-06 05:42:20	UNUSED	KEEP — constraint owns it
db_ops.db_ops.LedgerArchive.IX_SalesSnapshot	999876	btree					0	3	never	never	UNUSED	review, then DROP
db_ops.db_ops.LedgerArchive.IX_ShipmentEntry	49401	btree					0	3	never	never	UNUSED	review, then DROP
db_ops.db_ops.LedgerArchive.IX_PricingStaging	49402	btree					0	3	never	never	UNUSED	review, then DROP
db_ops.db_ops.LedgerArchive.IX_ShiftStaging	49408	btree	Y	Y			0	3	never	never	UNUSED	KEEP — primary key
db_ops.db_ops.PolicyLine.IX_CustomerDetail	49361	btree					0	72	never	2026-10-08 09:12:33	UNUSED	review, then DROP
db_ops.db_ops.PolicyLine.IX_OrdersDaily	49364	btree					0	72	never	2026-10-08 09:12:33	UNUSED	review, then DROP
db_ops.db_ops.PolicyLine.UQ_SupplierResult	49370	btree	Y		Y		0	72	never	2026-10-08 09:12:33	UNUSED	KEEP — constraint owns it
db_ops.db_ops.PolicyLine.IX_BatchResult	49372	btree	Y	Y			0	72	never	2026-10-08 09:12:33	UNUSED	KEEP — primary key
db_ops.db_ops.ShipmentMonthly.UX_ClaimSummary	49427	btree	Y			Y	0	4	never	never	UNUSED	review carefully — unique
db_ops.db_ops.ShipmentMonthly.IX_CampaignMonthly	49428	btree	Y	Y			0	4	never	never	UNUSED	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					526651	0	2026-10-07T10:30:07.048329+00:00	never	USED	keep — in use
db_ops.billing.PricingSummary.UX_SupplierResult	344550	btree	Y			Y	263327	0	2026-10-07T10:30:06.713807+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			17	49	2026-10-05T00:36:09.464027+00:00	never	USED	KEEP — primary key
db_ops.billing.SettlementDaily.IX_BillingSnapshot	344292	btree					0	49	never	never	UNUSED	review, then DROP
db_ops.billing.SettlementDaily.IX_OrdersLog	344293	btree					0	49	never	never	UNUSED	review, then DROP
db_ops.billing.SettlementHistory.IX_AssetHeader	344344	btree	Y	Y			1128	450	2026-10-05T00:44:01.688016+00:00	2026-10-02 13:06:25	USED	KEEP — primary key
db_ops.billing.SettlementHistory.UQ_WarehouseStaging	344346	btree	Y		Y		1112	450	2026-10-05T00:44:01.688016+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					2057	94	2026-10-05T00:44:01.688016+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	4238	94	2026-10-03T07:14:29.900178+00:00	2026-10-02 13:06:25	USED	keep — in use
db_ops.billing.StaffingResult.IX_CatalogDaily	344316	btree	Y	Y			1128	270	2026-10-05T00:44:01.688016+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					3404	1133774	2026-10-07T09:16:04.736884+00:00	2026-10-07 03:42:09	USED	keep — in use
db_ops.billing.WarehouseDetail.IX_InvoiceHistory	343702	btree					137287	1133774	2026-10-07T10:30:05.575616+00:00	2026-10-07 03:42:09	USED	keep — in use
db_ops.billing.WarehouseDetail.IX_SettlementDaily	343703	btree					324	1133774	2026-10-07T10:26:15.408689+00:00	2026-10-07 03:42:09	USED	keep — in use
db_ops.billing.WarehouseDetail.IX_CampaignSummary	343704	btree					3622	1133774	2026-10-05T06:41:17.77537+00:00	2026-10-07 03:42:09	USED	keep — in use
db_ops.billing.WarehouseDetail.IX_StaffingDetail	343699	btree	Y	Y			28342199	1133774	2026-10-07T10:30:06.173624+00:00	2026-10-07 03:42:09	USED	KEEP — primary key
db_ops.billing.WarehouseDetail.UX_SupplierLine	397615	btree	Y			Y	8	1133774	2026-10-02T09:32:40.413349+00:00	2026-10-07 03:42:09	USED	keep — in use
db_ops.billing.TicketDetail.IX_BillingStaging	343710	btree					0	308224	never	2026-10-07 01:07:27	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_PayrollSnapshot	344101	btree					5732526	4804692	2026-10-08T07:58:34.029228+00:00	2026-10-07 09:26:16	USED	keep — in use
db_ops.billing.metric_results.IX_ReconcileStatus	344107	btree					0	4804692	never	2026-10-07 09:26:16	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_InvoiceMonthly	344106	btree					0	4804692	never	2026-10-07 09:26:16	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_StaffingDetail	344103	btree					1715919	4804692	2026-10-08T07:54:13.537988+00:00	2026-10-07 09:26:16	USED	keep — in use
db_ops.billing.metric_results.IX_BillingStaging	344104	btree					150882	4804692	2026-10-07T10:06:12.078397+00:00	2026-10-07 09:26:16	USED	keep — in use
db_ops.billing.metric_results.IX_ShiftAudit	344105	btree					0	4804692	never	2026-10-07 09:26:16	UNUSED	review, then DROP
db_ops.billing.metric_results.IX_WarehouseSummary	344102	btree					1327965	4804692	2026-10-07T10:30:07.189278+00:00	2026-10-07 09:26:16	USED	keep — in use
db_ops.billing.metric_results.IX_BatchResult	344099	btree	Y	Y			9664	4804692	2026-10-07T10:29:45.66829+00:00	2026-10-07 09:26:16	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			11461	11026	2026-10-07T10:29:45.239591+00:00	2026-10-07 07:33:11	USED	KEEP — primary key
db_ops.billing.SettlementStatus.IX_QuotaQueue	344043	btree					0	48695	never	2026-10-07 10:28:13	UNUSED	review, then DROP
db_ops.billing.SettlementStatus.IX_CatalogHistory	344041	btree	Y	Y			48695	48695	2026-10-07T10:30:03.52944+00:00	2026-10-07 10:28:13	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					2	20204	2026-10-05T01:36:10.644019+00:00	2026-10-07 05:47:10	USED	keep — in use
db_ops.billing.reports.IX_MeterResult	870100	btree					16	20204	2026-10-05T01:35:47.434049+00:00	2026-10-07 05:47:10	USED	keep — in use
db_ops.billing.reports.IX_BillingDetail	870101	btree					0	20204	never	2026-10-07 05:47:10	UNUSED	review, then DROP
db_ops.billing.reports.IX_MeterQueue	862264	btree	Y	Y			5386	20204	2026-10-07T10:29:54.033753+00:00	2026-10-07 05:47:10	USED	KEEP — primary key
db_ops.billing.AssetAudit.IX_OrdersMonthly	343944	btree					2	14	2026-10-05T01:35:47.434049+00:00	never	USED	keep — in use
db_ops.billing.AssetAudit.IX_StaffingDetail	343942	btree	Y	Y			14	14	2026-10-07T01:19:12.995986+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	7497	never	2026-10-04 11:34:03	UNUSED	review, then DROP
db_ops.billing.ShiftHeader.IX_ContractSummary	344209	btree					313	7497	2026-10-07T10:02:01.741784+00:00	2026-10-04 11:34:03	USED	keep — in use
db_ops.billing.ShiftHeader.IX_ReconcileHistory	344211	btree					0	7497	never	2026-10-04 11:34:03	UNUSED	review, then DROP
db_ops.billing.ShiftHeader.IX_InvoiceHistory	344202	btree	Y	Y			16	7497	2026-10-02T09:32:40.413349+00:00	2026-10-04 11:34:03	USED	KEEP — primary key
db_ops.billing.RouteEntry.IX_CampaignLog	344164	btree					20	153	2026-10-05T01:36:10.230701+00:00	2026-10-02 06:55:16	USED	keep — in use
db_ops.billing.RouteEntry.IX_SupplierSummary	344165	btree					0	153	never	2026-10-02 06:55:16	UNUSED	review, then DROP
db_ops.billing.RouteEntry.IX_ReconcileArchive	344162	btree	Y	Y			8289	153	2026-10-07T10:02:01.741784+00:00	2026-10-02 06:55:16	USED	KEEP — primary key
db_ops.billing.ClaimQueue.IX_MeterMonthly	343743	btree					93201	160088	2026-10-07T10:29:54.948136+00:00	2026-10-07 04:51:10	USED	keep — in use
db_ops.billing.ClaimQueue.IX_ShiftSummary	343744	btree					0	160088	never	2026-10-07 04:51:10	UNUSED	review, then DROP
db_ops.billing.ClaimQueue.IX_RouteEntry	343745	btree					258826	160088	2026-10-07T10:30:04.811837+00:00	2026-10-07 04:51:10	USED	keep — in use
db_ops.billing.ClaimQueue.IX_PolicyHistory	343741	btree	Y	Y			15950749	160088	2026-10-07T10:30:07.497123+00:00	2026-10-07 04:51:10	USED	KEEP — primary key
db_ops.billing.ClaimQueue.UX_RouteArchive	397616	btree	Y			Y	10	160088	2026-10-02T09:32:40.413349+00:00	2026-10-07 04:51:10	USED	keep — in use
db_ops.billing.BatchLine.IX_TicketHeader	344140	btree					0	86949	never	2026-10-04 23:02:23	UNUSED	review, then DROP
db_ops.billing.BatchLine.IX_BookingSnapshot	344139	btree					0	86949	never	2026-10-04 23:02:23	UNUSED	review, then DROP
db_ops.billing.BatchLine.IX_TicketDaily	344136	btree	Y	Y			16	86949	2026-10-02T09:32:40.413349+00:00	2026-10-04 23:02:23	USED	KEEP — primary key
db_ops.billing.BatchLine.UX_LedgerQueue	344138	btree	Y				5507	86949	2026-10-07T10:29:27.257076+00:00	2026-10-04 23:02:23	USED	keep — in use
db_ops.billing.SupplierDaily.IX_BillingDaily	343919	btree					101101	68	2026-10-07T10:30:03.779494+00:00	2026-10-06 07:26:53	USED	keep — in use
db_ops.billing.SupplierDaily.IX_SalesHistory	343917	btree	Y	Y			70	68	2026-10-06T07:32:09.384734+00:00	2026-10-06 07:26:53	USED	KEEP — primary key
db_ops.billing.ReconcileArchive.IX_SettlementEntry	862238	btree					17	336	2026-10-06T07:32:09.737687+00:00	2026-10-06 07:27:53	USED	keep — in use
db_ops.billing.ReconcileArchive.IX_CatalogArchive	862242	btree					0	336	never	2026-10-06 07:27:53	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_WarehouseMonthly	862240	btree					0	336	never	2026-10-06 07:27:53	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_ContractLine	862241	btree					61669	336	2026-10-07T10:30:03.656516+00:00	2026-10-06 07:27:53	USED	keep — in use
db_ops.billing.ReconcileArchive.IX_OrdersDaily	862237	btree					0	336	never	2026-10-06 07:27:53	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_CatalogSummary	862239	btree					0	336	never	2026-10-06 07:27:53	UNUSED	review, then DROP
db_ops.billing.ReconcileArchive.IX_BookingStaging	862230	btree	Y		Y		10890330	336	2026-10-07T10:30:03.584331+00:00	2026-10-06 07:27:53	USED	KEEP — constraint owns it
db_ops.billing.ReconcileArchive.IX_ClaimDetail	862228	btree	Y	Y			139	336	2026-10-07T07:53:35.236047+00:00	2026-10-06 07:27:53	USED	KEEP — primary key
db_ops.billing.RouteLog.IX_InvoiceLine	343822	btree					0	9	never	never	UNUSED	review, then DROP
db_ops.billing.RouteLog.IX_CustomerEntry	343821	btree					0	9	never	never	UNUSED	review, then DROP
db_ops.billing.RouteLog.IX_InvoiceHeader	343819	btree	Y	Y			18	9	2026-10-02T14:01:50.126813+00:00	never	USED	KEEP — primary key
db_ops.billing.PricingResult.IX_PolicyArchive	343765	btree					0	86	never	2026-10-05 05:38:31	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_ForecastLog	343764	btree					0	86	never	2026-10-05 05:38:31	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_MeterAudit	343766	btree					0	86	never	2026-10-05 05:38:31	UNUSED	review, then DROP
db_ops.billing.PricingResult.IX_CampaignQueue	343762	btree	Y		Y		125	86	2026-10-07T07:53:30.760732+00:00	2026-10-05 05:38:31	USED	KEEP — constraint owns it
db_ops.billing.PricingResult.IX_ContractLine	343760	btree	Y	Y			1168	86	2026-10-07T07:53:30.847931+00:00	2026-10-05 05:38:31	USED	KEEP — primary key
db_ops.billing.RouteHeader.IX_StaffingEntry	343893	btree					18519	314092	2026-10-07T10:29:19.834437+00:00	2026-10-07 01:50:26	USED	keep — in use
db_ops.billing.RouteHeader.IX_CampaignSummary	343892	btree					178816	314092	2026-10-07T10:30:03.898515+00:00	2026-10-07 01:50:26	USED	keep — in use
db_ops.billing.RouteHeader.IX_LedgerEntry	343890	btree	Y	Y			282687	314092	2026-10-07T10:29:56.578758+00:00	2026-10-07 01:50:26	USED	KEEP — primary key
db_ops.billing.SupplierLog.IX_ContractResult	343865	btree					566	706	2026-10-06T07:31:55.13033+00:00	2026-10-06 07:27:53	USED	keep — in use
db_ops.billing.SupplierLog.IX_ForecastLog	343864	btree					296	706	2026-10-06T07:31:54.959926+00:00	2026-10-06 07:27:53	USED	keep — in use
db_ops.billing.SupplierLog.IX_OrdersDaily	343855	btree	Y	Y			16	706	2026-10-02T09:32:40.413349+00:00	2026-10-06 07:27:53	USED	KEEP — primary key
db_ops.billing.SupplierLog.IX_ForecastMonthly	343857	btree	Y		Y		0	706	never	2026-10-06 07:27:53	UNUSED	KEEP — constraint owns it
db_ops.billing.LedgerArchive.IX_SalesSnapshot	870103	btree					4	4	2026-10-03T07:14:28.054022+00:00	never	USED	keep — in use
db_ops.billing.LedgerArchive.IX_ShipmentEntry	344522	btree					0	4	never	never	UNUSED	review, then DROP
db_ops.billing.LedgerArchive.IX_PricingStaging	344523	btree					0	4	never	never	UNUSED	review, then DROP
db_ops.billing.LedgerArchive.IX_ShiftStaging	344515	btree	Y	Y			16	4	2026-10-02T09:32:40.413349+00:00	never	USED	KEEP — primary key
db_ops.billing.PolicyLine.IX_CustomerDetail	344495	btree					0	33	never	never	UNUSED	review, then DROP
db_ops.billing.PolicyLine.IX_OrdersDaily	344494	btree					1	33	2026-10-03T07:14:29.045624+00:00	never	USED	keep — in use
db_ops.billing.PolicyLine.UQ_SupplierResult	344487	btree	Y		Y		28	33	2026-10-03T09:02:51.807705+00:00	never	USED	KEEP — constraint owns it
db_ops.billing.PolicyLine.IX_BatchResult	344485	btree	Y	Y			46	33	2026-10-03T09:02:51.938364+00:00	never	USED	KEEP — primary key
db_ops.billing.ShipmentMonthly.UX_ClaimSummary	344461	btree	Y			Y	46	5	2026-10-07T01:19:23.333547+00:00	never	USED	keep — in use
db_ops.billing.ShipmentMonthly.IX_CampaignMonthly	344459	btree	Y	Y			57	5	2026-10-03T09:02:51.807705+00:00	never	USED	KEEP — primary key
drs.drs.InvoiceHistory.IX_AssetHeader	1085270	btree					0	288	never	2026-10-10 07:18:08	UNUSED	review, then DROP
drs.drs.InvoiceHistory.PK_ShipmentLine	1085268	btree	Y	Y			0	288	never	2026-10-10 07:18:08	UNUSED	KEEP — primary key
drs.drs.OrdersLine.IX_CatalogHeader	1085251	btree	Y	Y			9	10	2026-10-10T06:49:33.400611+00:00	never	USED	KEEP — primary key
drs.drs.AssetQueue.IX_ReconcileLog	1085287	btree					0	117	never	2026-10-07 06:09:54	UNUSED	review, then DROP
drs.drs.AssetQueue.PK_WarehouseLog	1085285	btree	Y	Y			0	117	never	2026-10-07 06:09:54	UNUSED	KEEP — primary key
drs.drs.RouteStatus.PK_ForecastLine	1085722	btree	Y	Y			146	51	2026-10-10T08:33:34.766165+00:00	2026-10-10 08:34:09	USED	KEEP — primary key
drs.drs.AssetSnapshot.PK_BatchHistory	1085307	btree	Y	Y			465	6	2026-10-10T08:25:32.465951+00:00	never	USED	KEEP — primary key
drs.drs.AssetSnapshot.UQ_ForecastSummary	1085309	btree	Y		Y		40	6	2026-10-10T07:16:53.435252+00:00	never	USED	KEEP — constraint owns it
drs.drs.StaffingLog.PK_SettlementDetail	1234756	btree	Y	Y			2	1	2026-10-10T05:37:45.066551+00:00	never	USED	KEEP — primary key
drs.drs.StaffingLog.UQ_PayrollDaily	1234773	btree	Y			Y	0	1	never	never	UNUSED	review carefully — unique
drs.drs.StaffingLog.UQ_PayrollLine	1234774	btree	Y			Y	1	1	2026-10-10T07:17:23.022563+00:00	never	USED	keep — in use
drs.drs.BatchStaging.PK_SettlementResult	1085383	btree	Y	Y			13	4	2026-10-10T06:50:01.576199+00:00	never	USED	KEEP — primary key
drs.drs.BatchStaging.UQ_CampaignLog	1085400	btree	Y			Y	0	4	never	never	UNUSED	review carefully — unique
drs.drs.BatchStaging.UQ_InvoiceLog	1085401	btree	Y			Y	103	4	2026-10-10T07:23:57.474837+00:00	never	USED	keep — in use
drs.drs.ShiftDetail.PK_ClaimHeader	1085509	btree	Y	Y			1	12	2026-10-07T06:49:29.115424+00:00	never	USED	KEEP — primary key
drs.drs.ShiftDetail.UQ_ContractLine	1085526	btree	Y			Y	0	12	never	never	UNUSED	review carefully — unique
drs.drs.ShiftDetail.UQ_PolicyDaily	1085527	btree	Y			Y	80	12	2026-10-10T07:23:57.474837+00:00	never	USED	keep — in use
drs.drs.CustomerArchive.PK_ShipmentDetail	1085429	btree	Y	Y			290	13	2026-10-10T08:33:34.768838+00:00	never	USED	KEEP — primary key
drs.drs.CustomerArchive.UQ_MeterStatus	1085431	btree	Y		Y		552	13	2026-10-10T08:33:34.939288+00:00	never	USED	KEEP — constraint owns it
drs.drs.BatchLog.IX_MeterSummary	1085559	btree	Y				159	37	2026-10-10T07:34:23.328222+00:00	never	USED	keep — in use
drs.drs.BatchLog.PK_ForecastHistory	1085552	btree	Y	Y			11	37	2026-10-07T03:16:51.611405+00:00	never	USED	KEEP — primary key
drs.drs.TerritorySnapshot.IX_SalesStaging	1234800	btree					1	6	2026-10-10T07:16:51.742567+00:00	never	USED	keep — in use
drs.drs.TerritorySnapshot.IX_SalesStatus	1234801	btree					3	6	2026-10-10T08:19:36.775695+00:00	never	USED	keep — in use
drs.drs.TerritorySnapshot.PK_MeterSummary	1234793	btree	Y	Y			18	6	2026-10-10T07:16:53.435252+00:00	never	USED	KEEP — primary key
drs.drs.TerritorySnapshot.UQ_ShiftMonthly	1234802	btree	Y			Y	2	6	2026-10-10T07:16:51.742567+00:00	never	USED	keep — in use
drs.drs.CatalogHistory.PK_PolicyDaily	1085325	btree	Y	Y			789	4	2026-10-10T08:33:34.939288+00:00	never	USED	KEEP — primary key
drs.drs.CatalogHistory.UQ_PayrollSummary	1085327	btree	Y		Y		35	4	2026-10-10T07:16:53.435252+00:00	never	USED	KEEP — constraint owns it
drs.drs.RouteHeader.PK_TerritoryArchive	1085568	btree	Y	Y			52	164	2026-10-08T01:55:37.168574+00:00	2026-10-10 08:29:09	USED	KEEP — primary key
drs.drs.LedgerStatus.IX_MeterArchive	1085610	btree	Y				358	12	2026-10-10T07:34:23.331072+00:00	never	USED	keep — in use
drs.drs.LedgerStatus.PK_ClaimStaging	1085598	btree	Y	Y			28	12	2026-10-07T08:42:04.270264+00:00	never	USED	KEEP — primary key
drs.drs.TerritoryStatus.IX_ClaimSnapshot	1085627	btree	Y				312	0	2026-10-10T08:33:34.939288+00:00	never	USED	keep — in use
drs.drs.TerritoryStatus.PK_BookingQueue	1085620	btree	Y	Y			3	0	2026-10-07T06:49:20.529796+00:00	never	USED	KEEP — primary key
drs.drs.SettlementHeader.IX_SettlementStaging	1085654	btree					0	31	never	never	UNUSED	review, then DROP
drs.drs.SettlementHeader.IX_RouteStaging	1085655	btree					182	31	2026-10-10T07:34:23.81809+00:00	never	USED	keep — in use
drs.drs.SettlementHeader.PK_InvoiceDaily	1085647	btree	Y	Y			77	31	2026-10-10T08:33:34.939288+00:00	never	USED	KEEP — primary key
drs.drs.MeterResult.IX_TicketSummary	1085678	btree					0	8	never	never	UNUSED	review, then DROP
drs.drs.MeterResult.IX_PricingDaily	1085679	btree					0	8	never	never	UNUSED	review, then DROP
drs.drs.MeterResult.IX_SupplierAudit	1085680	btree					2	8	2026-10-10T07:16:53.435252+00:00	never	USED	keep — in use
drs.drs.MeterResult.PK_PricingLine	1085676	btree	Y	Y			0	8	never	never	UNUSED	KEEP — primary key
drs.drs.AssetEntry.PK_ContractMonthly	1085339	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.drs.AssetEntry.UQ_RosterAudit	1085341	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.drs.ContractArchive.PK_ReconcileDetail	1085458	btree	Y	Y			181	151	2026-10-07T05:30:15.39099+00:00	2026-10-08 01:34:11	USED	KEEP — primary key
drs.drs.CustomerStatus.PK_TerritoryMonthly	1085363	btree	Y	Y			1051	59	2026-10-10T07:15:04.649752+00:00	2026-10-10 07:15:08	USED	KEEP — primary key
drs.drs.CustomerStatus.UQ_SettlementLine	1085365	btree	Y		Y		0	59	never	2026-10-10 07:15:08	UNUSED	KEEP — constraint owns it
drs.drs.CustomerStatus.UQ_WarehouseSummary	1085367	btree	Y		Y		355	59	2026-10-10T07:15:03.176371+00:00	2026-10-10 07:15:08	USED	KEEP — constraint owns it
drs.drs.AssetSummary.PK_CatalogHistory	1085471	btree	Y	Y			190	0	2026-10-10T07:34:23.331072+00:00	never	USED	KEEP — primary key
drs.drs.ClaimArchive.PK_StaffingHistory	1085483	btree	Y	Y			8	0	2026-10-07T08:17:03.555225+00:00	never	USED	KEEP — primary key
drs.dbo.StaffingSnapshot.IX_CustomerLog	1092875	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.StaffingSnapshot.IX_RouteHistory	1092877	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.PolicyAudit.IX_RosterEntry	1092879	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.PolicyAudit.IX_PricingArchive	1092881	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.PolicyAudit.IX_RosterResult	1093049	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.PolicyAudit.IX_StaffingMonthly	1093050	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.SalesMonthly.IX_ShipmentQueue	1092883	btree	Y		Y		0	87	never	2026-10-07 05:52:54	UNUSED	KEEP — constraint owns it
drs.dbo.SalesMonthly.IX_RouteArchive	1092885	btree	Y	Y			13183	87	2026-10-10T08:36:02.728365+00:00	2026-10-07 05:52:54	USED	KEEP — primary key
drs.dbo.OrdersQueue.IX_BatchLine	1092887	btree	Y		Y		0	235	never	2026-10-07 05:52:54	UNUSED	KEEP — constraint owns it
drs.dbo.OrdersQueue.IX_ContractHistory	1092889	btree	Y	Y			5517	235	2026-10-10T08:36:02.728365+00:00	2026-10-07 05:52:54	USED	KEEP — primary key
drs.dbo.OrdersQueue.IX_CustomerArchive	1093051	btree					11270	235	2026-10-10T08:36:02.728365+00:00	2026-10-07 05:52:54	USED	keep — in use
drs.dbo.OrdersQueue.IX_RouteStaging	1093069	btree					11270	235	2026-10-10T08:36:02.728365+00:00	2026-10-07 05:52:54	USED	keep — in use
drs.dbo.OrdersSummary.IX_RosterArchive	1092891	btree	Y		Y		5899	569	2026-10-10T08:36:02.728365+00:00	2026-10-07 05:52:54	USED	KEEP — constraint owns it
drs.dbo.OrdersSummary.IX_ShiftStatus	1092893	btree	Y	Y			0	569	never	2026-10-07 05:52:54	UNUSED	KEEP — primary key
drs.dbo.OrdersSummary.IX_InvoiceLine	1093052	btree					11502	569	2026-10-10T08:36:02.728365+00:00	2026-10-07 05:52:54	USED	keep — in use
drs.dbo.OrdersSummary.IX_TerritoryLog	1093053	btree					1271	569	2026-10-10T08:36:02.728365+00:00	2026-10-07 05:52:54	USED	keep — in use
drs.dbo.PayrollDetail.IX_LedgerLog	1092895	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.PayrollDetail.IX_PolicyArchive	1092897	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.PayrollDetail.IX_QuotaQueue	1092899	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.SalesMonthly.IX_AssetStaging	1092901	btree	Y		Y		0	9	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.SalesMonthly.IX_PayrollLine	1092903	btree	Y	Y			93	9	2026-10-10T08:31:16.934958+00:00	never	USED	KEEP — primary key
drs.dbo.QuotaArchive.IX_OrdersDaily	1092905	btree	Y		Y		0	175	never	2026-10-10 08:19:09	UNUSED	KEEP — constraint owns it
drs.dbo.QuotaArchive.IX_SupplierMonthly	1092911	btree	Y	Y			79	175	2026-10-10T08:26:22.434276+00:00	2026-10-10 08:19:09	USED	KEEP — primary key
drs.dbo.QuotaArchive.IX_ForecastDaily	1092917	btree	Y		Y		0	175	never	2026-10-10 08:19:09	UNUSED	KEEP — constraint owns it
drs.dbo.RouteStatus.IX_StaffingMonthly	1092907	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.RouteStatus.IX_WarehouseAudit	1092909	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.RouteStatus.IX_LedgerEntry	1093066	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.RouteStatus.IX_CustomerMonthly	1093067	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.WarehouseAudit.IX_ForecastLog	1092913	btree	Y	Y			0	6	never	never	UNUSED	KEEP — primary key
drs.dbo.WarehouseAudit.IX_LedgerQueue	1092915	btree	Y		Y		0	6	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.LedgerStatus.IX_TicketLog	1092919	btree	Y		Y		0	103	never	2026-10-07 05:52:54	UNUSED	KEEP — constraint owns it
drs.dbo.LedgerStatus.IX_CustomerLine	1092921	btree	Y	Y			27497	103	2026-10-10T08:36:02.728365+00:00	2026-10-07 05:52:54	USED	KEEP — primary key
drs.dbo.LedgerStatus.IX_MeterMonthly	1092923	btree	Y	Y			0	1	never	never	UNUSED	KEEP — primary key
drs.dbo.InvoiceStaging.IX_AssetLine	1092927	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.InvoiceStaging.IX_SalesArchive	1093087	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.PolicyMonthly.IX_OrdersSummary	1092925	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.ClaimSummary.IX_PricingArchive	1092929	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.ClaimSummary.IX_LedgerStatus	1093070	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.AssetStaging.IX_ContractMonthly	1092933	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.MeterStatus.IX_BookingDetail	1092935	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.BatchStatus.IX_BillingQueue	1092937	btree	Y	Y			0	13	never	never	UNUSED	KEEP — primary key
drs.dbo.BatchStatus.UQ_ContractStaging	1093021	btree	Y		Y		21	13	2026-10-10T08:26:22.434276+00:00	never	USED	KEEP — constraint owns it
drs.dbo.SettlementEntry.IX_StaffingHistory	1092939	btree	Y	Y			0	3	never	never	UNUSED	KEEP — primary key
drs.dbo.AssetHistory.IX_ContractHistory	1092941	btree	Y	Y			29	12	2026-10-10T07:34:23.955284+00:00	never	USED	KEEP — primary key
drs.dbo.AssetHistory.IX_BillingHeader	1092959	btree	Y		Y		0	12	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.AssetHistory.UQ_ClaimDetail	1093023	btree	Y		Y		0	12	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.SalesStaging.IX_ShipmentStatus	1092943	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.SalesStaging.IX_StaffingLog	1093068	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.dbs.IX_SalesResult	1092945	btree	Y		Y		0	2	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.dbs.IX_SalesStatus	1092947	btree	Y	Y			0	2	never	never	UNUSED	KEEP — primary key
drs.dbo.dbs.IX_PolicySummary	1092949	btree	Y		Y		0	2	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.dbs.UQ_TicketLog	1093025	btree	Y		Y		0	2	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.ShipmentSnapshot.IX_ShipmentStaging	1092951	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.ShipmentSnapshot.IX_ForecastQueue	1092953	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.ShipmentSnapshot.IX_TicketSummary	1092955	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.SupplierDetail.IX_PayrollLog	1092957	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.MeterDetail.IX_TerritoryResult	1093072	btree					0	25	never	never	UNUSED	review, then DROP
drs.dbo.MeterDetail.IX_BatchSnapshot	1093073	btree	Y				0	25	never	never	UNUSED	review carefully — unique
drs.dbo.MeterDetail.IX_CustomerHeader	1092961	btree	Y	Y			0	25	never	never	UNUSED	KEEP — primary key
drs.dbo.TicketSnapshot.IX_TicketHeader	1092963	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.logs.IX_TicketSummary	1093074	btree					3	2470	2026-10-10T08:26:21.479603+00:00	2026-10-10 07:59:09	USED	keep — in use
drs.dbo.logs.IX_PayrollStaging	1092965	btree	Y	Y			0	2470	never	2026-10-10 07:59:09	UNUSED	KEEP — primary key
drs.dbo.query.IX_WarehouseHeader	1092931	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.query.IX_ContractStaging	1093075	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.query.IX_ContractArchive	1093081	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.query.IX_PolicyHistory	1092967	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.query.IX_ShipmentDetail	1093088	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.BookingSnapshot.IX_MeterStaging	1093076	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.BookingSnapshot.IX_AssetLog	1093077	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.BookingSnapshot.IX_BookingHeader	1092969	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.TerritorySummary.IX_PayrollArchive	1093078	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.TerritorySummary.IX_CustomerEntry	1092971	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.StaffingResult.IX_RosterResult	1093071	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.StaffingResult.IX_SupplierQueue	1093079	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.StaffingResult.IX_TicketMonthly	1092973	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.StaffingResult.UQ_ShipmentResult	1093027	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.PayrollMonthly.IX_CampaignDetail	1092975	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.ClaimLine.IX_CampaignStatus	1092977	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.ForecastStatus.IX_AssetAudit	1092979	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.ReconcileDaily.IX_PricingSnapshot	1093080	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.ReconcileDaily.IX_MeterStaging	1092981	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.ReconcileDaily.UQ_OrdersStaging	1093029	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.PolicyLine.IX_AssetEntry	1092983	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.PolicyLine.UQ_ClaimAudit	1093031	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.StaffingStatus.IX_AssetAudit	1092985	btree	Y	Y			0	13	never	never	UNUSED	KEEP — primary key
drs.dbo.WarehouseStaging.IX_BillingMonthly	1092987	btree	Y	Y			0	17	never	never	UNUSED	KEEP — primary key
drs.dbo.WarehouseStaging.UQ_BookingLine	1093033	btree	Y		Y		0	17	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.ContractQueue.IX_CampaignLine	1092989	btree	Y	Y			0	3	never	never	UNUSED	KEEP — primary key
drs.dbo.ContractQueue.UQ_CustomerSummary	1093035	btree	Y		Y		0	3	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.ContractQueue.UQ_QuotaAudit	1093037	btree	Y		Y		0	3	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.RosterArchive.IX_TicketSummary	1092991	btree	Y	Y			0	3	never	never	UNUSED	KEEP — primary key
drs.dbo.CatalogLine.IX_OrdersDaily	1093082	btree	Y				529	0	2026-10-10T08:26:22.434276+00:00	never	USED	keep — in use
drs.dbo.CatalogLine.IX_LedgerArchive	1093083	btree	Y				0	0	never	never	COLD	review carefully — unique
drs.dbo.CatalogLine.IX_BillingDaily	1092993	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.OrdersArchive.IX_WarehouseDaily	1093084	btree	Y				0	0	never	never	COLD	review carefully — unique
drs.dbo.OrdersArchive.IX_PolicyLog	1092995	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.CatalogResult.IX_ReconcileDaily	1092997	btree	Y	Y			0	77	never	2026-10-10 06:51:08	UNUSED	KEEP — primary key
drs.dbo.CatalogResult.UQ_InvoiceHistory	1093039	btree	Y		Y		0	77	never	2026-10-10 06:51:08	UNUSED	KEEP — constraint owns it
drs.dbo.CatalogResult.UQ_CampaignDetail	1093041	btree	Y		Y		0	77	never	2026-10-10 06:51:08	UNUSED	KEEP — constraint owns it
drs.dbo.TicketAudit.IX_BookingResult	1093085	btree	Y				0	0	never	never	COLD	review carefully — unique
drs.dbo.TicketAudit.IX_OrdersHistory	1092999	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.tables.IX_AssetStatus	1092873	btree	Y		Y		0	7	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.tables.IX_CampaignMonthly	1093001	btree	Y	Y			21	7	2026-10-10T08:26:22.434276+00:00	never	USED	KEEP — primary key
drs.dbo.tables.UQ_LedgerStaging	1093043	btree	Y		Y		0	7	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.tag.IX_RosterEntry	1093003	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.tag.IX_WarehouseLine	1093005	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.ShiftSummary.IX_BatchEntry	1093086	btree					126	0	2026-10-10T08:35:55.265726+00:00	never	USED	keep — in use
drs.dbo.ShiftSummary.IX_WarehouseSummary	1093007	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.ShiftSummary.IX_SupplierAudit	1093019	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.SettlementStaging.IX_RouteStatus	1093054	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.SettlementStaging.IX_CatalogResult	1093009	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.SettlementStaging.UQ_RouteResult	1093045	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.tasks.IX_ShiftEntry	1093055	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.tasks.IX_ShiftLine	1093056	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.tasks.IX_PricingSnapshot	1093057	btree	Y				0	0	never	never	COLD	review carefully — unique
drs.dbo.tasks.IX_QuotaHeader	1093058	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.tasks.IX_ForecastResult	1093059	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.tasks.IX_InvoiceMonthly	1093060	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.tasks.IX_OrdersStaging	1093061	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.tasks.IX_CatalogLog	1093062	btree					0	0	never	never	COLD	review, then DROP
drs.dbo.tasks.IX_InvoiceEntry	1093063	btree	Y				0	0	never	never	COLD	review carefully — unique
drs.dbo.tasks.IX_WarehouseLine	1093011	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
drs.dbo.tasks.IX_AssetStaging	1093013	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
drs.dbo.PolicyResult.IX_ClaimHistory	1093064	btree					0	2	never	never	UNUSED	review, then DROP
drs.dbo.PolicyResult.IX_BatchSnapshot	1093065	btree					0	2	never	never	UNUSED	review, then DROP
drs.dbo.PolicyResult.IX_BatchLine	1093015	btree	Y	Y			0	2	never	never	UNUSED	KEEP — primary key
drs.dbo.PolicyResult.IX_SettlementSnapshot	1093017	btree	Y		Y		0	2	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.ClaimSnapshot.IX_QuotaDetail	1093047	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key