Index Usage — ACME-198-51-100-66

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

Index Usage Report — ACME-198-51-100-66

Host: 198.51.100.66

Collected: 2026-09-11T18:03:52Z

Server dashboard: http://192.0.2.15:8080/report_dba/server-metrics.html?server=ACME-198-51-100-66

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

They are zeroed by a restart, so user_seeks = 0 means "not used since that instant", not "never used". last_stats_update is a different clock again: it is set by UPDATE STATISTICS / auto-update, not by usage, so a heavily used index can still carry statistics from months ago.

> **Short sample — do not drop anything on the strength of this report.** The counters cover only 5.4 day(s) of the 7 that make a full business week. A weekly report, a month-end close or a quarterly batch has not necessarily run yet, so an index serving one of them still reads as cold. Use this to see the shape of the instance; re-read it after the sample is complete before dropping anything.

Metric	Count	Meaning
indexes_total	671	every index on a CatalogHistory table
used	369	had a seek, scan or lookup
unused	79	written but never read
cold	223	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	52	nonclustered, not unique, no constraint, never read
fragmented	162	above the rebuild threshold

By database

Database	Total	Cold	Droppable	Recommend action
ASSET_Prod	55	30	26	review the drop candidates above
host_726	571	167	25	review the drop candidates above
TICKET_Prod	24	5	1	review the drop candidates above
SUPPLIER_Stg	21	21	0	no action — cold indexes here are constraints or clustered

Drop candidates (52)

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
host_726.schedule.LedgerMonthly.IX_CatalogDaily	24302687	never	UNUSED	review, then DROP
host_726.schedule.ShipmentHeader.IX_QuotaSnapshot	12151350	never	UNUSED	review, then DROP
host_726.schedule.ShipmentHeader.IX_InvoiceSummary	12151350	never	UNUSED	review, then DROP
host_726.schedule.ShipmentHeader.IX_CampaignHistory	12151350	never	UNUSED	review, then DROP
host_726.schedule.WarehouseArchive.IX_CustomerHistory	1585876	never	UNUSED	review, then DROP
host_726.emp.SettlementQueue.IX_PolicyAudit	18576	never	UNUSED	review, then DROP
host_726.emp.SupplierStaging.IX_StaffingEntry	7751	never	UNUSED	review, then DROP
host_726.emp.SalesHeader.IX_BookingSummary	1410	never	UNUSED	review, then DROP
ASSET_Prod.dbo.BookingEntry.IX_ShipmentStatus	218	never	UNUSED	review, then DROP
ASSET_Prod.dbo.CampaignHeader.IX_SupplierResult	158	never	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_QuotaAudit	74	never	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_StaffingHeader	74	never	UNUSED	review, then DROP
host_726.org.RosterMonthly.IX_AssetDetail	12	never	UNUSED	review, then DROP
host_726.org.InvoiceStaging.IX_AssetAudit	12	never	UNUSED	review, then DROP
ASSET_Prod.dbo.BatchLog.IX_TerritoryArchive	0	never	COLD	review, then DROP
ASSET_Prod.dbo.BatchLog.IX_LedgerHistory	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ForecastDetail.IX_CampaignStatus	0	never	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_ClaimHistory	0	never	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_StaffingLine	0	never	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_ShiftDaily	0	never	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_CatalogLog	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RosterSummary.IX_ForecastSnapshot	0	never	COLD	review, then DROP
ASSET_Prod.dbo.SalesSnapshot.IX_TicketResult	0	never	COLD	review, then DROP
host_726.sal.ClaimArchive.IX_RouteDetail	0	never	COLD	review, then DROP
host_726.schedule.InvoiceHistory.IX_StaffingHeader	0	never	COLD	review, then DROP
host_726.wps.PolicyResult.IX_ContractSnapshot	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RouteSnapshot.IX_ContractHeader	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RouteArchive.IX_ShiftDaily	0	never	COLD	review, then DROP
ASSET_Prod.dbo.AssetEntry.IX_TerritoryDetail	0	never	COLD	review, then DROP
ASSET_Prod.dbo.BookingSnapshot.IX_RouteLine	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RosterDaily.IX_ShiftHeader	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RosterHeader.IX_ShipmentLog	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ContractStaging.IX_InvoiceLog	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_ForecastDetail	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_QuotaSummary	0	never	COLD	review, then DROP
ASSET_Prod.dbo.DOB.IX_CustomerSummary	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ShipmentLog.IX_ReconcileStatus	0	never	COLD	review, then DROP
ASSET_Prod.dbo.BookingSnapshot.IX_ClaimStaging	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RosterStaging.IX_BatchArchive	0	never	COLD	review, then DROP
host_726.emp.StaffingMonthly.IX_ReconcileEntry	0	never	COLD	review, then DROP
host_726.guest.TerritoryQueue.IX_InvoiceStaging	0	never	COLD	review, then DROP
host_726.org.SupplierHistory.IX_ShipmentSummary	0	never	COLD	review, then DROP
host_726.org.BillingHeader.IX_ShiftHistory	0	never	COLD	review, then DROP
host_726.org.ShipmentSummary.IX_StaffingResult	0	never	COLD	review, then DROP
host_726.org.QuotaEntry.IX_AssetHistory	0	never	COLD	review, then DROP
host_726.org.CustomerLine.IX_ForecastLine	0	never	COLD	review, then DROP
host_726.oth.StaffingArchive.IX_InvoiceStaging	0	never	COLD	review, then DROP
TICKET_Prod.app.WarehouseStatus.IX_BookingEntry	0	never	COLD	review, then DROP
host_726.dbo.SalesLine.IX_ReconcileResult	0	never	COLD	review, then DROP
host_726.dbo.BatchResult.IX_SettlementStaging	0	never	COLD	review, then DROP
host_726.dbo.BatchResult.IX_ReconcileEntry	0	never	COLD	review, then DROP
host_726.dbo.CustomerArchive.IX_BillingHeader	0	never	COLD	review, then DROP

Fragmented (162) — 162 partitions across 26 indexes

Total 55,967.9 MB of index to rebuild. Fragmentation is measured in LIMITED mode, so record count and page density are not collected — they need a SAMPLED scan.

Index	Part	Type	Frag	Pages	Size MB	Stats updated	Action
host_726\schedule.ShiftHeader.IX_TicketStatus#p20	20/21	NONCLUSTERED	100.0%	3,089	24.1	2026-09-11 20:33:10	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p18	18/21	NONCLUSTERED	99.9%	19,585	153.0	2026-09-11 23:25:54	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p16	16/21	NONCLUSTERED	99.9%	19,632	153.4	2026-09-11 23:25:54	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p21	21/21	NONCLUSTERED	99.8%	19,556	152.8	2026-09-11 23:25:54	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p20	20/21	NONCLUSTERED	99.8%	19,561	152.8	2026-09-11 23:25:54	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p17	17/21	NONCLUSTERED	99.8%	19,616	153.3	2026-09-11 23:25:54	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p19	19/21	NONCLUSTERED	99.7%	20,307	158.6	2026-09-11 23:25:54	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p10	10/21	NONCLUSTERED	99.7%	23,581	184.2	2026-09-11 23:26:00	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p15	15/21	NONCLUSTERED	99.6%	20,426	159.6	2026-09-11 23:25:54	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p14	14/21	NONCLUSTERED	99.6%	29,379	229.5	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p14	14/21	NONCLUSTERED	99.5%	38,332	299.5	2026-09-11 23:24:08	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p17	17/21	NONCLUSTERED	99.5%	47,173	368.5	2026-09-11 23:27:06	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p13	13/21	CLUSTERED	99.5%	159,518	1246.2	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p15	15/21	NONCLUSTERED	99.5%	33,004	257.8	2026-09-11 23:24:09	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p11	11/21	NONCLUSTERED	99.5%	21,838	170.6	2026-09-11 23:26:00	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p15	15/21	NONCLUSTERED	99.4%	43,105	336.8	2026-09-11 23:24:08	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p13	13/21	NONCLUSTERED	99.4%	41,500	324.2	2026-09-11 23:24:08	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p11	11/21	NONCLUSTERED	99.4%	40,131	313.5	2026-09-11 23:24:08	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p20	20/21	NONCLUSTERED	99.4%	47,053	367.6	2026-09-11 23:27:06	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p18	18/21	NONCLUSTERED	99.4%	47,106	368.0	2026-09-11 23:27:06	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p16	16/21	NONCLUSTERED	99.4%	47,225	368.9	2026-09-11 23:27:06	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p21	21/21	CLUSTERED	99.4%	76,990	601.5	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p17	17/21	NONCLUSTERED	99.4%	22,535	176.1	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p14	14/21	NONCLUSTERED	99.4%	20,844	162.8	2026-09-11 23:26:00	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p16	16/21	NONCLUSTERED	99.4%	4,362	34.1	2026-09-11 20:33:10	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p21	21/21	NONCLUSTERED	99.4%	31,660	247.3	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p20	20/21	NONCLUSTERED	99.4%	31,697	247.6	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p19	19/21	NONCLUSTERED	99.4%	32,884	256.9	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p18	18/21	NONCLUSTERED	99.4%	31,715	247.8	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p17	17/21	NONCLUSTERED	99.4%	31,735	247.9	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p16	16/21	NONCLUSTERED	99.4%	31,781	248.3	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p13	13/21	NONCLUSTERED	99.4%	31,843	248.8	2026-09-11 23:24:09	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p12	12/21	NONCLUSTERED	99.4%	23,579	184.2	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p13	13/21	NONCLUSTERED	99.4%	22,592	176.5	2026-09-11 23:26:00	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p16	16/21	NONCLUSTERED	99.3%	41,495	324.2	2026-09-11 23:24:08	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p12	12/21	NONCLUSTERED	99.3%	43,454	339.5	2026-09-11 23:24:08	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p19	19/21	NONCLUSTERED	99.3%	48,848	381.6	2026-09-11 23:27:06	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p15	15/21	NONCLUSTERED	99.3%	49,103	383.6	2026-09-11 23:27:06	REBUILD
host_726\schedule.ShipmentHeader.IX_QuotaSnapshot	1/1	NONCLUSTERED	99.3%	106,480	831.9	2026-09-11 02:10:13	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p21	21/21	CLUSTERED	99.3%	100,358	784.0	2026-09-11 23:25:53	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p13	13/21	CLUSTERED	99.3%	101,141	790.2	2026-09-11 23:25:53	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p16	16/21	NONCLUSTERED	99.3%	22,549	176.2	2026-09-11 23:26:00	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p15	15/21	NONCLUSTERED	99.3%	3,183	24.9	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p13	13/21	NONCLUSTERED	99.3%	3,154	24.6	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p17	17/21	NONCLUSTERED	99.3%	4,360	34.1	2026-09-11 20:33:10	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p18	18/21	CLUSTERED	99.3%	159,138	1243.3	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p12	12/21	CLUSTERED	99.3%	166,286	1299.1	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p10	10/21	CLUSTERED	99.3%	166,429	1300.2	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p12	12/21	NONCLUSTERED	99.3%	33,156	259.0	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p21	21/21	NONCLUSTERED	99.3%	41,476	324.0	2026-09-11 23:24:08	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p15	15/21	NONCLUSTERED	99.2%	23,430	183.0	2026-09-11 23:26:00	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p17	17/21	NONCLUSTERED	99.2%	41,483	324.1	2026-09-11 23:24:08	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p10	10/21	NONCLUSTERED	99.2%	43,342	338.6	2026-09-11 23:24:08	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p21	21/21	NONCLUSTERED	99.2%	47,043	367.5	2026-09-11 23:27:06	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p14	14/21	NONCLUSTERED	99.2%	43,897	342.9	2026-09-11 23:27:06	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p20	20/21	CLUSTERED	99.2%	77,001	601.6	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p19	19/21	CLUSTERED	99.2%	79,940	624.5	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p18	18/21	CLUSTERED	99.2%	77,096	602.3	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p16	16/21	CLUSTERED	99.2%	77,291	603.8	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p11	11/21	CLUSTERED	99.2%	75,025	586.1	2026-09-11 23:26:00	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p18	18/21	NONCLUSTERED	99.2%	41,499	324.2	2026-09-11 23:24:08	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p15	15/21	CLUSTERED	99.2%	104,686	817.9	2026-09-11 23:25:53	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p14	14/21	NONCLUSTERED	99.2%	18,228	142.4	2026-09-11 23:25:54	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p12	12/21	NONCLUSTERED	99.2%	20,774	162.3	2026-09-11 23:25:54	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p10	10/21	NONCLUSTERED	99.2%	20,861	163.0	2026-09-11 23:25:54	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p10	10/21	NONCLUSTERED	99.2%	3,215	25.1	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p18	18/21	NONCLUSTERED	99.2%	4,351	34.0	2026-09-11 20:33:10	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p21	21/21	CLUSTERED	99.2%	159,006	1242.2	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p20	20/21	CLUSTERED	99.2%	158,971	1242.0	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p19	19/21	CLUSTERED	99.2%	165,028	1289.3	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p17	17/21	CLUSTERED	99.2%	159,306	1244.6	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p16	16/21	CLUSTERED	99.2%	159,375	1245.1	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p15	15/21	CLUSTERED	99.2%	165,538	1293.3	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p14	14/21	CLUSTERED	99.2%	147,267	1150.5	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p11	11/21	CLUSTERED	99.2%	154,133	1204.2	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p10	10/21	NONCLUSTERED	99.2%	33,192	259.3	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p19	19/21	NONCLUSTERED	99.2%	43,088	336.6	2026-09-11 23:24:08	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p13	13/21	NONCLUSTERED	99.1%	47,809	373.5	2026-09-11 23:27:06	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p11	11/21	NONCLUSTERED	99.1%	46,348	362.1	2026-09-11 23:27:06	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p17	17/21	CLUSTERED	99.1%	77,229	603.4	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p10	10/21	CLUSTERED	99.1%	81,037	633.1	2026-09-11 23:26:00	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p14	14/21	CLUSTERED	99.1%	93,175	727.9	2026-09-11 23:25:53	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p11	11/21	CLUSTERED	99.1%	97,864	764.6	2026-09-11 23:25:53	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p10	10/21	CLUSTERED	99.1%	105,710	825.9	2026-09-11 23:25:53	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p13	13/21	NONCLUSTERED	99.1%	19,819	154.8	2026-09-11 23:25:54	REBUILD
host_726\schedule.RosterResult.IX_AssetStaging#p11	11/21	NONCLUSTERED	99.1%	19,279	150.6	2026-09-11 23:25:54	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p12	12/21	NONCLUSTERED	99.1%	3,240	25.3	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p21	21/21	NONCLUSTERED	99.1%	4,347	34.0	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p20	20/21	NONCLUSTERED	99.1%	4,346	34.0	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p11	11/21	NONCLUSTERED	99.1%	4,473	34.9	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p10	10/21	NONCLUSTERED	99.1%	4,481	35.0	2026-09-11 20:33:10	REBUILD
host_726\schedule.SettlementLog.IX_PolicyLine#p11	11/21	NONCLUSTERED	99.1%	30,742	240.2	2026-09-11 23:24:09	REBUILD
host_726\schedule.SettlementLog.IX_TicketLine#p20	20/21	NONCLUSTERED	99.1%	41,499	324.2	2026-09-11 23:24:08	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p12	12/21	NONCLUSTERED	99.0%	49,867	389.6	2026-09-11 23:27:06	REBUILD
host_726\schedule.PolicyStatus.IX_ForecastAudit#p10	10/21	NONCLUSTERED	99.0%	50,188	392.1	2026-09-11 23:27:06	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p18	18/21	NONCLUSTERED	99.0%	22,493	175.7	2026-09-11 23:26:00	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p17	17/21	CLUSTERED	99.0%	100,646	786.3	2026-09-11 23:25:53	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p12	12/21	CLUSTERED	99.0%	105,265	822.4	2026-09-11 23:25:53	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p9	9/21	NONCLUSTERED	99.0%	3,256	25.4	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p21	21/21	NONCLUSTERED	99.0%	3,091	24.1	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p14	14/21	NONCLUSTERED	99.0%	2,516	19.7	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p9	9/21	NONCLUSTERED	99.0%	4,895	38.2	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p13	13/21	NONCLUSTERED	99.0%	4,372	34.2	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p15	15/21	NONCLUSTERED	98.9%	4,439	34.7	2026-09-11 20:33:10	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p15	15/21	CLUSTERED	98.8%	80,327	627.6	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p14	14/21	CLUSTERED	98.8%	71,470	558.4	2026-09-11 23:26:00	REBUILD
host_726\schedule.RouteAudit.IX_InvoiceHeader	1/1	NONCLUSTERED	98.8%	80,800	631.3	2026-09-11 12:27:28	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p19	19/21	CLUSTERED	98.8%	104,205	814.1	2026-09-11 23:25:53	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p18	18/21	CLUSTERED	98.8%	100,497	785.1	2026-09-11 23:25:53	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p11	11/21	NONCLUSTERED	98.8%	3,190	24.9	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p19	19/21	NONCLUSTERED	98.8%	4,355	34.0	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p12	12/21	NONCLUSTERED	98.8%	4,347	34.0	2026-09-11 20:33:10	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p12	12/21	CLUSTERED	98.7%	81,284	635.0	2026-09-11 23:26:00	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p20	20/21	CLUSTERED	98.7%	100,369	784.1	2026-09-11 23:25:53	REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p16	16/21	CLUSTERED	98.7%	100,733	787.0	2026-09-11 23:25:53	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p19	19/21	NONCLUSTERED	98.7%	3,094	24.2	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p18	18/21	NONCLUSTERED	98.7%	3,093	24.2	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine#p14	14/21	NONCLUSTERED	98.7%	4,257	33.3	2026-09-11 20:33:10	REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p13	13/21	CLUSTERED	98.6%	77,569	606.0	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p19	19/21	NONCLUSTERED	98.6%	23,323	182.2	2026-09-11 23:26:00	REBUILD
host_726\schedule.MeterStaging.PK_PolicyArchive#p9	9/21	CLUSTERED	98.6%	1,535	12.0	2026-09-11 23:23:39	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p17	17/21	NONCLUSTERED	98.6%	3,098	24.2	2026-09-11 20:33:10	REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus#p16	16/21	NONCLUSTERED	98.4%	3,102	24.2	2026-09-11 20:33:10	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p20	20/21	NONCLUSTERED	98.3%	22,466	175.5	2026-09-11 23:26:00	REBUILD
host_726\schedule.BillingDetail.IX_TicketHeader#p21	21/21	NONCLUSTERED	97.9%	22,462	175.5	2026-09-11 23:26:00	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p10	10/21	NONCLUSTERED	96.5%	3,973	31.0	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p11	11/21	NONCLUSTERED	96.3%	3,869	30.2	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p15	15/21	NONCLUSTERED	96.3%	2,509	19.6	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p12	12/21	NONCLUSTERED	96.0%	3,913	30.6	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p13	13/21	NONCLUSTERED	95.8%	2,624	20.5	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p13	13/21	NONCLUSTERED	95.7%	3,936	30.8	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p11	11/21	NONCLUSTERED	95.7%	2,599	20.3	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p10	10/21	NONCLUSTERED	95.6%	2,642	20.6	2026-09-11 20:33:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p6	6/21	CLUSTERED	95.4%	1,302	10.2	2026-09-11 23:24:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p16	16/21	NONCLUSTERED	95.3%	2,379	18.6	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p15	15/21	NONCLUSTERED	95.2%	3,852	30.1	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p20	20/21	NONCLUSTERED	95.2%	2,424	18.9	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p17	17/21	NONCLUSTERED	95.1%	3,720	29.1	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p19	19/21	NONCLUSTERED	95.1%	3,634	28.4	2026-09-11 20:33:09	REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p5	5/21	CLUSTERED	95.0%	1,010	7.9	2026-09-11 23:24:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p18	18/21	NONCLUSTERED	95.0%	2,386	18.6	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p9	9/21	NONCLUSTERED	95.0%	2,616	20.4	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p17	17/21	NONCLUSTERED	94.8%	2,447	19.1	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p19	19/21	NONCLUSTERED	94.8%	2,442	19.1	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p16	16/21	NONCLUSTERED	94.6%	3,559	27.8	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p12	12/21	NONCLUSTERED	94.5%	2,680	20.9	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p9	9/21	NONCLUSTERED	94.3%	3,786	29.6	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p18	18/21	NONCLUSTERED	93.9%	3,513	27.4	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p20	20/21	NONCLUSTERED	93.8%	3,885	30.4	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_BillingHeader#p21	21/21	NONCLUSTERED	93.4%	3,483	27.2	2026-09-11 20:33:09	REBUILD
host_726\schedule.SupplierSnapshot.IX_ContractLog#p21	21/21	NONCLUSTERED	92.9%	2,394	18.7	2026-09-11 20:33:09	REBUILD
host_726\emp.CampaignResult.IX_ClaimStatus	1/1	NONCLUSTERED	68.9%	32,901	257.0	2026-09-11 02:02:16	REBUILD
host_726\schedule.ShipmentHeader.IX_InvoiceSummary	1/1	NONCLUSTERED	67.3%	113,821	889.2	2026-09-11 02:12:05	REBUILD
host_726\emp.TicketSnapshot.IX_BookingHistory	1/1	NONCLUSTERED	64.9%	11,146	87.1	2026-09-11 02:01:23	REBUILD
host_726\emp.CustomerLog.IX_PayrollResult	1/1	NONCLUSTERED	59.1%	1,422	11.1	2026-09-11 02:00:46	REORGANIZE
host_726\emp.BillingAudit.IX_PolicyHeader	1/1	NONCLUSTERED	57.3%	7,413	57.9	2026-09-11 20:34:16	REORGANIZE
host_726\schedule.PolicyLine.PK_RouteQueue#p9	9/21	CLUSTERED	54.6%	2,359	18.4	2026-09-11 23:26:00	REORGANIZE
host_726\schedule.ForecastMonthly.IX_WarehouseDaily	1/1	NONCLUSTERED	54.4%	590,644	4614.4	2026-09-11 20:34:25	REORGANIZE
host_726\emp.SupplierStaging.IX_StaffingSnapshot	1/1	NONCLUSTERED	43.9%	3,179	24.8	2026-09-11 02:00:54	REORGANIZE
host_726\schedule.InvoiceAudit.PK_LedgerMonthly#p9	9/21	CLUSTERED	41.4%	2,280	17.8	2026-09-11 23:24:15	REORGANIZE
host_726\schedule.PolicyLine.UX_TerritoryHistory#p9	9/21	NONCLUSTERED	38.8%	1,197	9.4	2026-09-11 23:27:30	REORGANIZE
host_726\emp.SupplierStaging.IX_CampaignResult	1/1	NONCLUSTERED	32.3%	2,384	18.6	2026-09-11 02:00:51	REORGANIZE

All indexes (671)

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	Filt	seeks	scans	lookups	updates	last_read	last_stats_update	State	Recommend action
TICKET_Prod.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y		2080623	603	439387	494	2026-09-12 01:03:52	2026-09-11 02:00:00	USED	KEEP — primary key
TICKET_Prod.app.ShiftAudit.UX_PayrollAudit	2	NONCLUSTERED	Y			844805	9	0	494	2026-09-12 01:03:51	2026-09-11 02:00:00	USED	keep — in use
TICKET_Prod.app.ShiftAudit.UX_ContractSummary	7	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-09-11 02:00:00	UNUSED	review carefully — unique
TICKET_Prod.app.ReconcileDaily.PK_LedgerResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
TICKET_Prod.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	402	never	2026-09-11 02:00:01	UNUSED	KEEP — primary key
TICKET_Prod.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	39804	never	2026-09-11 02:00:01	UNUSED	KEEP — primary key
TICKET_Prod.app.ForecastMonthly.IX_StaffingStatus	1	CLUSTERED				0	0	0	301	never	2026-09-11 02:00:01	UNUSED	KEEP — table storage
TICKET_Prod.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		0	53026	0	0	2026-09-12 01:01:07	2026-09-06 02:00:03	USED	KEEP — primary key
TICKET_Prod.app.CampaignAudit.PK_BillingMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
TICKET_Prod.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		155230	12919	0	6	2026-09-12 01:03:52	2026-09-10 02:00:02	USED	KEEP — primary key
TICKET_Prod.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	6	never	2026-09-10 02:00:02	UNUSED	KEEP — primary key
TICKET_Prod.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		79531	70	0	1	2026-09-12 01:01:07	2026-09-06 02:00:03	USED	KEEP — primary key
TICKET_Prod.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	1	never	2026-09-06 02:00:03	UNUSED	review carefully — unique
TICKET_Prod.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y		11707	0	0	10	2026-09-12 00:33:04	2026-09-06 02:00:03	USED	KEEP — primary key
TICKET_Prod.app.BatchQueue.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	4190	0	0	2026-09-11 20:11:56	never	USED	KEEP — primary key
TICKET_Prod.app.WarehouseStatus.IX_BookingEntry	9	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:00:03	COLD	review, then DROP
TICKET_Prod.app.WarehouseStatus.UX_QuotaLine	2	NONCLUSTERED	Y			4106	17483	0	0	2026-09-11 22:18:31	2026-09-06 02:00:03	USED	keep — in use
TICKET_Prod.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		130785	0	0	72	2026-09-12 01:03:52	2026-09-10 02:00:02	USED	KEEP — primary key
TICKET_Prod.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	72	never	2026-09-10 02:00:03	UNUSED	KEEP — primary key
TICKET_Prod.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		83603	454648	0	0	2026-09-12 01:03:52	2026-09-06 02:00:03	USED	KEEP — primary key
TICKET_Prod.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y		75709	110105	0	0	2026-09-12 01:03:52	2026-09-06 02:00:03	USED	KEEP — primary key
TICKET_Prod.app.CatalogMonthly.UX_RouteQueue	2	NONCLUSTERED	Y			4238	0	0	0	2026-09-11 20:11:56	2026-09-06 02:00:03	USED	keep — in use
TICKET_Prod.app.ClaimResult.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
TICKET_Prod.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER_Stg.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.ShiftAudit.UX_PayrollAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:25	COLD	review carefully — unique
SUPPLIER_Stg.app.ReconcileDaily.PK_LedgerResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER_Stg.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER_Stg.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.CampaignAudit.PK_BillingMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER_Stg.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:25	COLD	review carefully — unique
SUPPLIER_Stg.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.BatchQueue.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER_Stg.app.WarehouseStatus.UX_QuotaLine	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:25	COLD	review carefully — unique
SUPPLIER_Stg.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:25	COLD	KEEP — primary key
SUPPLIER_Stg.app.CatalogMonthly.UX_RouteQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:25	COLD	review carefully — unique
SUPPLIER_Stg.app.ClaimResult.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SUPPLIER_Stg.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:05	COLD	KEEP — primary key
host_726.cfg.QuotaStatus.UX_MeterSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:05	COLD	review carefully — unique
host_726.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		0	611	0	610	2026-09-12 00:35:47	2026-09-06 02:00:05	USED	KEEP — primary key
host_726.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	610	never	2026-09-11 02:00:02	UNUSED	KEEP — primary key
host_726.dbo.Jobs.PK_RosterStatus	1	CLUSTERED	Y	Y		0	2	0	0	2026-09-10 12:36:40	2026-09-06 02:00:05	USED	KEEP — primary key
host_726.dbo.Jobs.UQ_ContractMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:05	COLD	review carefully — unique
host_726.dbo.MeterResult.PK_BookingDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.OrdersSnapshot.IX_SalesQueue	2	NONCLUSTERED				0	1	0	0	2026-09-07 08:29:43	2026-09-06 02:00:05	USED	keep — in use
host_726.dbo.OrdersSnapshot.PK_PolicyLine	1	CLUSTERED	Y	Y		0	4	0	0	2026-09-07 08:29:43	2026-09-06 02:00:05	USED	KEEP — primary key
host_726.dbo.SalesLine.IX_ReconcileResult	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
host_726.dbo.SalesLine.PK_MeterStatus	1	CLUSTERED	Y	Y		0	1	0	0	2026-09-07 08:26:53	never	USED	KEEP — primary key
host_726.dbo.InvoiceSummary.PK_LedgerResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:05	COLD	KEEP — primary key
host_726.dbo.CustomerSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:05	COLD	KEEP — primary key
host_726.dbo.QuotaResult.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:05	COLD	KEEP — primary key
host_726.dbo.LedgerResult.PK_ForecastMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.BatchResult.IX_SettlementStaging	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:00:05	COLD	review, then DROP
host_726.dbo.BatchResult.IX_ReconcileEntry	3	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:00:05	COLD	review, then DROP
host_726.dbo.BatchResult.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:05	COLD	KEEP — primary key
host_726.dbo.PricingLog.PK_RouteLine	1	CLUSTERED	Y	Y		0	1	0	0	2026-09-10 12:37:00	never	USED	KEEP — primary key
host_726.dbo.ClaimArchive.PK_StaffingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:05	COLD	KEEP — primary key
host_726.dbo.ClaimArchive.UQ_SupplierResult	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:05	COLD	review carefully — unique
host_726.dbo.CustomerArchive.IX_BillingHeader	3	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:00:05	COLD	review, then DROP
host_726.dbo.CustomerArchive.PK_AssetSummary	1	CLUSTERED	Y	Y		0	2	0	0	2026-09-10 12:37:08	2026-09-06 02:00:05	USED	KEEP — primary key
host_726.dbo.CustomerArchive.UQ_OrdersMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:05	COLD	review carefully — unique
host_726.dbo.Status.PK_ShiftLine	1	CLUSTERED	Y	Y		0	1	0	0	2026-09-07 08:26:37	2026-09-06 02:00:05	USED	KEEP — primary key
host_726.dbo.Status.UQ_PricingHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:05	COLD	review carefully — unique
host_726.dbo.SupplierDetail.PK_ShiftResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.CampaignResult.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.TicketQueue.PK_CampaignEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.BookingStatus.PK_StaffingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:05	COLD	KEEP — primary key
host_726.dbo.BookingStatus.UQ_CatalogSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:05	COLD	review carefully — unique
host_726.dbo.BookingStatus.UQ_ContractEntry	3	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:05	COLD	review carefully — unique
host_726.dbo.BookingStatus.UQ_RouteLine	4	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:05	COLD	review carefully — unique
host_726.dbo.BillingHistory.PK_PayrollHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:05	COLD	KEEP — primary key
host_726.dbo.TicketQueue.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:06	COLD	KEEP — primary key
host_726.dbo.StaffingStaging.PK_SettlementHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.WarehouseEntry.PK_ShiftStatus	1	CLUSTERED	Y	Y		415965	440	0	0	2026-09-12 01:03:52	2026-09-06 02:00:06	USED	KEEP — primary key
host_726.dbo.WarehouseEntry.UX_CampaignHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:06	COLD	review carefully — unique
host_726.dbo.TicketSummary.PK_SalesLine	1	CLUSTERED				0	2948	0	0	2026-09-11 20:20:50	2026-09-06 02:00:06	USED	KEEP — table storage
host_726.dbo.TerritoryEntry.PK_SalesSummary	1	CLUSTERED	Y	Y		268367	158	0	0	2026-09-12 01:03:52	2026-09-06 02:00:06	USED	KEEP — primary key
host_726.dbo.TerritoryEntry.UX_TerritoryQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:06	COLD	review carefully — unique
host_726.dbo.PolicyEntry.PK_TicketEntry	1	CLUSTERED	Y	Y		132060	466	0	0	2026-09-12 01:03:52	2026-09-06 02:00:06	USED	KEEP — primary key
host_726.dbo.PolicyEntry.UX_PolicyAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:06	COLD	review carefully — unique
host_726.dbo.CampaignHeader.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y		148338	536	0	0	2026-09-12 01:03:52	2026-09-06 02:00:06	USED	KEEP — primary key
host_726.dbo.CampaignHeader.UX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:06	COLD	review carefully — unique
host_726.dbo.WarehouseHeader.PK_OrdersQueue	1	CLUSTERED	Y	Y		0	261	0	0	2026-09-11 15:11:00	2026-09-06 02:00:06	USED	KEEP — primary key
host_726.dbo.WarehouseHeader.UX_TicketQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:06	COLD	review carefully — unique
host_726.dbo.RouteQueue.PK_SupplierAudit	1	CLUSTERED	Y	Y		273569	158	0	0	2026-09-12 01:03:52	2026-09-06 02:00:06	USED	KEEP — primary key
host_726.dbo.RouteQueue.UX_CampaignQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:06	COLD	review carefully — unique
host_726.dbo.CampaignAudit.PK_BatchSnapshot	1	CLUSTERED	Y	Y		132017	466	0	0	2026-09-12 01:03:52	2026-09-06 02:00:06	USED	KEEP — primary key
host_726.dbo.CampaignAudit.UX_SupplierArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:06	COLD	review carefully — unique
host_726.dbo.ShiftDaily.PK_ReconcileStatus	1	CLUSTERED	Y	Y		273950	158	0	0	2026-09-12 01:03:52	2026-09-06 02:00:06	USED	KEEP — primary key
host_726.dbo.ShiftDaily.UX_RouteDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:06	COLD	review carefully — unique
host_726.dbs.ShipmentStatus.UX_StaffingLog	8	NONCLUSTERED	Y		Y	6	0	0	6	2026-09-11 20:00:32	2026-09-11 02:00:03	USED	keep — in use
host_726.emp.WarehouseMonthly.PK_PricingHistory	1	CLUSTERED	Y	Y		3196	1767	0	3	2026-09-12 00:56:10	2026-09-10 02:00:04	USED	KEEP — primary key
host_726.emp.WarehouseMonthly.UX_CustomerDetail	2	NONCLUSTERED	Y		Y	0	0	0	3	never	2026-09-10 02:00:04	UNUSED	review carefully — unique
host_726.emp.SettlementLine.PK_LedgerAudit	1	CLUSTERED	Y	Y		0	0	0	3	never	2026-09-10 02:00:04	UNUSED	KEEP — primary key
host_726.emp.SalesDetail.PK_BillingLog	1	CLUSTERED	Y	Y		0	21	0	0	2026-09-11 20:19:17	2026-09-06 02:00:07	USED	KEEP — primary key
host_726.emp.BatchMonthly.PK_TicketAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:07	COLD	KEEP — primary key
host_726.emp.RosterLog.PK_QuotaLog	1	CLUSTERED	Y	Y		65502	0	0	32751	2026-09-12 01:01:29	2026-09-06 02:00:07	USED	KEEP — primary key
host_726.emp.QuotaMonthly.IX_ShipmentEntry	2	NONCLUSTERED				150115	0	0	421	2026-09-12 01:03:52	2026-09-11 02:00:03	USED	keep — in use
host_726.emp.QuotaMonthly.PK_ReconcileDetail	1	CLUSTERED	Y	Y		417	100	150115	421	2026-09-12 01:03:52	2026-09-11 02:00:03	USED	KEEP — primary key
host_726.emp.OrdersEntry.PK_PolicyHeader	1	CLUSTERED	Y	Y		0	0	0	419	never	2026-09-11 02:00:03	UNUSED	KEEP — primary key
host_726.emp.PayrollSummary.PK_RouteSummary	1	CLUSTERED	Y	Y		0	21	0	0	2026-09-11 20:19:17	2026-09-06 02:00:11	USED	KEEP — primary key
host_726.emp.SettlementAudit.PK_ShiftStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:11	COLD	KEEP — primary key
host_726.emp.InvoiceLog.PK_BatchEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.InvoiceMonthly.PK_RouteEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.InvoiceMonthly.UX_CustomerSnapshot	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host_726.emp.CampaignEntry.PK_TicketMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.CampaignEntry.UX_CatalogHistory	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host_726.emp.RouteHistory.PK_CustomerMonthly	1	CLUSTERED	Y	Y		42	127	0	0	2026-09-12 00:00:00	2026-09-06 02:00:11	USED	KEEP — primary key
host_726.emp.RouteHistory.UX_CustomerQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:11	COLD	review carefully — unique
host_726.emp.CustomerHistory.PK_ShiftDaily	1	CLUSTERED	Y	Y		36	0	0	0	2026-09-11 15:11:00	2026-09-06 02:00:12	USED	KEEP — primary key
host_726.emp.ForecastEntry.PK_SettlementLog	1	CLUSTERED	Y	Y		2	159104	0	11	2026-09-12 01:01:34	2026-09-09 02:00:04	USED	KEEP — primary key
host_726.emp.ClaimQueue.PK_TerritoryResult	1	CLUSTERED	Y	Y		0	0	0	15	never	2026-09-09 02:00:04	UNUSED	KEEP — primary key
host_726.emp.PolicyAudit.PK_ContractAudit	1	CLUSTERED	Y	Y		10	279944	0	10	2026-09-12 01:01:34	2026-09-09 02:00:04	USED	KEEP — primary key
host_726.emp.ShipmentSummary.PK_ShiftAudit	1	CLUSTERED	Y	Y		0	4	0	19	2026-09-11 17:06:04	2026-09-09 02:00:04	USED	KEEP — primary key
host_726.emp.BatchArchive.PK_ClaimHistory	1	CLUSTERED	Y	Y		121098	158986	0	12	2026-09-12 01:01:34	2026-09-09 02:00:04	USED	KEEP — primary key
host_726.emp.RosterSnapshot.PK_PolicyStaging	1	CLUSTERED	Y	Y		0	0	0	12	never	2026-09-09 02:00:04	UNUSED	KEEP — primary key
host_726.emp.MeterResult.IX_LedgerQueue	2	NONCLUSTERED				0	104463	0	215	2026-09-12 01:01:30	2026-09-11 02:00:04	USED	keep — in use
host_726.emp.MeterResult.PK_CustomerResult	1	CLUSTERED	Y	Y		1121642	37384	0	215	2026-09-12 01:03:52	2026-09-11 02:00:04	USED	KEEP — primary key
host_726.emp.PayrollHeader.PK_TicketHistory	1	CLUSTERED	Y	Y		132218	55	0	215	2026-09-12 01:03:52	2026-09-11 02:00:05	USED	KEEP — primary key
host_726.emp.OrdersAudit.PK_ShipmentHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.RosterResult.PK_MeterAudit	1	CLUSTERED	Y	Y		0	67	0	0	2026-09-12 00:00:00	2026-09-06 02:00:13	USED	KEEP — primary key
host_726.emp.RouteHeader.PK_StaffingQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:14	COLD	KEEP — primary key
host_726.emp.MeterAudit.PK_ClaimLog	1	CLUSTERED	Y	Y		155	18969	0	154	2026-09-12 01:01:56	2026-09-11 02:00:05	USED	KEEP — primary key
host_726.emp.QuotaStatus.PK_OrdersArchive	1	CLUSTERED	Y	Y		0	0	0	13	never	2026-09-11 02:00:05	UNUSED	KEEP — primary key
host_726.emp.ShiftLine.IX_PricingAudit	3	NONCLUSTERED				41	0	0	0	2026-09-11 18:22:31	2026-09-06 02:00:14	USED	keep — in use
host_726.emp.ShiftLine.PK_SettlementStatus	1	CLUSTERED	Y	Y		34	78	41	11	2026-09-12 00:00:01	2026-09-06 02:00:14	USED	KEEP — primary key
host_726.emp.ShiftLine.UX_BookingDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:00:14	COLD	review carefully — unique
host_726.emp.CampaignHeader.PK_BillingQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.MeterStatus.PK_BillingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.WarehouseStaging.PK_CustomerEntry	1	CLUSTERED	Y	Y		0	0	0	11	never	2026-09-11 02:00:05	UNUSED	KEEP — primary key
host_726.emp.ForecastHeader.IX_WarehouseResult	2	NONCLUSTERED				3326	0	0	2	2026-09-11 20:20:50	2026-09-11 02:00:05	USED	keep — in use
host_726.emp.ForecastHeader.PK_OrdersAudit	1	CLUSTERED	Y	Y		2	21	3326	2	2026-09-11 20:20:50	2026-09-06 02:00:15	USED	KEEP — primary key
host_726.emp.SalesLog.PK_AssetStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:00:15	COLD	KEEP — primary key
host_726.emp.AssetDaily.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	6043	0	0	2026-09-11 20:20:50	2026-09-06 02:00:15	USED	KEEP — primary key
host_726.emp.StaffingDaily.PK_BookingLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.ClaimResult.PK_TerritoryQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.CatalogLog.PK_ReconcileHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.ShipmentSnapshot.PK_ReconcileQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.PricingDaily.IX_ShiftAudit	2	NONCLUSTERED				72	0	0	10	2026-09-11 15:57:34	2026-09-09 02:00:05	USED	keep — in use
host_726.emp.PricingDaily.PK_RouteEntry	1	CLUSTERED	Y	Y		1	3205	72	10	2026-09-11 20:20:50	2026-09-09 02:00:05	USED	KEEP — primary key
host_726.emp.PolicyLog.PK_LedgerHistory	1	CLUSTERED	Y	Y		214	57	132054	215	2026-09-12 01:03:52	2026-09-11 02:00:06	USED	KEEP — primary key
host_726.emp.PolicyLog.UX_OrdersSnapshot	2	NONCLUSTERED	Y			132057	6	0	215	2026-09-12 01:03:52	2026-09-11 02:00:06	USED	keep — in use
host_726.emp.RouteAudit.PK_ClaimResult	1	CLUSTERED	Y	Y		0	0	0	11	never	2026-09-11 02:00:06	UNUSED	KEEP — primary key
host_726.emp.PayrollDaily.IX_BillingStaging	2	NONCLUSTERED				14	0	0	75	2026-09-11 15:11:00	2026-09-06 02:00:16	USED	keep — in use
host_726.emp.PayrollDaily.PK_OrdersSnapshot	1	CLUSTERED	Y	Y		0	14	0	75	2026-09-11 15:11:00	2026-09-06 02:00:16	USED	KEEP — primary key
host_726.emp.MeterHistory.IX_ContractArchive	17	NONCLUSTERED				4114	67066	0	230	2026-09-12 01:01:05	2026-09-11 02:00:06	USED	keep — in use
host_726.emp.MeterHistory.PK_BatchLog	1	CLUSTERED	Y	Y		2962759	52684	1181025	315	2026-09-12 01:03:52	2026-09-11 02:00:06	USED	KEEP — primary key
host_726.emp.MeterHistory.UX_BatchLog	2	NONCLUSTERED	Y		Y	0	0	0	315	never	2026-09-11 02:00:06	UNUSED	review carefully — unique
host_726.emp.MeterHistory.UX_ForecastHeader	20	NONCLUSTERED	Y			286856	100	0	230	2026-09-12 01:03:52	2026-09-11 02:00:06	USED	keep — in use
host_726.emp.MeterHistory.UX_CustomerSnapshot	3	NONCLUSTERED	Y		Y	26	2	0	315	2026-09-10 11:19:53	2026-09-11 02:00:06	USED	keep — in use
host_726.emp.MeterHistory.UX_QuotaStaging	4	NONCLUSTERED	Y			1448535	7	0	230	2026-09-12 01:03:52	2026-09-11 02:00:06	USED	keep — in use
host_726.emp.ShiftSnapshot.IX_ForecastAudit	1	CLUSTERED				0	0	0	314	never	2026-09-11 02:00:07	UNUSED	KEEP — table storage
host_726.emp.TerritoryLine.PK_LedgerArchive	1	CLUSTERED	Y	Y		49372	10995	0	18590	2026-09-12 00:43:19	2026-09-09 02:00:07	USED	KEEP — primary key
host_726.emp.SalesStaging.PK_PolicyDaily	1	CLUSTERED	Y	Y		4923	125	0	1304	2026-09-12 00:09:35	2026-09-11 02:00:07	USED	KEEP — primary key
host_726.emp.TerritoryDaily.PK_MeterLog	1	CLUSTERED	Y	Y		0	0	0	406	never	2026-09-11 02:00:08	UNUSED	KEEP — primary key
host_726.emp.SettlementQueue.IX_PolicyAudit	2	NONCLUSTERED				0	0	0	18576	never	2026-09-11 02:00:08	UNUSED	review, then DROP
host_726.emp.SettlementQueue.PK_SalesEntry	1	CLUSTERED	Y	Y		0	20	0	18576	2026-09-11 18:22:32	2026-09-11 02:00:08	USED	KEEP — primary key
host_726.emp.StaffingMonthly.IX_ReconcileEntry	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:00:24	COLD	review, then DROP
host_726.emp.StaffingMonthly.IX_SalesQueue	3	NONCLUSTERED				9058	0	0	0	2026-09-11 22:15:12	2026-09-06 02:00:24	USED	keep — in use
host_726.emp.StaffingMonthly.PK_CampaignStatus	1	CLUSTERED	Y	Y		3	7960	3610	0	2026-09-11 22:15:12	2026-09-06 02:00:24	USED	KEEP — primary key
host_726.emp.TicketQueue.PK_BatchDaily	1	CLUSTERED	Y	Y		0	0	3340	424	2026-09-11 20:20:50	2026-09-11 02:00:09	USED	KEEP — primary key
host_726.emp.TicketQueue.UX_PayrollDaily	2	NONCLUSTERED	Y			3340	0	0	424	2026-09-11 20:20:50	2026-09-11 02:00:09	USED	keep — in use
host_726.emp.MeterStatus.PK_CustomerDetail	1	CLUSTERED	Y	Y		0	0	0	424	never	2026-09-11 02:00:11	UNUSED	KEEP — primary key
host_726.emp.OrdersEntry.PK_TerritoryAudit	1	CLUSTERED	Y	Y		0	3326	0	0	2026-09-11 20:20:50	2026-09-06 02:00:24	USED	KEEP — primary key
host_726.emp.InvoiceLog.PK_BillingDetail	1	CLUSTERED	Y	Y		0	0	0	233	never	2026-09-11 02:00:11	UNUSED	KEEP — primary key
host_726.emp.CampaignHistory.IX_QuotaDetail	2	NONCLUSTERED				1559620	0	0	1	2026-09-12 01:01:31	2026-09-08 02:00:13	USED	keep — in use
host_726.emp.CampaignHistory.PK_AssetHeader	1	CLUSTERED	Y	Y		0	27564	1559620	1	2026-09-12 01:01:31	2026-09-08 02:00:13	USED	KEEP — primary key
host_726.emp.ContractArchive.PK_BookingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.TicketLine.PK_CampaignEntry	1	CLUSTERED	Y	Y		28	15	0	0	2026-09-11 18:22:32	2026-09-06 02:00:28	USED	KEEP — primary key
host_726.emp.BatchAudit.IX_PolicyArchive	20	NONCLUSTERED				91334	52	0	769918	2026-09-12 00:58:20	2026-09-11 02:00:13	USED	keep — in use
host_726.emp.BatchAudit.PK_ForecastSummary	1	CLUSTERED	Y	Y		384993	4625	2062615	1154845	2026-09-12 01:01:33	2026-09-11 02:00:12	USED	KEEP — primary key
host_726.emp.BatchAudit.UX_LedgerStaging	2	NONCLUSTERED	Y			4011667	4	0	769918	2026-09-12 01:01:52	2026-09-11 02:00:13	USED	keep — in use
host_726.emp.ClaimAudit.PK_LedgerDaily	1	CLUSTERED	Y	Y		0	0	0	2	never	never	UNUSED	KEEP — primary key
host_726.emp.ClaimAudit.UX_RouteMonthly	2	NONCLUSTERED	Y			0	2	0	2	2026-09-11 17:10:42	never	USED	keep — in use
host_726.emp.PolicyHistory.PK_OrdersDaily	1	CLUSTERED	Y	Y		768863	255	0	1153657	2026-09-12 01:01:32	2026-09-11 20:34:09	USED	KEEP — primary key
host_726.emp.BillingEntry.PK_StaffingAudit	1	CLUSTERED	Y	Y		0	294	0	768727	2026-09-12 00:09:35	2026-09-11 10:44:23	USED	KEEP — primary key
host_726.emp.BillingEntry.UX_StaffingLog	2	NONCLUSTERED	Y			383804	0	0	768727	2026-09-12 01:01:32	2026-09-11 10:44:23	USED	keep — in use
host_726.emp.BillingAudit.IX_PolicyHeader	8	NONCLUSTERED				79851	0	0	768727	2026-09-12 01:01:29	2026-09-11 20:34:16	USED	keep — in use
host_726.emp.BillingAudit.PK_PolicyDetail	1	CLUSTERED	Y	Y		0	12	18	768727	2026-09-11 18:22:31	2026-09-11 20:34:17	USED	KEEP — primary key
host_726.emp.BillingAudit.UX_SupplierSnapshot	2	NONCLUSTERED	Y			383776	31	0	768727	2026-09-12 01:01:32	2026-09-11 20:34:16	USED	keep — in use
host_726.emp.ShipmentStaging.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	10	0	383798	2026-09-11 18:22:31	never	USED	KEEP — primary key
host_726.emp.ShipmentStaging.UX_RosterDaily	2	NONCLUSTERED	Y			0	383798	0	383798	2026-09-12 01:01:32	never	USED	keep — in use
host_726.emp.SalesLine.PK_CampaignResult	1	CLUSTERED	Y	Y		1039320	22	0	1153653	2026-09-12 01:01:32	2026-09-11 23:27:20	USED	KEEP — primary key
host_726.emp.LedgerSnapshot.PK_CampaignStatus	1	CLUSTERED	Y	Y		0	0	0	218	never	2026-09-11 02:00:41	UNUSED	KEEP — primary key
host_726.emp.ReconcileDetail.PK_CampaignQueue	1	CLUSTERED	Y	Y		97	3654	0	109	2026-09-11 20:20:50	2026-09-11 02:00:41	USED	KEEP — primary key
host_726.emp.PolicyStaging.PK_PolicyStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.ReconcileStaging.PK_ContractStaging	1	CLUSTERED	Y	Y		152	299	0	0	2026-09-11 15:57:34	2026-09-06 02:01:19	USED	KEEP — primary key
host_726.emp.ReconcileStaging.UX_OrdersHistory	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:01:19	COLD	review carefully — unique
host_726.emp.MeterStatus.PK_ReconcileMonthly	1	CLUSTERED	Y	Y		144	292	164300	142	2026-09-12 01:03:52	2026-09-11 02:00:42	USED	KEEP — primary key
host_726.emp.MeterStatus.UX_ReconcileAudit	4	NONCLUSTERED	Y			164303	0	0	57	2026-09-12 01:03:52	2026-09-11 02:00:42	USED	keep — in use
host_726.emp.PricingAudit.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		0	0	0	14	never	2026-09-11 02:00:42	UNUSED	KEEP — primary key
host_726.emp.RosterQueue.PK_SettlementHistory	1	CLUSTERED	Y	Y		15770	1725	0	0	2026-09-12 01:01:56	2026-09-06 02:01:22	USED	KEEP — primary key
host_726.emp.BatchResult.IX_BillingQueue	6	NONCLUSTERED				410	8	0	303	2026-09-12 00:35:47	2026-09-11 02:00:43	USED	keep — in use
host_726.emp.BatchResult.PK_InvoiceSummary	1	CLUSTERED	Y	Y		0	15	8	303	2026-09-11 14:31:37	2026-09-11 02:00:43	USED	KEEP — primary key
host_726.emp.TicketAudit.IX_LedgerLog	2	NONCLUSTERED				19	0	0	11808	2026-09-11 17:04:37	2026-09-10 02:07:55	USED	keep — in use
host_726.emp.TicketAudit.PK_LedgerStatus	1	CLUSTERED	Y	Y		0	0	19	11808	2026-09-11 17:04:37	2026-09-10 02:07:55	USED	KEEP — primary key
host_726.emp.InvoiceResult.PK_ShipmentMonthly	1	CLUSTERED	Y	Y		0	0	0	11808	never	2026-09-10 02:07:55	UNUSED	KEEP — primary key
host_726.emp.CustomerLog.IX_PolicyDaily	18	NONCLUSTERED				0	6597	0	5279	2026-09-11 23:44:13	2026-09-11 02:00:45	USED	keep — in use
host_726.emp.CustomerLog.IX_PayrollResult	21	NONCLUSTERED				3776970	580657	0	10553	2026-09-12 01:01:32	2026-09-11 02:00:46	USED	keep — in use
host_726.emp.CustomerLog.PK_StaffingDaily	1	CLUSTERED	Y	Y		2044379	2049	598753	10553	2026-09-12 01:01:32	2026-09-11 02:00:44	USED	KEEP — primary key
host_726.emp.InvoiceAudit.IX_SettlementResult	10	NONCLUSTERED				127006	20167	0	5266	2026-09-12 01:01:11	2026-09-11 02:00:47	USED	keep — in use
host_726.emp.InvoiceAudit.PK_QuotaEntry	1	CLUSTERED	Y	Y		0	90	18533	5266	2026-09-12 01:01:02	2026-09-11 02:00:47	USED	KEEP — primary key
host_726.emp.MeterSummary.PK_AssetEntry	1	CLUSTERED	Y	Y		0	0	0	3632	never	2026-09-11 02:00:48	UNUSED	KEEP — primary key
host_726.emp.BatchDaily.IX_SupplierStatus	1	CLUSTERED				0	0	0	7960	never	2026-09-11 02:00:48	UNUSED	KEEP — table storage
host_726.emp.AssetSummary.PK_SupplierStaging	1	CLUSTERED	Y	Y		0	5	0	5279	2026-09-11 01:15:02	2026-09-11 02:00:48	USED	KEEP — primary key
host_726.emp.SupplierStaging.IX_CampaignResult	24	NONCLUSTERED				0	123	0	8483	2026-09-11 18:08:42	2026-09-11 02:00:51	USED	keep — in use
host_726.emp.SupplierStaging.IX_StaffingSnapshot	30	NONCLUSTERED				1142107	148	0	8485	2026-09-12 01:01:32	2026-09-11 02:00:54	USED	keep — in use
host_726.emp.SupplierStaging.IX_MeterStaging	16	NONCLUSTERED				140	0	0	7608	2026-09-11 15:57:55	2026-09-11 02:00:55	USED	keep — in use
host_726.emp.SupplierStaging.IX_StaffingEntry	25	NONCLUSTERED				0	0	0	7751	never	2026-09-11 02:00:55	UNUSED	review, then DROP
host_726.emp.SupplierStaging.PK_PayrollMonthly	1	CLUSTERED	Y	Y		625257	4686	340967	8485	2026-09-12 01:01:11	2026-09-11 02:00:49	USED	KEEP — primary key
host_726.emp.SupplierStaging.IX_OrdersSnapshot	26	NONCLUSTERED	Y			22445	0	0	3512	2026-09-12 00:50:49	2026-09-11 02:00:55	USED	keep — in use
host_726.emp.CustomerStatus.IX_ReconcileLine	10	NONCLUSTERED				144777	57127	0	12360	2026-09-12 01:01:11	2026-09-11 02:00:56	USED	keep — in use
host_726.emp.CustomerStatus.PK_PolicyHistory	1	CLUSTERED	Y	Y		0	259	53783	12360	2026-09-12 00:23:11	2026-09-11 02:00:56	USED	KEEP — primary key
host_726.emp.BillingAudit.PK_CustomerEntry	1	CLUSTERED	Y	Y		0	0	0	9014	never	2026-09-11 02:00:57	UNUSED	KEEP — primary key
host_726.emp.PolicyLine.PK_OrdersSummary	1	CLUSTERED	Y	Y		4	10552	0	11	2026-09-12 00:23:11	2026-09-11 02:00:57	USED	KEEP — primary key
host_726.emp.RouteStaging.PK_WarehouseLine	1	CLUSTERED	Y	Y		0	3387	0	0	2026-09-12 00:23:11	2026-09-06 02:01:59	USED	KEEP — primary key
host_726.emp.CampaignMonthly.PK_OrdersArchive	1	CLUSTERED	Y	Y		6	7801	0	366	2026-09-12 00:13:21	2026-09-11 02:00:57	USED	KEEP — primary key
host_726.emp.CatalogSnapshot.PK_ClaimHistory	1	CLUSTERED	Y	Y		0	36	0	0	2026-09-11 21:12:06	2026-09-06 02:01:59	USED	KEEP — primary key
host_726.emp.TerritoryMonthly.IX_LedgerMonthly	1	CLUSTERED				0	0	0	5360	never	2026-09-11 02:00:57	UNUSED	KEEP — table storage
host_726.emp.BillingDaily.PK_CustomerLine	1	CLUSTERED	Y	Y		0	4096	4977	6173	2026-09-11 23:43:32	2026-09-11 02:00:58	USED	KEEP — primary key
host_726.emp.BillingDaily.UX_LedgerDaily	2	NONCLUSTERED	Y			5129	0	0	6173	2026-09-11 23:43:32	2026-09-11 02:00:58	USED	keep — in use
host_726.emp.SupplierHistory.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	9	0	8821	2026-09-11 01:15:00	2026-09-11 02:00:58	USED	KEEP — primary key
host_726.emp.ShipmentMonthly.IX_SupplierEntry	11	NONCLUSTERED				195543	0	0	147253	2026-09-12 01:01:11	2026-09-11 02:01:04	USED	keep — in use
host_726.emp.ShipmentMonthly.IX_InvoiceStaging	2	NONCLUSTERED				288803	0	0	147253	2026-09-12 01:01:34	2026-09-11 02:01:04	USED	keep — in use
host_726.emp.ShipmentMonthly.PK_BatchDaily	1	CLUSTERED	Y	Y		825	92	227823	148078	2026-09-12 01:01:34	2026-09-11 02:00:59	USED	KEEP — primary key
host_726.emp.AssetDetail.PK_ReconcileResult	1	CLUSTERED	Y	Y		0	0	0	64395	never	2026-09-11 02:01:05	UNUSED	KEEP — primary key
host_726.emp.AssetSnapshot.IX_ForecastStatus	5	NONCLUSTERED				1114770	881	0	63234	2026-09-12 01:01:31	2026-09-11 02:01:08	USED	keep — in use
host_726.emp.AssetSnapshot.IX_SalesDaily	2	NONCLUSTERED				744375	2036	0	63234	2026-09-12 01:01:34	2026-09-11 02:01:09	USED	keep — in use
host_726.emp.AssetSnapshot.PK_OrdersDetail	1	CLUSTERED	Y	Y		43770	0	159684	63234	2026-09-12 01:01:29	2026-09-11 02:01:06	USED	KEEP — primary key
host_726.emp.PricingStatus.PK_PolicyStatus	1	CLUSTERED	Y	Y		0	0	0	63234	never	2026-09-11 02:01:10	UNUSED	KEEP — primary key
host_726.emp.TicketSnapshot.IX_BookingHistory	15	NONCLUSTERED				0	2154	0	79777	2026-09-11 22:15:24	2026-09-11 02:01:23	USED	keep — in use
host_726.emp.TicketSnapshot.PK_CampaignQueue	1	CLUSTERED	Y	Y		1795814	135662	0	79777	2026-09-12 01:01:34	2026-09-11 02:01:10	USED	KEEP — primary key
host_726.emp.TicketSnapshot.IX_ContractEntry	19	NONCLUSTERED	Y			134424	39	0	79777	2026-09-12 01:01:30	2026-09-11 02:01:23	USED	keep — in use
host_726.emp.MeterEntry.IX_OrdersAudit	1	CLUSTERED				0	0	0	53900	never	2026-09-11 02:01:24	UNUSED	KEEP — table storage
host_726.emp.ForecastMonthly.PK_CampaignSummary	1	CLUSTERED	Y	Y		0	5	0	79761	2026-09-11 01:15:00	2026-09-11 02:01:25	USED	KEEP — primary key
host_726.emp.PricingStatus.IX_QuotaLog	7	NONCLUSTERED				14012	0	0	27412	2026-09-12 01:01:29	2026-09-11 02:01:26	USED	keep — in use
host_726.emp.PricingStatus.IX_ClaimEntry	2	NONCLUSTERED				1858794	3385	0	27412	2026-09-12 01:01:34	2026-09-11 02:01:26	USED	keep — in use
host_726.emp.PricingStatus.PK_LedgerResult	1	CLUSTERED	Y	Y		298609	12	13976	27412	2026-09-12 01:01:29	2026-09-11 02:01:26	USED	KEEP — primary key
host_726.emp.AssetDaily.IX_PayrollDaily	1	CLUSTERED				0	0	0	230	never	2026-09-11 02:01:27	UNUSED	KEEP — table storage
host_726.emp.PayrollHistory.PK_LedgerQueue	1	CLUSTERED	Y	Y		0	0	0	27412	never	2026-09-11 02:01:27	UNUSED	KEEP — primary key
host_726.emp.QuotaSummary.IX_StaffingQueue	10	NONCLUSTERED				122761	23366	0	1899	2026-09-12 01:01:11	2026-09-11 02:01:27	USED	keep — in use
host_726.emp.QuotaSummary.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	54	22922	1899	2026-09-11 23:52:08	2026-09-11 02:01:27	USED	KEEP — primary key
host_726.emp.PricingQueue.PK_PricingStaging	1	CLUSTERED	Y	Y		0	0	0	1455	never	2026-09-11 02:01:27	UNUSED	KEEP — primary key
host_726.emp.BookingMonthly.IX_ShipmentAudit	5	NONCLUSTERED				135116	1594968	0	2325	2026-09-12 01:01:31	2026-09-11 02:01:28	USED	keep — in use
host_726.emp.BookingMonthly.PK_WarehouseLog	1	CLUSTERED	Y	Y		14	0	0	2325	2026-09-11 12:11:36	2026-09-11 02:01:28	USED	KEEP — primary key
host_726.emp.MeterSnapshot.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	0	0	2325	never	2026-09-11 02:01:29	UNUSED	KEEP — primary key
host_726.emp.BatchMonthly.IX_ClaimSummary	18	NONCLUSTERED				0	137	0	2995	2026-09-11 20:17:21	2026-09-11 02:01:30	USED	keep — in use
host_726.emp.BatchMonthly.PK_InvoiceDetail	1	CLUSTERED	Y	Y		1861198	8016	132	2995	2026-09-12 01:01:31	2026-09-11 02:01:29	USED	KEEP — primary key
host_726.emp.BatchMonthly.IX_TerritorySnapshot	19	NONCLUSTERED	Y			2611	1	0	2995	2026-09-11 23:12:39	2026-09-11 02:01:30	USED	keep — in use
host_726.emp.WarehouseMonthly.IX_InvoiceStatus	1	CLUSTERED				0	0	0	908	never	2026-09-11 02:01:31	UNUSED	KEEP — table storage
host_726.emp.StaffingAudit.PK_ForecastHeader	1	CLUSTERED	Y	Y		0	5	0	3009	2026-09-11 01:15:01	2026-09-11 02:01:31	USED	KEEP — primary key
host_726.emp.BatchLog.PK_SalesDetail	1	CLUSTERED	Y	Y		139661	1597550	0	3257	2026-09-12 01:01:31	2026-09-11 02:01:32	USED	KEEP — primary key
host_726.emp.ReconcileSummary.IX_ShipmentDetail	1	CLUSTERED				0	0	0	16	never	2026-09-10 02:08:46	UNUSED	KEEP — table storage
host_726.emp.RouteHistory.PK_MeterEntry	1	CLUSTERED	Y	Y		0	0	0	3257	never	2026-09-11 02:01:32	UNUSED	KEEP — primary key
host_726.emp.CampaignResult.IX_ClaimStatus	15	NONCLUSTERED				537558	16	0	61860	2026-09-12 01:01:05	2026-09-11 02:02:16	USED	keep — in use
host_726.emp.CampaignResult.IX_ForecastAudit	14	NONCLUSTERED				241291	2	0	123688	2026-09-11 16:09:36	2026-09-11 02:02:16	USED	keep — in use
host_726.emp.CampaignResult.IX_CustomerQueue	6	NONCLUSTERED				1472230	0	0	123720	2026-09-12 01:01:32	2026-09-11 02:02:16	USED	keep — in use
host_726.emp.CampaignResult.PK_StaffingArchive	1	CLUSTERED	Y	Y		1148745	1006	2251091	123789	2026-09-12 01:01:32	2026-09-11 02:01:33	USED	KEEP — primary key
host_726.emp.SalesHeader.IX_BookingSummary	2	NONCLUSTERED				0	0	0	1410	never	2026-09-11 02:02:20	UNUSED	review, then DROP
host_726.emp.SalesHeader.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	0	0	1410	never	2026-09-11 02:02:20	UNUSED	KEEP — primary key
host_726.emp.PayrollHistory.PK_CampaignStaging	1	CLUSTERED	Y	Y		5674	31	0	222	2026-09-11 20:20:50	2026-09-11 02:02:17	USED	KEEP — primary key
host_726.emp.TerritoryDaily.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	222	never	2026-09-11 02:02:18	UNUSED	KEEP — primary key
host_726.emp.CatalogSummary.IX_PricingSnapshot	27	NONCLUSTERED				66861	0	0	408	2026-09-12 01:01:05	2026-09-11 02:02:18	USED	keep — in use
host_726.emp.CatalogSummary.IX_WarehouseSnapshot	7	NONCLUSTERED				137924	4924	0	277	2026-09-12 01:03:52	2026-09-11 02:02:18	USED	keep — in use
host_726.emp.CatalogSummary.IX_ReconcileSummary	21	NONCLUSTERED				583462	1	0	277	2026-09-12 01:01:34	2026-09-11 02:02:18	USED	keep — in use
host_726.emp.CatalogSummary.IX_AssetEntry	26	NONCLUSTERED				244878	1037	0	408	2026-09-12 01:01:34	2026-09-11 02:02:18	USED	keep — in use
host_726.emp.CatalogSummary.PK_ShipmentStaging	1	CLUSTERED	Y	Y		2233193	45873	814018	425	2026-09-12 01:03:52	2026-09-11 02:02:18	USED	KEEP — primary key
host_726.emp.CatalogSummary.UX_OrdersAudit	2	NONCLUSTERED	Y			15	47	0	277	2026-09-11 15:08:33	2026-09-11 02:02:18	USED	keep — in use
host_726.emp.CatalogSummary.UX_LedgerHistory	4	NONCLUSTERED	Y		Y	92289	0	0	425	2026-09-12 01:01:02	2026-09-11 02:02:18	USED	keep — in use
host_726.emp.TicketMonthly.PK_LedgerAudit	1	CLUSTERED	Y	Y		1363	364	0	625	2026-09-11 19:34:18	2026-09-11 02:02:19	USED	KEEP — primary key
host_726.emp.BillingQueue.IX_AssetDetail	11	NONCLUSTERED				13	157	0	596	2026-09-11 23:27:27	2026-09-11 02:02:19	USED	keep — in use
host_726.emp.BillingQueue.IX_ContractSummary	8	NONCLUSTERED				951200	3	0	596	2026-09-12 01:01:56	2026-09-11 02:02:19	USED	keep — in use
host_726.emp.BillingQueue.PK_ShipmentEntry	1	CLUSTERED	Y	Y		0	40700	951139	596	2026-09-12 01:01:56	2026-09-11 02:02:19	USED	KEEP — primary key
host_726.emp.CampaignResult.IX_SupplierLine	13	NONCLUSTERED				596	0	0	468	2026-09-11 18:36:27	2026-09-11 02:02:19	USED	keep — in use
host_726.emp.CampaignResult.PK_CustomerLine	1	CLUSTERED	Y	Y		0	657	596	468	2026-09-11 18:36:28	2026-09-11 02:02:19	USED	KEEP — primary key
host_726.guest.TerritoryQueue.IX_InvoiceStaging	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:03:03	COLD	review, then DROP
host_726.org.SettlementSnapshot.PK_org.SettlementSnapshot	1	CLUSTERED	Y	Y		0	38	0	0	2026-09-11 16:21:52	2026-09-06 02:03:14	USED	KEEP — primary key
host_726.org.SettlementSnapshot.UX_BillingLine	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:14	COLD	review carefully — unique
host_726.org.PolicySummary.IX_AssetEntry	3	NONCLUSTERED				311470	4584	0	26	2026-09-12 01:01:34	2026-09-11 02:02:20	USED	keep — in use
host_726.org.PolicySummary.PK_QuotaAudit	1	CLUSTERED	Y	Y		2932003	261132	311995	94	2026-09-12 01:03:52	2026-09-10 02:09:37	USED	KEEP — primary key
host_726.org.PolicySummary.UX_ForecastHistory	2	NONCLUSTERED	Y		Y	601	0	0	35	2026-09-11 18:26:37	2026-09-11 02:02:20	USED	keep — in use
host_726.org.BatchMonthly.PK_WarehouseSummary	1	CLUSTERED	Y	Y		76	1123	0	38	2026-09-11 20:11:51	2026-09-11 02:02:20	USED	KEEP — primary key
host_726.org.BatchMonthly.UX_SalesSnapshot	2	NONCLUSTERED	Y		Y	0	0	0	38	never	2026-09-11 02:02:20	UNUSED	review carefully — unique
host_726.org.CampaignQueue.PK_RosterDaily	1	CLUSTERED	Y	Y		0	0	0	54	never	2026-09-11 02:02:20	UNUSED	KEEP — primary key
host_726.org.TicketLog.PK_WarehouseDetail	1	CLUSTERED	Y	Y		83	92	7	71	2026-09-11 16:11:00	2026-09-06 02:03:14	USED	KEEP — primary key
host_726.org.TicketLog.UX_SalesMonthly	4	NONCLUSTERED	Y			7	0	0	71	2026-09-10 07:58:33	2026-09-11 02:02:20	USED	keep — in use
host_726.org.BatchDaily.PK_QuotaStaging	1	CLUSTERED	Y	Y		602726	122053	38	0	2026-09-12 01:03:52	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.BatchDaily.UX_PricingResult	2	NONCLUSTERED	Y		Y	0	38	0	0	2026-09-11 08:26:27	2026-09-06 02:03:15	USED	keep — in use
host_726.org.ShipmentAudit.PK_ForecastHeader	1	CLUSTERED	Y	Y		0	753864	314508	0	2026-09-12 01:03:00	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.ShipmentAudit.UX_BatchArchive	2	NONCLUSTERED	Y			313126	1403	0	0	2026-09-12 01:03:00	2026-09-06 02:03:15	USED	keep — in use
host_726.org.WarehouseStaging.PK_MeterHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:15	COLD	KEEP — primary key
host_726.org.BookingResult.PK_BillingQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.InvoiceQueue.PK_TicketEntry	1	CLUSTERED	Y	Y		5	113	0	0	2026-09-11 18:35:12	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.PricingStatus.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:15	COLD	KEEP — primary key
host_726.org.CatalogHeader.PK_ShiftStatus	1	CLUSTERED	Y	Y		437	146	0	8	2026-09-11 23:26:01	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.PolicySummary.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	0	0	8	never	2026-09-08 02:02:02	UNUSED	KEEP — primary key
host_726.org.CatalogAudit.PK_AssetStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:15	COLD	KEEP — primary key
host_726.org.OrdersSummary.PK_StaffingAudit	1	CLUSTERED	Y	Y		286	70	0	145	2026-09-11 18:24:10	2026-09-09 02:02:30	USED	KEEP — primary key
host_726.org.ContractResult.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	145	never	2026-09-09 02:02:30	UNUSED	KEEP — primary key
host_726.org.SupplierHistory.IX_ShipmentSummary	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:03:15	COLD	review, then DROP
host_726.org.SupplierHistory.PK_CustomerDetail	1	CLUSTERED	Y	Y		0	6748	0	0	2026-09-12 00:56:10	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.ContractStaging.PK_CatalogDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.BatchSummary.PK_SettlementHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.BillingHeader.IX_ShiftHistory	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:03:15	COLD	review, then DROP
host_726.org.BillingHeader.PK_InvoiceMonthly	1	CLUSTERED	Y	Y		0	1687	0	0	2026-09-12 00:56:10	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.ShipmentSummary.IX_StaffingResult	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:03:15	COLD	review, then DROP
host_726.org.ShipmentSummary.PK_ClaimDetail	1	CLUSTERED	Y	Y		0	1687	0	0	2026-09-12 00:56:10	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.SalesStatus.IX_ClaimHeader	2	NONCLUSTERED	Y			1688	0	0	0	2026-09-12 00:56:10	2026-09-06 02:03:15	USED	keep — in use
host_726.org.SalesStatus.PK_CampaignSnapshot	1	CLUSTERED	Y	Y		0	0	1688	0	2026-09-12 00:56:10	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.PolicyResult.PK_ForecastStaging	1	CLUSTERED	Y	Y		194	3964830	0	0	2026-09-12 01:01:31	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.AssetSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		15182	4948	0	0	2026-09-12 01:01:56	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.AssetSummary.UX_ShipmentSummary	2	NONCLUSTERED	Y			0	559	0	0	2026-09-11 22:31:20	2026-09-06 02:03:15	USED	keep — in use
host_726.org.ShipmentQueue.PK_InvoiceStaging	1	CLUSTERED	Y	Y		112635	393121	0	0	2026-09-12 01:01:32	2026-09-06 02:03:15	USED	KEEP — primary key
host_726.org.PolicyEntry.PK_SettlementSnapshot	1	CLUSTERED	Y	Y		2	114	0	4	2026-09-11 16:21:52	2026-09-08 02:02:02	USED	KEEP — primary key
host_726.org.PolicyEntry.UX_ShiftSnapshot	2	NONCLUSTERED	Y		Y	0	0	0	4	never	2026-09-08 02:02:02	UNUSED	review carefully — unique
host_726.org.MeterAudit.PK_BillingDetail	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-09-08 02:02:02	UNUSED	KEEP — primary key
host_726.org.BillingHeader.PK_ContractStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.TicketSnapshot.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.CustomerStaging.PK_CustomerHeader	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-09-08 02:02:02	UNUSED	KEEP — primary key
host_726.org.KPI.PK_ShiftLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.KPI.UX_ShiftHeader	2	NONCLUSTERED	Y		Y	0	0	0	0	never	never	COLD	review carefully — unique
host_726.org.StaffingArchive.PK_SettlementResult	1	CLUSTERED	Y	Y		0	37	0	0	2026-09-11 16:21:52	never	USED	KEEP — primary key
host_726.org.CustomerEntry.PK_RouteSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.PricingDaily.PK_CampaignArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.PricingDaily.UX_BillingArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host_726.org.TicketLine.PK_SupplierMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.BillingArchive.PK_MeterSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.MeterEntry.PK_SupplierLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.ReconcileAudit.PK_PolicyLog	1	CLUSTERED	Y	Y		81827	251	12	24	2026-09-12 00:50:49	2026-09-10 02:09:37	USED	KEEP — primary key
host_726.org.ReconcileAudit.UQ_ShipmentResult	2	NONCLUSTERED	Y		Y	26	0	0	24	2026-09-09 08:01:33	2026-09-10 02:09:37	USED	keep — in use
host_726.org.StaffingAudit.PK_RosterArchive	1	CLUSTERED	Y	Y		0	0	0	38	never	2026-09-10 02:09:37	UNUSED	KEEP — primary key
host_726.org.ShiftResult.PK_AssetAudit	1	CLUSTERED	Y	Y		2242649	635658	0	10	2026-09-12 01:01:33	2026-09-06 02:03:16	USED	KEEP — primary key
host_726.org.BatchMonthly.PK_SalesLine	1	CLUSTERED	Y	Y		10	7842	0	20	2026-09-12 00:23:11	2026-09-09 02:02:30	USED	KEEP — primary key
host_726.org.RosterMonthly.IX_AssetDetail	2	NONCLUSTERED				0	0	0	12	never	2026-09-09 02:02:30	UNUSED	review, then DROP
host_726.org.RosterMonthly.PK_ForecastDaily	1	CLUSTERED	Y	Y		6	66	0	12	2026-09-10 00:08:40	2026-09-09 02:02:30	USED	KEEP — primary key
host_726.org.InvoiceStaging.IX_AssetAudit	2	NONCLUSTERED				0	0	0	12	never	2026-09-09 02:02:30	UNUSED	review, then DROP
host_726.org.InvoiceStaging.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	0	0	12	never	2026-09-09 02:02:30	UNUSED	KEEP — primary key
host_726.org.StaffingAudit.PK_AssetLog	1	CLUSTERED	Y	Y		0	0	0	14	never	2026-09-10 02:09:37	UNUSED	KEEP — primary key
host_726.org.Level.PK_ShiftStaging	1	CLUSTERED	Y	Y		245908	1089	0	0	2026-09-12 01:01:34	2026-09-06 02:03:16	USED	KEEP — primary key
host_726.org.Level.UX_SettlementHistory	2	NONCLUSTERED	Y		Y	0	52	0	0	2026-09-11 16:21:52	2026-09-06 02:03:16	USED	keep — in use
host_726.org.ContractHistory.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:16	COLD	KEEP — primary key
host_726.org.QuotaEntry.IX_AssetHistory	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:03:16	COLD	review, then DROP
host_726.org.QuotaEntry.PK_LedgerQueue	1	CLUSTERED	Y	Y		0	318641	0	0	2026-09-12 01:01:32	2026-09-06 02:03:16	USED	KEEP — primary key
host_726.org.ClaimQueue.PK_LedgerHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:17	COLD	KEEP — primary key
host_726.org.SupplierLine.PK_InvoiceStatus	1	CLUSTERED	Y	Y		1128220	1743009	0	2	2026-09-12 01:01:29	2026-09-06 02:03:17	USED	KEEP — primary key
host_726.org.InvoiceHistory.PK_ContractDaily	1	CLUSTERED	Y	Y		0	6	0	0	2026-09-09 09:53:22	2026-09-06 02:03:17	USED	KEEP — primary key
host_726.org.AssetHeader.IX_PayrollAudit	2	NONCLUSTERED				2871213	0	0	1009	2026-09-12 01:01:29	2026-09-10 02:09:38	USED	keep — in use
host_726.org.AssetHeader.PK_LedgerResult	1	CLUSTERED	Y	Y		102	0	0	1009	2026-09-09 10:06:58	2026-09-10 02:09:38	USED	KEEP — primary key
host_726.org.TerritoryStatus.PK_PayrollLine	1	CLUSTERED	Y	Y		0	0	0	6	never	2026-09-10 02:09:38	UNUSED	KEEP — primary key
host_726.org.RosterLine.PK_BillingDaily	1	CLUSTERED	Y	Y		0	0	0	2	never	2026-09-10 02:09:38	UNUSED	KEEP — primary key
host_726.org.ForecastArchive.PK_CampaignHeader	1	CLUSTERED	Y	Y		78943	10	0	0	2026-09-12 01:01:29	2026-09-06 02:03:17	USED	KEEP — primary key
host_726.org.PolicySummary.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		3	382625	0	8	2026-09-12 01:01:29	2026-09-09 02:02:30	USED	KEEP — primary key
host_726.org.ClaimMonthly.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:17	COLD	KEEP — primary key
host_726.org.OrdersEntry.PK_MeterDaily	1	CLUSTERED	Y	Y		0	177630	0	0	2026-09-12 01:01:52	2026-09-06 02:03:17	USED	KEEP — primary key
host_726.org.LedgerStaging.PK_BatchLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:17	COLD	KEEP — primary key
host_726.org.Position.PK_PolicySummary	1	CLUSTERED	Y	Y		1165927	12733	0	9	2026-09-12 01:03:52	2026-09-08 02:02:02	USED	KEEP — primary key
host_726.org.Position.UX_MeterArchive	2	NONCLUSTERED	Y		Y	0	0	0	9	never	2026-09-08 02:02:02	UNUSED	review carefully — unique
host_726.org.CampaignQueue.PK_BillingArchive	1	CLUSTERED	Y	Y		15721	2629	290	12	2026-09-12 01:01:56	2026-09-11 02:02:21	USED	KEEP — primary key
host_726.org.CampaignQueue.UX_TicketDaily	2	NONCLUSTERED	Y			311616	55	0	10	2026-09-12 01:01:34	2026-09-11 02:02:21	USED	keep — in use
host_726.org.MeterResult.PK_CatalogStaging	1	CLUSTERED	Y	Y		0	6	0	20	2026-09-10 08:23:26	2026-09-11 02:02:21	USED	KEEP — primary key
host_726.org.QuotaLine.PK_AssetAudit	1	CLUSTERED	Y	Y		25	33	52	17	2026-09-11 16:21:52	2026-09-09 02:02:30	USED	KEEP — primary key
host_726.org.QuotaLine.UX_PricingAudit	2	NONCLUSTERED	Y		Y	0	52	0	17	2026-09-11 16:21:52	2026-09-08 15:27:30	USED	keep — in use
host_726.org.PayrollLog.PK_PayrollAudit	1	CLUSTERED	Y	Y		0	18	7	11	2026-09-07 14:08:50	2026-09-08 02:02:03	USED	KEEP — primary key
host_726.org.PayrollLog.UX_PayrollDetail	2	NONCLUSTERED	Y			7	0	0	11	2026-09-07 14:08:47	2026-09-08 02:02:03	USED	keep — in use
host_726.org.LedgerDaily.PK_ContractHeader	1	CLUSTERED	Y	Y		0	2	0	9	2026-09-10 07:23:57	2026-09-08 02:02:03	USED	KEEP — primary key
host_726.org.PricingArchive.PK_ShiftStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:17	COLD	KEEP — primary key
host_726.org.PricingArchive.UX_InvoiceAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:17	COLD	review carefully — unique
host_726.org.ForecastAudit.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	259	0	0	2026-09-11 15:11:00	2026-09-06 02:03:17	USED	KEEP — primary key
host_726.org.ForecastAudit.UX_ClaimArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:17	COLD	review carefully — unique
host_726.org.PayrollLine.PK_OrdersHistory	1	CLUSTERED	Y	Y		190	259	0	0	2026-09-11 18:22:32	2026-09-06 02:03:17	USED	KEEP — primary key
host_726.org.PayrollLine.UX_ShiftLog	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:17	COLD	review carefully — unique
host_726.org.BookingStaging.PK_AssetResult	1	CLUSTERED	Y	Y		1774983	134652	0	3	2026-09-12 01:01:52	2026-09-06 02:03:17	USED	KEEP — primary key
host_726.org.ReconcileLine.PK_CustomerLog	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-09-06 02:03:18	UNUSED	KEEP — primary key
host_726.org.ShiftStaging.PK_BillingHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:18	COLD	KEEP — primary key
host_726.org.ShiftStaging.UQ_PolicyAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:18	COLD	review carefully — unique
host_726.org.CustomerLine.IX_ForecastLine	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:03:18	COLD	review, then DROP
host_726.org.CustomerLine.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	1554	0	0	2026-09-12 00:56:10	2026-09-06 02:03:18	USED	KEEP — primary key
host_726.org.CustomerLine.UQ_PayrollLog	3	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:18	COLD	review carefully — unique
host_726.org.InvoiceMonthly.PK_WarehouseQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:18	COLD	KEEP — primary key
host_726.org.InvoiceMonthly.UQ_MeterAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:18	COLD	review carefully — unique
host_726.org.QuotaStaging.PK_ShiftStaging	1	CLUSTERED	Y	Y		0	2	1551	0	2026-09-12 00:56:10	2026-09-06 02:03:18	USED	KEEP — primary key
host_726.org.QuotaStaging.UQ_ShiftMonthly	2	NONCLUSTERED	Y			1551	0	0	0	2026-09-12 00:56:10	2026-09-06 02:03:18	USED	keep — in use
host_726.org.BatchMonthly.PK_WarehouseHeader	1	CLUSTERED	Y	Y		0	1486	0	0	2026-09-12 00:56:10	2026-09-06 02:03:18	USED	KEEP — primary key
host_726.org.BatchMonthly.UQ_LedgerStaging	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:18	COLD	review carefully — unique
host_726.org.ClaimHeader.PK_ClaimArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:18	COLD	KEEP — primary key
host_726.org.SupplierResult.PK_ForecastQueue	1	CLUSTERED	Y	Y		17	21403	0	0	2026-09-11 22:18:31	2026-09-06 02:03:18	USED	KEEP — primary key
host_726.org.RouteSummary.PK_RosterAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.RouteSummary.UX_SupplierSummary	2	NONCLUSTERED	Y		Y	0	0	0	0	never	never	COLD	review carefully — unique
host_726.org.ClaimDetail.PK_RouteMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.ShiftResult.PK_ForecastEntry	1	CLUSTERED	Y	Y		1002	1490	835124	1406	2026-09-12 01:01:31	2026-09-11 02:02:21	USED	KEEP — primary key
host_726.org.ShiftResult.UX_LedgerStaging	2	NONCLUSTERED	Y			835134	1	0	1406	2026-09-12 01:01:31	2026-09-11 02:02:21	USED	keep — in use
host_726.org.QuotaResult.PK_CampaignDaily	1	CLUSTERED	Y	Y		27557	692	0	0	2026-09-12 01:01:29	2026-09-06 02:03:18	USED	KEEP — primary key
host_726.org.QuotaResult.UX_BatchDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:18	COLD	review carefully — unique
host_726.org.QuotaDetail.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	3198312	0	0	2026-09-12 01:01:31	2026-09-06 02:03:18	USED	KEEP — primary key
host_726.org.BookingLog.PK_MeterStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:18	COLD	KEEP — primary key
host_726.org.SettlementAudit.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:18	COLD	KEEP — primary key
host_726.oth.QuotaSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		5	5	0	0	2026-09-09 22:56:53	2026-09-06 02:03:20	USED	KEEP — primary key
host_726.oth.InvoiceStatus.PK_ShiftQueue	1	CLUSTERED	Y	Y		263	32	0	0	2026-09-12 00:26:18	2026-09-06 02:03:20	USED	KEEP — primary key
host_726.oth.SupplierLine.PK_QuotaDetail	1	CLUSTERED	Y	Y		0	3	0	0	2026-09-09 22:56:53	2026-09-06 02:03:20	USED	KEEP — primary key
host_726.oth.SupplierLine.UX_InvoiceHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:20	COLD	review carefully — unique
host_726.oth.StaffingArchive.IX_InvoiceStaging	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:03:20	COLD	review, then DROP
host_726.oth.StaffingArchive.PK_PricingAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:20	COLD	KEEP — primary key
host_726.oth.StaffingArchive.UQ_SalesAudit	3	NONCLUSTERED	Y			15	259	0	0	2026-09-12 00:26:18	2026-09-06 02:03:20	USED	keep — in use
host_726.oth.CustomerQueue.IX_WarehouseResult	2	NONCLUSTERED				8	5	0	0	2026-09-09 22:56:53	2026-09-06 02:03:20	USED	keep — in use
host_726.oth.CustomerQueue.PK_TerritoryResult	1	CLUSTERED	Y	Y		0	19	5	0	2026-09-09 22:56:53	2026-09-06 02:03:20	USED	KEEP — primary key
host_726.rec.SettlementQueue.PK_BookingArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.SettlementQueue.UX_CatalogLine	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host_726.rec.AssetEntry.PK_BatchArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.ShipmentDetail.PK_QuotaResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.ShipmentDetail.UX_SalesLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host_726.rec.CustomerLine.PK_ShiftStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.SettlementAudit.PK_PricingHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.PricingResult.PK_AssetHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.OrdersMonthly.PK_ContractStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.OrdersMonthly.UX_AssetSnapshot	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host_726.rec.RosterArchive.PK_ContractAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.SalesQueue.PK_LedgerLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.MeterArchive.PK_ForecastResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.MeterArchive.UX_PayrollLine	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host_726.rec.PayrollStatus.PK_ForecastMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.CampaignStatus.PK_InvoiceHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.ReconcileStatus.PK_BatchDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.ShipmentMonthly.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.ForecastSummary.PK_ReconcileLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.CustomerDetail.PK_SalesSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.AssetSnapshot.PK_PolicyResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.AssetSnapshot.UX_ContractArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host_726.rec.CustomerQueue.PK_InvoiceLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.BatchSnapshot.PK_TicketLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.StaffingLine.PK_RosterSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.LedgerStatus.PK_InvoiceDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.sal.SalesHistory.PK_QuotaLine	1	CLUSTERED	Y	Y		0	2350	0	140	2026-09-12 01:01:57	2026-09-11 02:02:21	USED	KEEP — primary key
host_726.sal.ClaimArchive.IX_RouteDetail	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:03:20	COLD	review, then DROP
host_726.sal.ClaimArchive.PK_LedgerHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:20	COLD	KEEP — primary key
host_726.sal.QuotaLine.PK_ContractArchive	1	CLUSTERED	Y	Y		1529	18209	0	0	2026-09-12 01:03:00	2026-09-06 02:03:20	USED	KEEP — primary key
host_726.sal.SalesStatus.PK_ShiftMonthly	1	CLUSTERED	Y	Y		16332	268	0	20	2026-09-12 01:01:56	2026-09-11 02:02:21	USED	KEEP — primary key
host_726.sal.SettlementQueue.PK_StaffingSnapshot	1	CLUSTERED	Y	Y		0	19065	0	16335	2026-09-12 01:01:56	2026-09-11 02:02:21	USED	KEEP — primary key
host_726.sal.MeterHistory.PK_LedgerSnapshot	1	CLUSTERED	Y	Y		0	1045	0	16335	2026-09-12 00:56:09	2026-09-11 02:02:22	USED	KEEP — primary key
host_726.sal.ShipmentAudit.PK_BatchDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.sal.RouteResult.PK_OrdersAudit	1	CLUSTERED	Y	Y		0	66	0	0	2026-09-11 18:22:31	2026-09-06 02:03:21	USED	KEEP — primary key
host_726.sal.RouteResult.UX_ContractEntry	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:21	COLD	review carefully — unique
host_726.sal.WarehouseDaily.PK_SettlementDetail	1	CLUSTERED	Y	Y		2011	1249	0	7	2026-09-11 20:11:56	2026-09-10 02:09:39	USED	KEEP — primary key
host_726.sal.WarehouseDaily.UX_BookingAudit	2	NONCLUSTERED	Y			2	0	0	6	2026-09-09 15:48:18	2026-09-10 02:09:39	USED	keep — in use
host_726.sal.InvoiceLog.PK_MeterAudit	1	CLUSTERED	Y	Y		35	74	0	34	2026-09-11 18:22:31	2026-09-10 02:09:39	USED	KEEP — primary key
host_726.sal.PolicySnapshot.PK_ReconcileQueue	1	CLUSTERED	Y	Y		0	2	0	34	2026-09-09 15:55:25	2026-09-10 02:09:39	USED	KEEP — primary key
host_726.sal.SettlementStatus.PK_ReconcileResult	1	CLUSTERED	Y	Y		230	89	290	216	2026-09-11 18:36:13	2026-09-10 02:09:39	USED	KEEP — primary key
host_726.sal.SettlementStatus.UX_StaffingMonthly	2	NONCLUSTERED	Y			289	1	0	216	2026-09-11 18:36:13	2026-09-10 02:09:39	USED	keep — in use
host_726.sal.ReconcileHistory.PK_PayrollHeader	1	CLUSTERED	Y	Y		20	70	1	42	2026-09-11 08:18:05	2026-09-10 02:09:39	USED	KEEP — primary key
host_726.sal.ReconcileHistory.UX_TicketQueue	2	NONCLUSTERED	Y			1	0	0	42	2026-09-09 14:08:21	2026-09-10 02:09:39	USED	keep — in use
host_726.sal.InvoiceEntry.PK_RouteQueue	1	CLUSTERED	Y	Y		0	0	0	42	never	2026-09-10 02:09:39	UNUSED	KEEP — primary key
host_726.sal.BillingQueue.PK_ReconcileHistory	1	CLUSTERED	Y	Y		0	0	0	215	never	2026-09-10 02:09:39	UNUSED	KEEP — primary key
host_726.sal.RosterDetail.PK_BookingStaging	1	CLUSTERED	Y	Y		0	0	0	7	never	2026-09-10 02:09:40	UNUSED	KEEP — primary key
host_726.sal.RosterQueue.PK_ShiftQueue	1	CLUSTERED	Y	Y		0	773	0	0	2026-09-12 00:56:10	2026-09-06 02:03:23	USED	KEEP — primary key
host_726.sal.RosterQueue.UX_RosterArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:23	COLD	review carefully — unique
host_726.sal.WarehouseHeader.PK_RouteEntry	1	CLUSTERED	Y	Y		0	91	0	0	2026-09-12 00:09:34	2026-09-06 02:03:23	USED	KEEP — primary key
host_726.sal.SupplierArchive.PK_SupplierStaging	1	CLUSTERED	Y	Y		0	21	0	0	2026-09-11 20:19:41	2026-09-06 02:03:23	USED	KEEP — primary key
host_726.sal.RosterQueue.PK_PolicyLog	1	CLUSTERED	Y	Y		0	1	0	0	2026-09-07 12:34:54	2026-09-06 02:03:23	USED	KEEP — primary key
host_726.sal.CustomerSnapshot.PK_RosterEntry	1	CLUSTERED	Y	Y		0	21	0	0	2026-09-11 20:19:41	2026-09-06 02:03:23	USED	KEEP — primary key
host_726.sal.LedgerStatus.PK_WarehouseStaging	1	CLUSTERED	Y	Y		1	2	0	0	2026-09-09 13:39:32	2026-09-06 02:03:23	USED	KEEP — primary key
host_726.sal.BookingLine.PK_PricingAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:23	COLD	KEEP — primary key
host_726.sal.PricingLine.PK_BatchLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:23	COLD	KEEP — primary key
host_726.sal.WarehouseStaging.PK_SettlementHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:23	COLD	KEEP — primary key
host_726.sal.StaffingArchive.PK_CatalogLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:23	COLD	KEEP — primary key
host_726.sal.WarehouseSummary.PK_RosterArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:23	COLD	KEEP — primary key
host_726.schedule.CustomerDetail.PK_CatalogStaging	1	CLUSTERED	Y	Y		0	123	764513	0	2026-09-12 01:01:31	2026-09-06 02:03:23	USED	KEEP — primary key
host_726.schedule.CustomerDetail.UQ_BillingSnapshot	3	NONCLUSTERED	Y			763852	530	0	0	2026-09-12 01:01:31	2026-09-06 02:03:23	USED	keep — in use
host_726.schedule.CustomerDetail.UQ_CampaignResult	2	NONCLUSTERED	Y			764596	169	0	0	2026-09-12 01:01:31	2026-09-06 02:03:23	USED	keep — in use
host_726.schedule.InvoiceHistory.IX_StaffingHeader	3	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:03:23	COLD	review, then DROP
host_726.schedule.InvoiceHistory.PK_ContractLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:03:23	COLD	KEEP — primary key
host_726.schedule.InvoiceHistory.UQ_LedgerResult	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:23	COLD	review carefully — unique
host_726.schedule.MeterStaging.PK_SettlementMonthly	1	CLUSTERED	Y	Y		637807	0	0	541	2026-09-12 01:01:32	2026-09-10 02:09:40	USED	KEEP — primary key
host_726.schedule.SettlementLine.PK_CampaignStatus	1	CLUSTERED	Y	Y		764920	84	0	168	2026-09-12 01:01:31	2026-09-10 02:09:40	USED	KEEP — primary key
host_726.schedule.TicketEntry.PK_CampaignDaily	1	CLUSTERED	Y	Y		84	168	0	168	2026-09-11 23:26:01	2026-09-10 02:09:40	USED	KEEP — primary key
host_726.schedule.QuotaSummary.PK_LedgerStatus	1	CLUSTERED	Y	Y		1938020	1374	0	90	2026-09-12 01:01:31	2026-09-10 02:09:40	USED	KEEP — primary key
host_726.schedule.ShipmentLog.PK_SalesEntry	1	CLUSTERED	Y	Y		793943	0	0	1058	2026-09-12 01:01:31	2026-09-11 23:26:01	USED	KEEP — primary key
host_726.schedule.PricingResult.PK_CampaignDaily	1	CLUSTERED	Y	Y		763960	758	0	84	2026-09-12 01:01:31	2026-09-06 02:03:23	USED	KEEP — primary key
host_726.schedule.SupplierSnapshot.IX_BillingHeader	3	NONCLUSTERED				1763320	526	0	2484767	2026-09-12 01:01:31	2026-09-11 20:33:09	USED	keep — in use
host_726.schedule.SupplierSnapshot.PK_AssetStatus	1	CLUSTERED	Y	Y		4127965	198720	2243145	3277649	2026-09-12 01:01:32	2026-09-11 20:33:09	USED	KEEP — primary key
host_726.schedule.SupplierSnapshot.IX_ContractLog	2	NONCLUSTERED	Y			13	715284	0	1528780	2026-09-12 01:01:30	2026-09-11 20:33:09	USED	keep — in use
host_726.schedule.BatchDetail.PK_AssetDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.schedule.RosterSummary.IX_BatchDetail	2	NONCLUSTERED				495510	593	0	1274822	2026-09-12 01:01:32	2026-09-11 23:25:58	USED	keep — in use
host_726.schedule.RosterSummary.IX_ClaimHeader	3	NONCLUSTERED				732659	396	0	1274822	2026-09-12 01:01:32	2026-09-11 23:25:58	USED	keep — in use
host_726.schedule.RosterSummary.PK_CustomerAudit	1	CLUSTERED	Y	Y		21569596	167	273027	2549651	2026-09-12 01:01:32	2026-09-11 23:25:58	USED	KEEP — primary key
host_726.schedule.BillingDetail.IX_TicketHeader	2	NONCLUSTERED				8479223	547	0	5277911	2026-09-12 01:01:32	2026-09-11 23:26:00	USED	keep — in use
host_726.schedule.BillingDetail.PK_BillingLog	1	CLUSTERED	Y	Y		32514157	36571	5708208	6234026	2026-09-12 01:01:33	2026-09-11 23:26:00	USED	KEEP — primary key
host_726.schedule.PolicyStatus.IX_ForecastAudit	2	NONCLUSTERED				5818074	0	0	11013421	2026-09-12 01:01:32	2026-09-11 23:27:06	USED	keep — in use
host_726.schedule.PolicyStatus.IX_SupplierLine	3	NONCLUSTERED				7047759	171	0	11013421	2026-09-12 01:01:32	2026-09-11 23:27:07	USED	keep — in use
host_726.schedule.PolicyStatus.PK_PricingDaily	1	CLUSTERED	Y	Y		13887099	402	4179342	11013421	2026-09-12 01:01:32	2026-09-11 23:27:06	USED	KEEP — primary key
host_726.schedule.PolicyLine.IX_TerritorySnapshot	2	NONCLUSTERED				9391056	258	0	1200713	2026-09-12 01:01:32	2026-09-11 20:23:56	USED	keep — in use
host_726.schedule.PolicyLine.PK_BookingAudit	1	CLUSTERED	Y	Y		5276369	468	307968	2156747	2026-09-12 01:01:32	2026-09-11 20:23:56	USED	KEEP — primary key
host_726.schedule.AssetResult.IX_BillingResult	2	NONCLUSTERED				1075763	0	0	1075763	2026-09-12 01:01:32	never	USED	keep — in use
host_726.schedule.AssetResult.PK_TicketQueue	1	CLUSTERED	Y	Y		0	0	0	1075763	never	never	UNUSED	KEEP — primary key
host_726.schedule.InvoiceAudit.IX_StaffingQueue	2	NONCLUSTERED				11695025	76	0	3824187	2026-09-12 01:01:32	2026-09-11 23:24:15	USED	keep — in use
host_726.schedule.InvoiceAudit.PK_LedgerMonthly	1	CLUSTERED	Y	Y		5120892	175	486535	3824187	2026-09-12 01:01:32	2026-09-11 23:24:15	USED	KEEP — primary key
host_726.schedule.SettlementLog.IX_TicketLine	2	NONCLUSTERED				8243470	0	0	12747387	2026-09-12 01:01:32	2026-09-11 23:24:08	USED	keep — in use
host_726.schedule.SettlementLog.IX_PolicyLine	3	NONCLUSTERED				1482261	81	0	12747387	2026-09-12 01:01:32	2026-09-11 23:24:09	USED	keep — in use
host_726.schedule.SettlementLog.PK_CatalogMonthly	1	CLUSTERED	Y	Y		16513086	8	337934	13703423	2026-09-12 01:01:32	2026-09-11 23:24:09	USED	KEEP — primary key
host_726.schedule.ShiftHeader.IX_TicketStatus	4	NONCLUSTERED				1192	78	0	3171568	2026-09-09 13:10:48	2026-09-11 20:33:10	USED	keep — in use
host_726.schedule.ShiftHeader.IX_ShipmentLine	3	NONCLUSTERED				7639201	2	0	3171568	2026-09-12 01:01:33	2026-09-11 20:33:10	USED	keep — in use
host_726.schedule.ShiftHeader.PK_OrdersArchive	1	CLUSTERED	Y	Y		73504753	902	2374489	5550214	2026-09-12 01:01:33	2026-09-11 23:26:05	USED	KEEP — primary key
host_726.schedule.ShiftHeader.IX_BookingStatus	2	NONCLUSTERED	Y			16496	1460	0	3171568	2026-09-11 23:27:23	2026-09-11 20:33:11	USED	keep — in use
host_726.schedule.PolicyLine.PK_RouteQueue	1	CLUSTERED	Y	Y		29558830	710424	0	3171535	2026-09-12 01:01:33	2026-09-11 23:26:00	USED	KEEP — primary key
host_726.schedule.PolicyLine.UX_TerritoryHistory	2	NONCLUSTERED	Y		Y	0	0	0	1585787	never	2026-09-11 23:27:30	UNUSED	review carefully — unique
host_726.schedule.RosterHistory.IX_AssetSummary	2	NONCLUSTERED				5791509	901	0	1585806	2026-09-12 01:01:32	2026-09-11 19:32:37	USED	keep — in use
host_726.schedule.RosterHistory.PK_WarehouseLine	1	CLUSTERED	Y	Y		2504977	0	565	1585806	2026-09-12 01:01:32	2026-09-11 19:32:37	USED	KEEP — primary key
host_726.schedule.MeterStaging.IX_PayrollAudit	2	NONCLUSTERED				8767372	800292	0	1585808	2026-09-12 01:01:32	2026-09-11 23:23:39	USED	keep — in use
host_726.schedule.MeterStaging.PK_PolicyArchive	1	CLUSTERED	Y	Y		1944595	0	243048	1585808	2026-09-12 01:01:32	2026-09-11 23:23:39	USED	KEEP — primary key
host_726.schedule.CustomerHistory.IX_LedgerQueue	2	NONCLUSTERED				445587	5584	0	8284669	2026-09-12 01:01:32	2026-09-11 23:24:43	USED	keep — in use
host_726.schedule.CustomerHistory.PK_PayrollAudit	1	CLUSTERED	Y	Y		13255885	144	6826	8284669	2026-09-12 01:01:32	2026-09-11 23:24:43	USED	KEEP — primary key
host_726.schedule.RosterResult.IX_BookingAudit	2	NONCLUSTERED				53	2740	0	3823723	2026-09-11 23:27:22	2026-09-11 23:25:53	USED	keep — in use
host_726.schedule.RosterResult.IX_AssetStaging	3	NONCLUSTERED				2111410	52	0	3823723	2026-09-12 01:01:32	2026-09-11 23:25:54	USED	keep — in use
host_726.schedule.RosterResult.PK_PricingSummary	1	CLUSTERED	Y	Y		10111109	2769	334922	3823723	2026-09-12 01:01:33	2026-09-11 23:25:53	USED	KEEP — primary key
host_726.schedule.LedgerSnapshot.PK_RouteStatus	1	CLUSTERED	Y	Y		5523134	408618	0	12	2026-09-12 01:01:32	2026-09-10 03:59:16	USED	KEEP — primary key
host_726.schedule.LedgerSnapshot.IX_TicketLine	2	NONCLUSTERED	Y			17	1	0	12	2026-09-09 13:01:17	2026-09-10 03:59:16	USED	keep — in use
host_726.schedule.RosterHistory.PK_MeterLine	1	CLUSTERED	Y	Y		3115517	0	0	529	2026-09-12 01:01:31	2026-09-10 03:59:16	USED	KEEP — primary key
host_726.schedule.AssetStaging.PK_CampaignResult	1	CLUSTERED	Y	Y		2350148	530	0	529	2026-09-12 01:01:31	2026-09-10 03:59:16	USED	KEEP — primary key
host_726.schedule.InvoiceLog.PK_CatalogSummary	1	CLUSTERED	Y	Y		160780	276673	4493	7	2026-09-12 01:01:34	2026-09-06 02:03:23	USED	KEEP — primary key
host_726.schedule.InvoiceLog.IX_WarehouseHeader	2	NONCLUSTERED	Y			4500	0	0	7	2026-09-12 00:23:11	2026-09-11 02:02:22	USED	keep — in use
host_726.schedule.ContractResult.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	193539	0	7	2026-09-12 01:01:34	2026-09-11 02:02:22	USED	KEEP — primary key
host_726.schedule.ContractResult.UX_CampaignHistory	2	NONCLUSTERED	Y		Y	248382	11	0	7	2026-09-12 01:01:30	2026-09-11 02:02:22	USED	keep — in use
host_726.schedule.SalesArchive.IX_RosterStatus	1	CLUSTERED				0	0	0	7	never	2026-09-11 02:02:22	UNUSED	KEEP — table storage
host_726.schedule.CatalogHistory.PK_OrdersStatus	1	CLUSTERED	Y	Y		132594	9	0	0	2026-09-12 01:01:34	2026-09-06 02:03:23	USED	KEEP — primary key
host_726.schedule.CatalogHistory.IX_PricingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:03:23	COLD	review carefully — unique
host_726.schedule.engine.PK_ReconcileDaily	1	CLUSTERED	Y	Y		11968130	1	1881388	0	2026-09-12 01:01:32	2026-09-06 02:08:38	USED	KEEP — primary key
host_726.schedule.engine.UQ_MeterQueue	2	NONCLUSTERED	Y			1881405	0	0	0	2026-09-12 01:01:32	2026-09-06 02:08:38	USED	keep — in use
host_726.schedule.TerritoryAudit.PK_PayrollSnapshot	1	CLUSTERED	Y	Y		0	12	1796799	1039821	2026-09-12 01:01:32	2026-09-11 02:09:18	USED	KEEP — primary key
host_726.schedule.TerritoryAudit.UX_BookingHeader	2	NONCLUSTERED	Y		Y	1796799	0	0	757023	2026-09-12 01:01:32	2026-09-11 02:09:20	USED	keep — in use
host_726.schedule.WarehouseArchive.IX_CustomerHistory	2	NONCLUSTERED				0	0	0	1585876	never	2026-09-11 23:48:38	UNUSED	review, then DROP
host_726.schedule.WarehouseArchive.IX_OrdersHeader	3	NONCLUSTERED				805641	17	0	1585876	2026-09-12 01:01:31	2026-09-11 23:48:38	USED	keep — in use
host_726.schedule.WarehouseArchive.PK_RouteAudit	1	CLUSTERED	Y	Y		2852959	805709	2	2852963	2026-09-12 01:01:32	never	USED	KEEP — primary key
host_726.schedule.LedgerMonthly.IX_CatalogDaily	2	NONCLUSTERED				0	0	0	24302687	never	never	UNUSED	review, then DROP
host_726.schedule.LedgerMonthly.IX_CustomerMonthly	3	NONCLUSTERED				805641	15	0	24302687	2026-09-12 01:01:31	never	USED	keep — in use
host_726.schedule.LedgerMonthly.PK_ClaimLine	1	CLUSTERED	Y	Y		36454005	15	0	36454022	2026-09-12 01:01:32	never	USED	KEEP — primary key
host_726.schedule.RouteAudit.IX_InvoiceHeader	2	NONCLUSTERED				1	0	0	805639	2026-09-11 13:58:48	2026-09-11 12:27:28	USED	keep — in use
host_726.schedule.RouteAudit.IX_SettlementDetail	3	NONCLUSTERED			Y	0	2	0	792929	2026-09-08 09:05:17	never	USED	keep — in use
host_726.schedule.RouteAudit.IX_CatalogArchive	4	NONCLUSTERED				2035	77	0	805639	2026-09-12 00:58:17	2026-09-11 12:27:29	USED	keep — in use
host_726.schedule.RouteAudit.IX_QuotaStaging	5	NONCLUSTERED				0	74	0	805639	2026-09-11 20:40:28	2026-09-11 12:27:30	USED	keep — in use
host_726.schedule.RouteAudit.PK_PayrollAudit	1	CLUSTERED	Y	Y		0	136	2172	805639	2026-09-12 00:58:17	2026-09-11 12:27:29	USED	KEEP — primary key
host_726.schedule.ShipmentHeader.IX_QuotaSnapshot	2	NONCLUSTERED				0	0	0	12151350	never	2026-09-11 02:10:13	UNUSED	review, then DROP
host_726.schedule.ShipmentHeader.IX_InvoiceSummary	4	NONCLUSTERED				0	0	0	12151350	never	2026-09-11 02:12:05	UNUSED	review, then DROP
host_726.schedule.ShipmentHeader.IX_CampaignHistory	3	NONCLUSTERED				0	0	0	12151350	never	2026-09-11 02:12:23	UNUSED	review, then DROP
host_726.schedule.ShipmentHeader.PK_CampaignDetail	1	CLUSTERED	Y	Y		0	0	0	12151350	never	2026-09-11 02:10:13	UNUSED	KEEP — primary key
host_726.schedule.SupplierEntry.PK_AssetSnapshot	1	CLUSTERED	Y	Y		5537612	0	0	0	2026-09-12 01:01:32	2026-09-06 02:09:54	USED	KEEP — primary key
host_726.schedule.TerritoryDetail.PK_ReconcileMonthly	1	CLUSTERED	Y	Y		17	0	0	34	2026-09-11 20:30:49	2026-09-11 02:12:23	USED	KEEP — primary key
host_726.schedule.StaffingEntry.PK_QuotaDetail	1	CLUSTERED	Y	Y		55509114	47	32	51	2026-09-12 01:01:32	2026-09-11 02:12:23	USED	KEEP — primary key
host_726.schedule.StaffingEntry.UQ_TicketDetail	2	NONCLUSTERED	Y			17	0	0	17	2026-09-11 20:30:49	2026-09-11 02:12:23	USED	keep — in use
host_726.schedule.StaffingEntry.UX_PayrollDaily	3	NONCLUSTERED	Y		Y	11075574	32	0	34	2026-09-12 01:01:32	2026-09-11 02:12:23	USED	keep — in use
host_726.schedule.ForecastMonthly.IX_WarehouseDaily	2	NONCLUSTERED				14	0	0	55509063	2026-09-11 20:37:48	2026-09-11 20:34:25	USED	keep — in use
host_726.schedule.ForecastMonthly.IX_PayrollHistory	3	NONCLUSTERED				2	0	0	55509063	2026-09-08 12:45:32	2026-09-11 20:34:26	USED	keep — in use
host_726.schedule.ForecastMonthly.IX_BatchMonthly	4	NONCLUSTERED				34	22	0	55509063	2026-09-11 20:34:26	2026-09-11 20:34:24	USED	keep — in use
host_726.schedule.ForecastMonthly.PK_ForecastHistory	1	CLUSTERED	Y	Y		55509057	37	57	111018120	2026-09-12 01:01:32	2026-09-11 20:34:25	USED	KEEP — primary key
host_726.schedule.CatalogEntry.PK_PolicyDetail	1	CLUSTERED	Y	Y		11075574	0	0	0	2026-09-12 01:01:32	2026-09-06 02:14:22	USED	KEEP — primary key
host_726.schedule.CatalogEntry.UQ_AssetAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:22	COLD	review carefully — unique
host_726.schedule.ContractAudit.PK_TicketSummary	1	CLUSTERED	Y	Y		55509063	0	0	0	2026-09-12 01:01:32	2026-09-06 02:14:22	USED	KEEP — primary key
host_726.schedule.ContractAudit.UQ_OrdersStaging	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:22	COLD	review carefully — unique
host_726.schedule.ContractAudit.UX_BillingSnapshot	3	NONCLUSTERED	Y		Y	11075574	0	0	0	2026-09-12 01:01:32	2026-09-06 02:14:22	USED	keep — in use
host_726.schedule.SupplierSummary.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	17	0	0	2026-09-11 20:30:49	2026-09-06 02:14:22	USED	KEEP — primary key
host_726.schedule.SupplierSummary.UQ_BillingStaging	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:22	COLD	review carefully — unique
host_726.schedule.PayrollDaily.PK_CustomerQueue	1	CLUSTERED	Y	Y		7835972	130352	0	0	2026-09-12 01:01:32	2026-09-06 02:14:22	USED	KEEP — primary key
host_726.schedule.WarehouseDaily.PK_QuotaAudit	1	CLUSTERED	Y	Y		17	0	0	0	2026-09-11 20:30:49	2026-09-06 02:14:22	USED	KEEP — primary key
host_726.schedule.WarehouseDaily.UQ_ShiftEntry	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:22	COLD	review carefully — unique
host_726.schedule.WarehouseDaily.UX_TerritorySummary	3	NONCLUSTERED	Y		Y	17	0	0	0	2026-09-11 20:30:49	2026-09-06 02:14:22	USED	keep — in use
host_726.schedule.sql.IX_PayrollEntry	3	NONCLUSTERED			Y	11075574	22	0	166	2026-09-12 01:01:32	2026-09-10 03:59:16	USED	keep — in use
host_726.schedule.sql.PK_ContractMonthly	1	CLUSTERED	Y	Y		514	23	237	166	2026-09-11 20:37:48	2026-09-10 03:59:16	USED	KEEP — primary key
host_726.schedule.sql.UQ_SalesStatus	2	NONCLUSTERED	Y			263	83	0	3	2026-09-11 20:34:26	2026-09-10 03:59:16	USED	keep — in use
host_726.schedule.LedgerStatus.PK_SettlementQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:22	COLD	KEEP — primary key
host_726.schedule.LedgerStatus.UQ_QuotaAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:22	COLD	review carefully — unique
host_726.schedule.OrdersQueue.PK_QuotaQueue	1	CLUSTERED	Y	Y		17	0	0	34	2026-09-11 20:30:49	2026-09-11 02:27:32	USED	KEEP — primary key
host_726.schedule.LedgerStaging.IX_StaffingLog	3	NONCLUSTERED				11076041	44	0	492	2026-09-12 01:01:32	2026-09-11 02:27:32	USED	keep — in use
host_726.schedule.LedgerStaging.PK_ContractQueue	1	CLUSTERED	Y	Y		55509572	36	11075703	492	2026-09-12 01:01:32	2026-09-11 02:27:32	USED	KEEP — primary key
host_726.schedule.LedgerStaging.UQ_TicketResult	2	NONCLUSTERED	Y			31	31	0	166	2026-09-11 20:37:48	2026-09-11 02:27:32	USED	keep — in use
host_726.schedule.LedgerStaging.UX_QuotaHeader	4	NONCLUSTERED	Y		Y	0	0	0	326	never	2026-09-11 02:27:32	UNUSED	review carefully — unique
host_726.schedule.step.PK_AssetStaging	1	CLUSTERED	Y	Y		11868527	0	0	0	2026-09-12 01:01:32	2026-09-06 02:14:23	USED	KEEP — primary key
host_726.schedule.step.UQ_AssetQueue	3	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:23	COLD	review carefully — unique
host_726.schedule.step.UQ_OrdersLine	2	NONCLUSTERED	Y			0	1	0	0	2026-09-11 20:30:27	2026-09-06 02:14:23	USED	keep — in use
host_726.schedule.ShipmentResult.PK_MeterSnapshot	1	CLUSTERED	Y	Y		17	0	0	34	2026-09-11 20:30:49	2026-09-11 02:27:33	USED	KEEP — primary key
host_726.schedule.WarehouseEntry.PK_SettlementLine	1	CLUSTERED	Y	Y		55509098	11075611	0	0	2026-09-12 01:01:32	2026-09-06 02:14:24	USED	KEEP — primary key
host_726.schedule.WarehouseEntry.UQ_ShiftSnapshot	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:24	COLD	review carefully — unique
host_726.schedule.WarehouseEntry.UX_OrdersLog	3	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-09-06 02:14:24	COLD	review carefully — unique
host_726.wps.ContractStatus.IX_RosterDaily	3	NONCLUSTERED				19	0	0	7744	2026-09-07 10:44:39	2026-09-06 02:14:24	USED	keep — in use
host_726.wps.ContractStatus.PK_ClaimLog	1	CLUSTERED	Y	Y		0	7744	19	7744	2026-09-12 01:03:39	2026-09-06 02:14:24	USED	KEEP — primary key
host_726.wps.ContractStatus.UX_TerritoryResult	2	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-09-06 02:14:24	COLD	review carefully — unique
host_726.wps.ContractStatus.UX_SettlementDetail	4	NONCLUSTERED	Y			0	0	0	0	never	2026-09-06 02:14:24	COLD	review carefully — unique
host_726.wps.PolicyResult.IX_ContractSnapshot	2	NONCLUSTERED				0	0	0	0	never	2026-09-06 02:14:24	COLD	review, then DROP
host_726.wps.PolicyResult.PK_SettlementLine	1	CLUSTERED	Y	Y		46	347	0	0	2026-09-11 21:44:19	2026-09-06 02:14:24	USED	KEEP — primary key
host_726.wps.LedgerMonthly.PK_BookingResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:24	COLD	KEEP — primary key
host_726.wps.BookingStaging.PK_ClaimHistory	1	CLUSTERED	Y	Y		0	4	0	0	2026-09-11 21:29:40	2026-09-06 02:14:24	USED	KEEP — primary key
host_726.wps.SalesHeader.PK_ContractHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:24	COLD	KEEP — primary key
host_726.wps.ForecastResult.PK_QuotaLog	1	CLUSTERED	Y	Y		22	7	28539	0	2026-09-12 01:01:29	2026-09-06 02:14:24	USED	KEEP — primary key
host_726.wps.ForecastResult.UQ_ShipmentArchive	4	NONCLUSTERED	Y			29131	0	0	0	2026-09-12 01:01:29	2026-09-06 02:14:24	USED	keep — in use
host_726.wps.StaffingResult.PK_RosterStatus	1	CLUSTERED	Y	Y		0	685	0	0	2026-09-12 00:26:55	2026-09-06 02:14:24	USED	KEEP — primary key
host_726.wps.StaffingStaging.PK_PolicyEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:24	COLD	KEEP — primary key
host_726.wps.QuotaDetail.PK_BatchQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:24	COLD	KEEP — primary key
host_726.wps.OrdersLog.PK_WarehouseArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:24	COLD	KEEP — primary key
host_726.wps.TerritoryQueue.IX_InvoiceAudit	11	NONCLUSTERED				300	2	0	316	2026-09-12 00:26:55	2026-09-11 02:27:33	USED	keep — in use
host_726.wps.TerritoryQueue.PK_RosterSnapshot	1	CLUSTERED	Y	Y		0	40	877	316	2026-09-12 00:26:55	2026-09-11 02:27:33	USED	KEEP — primary key
host_726.wps.TerritoryQueue.UX_MeterStaging	2	NONCLUSTERED	Y			64	516	0	20	2026-09-12 00:26:07	2026-09-11 02:27:33	USED	keep — in use
host_726.wps.ContractEntry.PK_PayrollSummary	1	CLUSTERED	Y	Y		0	0	0	38	never	2026-09-11 02:27:33	UNUSED	KEEP — primary key
host_726.wps.TicketStatus.PK_InvoiceMonthly	1	CLUSTERED	Y	Y		0	508	0	0	2026-09-12 00:26:55	2026-09-06 02:14:24	USED	KEEP — primary key
host_726.wps.SalesDetail.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:24	COLD	KEEP — primary key
host_726.wps.ClaimResult.PK_TicketEntry	1	CLUSTERED	Y	Y		19	8	0	0	2026-09-09 09:46:19	2026-09-06 02:14:24	USED	KEEP — primary key
host_726.wps.CatalogSnapshot.PK_ForecastHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:24	COLD	KEEP — primary key
host_726.wps.BillingLine.PK_RosterResult	1	CLUSTERED	Y	Y		46	25	0	0	2026-09-11 21:29:08	2026-09-06 02:14:24	USED	KEEP — primary key
host_726.wps.BillingLine.UX_WarehouseLog	2	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-09-06 02:14:24	COLD	review carefully — unique
host_726.wps.BatchStatus.PK_ClaimLine	1	CLUSTERED	Y	Y		0	291	677	0	2026-09-12 00:26:55	2026-09-06 02:14:24	USED	KEEP — primary key
host_726.wps.BatchStatus.UQ_CustomerHeader	2	NONCLUSTERED	Y			677	0	0	0	2026-09-12 00:26:55	2026-09-06 02:14:24	USED	keep — in use
host_726.wps.BookingResult.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:24	COLD	KEEP — primary key
host_726.wps.BookingStaging.PK_ForecastLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-06 02:14:24	COLD	KEEP — primary key
ASSET_Prod.dbo.PricingHeader.IX_StaffingHeader	3	NONCLUSTERED				0	0	0	74	never	2026-08-24 12:48:18	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_QuotaAudit	4	NONCLUSTERED				0	0	0	74	never	2026-08-24 12:48:18	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y		12843	2354	0	218	2026-09-11 20:07:38	2026-08-24 12:50:52	USED	KEEP — primary key
ASSET_Prod.dbo.PricingHeader.UX_QuotaMonthly	2	NONCLUSTERED	Y			0	0	0	74	never	2026-08-24 12:48:18	UNUSED	review carefully — unique
ASSET_Prod.dbo.RouteSnapshot.IX_ContractHeader	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 08:14:24	COLD	review, then DROP
ASSET_Prod.dbo.RouteSnapshot.PK_ContractStatus	1	CLUSTERED	Y	Y		0	978	0	0	2026-09-11 18:06:24	never	USED	KEEP — primary key
ASSET_Prod.dbo.RouteArchive.IX_ShiftDaily	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
ASSET_Prod.dbo.RouteArchive.PK_SupplierResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
ASSET_Prod.dbo.AssetEntry.IX_TerritoryDetail	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 09:40:40	COLD	review, then DROP
ASSET_Prod.dbo.AssetEntry.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	10	0	0	2026-09-10 19:29:10	never	USED	KEEP — primary key
ASSET_Prod.dbo.BookingSnapshot.IX_RouteLine	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 08:14:24	COLD	review, then DROP
ASSET_Prod.dbo.BookingSnapshot.PK_TicketHistory	1	CLUSTERED	Y	Y		0	13	0	0	2026-09-10 09:00:06	never	USED	KEEP — primary key
ASSET_Prod.dbo.SalesEntry.PK_BookingAudit	1	CLUSTERED	Y	Y		0	0	6	0	2026-09-10 13:27:51	never	USED	KEEP — primary key
ASSET_Prod.dbo.SalesEntry.UX_ShiftSnapshot	2	NONCLUSTERED	Y			6	0	0	0	2026-09-10 13:27:51	2026-07-29 08:09:18	USED	keep — in use
ASSET_Prod.dbo.RosterDaily.IX_RouteLine	2	NONCLUSTERED				7	0	0	0	2026-09-10 19:29:10	2026-07-29 09:40:40	USED	keep — in use
ASSET_Prod.dbo.RosterDaily.IX_ShiftHeader	3	NONCLUSTERED				0	0	0	0	never	2026-07-29 09:40:40	COLD	review, then DROP
ASSET_Prod.dbo.RosterDaily.PK_MeterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
ASSET_Prod.dbo.RosterHeader.IX_ShipmentLog	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 09:40:40	COLD	review, then DROP
ASSET_Prod.dbo.RosterHeader.PK_RosterMonthly	1	CLUSTERED	Y	Y		0	8	0	0	2026-09-10 19:29:10	never	USED	KEEP — primary key
ASSET_Prod.dbo.ContractStaging.IX_InvoiceLog	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 08:14:24	COLD	review, then DROP
ASSET_Prod.dbo.ContractStaging.PK_TerritorySnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
ASSET_Prod.dbo.BookingEntry.IX_ShipmentStatus	2	NONCLUSTERED				0	0	0	218	never	2026-08-21 16:55:04	UNUSED	review, then DROP
ASSET_Prod.dbo.BookingEntry.PK_SettlementQueue	1	CLUSTERED	Y	Y		0	660	0	218	2026-09-11 18:06:24	never	USED	KEEP — primary key
ASSET_Prod.dbo.ReconcileMonthly.IX_ForecastDetail	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 08:14:24	COLD	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_QuotaSummary	9	NONCLUSTERED			Y	0	0	0	0	never	2026-07-29 08:51:33	COLD	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.PK_SettlementDetail	1	CLUSTERED	Y	Y		0	10257	0	0	2026-09-11 18:11:32	2026-07-29 09:58:28	USED	KEEP — primary key
ASSET_Prod.dbo.ReconcileMonthly.UX_CustomerDetail	3	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-07-29 08:15:18	COLD	review carefully — unique
ASSET_Prod.dbo.CampaignHeader.IX_SupplierResult	2	NONCLUSTERED				0	0	0	158	never	2026-08-28 09:23:30	UNUSED	review, then DROP
ASSET_Prod.dbo.CampaignHeader.PK_ShiftHeader	1	CLUSTERED	Y	Y		20	11449	0	178	2026-09-11 20:07:38	2026-08-28 09:24:14	USED	KEEP — primary key
ASSET_Prod.dbo.DOB.IX_CustomerSummary	2	NONCLUSTERED				0	0	0	0	never	2026-07-30 11:02:10	COLD	review, then DROP
ASSET_Prod.dbo.DOB.PK_AssetStatus	1	CLUSTERED	Y	Y		0	3	0	0	2026-09-10 13:28:07	2026-07-31 02:39:58	USED	KEEP — primary key
ASSET_Prod.dbo.ShipmentLog.IX_ReconcileStatus	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 09:41:32	COLD	review, then DROP
ASSET_Prod.dbo.ShipmentLog.PK_ClaimHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
ASSET_Prod.dbo.BookingSnapshot.IX_ClaimStaging	3	NONCLUSTERED				0	0	0	0	never	2026-07-29 09:40:41	COLD	review, then DROP
ASSET_Prod.dbo.BookingSnapshot.PK_RosterSummary	1	CLUSTERED	Y	Y		0	3	0	0	2026-09-10 13:28:07	2026-07-29 09:41:31	USED	KEEP — primary key
ASSET_Prod.dbo.BookingSnapshot.UX_RosterStaging	2	NONCLUSTERED	Y			0	0	0	0	never	2026-07-29 09:40:41	COLD	review carefully — unique
ASSET_Prod.dbo.RosterStaging.IX_BatchArchive	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
ASSET_Prod.dbo.RosterStaging.PK_SupplierStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
ASSET_Prod.dbo.BatchLog.IX_LedgerHistory	2	NONCLUSTERED				0	0	0	0	never	2026-07-30 11:02:10	COLD	review, then DROP
ASSET_Prod.dbo.BatchLog.IX_TerritoryArchive	3	NONCLUSTERED				0	0	0	0	never	2026-07-30 11:02:10	COLD	review, then DROP
ASSET_Prod.dbo.BatchLog.PK_ClaimLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
ASSET_Prod.dbo.ForecastDetail.IX_CampaignStatus	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 08:16:57	COLD	review, then DROP
ASSET_Prod.dbo.ForecastDetail.PK_BillingHistory	1	CLUSTERED	Y	Y		0	431	0	0	2026-09-11 18:06:19	2026-07-29 08:16:57	USED	KEEP — primary key
ASSET_Prod.dbo.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	431	0	0	2026-09-11 18:03:24	never	USED	KEEP — primary key
ASSET_Prod.dbo.CustomerEntry.IX_ShiftDaily	3	NONCLUSTERED				0	0	0	0	never	2026-07-31 02:41:20	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_ClaimHistory	5	NONCLUSTERED				0	0	0	0	never	2026-07-31 02:41:20	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_StaffingLine	4	NONCLUSTERED				0	0	0	0	never	2026-07-31 02:41:20	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_CatalogLog	2	NONCLUSTERED				0	0	0	0	never	2026-07-31 02:41:06	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.PK_CampaignHistory	1	CLUSTERED	Y	Y		0	2	0	0	2026-09-10 13:28:01	2026-07-31 02:41:20	USED	KEEP — primary key
ASSET_Prod.dbo.RosterSummary.IX_ForecastSnapshot	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
ASSET_Prod.dbo.SalesSnapshot.IX_BillingQueue	3	NONCLUSTERED				391	0	0	0	2026-09-11 18:05:54	2026-07-29 11:14:33	USED	keep — in use
ASSET_Prod.dbo.SalesSnapshot.IX_TicketResult	4	NONCLUSTERED			Y	0	0	0	0	never	2026-07-31 11:16:08	COLD	review, then DROP
ASSET_Prod.dbo.SalesSnapshot.PK_WarehouseLog	1	CLUSTERED	Y	Y		0	0	992	0	2026-09-11 18:05:54	2026-07-31 11:16:08	USED	KEEP — primary key
ASSET_Prod.dbo.SalesSnapshot.UX_ShiftResult	2	NONCLUSTERED	Y			992	0	0	0	2026-09-11 18:05:54	2026-07-29 11:14:33	USED	keep — in use
ASSET_Prod.dbo.RouteHistory.PK_BillingArchive	1	CLUSTERED	Y	Y		278	39	0	0	2026-09-11 18:05:54	2026-07-29 08:07:17	USED	KEEP — primary key