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

Index reportsSQL Server 13ACME-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-60 ACME-192-0-2-243 ACME-203-0-113-99 ACME-198-51-100-92 ACME-203-0-113-69 ACME-192-0-2-97 ACME-192-0-2-242 ACME-203-0-113-155Oracle 1ACME-198-51-100-125PostgreSQL 1ACME-192-0-2-15-PG-5433

Host: 198.51.100.66

Collected: 2026-10-02T17:03:34Z

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

Fleet inventory: http://203.0.113.28: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.

Metric	Count	Meaning
indexes_total	674	every index on a user table
used	413	had a seek, scan or lookup
unused	160	written but never read
cold	101	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	45	nonclustered, not unique, no constraint, never read
fragmented	12	above the rebuild threshold

By database

Database	Total	Cold	Droppable	Recommend action
ASSET_Prod	55	26	26	review the drop candidates above
host_726	574	65	19	review the drop candidates above
host-871	21	6	0	no action — cold indexes here are constraints or clustered
host-877	24	4	0	no action — cold indexes here are constraints or clustered

Drop candidates (45)

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.emp.SettlementQueue.IX_PolicyAudit	57599	never	UNUSED	review, then DROP
host_726.emp.SupplierStaging.IX_StaffingEntry	37846	never	UNUSED	review, then DROP
host_726.emp.SalesHeader.IX_BookingSummary	11425	never	UNUSED	review, then DROP
host_726.org.SupplierHistory.IX_ShipmentSummary	1150	never	UNUSED	review, then DROP
ASSET_Prod.dbo.BookingEntry.IX_ShipmentStatus	1068	never	UNUSED	review, then DROP
ASSET_Prod.dbo.CampaignHeader.IX_SupplierResult	1029	never	UNUSED	review, then DROP
host_726.emp.OrdersMonthly.IX_QuotaArchive	575	never	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_QuotaAudit	373	never	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_StaffingHeader	373	never	UNUSED	review, then DROP
host_726.org.BillingHeader.IX_ShiftHistory	213	never	UNUSED	review, then DROP
host_726.org.ShipmentSummary.IX_StaffingResult	95	never	UNUSED	review, then DROP
host_726.wps.PolicyResult.IX_ContractSnapshot	21	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.ReconcileMonthly.IX_ForecastDetail	8	never	UNUSED	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_QuotaSummary	8	never	UNUSED	review, then DROP
host_726.dbo.BatchResult.IX_ReconcileEntry	0	never	UNUSED	review, then DROP
host_726.dbo.CustomerArchive.IX_BillingHeader	0	never	UNUSED	review, then DROP
host_726.emp.StaffingMonthly.IX_ReconcileEntry	0	never	UNUSED	review, then DROP
host_726.guest.TerritoryQueue.IX_InvoiceStaging	0	never	UNUSED	review, then DROP
host_726.oth.StaffingArchive.IX_InvoiceStaging	0	never	UNUSED	review, then DROP
host_726.sal.ClaimArchive.IX_RouteDetail	0	never	UNUSED	review, then DROP
host_726.schedule.InvoiceHistory.IX_StaffingHeader	0	never	UNUSED	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
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.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
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

Fragmented (12) — 12 partitions across 11 indexes

Total 1,433.4 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.PK_OrdersArchive#p6	6/21	CLUSTERED	98.1%	1,297	10.1	2026-10-02 22:34:18	REBUILD
host_726.schedule.RouteAudit.IX_InvoiceHeader	1/1	NONCLUSTERED	94.8%	103,520	808.8	2026-10-02 17:29:57	REBUILD
host_726.schedule.SettlementLog.IX_TicketLine#p3	3/21	NONCLUSTERED	93.3%	1,084	8.5	2026-10-02 22:36:30	REBUILD
host_726.schedule.SettlementLog.IX_TicketLine#p4	4/21	NONCLUSTERED	91.3%	1,224	9.6	2026-10-02 22:36:30	REBUILD
host_726.emp.CampaignResult.IX_ClaimStatus	1/1	NONCLUSTERED	63.2%	35,155	274.6	2026-10-02 02:03:58	REBUILD
host_726.emp.BillingAudit.IX_PolicyHeader	1/1	NONCLUSTERED	59.8%	8,454	66.0	2026-10-02 22:36:03	REORGANIZE
host_726.emp.TicketSnapshot.IX_BookingHistory	1/1	NONCLUSTERED	54.9%	11,570	90.4	2026-10-02 02:03:07	REORGANIZE
host_726.schedule.TerritoryAudit.UX_BookingHeader	1/1	NONCLUSTERED	40.5%	4,712	36.8	2026-10-02 02:39:13	REORGANIZE
host_726.emp.SupplierStaging.IX_StaffingSnapshot	1/1	NONCLUSTERED	40.0%	3,259	25.5	2026-10-02 02:02:31	REORGANIZE
host_726.emp.CustomerLog.IX_PayrollResult	1/1	NONCLUSTERED	35.8%	1,356	10.6	2026-10-02 02:02:22	REORGANIZE
host_726.emp.SupplierStaging.IX_CampaignResult	1/1	NONCLUSTERED	33.7%	2,503	19.6	2026-10-02 02:02:28	REORGANIZE
host_726.schedule.CustomerHistory.PK_PayrollAudit#p9	9/21	CLUSTERED	33.2%	9,325	72.9	2026-10-02 22:36:02	REORGANIZE

All indexes (674)

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
host-877.app.Account.PK_SettlementResult	1	CLUSTERED	Y	Y		9761223	3922	2142010	8212	2026-10-03 00:03:34	2026-10-02 02:00:00	USED	KEEP — primary key
host-877.app.Account.UX_PayrollAudit	2	NONCLUSTERED	Y			3973025	61	0	8041	2026-10-03 00:03:32	2026-10-02 02:00:00	USED	keep — in use
host-877.app.Account.UX_ContractSummary	7	NONCLUSTERED	Y		Y	161	0	0	161	2026-09-29 09:11:03	2026-10-02 02:00:00	USED	keep — in use
host-877.app.ReconcileDaily.PK_LedgerResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-877.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	7879	never	2026-10-02 02:00:01	UNUSED	KEEP — primary key
host-877.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	183091	never	2026-10-02 02:00:01	UNUSED	KEEP — primary key
host-877.app.ForecastMonthly.IX_StaffingStatus	1	CLUSTERED				0	0	0	7089	never	2026-10-02 02:00:01	UNUSED	KEEP — table storage
host-877.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		2	307019	0	0	2026-10-03 00:02:48	2026-09-27 02:00:01	USED	KEEP — primary key
host-877.app.CampaignAudit.PK_BillingMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-877.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		819887	71524	0	28	2026-10-03 00:02:59	2026-10-01 02:00:02	USED	KEEP — primary key
host-877.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	25	never	2026-10-01 02:00:02	UNUSED	KEEP — primary key
host-877.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		460903	461	0	20	2026-10-03 00:02:48	2026-10-01 02:00:02	USED	KEEP — primary key
host-877.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			1	1	0	20	2026-09-18 12:25:08	2026-10-02 02:00:01	USED	keep — in use
host-877.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y		62454	0	0	73	2026-10-02 23:38:41	2026-10-02 02:00:02	USED	KEEP — primary key
host-877.app.BatchQueue.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	22893	0	0	2026-10-02 21:53:09	never	USED	KEEP — primary key
host-877.app.WarehouseStatus.IX_BookingEntry	9	NONCLUSTERED				0	1	0	13	2026-09-18 10:15:38	2026-10-02 02:00:02	USED	keep — in use
host-877.app.WarehouseStatus.UX_QuotaLine	2	NONCLUSTERED	Y			22517	108235	0	13	2026-10-02 23:39:21	2026-10-02 02:00:02	USED	keep — in use
host-877.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		676107	0	0	343	2026-10-03 00:02:59	2026-10-02 02:00:02	USED	KEEP — primary key
host-877.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	282	never	2026-10-02 02:00:02	UNUSED	KEEP — primary key
host-877.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		402840	2155990	0	6	2026-10-03 00:02:59	2026-09-27 02:00:01	USED	KEEP — primary key
host-877.app.Permission.PK_ClaimHeader	1	CLUSTERED	Y	Y		359057	633976	0	4	2026-10-03 00:02:59	2026-09-27 02:00:01	USED	KEEP — primary key
host-877.app.Permission.UX_RouteQueue	2	NONCLUSTERED	Y			23167	3	0	3	2026-10-02 22:40:10	2026-09-27 02:00:01	USED	keep — in use
host-877.app.Token.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-877.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-871.app.Account.PK_SettlementResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:23	UNUSED	KEEP — primary key
host-871.app.Account.UX_PayrollAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 03:06:23	UNUSED	review carefully — unique
host-871.app.ReconcileDaily.PK_LedgerResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-871.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-871.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:24	UNUSED	KEEP — primary key
host-871.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:24	UNUSED	KEEP — primary key
host-871.app.CampaignAudit.PK_BillingMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-871.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:24	UNUSED	KEEP — primary key
host-871.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:24	UNUSED	KEEP — primary key
host-871.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:24	UNUSED	KEEP — primary key
host-871.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 03:06:24	UNUSED	review carefully — unique
host-871.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:24	UNUSED	KEEP — primary key
host-871.app.BatchQueue.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-871.app.WarehouseStatus.UX_QuotaLine	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 03:06:24	UNUSED	review carefully — unique
host-871.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:24	UNUSED	KEEP — primary key
host-871.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:24	UNUSED	KEEP — primary key
host-871.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:24	UNUSED	KEEP — primary key
host-871.app.Permission.PK_ClaimHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:24	UNUSED	KEEP — primary key
host-871.app.Permission.UX_RouteQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 03:06:24	UNUSED	review carefully — unique
host-871.app.Token.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-871.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	2	0	0	2026-09-18 10:21:30	2026-09-27 02:00:02	USED	KEEP — primary key
host_726.cfg.QuotaStatus.UX_MeterSummary	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:31	2026-09-27 02:00:02	USED	keep — in use
host_726.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		0	2978	0	2977	2026-10-02 22:30:28	2026-09-27 02:00:02	USED	KEEP — primary key
host_726.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	2977	never	2026-10-02 02:00:03	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-27 02:00:04	USED	KEEP — primary key
host_726.dbo.Jobs.UQ_ContractMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:00:04	UNUSED	review carefully — unique
host_726.dbo.Keys.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-27 02:00:04	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-27 02:00:04	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-27 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.CustomerSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.QuotaResult.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:00:04	UNUSED	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-27 02:00:04	COLD	review, then DROP
host_726.dbo.BatchResult.IX_ReconcileEntry	3	NONCLUSTERED				0	0	0	0	never	2026-09-27 02:00:04	UNUSED	review, then DROP
host_726.dbo.BatchResult.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:00:04	UNUSED	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-27 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.ClaimArchive.UQ_SupplierResult	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:00:04	UNUSED	review carefully — unique
host_726.dbo.CustomerArchive.IX_BillingHeader	3	NONCLUSTERED				0	0	0	0	never	2026-09-27 02:00:04	UNUSED	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-27 02:00:04	USED	KEEP — primary key
host_726.dbo.CustomerArchive.UQ_OrdersMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:00:04	UNUSED	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-27 02:00:04	USED	KEEP — primary key
host_726.dbo.Status.UQ_PricingHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:00:04	UNUSED	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-27 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.BookingStatus.UQ_CatalogSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:00:04	UNUSED	review carefully — unique
host_726.dbo.BookingStatus.UQ_ContractEntry	3	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:00:04	UNUSED	review carefully — unique
host_726.dbo.BookingStatus.UQ_RouteLine	4	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:00:04	UNUSED	review carefully — unique
host_726.dbo.BillingHistory.PK_PayrollHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.TicketQueue.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:00:04	UNUSED	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		2088405	2368	0	0	2026-10-03 00:02:59	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.dbo.WarehouseEntry.UX_CampaignHeader	2	NONCLUSTERED	Y			0	3	0	0	2026-09-19 15:40:54	2026-09-27 02:00:05	USED	keep — in use
host_726.dbo.TicketSummary.PK_SalesLine	1	CLUSTERED				0	13364	0	0	2026-10-02 21:53:05	2026-09-27 02:00:05	USED	KEEP — table storage
host_726.dbo.TerritoryEntry.PK_SalesSummary	1	CLUSTERED	Y	Y		1347333	936	0	0	2026-10-03 00:02:59	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.dbo.TerritoryEntry.UX_TerritoryQueue	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:20	2026-09-27 02:00:05	USED	keep — in use
host_726.dbo.PolicyEntry.PK_TicketEntry	1	CLUSTERED	Y	Y		661995	2382	0	0	2026-10-03 00:02:59	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.dbo.PolicyEntry.UX_PolicyAudit	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:25	2026-09-27 02:00:05	USED	keep — in use
host_726.dbo.CampaignHeader.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y		747196	2602	0	0	2026-10-03 00:02:59	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.dbo.CampaignHeader.UX_BillingLog	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:30	2026-09-27 02:00:05	USED	keep — in use
host_726.dbo.WarehouseHeader.PK_OrdersQueue	1	CLUSTERED	Y	Y		0	1376	0	0	2026-10-02 18:31:31	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.dbo.WarehouseHeader.UX_TicketQueue	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:26	2026-09-27 02:00:05	USED	keep — in use
host_726.dbo.RouteQueue.PK_SupplierAudit	1	CLUSTERED	Y	Y		1375790	948	0	0	2026-10-03 00:02:59	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.dbo.RouteQueue.UX_CampaignQueue	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:19	2026-09-27 02:00:05	USED	keep — in use
host_726.dbo.CampaignAudit.PK_BatchSnapshot	1	CLUSTERED	Y	Y		661785	2392	0	0	2026-10-03 00:02:59	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.dbo.CampaignAudit.UX_SupplierArchive	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:28	2026-09-27 02:00:05	USED	keep — in use
host_726.dbo.ShiftDaily.PK_ReconcileStatus	1	CLUSTERED	Y	Y		1377777	932	0	0	2026-10-03 00:02:59	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.dbo.ShiftDaily.UX_RouteDaily	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:23	2026-09-27 02:00:05	USED	keep — in use
host_726.dbs.ShipmentStatus.UX_StaffingLog	8	NONCLUSTERED	Y		Y	25	0	0	27	2026-10-01 20:00:02	2026-09-29 02:00:04	USED	keep — in use
host_726.emp.WarehouseMonthly.PK_PricingHistory	1	CLUSTERED	Y	Y		14951	22687	0	5	2026-10-02 23:06:47	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.emp.WarehouseMonthly.UX_CustomerDetail	2	NONCLUSTERED	Y		Y	0	0	0	5	never	2026-09-27 02:00:05	UNUSED	review carefully — unique
host_726.emp.SettlementLine.PK_LedgerAudit	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-09-27 02:00:05	UNUSED	KEEP — primary key
host_726.emp.SalesDetail.PK_BillingLog	1	CLUSTERED	Y	Y		0	87	0	0	2026-09-29 08:39:09	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.emp.BatchMonthly.PK_TicketAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:00:05	UNUSED	KEEP — primary key
host_726.emp.RosterLog.PK_QuotaLog	1	CLUSTERED	Y	Y		288704	0	0	144352	2026-10-03 00:03:32	2026-09-27 02:00:05	USED	KEEP — primary key
host_726.emp.QuotaMonthly.IX_ShipmentEntry	2	NONCLUSTERED				761354	1	0	1764	2026-10-03 00:02:59	2026-10-02 02:00:04	USED	keep — in use
host_726.emp.QuotaMonthly.PK_ReconcileDetail	1	CLUSTERED	Y	Y		1820	475	761353	1848	2026-10-03 00:02:59	2026-10-02 02:00:04	USED	KEEP — primary key
host_726.emp.OrdersEntry.PK_PolicyHeader	1	CLUSTERED	Y	Y		0	0	0	1696	never	2026-10-02 02:00:04	UNUSED	KEEP — primary key
host_726.emp.PayrollSummary.PK_RouteSummary	1	CLUSTERED	Y	Y		6	87	0	0	2026-09-29 08:39:09	2026-09-27 02:00:07	USED	KEEP — primary key
host_726.emp.SettlementAudit.PK_ShiftStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:00:07	UNUSED	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		396	683	0	0	2026-10-03 00:00:00	2026-09-27 02:00:07	USED	KEEP — primary key
host_726.emp.RouteHistory.UX_CustomerQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:00:07	UNUSED	review carefully — unique
host_726.emp.CustomerHistory.PK_ShiftDaily	1	CLUSTERED	Y	Y		169	0	0	1	2026-10-02 14:09:44	2026-09-27 02:00:10	USED	KEEP — primary key
host_726.emp.ForecastEntry.PK_SettlementLog	1	CLUSTERED	Y	Y		12	719626	0	43	2026-10-03 00:03:32	2026-10-02 02:00:05	USED	KEEP — primary key
host_726.emp.ClaimQueue.PK_TerritoryResult	1	CLUSTERED	Y	Y		0	0	0	50	never	2026-10-02 02:00:05	UNUSED	KEEP — primary key
host_726.emp.PolicyAudit.PK_ContractAudit	1	CLUSTERED	Y	Y		52	1290389	0	39	2026-10-03 00:03:32	2026-10-02 02:00:05	USED	KEEP — primary key
host_726.emp.ShipmentSummary.PK_ShiftAudit	1	CLUSTERED	Y	Y		0	7	0	49	2026-09-21 10:16:54	2026-10-02 02:00:05	USED	KEEP — primary key
host_726.emp.BatchArchive.PK_ClaimHistory	1	CLUSTERED	Y	Y		571904	719081	0	31	2026-10-03 00:03:32	2026-10-02 02:00:06	USED	KEEP — primary key
host_726.emp.RosterSnapshot.PK_PolicyStaging	1	CLUSTERED	Y	Y		0	0	0	31	never	2026-10-02 02:00:06	UNUSED	KEEP — primary key
host_726.emp.MeterResult.IX_LedgerQueue	2	NONCLUSTERED				5	454524	0	4194	2026-10-03 00:03:34	2026-10-02 02:00:06	USED	keep — in use
host_726.emp.MeterResult.PK_CustomerResult	1	CLUSTERED	Y	Y		6476023	178679	6	4194	2026-10-03 00:03:32	2026-10-02 02:00:06	USED	KEEP — primary key
host_726.emp.PayrollHeader.PK_TicketHistory	1	CLUSTERED	Y	Y		662822	291	0	1092	2026-10-03 00:02:59	2026-10-02 02:00:06	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	275	0	0	2026-10-03 00:00:00	2026-09-27 02:00:11	USED	KEEP — primary key
host_726.emp.RouteHeader.PK_StaffingQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:00:11	UNUSED	KEEP — primary key
host_726.emp.MeterAudit.PK_ClaimLog	1	CLUSTERED	Y	Y		7433	455207	0	7434	2026-10-02 23:56:10	2026-10-02 02:00:06	USED	KEEP — primary key
host_726.emp.QuotaStatus.PK_OrdersArchive	1	CLUSTERED	Y	Y		0	0	0	65	never	2026-10-02 02:00:06	UNUSED	KEEP — primary key
host_726.emp.ShiftLine.IX_PricingAudit	3	NONCLUSTERED				351	0	0	0	2026-10-02 16:02:56	2026-09-27 02:00:11	USED	keep — in use
host_726.emp.ShiftLine.PK_SettlementStatus	1	CLUSTERED	Y	Y		139	410	351	53	2026-10-03 00:00:01	2026-09-27 02:00:11	USED	KEEP — primary key
host_726.emp.ShiftLine.UX_BookingDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:00:11	UNUSED	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	53	never	2026-10-02 02:00:06	UNUSED	KEEP — primary key
host_726.emp.ForecastHeader.IX_WarehouseResult	2	NONCLUSTERED				14551	1	0	1609	2026-10-02 21:53:22	2026-10-02 02:00:07	USED	keep — in use
host_726.emp.ForecastHeader.PK_OrdersAudit	1	CLUSTERED	Y	Y		3	228	14551	1609	2026-10-02 21:53:22	2026-09-30 16:18:54	USED	KEEP — primary key
host_726.emp.SalesLog.PK_AssetStaging	1	CLUSTERED	Y	Y		0	0	0	1606	never	2026-10-01 02:00:07	UNUSED	KEEP — primary key
host_726.emp.AssetDaily.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	27190	0	0	2026-10-02 21:53:05	2026-09-27 02:00:12	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				347	1	0	28	2026-10-02 18:33:24	2026-10-02 02:00:07	USED	keep — in use
host_726.emp.PricingDaily.PK_RouteEntry	1	CLUSTERED	Y	Y		5	14380	347	28	2026-10-02 21:53:22	2026-10-02 02:00:07	USED	KEEP — primary key
host_726.emp.PolicyLog.PK_LedgerHistory	1	CLUSTERED	Y	Y		1069	312	661973	1077	2026-10-03 00:02:59	2026-10-02 02:00:07	USED	KEEP — primary key
host_726.emp.PolicyLog.UX_OrdersSnapshot	2	NONCLUSTERED	Y			662000	29	0	1077	2026-10-03 00:02:59	2026-10-02 02:00:07	USED	keep — in use
host_726.emp.RouteAudit.PK_ClaimResult	1	CLUSTERED	Y	Y		0	0	0	60	never	2026-10-02 02:00:07	UNUSED	KEEP — primary key
host_726.emp.PayrollDaily.IX_BillingStaging	2	NONCLUSTERED				97	0	0	504	2026-10-02 17:12:23	2026-10-02 02:00:07	USED	keep — in use
host_726.emp.PayrollDaily.PK_OrdersSnapshot	1	CLUSTERED	Y	Y		0	97	0	504	2026-10-02 17:12:23	2026-10-02 02:00:07	USED	KEEP — primary key
host_726.emp.MeterHistory.IX_ContractArchive	17	NONCLUSTERED				14111	78665	0	1203	2026-10-02 22:36:08	2026-10-02 02:00:07	USED	keep — in use
host_726.emp.MeterHistory.PK_BatchLog	1	CLUSTERED	Y	Y		16530103	275469	6055677	29262	2026-10-03 00:03:34	2026-10-02 02:00:07	USED	KEEP — primary key
host_726.emp.MeterHistory.UX_BatchLog	2	NONCLUSTERED	Y		Y	0	0	0	28096	never	2026-10-02 02:00:07	UNUSED	review carefully — unique
host_726.emp.MeterHistory.UX_ForecastHeader	20	NONCLUSTERED	Y			1348493	5400	0	1203	2026-10-03 00:03:33	2026-10-02 02:00:07	USED	keep — in use
host_726.emp.MeterHistory.UX_CustomerSnapshot	3	NONCLUSTERED	Y		Y	178	220	0	28096	2026-10-02 23:26:03	2026-10-02 02:00:07	USED	keep — in use
host_726.emp.MeterHistory.UX_QuotaStaging	4	NONCLUSTERED	Y			7571648	54	0	1203	2026-10-03 00:03:33	2026-10-02 02:00:08	USED	keep — in use
host_726.emp.ShiftSnapshot.IX_ForecastAudit	1	CLUSTERED				0	0	0	29255	never	2026-10-02 02:00:08	UNUSED	KEEP — table storage
host_726.emp.TerritoryLine.PK_LedgerArchive	1	CLUSTERED	Y	Y		161376	50649	0	57933	2026-10-02 23:57:29	2026-10-01 02:00:09	USED	KEEP — primary key
host_726.emp.SalesStaging.PK_PolicyDaily	1	CLUSTERED	Y	Y		21393	569	0	5481	2026-10-02 21:53:22	2026-10-01 02:00:10	USED	KEEP — primary key
host_726.emp.TerritoryDaily.PK_MeterLog	1	CLUSTERED	Y	Y		0	0	0	2136	never	2026-10-01 02:00:10	UNUSED	KEEP — primary key
host_726.emp.SettlementQueue.IX_PolicyAudit	2	NONCLUSTERED				0	0	0	57599	never	2026-10-02 02:00:10	UNUSED	review, then DROP
host_726.emp.SettlementQueue.PK_SalesEntry	1	CLUSTERED	Y	Y		0	220	0	57599	2026-10-02 16:02:59	2026-10-02 02:00:10	USED	KEEP — primary key
host_726.emp.StaffingMonthly.IX_ReconcileEntry	2	NONCLUSTERED				0	0	0	0	never	2026-09-27 02:00:17	UNUSED	review, then DROP
host_726.emp.StaffingMonthly.IX_SalesQueue	3	NONCLUSTERED				46111	1	0	0	2026-10-02 23:38:44	2026-09-27 02:00:17	USED	keep — in use
host_726.emp.StaffingMonthly.PK_CampaignStatus	1	CLUSTERED	Y	Y		3	40606	17246	0	2026-10-02 23:38:44	2026-09-27 02:00:17	USED	KEEP — primary key
host_726.emp.TicketQueue.PK_BatchDaily	1	CLUSTERED	Y	Y		0	95	14601	1754	2026-10-02 21:53:22	2026-10-02 02:00:11	USED	KEEP — primary key
host_726.emp.TicketQueue.UX_PayrollDaily	2	NONCLUSTERED	Y			14602	2	0	1754	2026-10-02 21:53:22	2026-10-02 02:00:11	USED	keep — in use
host_726.emp.MeterStatus.PK_CustomerDetail	1	CLUSTERED	Y	Y		0	0	0	1754	never	2026-10-02 02:00:11	UNUSED	KEEP — primary key
host_726.emp.OrdersEntry.PK_TerritoryAudit	1	CLUSTERED	Y	Y		0	15860	0	0	2026-10-02 21:53:22	2026-09-27 02:00:17	USED	KEEP — primary key
host_726.emp.InvoiceLog.PK_BillingDetail	1	CLUSTERED	Y	Y		0	23	0	1205	2026-09-22 14:44:42	2026-10-02 02:00:12	USED	KEEP — primary key
host_726.emp.CampaignHistory.IX_QuotaDetail	2	NONCLUSTERED				7758149	1	0	60	2026-10-03 00:03:34	2026-10-02 02:00:13	USED	keep — in use
host_726.emp.CampaignHistory.PK_AssetHeader	1	CLUSTERED	Y	Y		19	114200	7758149	60	2026-10-03 00:03:34	2026-10-01 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		134	127	0	0	2026-10-02 16:02:59	2026-09-27 02:00:27	USED	KEEP — primary key
host_726.emp.BatchAudit.IX_PolicyArchive	20	NONCLUSTERED				799373	204	0	4678288	2026-10-03 00:03:26	2026-10-02 02:00:44	USED	keep — in use
host_726.emp.BatchAudit.PK_ForecastSummary	1	CLUSTERED	Y	Y		3357131	20382	11834793	6510861	2026-10-03 00:03:34	2026-10-02 02:00:13	USED	KEEP — primary key
host_726.emp.BatchAudit.UX_LedgerStaging	2	NONCLUSTERED	Y			16749249	6	0	4678288	2026-10-03 00:03:33	2026-10-02 02:00:44	USED	keep — in use
host_726.emp.ClaimAudit.PK_LedgerDaily	1	CLUSTERED	Y	Y		0	1	0	62	2026-09-28 21:09:39	never	USED	KEEP — primary key
host_726.emp.ClaimAudit.UX_RouteMonthly	2	NONCLUSTERED	Y			1	61	0	62	2026-10-02 02:00:03	never	USED	keep — in use
host_726.emp.PolicyHistory.PK_OrdersDaily	1	CLUSTERED	Y	Y		3650461	1160	0	5482807	2026-10-03 00:03:33	2026-10-02 22:36:05	USED	KEEP — primary key
host_726.emp.BillingEntry.PK_StaffingAudit	1	CLUSTERED	Y	Y		1	1476	66	3650207	2026-10-02 16:02:59	2026-10-02 20:54:31	USED	KEEP — primary key
host_726.emp.BillingEntry.UX_StaffingLog	2	NONCLUSTERED	Y			1817664	23	0	3650207	2026-10-03 00:03:33	2026-10-02 20:54:31	USED	keep — in use
host_726.emp.BillingAudit.IX_PolicyHeader	8	NONCLUSTERED				307723	0	0	3650203	2026-10-03 00:03:32	2026-10-02 22:36:03	USED	keep — in use
host_726.emp.BillingAudit.PK_PolicyDetail	1	CLUSTERED	Y	Y		0	99	88	3650203	2026-10-02 16:02:56	2026-10-02 22:36:04	USED	KEEP — primary key
host_726.emp.BillingAudit.UX_SupplierSnapshot	2	NONCLUSTERED	Y			1817497	128	0	3650203	2026-10-03 00:03:33	2026-10-02 22:36:03	USED	keep — in use
host_726.emp.ShipmentStaging.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	111	0	1817608	2026-10-02 16:02:56	never	USED	KEEP — primary key
host_726.emp.ShipmentStaging.UX_RosterDaily	2	NONCLUSTERED	Y			1	1817607	0	1817608	2026-10-03 00:03:33	never	USED	keep — in use
host_726.emp.SalesLine.PK_CampaignResult	1	CLUSTERED	Y	Y		4580586	51	0	5486062	2026-10-03 00:03:33	2026-10-02 22:37:35	USED	KEEP — primary key
host_726.emp.LedgerSnapshot.PK_CampaignStatus	1	CLUSTERED	Y	Y		0	18	0	910	2026-09-18 14:08:37	2026-10-02 02:02:14	USED	KEEP — primary key
host_726.emp.ReconcileDetail.PK_CampaignQueue	1	CLUSTERED	Y	Y		440	16005	0	506	2026-10-02 21:53:22	2026-10-02 02:02:15	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		570	1599	0	0	2026-10-02 18:33:24	2026-09-27 02:01:28	USED	KEEP — primary key
host_726.emp.ReconcileStaging.UX_OrdersHistory	2	NONCLUSTERED	Y			0	1	0	0	2026-09-19 15:40:54	2026-09-27 02:01:28	USED	keep — in use
host_726.emp.MeterStatus.PK_ReconcileMonthly	1	CLUSTERED	Y	Y		27325	2241	1188093	27309	2026-10-03 00:02:59	2026-10-02 02:02:15	USED	KEEP — primary key
host_726.emp.MeterStatus.UX_ReconcileAudit	4	NONCLUSTERED	Y			1188120	1	0	424	2026-10-03 00:02:59	2026-10-02 02:02:15	USED	keep — in use
host_726.emp.PricingAudit.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		0	0	0	85	never	2026-10-02 02:02:15	UNUSED	KEEP — primary key
host_726.emp.OrdersMonthly.IX_QuotaArchive	2	NONCLUSTERED			Y	0	0	0	575	never	2026-10-02 02:02:16	UNUSED	review, then DROP
host_726.emp.OrdersMonthly.IX_PayrollResult	3	NONCLUSTERED			Y	0	9	0	1667	2026-10-01 10:12:41	2026-10-02 02:02:16	USED	keep — in use
host_726.emp.OrdersMonthly.IX_TicketSnapshot	4	NONCLUSTERED				456737	55	0	2471	2026-10-03 00:03:28	2026-10-02 02:02:16	USED	keep — in use
host_726.emp.OrdersMonthly.IX_SettlementLine	5	NONCLUSTERED				86	0	0	2471	2026-09-30 15:21:10	2026-10-02 02:02:16	USED	keep — in use
host_726.emp.OrdersMonthly.PK_ShipmentSnapshot	1	CLUSTERED	Y	Y		10859	409	9	2471	2026-10-03 00:02:57	2026-10-02 02:02:16	USED	KEEP — primary key
host_726.emp.RosterQueue.PK_SettlementHistory	1	CLUSTERED	Y	Y		440119	8799	0	2	2026-10-02 23:56:10	2026-09-27 02:01:32	USED	KEEP — primary key
host_726.emp.BatchResult.IX_BillingQueue	6	NONCLUSTERED				19036	41	0	5531	2026-10-02 23:52:36	2026-10-02 02:02:17	USED	keep — in use
host_726.emp.BatchResult.PK_InvoiceSummary	1	CLUSTERED	Y	Y		0	75	31	5531	2026-09-30 09:26:50	2026-10-02 02:02:17	USED	KEEP — primary key
host_726.emp.TicketAudit.IX_LedgerLog	2	NONCLUSTERED				44	0	0	12668	2026-10-02 15:43:03	2026-10-02 02:02:18	USED	keep — in use
host_726.emp.TicketAudit.PK_LedgerStatus	1	CLUSTERED	Y	Y		0	0	44	12668	2026-10-02 15:43:03	2026-10-02 02:02:18	USED	KEEP — primary key
host_726.emp.InvoiceResult.PK_ShipmentMonthly	1	CLUSTERED	Y	Y		0	0	0	12668	never	2026-10-02 02:02:18	UNUSED	KEEP — primary key
host_726.emp.CustomerLog.IX_PolicyDaily	18	NONCLUSTERED				5	38598	0	34522	2026-10-02 23:56:55	2026-10-02 02:02:21	USED	keep — in use
host_726.emp.CustomerLog.IX_PayrollResult	21	NONCLUSTERED				18854412	3206864	0	69018	2026-10-03 00:03:32	2026-10-02 02:02:22	USED	keep — in use
host_726.emp.CustomerLog.PK_StaffingDaily	1	CLUSTERED	Y	Y		10231832	9266	5301470	69020	2026-10-03 00:03:32	2026-10-02 02:02:19	USED	KEEP — primary key
host_726.emp.InvoiceAudit.IX_SettlementResult	10	NONCLUSTERED				604965	119094	0	37574	2026-10-03 00:03:28	2026-10-02 02:02:23	USED	keep — in use
host_726.emp.InvoiceAudit.PK_QuotaEntry	1	CLUSTERED	Y	Y		0	524	107214	37574	2026-10-03 00:02:30	2026-10-02 02:02:23	USED	KEEP — primary key
host_726.emp.MeterSummary.PK_AssetEntry	1	CLUSTERED	Y	Y		0	0	0	25691	never	2026-10-02 02:02:24	UNUSED	KEEP — primary key
host_726.emp.BatchDaily.IX_SupplierStatus	1	CLUSTERED				0	0	0	55546	never	2026-10-02 02:02:24	UNUSED	KEEP — table storage
host_726.emp.AssetSummary.PK_SupplierStaging	1	CLUSTERED	Y	Y		0	28	0	34524	2026-10-02 01:15:02	2026-10-02 02:02:25	USED	KEEP — primary key
host_726.emp.SupplierStaging.IX_CampaignResult	24	NONCLUSTERED				0	664	0	41451	2026-10-02 16:11:08	2026-10-02 02:02:28	USED	keep — in use
host_726.emp.SupplierStaging.IX_StaffingSnapshot	30	NONCLUSTERED				6353677	1602	0	41453	2026-10-03 00:03:32	2026-10-02 02:02:31	USED	keep — in use
host_726.emp.SupplierStaging.IX_MeterStaging	16	NONCLUSTERED				990	0	0	37205	2026-10-02 16:15:20	2026-10-02 02:02:32	USED	keep — in use
host_726.emp.SupplierStaging.IX_StaffingEntry	25	NONCLUSTERED				0	0	0	37846	never	2026-10-02 02:02:32	UNUSED	review, then DROP
host_726.emp.SupplierStaging.PK_PayrollMonthly	1	CLUSTERED	Y	Y		3308856	25563	1832492	41453	2026-10-03 00:03:28	2026-10-02 02:02:26	USED	KEEP — primary key
host_726.emp.SupplierStaging.IX_OrdersSnapshot	26	NONCLUSTERED	Y			110834	0	0	17217	2026-10-02 23:39:21	2026-10-02 02:02:32	USED	keep — in use
host_726.emp.CustomerStatus.IX_ReconcileLine	10	NONCLUSTERED				686210	266589	0	59640	2026-10-03 00:03:28	2026-10-02 02:02:33	USED	keep — in use
host_726.emp.CustomerStatus.PK_PolicyHistory	1	CLUSTERED	Y	Y		0	1261	250533	59640	2026-10-02 23:37:20	2026-10-02 02:02:33	USED	KEEP — primary key
host_726.emp.BillingAudit.PK_CustomerEntry	1	CLUSTERED	Y	Y		0	0	0	43569	never	2026-10-02 02:02:34	UNUSED	KEEP — primary key
host_726.emp.PolicyLine.PK_OrdersSummary	1	CLUSTERED	Y	Y		22	50038	0	60	2026-10-02 23:37:20	2026-10-02 02:02:34	USED	KEEP — primary key
host_726.emp.RouteStaging.PK_WarehouseLine	1	CLUSTERED	Y	Y		0	16305	0	0	2026-10-02 23:26:53	2026-09-27 02:03:18	USED	KEEP — primary key
host_726.emp.CampaignMonthly.PK_OrdersArchive	1	CLUSTERED	Y	Y		51	36566	0	1784	2026-10-02 23:37:20	2026-10-02 02:02:35	USED	KEEP — primary key
host_726.emp.CatalogSnapshot.PK_ClaimHistory	1	CLUSTERED	Y	Y		0	193	0	0	2026-10-02 16:41:40	2026-09-27 02:03:18	USED	KEEP — primary key
host_726.emp.TerritoryMonthly.IX_LedgerMonthly	1	CLUSTERED				0	0	0	26333	never	2026-10-02 02:02:35	UNUSED	KEEP — table storage
host_726.emp.BillingDaily.PK_CustomerLine	1	CLUSTERED	Y	Y		0	19988	24329	29492	2026-10-02 23:32:27	2026-10-02 02:02:36	USED	KEEP — primary key
host_726.emp.BillingDaily.UX_LedgerDaily	2	NONCLUSTERED	Y			25261	0	0	29492	2026-10-02 23:32:27	2026-10-02 02:02:36	USED	keep — in use
host_726.emp.SupplierHistory.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	39	0	42940	2026-10-02 01:15:00	2026-10-02 02:02:36	USED	KEEP — primary key
host_726.emp.ShipmentMonthly.IX_SupplierEntry	11	NONCLUSTERED				892530	0	0	610297	2026-10-03 00:03:28	2026-10-02 02:02:38	USED	keep — in use
host_726.emp.ShipmentMonthly.IX_InvoiceStaging	2	NONCLUSTERED				1269723	0	0	610297	2026-10-03 00:03:32	2026-10-02 02:02:38	USED	keep — in use
host_726.emp.ShipmentMonthly.PK_BatchDaily	1	CLUSTERED	Y	Y		4113	1238	1003131	614410	2026-10-03 00:03:21	2026-10-02 02:02:37	USED	KEEP — primary key
host_726.emp.AssetDetail.PK_ReconcileResult	1	CLUSTERED	Y	Y		0	0	0	267674	never	2026-10-02 02:02:39	UNUSED	KEEP — primary key
host_726.emp.AssetSnapshot.IX_ForecastStatus	5	NONCLUSTERED				5198898	7681	0	270895	2026-10-03 00:03:33	2026-10-02 02:02:46	USED	keep — in use
host_726.emp.AssetSnapshot.IX_SalesDaily	2	NONCLUSTERED				3422524	17077	0	270895	2026-10-03 00:03:34	2026-10-02 02:02:46	USED	keep — in use
host_726.emp.AssetSnapshot.PK_OrdersDetail	1	CLUSTERED	Y	Y		199965	0	615303	270895	2026-10-03 00:03:32	2026-10-02 02:02:43	USED	KEEP — primary key
host_726.emp.PricingStatus.PK_PolicyStatus	1	CLUSTERED	Y	Y		0	3	0	270884	2026-09-29 13:56:12	2026-10-02 02:02:47	USED	KEEP — primary key
host_726.emp.TicketSnapshot.IX_BookingHistory	15	NONCLUSTERED				0	13388	0	320166	2026-10-02 21:52:54	2026-10-02 02:03:07	USED	keep — in use
host_726.emp.TicketSnapshot.PK_CampaignQueue	1	CLUSTERED	Y	Y		9081984	598230	4	320166	2026-10-03 00:03:33	2026-10-02 02:02:53	USED	KEEP — primary key
host_726.emp.TicketSnapshot.IX_ContractEntry	19	NONCLUSTERED	Y			586595	2067	0	320166	2026-10-03 00:03:33	2026-10-02 02:03:07	USED	keep — in use
host_726.emp.MeterEntry.IX_OrdersAudit	1	CLUSTERED				0	0	0	213013	never	2026-10-02 02:03:09	UNUSED	KEEP — table storage
host_726.emp.ForecastMonthly.PK_CampaignSummary	1	CLUSTERED	Y	Y		0	31	0	319979	2026-10-02 01:15:01	2026-10-02 02:03:09	USED	KEEP — primary key
host_726.emp.PricingStatus.IX_QuotaLog	7	NONCLUSTERED				27187	0	0	113541	2026-10-03 00:03:32	2026-10-02 02:03:11	USED	keep — in use
host_726.emp.PricingStatus.IX_ClaimEntry	2	NONCLUSTERED				8418809	28612	0	113541	2026-10-03 00:03:34	2026-10-02 02:03:11	USED	keep — in use
host_726.emp.PricingStatus.PK_LedgerResult	1	CLUSTERED	Y	Y		2239237	691	27049	113541	2026-10-03 00:03:32	2026-10-02 02:03:11	USED	KEEP — primary key
host_726.emp.AssetDaily.IX_PayrollDaily	1	CLUSTERED				0	0	0	1145	never	2026-10-02 02:03:11	UNUSED	KEEP — table storage
host_726.emp.PayrollHistory.PK_LedgerQueue	1	CLUSTERED	Y	Y		0	1	0	113528	2026-09-29 13:51:06	2026-10-02 02:03:12	USED	KEEP — primary key
host_726.emp.QuotaSummary.IX_StaffingQueue	10	NONCLUSTERED				581341	167945	0	10835	2026-10-03 00:03:28	2026-10-02 02:03:12	USED	keep — in use
host_726.emp.QuotaSummary.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	331	165313	10835	2026-10-03 00:01:52	2026-10-02 02:03:12	USED	KEEP — primary key
host_726.emp.PricingQueue.PK_PricingStaging	1	CLUSTERED	Y	Y		0	0	0	8208	never	2026-10-02 02:03:12	UNUSED	KEEP — primary key
host_726.emp.BookingMonthly.IX_ShipmentAudit	5	NONCLUSTERED				650377	9121593	0	9413	2026-10-03 00:03:34	2026-10-02 02:03:13	USED	keep — in use
host_726.emp.BookingMonthly.PK_WarehouseLog	1	CLUSTERED	Y	Y		278	0	0	9413	2026-10-01 12:37:37	2026-10-02 02:03:13	USED	KEEP — primary key
host_726.emp.MeterSnapshot.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	0	0	9413	never	2026-10-02 02:03:13	UNUSED	KEEP — primary key
host_726.emp.BatchMonthly.IX_ClaimSummary	18	NONCLUSTERED				0	1034	0	12207	2026-10-02 16:09:12	2026-10-02 02:03:14	USED	keep — in use
host_726.emp.BatchMonthly.PK_InvoiceDetail	1	CLUSTERED	Y	Y		11169105	60756	997	12207	2026-10-03 00:03:34	2026-10-02 02:03:14	USED	KEEP — primary key
host_726.emp.BatchMonthly.IX_TerritorySnapshot	19	NONCLUSTERED	Y			13273	3	0	12207	2026-10-02 23:17:08	2026-10-02 02:03:14	USED	keep — in use
host_726.emp.WarehouseMonthly.IX_InvoiceStatus	1	CLUSTERED				0	0	0	4897	never	2026-10-02 02:03:15	UNUSED	KEEP — table storage
host_726.emp.StaffingAudit.PK_ForecastHeader	1	CLUSTERED	Y	Y		0	26	0	12369	2026-10-02 01:15:02	2026-10-02 02:03:15	USED	KEEP — primary key
host_726.emp.BatchLog.PK_SalesDetail	1	CLUSTERED	Y	Y		1462055	9136901	0	14624	2026-10-03 00:03:34	2026-10-02 02:03:16	USED	KEEP — primary key
host_726.emp.ReconcileSummary.IX_ShipmentDetail	1	CLUSTERED				0	0	0	135	never	2026-10-02 02:03:16	UNUSED	KEEP — table storage
host_726.emp.RouteHistory.PK_MeterEntry	1	CLUSTERED	Y	Y		0	0	0	14624	never	2026-10-02 02:03:17	UNUSED	KEEP — primary key
host_726.emp.CampaignResult.IX_ClaimStatus	15	NONCLUSTERED				2009148	18	0	267460	2026-10-03 00:03:21	2026-10-02 02:03:58	USED	keep — in use
host_726.emp.CampaignResult.IX_CustomerQueue	6	NONCLUSTERED				8667500	0	0	534920	2026-10-03 00:03:32	2026-10-02 02:03:58	USED	keep — in use
host_726.emp.CampaignResult.PK_StaffingArchive	1	CLUSTERED	Y	Y		5767987	5873	11160738	535243	2026-10-03 00:03:32	2026-10-02 02:03:17	USED	KEEP — primary key
host_726.emp.SalesHeader.IX_BookingSummary	2	NONCLUSTERED				0	0	0	11425	never	2026-10-02 02:04:02	UNUSED	review, then DROP
host_726.emp.SalesHeader.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	0	0	11425	never	2026-10-02 02:04:02	UNUSED	KEEP — primary key
host_726.emp.PayrollHistory.PK_CampaignStaging	1	CLUSTERED	Y	Y		26396	170	0	1985	2026-10-02 21:53:22	2026-10-02 02:03:59	USED	KEEP — primary key
host_726.emp.TerritoryDaily.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	1977	never	2026-10-02 02:03:59	UNUSED	KEEP — primary key
host_726.emp.CatalogSummary.IX_PricingSnapshot	27	NONCLUSTERED				375315	13	0	7840	2026-10-03 00:02:40	2026-10-02 02:04:00	USED	keep — in use
host_726.emp.CatalogSummary.IX_WarehouseSnapshot	7	NONCLUSTERED				695131	28710	0	2328	2026-10-03 00:02:59	2026-10-02 02:04:00	USED	keep — in use
host_726.emp.CatalogSummary.IX_ReconcileSummary	21	NONCLUSTERED				2813756	24	0	2328	2026-10-03 00:03:32	2026-10-02 02:04:00	USED	keep — in use
host_726.emp.CatalogSummary.IX_AssetEntry	26	NONCLUSTERED				1103852	6652	0	7840	2026-10-03 00:03:32	2026-10-02 02:04:00	USED	keep — in use
host_726.emp.CatalogSummary.PK_ShipmentStaging	1	CLUSTERED	Y	Y		12054374	133138	4152674	15747	2026-10-03 00:03:34	2026-10-02 02:04:00	USED	KEEP — primary key
host_726.emp.CatalogSummary.UX_OrdersAudit	2	NONCLUSTERED	Y			298	344	0	2328	2026-10-02 21:52:57	2026-10-02 02:04:00	USED	keep — in use
host_726.emp.CatalogSummary.UX_LedgerHistory	4	NONCLUSTERED	Y		Y	419029	1	0	7925	2026-10-03 00:03:10	2026-10-02 02:04:00	USED	keep — in use
host_726.emp.TicketMonthly.PK_LedgerAudit	1	CLUSTERED	Y	Y		8242	2646	0	11377	2026-10-02 21:46:47	2026-10-02 02:04:00	USED	KEEP — primary key
host_726.emp.BillingQueue.IX_AssetDetail	11	NONCLUSTERED				113	941	0	4058	2026-10-02 09:46:58	2026-10-02 02:04:01	USED	keep — in use
host_726.emp.BillingQueue.IX_ContractSummary	8	NONCLUSTERED				5365587	5	0	4058	2026-10-03 00:03:34	2026-10-02 02:04:01	USED	keep — in use
host_726.emp.BillingQueue.PK_ShipmentEntry	1	CLUSTERED	Y	Y		0	131203	5365462	4058	2026-10-03 00:03:34	2026-10-02 02:04:01	USED	KEEP — primary key
host_726.emp.CampaignResult.IX_SupplierLine	13	NONCLUSTERED				3751	0	0	16215	2026-10-02 16:32:54	2026-10-02 02:04:01	USED	keep — in use
host_726.emp.CampaignResult.PK_CustomerLine	1	CLUSTERED	Y	Y		12	4429	3751	16215	2026-10-02 16:35:06	2026-10-02 02:04:01	USED	KEEP — primary key
host_726.guest.TerritoryQueue.IX_InvoiceStaging	2	NONCLUSTERED				0	0	0	0	never	2026-09-27 02:06:47	UNUSED	review, then DROP
host_726.org.SettlementSnapshot.PK_org.SettlementSnapshot	1	CLUSTERED	Y	Y		0	217	0	0	2026-10-02 15:49:33	2026-09-27 02:07:01	USED	KEEP — primary key
host_726.org.SettlementSnapshot.UX_BillingLine	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:07:01	UNUSED	review carefully — unique
host_726.org.PolicySummary.IX_AssetEntry	3	NONCLUSTERED				1477778	112773	0	70	2026-10-03 00:03:32	2026-09-30 02:05:34	USED	keep — in use
host_726.org.PolicySummary.PK_QuotaAudit	1	CLUSTERED	Y	Y		13843258	1201412	1482656	218	2026-10-03 00:03:34	2026-09-30 02:05:34	USED	KEEP — primary key
host_726.org.PolicySummary.UX_ForecastHistory	2	NONCLUSTERED	Y		Y	5032	0	0	90	2026-10-02 21:51:08	2026-09-30 02:05:34	USED	keep — in use
host_726.org.BatchMonthly.PK_WarehouseSummary	1	CLUSTERED	Y	Y		159	5259	0	81	2026-10-02 21:13:00	2026-10-02 02:04:02	USED	KEEP — primary key
host_726.org.BatchMonthly.UX_SalesSnapshot	2	NONCLUSTERED	Y		Y	0	0	0	81	never	2026-10-02 02:04:02	UNUSED	review carefully — unique
host_726.org.CampaignQueue.PK_RosterDaily	1	CLUSTERED	Y	Y		0	0	0	113	never	2026-10-02 02:04:02	UNUSED	KEEP — primary key
host_726.org.TicketLog.PK_WarehouseDetail	1	CLUSTERED	Y	Y		520	549	31	468	2026-10-02 16:32:54	2026-09-27 02:07:03	USED	KEEP — primary key
host_726.org.TicketLog.UX_SalesMonthly	4	NONCLUSTERED	Y			30	2	0	468	2026-10-02 14:09:44	2026-10-02 02:04:02	USED	keep — in use
host_726.org.Company.PK_QuotaStaging	1	CLUSTERED	Y	Y		2898792	680167	252	1	2026-10-03 00:03:32	2026-09-27 02:07:03	USED	KEEP — primary key
host_726.org.Company.UX_PricingResult	2	NONCLUSTERED	Y		Y	0	252	0	1	2026-10-02 22:40:10	2026-09-27 02:07:03	USED	keep — in use
host_726.org.ShipmentAudit.PK_ForecastHeader	1	CLUSTERED	Y	Y		3	3480430	1496801	5	2026-10-03 00:03:33	2026-09-27 02:07:03	USED	KEEP — primary key
host_726.org.ShipmentAudit.UX_BatchArchive	2	NONCLUSTERED	Y			1492148	4846	0	5	2026-10-03 00:03:32	2026-09-27 02:07:03	USED	keep — in use
host_726.org.WarehouseStaging.PK_MeterHistory	1	CLUSTERED	Y	Y		0	0	0	3	never	2026-09-27 02:07:03	UNUSED	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		130	443	0	1	2026-10-02 21:52:49	2026-09-27 02:07:04	USED	KEEP — primary key
host_726.org.PricingStatus.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-09-27 02:07:04	UNUSED	KEEP — primary key
host_726.org.CatalogHeader.PK_ShiftStatus	1	CLUSTERED	Y	Y		1211	661	0	42	2026-10-02 22:36:07	2026-09-27 02:07:04	USED	KEEP — primary key
host_726.org.PolicySummary.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	0	0	42	never	2026-10-02 02:04:03	UNUSED	KEEP — primary key
host_726.org.CatalogAudit.PK_AssetStatus	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-09-27 02:07:04	UNUSED	KEEP — primary key
host_726.org.OrdersSummary.PK_StaffingAudit	1	CLUSTERED	Y	Y		1724	452	0	870	2026-10-02 22:41:06	2026-09-27 02:07:05	USED	KEEP — primary key
host_726.org.ContractResult.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	870	never	2026-09-27 02:07:05	UNUSED	KEEP — primary key
host_726.org.SupplierHistory.IX_ShipmentSummary	2	NONCLUSTERED				0	0	0	1150	never	2026-10-01 02:02:20	UNUSED	review, then DROP
host_726.org.SupplierHistory.PK_CustomerDetail	1	CLUSTERED	Y	Y		539	143121	0	1150	2026-10-02 23:06:47	2026-10-01 02:02:20	USED	KEEP — primary key
host_726.org.ContractStaging.PK_CatalogDetail	1	CLUSTERED	Y	Y		0	2	0	0	2026-09-28 16:36:22	never	USED	KEEP — primary key
host_726.org.BatchSummary.PK_SettlementHistory	1	CLUSTERED	Y	Y		0	1	0	0	2026-09-19 12:43:08	never	USED	KEEP — primary key
host_726.org.BillingHeader.IX_ShiftHistory	2	NONCLUSTERED				0	0	0	213	never	2026-10-01 02:02:20	UNUSED	review, then DROP
host_726.org.BillingHeader.PK_InvoiceMonthly	1	CLUSTERED	Y	Y		100	35836	0	213	2026-10-02 23:06:47	2026-10-01 02:02:20	USED	KEEP — primary key
host_726.org.ShipmentSummary.IX_StaffingResult	2	NONCLUSTERED				0	0	0	95	never	2026-10-01 02:02:20	UNUSED	review, then DROP
host_726.org.ShipmentSummary.PK_ClaimDetail	1	CLUSTERED	Y	Y		44	35835	0	95	2026-10-02 23:06:47	2026-10-01 02:02:20	USED	KEEP — primary key
host_726.org.SalesStatus.IX_ClaimHeader	2	NONCLUSTERED	Y			35841	0	0	3	2026-10-02 23:06:47	2026-10-01 02:02:20	USED	keep — in use
host_726.org.SalesStatus.PK_CampaignSnapshot	1	CLUSTERED	Y	Y		17	0	35837	3	2026-10-02 23:06:47	2026-09-27 02:07:05	USED	KEEP — primary key
host_726.org.PolicyResult.PK_ForecastStaging	1	CLUSTERED	Y	Y		684	19423328	0	4	2026-10-03 00:03:34	2026-09-27 02:07:05	USED	KEEP — primary key
host_726.org.AssetSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		293368	28327	0	1	2026-10-02 23:56:10	2026-09-27 02:07:05	USED	KEEP — primary key
host_726.org.AssetSummary.UX_ShipmentSummary	2	NONCLUSTERED	Y			4	146934	0	1	2026-10-02 22:38:16	2026-09-27 02:07:05	USED	keep — in use
host_726.org.ShipmentQueue.PK_InvoiceStaging	1	CLUSTERED	Y	Y		665044	5866990	0	36	2026-10-03 00:03:33	2026-10-02 02:04:03	USED	KEEP — primary key
host_726.org.PolicyEntry.PK_SettlementSnapshot	1	CLUSTERED	Y	Y		6696	1961	0	13	2026-10-03 00:02:57	2026-09-30 02:05:34	USED	KEEP — primary key
host_726.org.PolicyEntry.UX_ShiftSnapshot	2	NONCLUSTERED	Y		Y	0	0	0	12	never	2026-10-02 02:04:03	UNUSED	review carefully — unique
host_726.org.MeterAudit.IX_WarehouseQueue	6	NONCLUSTERED				1367	0	0	8	2026-10-02 16:32:54	2026-10-02 02:04:03	USED	keep — in use
host_726.org.MeterAudit.PK_BillingDetail	1	CLUSTERED	Y	Y		6460	1	0	12	2026-10-03 00:02:57	2026-10-02 02:04:03	USED	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	11	never	2026-10-02 02:04:04	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	216	0	0	2026-10-02 15:49:33	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		384537	741	21	38	2026-10-03 00:00:52	2026-09-27 02:07:07	USED	KEEP — primary key
host_726.org.ReconcileAudit.UQ_ShipmentResult	2	NONCLUSTERED	Y		Y	44	0	0	38	2026-10-02 15:19:32	2026-09-29 02:03:41	USED	keep — in use
host_726.org.StaffingAudit.PK_RosterArchive	1	CLUSTERED	Y	Y		0	0	0	52	never	2026-09-29 02:03:42	UNUSED	KEEP — primary key
host_726.org.ShiftResult.PK_AssetAudit	1	CLUSTERED	Y	Y		11781040	3816713	0	20	2026-10-03 00:03:33	2026-09-27 02:07:08	USED	KEEP — primary key
host_726.org.BatchMonthly.PK_SalesLine	1	CLUSTERED	Y	Y		10	51554	0	20	2026-10-02 23:32:27	2026-09-27 02:07:08	USED	KEEP — primary key
host_726.org.RosterMonthly.IX_AssetDetail	2	NONCLUSTERED				0	0	0	12	never	2026-09-27 02:07:08	UNUSED	review, then DROP
host_726.org.RosterMonthly.PK_ForecastDaily	1	CLUSTERED	Y	Y		6	13465	0	12	2026-10-02 15:19:32	2026-09-27 02:07:08	USED	KEEP — primary key
host_726.org.InvoiceStaging.IX_AssetAudit	2	NONCLUSTERED				0	0	0	12	never	2026-09-27 02:07:08	UNUSED	review, then DROP
host_726.org.InvoiceStaging.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	0	0	12	never	2026-09-27 02:07:08	UNUSED	KEEP — primary key
host_726.org.StaffingAudit.PK_AssetLog	1	CLUSTERED	Y	Y		0	0	0	23	never	2026-09-29 02:03:42	UNUSED	KEEP — primary key
host_726.org.Level.PK_ShiftStaging	1	CLUSTERED	Y	Y		1113919	5831	0	1	2026-10-03 00:03:32	2026-09-27 02:07:09	USED	KEEP — primary key
host_726.org.Level.UX_SettlementHistory	2	NONCLUSTERED	Y		Y	0	239	0	1	2026-10-02 15:49:25	2026-09-27 02:07:09	USED	keep — in use
host_726.org.ContractHistory.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:07:09	UNUSED	KEEP — primary key
host_726.org.QuotaEntry.IX_AssetHistory	2	NONCLUSTERED				2	0	0	1	2026-09-22 10:14:28	2026-09-27 02:07:09	USED	keep — in use
host_726.org.QuotaEntry.PK_LedgerQueue	1	CLUSTERED	Y	Y		0	1877976	0	1	2026-10-03 00:03:33	2026-09-27 02:07:09	USED	KEEP — primary key
host_726.org.ClaimQueue.PK_LedgerHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:07:10	UNUSED	KEEP — primary key
host_726.org.SupplierLine.PK_InvoiceStatus	1	CLUSTERED	Y	Y		1490585	10895690	0	5	2026-10-03 00:03:32	2026-09-27 02:07:10	USED	KEEP — primary key
host_726.org.InvoiceHistory.PK_ContractDaily	1	CLUSTERED	Y	Y		0	45	0	0	2026-09-25 17:10:16	2026-09-27 02:07:10	USED	KEEP — primary key
host_726.org.AssetHeader.IX_PayrollAudit	2	NONCLUSTERED				12386170	0	0	1559	2026-10-03 00:03:32	2026-09-27 02:07:10	USED	keep — in use
host_726.org.AssetHeader.PK_LedgerResult	1	CLUSTERED	Y	Y		685	0	0	1559	2026-09-25 17:19:56	2026-09-27 02:07:10	USED	KEEP — primary key
host_726.org.TerritoryStatus.PK_PayrollLine	1	CLUSTERED	Y	Y		0	0	0	11	never	2026-09-27 02:07:10	UNUSED	KEEP — primary key
host_726.org.RosterLine.PK_BillingDaily	1	CLUSTERED	Y	Y		0	1	0	5	2026-09-28 07:38:34	2026-09-27 02:07:10	USED	KEEP — primary key
host_726.org.ForecastArchive.PK_CampaignHeader	1	CLUSTERED	Y	Y		303141	40	0	1	2026-10-03 00:03:32	2026-09-27 02:07:10	USED	KEEP — primary key
host_726.org.PolicySummary.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		9	1589969	0	19	2026-10-03 00:03:32	2026-09-27 02:07:10	USED	KEEP — primary key
host_726.org.ClaimMonthly.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:07:10	UNUSED	KEEP — primary key
host_726.org.OrdersEntry.PK_MeterDaily	1	CLUSTERED	Y	Y		64	765117	0	89	2026-10-03 00:03:32	2026-09-27 02:07:11	USED	KEEP — primary key
host_726.org.LedgerStaging.PK_BatchLine	1	CLUSTERED	Y	Y		0	0	0	89	never	2026-09-29 02:03:42	UNUSED	KEEP — primary key
host_726.org.Position.PK_PolicySummary	1	CLUSTERED	Y	Y		6079382	40646	0	31	2026-10-03 00:03:32	2026-09-30 02:05:35	USED	KEEP — primary key
host_726.org.Position.UX_MeterArchive	2	NONCLUSTERED	Y		Y	0	0	0	31	never	2026-10-02 02:04:04	UNUSED	review carefully — unique
host_726.org.CampaignQueue.PK_BillingArchive	1	CLUSTERED	Y	Y		439920	14777	1611	76	2026-10-02 23:56:10	2026-10-02 02:04:04	USED	KEEP — primary key
host_726.org.CampaignQueue.UX_TicketDaily	2	NONCLUSTERED	Y			1479052	172	0	68	2026-10-03 00:03:32	2026-10-02 02:04:04	USED	keep — in use
host_726.org.MeterResult.PK_CatalogStaging	1	CLUSTERED	Y	Y		0	7	0	964	2026-09-22 15:41:26	2026-10-02 02:04:04	USED	KEEP — primary key
host_726.org.QuotaLine.PK_AssetAudit	1	CLUSTERED	Y	Y		73	170	264	52	2026-10-02 15:49:25	2026-10-02 02:04:04	USED	KEEP — primary key
host_726.org.QuotaLine.UX_PricingAudit	2	NONCLUSTERED	Y		Y	0	264	0	52	2026-10-02 15:49:25	never	USED	keep — in use
host_726.org.PayrollLog.PK_PayrollAudit	1	CLUSTERED	Y	Y		0	51	19	23	2026-10-02 15:49:25	2026-10-02 02:04:04	USED	KEEP — primary key
host_726.org.PayrollLog.UX_PayrollDetail	2	NONCLUSTERED	Y			19	0	0	23	2026-10-02 15:49:21	2026-10-02 02:04:04	USED	keep — in use
host_726.org.LedgerDaily.PK_ContractHeader	1	CLUSTERED	Y	Y		0	4	0	30	2026-09-28 14:02:23	2026-10-02 02:04:04	USED	KEEP — primary key
host_726.org.PricingArchive.PK_ShiftStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:07:12	UNUSED	KEEP — primary key
host_726.org.PricingArchive.UX_InvoiceAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:07:12	UNUSED	review carefully — unique
host_726.org.ForecastAudit.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	1352	0	0	2026-10-02 18:31:31	2026-09-27 02:07:12	USED	KEEP — primary key
host_726.org.ForecastAudit.UX_ClaimArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:07:12	UNUSED	review carefully — unique
host_726.org.PayrollLine.PK_OrdersHistory	1	CLUSTERED	Y	Y		2090	1352	0	0	2026-10-02 18:31:31	2026-09-27 02:07:12	USED	KEEP — primary key
host_726.org.PayrollLine.UX_ShiftLog	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:07:12	UNUSED	review carefully — unique
host_726.org.BookingStaging.PK_AssetResult	1	CLUSTERED	Y	Y		8404925	1042489	0	58	2026-10-03 00:03:34	2026-09-27 02:07:12	USED	KEEP — primary key
host_726.org.ReconcileLine.PK_CustomerLog	1	CLUSTERED	Y	Y		0	0	0	25	never	2026-09-29 02:03:42	UNUSED	KEEP — primary key
host_726.org.ShiftStaging.PK_BillingHistory	1	CLUSTERED	Y	Y		0	14	0	0	2026-09-29 10:26:40	2026-09-27 02:07:13	USED	KEEP — primary key
host_726.org.ShiftStaging.UQ_PolicyAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:07:13	UNUSED	review carefully — unique
host_726.org.CustomerLine.IX_ForecastLine	2	NONCLUSTERED				14	0	0	0	2026-09-29 10:26:39	2026-09-27 02:07:13	USED	keep — in use
host_726.org.CustomerLine.PK_LedgerEntry	1	CLUSTERED	Y	Y		2	34137	0	0	2026-10-02 23:06:47	2026-09-27 02:07:13	USED	KEEP — primary key
host_726.org.CustomerLine.UQ_PayrollLog	3	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:07:13	UNUSED	review carefully — unique
host_726.org.InvoiceMonthly.PK_WarehouseQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:07:13	UNUSED	KEEP — primary key
host_726.org.InvoiceMonthly.UQ_MeterAudit	2	NONCLUSTERED	Y			0	14	0	0	2026-09-29 10:26:40	2026-09-27 02:07:13	USED	keep — in use
host_726.org.QuotaStaging.PK_ShiftStaging	1	CLUSTERED	Y	Y		0	23	34081	0	2026-10-02 23:06:47	2026-09-27 02:07:13	USED	KEEP — primary key
host_726.org.QuotaStaging.UQ_ShiftMonthly	2	NONCLUSTERED	Y			34081	0	0	0	2026-10-02 23:06:47	2026-09-27 02:07:13	USED	keep — in use
host_726.org.BatchMonthly.PK_WarehouseHeader	1	CLUSTERED	Y	Y		0	33381	0	0	2026-10-02 23:06:47	2026-09-27 02:07:14	USED	KEEP — primary key
host_726.org.BatchMonthly.UQ_LedgerStaging	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:07:14	UNUSED	review carefully — unique
host_726.org.ClaimHeader.PK_ClaimArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:07:14	UNUSED	KEEP — primary key
host_726.org.SupplierResult.PK_ForecastQueue	1	CLUSTERED	Y	Y		112	128471	0	1	2026-10-02 23:39:21	2026-09-27 02:07:14	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		5961	15408	4555084	27077	2026-10-03 00:03:34	2026-10-02 02:04:04	USED	KEEP — primary key
host_726.org.ShiftResult.UX_LedgerStaging	2	NONCLUSTERED	Y			4555152	48	0	27077	2026-10-03 00:03:34	2026-10-02 02:04:05	USED	keep — in use
host_726.org.QuotaResult.PK_CampaignDaily	1	CLUSTERED	Y	Y		106505	19693	3	2	2026-10-03 00:03:32	2026-09-27 02:07:14	USED	KEEP — primary key
host_726.org.QuotaResult.UX_BatchDaily	2	NONCLUSTERED	Y			5	0	0	2	2026-09-22 10:14:28	2026-09-27 02:07:14	USED	keep — in use
host_726.org.QuotaDetail.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		3	15639287	0	5	2026-10-03 00:03:32	2026-09-27 02:07:14	USED	KEEP — primary key
host_726.org.BookingLog.PK_MeterStaging	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-09-27 02:07:14	UNUSED	KEEP — primary key
host_726.org.SettlementAudit.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-09-27 02:07:14	UNUSED	KEEP — primary key
host_726.oth.QuotaSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		6	20	0	0	2026-10-02 21:46:22	2026-09-27 02:07:15	USED	KEEP — primary key
host_726.oth.InvoiceStatus.PK_ShiftQueue	1	CLUSTERED	Y	Y		1781	135	0	0	2026-10-03 00:00:00	2026-09-27 02:07:15	USED	KEEP — primary key
host_726.oth.SupplierLine.PK_QuotaDetail	1	CLUSTERED	Y	Y		0	4	0	0	2026-10-02 21:45:43	2026-09-27 02:07:16	USED	KEEP — primary key
host_726.oth.SupplierLine.UX_InvoiceHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:07:16	UNUSED	review carefully — unique
host_726.oth.StaffingArchive.IX_InvoiceStaging	2	NONCLUSTERED				0	0	0	0	never	2026-09-27 02:07:16	UNUSED	review, then DROP
host_726.oth.StaffingArchive.PK_PricingAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:07:16	UNUSED	KEEP — primary key
host_726.oth.StaffingArchive.UQ_SalesAudit	3	NONCLUSTERED	Y			22	1789	0	0	2026-10-02 23:27:18	2026-09-27 02:07:16	USED	keep — in use
host_726.oth.CustomerQueue.IX_WarehouseResult	2	NONCLUSTERED				12	20	0	0	2026-10-02 21:46:22	2026-09-27 02:07:16	USED	keep — in use
host_726.oth.CustomerQueue.PK_TerritoryResult	1	CLUSTERED	Y	Y		0	28	6	0	2026-10-02 21:45:43	2026-09-27 02:07:16	USED	KEEP — primary key
host_726.rec.Candidate.PK_BookingArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.rec.Candidate.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	57737	0	2545	2026-10-02 23:56:11	2026-10-02 02:04:05	USED	KEEP — primary key
host_726.sal.ClaimArchive.IX_RouteDetail	2	NONCLUSTERED				0	0	0	0	never	2026-09-27 02:07:17	UNUSED	review, then DROP
host_726.sal.ClaimArchive.PK_LedgerHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:07:17	UNUSED	KEEP — primary key
host_726.sal.QuotaLine.PK_ContractArchive	1	CLUSTERED	Y	Y		26121	139649	0	21	2026-10-03 00:03:00	2026-10-01 02:02:23	USED	KEEP — primary key
host_726.sal.SalesStatus.PK_ShiftMonthly	1	CLUSTERED	Y	Y		444589	2263	0	230	2026-10-02 23:56:10	2026-10-02 02:04:05	USED	KEEP — primary key
host_726.sal.SettlementQueue.PK_StaffingSnapshot	1	CLUSTERED	Y	Y		0	490201	0	188401	2026-10-02 23:56:10	2026-10-02 02:04:05	USED	KEEP — primary key
host_726.sal.MeterHistory.PK_LedgerSnapshot	1	CLUSTERED	Y	Y		0	19519	0	188401	2026-10-02 23:06:47	2026-10-02 02:04:05	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	458	0	0	2026-10-02 21:46:47	2026-09-27 02:08:29	USED	KEEP — primary key
host_726.sal.RouteResult.UX_ContractEntry	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:08:29	UNUSED	review carefully — unique
host_726.sal.WarehouseDaily.PK_SettlementDetail	1	CLUSTERED	Y	Y		11939	7880	0	42	2026-10-02 22:40:10	2026-09-27 02:08:29	USED	KEEP — primary key
host_726.sal.WarehouseDaily.UX_BookingAudit	2	NONCLUSTERED	Y			2	0	0	41	2026-09-09 15:48:18	2026-10-02 02:04:06	USED	keep — in use
host_726.sal.InvoiceLog.PK_MeterAudit	1	CLUSTERED	Y	Y		315	471	0	314	2026-10-02 21:46:47	2026-09-27 02:08:29	USED	KEEP — primary key
host_726.sal.PolicySnapshot.PK_ReconcileQueue	1	CLUSTERED	Y	Y		0	2	0	314	2026-09-09 15:55:25	2026-10-02 02:04:06	USED	KEEP — primary key
host_726.sal.SettlementStatus.PK_ReconcileResult	1	CLUSTERED	Y	Y		2121	628	1940	2107	2026-10-02 21:47:01	2026-09-27 02:08:30	USED	KEEP — primary key
host_726.sal.SettlementStatus.UX_StaffingMonthly	2	NONCLUSTERED	Y			1939	1	0	2102	2026-10-02 21:47:01	2026-10-02 02:04:06	USED	keep — in use
host_726.sal.ReconcileHistory.PK_PayrollHeader	1	CLUSTERED	Y	Y		151	302	1	302	2026-10-02 16:08:43	2026-10-02 02:04:06	USED	KEEP — primary key
host_726.sal.ReconcileHistory.UX_TicketQueue	2	NONCLUSTERED	Y			1	0	0	302	2026-09-09 14:08:21	2026-10-02 02:04:06	USED	keep — in use
host_726.sal.InvoiceEntry.PK_RouteQueue	1	CLUSTERED	Y	Y		0	0	0	302	never	2026-10-02 02:04:06	UNUSED	KEEP — primary key
host_726.sal.BillingQueue.PK_ReconcileHistory	1	CLUSTERED	Y	Y		0	0	0	2099	never	2026-10-02 02:04:06	UNUSED	KEEP — primary key
host_726.sal.RosterDetail.PK_BookingStaging	1	CLUSTERED	Y	Y		0	0	0	42	never	2026-10-02 02:04:06	UNUSED	KEEP — primary key
host_726.sal.RosterQueue.PK_ShiftQueue	1	CLUSTERED	Y	Y		0	17170	0	0	2026-10-02 23:06:47	2026-09-27 02:08:31	USED	KEEP — primary key
host_726.sal.RosterQueue.UX_RosterArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:08:31	UNUSED	review carefully — unique
host_726.sal.WarehouseHeader.PK_RouteEntry	1	CLUSTERED	Y	Y		0	380	0	0	2026-10-02 14:09:37	2026-09-27 02:08:31	USED	KEEP — primary key
host_726.sal.SupplierArchive.PK_SupplierStaging	1	CLUSTERED	Y	Y		0	87	0	0	2026-09-29 08:39:11	2026-09-27 02:08:31	USED	KEEP — primary key
host_726.sal.RosterQueue.PK_PolicyLog	1	CLUSTERED	Y	Y		0	22	0	0	2026-10-02 21:46:32	2026-09-27 02:08:31	USED	KEEP — primary key
host_726.sal.CustomerSnapshot.PK_RosterEntry	1	CLUSTERED	Y	Y		0	87	0	0	2026-09-29 08:39:11	2026-09-27 02:08:31	USED	KEEP — primary key
host_726.sal.LedgerStatus.PK_WarehouseStaging	1	CLUSTERED	Y	Y		22	16	0	0	2026-10-02 21:46:32	2026-09-27 02:08:31	USED	KEEP — primary key
host_726.sal.BookingLine.PK_PricingAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:08:31	UNUSED	KEEP — primary key
host_726.sal.PricingLine.PK_BatchLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:08:31	UNUSED	KEEP — primary key
host_726.sal.WarehouseStaging.PK_SettlementHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:08:32	UNUSED	KEEP — primary key
host_726.sal.StaffingArchive.PK_CatalogLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:08:32	UNUSED	KEEP — primary key
host_726.sal.WarehouseSummary.PK_RosterArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:08:32	UNUSED	KEEP — primary key
host_726.schedule.CustomerDetail.PK_CatalogStaging	1	CLUSTERED	Y	Y		0	204	3866615	0	2026-10-03 00:03:34	2026-09-27 02:08:32	USED	KEEP — primary key
host_726.schedule.CustomerDetail.UQ_BillingSnapshot	3	NONCLUSTERED	Y			3862842	1717	0	0	2026-10-03 00:03:34	2026-09-27 02:08:32	USED	keep — in use
host_726.schedule.CustomerDetail.UQ_CampaignResult	2	NONCLUSTERED	Y			3867374	1497	0	0	2026-10-03 00:03:34	2026-09-27 02:08:32	USED	keep — in use
host_726.schedule.InvoiceHistory.IX_StaffingHeader	3	NONCLUSTERED				0	0	0	0	never	2026-09-27 02:08:32	UNUSED	review, then DROP
host_726.schedule.InvoiceHistory.PK_ContractLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 02:08:32	UNUSED	KEEP — primary key
host_726.schedule.InvoiceHistory.UQ_LedgerResult	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:08:32	UNUSED	review carefully — unique
host_726.schedule.MeterStaging.PK_SettlementMonthly	1	CLUSTERED	Y	Y		3757474	0	0	1612	2026-10-03 00:03:33	2026-10-02 02:04:07	USED	KEEP — primary key
host_726.schedule.SettlementLine.PK_CampaignStatus	1	CLUSTERED	Y	Y		4217974	754	0	1740	2026-10-03 00:03:34	2026-10-02 02:04:07	USED	KEEP — primary key
host_726.schedule.TicketEntry.PK_CampaignDaily	1	CLUSTERED	Y	Y		995	1738	0	1739	2026-10-02 22:36:07	2026-10-02 02:04:07	USED	KEEP — primary key
host_726.schedule.QuotaSummary.PK_LedgerStatus	1	CLUSTERED	Y	Y		9689206	4144	0	758	2026-10-03 00:03:34	2026-10-02 02:04:07	USED	KEEP — primary key
host_726.schedule.ShipmentLog.PK_SalesEntry	1	CLUSTERED	Y	Y		3885212	0	0	3200	2026-10-03 00:03:34	2026-10-02 22:34:20	USED	KEEP — primary key
host_726.schedule.PricingResult.PK_CampaignDaily	1	CLUSTERED	Y	Y		3863618	3949	0	752	2026-10-03 00:03:34	2026-09-27 02:08:33	USED	KEEP — primary key
host_726.schedule.SupplierSnapshot.IX_BillingHeader	3	NONCLUSTERED				8104850	1465	0	13363810	2026-10-03 00:03:34	2026-10-02 22:32:30	USED	keep — in use
host_726.schedule.SupplierSnapshot.PK_AssetStatus	1	CLUSTERED	Y	Y		24121216	638142	7505240	17245806	2026-10-03 00:03:34	2026-10-02 22:36:09	USED	KEEP — primary key
host_726.schedule.SupplierSnapshot.IX_ContractLog	2	NONCLUSTERED	Y			15	2737089	0	7729138	2026-10-03 00:03:33	2026-10-02 22:32:28	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				5492889	246966	0	7513186	2026-10-03 00:03:32	2026-10-02 22:36:05	USED	keep — in use
host_726.schedule.RosterSummary.IX_ClaimHeader	3	NONCLUSTERED				4001229	458001	0	7513186	2026-10-03 00:03:32	2026-10-02 22:36:22	USED	keep — in use
host_726.schedule.RosterSummary.PK_CustomerAudit	1	CLUSTERED	Y	Y		134978894	3137	4097221	15491944	2026-10-03 00:03:32	2026-10-02 22:36:05	USED	KEEP — primary key
host_726.schedule.BillingDetail.IX_TicketHeader	2	NONCLUSTERED				54740049	355045	0	31789008	2026-10-03 00:03:32	2026-10-02 22:36:16	USED	keep — in use
host_726.schedule.BillingDetail.PK_BillingLog	1	CLUSTERED	Y	Y		202590629	834017	38662804	37423765	2026-10-03 00:03:33	2026-10-02 22:36:07	USED	KEEP — primary key
host_726.schedule.PolicyStatus.IX_ForecastAudit	2	NONCLUSTERED				30732351	0	0	66290521	2026-10-03 00:03:33	2026-10-02 22:36:06	USED	keep — in use
host_726.schedule.PolicyStatus.IX_SupplierLine	3	NONCLUSTERED				56627342	355	0	66290521	2026-10-03 00:03:33	2026-10-02 22:37:05	USED	keep — in use
host_726.schedule.PolicyStatus.PK_PricingDaily	1	CLUSTERED	Y	Y		78238759	1270	34942592	66290521	2026-10-03 00:03:33	2026-10-02 22:36:05	USED	KEEP — primary key
host_726.schedule.PolicyLine.IX_TerritorySnapshot	2	NONCLUSTERED				61905453	317	0	8998063	2026-10-03 00:03:32	2026-10-02 22:32:25	USED	keep — in use
host_726.schedule.PolicyLine.PK_BookingAudit	1	CLUSTERED	Y	Y		32752516	1485	1858995	14632048	2026-10-03 00:03:33	2026-10-02 22:32:25	USED	KEEP — primary key
host_726.schedule.AssetResult.IX_BillingResult	2	NONCLUSTERED				5643228	0	0	5643228	2026-10-03 00:03:34	never	USED	keep — in use
host_726.schedule.AssetResult.PK_TicketQueue	1	CLUSTERED	Y	Y		0	0	0	5643228	never	never	UNUSED	KEEP — primary key
host_726.schedule.InvoiceAudit.IX_StaffingQueue	2	NONCLUSTERED				98874996	139	0	24063562	2026-10-03 00:03:32	2026-10-02 22:34:51	USED	keep — in use
host_726.schedule.InvoiceAudit.PK_LedgerMonthly	1	CLUSTERED	Y	Y		31022491	178	2024304	24063562	2026-10-03 00:03:32	2026-10-02 22:34:51	USED	KEEP — primary key
host_726.schedule.SettlementLog.IX_TicketLine	2	NONCLUSTERED				56926925	0	0	75587149	2026-10-03 00:03:32	2026-10-02 22:36:30	USED	keep — in use
host_726.schedule.SettlementLog.IX_PolicyLine	3	NONCLUSTERED				9840418	142	0	75587149	2026-10-03 00:03:32	2026-10-02 22:36:30	USED	keep — in use
host_726.schedule.SettlementLog.PK_CatalogMonthly	1	CLUSTERED	Y	Y		106652928	8	6567573	83212219	2026-10-03 00:03:32	2026-10-02 22:36:29	USED	KEEP — primary key
host_726.schedule.ShiftHeader.IX_TicketStatus	4	NONCLUSTERED				1192	137	0	15540195	2026-09-30 10:40:10	2026-10-02 22:34:20	USED	keep — in use
host_726.schedule.ShiftHeader.IX_ShipmentLine	3	NONCLUSTERED				38985549	2	0	15540195	2026-10-03 00:03:34	2026-10-02 22:32:28	USED	keep — in use
host_726.schedule.ShiftHeader.PK_OrdersArchive	1	CLUSTERED	Y	Y		426202572	2366	11801230	27186214	2026-10-03 00:03:34	2026-10-02 22:34:18	USED	KEEP — primary key
host_726.schedule.ShiftHeader.IX_BookingStatus	2	NONCLUSTERED	Y			16496	5045	0	15540195	2026-10-02 22:37:50	2026-10-02 22:34:18	USED	keep — in use
host_726.schedule.PolicyLine.PK_RouteQueue	1	CLUSTERED	Y	Y		176518622	7060514	0	15540150	2026-10-03 00:03:34	2026-10-02 22:34:25	USED	KEEP — primary key
host_726.schedule.PolicyLine.UX_TerritoryHistory	2	NONCLUSTERED	Y		Y	0	0	0	7776158	never	2026-10-02 22:34:58	UNUSED	review carefully — unique
host_726.schedule.RosterHistory.IX_AssetSummary	2	NONCLUSTERED				30051638	355998	0	7776177	2026-10-03 00:03:34	2026-10-02 22:32:34	USED	keep — in use
host_726.schedule.RosterHistory.PK_WarehouseLine	1	CLUSTERED	Y	Y		13265928	0	355084	7776177	2026-10-03 00:03:33	2026-10-02 22:32:34	USED	KEEP — primary key
host_726.schedule.MeterStaging.IX_PayrollAudit	2	NONCLUSTERED				44738778	4285020	0	7776181	2026-10-03 00:03:34	2026-10-02 22:34:18	USED	keep — in use
host_726.schedule.MeterStaging.PK_PolicyArchive	1	CLUSTERED	Y	Y		9887283	3	1889070	7776181	2026-10-03 00:03:32	2026-10-02 22:34:18	USED	KEEP — primary key
host_726.schedule.CustomerHistory.IX_LedgerQueue	2	NONCLUSTERED				2632903	1331961	0	46712949	2026-10-03 00:03:32	2026-10-02 22:37:23	USED	keep — in use
host_726.schedule.CustomerHistory.PK_PayrollAudit	1	CLUSTERED	Y	Y		74123568	1018	880910	46945904	2026-10-03 00:03:32	2026-10-02 22:36:02	USED	KEEP — primary key
host_726.schedule.RosterResult.IX_BookingAudit	2	NONCLUSTERED				53	2790	0	22536084	2026-10-01 09:37:51	2026-10-02 22:36:00	USED	keep — in use
host_726.schedule.RosterResult.IX_AssetStaging	3	NONCLUSTERED				12951520	3473	0	22536084	2026-10-03 00:03:33	2026-10-02 22:36:00	USED	keep — in use
host_726.schedule.RosterResult.PK_PricingSummary	1	CLUSTERED	Y	Y		56527125	8685	3616385	22769039	2026-10-03 00:03:33	2026-10-02 22:36:00	USED	KEEP — primary key
host_726.schedule.LedgerSnapshot.PK_RouteStatus	1	CLUSTERED	Y	Y		27164004	1958602	0	12	2026-10-03 00:03:34	2026-09-27 03:06:20	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-27 03:06:20	USED	keep — in use
host_726.schedule.RosterHistory.PK_MeterLine	1	CLUSTERED	Y	Y		15847161	13	0	1601	2026-10-03 00:03:34	2026-10-02 02:40:48	USED	KEEP — primary key
host_726.schedule.AssetStaging.PK_CampaignResult	1	CLUSTERED	Y	Y		11628460	1717	0	1600	2026-10-03 00:03:34	2026-10-02 02:40:48	USED	KEEP — primary key
host_726.schedule.CampaignDaily.IX_BookingArchive	2	NONCLUSTERED				0	1	0	0	2026-10-01 15:39:54	never	USED	keep — in use
host_726.schedule.CampaignDaily.PK_PricingEntry	1	CLUSTERED	Y	Y		0	2	0	0	2026-10-02 14:58:18	never	USED	KEEP — primary key
host_726.schedule.BatchSnapshot.IX_ShiftQueue	3	NONCLUSTERED				0	44	0	59	2026-10-02 02:11:31	never	USED	keep — in use
host_726.schedule.BatchSnapshot.PK_ShiftHistory	1	CLUSTERED	Y	Y		0	28	0	59	2026-10-02 14:58:18	never	USED	KEEP — primary key
host_726.schedule.BatchSnapshot.UX_StaffingEntry	2	NONCLUSTERED	Y			118	42	0	59	2026-10-02 02:11:35	never	USED	keep — in use
host_726.schedule.InvoiceLog.PK_CatalogSummary	1	CLUSTERED	Y	Y		1157291	1398080	35755	15	2026-10-03 00:03:34	2026-09-27 02:08:33	USED	KEEP — primary key
host_726.schedule.InvoiceLog.IX_WarehouseHeader	2	NONCLUSTERED	Y			35770	0	0	15	2026-10-02 23:26:53	2026-09-27 02:08:33	USED	keep — in use
host_726.schedule.ContractResult.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	1281280	0	15	2026-10-03 00:03:32	2026-09-27 02:08:33	USED	KEEP — primary key
host_726.schedule.ContractResult.UX_CampaignHistory	2	NONCLUSTERED	Y		Y	1309795	22	0	15	2026-10-03 00:03:34	2026-09-27 02:08:33	USED	keep — in use
host_726.schedule.SalesArchive.IX_RosterStatus	1	CLUSTERED				0	0	0	14	never	2026-09-27 02:08:33	UNUSED	KEEP — table storage
host_726.schedule.CatalogHistory.PK_OrdersStatus	1	CLUSTERED	Y	Y		581146	19	0	0	2026-10-03 00:03:32	2026-09-27 02:08:33	USED	KEEP — primary key
host_726.schedule.CatalogHistory.IX_PricingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 02:08:33	UNUSED	review carefully — unique
host_726.schedule.engine.PK_ReconcileDaily	1	CLUSTERED	Y	Y		65225318	6	9623145	0	2026-10-03 00:03:34	2026-09-27 02:41:34	USED	KEEP — primary key
host_726.schedule.engine.UQ_MeterQueue	2	NONCLUSTERED	Y			9623185	0	0	0	2026-10-03 00:03:34	2026-09-27 02:41:34	USED	keep — in use
host_726.schedule.TerritoryAudit.PK_PayrollSnapshot	1	CLUSTERED	Y	Y		0	12	9254616	5501770	2026-10-03 00:03:33	2026-10-02 02:39:05	USED	KEEP — primary key
host_726.schedule.TerritoryAudit.UX_BookingHeader	2	NONCLUSTERED	Y		Y	9254616	0	0	3752910	2026-10-03 00:03:33	2026-10-02 02:39:13	USED	keep — in use
host_726.schedule.WarehouseArchive.IX_CustomerHistory	2	NONCLUSTERED				80	0	0	7788385	2026-09-14 10:55:41	2026-10-02 23:46:49	USED	keep — in use
host_726.schedule.WarehouseArchive.IX_OrdersHeader	3	NONCLUSTERED				3979960	53	0	7788385	2026-10-03 00:03:34	2026-10-02 23:46:49	USED	keep — in use
host_726.schedule.WarehouseArchive.PK_RouteAudit	1	CLUSTERED	Y	Y		13686315	3979999	83	13686350	2026-10-03 00:03:34	2026-10-02 15:03:56	USED	KEEP — primary key
host_726.schedule.LedgerMonthly.IX_CustomerMonthly	3	NONCLUSTERED				3979960	49	0	133020866	2026-10-03 00:03:34	never	USED	keep — in use
host_726.schedule.LedgerMonthly.PK_ClaimLine	1	CLUSTERED	Y	Y		199531183	49	0	199531261	2026-10-03 00:03:34	2026-10-02 15:03:56	USED	KEEP — primary key
host_726.schedule.RouteAudit.IX_InvoiceHeader	2	NONCLUSTERED				4	0	0	3979935	2026-09-12 07:28:31	2026-10-02 17:29:57	USED	keep — in use
host_726.schedule.RouteAudit.IX_SettlementDetail	3	NONCLUSTERED			Y	0	3	0	3894154	2026-09-30 08:40:20	never	USED	keep — in use
host_726.schedule.RouteAudit.IX_CatalogArchive	4	NONCLUSTERED				16748	107	0	3979933	2026-10-03 00:03:22	2026-10-02 17:29:58	USED	keep — in use
host_726.schedule.RouteAudit.IX_QuotaStaging	5	NONCLUSTERED				0	100	0	3979933	2026-09-30 10:01:09	2026-10-02 17:29:58	USED	keep — in use
host_726.schedule.RouteAudit.PK_PayrollAudit	1	CLUSTERED	Y	Y		4	1209	16944	3979933	2026-10-03 00:03:22	2026-10-02 17:29:58	USED	KEEP — primary key
host_726.schedule.ShipmentHeader.PK_CampaignDetail	1	CLUSTERED	Y	Y		3087	482	0	66512951	2026-10-02 06:48:35	2026-10-02 02:40:38	USED	KEEP — primary key
host_726.schedule.SupplierEntry.PK_AssetSnapshot	1	CLUSTERED	Y	Y		30424051	6	0	0	2026-10-03 00:03:34	2026-09-27 02:48:31	USED	KEEP — primary key
host_726.schedule.TerritoryDetail.PK_ReconcileMonthly	1	CLUSTERED	Y	Y		38	2	0	76	2026-10-02 15:11:36	2026-10-02 02:40:40	USED	KEEP — primary key
host_726.schedule.StaffingEntry.PK_QuotaDetail	1	CLUSTERED	Y	Y		318863587	94	63	102	2026-10-03 00:03:34	2026-10-02 02:40:40	USED	KEEP — primary key
host_726.schedule.StaffingEntry.UQ_TicketDetail	2	NONCLUSTERED	Y			50	5	0	38	2026-10-02 13:28:48	2026-10-02 02:40:40	USED	keep — in use
host_726.schedule.StaffingEntry.UX_PayrollDaily	3	NONCLUSTERED	Y		Y	60867195	63	0	64	2026-10-03 00:03:34	2026-10-02 02:40:40	USED	keep — in use
host_726.schedule.ForecastMonthly.PK_ForecastHistory	1	CLUSTERED	Y	Y		318879490	534	69	637741203	2026-10-03 00:03:34	2026-10-02 02:40:42	USED	KEEP — primary key
host_726.schedule.CatalogEntry.PK_PolicyDetail	1	CLUSTERED	Y	Y		60867195	5	2	0	2026-10-03 00:03:34	2026-09-27 03:06:20	USED	KEEP — primary key
host_726.schedule.CatalogEntry.UQ_AssetAudit	2	NONCLUSTERED	Y			2	0	0	0	2026-10-02 15:11:35	2026-09-27 03:06:20	USED	keep — in use
host_726.schedule.ContractAudit.PK_TicketSummary	1	CLUSTERED	Y	Y		318863485	2	0	0	2026-10-03 00:03:34	2026-09-27 03:06:20	USED	KEEP — primary key
host_726.schedule.ContractAudit.UQ_OrdersStaging	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 03:06:20	UNUSED	review carefully — unique
host_726.schedule.ContractAudit.UX_BillingSnapshot	3	NONCLUSTERED	Y		Y	60867195	0	0	0	2026-10-03 00:03:34	2026-09-27 03:06:20	USED	keep — in use
host_726.schedule.SupplierSummary.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	51	16	15	2026-10-02 15:11:35	2026-10-01 02:29:44	USED	KEEP — primary key
host_726.schedule.SupplierSummary.UQ_BillingStaging	2	NONCLUSTERED	Y			16	0	0	14	2026-09-30 08:30:16	2026-10-01 02:29:44	USED	keep — in use
host_726.schedule.PayrollDaily.PK_CustomerQueue	1	CLUSTERED	Y	Y		44017777	817108	0	10	2026-10-03 00:03:32	2026-10-01 02:29:44	USED	KEEP — primary key
host_726.schedule.WarehouseDaily.PK_QuotaAudit	1	CLUSTERED	Y	Y		50	10	8	18	2026-10-02 15:11:36	2026-10-01 02:29:44	USED	KEEP — primary key
host_726.schedule.WarehouseDaily.UQ_ShiftEntry	2	NONCLUSTERED	Y			24	5	0	6	2026-09-30 10:00:26	2026-10-01 02:29:44	USED	keep — in use
host_726.schedule.WarehouseDaily.UX_TerritorySummary	3	NONCLUSTERED	Y		Y	46	0	0	12	2026-10-02 15:11:35	2026-10-01 02:29:44	USED	keep — in use
host_726.schedule.sql.IX_PayrollEntry	3	NONCLUSTERED			Y	60867194	64	0	361	2026-10-03 00:03:34	2026-10-01 02:29:44	USED	keep — in use
host_726.schedule.sql.PK_ContractMonthly	1	CLUSTERED	Y	Y		938	49	529	361	2026-10-02 15:18:57	2026-10-01 02:29:44	USED	KEEP — primary key
host_726.schedule.sql.UQ_SalesStatus	2	NONCLUSTERED	Y			952	247	0	7	2026-10-02 13:29:45	2026-10-01 02:29:44	USED	keep — in use
host_726.schedule.LedgerStatus.PK_SettlementQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:20	UNUSED	KEEP — primary key
host_726.schedule.LedgerStatus.UQ_QuotaAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 03:06:20	UNUSED	review carefully — unique
host_726.schedule.OrdersQueue.PK_QuotaQueue	1	CLUSTERED	Y	Y		38	2	0	76	2026-10-02 15:11:36	2026-10-02 02:40:50	USED	KEEP — primary key
host_726.schedule.LedgerStaging.IX_StaffingLog	3	NONCLUSTERED				60868208	86	0	1163	2026-10-03 00:03:34	2026-10-02 02:40:50	USED	keep — in use
host_726.schedule.LedgerStaging.PK_ContractQueue	1	CLUSTERED	Y	Y		318864655	97	60867420	1163	2026-10-03 00:03:34	2026-10-02 02:40:50	USED	KEEP — primary key
host_726.schedule.LedgerStaging.UQ_TicketResult	2	NONCLUSTERED	Y			558	46	0	361	2026-10-02 13:29:45	2026-10-02 02:40:50	USED	keep — in use
host_726.schedule.LedgerStaging.UX_QuotaHeader	4	NONCLUSTERED	Y		Y	0	0	0	802	never	2026-10-02 02:40:50	UNUSED	review carefully — unique
host_726.schedule.step.PK_AssetStaging	1	CLUSTERED	Y	Y		64761417	8	2	0	2026-10-03 00:03:34	2026-09-27 03:06:22	USED	KEEP — primary key
host_726.schedule.step.UQ_AssetQueue	3	NONCLUSTERED	Y			2	0	0	0	2026-10-02 15:11:35	2026-09-27 03:06:22	USED	keep — in use
host_726.schedule.step.UQ_OrdersLine	2	NONCLUSTERED	Y			0	1	0	0	2026-09-11 20:30:27	2026-09-27 03:06:22	USED	keep — in use
host_726.schedule.ShipmentResult.PK_MeterSnapshot	1	CLUSTERED	Y	Y		38	2	0	76	2026-10-02 15:11:36	2026-10-02 02:40:51	USED	KEEP — primary key
host_726.schedule.WarehouseEntry.PK_SettlementLine	1	CLUSTERED	Y	Y		318863562	60867283	0	0	2026-10-03 00:03:34	2026-09-27 03:06:22	USED	KEEP — primary key
host_726.schedule.WarehouseEntry.UQ_ShiftSnapshot	2	NONCLUSTERED	Y			0	0	0	0	never	2026-09-27 03:06:22	UNUSED	review carefully — unique
host_726.schedule.WarehouseEntry.UX_OrdersLog	3	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-09-27 03:06:22	COLD	review carefully — unique
host_726.wps.ContractStatus.IX_RosterDaily	3	NONCLUSTERED				30	0	0	37915	2026-09-30 08:03:26	2026-09-30 02:26:50	USED	keep — in use
host_726.wps.ContractStatus.PK_ClaimLog	1	CLUSTERED	Y	Y		3	37908	45	37915	2026-10-03 00:03:29	2026-09-30 02:26:50	USED	KEEP — primary key
host_726.wps.ContractStatus.UX_TerritoryResult	2	NONCLUSTERED	Y		Y	0	0	0	7	never	2026-09-30 02:26:50	UNUSED	review carefully — unique
host_726.wps.ContractStatus.UX_SettlementDetail	4	NONCLUSTERED	Y			15	0	0	7	2026-09-29 15:35:25	2026-09-30 02:26:50	USED	keep — in use
host_726.wps.PolicyResult.IX_ContractSnapshot	2	NONCLUSTERED				0	0	0	21	never	2026-09-30 02:26:50	UNUSED	review, then DROP
host_726.wps.PolicyResult.PK_SettlementLine	1	CLUSTERED	Y	Y		340	2424	0	21	2026-10-02 23:19:55	2026-09-30 02:26:50	USED	KEEP — primary key
host_726.wps.LedgerMonthly.PK_BookingResult	1	CLUSTERED	Y	Y		0	0	0	32	never	2026-09-30 02:26:50	UNUSED	KEEP — primary key
host_726.wps.BookingStaging.PK_ClaimHistory	1	CLUSTERED	Y	Y		10	97	0	29	2026-10-02 13:14:48	2026-09-30 02:26:50	USED	KEEP — primary key
host_726.wps.SalesHeader.PK_ContractHistory	1	CLUSTERED	Y	Y		0	0	0	44	never	2026-09-30 02:26:50	UNUSED	KEEP — primary key
host_726.wps.ForecastResult.PK_QuotaLog	1	CLUSTERED	Y	Y		161	86	127489	292	2026-10-03 00:03:32	2026-10-01 02:29:46	USED	KEEP — primary key
host_726.wps.ForecastResult.UQ_ShipmentArchive	4	NONCLUSTERED	Y			131391	2	0	292	2026-10-03 00:03:32	2026-10-01 02:29:46	USED	keep — in use
host_726.wps.StaffingResult.PK_RosterStatus	1	CLUSTERED	Y	Y		4	33312	0	3	2026-10-03 00:03:00	2026-09-30 02:26:50	USED	KEEP — primary key
host_726.wps.StaffingStaging.PK_PolicyEntry	1	CLUSTERED	Y	Y		0	0	0	3	never	2026-09-30 02:26:50	UNUSED	KEEP — primary key
host_726.wps.QuotaDetail.PK_BatchQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:23	UNUSED	KEEP — primary key
host_726.wps.OrdersLog.PK_WarehouseArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-09-27 03:06:23	UNUSED	KEEP — primary key
host_726.wps.TerritoryQueue.IX_InvoiceAudit	11	NONCLUSTERED				1508	32	0	1503	2026-10-02 23:34:41	2026-10-02 02:40:52	USED	keep — in use
host_726.wps.TerritoryQueue.PK_RosterSnapshot	1	CLUSTERED	Y	Y		14	329	5187	1503	2026-10-02 23:35:57	2026-10-02 02:40:51	USED	KEEP — primary key
host_726.wps.TerritoryQueue.UX_MeterStaging	2	NONCLUSTERED	Y			403	3307	0	112	2026-10-02 23:35:57	2026-10-02 02:40:52	USED	keep — in use
host_726.wps.ContractEntry.PK_PayrollSummary	1	CLUSTERED	Y	Y		0	0	0	213	never	2026-10-02 02:40:52	UNUSED	KEEP — primary key
host_726.wps.TicketStatus.PK_InvoiceMonthly	1	CLUSTERED	Y	Y		0	8018	0	24	2026-10-02 23:34:41	2026-09-27 03:06:23	USED	KEEP — primary key
host_726.wps.SalesDetail.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	292	never	2026-10-01 02:29:46	UNUSED	KEEP — primary key
host_726.wps.ClaimResult.PK_TicketEntry	1	CLUSTERED	Y	Y		58	79	0	3	2026-10-02 21:46:16	2026-09-27 03:06:23	USED	KEEP — primary key
host_726.wps.CatalogSnapshot.PK_ForecastHeader	1	CLUSTERED	Y	Y		0	0	0	6	never	2026-09-27 03:06:23	UNUSED	KEEP — primary key
host_726.wps.BillingLine.PK_RosterResult	1	CLUSTERED	Y	Y		432	4770	0	0	2026-10-02 22:15:29	2026-09-27 03:06:23	USED	KEEP — primary key
host_726.wps.BillingLine.UX_WarehouseLog	2	NONCLUSTERED	Y		Y	4	0	0	0	2026-09-28 20:13:47	2026-09-27 03:06:23	USED	keep — in use
host_726.wps.BatchStatus.PK_ClaimLine	1	CLUSTERED	Y	Y		0	2999	3495	1	2026-10-02 23:34:41	2026-09-29 02:24:29	USED	KEEP — primary key
host_726.wps.BatchStatus.UQ_CustomerHeader	2	NONCLUSTERED	Y			3495	0	0	1	2026-10-02 23:34:41	2026-09-29 02:24:29	USED	keep — in use
host_726.wps.BookingResult.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-09-29 02:24:29	UNUSED	KEEP — primary key
host_726.wps.BookingStaging.PK_ForecastLog	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-09-29 02:24:29	UNUSED	KEEP — primary key
ASSET_Prod.dbo.PricingHeader.IX_StaffingHeader	3	NONCLUSTERED				0	0	0	373	never	2026-08-24 12:48:18	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_QuotaAudit	4	NONCLUSTERED				0	0	0	373	never	2026-08-24 12:48:18	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y		81269	13344	1	1068	2026-10-02 18:38:55	2026-08-24 12:50:52	USED	KEEP — primary key
ASSET_Prod.dbo.PricingHeader.UX_QuotaMonthly	2	NONCLUSTERED	Y			1	0	0	373	2026-09-28 08:54:27	2026-08-24 12:48:18	USED	keep — in use
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	5194	0	0	2026-10-02 16:45:14	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	37	0	0	2026-10-02 14:38:08	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	163	0	8	2026-10-02 10:28:16	never	USED	KEEP — primary key
ASSET_Prod.dbo.SalesEntry.PK_BookingAudit	1	CLUSTERED	Y	Y		0	0	33	0	2026-09-30 07:52:38	never	USED	KEEP — primary key
ASSET_Prod.dbo.SalesEntry.UX_ShiftSnapshot	2	NONCLUSTERED	Y			33	0	0	0	2026-09-30 07:52:38	2026-07-29 08:09:18	USED	keep — in use
ASSET_Prod.dbo.RosterDaily.IX_RouteLine	2	NONCLUSTERED				31	0	0	0	2026-10-02 14:38:08	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	32	0	0	2026-10-02 14:38:08	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	24	0	0	2026-09-26 08:28:39	never	USED	KEEP — primary key
ASSET_Prod.dbo.BookingEntry.IX_ShipmentStatus	2	NONCLUSTERED				0	0	0	1068	never	2026-09-17 15:19:39	UNUSED	review, then DROP
ASSET_Prod.dbo.BookingEntry.PK_SettlementQueue	1	CLUSTERED	Y	Y		0	3409	0	1068	2026-10-02 16:45:14	never	USED	KEEP — primary key
ASSET_Prod.dbo.ReconcileMonthly.IX_ForecastDetail	2	NONCLUSTERED				0	0	0	8	never	2026-07-29 08:14:24	UNUSED	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_QuotaSummary	9	NONCLUSTERED			Y	0	0	0	8	never	2026-07-29 08:51:33	UNUSED	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.PK_SettlementDetail	1	CLUSTERED	Y	Y		0	58489	0	8	2026-10-02 18:38:52	2026-07-29 09:58:28	USED	KEEP — primary key
ASSET_Prod.dbo.ReconcileMonthly.UX_CustomerDetail	3	NONCLUSTERED	Y		Y	0	0	0	8	never	2026-07-29 08:15:18	UNUSED	review carefully — unique
ASSET_Prod.dbo.CampaignHeader.IX_SupplierResult	2	NONCLUSTERED				0	0	0	1029	never	2026-09-26 10:35:37	UNUSED	review, then DROP
ASSET_Prod.dbo.CampaignHeader.PK_ShiftHeader	1	CLUSTERED	Y	Y		76	75156	0	1103	2026-10-02 18:38:44	2026-09-26 16:05:34	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	4	0	0	2026-09-26 15:10: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	4	0	0	2026-09-26 15:10: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		1	5016	0	0	2026-10-02 18:38:52	2026-07-29 08:16:57	USED	KEEP — primary key
ASSET_Prod.dbo.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	2236	0	0	2026-10-02 15:31:52	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	5	0	0	2026-09-26 15:10:08	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				1731	0	0	0	2026-10-02 18:38:42	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	6728	0	2026-10-02 18:38:43	2026-07-31 11:16:08	USED	KEEP — primary key
ASSET_Prod.dbo.SalesSnapshot.UX_ShiftResult	2	NONCLUSTERED	Y			6728	0	0	0	2026-10-02 18:38:43	2026-07-29 11:14:33	USED	keep — in use
ASSET_Prod.dbo.RouteHistory.PK_BillingArchive	1	CLUSTERED	Y	Y		1265	293	0	0	2026-10-02 18:38:42	2026-07-29 08:07:17	USED	KEEP — primary key