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-192-0-2-136-MSSQLLAB-1433 ACME-198-51-100-210 ACME-198-51-100-60 ACME-192-0-2-243 ACME-203-0-113-99 ACME-203-0-113-69 ACME-192-0-2-97 ACME-192-0-2-242 ACME-203-0-113-155Oracle 3ACME-192-0-2-136-ORALAB-1521 ACME-192-0-2-120 ACME-198-51-100-125PostgreSQL 2ACME-192-0-2-15-PG-5433ACME-192-0-2-136-PGLAB-5432

Host: 192.0.2.15

Collected: 2026-10-19T18:00:18Z

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	785	every index on a user table
used	273	had a seek, scan or lookup
unused	193	written but never read
cold	319	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	231	nonclustered, not unique, no constraint, never read

By database

Database	Total	Cold	Droppable	Recommend action
SETTLEMENT	288	101	112	review the drop candidates above
BILLING	319	142	90	review the drop candidates above
drs	178	76	29	review the drop candidates above

Drop candidates (231)

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

Index	user_updates	last_read	State	Recommend action
SETTLEMENT.SETTLEMENT.metric_results.IX_InvoiceMonthly	29296421	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.metric_results.IX_WarehouseSummary	29296421	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.metric_results.IX_ReconcileStatus	4804692	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.metric_results.IX_InvoiceMonthly	4804692	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.metric_results.IX_ShiftAudit	4804692	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.TicketDetail.IX_BillingStaging	1375298	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.TicketDetail.IX_BillingStaging	308224	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.SettlementStatus.IX_QuotaQueue	225742	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.ClaimQueue.IX_ShiftSummary	160088	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.BatchLine.IX_TicketHeader	86949	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.BatchLine.IX_BookingSnapshot	86949	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.SettlementStatus.IX_QuotaQueue	48695	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.reports.IX_BillingDetail	20204	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.ShiftHeader.IX_ReconcileHistory	7497	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.ShiftHeader.IX_SettlementSummary	7497	never	UNUSED	review, then DROP
BILLING.public.InvoiceDetail.IX_PolicyLog	1745	never	UNUSED	review, then DROP
BILLING.public.InvoiceDetail.IX_ClaimArchive	1745	never	UNUSED	review, then DROP
BILLING.public.BillingHistory.IX_CampaignResult	1484	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.RouteEntry.IX_SupplierSummary	753	never	UNUSED	review, then DROP
BILLING.public.CampaignArchive.IX_TerritoryLine	690	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.SettlementDaily.IX_BillingSnapshot	564	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.SettlementEntry.IX_BillingResult	519	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.ReconcileArchive.IX_CatalogArchive	336	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.ReconcileArchive.IX_WarehouseMonthly	336	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.ReconcileArchive.IX_OrdersDaily	336	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.ReconcileArchive.IX_CatalogSummary	336	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_CatalogSummary	330	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_OrdersDaily	330	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_WarehouseMonthly	330	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_CatalogArchive	330	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_SettlementEntry	330	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.StaffingResult.IX_OrdersQueue	327	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.StaffingResult.IX_OrdersQueue	270	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.PolicyLine.IX_OrdersDaily	162	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.PolicyLine.IX_CustomerDetail	162	never	UNUSED	review, then DROP
drs.dbo.MeterDetail.IX_TerritoryResult	162	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.RouteEntry.IX_SupplierSummary	153	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.PricingResult.IX_MeterAudit	138	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.PricingResult.IX_ForecastLog	138	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.PricingResult.IX_PolicyArchive	138	never	UNUSED	review, then DROP
BILLING.public.RosterSnapshot.IX_ClaimAudit	117	never	UNUSED	review, then DROP
BILLING.public.RosterSnapshot.IX_BatchEntry	117	never	UNUSED	review, then DROP
BILLING.public.RosterSnapshot.IX_ReconcileLine	117	never	UNUSED	review, then DROP
BILLING.public.SalesDetail.IX_CatalogHeader	114	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.TerritoryStaging.IX_RosterSnapshot	96	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.SettlementEntry.IX_BillingResult	94	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.PricingResult.IX_MeterAudit	86	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.PricingResult.IX_ForecastLog	86	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.PricingResult.IX_PolicyArchive	86	never	UNUSED	review, then DROP
drs.drs.MeterResult.IX_PricingDaily	62	never	UNUSED	review, then DROP
drs.drs.MeterResult.IX_TicketSummary	62	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.SettlementDaily.IX_OrdersLog	49	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.SettlementDaily.IX_BillingSnapshot	49	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_TicketLog	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_TerritoryHeader	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_ContractHeader	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_ContractMonthly	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_CatalogLog	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_MeterQueue	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_BatchStatus	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_BillingSummary	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_LedgerDetail	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_TicketArchive	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_SettlementLine	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_ForecastResult	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_ForecastSummary	38	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_QuotaQueue	38	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.PolicyLine.IX_CustomerDetail	33	never	UNUSED	review, then DROP
BILLING.public.PayrollMonthly.IX_AssetHeader	28	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_BatchArchive	10	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_CustomerStatus	10	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_PayrollSnapshot	10	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_ShiftResult	10	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_LedgerArchive	10	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_ShiftResult	10	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_CampaignStatus	10	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.RouteLog.IX_InvoiceLine	9	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.RouteLog.IX_CustomerEntry	9	never	UNUSED	review, then DROP
BILLING.public.QuotaHeader.IX_LedgerStaging	7	never	UNUSED	review, then DROP
BILLING.public.article.IX_CampaignStaging	6	never	UNUSED	review, then DROP
BILLING.public.article.IX_QuotaStaging	6	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.LedgerArchive.IX_ShipmentEntry	5	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.LedgerArchive.IX_SalesSnapshot	5	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.LedgerArchive.IX_PricingStaging	5	never	UNUSED	review, then DROP
BILLING.public.RosterMonthly.IX_PayrollEntry	5	never	UNUSED	review, then DROP
BILLING.public.AssetAudit.IX_SettlementQueue	4	never	UNUSED	review, then DROP
BILLING.public.queue.IX_ReconcileLine	4	never	UNUSED	review, then DROP
BILLING.public.SalesAudit.IX_SettlementResult	4	never	UNUSED	review, then DROP
BILLING.public.SalesAudit.IX_CampaignArchive	4	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.LedgerArchive.IX_ShipmentEntry	4	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.LedgerArchive.IX_PricingStaging	4	never	UNUSED	review, then DROP
BILLING.public.LedgerHeader.IX_CampaignSnapshot	3	never	UNUSED	review, then DROP
BILLING.public.CampaignLine.IX_ReconcileLine	3	never	UNUSED	review, then DROP
drs.dbo.PolicyResult.IX_ClaimHistory	2	never	UNUSED	review, then DROP
drs.dbo.PolicyResult.IX_BatchSnapshot	2	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.ContractAudit.IX_OrdersAudit	0	never	COLD	review, then DROP
SETTLEMENT.dbabrain.QuotaHistory.IX_ShiftHistory	0	never	COLD	review, then DROP
SETTLEMENT.dbabrain.PricingSummary.IX_TicketArchive	0	never	COLD	review, then DROP
SETTLEMENT.report.PolicyLine.IX_OrdersDaily	0	never	COLD	review, then DROP
SETTLEMENT.report.PolicyLine.IX_CustomerDetail	0	never	COLD	review, then DROP
SETTLEMENT.report.SettlementDaily.IX_OrdersLog	0	never	COLD	review, then DROP
SETTLEMENT.SETTLEMENT.TerritoryStaging.IX_RosterSnapshot	0	never	COLD	review, then DROP
SETTLEMENT.SETTLEMENT.QuotaHistory.IX_ShiftHistory	0	never	COLD	review, then DROP
SETTLEMENT.SETTLEMENT.PricingSummary.IX_AssetEntry	0	never	COLD	review, then DROP
BILLING.public.PricingAudit.IX_StaffingEntry	0	never	COLD	review, then DROP
BILLING.public.BatchMonthly.IX_CampaignDetail	0	never	COLD	review, then DROP
BILLING.public.SalesResult.IX_ClaimEntry	0	never	COLD	review, then DROP
BILLING.public.ShipmentMonthly.IX_WarehouseAudit	0	never	COLD	review, then DROP
BILLING.public.BillingEntry.IX_ContractHeader	0	never	COLD	review, then DROP
BILLING.public.CampaignAudit.IX_InvoiceStaging	0	never	COLD	review, then DROP
BILLING.public.ForecastLine.IX_TerritoryDaily	0	never	COLD	review, then DROP
BILLING.public.BookingMonthly.IX_MeterResult	0	never	COLD	review, then DROP
BILLING.public.TerritoryMonthly.IX_PayrollLine	0	never	COLD	review, then DROP
drs.dbo.BookingSnapshot.IX_AssetLog	0	never	COLD	review, then DROP
drs.dbo.BookingSnapshot.IX_MeterStaging	0	never	COLD	review, then DROP
drs.dbo.query.IX_ShipmentDetail	0	never	COLD	review, then DROP
drs.dbo.query.IX_ContractArchive	0	never	COLD	review, then DROP
drs.dbo.query.IX_ContractStaging	0	never	COLD	review, then DROP
SETTLEMENT.report.LedgerArchive.IX_PricingStaging	0	never	COLD	review, then DROP
SETTLEMENT.report.LedgerArchive.IX_ShipmentEntry	0	never	COLD	review, then DROP
SETTLEMENT.report.RouteHeader.IX_CampaignSummary	0	never	COLD	review, then DROP
SETTLEMENT.report.RouteHeader.IX_StaffingEntry	0	never	COLD	review, then DROP
SETTLEMENT.report.PricingResult.IX_MeterAudit	0	never	COLD	review, then DROP
SETTLEMENT.report.PricingResult.IX_ForecastLog	0	never	COLD	review, then DROP
SETTLEMENT.report.PricingResult.IX_PolicyArchive	0	never	COLD	review, then DROP
SETTLEMENT.report.RouteLog.IX_CustomerEntry	0	never	COLD	review, then DROP
SETTLEMENT.report.RouteLog.IX_InvoiceLine	0	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_CatalogSummary	0	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_OrdersDaily	0	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_ContractLine	0	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_WarehouseMonthly	0	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_CatalogArchive	0	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_SettlementEntry	0	never	COLD	review, then DROP
SETTLEMENT.report.SupplierDaily.IX_BillingDaily	0	never	COLD	review, then DROP
SETTLEMENT.report.SettlementDaily.IX_BillingSnapshot	0	never	COLD	review, then DROP
SETTLEMENT.report.QuotaHistory.IX_ShiftHistory	0	never	COLD	review, then DROP
SETTLEMENT.report.PricingSummary.IX_AssetEntry	0	never	COLD	review, then DROP
SETTLEMENT.report.PricingSummary.IX_TicketArchive	0	never	COLD	review, then DROP
BILLING.public.TicketAudit.IX_RouteResult	0	never	COLD	review, then DROP
BILLING.public.TicketAudit.IX_ShipmentQueue	0	never	COLD	review, then DROP
BILLING.public.TicketAudit.IX_TicketStatus	0	never	COLD	review, then DROP
BILLING.public.PayrollDaily.IX_RosterQueue	0	never	COLD	review, then DROP
BILLING.public.QuotaStaging.IX_PricingLog	0	never	COLD	review, then DROP
BILLING.public.ReconcileHistory.IX_ForecastHeader	0	never	COLD	review, then DROP
BILLING.public.AssetDaily.IX_SalesDaily	0	never	COLD	review, then DROP
BILLING.public.ForecastLine.IX_CatalogHeader	0	never	COLD	review, then DROP
BILLING.public.ForecastLine.IX_BillingLine	0	never	COLD	review, then DROP
BILLING.public.RouteSnapshot.IX_PolicyAudit	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
BILLING.public.RouteSnapshot.IX_ContractDaily	0	never	COLD	review, then DROP
BILLING.public.RouteSnapshot.IX_ForecastLog	0	never	COLD	review, then DROP
BILLING.public.RouteSnapshot.IX_TerritoryLine	0	never	COLD	review, then DROP
BILLING.public.SupplierQueue.IX_ShiftHistory	0	never	COLD	review, then DROP
BILLING.public.MeterArchive.IX_OrdersResult	0	never	COLD	review, then DROP
BILLING.public.MeterArchive.IX_CustomerLine	0	never	COLD	review, then DROP
BILLING.public.ShipmentMonthly.IX_ReconcileDetail	0	never	COLD	review, then DROP
BILLING.public.StaffingDaily.IX_StaffingArchive	0	never	COLD	review, then DROP
BILLING.public.StaffingDaily.IX_WarehouseMonthly	0	never	COLD	review, then DROP
BILLING.public.OrdersQueue.IX_PayrollAudit	0	never	COLD	review, then DROP
BILLING.public.OrdersQueue.IX_LedgerEntry	0	never	COLD	review, then DROP
BILLING.public.TicketMonthly.IX_ForecastResult	0	never	COLD	review, then DROP
BILLING.public.TicketMonthly.IX_InvoiceArchive	0	never	COLD	review, then DROP
BILLING.public.WarehouseSummary.IX_WarehouseResult	0	never	COLD	review, then DROP
BILLING.public.WarehouseSummary.IX_ReconcileStaging	0	never	COLD	review, then DROP
BILLING.public.SupplierLine.IX_QuotaSnapshot	0	never	COLD	review, then DROP
BILLING.public.CampaignLine.IX_SalesSummary	0	never	COLD	review, then DROP
BILLING.public.PricingAudit.IX_ShipmentMonthly	0	never	COLD	review, then DROP
BILLING.public.PricingAudit.IX_QuotaLog	0	never	COLD	review, then DROP
BILLING.public.OrdersSnapshot.IX_CustomerDetail	0	never	COLD	review, then DROP
BILLING.public.OrdersSnapshot.IX_TicketStatus	0	never	COLD	review, then DROP
BILLING.public.ReconcileHistory.IX_BillingHistory	0	never	COLD	review, then DROP
BILLING.public.QuotaHistory.IX_PricingMonthly	0	never	COLD	review, then DROP
BILLING.public.QuotaHistory.IX_MeterResult	0	never	COLD	review, then DROP
BILLING.public.QuotaHistory.IX_CampaignDaily	0	never	COLD	review, then DROP
BILLING.public.CatalogDetail.IX_ForecastHeader	0	never	COLD	review, then DROP
BILLING.public.SalesEntry.IX_RouteHistory	0	never	COLD	review, then DROP
BILLING.public.SalesEntry.IX_TerritoryHistory	0	never	COLD	review, then DROP
BILLING.public.PricingStatus.IX_SalesQueue	0	never	COLD	review, then DROP
BILLING.public.SalesResult.IX_ClaimSnapshot	0	never	COLD	review, then DROP
BILLING.public.PricingAudit.IX_RouteHistory	0	never	COLD	review, then DROP
SETTLEMENT.SETTLEMENT.PricingSummary.IX_TicketArchive	0	never	COLD	review, then DROP
SETTLEMENT.report.SettlementEntry.IX_WarehouseEntry	0	never	COLD	review, then DROP
SETTLEMENT.report.SettlementEntry.IX_BillingResult	0	never	COLD	review, then DROP
SETTLEMENT.report.StaffingResult.IX_OrdersQueue	0	never	COLD	review, then DROP
SETTLEMENT.report.WarehouseDetail.IX_PayrollResult	0	never	COLD	review, then DROP
SETTLEMENT.report.WarehouseDetail.IX_InvoiceHistory	0	never	COLD	review, then DROP
SETTLEMENT.report.WarehouseDetail.IX_SettlementDaily	0	never	COLD	review, then DROP
SETTLEMENT.report.WarehouseDetail.IX_CampaignSummary	0	never	COLD	review, then DROP
SETTLEMENT.report.TicketDetail.IX_BillingStaging	0	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_PayrollSnapshot	0	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_ReconcileStatus	0	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_InvoiceMonthly	0	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_StaffingDetail	0	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_BillingStaging	0	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_ShiftAudit	0	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_WarehouseSummary	0	never	COLD	review, then DROP
SETTLEMENT.report.ContractAudit.IX_OrdersAudit	0	never	COLD	review, then DROP
SETTLEMENT.report.SettlementStatus.IX_QuotaQueue	0	never	COLD	review, then DROP
SETTLEMENT.report.TerritoryStaging.IX_RosterSnapshot	0	never	COLD	review, then DROP
SETTLEMENT.report.reports.IX_PayrollLog	0	never	COLD	review, then DROP
SETTLEMENT.report.reports.IX_MeterResult	0	never	COLD	review, then DROP
SETTLEMENT.report.reports.IX_BillingDetail	0	never	COLD	review, then DROP
SETTLEMENT.report.AssetAudit.IX_OrdersMonthly	0	never	COLD	review, then DROP
SETTLEMENT.report.ShiftHeader.IX_SettlementSummary	0	never	COLD	review, then DROP
SETTLEMENT.report.ShiftHeader.IX_ContractSummary	0	never	COLD	review, then DROP
SETTLEMENT.report.ShiftHeader.IX_ReconcileHistory	0	never	COLD	review, then DROP
SETTLEMENT.report.RouteEntry.IX_CampaignLog	0	never	COLD	review, then DROP
SETTLEMENT.report.RouteEntry.IX_SupplierSummary	0	never	COLD	review, then DROP
SETTLEMENT.report.ClaimQueue.IX_MeterMonthly	0	never	COLD	review, then DROP
SETTLEMENT.report.ClaimQueue.IX_ShiftSummary	0	never	COLD	review, then DROP
SETTLEMENT.report.ClaimQueue.IX_RouteEntry	0	never	COLD	review, then DROP
SETTLEMENT.report.BatchLine.IX_TicketHeader	0	never	COLD	review, then DROP
SETTLEMENT.report.BatchLine.IX_BookingSnapshot	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.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
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

All indexes (785)

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
SETTLEMENT.SETTLEMENT.PricingSummary.IX_ForecastEntry	49445	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.SETTLEMENT.PricingSummary.IX_TicketArchive	49447	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.SETTLEMENT.PricingSummary.IX_AssetEntry	49448	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.SETTLEMENT.PricingSummary.UX_SupplierResult	49449	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
SETTLEMENT.SETTLEMENT.QuotaHistory.IX_ShiftHistory	248903	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.SETTLEMENT.SettlementDaily.IX_PricingEntry	49348	btree	Y	Y			283	564	2026-10-16T20:40:53.764026+00:00	2026-10-14 19:56:21	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.SettlementDaily.IX_BillingSnapshot	49336	btree					0	564	never	2026-10-14 19:56:21	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.SettlementDaily.IX_OrdersLog	49343	btree					2	564	2026-10-06T01:51:22.481332+00:00	2026-10-14 19:56:21	USED	keep — in use
SETTLEMENT.SETTLEMENT.SettlementHistory.IX_AssetHeader	49383	btree	Y	Y			1204	552	2026-10-19T04:31:55.575252+00:00	2026-10-19 03:51:04	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.SettlementHistory.UQ_WarehouseStaging	49390	btree	Y		Y		1204	552	2026-10-19T04:31:55.575252+00:00	2026-10-19 03:51:04	USED	KEEP — constraint owns it
SETTLEMENT.SETTLEMENT.CampaignStaging.IX_SalesQueue	49271	btree	Y	Y			0	519	never	2026-10-19 00:51:48	UNUSED	KEEP — primary key
SETTLEMENT.SETTLEMENT.CampaignStaging.UQ_MeterSnapshot	49273	btree	Y		Y		70	519	2026-10-05T04:14:19.368666+00:00	2026-10-19 00:51:48	USED	KEEP — constraint owns it
SETTLEMENT.SETTLEMENT.SettlementEntry.IX_StaffingDetail	49299	btree	Y	Y			981	519	2026-10-19T04:31:54.847675+00:00	2026-10-19 00:51:48	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.SettlementEntry.IX_WarehouseEntry	49315	btree					1676	519	2026-10-19T04:31:55.575252+00:00	2026-10-19 00:51:48	USED	keep — in use
SETTLEMENT.SETTLEMENT.SettlementEntry.IX_BillingResult	49316	btree					0	519	never	2026-10-19 00:51:48	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.SettlementEntry.UX_QuotaMonthly	49317	btree	Y			Y	6857	519	2026-10-19T04:31:55.575252+00:00	2026-10-19 00:51:48	USED	keep — in use
SETTLEMENT.SETTLEMENT.StaffingResult.IX_CatalogDaily	49374	btree	Y	Y			1204	327	2026-10-19T04:31:55.575252+00:00	2026-10-19 00:50:48	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.StaffingResult.IX_InvoiceDetail	49376	btree	Y		Y		0	327	never	2026-10-19 00:50:48	UNUSED	KEEP — constraint owns it
SETTLEMENT.SETTLEMENT.StaffingResult.IX_OrdersQueue	49320	btree					0	327	never	2026-10-19 00:50:48	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.WarehouseDetail.IX_PayrollResult	46502	btree					5334	5040586	2026-10-19T13:57:58.419911+00:00	2026-10-19 09:53:10	USED	keep — in use
SETTLEMENT.SETTLEMENT.WarehouseDetail.IX_InvoiceHistory	46505	btree					4367836	5040586	2026-10-19T18:00:18.740915+00:00	2026-10-19 09:53:10	USED	keep — in use
SETTLEMENT.SETTLEMENT.WarehouseDetail.IX_SettlementDaily	46507	btree					21738	5040586	2026-10-19T17:58:54.575783+00:00	2026-10-19 09:53:10	USED	keep — in use
SETTLEMENT.SETTLEMENT.WarehouseDetail.IX_CampaignSummary	46509	btree					130	5040586	2026-10-14T11:50:39.156802+00:00	2026-10-19 09:53:10	USED	keep — in use
SETTLEMENT.SETTLEMENT.WarehouseDetail.IX_StaffingDetail	46514	btree	Y	Y			78254161	5040586	2026-10-19T18:00:18.000995+00:00	2026-10-19 09:53:10	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.WarehouseDetail.UX_SupplierLine	473550	btree	Y			Y	0	5040586	never	2026-10-19 09:53:10	UNUSED	review carefully — unique
SETTLEMENT.SETTLEMENT.TicketDetail.IX_BillingStaging	46498	btree					0	1375298	never	2026-10-19 06:32:14	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.metric_results.IX_PayrollSnapshot	49487	btree					311513	29296421	2026-10-19T18:00:13.008396+00:00	2026-10-19 03:00:05	USED	keep — in use
SETTLEMENT.SETTLEMENT.metric_results.IX_ReconcileStatus	49486	btree					487	29296421	2026-10-19T00:13:28.092219+00:00	2026-10-19 03:00:05	USED	keep — in use
SETTLEMENT.SETTLEMENT.metric_results.IX_InvoiceMonthly	49484	btree					0	29296421	never	2026-10-19 03:00:05	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.metric_results.IX_StaffingDetail	49485	btree					347	29296421	2026-10-19T14:59:49.527837+00:00	2026-10-19 03:00:05	USED	keep — in use
SETTLEMENT.SETTLEMENT.metric_results.IX_BillingStaging	49488	btree					2200345	29296421	2026-10-19T17:56:21.1746+00:00	2026-10-19 03:00:05	USED	keep — in use
SETTLEMENT.SETTLEMENT.metric_results.IX_ShiftAudit	49489	btree					9	29296421	2026-10-19T03:04:00.397153+00:00	2026-10-19 03:00:05	USED	keep — in use
SETTLEMENT.SETTLEMENT.metric_results.IX_WarehouseSummary	49490	btree					0	29296421	never	2026-10-19 03:00:05	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.metric_results.IX_SalesDetail	49491	btree					96714098	29296421	2026-10-19T18:00:19.32761+00:00	2026-10-19 03:00:05	USED	keep — in use
SETTLEMENT.SETTLEMENT.metric_results.IX_BatchResult	49492	btree	Y	Y			43725	29296421	2026-10-19T17:58:06.622634+00:00	2026-10-19 03:00:05	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.ContractAudit.IX_OrdersAudit	47914	btree					2	9135574	2026-10-19T00:52:43.028023+00:00	2026-10-15 04:20:35	USED	keep — in use
SETTLEMENT.SETTLEMENT.SupplierMonthly.IX_CampaignAudit	49239	btree	Y	Y			90533	127640	2026-10-19T18:00:05.998778+00:00	2026-10-19 14:40:13	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.SettlementStatus.IX_QuotaQueue	49416	btree					0	225742	never	2026-10-19 17:56:14	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.SettlementStatus.IX_CatalogHistory	49420	btree	Y	Y			225742	225742	2026-10-19T17:59:57.648332+00:00	2026-10-19 17:56:14	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.TerritoryStaging.IX_RosterSnapshot	49398	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.SETTLEMENT.TerritoryStaging.IX_BookingHeader	49399	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.SETTLEMENT.reports.IX_PayrollLog	505334	btree					1	51673	2026-10-15T03:15:22.350712+00:00	2026-10-15 22:56:50	USED	keep — in use
SETTLEMENT.SETTLEMENT.reports.IX_MeterResult	505332	btree					21	51673	2026-10-15T03:15:22.350712+00:00	2026-10-15 22:56:50	USED	keep — in use
SETTLEMENT.SETTLEMENT.reports.IX_BillingDetail	505333	btree					9	51673	2026-10-12T00:53:18.993585+00:00	2026-10-15 22:56:50	USED	keep — in use
SETTLEMENT.SETTLEMENT.reports.IX_MeterQueue	473606	btree	Y	Y			34739	51673	2026-10-19T17:58:12.979475+00:00	2026-10-15 22:56:50	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.AssetAudit.IX_OrdersMonthly	285096	btree					2	17	2026-10-15T03:14:53.94353+00:00	never	USED	keep — in use
SETTLEMENT.SETTLEMENT.AssetAudit.IX_StaffingDetail	285094	btree	Y	Y			18	17	2026-10-19T04:06:01.369767+00:00	never	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.MeterDaily.IX_BookingStaging	49443	btree	Y	Y			1	1	2026-10-05T02:32:22.611244+00:00	never	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.ShiftHeader.IX_SettlementSummary	46624	btree					9	279993	2026-10-19T05:06:13.929856+00:00	2026-10-19 10:48:19	USED	keep — in use
SETTLEMENT.SETTLEMENT.ShiftHeader.IX_ContractSummary	46626	btree					1520	279993	2026-10-19T17:56:19.109815+00:00	2026-10-19 10:48:19	USED	keep — in use
SETTLEMENT.SETTLEMENT.ShiftHeader.IX_ReconcileHistory	46627	btree					1	279993	2026-10-19T02:20:41.330603+00:00	2026-10-19 10:48:19	USED	keep — in use
SETTLEMENT.SETTLEMENT.ShiftHeader.IX_InvoiceHistory	46631	btree	Y	Y			0	279993	never	2026-10-19 10:48:19	UNUSED	KEEP — primary key
SETTLEMENT.SETTLEMENT.RouteEntry.IX_CampaignLog	49357	btree					13	753	2026-10-19T04:06:00.950523+00:00	2026-10-16 10:24:59	USED	keep — in use
SETTLEMENT.SETTLEMENT.RouteEntry.IX_SupplierSummary	49358	btree					0	753	never	2026-10-16 10:24:59	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.RouteEntry.IX_ReconcileArchive	49362	btree	Y	Y			283774	753	2026-10-19T17:56:19.109815+00:00	2026-10-16 10:24:59	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.ClaimQueue.IX_MeterMonthly	35408	btree					134668	817421	2026-10-19T18:00:19.343299+00:00	2026-10-19 00:58:49	USED	keep — in use
SETTLEMENT.SETTLEMENT.ClaimQueue.IX_ShiftSummary	35410	btree					18	817421	2026-10-12T04:12:10.243238+00:00	2026-10-19 00:58:49	USED	keep — in use
SETTLEMENT.SETTLEMENT.ClaimQueue.IX_RouteEntry	35411	btree					602380	817421	2026-10-19T18:00:18.814922+00:00	2026-10-19 00:58:49	USED	keep — in use
SETTLEMENT.SETTLEMENT.ClaimQueue.IX_PolicyHistory	35412	btree	Y	Y			48084561	817421	2026-10-19T18:00:18.082583+00:00	2026-10-19 00:58:49	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.ClaimQueue.UX_RouteArchive	473551	btree	Y			Y	2	817421	2026-10-12T00:52:21.075631+00:00	2026-10-19 00:58:49	USED	keep — in use
SETTLEMENT.SETTLEMENT.BatchLine.IX_TicketHeader	46623	btree					1	761842	2026-10-16T08:36:59.330599+00:00	2026-10-19 10:26:11	USED	keep — in use
SETTLEMENT.SETTLEMENT.BatchLine.IX_BookingSnapshot	46630	btree					1	761842	2026-10-16T08:36:59.330599+00:00	2026-10-19 10:26:11	USED	keep — in use
SETTLEMENT.SETTLEMENT.BatchLine.IX_TicketDaily	46633	btree	Y	Y			0	761842	never	2026-10-19 10:26:11	UNUSED	KEEP — primary key
SETTLEMENT.SETTLEMENT.BatchLine.UX_LedgerQueue	46721	btree	Y				63800	761842	2026-10-19T18:00:06.087314+00:00	2026-10-19 10:26:11	USED	keep — in use
SETTLEMENT.SETTLEMENT.SupplierDaily.IX_BillingDaily	49356	btree					428073	14	2026-10-19T18:00:07.06282+00:00	never	USED	keep — in use
SETTLEMENT.SETTLEMENT.SupplierDaily.IX_SalesHistory	49359	btree	Y	Y			7	14	2026-10-10T04:03:28.175294+00:00	never	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_SettlementEntry	473580	btree					0	330	never	2026-10-19 06:53:06	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_CatalogArchive	473584	btree					0	330	never	2026-10-19 06:53:06	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_WarehouseMonthly	473582	btree					0	330	never	2026-10-19 06:53:06	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_ContractLine	473583	btree					428140	330	2026-10-19T18:00:06.166891+00:00	2026-10-19 06:53:06	USED	keep — in use
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_OrdersDaily	473579	btree					0	330	never	2026-10-19 06:53:06	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_CatalogSummary	473581	btree					0	330	never	2026-10-19 06:53:06	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_LedgerEntry	473572	btree	Y		Y		258898556	330	2026-10-19T18:00:06.003085+00:00	2026-10-19 06:53:06	USED	KEEP — constraint owns it
SETTLEMENT.SETTLEMENT.ReconcileArchive.IX_ShipmentAudit	473570	btree	Y	Y			263	330	2026-10-19T06:52:53.171903+00:00	2026-10-19 06:53:06	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.RouteLog.IX_InvoiceLine	47988	btree					67	200	2026-10-19T06:53:40.895302+00:00	2026-10-10 04:03:20	USED	keep — in use
SETTLEMENT.SETTLEMENT.RouteLog.IX_CustomerEntry	47995	btree					428079	200	2026-10-19T18:00:06.703782+00:00	2026-10-10 04:03:20	USED	keep — in use
SETTLEMENT.SETTLEMENT.RouteLog.IX_InvoiceHeader	47998	btree	Y	Y			1675	200	2026-10-19T06:54:03.912632+00:00	2026-10-10 04:03:20	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.PricingResult.IX_PolicyArchive	49297	btree					0	138	never	2026-10-15 00:27:25	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.PricingResult.IX_ForecastLog	49318	btree					0	138	never	2026-10-15 00:27:25	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.PricingResult.IX_MeterAudit	49319	btree					0	138	never	2026-10-15 00:27:25	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.PricingResult.IX_CampaignQueue	49321	btree	Y		Y		379	138	2026-10-19T06:53:53.845063+00:00	2026-10-15 00:27:25	USED	KEEP — constraint owns it
SETTLEMENT.SETTLEMENT.PricingResult.IX_ContractLine	49326	btree	Y	Y			67	138	2026-10-19T06:52:51.442801+00:00	2026-10-15 00:27:25	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.RouteHeader.IX_StaffingEntry	49237	btree					68107	113240	2026-10-19T18:00:18.212274+00:00	2026-10-18 20:50:48	USED	keep — in use
SETTLEMENT.SETTLEMENT.RouteHeader.IX_CampaignSummary	49238	btree					702190	113240	2026-10-19T18:00:07.791141+00:00	2026-10-18 20:50:48	USED	keep — in use
SETTLEMENT.SETTLEMENT.RouteHeader.IX_LedgerEntry	49261	btree	Y	Y			142260	113240	2026-10-19T18:00:11.376289+00:00	2026-10-18 20:50:48	USED	KEEP — primary key
SETTLEMENT.SETTLEMENT.SupplierLog.IX_ContractResult	314329	btree					88	132	2026-10-19T06:53:01.317969+00:00	2026-10-19 06:53:06	USED	keep — in use
SETTLEMENT.SETTLEMENT.SupplierLog.IX_ForecastLog	314328	btree					72	132	2026-10-19T06:53:57.414829+00:00	2026-10-19 06:53:06	USED	keep — in use
SETTLEMENT.SETTLEMENT.SupplierLog.IX_OrdersDaily	314319	btree	Y	Y			0	132	never	2026-10-19 06:53:06	UNUSED	KEEP — primary key
SETTLEMENT.SETTLEMENT.SupplierLog.IX_ForecastMonthly	314321	btree	Y		Y		0	132	never	2026-10-19 06:53:06	UNUSED	KEEP — constraint owns it
SETTLEMENT.SETTLEMENT.LedgerArchive.IX_SalesSnapshot	999876	btree					0	5	never	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.LedgerArchive.IX_ShipmentEntry	49401	btree					0	5	never	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.LedgerArchive.IX_PricingStaging	49402	btree					0	5	never	never	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.LedgerArchive.IX_ShiftStaging	49408	btree	Y	Y			0	5	never	never	UNUSED	KEEP — primary key
SETTLEMENT.SETTLEMENT.PolicyLine.IX_CustomerDetail	49361	btree					0	162	never	2026-10-16 02:00:50	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.PolicyLine.IX_OrdersDaily	49364	btree					0	162	never	2026-10-16 02:00:50	UNUSED	review, then DROP
SETTLEMENT.SETTLEMENT.PolicyLine.UQ_SupplierResult	49370	btree	Y		Y		0	162	never	2026-10-16 02:00:50	UNUSED	KEEP — constraint owns it
SETTLEMENT.SETTLEMENT.PolicyLine.IX_BatchResult	49372	btree	Y	Y			0	162	never	2026-10-16 02:00:50	UNUSED	KEEP — primary key
SETTLEMENT.SETTLEMENT.ShipmentMonthly.UX_ClaimSummary	49427	btree	Y			Y	0	6	never	never	UNUSED	review carefully — unique
SETTLEMENT.SETTLEMENT.ShipmentMonthly.IX_CampaignMonthly	49428	btree	Y	Y			0	6	never	never	UNUSED	KEEP — primary key
SETTLEMENT.report.PricingSummary.IX_ForecastEntry	305448	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.PricingSummary.IX_TicketArchive	305457	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.PricingSummary.IX_AssetEntry	305456	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.PricingSummary.UX_SupplierResult	305455	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
SETTLEMENT.report.QuotaHistory.IX_ShiftHistory	305463	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.SettlementDaily.IX_PricingEntry	305195	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.SettlementDaily.IX_BillingSnapshot	305197	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.SettlementDaily.IX_OrdersLog	305198	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.SettlementHistory.IX_AssetHeader	305249	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.SettlementHistory.UQ_WarehouseStaging	305251	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
SETTLEMENT.report.CampaignStaging.IX_SalesQueue	305322	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.CampaignStaging.UQ_MeterSnapshot	305324	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
SETTLEMENT.report.SettlementEntry.IX_StaffingDetail	305290	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.SettlementEntry.IX_WarehouseEntry	305298	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.SettlementEntry.IX_BillingResult	305299	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.SettlementEntry.UX_QuotaMonthly	305297	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
SETTLEMENT.report.StaffingResult.IX_CatalogDaily	305221	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.StaffingResult.IX_InvoiceDetail	305223	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
SETTLEMENT.report.StaffingResult.IX_OrdersQueue	305225	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.WarehouseDetail.IX_PayrollResult	304649	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.WarehouseDetail.IX_InvoiceHistory	304650	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.WarehouseDetail.IX_SettlementDaily	304651	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.WarehouseDetail.IX_CampaignSummary	304652	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.WarehouseDetail.IX_StaffingDetail	304647	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.TicketDetail.IX_BillingStaging	304658	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_PayrollSnapshot	305006	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_ReconcileStatus	305012	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_InvoiceMonthly	305011	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_StaffingDetail	305008	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_BillingStaging	305009	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_ShiftAudit	305010	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_WarehouseSummary	305007	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.metric_results.IX_BatchResult	305004	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.ContractAudit.IX_OrdersAudit	305018	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.SupplierMonthly.IX_CampaignAudit	304989	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.SettlementStatus.IX_QuotaQueue	304948	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.SettlementStatus.IX_CatalogHistory	304946	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.TerritoryStaging.IX_RosterSnapshot	304868	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.TerritoryStaging.IX_BookingHeader	304866	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.reports.IX_PayrollLog	305180	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.reports.IX_MeterResult	305178	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.reports.IX_BillingDetail	305179	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.reports.IX_MeterQueue	305171	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.AssetAudit.IX_OrdersMonthly	304849	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.AssetAudit.IX_StaffingDetail	304847	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.MeterDaily.IX_BookingStaging	304627	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.ShiftHeader.IX_SettlementSummary	305115	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ShiftHeader.IX_ContractSummary	305114	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ShiftHeader.IX_ReconcileHistory	305116	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ShiftHeader.IX_InvoiceHistory	305107	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.RouteEntry.IX_CampaignLog	305069	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.RouteEntry.IX_SupplierSummary	305070	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.RouteEntry.IX_ReconcileArchive	305067	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.ClaimQueue.IX_MeterMonthly	304691	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ClaimQueue.IX_ShiftSummary	304692	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ClaimQueue.IX_RouteEntry	304693	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ClaimQueue.IX_PolicyHistory	304689	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.BatchLine.IX_TicketHeader	305045	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.BatchLine.IX_BookingSnapshot	305044	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.BatchLine.IX_TicketDaily	305041	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.BatchLine.UX_LedgerQueue	305043	btree	Y				0	0	never	never	COLD	review carefully — unique
SETTLEMENT.report.SupplierDaily.IX_BillingDaily	304824	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.SupplierDaily.IX_SalesHistory	304822	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.ReconcileArchive.IX_SettlementEntry	305145	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_CatalogArchive	305149	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_WarehouseMonthly	305147	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_ContractLine	305148	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_OrdersDaily	305144	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_CatalogSummary	305146	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.ReconcileArchive.IX_BookingStaging	305137	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
SETTLEMENT.report.ReconcileArchive.IX_ClaimDetail	305135	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.RouteLog.IX_InvoiceLine	304770	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.RouteLog.IX_CustomerEntry	304769	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.RouteLog.IX_InvoiceHeader	304767	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.PricingResult.IX_PolicyArchive	304713	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.PricingResult.IX_ForecastLog	304712	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.PricingResult.IX_MeterAudit	304714	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.PricingResult.IX_CampaignQueue	304710	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
SETTLEMENT.report.PricingResult.IX_ContractLine	304708	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.RouteHeader.IX_StaffingEntry	304798	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.RouteHeader.IX_CampaignSummary	304797	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.RouteHeader.IX_LedgerEntry	304795	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.LedgerArchive.IX_ShipmentEntry	305427	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.LedgerArchive.IX_PricingStaging	305428	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.LedgerArchive.IX_ShiftStaging	305420	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.PolicyLine.IX_CustomerDetail	305400	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.PolicyLine.IX_OrdersDaily	305399	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.report.PolicyLine.UQ_SupplierResult	305392	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
SETTLEMENT.report.PolicyLine.IX_BatchResult	305390	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.report.ShipmentMonthly.UX_ClaimSummary	305366	btree	Y			Y	0	0	never	never	COLD	review carefully — unique
SETTLEMENT.report.ShipmentMonthly.IX_CampaignMonthly	305364	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.dbabrain.PricingSummary.IX_ForecastEntry	344543	btree	Y	Y			16	0	2026-10-02T09:32:40.413349+00:00	never	USED	KEEP — primary key
SETTLEMENT.dbabrain.PricingSummary.IX_TicketArchive	344552	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.dbabrain.PricingSummary.IX_AssetEntry	344551	btree					526651	0	2026-10-07T10:30:07.048329+00:00	never	USED	keep — in use
SETTLEMENT.dbabrain.PricingSummary.UX_SupplierResult	344550	btree	Y			Y	263327	0	2026-10-07T10:30:06.713807+00:00	never	USED	keep — in use
SETTLEMENT.dbabrain.QuotaHistory.IX_ShiftHistory	344558	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.dbabrain.SettlementDaily.IX_PricingEntry	344290	btree	Y	Y			17	49	2026-10-05T00:36:09.464027+00:00	never	USED	KEEP — primary key
SETTLEMENT.dbabrain.SettlementDaily.IX_BillingSnapshot	344292	btree					0	49	never	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.SettlementDaily.IX_OrdersLog	344293	btree					0	49	never	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.CampaignStaging.IX_SalesQueue	344417	btree	Y	Y			16	94	2026-10-02T09:32:40.413349+00:00	never	USED	KEEP — primary key
SETTLEMENT.dbabrain.CampaignStaging.UQ_MeterSnapshot	344419	btree	Y		Y		0	94	never	never	UNUSED	KEEP — constraint owns it
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.SettlementEntry.IX_BillingResult	344394	btree					0	94	never	2026-10-02 13:06:25	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.StaffingResult.IX_InvoiceDetail	344318	btree	Y		Y		0	270	never	2026-10-02 13:23:26	UNUSED	KEEP — constraint owns it
SETTLEMENT.dbabrain.StaffingResult.IX_OrdersQueue	344320	btree					0	270	never	2026-10-02 13:23:26	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.TicketDetail.IX_BillingStaging	343710	btree					0	308224	never	2026-10-07 01:07:27	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.metric_results.IX_ReconcileStatus	344107	btree					0	4804692	never	2026-10-07 09:26:16	UNUSED	review, then DROP
SETTLEMENT.dbabrain.metric_results.IX_InvoiceMonthly	344106	btree					0	4804692	never	2026-10-07 09:26:16	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.metric_results.IX_ShiftAudit	344105	btree					0	4804692	never	2026-10-07 09:26:16	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.ContractAudit.IX_OrdersAudit	344113	btree					0	0	never	never	COLD	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.SettlementStatus.IX_QuotaQueue	344043	btree					0	48695	never	2026-10-07 10:28:13	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.TerritoryStaging.IX_RosterSnapshot	343963	btree					0	96	never	2026-09-30 09:39:47	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.reports.IX_BillingDetail	870101	btree					0	20204	never	2026-10-07 05:47:10	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.AssetAudit.IX_OrdersMonthly	343944	btree					2	14	2026-10-05T01:35:47.434049+00:00	never	USED	keep — in use
SETTLEMENT.dbabrain.AssetAudit.IX_StaffingDetail	343942	btree	Y	Y			14	14	2026-10-07T01:19:12.995986+00:00	never	USED	KEEP — primary key
SETTLEMENT.dbabrain.MeterDaily.IX_BookingStaging	343679	btree	Y	Y			40	40	2026-10-02T09:32:40.805729+00:00	never	USED	KEEP — primary key
SETTLEMENT.dbabrain.ShiftHeader.IX_SettlementSummary	344210	btree					0	7497	never	2026-10-04 11:34:03	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.ShiftHeader.IX_ReconcileHistory	344211	btree					0	7497	never	2026-10-04 11:34:03	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.RouteEntry.IX_SupplierSummary	344165	btree					0	153	never	2026-10-02 06:55:16	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.ClaimQueue.IX_ShiftSummary	343744	btree					0	160088	never	2026-10-07 04:51:10	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.BatchLine.IX_TicketHeader	344140	btree					0	86949	never	2026-10-04 23:02:23	UNUSED	review, then DROP
SETTLEMENT.dbabrain.BatchLine.IX_BookingSnapshot	344139	btree					0	86949	never	2026-10-04 23:02:23	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.ReconcileArchive.IX_CatalogArchive	862242	btree					0	336	never	2026-10-06 07:27:53	UNUSED	review, then DROP
SETTLEMENT.dbabrain.ReconcileArchive.IX_WarehouseMonthly	862240	btree					0	336	never	2026-10-06 07:27:53	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.ReconcileArchive.IX_OrdersDaily	862237	btree					0	336	never	2026-10-06 07:27:53	UNUSED	review, then DROP
SETTLEMENT.dbabrain.ReconcileArchive.IX_CatalogSummary	862239	btree					0	336	never	2026-10-06 07:27:53	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.RouteLog.IX_InvoiceLine	343822	btree					0	9	never	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.RouteLog.IX_CustomerEntry	343821	btree					0	9	never	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.RouteLog.IX_InvoiceHeader	343819	btree	Y	Y			18	9	2026-10-02T14:01:50.126813+00:00	never	USED	KEEP — primary key
SETTLEMENT.dbabrain.PricingResult.IX_PolicyArchive	343765	btree					0	86	never	2026-10-05 05:38:31	UNUSED	review, then DROP
SETTLEMENT.dbabrain.PricingResult.IX_ForecastLog	343764	btree					0	86	never	2026-10-05 05:38:31	UNUSED	review, then DROP
SETTLEMENT.dbabrain.PricingResult.IX_MeterAudit	343766	btree					0	86	never	2026-10-05 05:38:31	UNUSED	review, then DROP
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.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
SETTLEMENT.dbabrain.SupplierLog.IX_ForecastMonthly	343857	btree	Y		Y		0	706	never	2026-10-06 07:27:53	UNUSED	KEEP — constraint owns it
SETTLEMENT.dbabrain.LedgerArchive.IX_SalesSnapshot	870103	btree					4	4	2026-10-03T07:14:28.054022+00:00	never	USED	keep — in use
SETTLEMENT.dbabrain.LedgerArchive.IX_ShipmentEntry	344522	btree					0	4	never	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.LedgerArchive.IX_PricingStaging	344523	btree					0	4	never	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.LedgerArchive.IX_ShiftStaging	344515	btree	Y	Y			16	4	2026-10-02T09:32:40.413349+00:00	never	USED	KEEP — primary key
SETTLEMENT.dbabrain.PolicyLine.IX_CustomerDetail	344495	btree					0	33	never	never	UNUSED	review, then DROP
SETTLEMENT.dbabrain.PolicyLine.IX_OrdersDaily	344494	btree					1	33	2026-10-03T07:14:29.045624+00:00	never	USED	keep — in use
SETTLEMENT.dbabrain.PolicyLine.UQ_SupplierResult	344487	btree	Y		Y		28	33	2026-10-03T09:02:51.807705+00:00	never	USED	KEEP — constraint owns it
SETTLEMENT.dbabrain.PolicyLine.IX_BatchResult	344485	btree	Y	Y			46	33	2026-10-03T09:02:51.938364+00:00	never	USED	KEEP — primary key
SETTLEMENT.dbabrain.ShipmentMonthly.UX_ClaimSummary	344461	btree	Y			Y	46	5	2026-10-07T01:19:23.333547+00:00	never	USED	keep — in use
SETTLEMENT.dbabrain.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					1	564	2026-10-15T01:07:23.133718+00:00	2026-10-14 09:14:50	USED	keep — in use
drs.drs.InvoiceHistory.PK_ShipmentLine	1085268	btree	Y	Y			3	564	2026-10-15T00:37:33.8478+00:00	2026-10-14 09:14:50	USED	KEEP — primary key
drs.drs.OrdersLine.IX_CatalogHeader	1085251	btree	Y	Y			11	12	2026-10-15T03:18:24.321252+00:00	never	USED	KEEP — primary key
drs.drs.AssetQueue.IX_ReconcileLog	1085287	btree					1	148	2026-10-15T01:07:23.133718+00:00	2026-10-14 09:09:50	USED	keep — in use
drs.drs.AssetQueue.PK_WarehouseLog	1085285	btree	Y	Y			4	148	2026-10-15T07:55:31.995566+00:00	2026-10-14 09:09:50	USED	KEEP — primary key
drs.drs.RouteStatus.PK_ForecastLine	1085722	btree	Y	Y			146	105	2026-10-10T08:33:34.766165+00:00	2026-10-15 09:41:08	USED	KEEP — primary key
drs.drs.AssetSnapshot.PK_BatchHistory	1085307	btree	Y	Y			1313	8	2026-10-19T06:43:03.960541+00:00	never	USED	KEEP — primary key
drs.drs.AssetSnapshot.UQ_ForecastSummary	1085309	btree	Y		Y		62	8	2026-10-15T07:58:54.786387+00:00	never	USED	KEEP — constraint owns it
drs.drs.StaffingLog.PK_SettlementDetail	1234756	btree	Y	Y			9	3	2026-10-15T07:42:59.669988+00:00	never	USED	KEEP — primary key
drs.drs.StaffingLog.UQ_PayrollDaily	1234773	btree	Y			Y	0	3	never	never	UNUSED	review carefully — unique
drs.drs.StaffingLog.UQ_PayrollLine	1234774	btree	Y			Y	82	3	2026-10-19T06:42:58.410536+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	622	4	2026-10-19T06:42:58.410536+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	437	12	2026-10-16T03:54:53.199926+00:00	never	USED	keep — in use
drs.drs.CustomerArchive.PK_ShipmentDetail	1085429	btree	Y	Y			565	19	2026-10-16T09:15:28.278966+00:00	never	USED	KEEP — primary key
drs.drs.CustomerArchive.UQ_MeterStatus	1085431	btree	Y		Y		1237	19	2026-10-16T09:15:28.293614+00:00	never	USED	KEEP — constraint owns it
drs.drs.BatchSnapshot.PK_CampaignResult	1498641	btree	Y	Y			18	1	2026-10-16T09:15:28.284206+00:00	never	USED	KEEP — primary key
drs.drs.CampaignLine.PK_QuotaSnapshot	1498661	btree	Y	Y			2	0	2026-10-15T08:10:43.416143+00:00	never	USED	KEEP — primary key
drs.drs.BatchLog.IX_MeterSummary	1085559	btree	Y				256	41	2026-10-16T09:15:25.443984+00:00	never	USED	keep — in use
drs.drs.BatchLog.PK_ForecastHistory	1085552	btree	Y	Y			11	41	2026-10-07T03:16:51.611405+00:00	never	USED	KEEP — primary key
drs.drs.TerritorySnapshot.IX_SalesStaging	1234800	btree					30	20	2026-10-19T06:42:58.410536+00:00	never	USED	keep — in use
drs.drs.TerritorySnapshot.IX_SalesStatus	1234801	btree					28	20	2026-10-16T09:15:25.443984+00:00	never	USED	keep — in use
drs.drs.TerritorySnapshot.PK_MeterSummary	1234793	btree	Y	Y			74	20	2026-10-15T09:44:30.087238+00:00	never	USED	KEEP — primary key
drs.drs.TerritorySnapshot.UQ_ShiftMonthly	1234802	btree	Y			Y	4	20	2026-10-15T07:55:06.526681+00:00	never	USED	keep — in use
drs.drs.CatalogHistory.PK_PolicyDaily	1085325	btree	Y	Y			2280	4	2026-10-19T06:43:03.960541+00:00	never	USED	KEEP — primary key
drs.drs.CatalogHistory.UQ_PayrollSummary	1085327	btree	Y		Y		70	4	2026-10-15T07:58:54.786387+00:00	never	USED	KEEP — constraint owns it
drs.drs.RouteHeader.PK_TerritoryArchive	1085568	btree	Y	Y			52	500	2026-10-08T01:55:37.168574+00:00	2026-10-15 09:40:08	USED	KEEP — primary key
drs.drs.LedgerStatus.IX_MeterArchive	1085610	btree	Y				1100	15	2026-10-19T06:42:58.410536+00:00	never	USED	keep — in use
drs.drs.LedgerStatus.PK_ClaimStaging	1085598	btree	Y	Y			28	15	2026-10-07T08:42:04.270264+00:00	never	USED	KEEP — primary key
drs.drs.TerritoryStatus.IX_ClaimSnapshot	1085627	btree	Y				568	0	2026-10-16T09:15:28.284206+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					188	149	2026-10-16T09:15:28.282812+00:00	2026-10-14 09:14:50	USED	keep — in use
drs.drs.SettlementHeader.IX_RouteStaging	1085655	btree					299	149	2026-10-14T09:14:44.710769+00:00	2026-10-14 09:14:50	USED	keep — in use
drs.drs.SettlementHeader.PK_InvoiceDaily	1085647	btree	Y	Y			192	149	2026-10-15T03:18:45.427731+00:00	2026-10-14 09:14:50	USED	KEEP — primary key
drs.drs.MeterResult.IX_TicketSummary	1085678	btree					0	62	never	2026-10-15 06:28:05	UNUSED	review, then DROP
drs.drs.MeterResult.IX_PricingDaily	1085679	btree					0	62	never	2026-10-15 06:28:05	UNUSED	review, then DROP
drs.drs.MeterResult.IX_SupplierAudit	1085680	btree					3	62	2026-10-15T07:58:54.786387+00:00	2026-10-15 06:28:05	USED	keep — in use
drs.drs.MeterResult.PK_PricingLine	1085676	btree	Y	Y			0	62	never	2026-10-15 06:28:05	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	261	2026-10-07T05:30:15.39099+00:00	2026-10-16 06:32:29	USED	KEEP — primary key
drs.drs.CustomerStatus.IX_SettlementHeader	1501506	btree	Y				0	84	never	2026-10-10 07:15:08	UNUSED	review carefully — unique
drs.drs.CustomerStatus.PK_TerritoryMonthly	1085363	btree	Y	Y			1051	84	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	84	never	2026-10-10 07:15:08	UNUSED	KEEP — constraint owns it
drs.drs.CustomerStatus.UQ_WarehouseSummary	1085367	btree	Y		Y		355	84	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			407	0	2026-10-16T09:15:28.293614+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			44586	87	2026-10-16T09:15:11.09535+00:00	2026-10-07 05:52:54	USED	KEEP — primary key
drs.dbo.OrdersQueue.IX_BatchLine	1092887	btree	Y		Y		0	237	never	2026-10-07 05:52:54	UNUSED	KEEP — constraint owns it
drs.dbo.OrdersQueue.IX_ContractHistory	1092889	btree	Y	Y			19582	237	2026-10-16T09:15:11.09535+00:00	2026-10-07 05:52:54	USED	KEEP — primary key
drs.dbo.OrdersQueue.IX_CustomerArchive	1093051	btree					40004	237	2026-10-16T09:15:11.09535+00:00	2026-10-07 05:52:54	USED	keep — in use
drs.dbo.OrdersQueue.IX_RouteStaging	1093069	btree					40004	237	2026-10-16T09:15:11.09535+00:00	2026-10-07 05:52:54	USED	keep — in use
drs.dbo.OrdersSummary.IX_RosterArchive	1092891	btree	Y		Y		10509	572	2026-10-16T09:15:11.09535+00:00	2026-10-07 05:52:54	USED	KEEP — constraint owns it
drs.dbo.OrdersSummary.IX_ShiftStatus	1092893	btree	Y	Y			0	572	never	2026-10-07 05:52:54	UNUSED	KEEP — primary key
drs.dbo.OrdersSummary.IX_InvoiceLine	1093052	btree					50905	572	2026-10-16T09:15:11.09535+00:00	2026-10-07 05:52:54	USED	keep — in use
drs.dbo.OrdersSummary.IX_TerritoryLog	1093053	btree					3378	572	2026-10-16T09:15:11.09535+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			1861	9	2026-10-16T01:02:27.608497+00:00	never	USED	KEEP — primary key
drs.dbo.QuotaArchive.IX_OrdersDaily	1092905	btree	Y		Y		0	344	never	2026-10-15 08:04:06	UNUSED	KEEP — constraint owns it
drs.dbo.QuotaArchive.IX_SupplierMonthly	1092911	btree	Y	Y			1360	344	2026-10-15T09:43:28.727372+00:00	2026-10-15 08:04:06	USED	KEEP — primary key
drs.dbo.QuotaArchive.IX_ForecastDaily	1092917	btree	Y		Y		0	344	never	2026-10-15 08:04:06	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	105	never	2026-10-07 05:52:54	UNUSED	KEEP — constraint owns it
drs.dbo.LedgerStatus.IX_CustomerLine	1092921	btree	Y	Y			84644	105	2026-10-16T09:15:11.09535+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	25	never	never	UNUSED	KEEP — primary key
drs.dbo.BatchStatus.UQ_ContractStaging	1093021	btree	Y		Y		434	25	2026-10-15T09:43:28.727372+00:00	never	USED	KEEP — constraint owns it
drs.dbo.SettlementEntry.IX_StaffingHistory	1092939	btree	Y	Y			0	9	never	never	UNUSED	KEEP — primary key
drs.dbo.AssetHistory.IX_ContractHistory	1092941	btree	Y	Y			198	37	2026-10-15T09:43:28.727372+00:00	never	USED	KEEP — primary key
drs.dbo.AssetHistory.IX_BillingHeader	1092959	btree	Y		Y		0	37	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.AssetHistory.UQ_ClaimDetail	1093023	btree	Y		Y		0	37	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	162	never	2026-10-15 08:04:06	UNUSED	review, then DROP
drs.dbo.MeterDetail.IX_BatchSnapshot	1093073	btree	Y				98	162	2026-10-15T09:40:20.001286+00:00	2026-10-15 08:04:06	USED	keep — in use
drs.dbo.MeterDetail.IX_CustomerHeader	1092961	btree	Y	Y			25	162	2026-10-15T08:13:51.617253+00:00	2026-10-15 08:04:06	USED	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					31	5398	2026-10-15T09:43:28.063989+00:00	2026-10-15 08:09:07	USED	keep — in use
drs.dbo.logs.IX_PayrollStaging	1092965	btree	Y	Y			0	5398	never	2026-10-15 08:09:07	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	19	never	never	UNUSED	KEEP — primary key
drs.dbo.WarehouseStaging.IX_BillingMonthly	1092987	btree	Y	Y			0	24	never	never	UNUSED	KEEP — primary key
drs.dbo.WarehouseStaging.UQ_BookingLine	1093033	btree	Y		Y		0	24	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.ContractQueue.IX_CampaignLine	1092989	btree	Y	Y			0	5	never	never	UNUSED	KEEP — primary key
drs.dbo.ContractQueue.UQ_CustomerSummary	1093035	btree	Y		Y		0	5	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.ContractQueue.UQ_QuotaAudit	1093037	btree	Y		Y		0	5	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.RosterArchive.IX_TicketSummary	1092991	btree	Y	Y			0	5	never	never	UNUSED	KEEP — primary key
drs.dbo.CatalogLine.IX_OrdersDaily	1093082	btree	Y				1789	0	2026-10-15T09:43:37.424688+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	121	never	2026-10-15 07:59:06	UNUSED	KEEP — primary key
drs.dbo.CatalogResult.UQ_InvoiceHistory	1093039	btree	Y		Y		0	121	never	2026-10-15 07:59:06	UNUSED	KEEP — constraint owns it
drs.dbo.CatalogResult.UQ_CampaignDetail	1093041	btree	Y		Y		0	121	never	2026-10-15 07:59:06	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	13	never	never	UNUSED	KEEP — constraint owns it
drs.dbo.tables.IX_CampaignMonthly	1093001	btree	Y	Y			437	13	2026-10-15T09:43:28.727372+00:00	never	USED	KEEP — primary key
drs.dbo.tables.UQ_LedgerStaging	1093043	btree	Y		Y		0	13	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					690	0	2026-10-15T09:43:28.727372+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
BILLING.public.acl.IX_TerritoryEntry	1449821	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.acl.IX_RosterDaily	1449819	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.OrdersDaily.IX_MeterArchive	1449833	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.WarehouseDetail.IX_PricingStaging	1449872	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.WarehouseDetail.IX_ContractMonthly	1449870	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.activity.IX_PayrollStaging	1449848	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.activity.IX_ShiftArchive	1449850	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.article.IX_QuotaStaging	1450514	btree					0	6	never	never	UNUSED	review, then DROP
BILLING.public.article.IX_CampaignStaging	1450515	btree					0	6	never	never	UNUSED	review, then DROP
BILLING.public.article.IX_ShiftMonthly	1450512	btree	Y	Y			35	6	2026-10-14T01:51:06.416923+00:00	never	USED	KEEP — primary key
BILLING.public.article.IX_PayrollLine	1450516	btree					5790	6	2026-10-18T02:10:12.5312+00:00	never	USED	keep — in use
BILLING.public.article.IX_SalesStatus	1450517	btree					41	6	2026-10-19T06:00:47.886713+00:00	never	USED	keep — in use
BILLING.public.RosterMonthly.IX_PolicyEntry	1450534	btree					81	5	2026-10-19T06:00:26.447865+00:00	never	USED	keep — in use
BILLING.public.RosterMonthly.IX_PayrollEntry	1450535	btree					0	5	never	never	UNUSED	review, then DROP
BILLING.public.RosterMonthly.IX_ReconcileResult	1450532	btree	Y	Y			2	5	2026-10-14T01:50:07.165649+00:00	never	USED	KEEP — primary key
BILLING.public.OrdersAudit.IX_WarehouseDetail	1450583	btree					90	2	2026-10-19T05:59:57.191049+00:00	never	USED	keep — in use
BILLING.public.OrdersAudit.IX_RosterDetail	1450581	btree	Y	Y			22	2	2026-10-19T05:59:57.191049+00:00	never	USED	KEEP — primary key
BILLING.public.CampaignLine.IX_ReconcileLine	1450567	btree					0	3	never	never	UNUSED	review, then DROP
BILLING.public.CampaignLine.IX_OrdersMonthly	1450565	btree	Y	Y			0	3	never	never	UNUSED	KEEP — primary key
BILLING.public.TerritoryMonthly.IX_ShipmentQueue	1450594	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.TerritoryMonthly.IX_SupplierQueue	1450596	btree					29	0	2026-10-19T05:59:57.191049+00:00	never	USED	keep — in use
BILLING.public.TerritoryMonthly.IX_PayrollLine	1450597	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.BookingMonthly.IX_MeterResult	1450614	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.BookingMonthly.IX_TicketResult	1450612	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.AssetAudit.IX_SettlementQueue	1450473	btree					0	4	never	never	UNUSED	review, then DROP
BILLING.public.AssetAudit.IX_InvoiceSummary	1450474	btree					33	4	2026-10-19T06:00:00.199757+00:00	never	USED	keep — in use
BILLING.public.AssetAudit.IX_ShipmentSnapshot	1450471	btree	Y	Y			0	4	never	never	UNUSED	KEEP — primary key
BILLING.public.PayrollMonthly.IX_CatalogEntry	1450549	btree					5	28	2026-10-14T01:51:06.416923+00:00	never	USED	keep — in use
BILLING.public.PayrollMonthly.IX_CustomerHeader	1450547	btree	Y	Y			0	28	never	never	UNUSED	KEEP — primary key
BILLING.public.PayrollMonthly.IX_AssetHeader	1450550	btree					0	28	never	never	UNUSED	review, then DROP
BILLING.public.ContractResult.IX_TerritoryLine	1450459	btree	Y		Y		3	3	2026-10-19T06:00:47.886713+00:00	never	USED	KEEP — constraint owns it
BILLING.public.ContractResult.IX_CustomerQueue	1450457	btree	Y	Y			2	3	2026-10-14T01:50:07.165649+00:00	never	USED	KEEP — primary key
BILLING.public.ForecastAudit.IX_BatchAudit	1450734	btree	Y		Y		0	4	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.ForecastAudit.IX_MeterAudit	1450732	btree	Y	Y			0	4	never	never	UNUSED	KEEP — primary key
BILLING.public.CatalogHeader.IX_RosterDaily	1450714	btree	Y		Y		2	5	2026-10-14T01:50:07.165649+00:00	never	USED	KEEP — constraint owns it
BILLING.public.CatalogHeader.IX_ShipmentDaily	1450712	btree	Y	Y			0	5	never	never	UNUSED	KEEP — primary key
BILLING.public.calendar.IX_InvoiceEntry	1451665	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.calendar.IX_RouteDaily	1451663	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.AssetDetail.IX_PolicyDetail	1451680	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.OrdersEntry.IX_SupplierDaily	1451696	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.OrdersEntry.IX_SalesDaily	1451698	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.RouteSnapshot.IX_PolicyAudit	1451714	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.RouteSnapshot.IX_ContractDaily	1451715	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.RouteSnapshot.IX_ContractMonthly	1451712	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.RouteSnapshot.IX_LedgerSummary	1451710	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.RouteSnapshot.IX_ForecastLog	1451716	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.RouteSnapshot.IX_TerritoryLine	1451717	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.OrdersDaily.IX_SupplierSnapshot	1450494	btree	Y		Y		4	4	2026-10-14T01:21:34.973733+00:00	never	USED	KEEP — constraint owns it
BILLING.public.OrdersDaily.IX_MeterHeader	1450492	btree	Y	Y			3	4	2026-10-14T01:50:07.165649+00:00	never	USED	KEEP — primary key
BILLING.public.InvoiceDetail.IX_ClaimArchive	1451764	btree					0	1745	never	2026-10-17 20:41:08	UNUSED	review, then DROP
BILLING.public.InvoiceDetail.IX_BillingAudit	1451762	btree	Y	Y			1069	1745	2026-10-18T02:10:12.849548+00:00	2026-10-17 20:41:08	USED	KEEP — primary key
BILLING.public.InvoiceDetail.IX_RouteResult	1451765	btree					48	1745	2026-10-17T03:00:16.5518+00:00	2026-10-17 20:41:08	USED	keep — in use
BILLING.public.InvoiceDetail.IX_BookingResult	1451766	btree					4	1745	2026-10-14T03:00:13.164282+00:00	2026-10-17 20:41:08	USED	keep — in use
BILLING.public.InvoiceDetail.IX_PolicyLog	1451767	btree					0	1745	never	2026-10-17 20:41:08	UNUSED	review, then DROP
BILLING.public.ReconcileSummary.IX_SettlementAudit	1451807	btree	Y	Y			0	3	never	never	UNUSED	KEEP — primary key
BILLING.public.ReconcileSummary.IX_ShipmentDaily	1451809	btree					14	3	2026-10-19T05:59:57.191049+00:00	never	USED	keep — in use
BILLING.public.PayrollQueue.IX_InvoiceLog	1451780	btree					26	1170	2026-10-14T05:00:05.173117+00:00	2026-10-17 22:01:08	USED	keep — in use
BILLING.public.PayrollQueue.IX_InvoiceLog	1451778	btree	Y	Y			822	1170	2026-10-19T05:59:57.191049+00:00	2026-10-17 22:01:08	USED	KEEP — primary key
BILLING.public.PayrollQueue.IX_ContractStaging	1451781	btree					1	1170	2026-10-14T01:38:51.495018+00:00	2026-10-17 22:01:08	USED	keep — in use
BILLING.public.CampaignArchive.IX_TerritoryLine	1451797	btree					0	690	never	2026-10-17 11:51:04	UNUSED	review, then DROP
BILLING.public.CampaignArchive.IX_ShiftAudit	1451795	btree	Y	Y			0	690	never	2026-10-17 11:51:04	UNUSED	KEEP — primary key
BILLING.public.PricingSnapshot.IX_AssetStaging	1450900	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.PricingSnapshot.IX_StaffingAudit	1450898	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.SupplierQueue.IX_TicketLine	1450883	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.SupplierQueue.IX_ShiftHistory	1450885	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.PayrollResult.IX_TicketResult	1450871	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.PayrollResult.IX_ClaimSummary	1450869	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.MeterArchive.IX_OrdersResult	1450916	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.MeterArchive.IX_BatchSummary	1450914	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.MeterArchive.IX_CustomerLine	1450917	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.TicketSummary.IX_OrdersLine	1451336	btree	Y		Y		0	5	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.TicketSummary.IX_BookingArchive	1451334	btree	Y	Y			495	5	2026-10-19T05:58:36.387607+00:00	never	USED	KEEP — primary key
BILLING.public.BookingLog.IX_QuotaMonthly	1451346	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.BookingLog.IX_ShipmentQueue	1451348	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.ForecastLine.IX_ClaimMonthly	1451310	btree					55	0	2026-10-19T06:00:47.886713+00:00	never	USED	keep — in use
BILLING.public.ForecastLine.IX_RouteHeader	1451308	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ForecastLine.IX_BillingLine	1451311	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.ForecastLine.IX_CatalogHeader	1451312	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.ForecastLine.IX_TerritoryDaily	1451313	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.ContractHistory.IX_PolicyDetail	1450155	btree	Y		Y		0	3	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.ContractHistory.IX_SettlementResult	1450153	btree	Y	Y			0	3	never	never	UNUSED	KEEP — primary key
BILLING.public.InvoiceEntry.IX_ReconcileStaging	1451828	btree					8	0	2026-10-19T05:59:32.331267+00:00	never	USED	keep — in use
BILLING.public.InvoiceEntry.IX_SupplierDetail	1451826	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.CampaignAudit.IX_InvoiceStaging	1450968	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.CampaignAudit.IX_CampaignQueue	1450966	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.BillingEntry.IX_SupplierArchive	1451263	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.BillingEntry.IX_ContractHeader	1451265	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.BillingEntry.IX_AssetStatus	1451261	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ShipmentMonthly.IX_WarehouseAudit	1451280	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.ShipmentMonthly.IX_ReconcileDetail	1451281	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.ShipmentMonthly.IX_RouteLog	1451278	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.CustomerSummary.IX_ContractSummary	1451230	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.CustomerSummary.IX_SettlementLog	1451228	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ClaimLine.IX_CatalogLine	1451249	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.ClaimLine.IX_TicketHistory	1451247	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.StaffingDaily.IX_StaffingArchive	1450009	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.StaffingDaily.IX_WarehouseMonthly	1450010	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.StaffingDaily.IX_ShiftMonthly	1450007	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.OrdersQueue.IX_PayrollAudit	1449990	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.OrdersQueue.IX_ClaimAudit	1449988	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.OrdersQueue.IX_LedgerEntry	1449991	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.TicketMonthly.IX_ForecastResult	1449972	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.TicketMonthly.IX_InvoiceDaily	1449970	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.TicketMonthly.IX_InvoiceArchive	1449973	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.QuotaHeader.IX_LedgerStaging	1449954	btree					0	7	never	never	UNUSED	review, then DROP
BILLING.public.QuotaHeader.IX_SalesResult	1449952	btree	Y	Y			0	7	never	never	UNUSED	KEEP — primary key
BILLING.public.QuotaHeader.IX_CustomerResult	1449955	btree					4	7	2026-10-14T01:47:01.899897+00:00	never	USED	keep — in use
BILLING.public.CustomerLine.IX_BookingAudit	1451102	btree	Y		Y		3	1	2026-10-14T01:30:37.802735+00:00	never	USED	KEEP — constraint owns it
BILLING.public.CustomerLine.IX_ShipmentDetail	1451100	btree	Y	Y			0	1	never	never	UNUSED	KEEP — primary key
BILLING.public.BookingStaging.IX_SupplierStaging	1451122	btree					3	0	2026-10-14T01:50:07.165649+00:00	never	USED	keep — in use
BILLING.public.BookingStaging.IX_TerritoryHistory	1451123	btree					3	0	2026-10-14T01:50:07.165649+00:00	never	USED	keep — in use
BILLING.public.BookingStaging.IX_TicketSnapshot	1451118	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.BookingStaging.IX_RosterDaily	1451120	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.QuotaStatus.IX_ShiftSummary	1451091	btree	Y		Y		1	2	2026-10-14T01:30:37.802735+00:00	never	USED	KEEP — constraint owns it
BILLING.public.QuotaStatus.IX_SalesSnapshot	1451089	btree	Y	Y			0	2	never	never	UNUSED	KEEP — primary key
BILLING.public.MeterHeader.IX_PolicyEntry	1451075	btree	Y		Y		1	2	2026-10-14T01:30:37.802735+00:00	never	USED	KEEP — constraint owns it
BILLING.public.MeterHeader.IX_ClaimSnapshot	1451073	btree	Y	Y			0	2	never	never	UNUSED	KEEP — primary key
BILLING.public.PolicySummary.IX_SalesHeader	1450939	btree	Y	Y			1	1	2026-10-14T01:26:30.963251+00:00	never	USED	KEEP — primary key
BILLING.public.LedgerHeader.IX_QuotaSnapshot	1451745	btree	Y		Y		29	3	2026-10-19T05:59:57.191049+00:00	never	USED	KEEP — constraint owns it
BILLING.public.LedgerHeader.IX_CampaignSnapshot	1451749	btree					0	3	never	never	UNUSED	review, then DROP
BILLING.public.LedgerHeader.IX_ReconcileAudit	1451747	btree	Y		Y		1	3	2026-10-14T01:38:26.518863+00:00	never	USED	KEEP — constraint owns it
BILLING.public.LedgerHeader.IX_ShiftHistory	1451743	btree	Y	Y			2	3	2026-10-14T01:38:51.495018+00:00	never	USED	KEEP — primary key
BILLING.public.AssetDaily.IX_SalesDaily	1451893	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.AssetDaily.IX_QuotaEntry	1451891	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.AssetDaily.IX_TicketArchive	1451894	btree					37	0	2026-10-19T06:00:00.199757+00:00	never	USED	keep — in use
BILLING.public.AssetDaily.IX_CatalogSnapshot	1451895	btree					211	0	2026-10-19T06:00:47.886713+00:00	never	USED	keep — in use
BILLING.public.AssetEntry.IX_SalesLog	1451026	btree	Y		Y		0	16	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.AssetEntry.IX_LedgerEntry	1451024	btree	Y	Y			51	16	2026-10-19T04:06:37.931482+00:00	never	USED	KEEP — primary key
BILLING.public.RosterSnapshot.IX_ReconcileLine	1451058	btree					0	117	never	2026-10-14 01:07:56	UNUSED	review, then DROP
BILLING.public.RosterSnapshot.IX_BatchEntry	1451059	btree					0	117	never	2026-10-14 01:07:56	UNUSED	review, then DROP
BILLING.public.RosterSnapshot.IX_ClaimAudit	1451060	btree					0	117	never	2026-10-14 01:07:56	UNUSED	review, then DROP
BILLING.public.RosterSnapshot.IX_PolicyQueue	1451056	btree	Y	Y			0	117	never	2026-10-14 01:07:56	UNUSED	KEEP — primary key
BILLING.public.SalesDetail.IX_CatalogHeader	1451045	btree					0	114	never	2026-10-14 01:07:56	UNUSED	review, then DROP
BILLING.public.SalesDetail.IX_WarehouseHistory	1451046	btree					3	114	2026-10-14T01:22:37.788641+00:00	2026-10-14 01:07:56	USED	keep — in use
BILLING.public.SalesDetail.IX_CampaignQueue	1451043	btree	Y		Y		0	114	never	2026-10-14 01:07:56	UNUSED	KEEP — constraint owns it
BILLING.public.SalesDetail.IX_PricingStatus	1451041	btree	Y	Y			0	114	never	2026-10-14 01:07:56	UNUSED	KEEP — primary key
BILLING.public.ContractArchive.IX_BookingEntry	1451881	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.ContractArchive.IX_BillingHistory	1451879	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ContractArchive.IX_CampaignLine	1451883	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.ReconcileArchive.IX_ShipmentLine	1451862	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.ReconcileArchive.IX_PricingHistory	1451860	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ReconcileArchive.IX_BookingArchive	1451864	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.ClaimArchive.IX_PayrollLine	1451211	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ShiftHistory.IX_PayrollLog	1449937	btree	Y		Y		0	4	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.ShiftHistory.IX_LedgerDaily	1449935	btree	Y	Y			4	4	2026-10-14T01:47:01.899897+00:00	never	USED	KEEP — primary key
BILLING.public.ForecastResult.IX_AssetStaging	1450051	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ForecastResult.IX_RouteArchive	1450053	btree					3	0	2026-10-19T04:06:37.931482+00:00	never	USED	keep — in use
BILLING.public.ForecastResult.IX_TicketLine	1450054	btree					2	0	2026-10-14T01:47:47.936473+00:00	never	USED	keep — in use
BILLING.public.WarehouseSummary.IX_CampaignStaging	1450063	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.WarehouseSummary.IX_WarehouseResult	1450065	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.WarehouseSummary.IX_ReconcileStaging	1450066	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.WarehouseStaging.IX_SettlementDetail	1451388	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.WarehouseStaging.IX_PricingStaging	1451386	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.StaffingSnapshot.IX_LedgerDaily	1451407	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.StaffingSnapshot.IX_ContractDetail	1451405	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.QuotaStaging.IX_BatchSummary	1451460	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.QuotaStaging.IX_PayrollArchive	1451458	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.QuotaSnapshot.IX_PayrollLine	1451369	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.QuotaSnapshot.IX_ShipmentSnapshot	1451367	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.BookingResult.IX_PolicyStatus	1451426	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.BookingResult.IX_BatchSnapshot	1451424	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.RosterMonthly.IX_PricingMonthly	1451445	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.RosterMonthly.IX_OrdersLine	1451443	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.SupplierLine.IX_QuotaSnapshot	1450955	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.SupplierLine.IX_BookingHistory	1450953	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.BatchSnapshot.IX_PricingQueue	1450998	btree	Y	Y			0	24518	never	2026-10-18 02:03:22	UNUSED	KEEP — primary key
BILLING.public.queue.IX_ReconcileLine	1450181	btree					0	4	never	never	UNUSED	review, then DROP
BILLING.public.queue.IX_BillingLine	1450179	btree	Y		Y		0	4	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.queue.IX_RosterResult	1450177	btree	Y	Y			14	4	2026-10-19T05:59:08.773825+00:00	never	USED	KEEP — primary key
BILLING.public.SalesHistory.IX_RosterArchive	1450748	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.CampaignLine.IX_PayrollLine	1450190	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.CampaignLine.IX_SalesSummary	1450192	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.InvoiceDaily.IX_SupplierArchive	1450663	btree	Y	Y			0	4	never	never	UNUSED	KEEP — primary key
BILLING.public.PricingAudit.IX_CampaignArchive	1450039	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.PricingAudit.IX_ShipmentMonthly	1450041	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.PricingAudit.IX_QuotaLog	1450042	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.roles.IX_WarehouseLog	1450025	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.roles.IX_TicketArchive	1450023	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.QuotaLine.IX_SalesDaily	1450084	btree	Y		Y		0	1	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.QuotaLine.IX_SettlementEntry	1450082	btree	Y	Y			0	1	never	never	UNUSED	KEEP — primary key
BILLING.public.PolicyStaging.IX_SettlementLog	1451499	btree	Y		Y		0	10	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.PolicyStaging.IX_MeterHistory	1451501	btree					3	10	2026-10-19T02:17:18.519124+00:00	never	USED	keep — in use
BILLING.public.PolicyStaging.IX_QuotaLog	1451502	btree					691995	10	2026-10-19T02:17:18.519124+00:00	never	USED	keep — in use
BILLING.public.PolicyStaging.IX_ShipmentEntry	1451497	btree	Y	Y			2	10	2026-10-14T01:48:04.853313+00:00	never	USED	KEEP — primary key
BILLING.public.AssetHeader.IX_StaffingStaging	1451519	btree					20	52530	2026-10-14T01:44:05.486462+00:00	2026-10-18 02:10:22	USED	keep — in use
BILLING.public.AssetHeader.IX_QuotaDetail	1451517	btree	Y		Y		0	52530	never	2026-10-18 02:10:22	UNUSED	KEEP — constraint owns it
BILLING.public.AssetHeader.IX_BillingLine	1451515	btree	Y	Y			10	52530	2026-10-14T01:44:05.486462+00:00	2026-10-18 02:10:22	USED	KEEP — primary key
BILLING.public.AssetHeader.IX_LedgerSnapshot	1451520	btree					84	52530	2026-10-14T01:44:45.503825+00:00	2026-10-18 02:10:22	USED	keep — in use
BILLING.public.InvoiceMonthly.IX_SupplierSnapshot	1451478	btree	Y		Y		0	87552	never	2026-10-18 02:08:22	UNUSED	KEEP — constraint owns it
BILLING.public.InvoiceMonthly.IX_OrdersHeader	1451480	btree					13	87552	2026-10-14T01:44:05.486462+00:00	2026-10-18 02:08:22	USED	keep — in use
BILLING.public.InvoiceMonthly.IX_MeterStaging	1451481	btree					73	87552	2026-10-14T01:44:49.227018+00:00	2026-10-18 02:08:22	USED	keep — in use
BILLING.public.InvoiceMonthly.IX_TerritoryHistory	1451476	btree	Y	Y			52	87552	2026-10-14T01:44:05.744744+00:00	2026-10-18 02:08:22	USED	KEEP — primary key
BILLING.public.OrdersSnapshot.IX_CustomerDetail	1450983	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.OrdersSnapshot.IX_QuotaArchive	1450981	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.OrdersSnapshot.IX_TicketStatus	1450984	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.service.IX_QuotaDaily	1450764	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.service.IX_OrdersArchive	1450762	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ReconcileHistory.IX_BillingHistory	1450789	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.ReconcileHistory.IX_ShiftLog	1450787	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ReconcileHistory.IX_ForecastHeader	1450790	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.QuotaStaging.IX_LedgerHeader	1450774	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.QuotaStaging.IX_PricingLog	1450776	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.RosterMonthly.IX_InvoiceStatus	1450832	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.RosterMonthly.IX_SalesEntry	1450834	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.sessions.IX_PayrollHeader	1450849	btree					10	856	2026-10-14T01:22:56.835618+00:00	2026-10-19 05:59:54	USED	keep — in use
BILLING.public.sessions.IX_CampaignEntry	1450847	btree	Y	Y			297	856	2026-10-19T06:00:47.886713+00:00	2026-10-19 05:59:54	USED	KEEP — primary key
BILLING.public.sessions.IX_CampaignLog	1450850	btree					51	856	2026-10-19T04:11:51.470068+00:00	2026-10-19 05:59:54	USED	keep — in use
BILLING.public.ReconcileDetail.IX_OrdersResult	1450103	btree	Y		Y		0	1	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.ReconcileDetail.IX_WarehouseLog	1450101	btree	Y	Y			0	1	never	never	UNUSED	KEEP — primary key
BILLING.public.sla.IX_ShipmentLine	1450811	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.sla.IX_ReconcileHistory	1450809	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.PayrollDaily.IX_InvoiceSnapshot	1450821	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.PayrollDaily.IX_RosterQueue	1450823	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.TicketAudit.IX_TicketStatus	1451842	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.TicketAudit.IX_ShipmentQueue	1451843	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.TicketAudit.IX_RouteResult	1451844	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.TicketAudit.IX_CampaignStaging	1451840	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.MeterAudit.IX_TicketHistory	1451296	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.LedgerDetail.IX_StaffingSnapshot	1450684	btree	Y		Y		0	0	never	never	COLD	KEEP — constraint owns it
BILLING.public.LedgerDetail.IX_RouteEntry	1450682	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ShiftHistory.IX_MeterHeader	1450649	btree	Y		Y		0	2	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.ShiftHistory.IX_SupplierResult	1450647	btree	Y	Y			0	2	never	never	UNUSED	KEEP — primary key
BILLING.public.ForecastAudit.IX_SupplierAudit	1450698	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ShiftSnapshot.IX_BookingLog	1451551	btree	Y		Y		4306	23515	2026-10-14T01:40:32.126675+00:00	2026-10-14 01:20:57	USED	KEEP — constraint owns it
BILLING.public.ShiftSnapshot.IX_MeterMonthly	1451549	btree	Y	Y			6010	23515	2026-10-14T03:36:52.321071+00:00	2026-10-14 01:20:57	USED	KEEP — primary key
BILLING.public.CustomerSnapshot.IX_PayrollSnapshot	1451581	btree					6	2137	2026-10-14T01:20:30.436693+00:00	2026-10-14 01:08:56	USED	keep — in use
BILLING.public.CustomerSnapshot.IX_CampaignDaily	1451579	btree	Y	Y			18	2137	2026-10-14T01:40:34.128746+00:00	2026-10-14 01:08:56	USED	KEEP — primary key
BILLING.public.WarehouseHistory.IX_CampaignEntry	1451644	btree	Y	Y			2	2	2026-10-14T01:21:35.39459+00:00	never	USED	KEEP — primary key
BILLING.public.ShiftLog.IX_BookingAudit	1451631	btree	Y	Y			0	2	never	never	UNUSED	KEEP — primary key
BILLING.public.ClaimDetail.IX_ForecastArchive	1451603	btree	Y		Y		13	12	2026-10-14T01:40:34.128746+00:00	never	USED	KEEP — constraint owns it
BILLING.public.ClaimDetail.IX_PricingSnapshot	1451601	btree	Y	Y			0	12	never	never	UNUSED	KEEP — primary key
BILLING.public.RouteLog.IX_CustomerStatus	1451623	btree	Y	Y			6	6	2026-10-14T01:40:34.128746+00:00	never	USED	KEEP — primary key
BILLING.public.RosterResult.IX_SettlementMonthly	1450121	btree	Y	Y			3	1	2026-10-19T04:06:37.931482+00:00	never	USED	KEEP — primary key
BILLING.public.ClaimEntry.IX_RouteLine	1451134	btree	Y	Y			103	98	2026-10-16T03:01:14.818452+00:00	2026-10-16 03:01:39	USED	KEEP — primary key
BILLING.public.CampaignDaily.IX_RosterEntry	1450139	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.ticket.IX_TicketLog	1450306	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_QuotaDetail	1450307	btree					24	38	2026-10-19T06:00:47.886713+00:00	never	USED	keep — in use
BILLING.public.ticket.IX_TerritoryHeader	1450308	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_ContractHeader	1450309	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_ContractMonthly	1450310	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_CatalogLog	1450311	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_MeterQueue	1450312	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_BatchStatus	1450313	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_LedgerDetail	1450302	btree	Y	Y			127	38	2026-10-19T06:00:26.447865+00:00	never	USED	KEEP — primary key
BILLING.public.ticket.IX_ContractStaging	1450314	btree					19	38	2026-10-19T05:58:36.387607+00:00	never	USED	keep — in use
BILLING.public.ticket.IX_BillingSummary	1450315	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_QuotaQueue	1450316	btree					19	38	2026-10-19T05:58:36.387607+00:00	never	USED	keep — in use
BILLING.public.ticket.IX_LedgerDetail	1450317	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_TicketArchive	1450318	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_RosterQueue	1450319	btree					809	38	2026-10-19T06:00:47.886713+00:00	never	USED	keep — in use
BILLING.public.ticket.IX_SettlementLine	1450320	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_ForecastResult	1450321	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_PricingEntry	1450304	btree	Y		Y		4	38	2026-10-14T01:50:07.165649+00:00	never	USED	KEEP — constraint owns it
BILLING.public.ticket.IX_ForecastSummary	1450322	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_QuotaQueue	1450323	btree					0	38	never	never	UNUSED	review, then DROP
BILLING.public.ticket.IX_TicketAudit	1450324	btree					956	38	2026-10-19T06:00:47.886713+00:00	never	USED	keep — in use
BILLING.public.SalesAudit.IX_SettlementHeader	1450337	btree	Y		Y		0	4	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.SalesAudit.IX_SalesLog	1450335	btree	Y	Y			0	4	never	never	UNUSED	KEEP — primary key
BILLING.public.SalesAudit.IX_SettlementResult	1450339	btree					0	4	never	never	UNUSED	review, then DROP
BILLING.public.SalesAudit.IX_CampaignArchive	1450340	btree					0	4	never	never	UNUSED	review, then DROP
BILLING.public.SalesAudit.IX_WarehouseAudit	1450341	btree					395	4	2026-10-19T06:00:47.886713+00:00	never	USED	keep — in use
BILLING.public.MeterHeader.IX_CampaignStatus	1450362	btree					0	10	never	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_ShiftResult	1450363	btree					0	10	never	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_LedgerArchive	1450364	btree					0	10	never	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_ShiftResult	1450365	btree					0	10	never	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_AssetStaging	1450360	btree	Y	Y			0	10	never	never	UNUSED	KEEP — primary key
BILLING.public.MeterHeader.IX_PayrollSnapshot	1450366	btree					0	10	never	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_CustomerStatus	1450367	btree					0	10	never	never	UNUSED	review, then DROP
BILLING.public.MeterHeader.IX_ShipmentDaily	1450368	btree					23	10	2026-10-19T05:58:36.387607+00:00	never	USED	keep — in use
BILLING.public.MeterHeader.IX_WarehouseResult	1450369	btree					7	10	2026-10-19T06:00:47.886713+00:00	never	USED	keep — in use
BILLING.public.MeterHeader.IX_BatchArchive	1450370	btree					0	10	never	never	UNUSED	review, then DROP
BILLING.public.PolicyHeader.IX_ShipmentEntry	1450385	btree	Y		Y		0	52	never	2026-10-14 01:07:56	UNUSED	KEEP — constraint owns it
BILLING.public.PolicyHeader.IX_ContractHistory	1450383	btree	Y	Y			0	52	never	2026-10-14 01:07:56	UNUSED	KEEP — primary key
BILLING.public.QuotaHistory.IX_PricingMonthly	1450420	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.QuotaHistory.IX_LedgerHistory	1450418	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.QuotaHistory.IX_MeterResult	1450421	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.QuotaHistory.IX_CampaignDaily	1450422	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.CatalogDetail.IX_CatalogResult	1450430	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.CatalogDetail.IX_ForecastHeader	1450432	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.CatalogEntry.IX_MeterLog	1450240	btree	Y		Y		1	3	2026-10-14T02:35:10.517597+00:00	never	USED	KEEP — constraint owns it
BILLING.public.CatalogEntry.IX_ShipmentSnapshot	1450238	btree	Y	Y			3	3	2026-10-19T05:59:08.773825+00:00	never	USED	KEEP — primary key
BILLING.public.SalesEntry.IX_MeterResult	1450441	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.SalesEntry.IX_RouteHistory	1450443	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.SalesEntry.IX_TerritoryHistory	1450444	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.WarehouseHistory.IX_InvoiceHistory	1451730	btree					2	4	2026-10-14T01:50:07.165649+00:00	never	USED	keep — in use
BILLING.public.WarehouseHistory.IX_BookingLine	1451726	btree	Y	Y			4	4	2026-10-14T01:50:07.165649+00:00	never	USED	KEEP — primary key
BILLING.public.WarehouseHistory.IX_CustomerArchive	1451728	btree	Y		Y		4	4	2026-10-14T01:50:07.165649+00:00	never	USED	KEEP — constraint owns it
BILLING.public.TicketMonthly.IX_RosterStaging	1450208	btree	Y		Y		0	5	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.TicketMonthly.IX_MeterSnapshot	1450206	btree	Y	Y			16	5	2026-10-19T05:59:08.773825+00:00	never	USED	KEEP — primary key
BILLING.public.BookingStaging.IX_ContractStaging	1450258	btree	Y		Y		5	9	2026-10-14T01:21:30.937993+00:00	never	USED	KEEP — constraint owns it
BILLING.public.BookingStaging.IX_ShiftArchive	1450256	btree	Y	Y			20	9	2026-10-19T05:59:08.773825+00:00	never	USED	KEEP — primary key
BILLING.public.CustomerQueue.IX_QuotaStaging	1450273	btree	Y		Y		63	7	2026-10-14T02:45:11.782292+00:00	never	USED	KEEP — constraint owns it
BILLING.public.CustomerQueue.IX_SettlementAudit	1450271	btree	Y	Y			14	7	2026-10-14T01:21:30.937993+00:00	never	USED	KEEP — primary key
BILLING.public.CustomerMonthly.IX_ClaimHeader	1450224	btree	Y		Y		0	1	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.CustomerMonthly.IX_CatalogResult	1450222	btree	Y	Y			12	1	2026-10-19T05:59:08.773825+00:00	never	USED	KEEP — primary key
BILLING.public.PricingStatus.IX_MeterResult	1450399	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.PricingStatus.IX_PayrollHeader	1450401	btree					46	0	2026-10-19T05:58:36.387607+00:00	never	USED	keep — in use
BILLING.public.PricingStatus.IX_SalesQueue	1450402	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.CampaignQueue.IX_RouteQueue	1450629	btree					2	0	2026-10-19T05:58:59.988378+00:00	never	USED	keep — in use
BILLING.public.CampaignQueue.IX_InvoiceEntry	1450627	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.CampaignQueue.IX_ReconcileLine	1450630	btree					13	0	2026-10-19T06:00:47.886713+00:00	never	USED	keep — in use
BILLING.public.InvoiceEntry.IX_CampaignEntry	1449920	btree	Y	Y			0	37	never	never	UNUSED	KEEP — primary key
BILLING.public.InvoiceEntry.IX_ShipmentHistory	1449922	btree					64	37	2026-10-19T06:00:26.447865+00:00	never	USED	keep — in use
BILLING.public.users.IX_BillingHeader	1449908	btree	Y		Y		5	4	2026-10-19T02:17:18.519124+00:00	never	USED	KEEP — constraint owns it
BILLING.public.users.IX_PolicySummary	1449906	btree	Y	Y			17339	4	2026-10-19T06:00:26.447865+00:00	never	USED	KEEP — primary key
BILLING.public.valid.IX_TerritoryEntry	1449887	btree	Y		Y		0	3	never	never	UNUSED	KEEP — constraint owns it
BILLING.public.valid.IX_CustomerDetail	1449885	btree	Y	Y			2	3	2026-10-14T01:46:38.135223+00:00	never	USED	KEEP — primary key
BILLING.public.SalesResult.IX_ClaimSnapshot	1451165	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.SalesResult.IX_ClaimEntry	1451166	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.SalesResult.IX_SupplierStaging	1451163	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.BatchMonthly.IX_CampaignDetail	1451193	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.BatchMonthly.IX_CustomerArchive	1451191	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.PricingAudit.IX_StaffingEntry	1451179	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.PricingAudit.IX_StaffingDaily	1451177	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.PricingAudit.IX_RouteHistory	1451180	btree					0	0	never	never	COLD	review, then DROP
BILLING.public.BatchSnapshot.IX_PayrollQueue	1451010	btree	Y	Y			0	0	never	never	COLD	KEEP — primary key
BILLING.public.BillingHistory.IX_LedgerLog	1451149	btree					106	1484	2026-10-19T02:17:37.915604+00:00	2026-10-14 01:21:56	USED	keep — in use
BILLING.public.BillingHistory.IX_CatalogStaging	1451147	btree	Y	Y			0	1484	never	2026-10-14 01:21:56	UNUSED	KEEP — primary key
BILLING.public.BillingHistory.IX_CampaignResult	1451150	btree					0	1484	never	2026-10-14 01:21:56	UNUSED	review, then DROP