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

Host: 198.51.100.66

Collected: 2026-10-11T18:01:55Z

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

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

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

Metric	Count	Meaning
indexes_total	676	every index on a user table
used	435	had a seek, scan or lookup
unused	142	written but never read
cold	99	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	42	nonclustered, not unique, no constraint, never read
fragmented	10	above the rebuild threshold

By database

Database	Total	Cold	Droppable	Recommend action
ASSET_Prod	55	26	26	review the drop candidates above
host_726	576	63	16	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 (42)

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.SupplierStaging.IX_StaffingEntry	50198	never	UNUSED	review, then DROP
host_726.emp.SalesHeader.IX_BookingSummary	17612	never	UNUSED	review, then DROP
host_726.org.SupplierHistory.IX_ShipmentSummary	2640	never	UNUSED	review, then DROP
ASSET_Prod.dbo.CampaignHeader.IX_SupplierResult	1485	never	UNUSED	review, then DROP
ASSET_Prod.dbo.BookingEntry.IX_ShipmentStatus	1362	never	UNUSED	review, then DROP
host_726.emp.OrdersMonthly.IX_QuotaArchive	818	never	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_StaffingHeader	481	never	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_QuotaAudit	481	never	UNUSED	review, then DROP
host_726.org.BillingHeader.IX_ShiftHistory	346	never	UNUSED	review, then DROP
host_726.org.ShipmentSummary.IX_StaffingResult	234	never	UNUSED	review, then DROP
host_726.wps.PolicyResult.IX_ContractSnapshot	21	never	UNUSED	review, then DROP
host_726.org.InvoiceStaging.IX_AssetAudit	16	never	UNUSED	review, then DROP
host_726.org.RosterMonthly.IX_AssetDetail	16	never	UNUSED	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_QuotaSummary	9	never	UNUSED	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_ForecastDetail	9	never	UNUSED	review, then DROP
host_726.dbo.BatchResult.IX_SettlementStaging	0	never	COLD	review, then DROP
host_726.dbo.SalesLine.IX_ReconcileResult	0	never	COLD	review, then DROP
host_726.schedule.InvoiceHistory.IX_StaffingHeader	0	never	UNUSED	review, then DROP
host_726.oth.StaffingArchive.IX_InvoiceStaging	0	never	UNUSED	review, then DROP
host_726.guest.TerritoryQueue.IX_InvoiceStaging	0	never	UNUSED	review, then DROP
host_726.dbo.CustomerArchive.IX_BillingHeader	0	never	UNUSED	review, then DROP
host_726.dbo.BatchResult.IX_ReconcileEntry	0	never	UNUSED	review, then DROP
ASSET_Prod.dbo.SalesSnapshot.IX_TicketResult	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RosterSummary.IX_ForecastSnapshot	0	never	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_CatalogLog	0	never	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_ShiftDaily	0	never	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_StaffingLine	0	never	COLD	review, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_ClaimHistory	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ForecastDetail.IX_CampaignStatus	0	never	COLD	review, then DROP
ASSET_Prod.dbo.BatchLog.IX_LedgerHistory	0	never	COLD	review, then DROP
ASSET_Prod.dbo.BatchLog.IX_TerritoryArchive	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RosterStaging.IX_BatchArchive	0	never	COLD	review, then DROP
ASSET_Prod.dbo.BookingSnapshot.IX_ClaimStaging	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ShipmentLog.IX_ReconcileStatus	0	never	COLD	review, then DROP
ASSET_Prod.dbo.DOB.IX_CustomerSummary	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ContractStaging.IX_InvoiceLog	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RosterHeader.IX_ShipmentLog	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RosterDaily.IX_ShiftHeader	0	never	COLD	review, then DROP
ASSET_Prod.dbo.BookingSnapshot.IX_RouteLine	0	never	COLD	review, then DROP
ASSET_Prod.dbo.AssetEntry.IX_TerritoryDetail	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RouteArchive.IX_ShiftDaily	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RouteSnapshot.IX_ContractHeader	0	never	COLD	review, then DROP

Fragmented (10)

Total 950.3 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.BillingDetail.IX_TicketHeader#p6	6/21	NONCLUSTERED	96.0%	1,001	7.8	2026-10-12 00:41:34	REBUILD
host_726.schedule.RouteAudit.IX_InvoiceHeader	1/1	NONCLUSTERED	75.6%	96,745	755.8	2026-10-11 02:32:10	REBUILD
host_726.schedule.SettlementLog.IX_TicketLine#p3	3/21	NONCLUSTERED	71.2%	1,214	9.5	2026-10-12 00:41:48	REBUILD
host_726.emp.BillingAudit.IX_PolicyHeader	1/1	NONCLUSTERED	69.6%	9,568	74.8	2026-10-11 22:34:51	REBUILD
host_726.schedule.SettlementLog.IX_PolicyLine#p5	5/21	NONCLUSTERED	58.5%	1,025	8.0	2026-10-12 00:41:48	REORGANIZE
host_726.schedule.RosterResult.IX_AssetStaging#p3	3/21	NONCLUSTERED	44.5%	1,054	8.2	2026-10-12 00:41:26	REORGANIZE
host_726.schedule.MeterStaging.PK_PolicyArchive#p10	10/21	CLUSTERED	42.8%	1,326	10.4	2026-10-12 00:35:18	REORGANIZE
host_726.schedule.PolicyLine.UX_TerritoryHistory#p10	10/21	NONCLUSTERED	42.0%	1,709	13.4	2026-10-12 00:37:49	REORGANIZE
host_726.schedule.InvoiceAudit.PK_LedgerMonthly#p10	10/21	CLUSTERED	38.7%	4,256	33.3	2026-10-12 00:38:26	REORGANIZE
host_726.schedule.SettlementLog.PK_CatalogMonthly#p3	3/21	CLUSTERED	30.1%	3,729	29.1	2026-10-12 00:41:47	REORGANIZE

All indexes (676)

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		13270332	5167	3188931	14800	2026-10-12 01:01:54	2026-10-11 02:00:01	USED	KEEP — primary key
host-877.app.Account.UX_PayrollAudit	2	NONCLUSTERED	Y			5888915	97	0	12930	2026-10-12 01:01:52	2026-10-11 02:00:01	USED	keep — in use
host-877.app.Account.UX_ContractSummary	7	NONCLUSTERED	Y		Y	1860	0	0	1860	2026-10-10 16:27:51	2026-10-11 02:00:01	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	10735	never	2026-10-11 02:00:01	UNUSED	KEEP — primary key
host-877.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	241911	never	2026-10-11 02:31:10	UNUSED	KEEP — primary key
host-877.app.ForecastMonthly.IX_StaffingStatus	1	CLUSTERED				0	0	0	12877	never	2026-10-11 02:00:02	UNUSED	KEEP — table storage
host-877.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		2	418817	0	0	2026-10-12 00:56:10	2026-10-11 02:00:02	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		1108361	106350	0	48	2026-10-12 01:01:52	2026-10-11 02:00:02	USED	KEEP — primary key
host-877.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	44	never	2026-10-11 02:00:02	UNUSED	KEEP — primary key
host-877.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		627565	698	0	31	2026-10-12 01:00:10	2026-10-11 02:00:02	USED	KEEP — primary key
host-877.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			1	1	0	31	2026-09-18 12:25:08	2026-10-11 02:00:02	USED	keep — in use
host-877.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y		86132	0	0	116	2026-10-11 23:52:34	2026-10-11 02:00:02	USED	KEEP — primary key
host-877.app.BatchQueue.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	33945	0	0	2026-10-11 23:52:34	never	USED	KEEP — primary key
host-877.app.WarehouseStatus.IX_BookingEntry	9	NONCLUSTERED				0	1	0	16	2026-09-18 10:15:38	2026-10-11 02:00:02	USED	keep — in use
host-877.app.WarehouseStatus.UX_QuotaLine	2	NONCLUSTERED	Y			30926	151961	0	16	2026-10-11 23:49:07	2026-10-11 02:00:02	USED	keep — in use
host-877.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		912898	1	0	453	2026-10-12 01:01:52	2026-10-11 02:00:02	USED	KEEP — primary key
host-877.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	391	never	2026-10-11 02:00:02	UNUSED	KEEP — primary key
host-877.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		545909	2887406	0	6	2026-10-12 01:01:52	2026-10-11 02:00:02	USED	KEEP — primary key
host-877.app.Permission.PK_ClaimHeader	1	CLUSTERED	Y	Y		480846	863934	0	4	2026-10-12 01:01:52	2026-10-11 02:00:02	USED	KEEP — primary key
host-877.app.Permission.UX_RouteQueue	2	NONCLUSTERED	Y			34408	5	0	3	2026-10-11 23:52:34	2026-10-11 02:00:02	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-10-11 02:31:09	UNUSED	KEEP — primary key
host-871.app.Account.UX_PayrollAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:31:09	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-10-11 02:31:09	UNUSED	KEEP — primary key
host-871.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:09	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-10-11 02:31:09	UNUSED	KEEP — primary key
host-871.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:09	UNUSED	KEEP — primary key
host-871.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:09	UNUSED	KEEP — primary key
host-871.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:31:09	UNUSED	review carefully — unique
host-871.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:09	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-10-11 02:31:09	UNUSED	review carefully — unique
host-871.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:09	UNUSED	KEEP — primary key
host-871.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:09	UNUSED	KEEP — primary key
host-871.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:09	UNUSED	KEEP — primary key
host-871.app.Permission.PK_ClaimHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:09	UNUSED	KEEP — primary key
host-871.app.Permission.UX_RouteQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:31:09	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-10-11 02:00:03	USED	KEEP — primary key
host_726.cfg.QuotaStatus.UX_MeterSummary	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:31	2026-10-11 02:00:03	USED	keep — in use
host_726.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		0	4160	0	4154	2026-10-12 00:35:10	2026-10-11 02:00:03	USED	KEEP — primary key
host_726.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	4154	never	2026-10-11 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.Jobs.PK_RosterStatus	1	CLUSTERED	Y	Y		1	2	0	0	2026-10-07 08:54:34	2026-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.Jobs.UQ_ContractMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 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				1	1	0	0	2026-10-07 08:54:34	2026-10-11 02:00:04	USED	keep — in use
host_726.dbo.OrdersSnapshot.PK_PolicyLine	1	CLUSTERED	Y	Y		0	4	1	0	2026-10-07 08:54:34	2026-10-11 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-10-11 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.CustomerSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		0	1	0	0	2026-10-07 08:54:34	2026-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.QuotaResult.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 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-10-11 02:00:04	COLD	review, then DROP
host_726.dbo.BatchResult.IX_ReconcileEntry	3	NONCLUSTERED				0	0	0	0	never	2026-10-11 02:00:04	UNUSED	review, then DROP
host_726.dbo.BatchResult.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 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-10-11 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.ClaimArchive.UQ_SupplierResult	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:00:04	UNUSED	review carefully — unique
host_726.dbo.CustomerArchive.IX_BillingHeader	3	NONCLUSTERED				0	0	0	0	never	2026-10-11 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-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.CustomerArchive.UQ_OrdersMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 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-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.Status.UQ_PricingHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 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-10-11 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.BookingStatus.UQ_CatalogSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:00:04	UNUSED	review carefully — unique
host_726.dbo.BookingStatus.UQ_ContractEntry	3	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:00:04	UNUSED	review carefully — unique
host_726.dbo.BookingStatus.UQ_RouteLine	4	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:00:04	UNUSED	review carefully — unique
host_726.dbo.BillingHistory.PK_PayrollHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.TicketQueue.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 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		2839408	3203	0	0	2026-10-12 01:01:52	2026-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.WarehouseEntry.UX_CampaignHeader	2	NONCLUSTERED	Y			0	3	0	0	2026-09-19 15:40:54	2026-10-11 02:00:04	USED	keep — in use
host_726.dbo.TicketSummary.PK_SalesLine	1	CLUSTERED				0	17854	0	0	2026-10-11 23:41:19	2026-10-11 02:00:04	USED	KEEP — table storage
host_726.dbo.TerritoryEntry.PK_SalesSummary	1	CLUSTERED	Y	Y		1840359	1219	0	0	2026-10-12 01:01:52	2026-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.TerritoryEntry.UX_TerritoryQueue	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:20	2026-10-11 02:00:04	USED	keep — in use
host_726.dbo.PolicyEntry.PK_TicketEntry	1	CLUSTERED	Y	Y		889892	3253	0	0	2026-10-12 01:01:52	2026-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.PolicyEntry.UX_PolicyAudit	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:25	2026-10-11 02:00:04	USED	keep — in use
host_726.dbo.CampaignHeader.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y		1035090	3530	0	0	2026-10-12 01:01:52	2026-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.CampaignHeader.UX_BillingLog	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:30	2026-10-11 02:00:04	USED	keep — in use
host_726.dbo.WarehouseHeader.PK_OrdersQueue	1	CLUSTERED	Y	Y		0	1896	0	0	2026-10-11 22:30:21	2026-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.WarehouseHeader.UX_TicketQueue	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:26	2026-10-11 02:00:04	USED	keep — in use
host_726.dbo.RouteQueue.PK_SupplierAudit	1	CLUSTERED	Y	Y		1877359	1277	0	0	2026-10-12 01:01:52	2026-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.RouteQueue.UX_CampaignQueue	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:19	2026-10-11 02:00:04	USED	keep — in use
host_726.dbo.CampaignAudit.PK_BatchSnapshot	1	CLUSTERED	Y	Y		889572	3281	0	0	2026-10-12 01:01:52	2026-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.CampaignAudit.UX_SupplierArchive	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:28	2026-10-11 02:00:04	USED	keep — in use
host_726.dbo.ShiftDaily.PK_ReconcileStatus	1	CLUSTERED	Y	Y		1880081	1211	0	0	2026-10-12 01:01:52	2026-10-11 02:00:04	USED	KEEP — primary key
host_726.dbo.ShiftDaily.UX_RouteDaily	2	NONCLUSTERED	Y			0	2	0	0	2026-09-18 10:21:23	2026-10-11 02:00:04	USED	keep — in use
host_726.dbs.ShipmentStatus.UX_StaffingLog	8	NONCLUSTERED	Y		Y	34	0	0	36	2026-10-11 20:00:01	2026-10-11 02:00:05	USED	keep — in use
host_726.emp.WarehouseMonthly.PK_PricingHistory	1	CLUSTERED	Y	Y		21502	29421	0	7	2026-10-11 23:59:11	2026-10-11 02:00:05	USED	KEEP — primary key
host_726.emp.WarehouseMonthly.UX_CustomerDetail	2	NONCLUSTERED	Y		Y	0	0	0	7	never	2026-10-11 02:00:05	UNUSED	review carefully — unique
host_726.emp.SettlementLine.PK_LedgerAudit	1	CLUSTERED	Y	Y		0	0	0	5	never	2026-10-11 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-10-11 02:00:05	USED	KEEP — primary key
host_726.emp.BatchMonthly.PK_TicketAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:00:05	UNUSED	KEEP — primary key
host_726.emp.RosterLog.PK_QuotaLog	1	CLUSTERED	Y	Y		420676	0	0	210338	2026-10-12 00:29:08	2026-10-11 02:00:05	USED	KEEP — primary key
host_726.emp.QuotaMonthly.IX_ShipmentEntry	2	NONCLUSTERED				1052009	1	0	2388	2026-10-12 01:01:52	2026-10-11 02:00:05	USED	keep — in use
host_726.emp.QuotaMonthly.PK_ReconcileDetail	1	CLUSTERED	Y	Y		2422	600	1052008	2472	2026-10-12 01:01:52	2026-10-11 02:00:05	USED	KEEP — primary key
host_726.emp.OrdersEntry.PK_PolicyHeader	1	CLUSTERED	Y	Y		0	0	0	2292	never	2026-10-11 02:00:06	UNUSED	KEEP — primary key
host_726.emp.PayrollSummary.PK_RouteSummary	1	CLUSTERED	Y	Y		20467	101	0	20445	2026-10-06 15:03:27	2026-10-11 02:00:07	USED	KEEP — primary key
host_726.emp.SettlementAudit.PK_ShiftStatus	1	CLUSTERED	Y	Y		0	0	0	20445	never	2026-10-11 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		604	1158	0	0	2026-10-12 00:00:00	2026-10-11 02:00:07	USED	KEEP — primary key
host_726.emp.RouteHistory.UX_CustomerQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:00:07	UNUSED	review carefully — unique
host_726.emp.CustomerHistory.PK_ShiftDaily	1	CLUSTERED	Y	Y		220	0	0	2	2026-10-11 22:04:52	2026-10-11 02:00:11	USED	KEEP — primary key
host_726.emp.ForecastEntry.PK_SettlementLog	1	CLUSTERED	Y	Y		12	1089574	0	47	2026-10-12 00:51:56	2026-10-11 02:00:11	USED	KEEP — primary key
host_726.emp.ClaimQueue.PK_TerritoryResult	1	CLUSTERED	Y	Y		0	0	0	55	never	2026-10-11 02:00:11	UNUSED	KEEP — primary key
host_726.emp.PolicyAudit.PK_ContractAudit	1	CLUSTERED	Y	Y		54	1867698	0	42	2026-10-12 01:01:04	2026-10-11 02:00:11	USED	KEEP — primary key
host_726.emp.ShipmentSummary.PK_ShiftAudit	1	CLUSTERED	Y	Y		0	9	0	53	2026-10-07 17:24:36	2026-10-11 02:00:12	USED	KEEP — primary key
host_726.emp.BatchArchive.PK_ClaimHistory	1	CLUSTERED	Y	Y		779541	1088888	0	34	2026-10-12 01:01:04	2026-10-11 02:00:12	USED	KEEP — primary key
host_726.emp.RosterSnapshot.PK_PolicyStaging	1	CLUSTERED	Y	Y		0	0	0	34	never	2026-10-11 02:00:12	UNUSED	KEEP — primary key
host_726.emp.MeterResult.IX_LedgerQueue	2	NONCLUSTERED				9	639043	0	5549	2026-10-12 00:55:39	2026-10-11 02:00:12	USED	keep — in use
host_726.emp.MeterResult.PK_CustomerResult	1	CLUSTERED	Y	Y		9297661	243360	10	5549	2026-10-12 01:01:54	2026-10-11 02:00:12	USED	KEEP — primary key
host_726.emp.PayrollHeader.PK_TicketHistory	1	CLUSTERED	Y	Y		890935	361	0	1409	2026-10-12 01:01:52	2026-10-11 02:00:12	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	336	0	0	2026-10-12 00:00:01	2026-10-11 02:00:12	USED	KEEP — primary key
host_726.emp.RouteHeader.PK_StaffingQueue	1	CLUSTERED	Y	Y		0	1	0	0	2026-10-07 11:06:12	2026-10-11 02:00:12	USED	KEEP — primary key
host_726.emp.MeterAudit.PK_ClaimLog	1	CLUSTERED	Y	Y		7635	491097	0	7638	2026-10-11 23:59:11	2026-10-11 02:00:12	USED	KEEP — primary key
host_726.emp.QuotaStatus.PK_OrdersArchive	1	CLUSTERED	Y	Y		0	0	0	80	never	2026-10-11 02:00:12	UNUSED	KEEP — primary key
host_726.emp.ShiftLine.IX_PricingAudit	3	NONCLUSTERED				4754	0	0	705	2026-10-11 23:48:17	2026-10-11 02:00:13	USED	keep — in use
host_726.emp.ShiftLine.PK_SettlementStatus	1	CLUSTERED	Y	Y		186	559	4754	776	2026-10-12 00:00:00	2026-10-11 02:00:13	USED	KEEP — primary key
host_726.emp.ShiftLine.UX_BookingDaily	2	NONCLUSTERED	Y			0	0	0	705	never	2026-10-11 02:00:13	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	1	0	776	2026-10-07 11:06:12	2026-10-11 02:00:13	USED	KEEP — primary key
host_726.emp.ForecastHeader.IX_WarehouseResult	2	NONCLUSTERED				19396	1	0	1623	2026-10-11 23:41:19	2026-10-11 02:00:13	USED	keep — in use
host_726.emp.ForecastHeader.PK_OrdersAudit	1	CLUSTERED	Y	Y		17	335	19396	1623	2026-10-11 23:41:19	2026-10-11 02:00:13	USED	KEEP — primary key
host_726.emp.SalesLog.PK_AssetStaging	1	CLUSTERED	Y	Y		0	0	0	1606	never	2026-10-11 02:00:13	UNUSED	KEEP — primary key
host_726.emp.AssetDaily.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	36307	0	0	2026-10-11 23:48:17	2026-10-11 02:00:13	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				1159	1	0	340	2026-10-11 23:41:19	2026-10-11 02:00:13	USED	keep — in use
host_726.emp.PricingDaily.PK_RouteEntry	1	CLUSTERED	Y	Y		15	18466	1159	340	2026-10-11 23:41:19	2026-10-11 02:00:13	USED	KEEP — primary key
host_726.emp.PolicyLog.PK_LedgerHistory	1	CLUSTERED	Y	Y		1377	399	889861	1389	2026-10-12 01:01:52	2026-10-11 02:00:13	USED	KEEP — primary key
host_726.emp.PolicyLog.UX_OrdersSnapshot	2	NONCLUSTERED	Y			889894	38	0	1389	2026-10-12 01:01:52	2026-10-11 02:00:13	USED	keep — in use
host_726.emp.RouteAudit.PK_ClaimResult	1	CLUSTERED	Y	Y		0	0	0	74	never	2026-10-11 02:00:14	UNUSED	KEEP — primary key
host_726.emp.PayrollDaily.IX_BillingStaging	2	NONCLUSTERED				118	0	0	612	2026-10-10 15:57:18	2026-10-11 02:00:14	USED	keep — in use
host_726.emp.PayrollDaily.PK_OrdersSnapshot	1	CLUSTERED	Y	Y		0	118	0	612	2026-10-10 15:57:18	2026-10-11 02:00:14	USED	KEEP — primary key
host_726.emp.MeterHistory.IX_ContractArchive	17	NONCLUSTERED				18370	80472	0	1587	2026-10-12 00:41:24	2026-10-11 02:00:14	USED	keep — in use
host_726.emp.MeterHistory.PK_BatchLog	1	CLUSTERED	Y	Y		22980781	372841	8547861	30990	2026-10-12 01:01:54	2026-10-11 02:00:14	USED	KEEP — primary key
host_726.emp.MeterHistory.UX_BatchLog	2	NONCLUSTERED	Y		Y	0	0	0	29823	never	2026-10-11 02:00:14	UNUSED	review carefully — unique
host_726.emp.MeterHistory.UX_ForecastHeader	20	NONCLUSTERED	Y			1823034	5718	0	1587	2026-10-12 01:01:52	2026-10-11 02:00:14	USED	keep — in use
host_726.emp.MeterHistory.UX_CustomerSnapshot	3	NONCLUSTERED	Y		Y	211	338	0	29823	2026-10-11 21:52:09	2026-10-11 02:00:14	USED	keep — in use
host_726.emp.MeterHistory.UX_QuotaStaging	4	NONCLUSTERED	Y			10759581	80	0	1587	2026-10-12 01:01:54	2026-10-11 02:00:14	USED	keep — in use
host_726.emp.ShiftSnapshot.IX_ForecastAudit	1	CLUSTERED				0	1	0	30981	2026-10-07 11:06:12	2026-10-11 02:00:15	USED	KEEP — table storage
host_726.emp.TerritoryLine.PK_LedgerArchive	1	CLUSTERED	Y	Y		211722	67099	0	73659	2026-10-12 00:10:57	2026-10-11 02:00:16	USED	KEEP — primary key
host_726.emp.SalesStaging.PK_PolicyDaily	1	CLUSTERED	Y	Y		28599	804	0	7274	2026-10-12 00:09:43	2026-10-11 02:00:16	USED	KEEP — primary key
host_726.emp.TerritoryDaily.PK_MeterLog	1	CLUSTERED	Y	Y		0	1	0	2800	2026-10-07 11:06:13	2026-10-11 02:00:17	USED	KEEP — primary key
host_726.emp.SettlementQueue.IX_PolicyAudit	2	NONCLUSTERED				1	0	0	73314	2026-10-07 11:06:13	2026-10-11 02:31:12	USED	keep — in use
host_726.emp.SettlementQueue.PK_SalesEntry	1	CLUSTERED	Y	Y		0	332	0	73314	2026-10-11 22:26:09	2026-10-11 02:31:12	USED	KEEP — primary key
host_726.emp.StaffingMonthly.IX_ReconcileEntry	2	NONCLUSTERED				0	1	0	0	2026-10-07 11:06:13	2026-10-11 02:00:18	USED	keep — in use
host_726.emp.StaffingMonthly.IX_SalesQueue	3	NONCLUSTERED				63857	1	0	0	2026-10-11 23:48:28	2026-10-11 02:00:18	USED	keep — in use
host_726.emp.StaffingMonthly.PK_CampaignStatus	1	CLUSTERED	Y	Y		3	53783	24491	0	2026-10-11 23:49:08	2026-10-11 02:00:18	USED	KEEP — primary key
host_726.emp.TicketQueue.PK_BatchDaily	1	CLUSTERED	Y	Y		0	107	19493	2360	2026-10-11 23:41:19	2026-10-11 02:00:18	USED	KEEP — primary key
host_726.emp.TicketQueue.UX_PayrollDaily	2	NONCLUSTERED	Y			19494	2	0	2360	2026-10-11 23:41:19	2026-10-11 02:00:18	USED	keep — in use
host_726.emp.MeterStatus.PK_CustomerDetail	1	CLUSTERED	Y	Y		0	1	0	2360	2026-10-07 11:06:13	2026-10-11 02:00:18	USED	KEEP — primary key
host_726.emp.OrdersEntry.PK_TerritoryAudit	1	CLUSTERED	Y	Y		0	21461	0	0	2026-10-11 23:41:19	2026-10-11 02:00:18	USED	KEEP — primary key
host_726.emp.InvoiceLog.PK_BillingDetail	1	CLUSTERED	Y	Y		0	39	0	1581	2026-10-11 10:28:43	2026-10-11 02:00:19	USED	KEEP — primary key
host_726.emp.CampaignHistory.IX_QuotaDetail	2	NONCLUSTERED				11131540	2	0	153	2026-10-12 01:01:55	2026-10-11 02:00:20	USED	keep — in use
host_726.emp.CampaignHistory.PK_AssetHeader	1	CLUSTERED	Y	Y		52	154787	11131540	153	2026-10-12 01:01:55	2026-10-11 02:00:20	USED	KEEP — primary key
host_726.emp.ContractArchive.PK_BookingStaging	1	CLUSTERED	Y	Y		0	2	0	0	2026-10-05 09:40:18	never	USED	KEEP — primary key
host_726.emp.RosterStaging.IX_ClaimLine	1	CLUSTERED				0	2	0	23	2026-10-07 11:06:14	2026-10-11 02:00:20	USED	KEEP — table storage
host_726.emp.TicketLine.PK_CampaignEntry	1	CLUSTERED	Y	Y		320	188	0	0	2026-10-11 22:26:09	2026-10-11 02:00:20	USED	KEEP — primary key
host_726.emp.BatchAudit.IX_PolicyArchive	20	NONCLUSTERED				1237796	357	0	6892281	2026-10-12 01:01:03	2026-10-11 02:31:13	USED	keep — in use
host_726.emp.BatchAudit.PK_ForecastSummary	1	CLUSTERED	Y	Y		7784961	27610	17071802	9462790	2026-10-12 01:01:54	2026-10-11 02:31:13	USED	KEEP — primary key
host_726.emp.BatchAudit.UX_LedgerStaging	2	NONCLUSTERED	Y			23358577	6	0	6892281	2026-10-12 01:01:54	2026-10-11 02:31:13	USED	keep — in use
host_726.emp.ClaimAudit.PK_LedgerDaily	1	CLUSTERED	Y	Y		0	1	0	74	2026-09-28 21:09:39	never	USED	KEEP — primary key
host_726.emp.ClaimAudit.UX_RouteMonthly	2	NONCLUSTERED	Y			1	73	0	74	2026-10-11 02:00:05	never	USED	keep — in use
host_726.emp.PolicyHistory.PK_OrdersDaily	1	CLUSTERED	Y	Y		5074033	1620	0	7644297	2026-10-12 00:43:02	2026-10-12 00:40:38	USED	KEEP — primary key
host_726.emp.BillingEntry.PK_StaffingAudit	1	CLUSTERED	Y	Y		1	2072	85	5073637	2026-10-12 00:09:33	2026-10-11 22:36:25	USED	KEEP — primary key
host_726.emp.BillingEntry.UX_StaffingLog	2	NONCLUSTERED	Y			2503131	29	0	5073637	2026-10-12 00:43:00	2026-10-11 22:36:25	USED	keep — in use
host_726.emp.BillingAudit.IX_PolicyHeader	8	NONCLUSTERED				414922	0	0	5073670	2026-10-12 00:42:53	2026-10-11 22:34:51	USED	keep — in use
host_726.emp.BillingAudit.PK_PolicyDetail	1	CLUSTERED	Y	Y		0	147	118	5073667	2026-10-11 22:26:07	2026-10-11 22:34:51	USED	KEEP — primary key
host_726.emp.BillingAudit.UX_SupplierSnapshot	2	NONCLUSTERED	Y			2502920	158	0	5073667	2026-10-12 00:43:00	2026-10-11 22:34:51	USED	keep — in use
host_726.emp.ShipmentStaging.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	168	0	2503058	2026-10-11 22:26:07	never	USED	KEEP — primary key
host_726.emp.ShipmentStaging.UX_RosterDaily	2	NONCLUSTERED	Y			1	2503057	0	2503058	2026-10-12 00:43:00	never	USED	keep — in use
host_726.emp.SalesLine.PK_CampaignResult	1	CLUSTERED	Y	Y		6439035	112	0	7647398	2026-10-12 01:01:54	2026-10-12 00:36:53	USED	KEEP — primary key
host_726.emp.LedgerSnapshot.PK_CampaignStatus	1	CLUSTERED	Y	Y		0	19	0	1221	2026-10-10 11:58:41	2026-10-11 02:03:30	USED	KEEP — primary key
host_726.emp.ReconcileDetail.PK_CampaignQueue	1	CLUSTERED	Y	Y		608	21311	0	692	2026-10-11 23:41:19	2026-10-11 02:03:31	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		813	2170	0	0	2026-10-11 22:30:21	2026-10-11 02:03:31	USED	KEEP — primary key
host_726.emp.ReconcileStaging.UX_OrdersHistory	2	NONCLUSTERED	Y			0	1	0	0	2026-09-19 15:40:54	2026-10-11 02:03:31	USED	keep — in use
host_726.emp.MeterStatus.PK_ReconcileMonthly	1	CLUSTERED	Y	Y		28816	3792	1506912	28804	2026-10-12 01:01:52	2026-10-11 02:03:31	USED	KEEP — primary key
host_726.emp.MeterStatus.UX_ReconcileAudit	4	NONCLUSTERED	Y			1506945	1	0	575	2026-10-12 01:01:52	2026-10-11 02:03:31	USED	keep — in use
host_726.emp.PricingAudit.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		0	2	0	106	2026-10-07 09:45:45	2026-10-11 02:03:32	USED	KEEP — primary key
host_726.emp.OrdersMonthly.IX_QuotaArchive	2	NONCLUSTERED			Y	0	0	0	818	never	2026-10-11 02:03:32	UNUSED	review, then DROP
host_726.emp.OrdersMonthly.IX_PayrollResult	3	NONCLUSTERED			Y	0	9	0	2643	2026-10-01 10:12:41	2026-10-11 02:03:32	USED	keep — in use
host_726.emp.OrdersMonthly.IX_TicketSnapshot	4	NONCLUSTERED				678472	55	0	3776	2026-10-12 01:01:04	2026-10-11 02:03:32	USED	keep — in use
host_726.emp.OrdersMonthly.IX_SettlementLine	5	NONCLUSTERED				88	0	0	3776	2026-10-03 13:20:33	2026-10-11 02:03:32	USED	keep — in use
host_726.emp.OrdersMonthly.PK_ShipmentSnapshot	1	CLUSTERED	Y	Y		17829	580	9	3776	2026-10-12 00:20:02	2026-10-11 02:03:32	USED	KEEP — primary key
host_726.emp.RosterQueue.PK_SettlementHistory	1	CLUSTERED	Y	Y		470697	12782	0	2	2026-10-11 23:59:11	2026-10-11 02:03:33	USED	KEEP — primary key
host_726.emp.BatchResult.IX_BillingQueue	6	NONCLUSTERED				31858	63	0	8981	2026-10-12 00:37:27	2026-10-11 02:03:33	USED	keep — in use
host_726.emp.BatchResult.PK_InvoiceSummary	1	CLUSTERED	Y	Y		0	84	55	8981	2026-10-10 10:26:49	2026-10-11 02:03:33	USED	KEEP — primary key
host_726.emp.TicketAudit.IX_LedgerLog	2	NONCLUSTERED				59	0	0	18058	2026-10-11 18:21:15	2026-10-11 02:03:34	USED	keep — in use
host_726.emp.TicketAudit.PK_LedgerStatus	1	CLUSTERED	Y	Y		0	0	59	18058	2026-10-11 18:21:15	2026-10-11 02:03:34	USED	KEEP — primary key
host_726.emp.InvoiceResult.PK_ShipmentMonthly	1	CLUSTERED	Y	Y		0	1	0	18058	2026-10-07 11:06:14	2026-10-11 02:03:34	USED	KEEP — primary key
host_726.emp.CustomerLog.IX_PolicyDaily	18	NONCLUSTERED				5	77310	0	134862	2026-10-12 00:16:54	2026-10-11 02:31:21	USED	keep — in use
host_726.emp.CustomerLog.IX_PayrollResult	21	NONCLUSTERED				27791447	3729147	0	269689	2026-10-12 01:01:56	2026-10-11 02:31:22	USED	keep — in use
host_726.emp.CustomerLog.PK_StaffingDaily	1	CLUSTERED	Y	Y		14584724	15426	14733682	269691	2026-10-12 01:01:56	2026-10-11 02:31:21	USED	KEEP — primary key
host_726.emp.InvoiceAudit.IX_SettlementResult	10	NONCLUSTERED				845976	323370	0	121597	2026-10-12 01:01:04	2026-10-11 02:31:23	USED	keep — in use
host_726.emp.InvoiceAudit.PK_QuotaEntry	1	CLUSTERED	Y	Y		0	639	285420	121597	2026-10-12 00:23:25	2026-10-11 02:31:22	USED	KEEP — primary key
host_726.emp.MeterSummary.PK_AssetEntry	1	CLUSTERED	Y	Y		0	0	0	83648	never	2026-10-11 02:31:23	UNUSED	KEEP — primary key
host_726.emp.BatchDaily.IX_SupplierStatus	1	CLUSTERED				0	3	0	202077	2026-10-07 11:06:15	2026-10-11 02:31:24	USED	KEEP — table storage
host_726.emp.AssetSummary.PK_SupplierStaging	1	CLUSTERED	Y	Y		0	38	0	134864	2026-10-11 01:15:02	2026-10-11 02:31:25	USED	KEEP — primary key
host_726.emp.SupplierStaging.IX_CampaignResult	24	NONCLUSTERED				0	838	0	54957	2026-10-11 22:30:27	2026-10-11 02:03:43	USED	keep — in use
host_726.emp.SupplierStaging.IX_StaffingSnapshot	30	NONCLUSTERED				9716184	1941	0	54959	2026-10-12 01:01:55	2026-10-11 02:03:44	USED	keep — in use
host_726.emp.SupplierStaging.IX_MeterStaging	16	NONCLUSTERED				1315	0	0	49316	2026-10-11 15:47:48	2026-10-11 02:03:44	USED	keep — in use
host_726.emp.SupplierStaging.IX_StaffingEntry	25	NONCLUSTERED				0	0	0	50198	never	2026-10-11 02:31:26	UNUSED	review, then DROP
host_726.emp.SupplierStaging.PK_PayrollMonthly	1	CLUSTERED	Y	Y		5081564	33812	2921799	54959	2026-10-12 01:01:55	2026-10-11 02:03:43	USED	KEEP — primary key
host_726.emp.SupplierStaging.IX_OrdersSnapshot	26	NONCLUSTERED	Y			146267	0	0	22983	2026-10-12 00:11:50	2026-10-11 02:03:44	USED	keep — in use
host_726.emp.CustomerStatus.IX_ReconcileLine	10	NONCLUSTERED				930299	351433	0	78689	2026-10-12 01:01:04	2026-10-11 02:03:45	USED	keep — in use
host_726.emp.CustomerStatus.PK_PolicyHistory	1	CLUSTERED	Y	Y		0	1738	330109	78689	2026-10-12 00:30:35	2026-10-11 02:03:45	USED	KEEP — primary key
host_726.emp.BillingAudit.PK_CustomerEntry	1	CLUSTERED	Y	Y		0	0	0	57356	never	2026-10-11 02:03:46	UNUSED	KEEP — primary key
host_726.emp.PolicyLine.PK_OrdersSummary	1	CLUSTERED	Y	Y		32	66149	0	95	2026-10-12 00:30:35	2026-10-11 02:03:47	USED	KEEP — primary key
host_726.emp.RouteStaging.PK_WarehouseLine	1	CLUSTERED	Y	Y		0	21692	0	0	2026-10-12 00:08:21	2026-10-11 02:03:47	USED	KEEP — primary key
host_726.emp.CampaignMonthly.PK_OrdersArchive	1	CLUSTERED	Y	Y		66	48226	0	2322	2026-10-12 00:30:35	2026-10-11 02:03:47	USED	KEEP — primary key
host_726.emp.CatalogSnapshot.PK_ClaimHistory	1	CLUSTERED	Y	Y		0	281	0	0	2026-10-11 19:26:27	2026-10-11 02:03:47	USED	KEEP — primary key
host_726.emp.TerritoryMonthly.IX_LedgerMonthly	1	CLUSTERED				0	2	0	34854	2026-10-07 11:06:15	2026-10-11 02:31:26	USED	KEEP — table storage
host_726.emp.BillingDaily.PK_CustomerLine	1	CLUSTERED	Y	Y		0	26333	32107	39089	2026-10-12 00:10:57	2026-10-11 02:31:27	USED	KEEP — primary key
host_726.emp.BillingDaily.UX_LedgerDaily	2	NONCLUSTERED	Y			33300	0	0	39089	2026-10-12 00:10:57	2026-10-11 02:31:27	USED	keep — in use
host_726.emp.SupplierHistory.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	49	0	56918	2026-10-11 01:15:00	2026-10-11 02:31:27	USED	KEEP — primary key
host_726.emp.ShipmentMonthly.IX_SupplierEntry	11	NONCLUSTERED				1188716	0	0	799677	2026-10-12 01:01:04	2026-10-11 02:31:28	USED	keep — in use
host_726.emp.ShipmentMonthly.IX_InvoiceStaging	2	NONCLUSTERED				1617676	0	0	799677	2026-10-12 00:51:56	2026-10-11 02:31:29	USED	keep — in use
host_726.emp.ShipmentMonthly.PK_BatchDaily	1	CLUSTERED	Y	Y		5473	1540	1276305	805150	2026-10-12 00:51:56	2026-10-11 02:31:28	USED	KEEP — primary key
host_726.emp.AssetDetail.PK_ReconcileResult	1	CLUSTERED	Y	Y		0	0	0	349388	never	2026-10-11 02:31:29	UNUSED	KEEP — primary key
host_726.emp.AssetSnapshot.IX_ForecastStatus	5	NONCLUSTERED				6947686	9127	0	350033	2026-10-12 00:55:39	2026-10-11 02:31:30	USED	keep — in use
host_726.emp.AssetSnapshot.IX_SalesDaily	2	NONCLUSTERED				5456640	24794	0	350033	2026-10-12 01:01:55	2026-10-11 02:31:30	USED	keep — in use
host_726.emp.AssetSnapshot.PK_OrdersDetail	1	CLUSTERED	Y	Y		252493	0	829647	350033	2026-10-12 00:42:53	2026-10-11 02:31:30	USED	KEEP — primary key
host_726.emp.PricingStatus.PK_PolicyStatus	1	CLUSTERED	Y	Y		0	5	0	350022	2026-10-07 11:06:38	2026-10-11 02:31:31	USED	KEEP — primary key
host_726.emp.TicketSnapshot.IX_BookingHistory	15	NONCLUSTERED				0	17268	0	422700	2026-10-11 22:30:29	2026-10-11 02:31:32	USED	keep — in use
host_726.emp.TicketSnapshot.PK_CampaignQueue	1	CLUSTERED	Y	Y		12802438	784097	5	422700	2026-10-12 01:01:55	2026-10-11 02:31:32	USED	KEEP — primary key
host_726.emp.TicketSnapshot.IX_ContractEntry	19	NONCLUSTERED	Y			766936	5301	0	422700	2026-10-12 00:55:39	2026-10-11 02:31:32	USED	keep — in use
host_726.emp.MeterEntry.IX_OrdersAudit	1	CLUSTERED				0	1	0	281861	2026-10-07 11:07:27	2026-10-11 02:04:01	USED	KEEP — table storage
host_726.emp.ForecastMonthly.PK_CampaignSummary	1	CLUSTERED	Y	Y		0	54	0	422487	2026-10-11 01:15:01	2026-10-11 02:31:33	USED	KEEP — primary key
host_726.emp.PricingStatus.IX_QuotaLog	7	NONCLUSTERED				47400	0	0	149316	2026-10-11 21:55:00	2026-10-11 02:31:34	USED	keep — in use
host_726.emp.PricingStatus.IX_ClaimEntry	2	NONCLUSTERED				11124415	40063	0	149316	2026-10-12 01:01:06	2026-10-11 02:31:34	USED	keep — in use
host_726.emp.PricingStatus.PK_LedgerResult	1	CLUSTERED	Y	Y		3694020	869	47251	149316	2026-10-12 01:01:55	2026-10-11 02:31:34	USED	KEEP — primary key
host_726.emp.AssetDaily.IX_PayrollDaily	1	CLUSTERED				0	0	0	1471	never	2026-10-11 02:04:04	UNUSED	KEEP — table storage
host_726.emp.PayrollHistory.PK_LedgerQueue	1	CLUSTERED	Y	Y		0	1	0	149301	2026-09-29 13:51:06	2026-10-11 02:31:35	USED	KEEP — primary key
host_726.emp.QuotaSummary.IX_StaffingQueue	10	NONCLUSTERED				792363	210315	0	14359	2026-10-12 01:01:04	2026-10-11 02:04:05	USED	keep — in use
host_726.emp.QuotaSummary.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	413	206751	14359	2026-10-12 00:15:06	2026-10-11 02:04:05	USED	KEEP — primary key
host_726.emp.PricingQueue.PK_PricingStaging	1	CLUSTERED	Y	Y		0	0	0	10807	never	2026-10-11 02:04:05	UNUSED	KEEP — primary key
host_726.emp.BookingMonthly.IX_ShipmentAudit	5	NONCLUSTERED				884828	12670524	0	14646	2026-10-12 01:01:54	2026-10-11 02:04:06	USED	keep — in use
host_726.emp.BookingMonthly.PK_WarehouseLog	1	CLUSTERED	Y	Y		338	0	0	14646	2026-10-10 09:23:33	2026-10-11 02:04:06	USED	KEEP — primary key
host_726.emp.MeterSnapshot.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	1	0	14646	2026-10-07 11:06:17	2026-10-11 02:04:06	USED	KEEP — primary key
host_726.emp.BatchMonthly.IX_ClaimSummary	18	NONCLUSTERED				0	1116	0	18488	2026-10-11 22:35:08	2026-10-11 02:04:08	USED	keep — in use
host_726.emp.BatchMonthly.PK_InvoiceDetail	1	CLUSTERED	Y	Y		15945960	83558	1069	18488	2026-10-12 01:01:55	2026-10-11 02:04:07	USED	KEEP — primary key
host_726.emp.BatchMonthly.IX_TerritorySnapshot	19	NONCLUSTERED	Y			17448	3	0	18488	2026-10-12 00:11:51	2026-10-11 02:04:08	USED	keep — in use
host_726.emp.WarehouseMonthly.IX_InvoiceStatus	1	CLUSTERED				0	0	0	6559	never	2026-10-11 02:04:08	UNUSED	KEEP — table storage
host_726.emp.StaffingAudit.PK_ForecastHeader	1	CLUSTERED	Y	Y		0	35	0	18689	2026-10-11 01:15:02	2026-10-11 02:04:09	USED	KEEP — primary key
host_726.emp.BatchLog.PK_SalesDetail	1	CLUSTERED	Y	Y		2481664	12690363	0	22522	2026-10-12 01:01:55	2026-10-11 02:04:10	USED	KEEP — primary key
host_726.emp.ReconcileSummary.IX_ShipmentDetail	1	CLUSTERED				0	0	0	162	never	2026-10-11 02:04:10	UNUSED	KEEP — table storage
host_726.emp.RouteHistory.PK_MeterEntry	1	CLUSTERED	Y	Y		0	0	0	22522	never	2026-10-11 02:04:10	UNUSED	KEEP — primary key
host_726.emp.CampaignResult.IX_ClaimStatus	15	NONCLUSTERED				3311652	18	0	329756	2026-10-12 01:01:55	2026-10-11 02:04:17	USED	keep — in use
host_726.emp.CampaignResult.IX_CustomerQueue	6	NONCLUSTERED				12278639	0	0	659512	2026-10-12 01:01:55	2026-10-11 02:04:17	USED	keep — in use
host_726.emp.CampaignResult.PK_StaffingArchive	1	CLUSTERED	Y	Y		8168293	7702	16074149	659981	2026-10-12 01:01:55	2026-10-11 02:04:11	USED	KEEP — primary key
host_726.emp.SalesHeader.IX_BookingSummary	2	NONCLUSTERED				0	0	0	17612	never	2026-10-11 02:04:21	UNUSED	review, then DROP
host_726.emp.SalesHeader.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	0	0	17612	never	2026-10-11 02:04:21	UNUSED	KEEP — primary key
host_726.emp.PayrollHistory.PK_CampaignStaging	1	CLUSTERED	Y	Y		38358	217	0	4217	2026-10-11 23:41:19	2026-10-11 02:04:18	USED	KEEP — primary key
host_726.emp.TerritoryDaily.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	4200	never	2026-10-11 02:04:18	UNUSED	KEEP — primary key
host_726.emp.CatalogSummary.IX_PricingSnapshot	27	NONCLUSTERED				586526	244	0	11229	2026-10-12 01:01:54	2026-10-11 02:04:19	USED	keep — in use
host_726.emp.CatalogSummary.IX_WarehouseSnapshot	7	NONCLUSTERED				935837	43821	0	3848	2026-10-12 01:01:52	2026-10-11 02:04:19	USED	keep — in use
host_726.emp.CatalogSummary.IX_ReconcileSummary	21	NONCLUSTERED				4015654	24	0	3848	2026-10-12 01:01:54	2026-10-11 02:04:19	USED	keep — in use
host_726.emp.CatalogSummary.IX_AssetEntry	26	NONCLUSTERED				1594834	9482	0	11229	2026-10-12 00:55:39	2026-10-11 02:04:19	USED	keep — in use
host_726.emp.CatalogSummary.PK_ShipmentStaging	1	CLUSTERED	Y	Y		16511714	170009	5941257	27754	2026-10-12 01:01:54	2026-10-11 02:04:19	USED	KEEP — primary key
host_726.emp.CatalogSummary.UX_OrdersAudit	2	NONCLUSTERED	Y			445	416	0	3848	2026-10-12 00:20:02	2026-10-11 02:04:19	USED	keep — in use
host_726.emp.CatalogSummary.UX_LedgerHistory	4	NONCLUSTERED	Y		Y	554135	3	0	11361	2026-10-12 00:55:39	2026-10-11 02:04:19	USED	keep — in use
host_726.emp.TicketMonthly.PK_LedgerAudit	1	CLUSTERED	Y	Y		13159	4776	0	22676	2026-10-11 22:40:02	2026-10-11 02:04:19	USED	KEEP — primary key
host_726.emp.BillingQueue.IX_AssetDetail	11	NONCLUSTERED				187	1370	0	6096	2026-10-11 02:11:49	2026-10-11 02:04:20	USED	keep — in use
host_726.emp.BillingQueue.IX_ContractSummary	8	NONCLUSTERED				7318390	5	0	6096	2026-10-12 01:01:54	2026-10-11 02:04:20	USED	keep — in use
host_726.emp.BillingQueue.PK_ShipmentEntry	1	CLUSTERED	Y	Y		2	193018	7318331	6096	2026-10-12 01:01:54	2026-10-11 02:04:20	USED	KEEP — primary key
host_726.emp.CampaignResult.IX_SupplierLine	13	NONCLUSTERED				5742	0	0	27798	2026-10-12 00:00:01	2026-10-11 02:04:20	USED	keep — in use
host_726.emp.CampaignResult.PK_CustomerLine	1	CLUSTERED	Y	Y		12	7421	5742	27798	2026-10-12 00:00:01	2026-10-11 02:04:20	USED	KEEP — primary key
host_726.guest.TerritoryQueue.IX_InvoiceStaging	2	NONCLUSTERED				0	0	0	0	never	2026-10-11 02:04:25	UNUSED	review, then DROP
host_726.org.SettlementSnapshot.PK_org.SettlementSnapshot	1	CLUSTERED	Y	Y		0	265	0	0	2026-10-10 08:36:48	2026-10-11 02:04:32	USED	KEEP — primary key
host_726.org.SettlementSnapshot.UX_BillingLine	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:32	UNUSED	review carefully — unique
host_726.org.PolicySummary.IX_AssetEntry	3	NONCLUSTERED				2179592	178076	0	100	2026-10-12 01:01:54	2026-10-11 02:04:33	USED	keep — in use
host_726.org.PolicySummary.PK_QuotaAudit	1	CLUSTERED	Y	Y		19327612	1725288	2185757	307	2026-10-12 01:01:54	2026-10-11 02:04:33	USED	KEEP — primary key
host_726.org.PolicySummary.UX_ForecastHistory	2	NONCLUSTERED	Y		Y	6372	0	0	130	2026-10-11 23:52:34	2026-10-11 02:04:33	USED	keep — in use
host_726.org.BatchMonthly.PK_WarehouseSummary	1	CLUSTERED	Y	Y		192	7281	0	100	2026-10-11 23:52:34	2026-10-11 02:04:33	USED	KEEP — primary key
host_726.org.BatchMonthly.UX_SalesSnapshot	2	NONCLUSTERED	Y		Y	0	0	0	100	never	2026-10-11 02:04:33	UNUSED	review carefully — unique
host_726.org.CampaignQueue.PK_RosterDaily	1	CLUSTERED	Y	Y		0	0	0	148	never	2026-10-11 02:04:33	UNUSED	KEEP — primary key
host_726.org.TicketLog.PK_WarehouseDetail	1	CLUSTERED	Y	Y		1359	1392	41	1285	2026-10-11 22:19:44	2026-10-11 02:04:33	USED	KEEP — primary key
host_726.org.TicketLog.UX_SalesMonthly	4	NONCLUSTERED	Y			40	4	0	1285	2026-10-11 22:19:52	2026-10-11 02:04:33	USED	keep — in use
host_726.org.Company.PK_QuotaStaging	1	CLUSTERED	Y	Y		4182435	950285	398	2	2026-10-12 01:01:54	2026-10-11 02:04:33	USED	KEEP — primary key
host_726.org.Company.UX_PricingResult	2	NONCLUSTERED	Y		Y	0	398	0	2	2026-10-10 16:43:32	2026-10-11 02:04:33	USED	keep — in use
host_726.org.ShipmentAudit.PK_ForecastHeader	1	CLUSTERED	Y	Y		4	4791050	2110765	6	2026-10-12 01:01:00	2026-10-11 02:04:33	USED	KEEP — primary key
host_726.org.ShipmentAudit.UX_BatchArchive	2	NONCLUSTERED	Y			2103978	6992	0	6	2026-10-12 01:01:00	2026-10-11 02:04:33	USED	keep — in use
host_726.org.WarehouseStaging.PK_MeterHistory	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-10-11 02:04:33	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		210	605	0	2	2026-10-11 23:49:07	2026-10-11 02:04:33	USED	KEEP — primary key
host_726.org.PricingStatus.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	0	0	2	never	2026-10-11 02:04:33	UNUSED	KEEP — primary key
host_726.org.CatalogHeader.PK_ShiftStatus	1	CLUSTERED	Y	Y		1688	969	0	42	2026-10-12 00:41:24	2026-10-11 02:04:34	USED	KEEP — primary key
host_726.org.PolicySummary.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	0	0	42	never	2026-10-11 02:04:34	UNUSED	KEEP — primary key
host_726.org.CatalogAudit.PK_AssetStatus	1	CLUSTERED	Y	Y		0	0	0	2	never	2026-10-11 02:04:34	UNUSED	KEEP — primary key
host_726.org.OrdersSummary.PK_StaffingAudit	1	CLUSTERED	Y	Y		3542	676	0	1800	2026-10-11 21:22:43	2026-10-11 02:31:35	USED	KEEP — primary key
host_726.org.ContractResult.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	1800	never	2026-10-11 02:31:35	UNUSED	KEEP — primary key
host_726.org.SupplierHistory.IX_ShipmentSummary	2	NONCLUSTERED				0	0	0	2640	never	2026-10-11 02:31:36	UNUSED	review, then DROP
host_726.org.SupplierHistory.PK_CustomerDetail	1	CLUSTERED	Y	Y		1279	174197	0	2640	2026-10-11 23:59:11	2026-10-11 02:31:36	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	346	never	2026-10-11 02:31:36	UNUSED	review, then DROP
host_726.org.BillingHeader.PK_InvoiceMonthly	1	CLUSTERED	Y	Y		168	42605	0	346	2026-10-11 23:59:11	2026-10-11 02:31:36	USED	KEEP — primary key
host_726.org.ShipmentSummary.IX_StaffingResult	2	NONCLUSTERED				0	0	0	234	never	2026-10-11 02:31:36	UNUSED	review, then DROP
host_726.org.ShipmentSummary.PK_ClaimDetail	1	CLUSTERED	Y	Y		113	42604	0	234	2026-10-11 23:59:11	2026-10-11 02:31:36	USED	KEEP — primary key
host_726.org.SalesStatus.IX_ClaimHeader	2	NONCLUSTERED	Y			42594	0	0	4	2026-10-11 23:59:11	2026-10-11 02:04:34	USED	keep — in use
host_726.org.SalesStatus.PK_CampaignSnapshot	1	CLUSTERED	Y	Y		34	0	42590	4	2026-10-11 23:59:11	2026-10-11 02:04:34	USED	KEEP — primary key
host_726.org.PolicyResult.PK_ForecastStaging	1	CLUSTERED	Y	Y		973	26013630	0	4	2026-10-12 00:42:54	2026-10-11 02:04:34	USED	KEEP — primary key
host_726.org.AssetSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		313676	38391	0	4	2026-10-11 23:59:11	2026-10-11 02:04:34	USED	KEEP — primary key
host_726.org.AssetSummary.UX_ShipmentSummary	2	NONCLUSTERED	Y			8	157528	0	4	2026-10-11 08:05:04	2026-10-11 02:04:34	USED	keep — in use
host_726.org.ShipmentQueue.PK_InvoiceStaging	1	CLUSTERED	Y	Y		1036536	9373919	0	39	2026-10-12 01:01:54	2026-10-11 02:04:34	USED	KEEP — primary key
host_726.org.PolicyEntry.PK_SettlementSnapshot	1	CLUSTERED	Y	Y		11688	3044	0	20	2026-10-12 00:20:02	2026-10-11 02:04:34	USED	KEEP — primary key
host_726.org.PolicyEntry.UX_ShiftSnapshot	2	NONCLUSTERED	Y		Y	0	0	0	18	never	2026-10-11 02:04:34	UNUSED	review carefully — unique
host_726.org.MeterAudit.IX_WarehouseQueue	6	NONCLUSTERED				2308	0	0	13	2026-10-12 00:20:02	2026-10-11 02:04:34	USED	keep — in use
host_726.org.MeterAudit.PK_BillingDetail	1	CLUSTERED	Y	Y		11366	2	0	17	2026-10-11 23:46:49	2026-10-11 02:04:34	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	15	never	2026-10-11 02:04:36	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	264	0	0	2026-10-10 08:36:48	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		510504	2748	27	99	2026-10-12 00:48:22	2026-10-11 02:04:36	USED	KEEP — primary key
host_726.org.ReconcileAudit.UQ_ShipmentResult	2	NONCLUSTERED	Y		Y	61	0	0	99	2026-10-10 10:39:27	2026-10-11 02:04:36	USED	keep — in use
host_726.org.StaffingAudit.PK_RosterArchive	1	CLUSTERED	Y	Y		0	0	0	122	never	2026-10-11 02:04:36	UNUSED	KEEP — primary key
host_726.org.ShiftResult.PK_AssetAudit	1	CLUSTERED	Y	Y		16186239	5589793	0	31	2026-10-12 01:01:54	2026-10-11 02:04:36	USED	KEEP — primary key
host_726.org.BatchMonthly.PK_SalesLine	1	CLUSTERED	Y	Y		12	64197	0	24	2026-10-12 00:10:57	2026-10-11 02:04:36	USED	KEEP — primary key
host_726.org.RosterMonthly.IX_AssetDetail	2	NONCLUSTERED				0	0	0	16	never	2026-10-11 02:04:36	UNUSED	review, then DROP
host_726.org.RosterMonthly.PK_ForecastDaily	1	CLUSTERED	Y	Y		8	13528	0	16	2026-10-11 10:55:00	2026-10-11 02:04:36	USED	KEEP — primary key
host_726.org.InvoiceStaging.IX_AssetAudit	2	NONCLUSTERED				0	0	0	16	never	2026-10-11 02:04:36	UNUSED	review, then DROP
host_726.org.InvoiceStaging.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	0	0	16	never	2026-10-11 02:04:36	UNUSED	KEEP — primary key
host_726.org.StaffingAudit.PK_AssetLog	1	CLUSTERED	Y	Y		0	0	0	34	never	2026-10-11 02:04:37	UNUSED	KEEP — primary key
host_726.org.Level.PK_ShiftStaging	1	CLUSTERED	Y	Y		1613612	8037	0	8	2026-10-12 00:55:39	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.Level.UX_SettlementHistory	2	NONCLUSTERED	Y		Y	0	298	0	8	2026-10-10 08:36:48	2026-10-11 02:04:37	USED	keep — in use
host_726.org.ContractHistory.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-10-11 02:04:37	UNUSED	KEEP — primary key
host_726.org.QuotaEntry.IX_AssetHistory	2	NONCLUSTERED				2	0	0	2	2026-09-22 10:14:28	2026-10-11 02:04:37	USED	keep — in use
host_726.org.QuotaEntry.PK_LedgerQueue	1	CLUSTERED	Y	Y		2	2455963	0	4	2026-10-12 00:42:58	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.ClaimQueue.PK_LedgerHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:37	UNUSED	KEEP — primary key
host_726.org.SupplierLine.PK_InvoiceStatus	1	CLUSTERED	Y	Y		1490627	14931183	0	7	2026-10-12 00:42:53	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.InvoiceHistory.PK_ContractDaily	1	CLUSTERED	Y	Y		2	86	0	1	2026-10-07 08:43:23	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.AssetHeader.IX_PayrollAudit	2	NONCLUSTERED				16421615	0	0	2646	2026-10-12 00:42:53	2026-10-11 02:04:37	USED	keep — in use
host_726.org.AssetHeader.PK_LedgerResult	1	CLUSTERED	Y	Y		1447	0	0	2646	2026-10-07 08:43:23	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.TerritoryStatus.PK_PayrollLine	1	CLUSTERED	Y	Y		0	0	0	17	never	2026-10-11 02:04:37	UNUSED	KEEP — primary key
host_726.org.RosterLine.PK_BillingDaily	1	CLUSTERED	Y	Y		0	1	0	7	2026-09-28 07:38:34	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.ForecastArchive.PK_CampaignHeader	1	CLUSTERED	Y	Y		409267	85	0	2	2026-10-12 00:42:53	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.PolicySummary.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		10	2035988	0	23	2026-10-12 00:42:53	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.ClaimMonthly.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:37	UNUSED	KEEP — primary key
host_726.org.OrdersEntry.PK_MeterDaily	1	CLUSTERED	Y	Y		64	993940	0	90	2026-10-12 00:42:53	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.LedgerStaging.PK_BatchLine	1	CLUSTERED	Y	Y		0	0	0	90	never	2026-10-11 02:04:37	UNUSED	KEEP — primary key
host_726.org.Position.PK_PolicySummary	1	CLUSTERED	Y	Y		8640114	53338	0	44	2026-10-12 01:01:54	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.Position.UX_MeterArchive	2	NONCLUSTERED	Y		Y	0	0	0	43	never	2026-10-11 02:04:37	UNUSED	review carefully — unique
host_726.org.CampaignQueue.PK_BillingArchive	1	CLUSTERED	Y	Y		470451	21295	2502	202	2026-10-11 23:59:11	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.CampaignQueue.UX_TicketDaily	2	NONCLUSTERED	Y			2181639	219	0	194	2026-10-12 01:01:54	2026-10-11 02:04:37	USED	keep — in use
host_726.org.MeterResult.PK_CatalogStaging	1	CLUSTERED	Y	Y		0	7	0	1217	2026-09-22 15:41:26	2026-10-11 02:04:37	USED	KEEP — primary key
host_726.org.QuotaLine.PK_AssetAudit	1	CLUSTERED	Y	Y		80	207	323	58	2026-10-10 08:36:58	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.QuotaLine.UX_PricingAudit	2	NONCLUSTERED	Y		Y	0	323	0	58	2026-10-10 08:36:48	never	USED	keep — in use
host_726.org.PayrollLog.PK_PayrollAudit	1	CLUSTERED	Y	Y		0	54	20	24	2026-10-09 08:16:21	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.PayrollLog.UX_PayrollDetail	2	NONCLUSTERED	Y			20	0	0	24	2026-10-09 08:16:15	2026-10-11 02:04:38	USED	keep — in use
host_726.org.LedgerDaily.PK_ContractHeader	1	CLUSTERED	Y	Y		0	4	0	40	2026-09-28 14:02:23	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.PricingArchive.PK_ShiftStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:38	UNUSED	KEEP — primary key
host_726.org.PricingArchive.UX_InvoiceAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:38	UNUSED	review carefully — unique
host_726.org.ForecastAudit.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	1863	0	0	2026-10-11 22:30:21	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.ForecastAudit.UX_ClaimArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:38	UNUSED	review carefully — unique
host_726.org.PayrollLine.PK_OrdersHistory	1	CLUSTERED	Y	Y		3154	1863	0	0	2026-10-11 22:30:21	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.PayrollLine.UX_ShiftLog	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:38	UNUSED	review carefully — unique
host_726.org.BookingStaging.PK_AssetResult	1	CLUSTERED	Y	Y		11838657	1450150	0	63	2026-10-12 01:01:54	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.ReconcileLine.PK_CustomerLog	1	CLUSTERED	Y	Y		0	0	0	26	never	2026-10-11 02:04:38	UNUSED	KEEP — primary key
host_726.org.ShiftStaging.PK_BillingHistory	1	CLUSTERED	Y	Y		0	49	0	0	2026-10-08 08:49:02	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.ShiftStaging.UQ_PolicyAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:38	UNUSED	review carefully — unique
host_726.org.CustomerLine.IX_ForecastLine	2	NONCLUSTERED				49	0	0	0	2026-10-08 08:49:02	2026-10-11 02:04:38	USED	keep — in use
host_726.org.CustomerLine.PK_LedgerEntry	1	CLUSTERED	Y	Y		2	40898	0	0	2026-10-11 23:59:11	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.CustomerLine.UQ_PayrollLog	3	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:38	UNUSED	review carefully — unique
host_726.org.InvoiceMonthly.PK_WarehouseQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:38	UNUSED	KEEP — primary key
host_726.org.InvoiceMonthly.UQ_MeterAudit	2	NONCLUSTERED	Y			0	49	0	0	2026-10-08 08:49:02	2026-10-11 02:04:38	USED	keep — in use
host_726.org.QuotaStaging.PK_ShiftStaging	1	CLUSTERED	Y	Y		27	76	40675	9	2026-10-11 23:59:11	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.QuotaStaging.UQ_ShiftMonthly	2	NONCLUSTERED	Y			40675	0	0	9	2026-10-11 23:59:11	2026-10-11 02:04:38	USED	keep — in use
host_726.org.BatchMonthly.PK_WarehouseHeader	1	CLUSTERED	Y	Y		1978	39865	1808	170	2026-10-11 23:59:11	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.BatchMonthly.UQ_LedgerStaging	2	NONCLUSTERED	Y			1808	0	0	170	2026-10-08 08:49:02	2026-10-11 02:04:38	USED	keep — in use
host_726.org.ClaimHeader.PK_ClaimArchive	1	CLUSTERED	Y	Y		0	0	0	2825	never	2026-10-11 02:04:38	UNUSED	KEEP — primary key
host_726.org.SupplierResult.PK_ForecastQueue	1	CLUSTERED	Y	Y		178	179084	0	2	2026-10-11 23:49:07	2026-10-11 02:04:38	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		10217	21597	6306682	31820	2026-10-12 01:01:54	2026-10-11 02:04:39	USED	KEEP — primary key
host_726.org.ShiftResult.UX_LedgerStaging	2	NONCLUSTERED	Y			6306768	88	0	31820	2026-10-12 01:01:54	2026-10-11 02:04:39	USED	keep — in use
host_726.org.QuotaResult.PK_CampaignDaily	1	CLUSTERED	Y	Y		146931	55671	14	6	2026-10-12 01:01:07	2026-10-11 02:04:38	USED	KEEP — primary key
host_726.org.QuotaResult.UX_BatchDaily	2	NONCLUSTERED	Y			16	0	0	6	2026-10-05 19:36:58	2026-10-11 02:04:38	USED	keep — in use
host_726.org.QuotaDetail.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		4	20945770	0	20	2026-10-12 00:42:54	2026-10-11 02:04:39	USED	KEEP — primary key
host_726.org.BookingLog.PK_MeterStaging	1	CLUSTERED	Y	Y		0	0	0	18	never	2026-10-11 02:04:39	UNUSED	KEEP — primary key
host_726.org.SettlementAudit.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-10-11 02:04:39	UNUSED	KEEP — primary key
host_726.oth.QuotaSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		6	21	0	0	2026-10-06 16:26:19	2026-10-11 02:04:39	USED	KEEP — primary key
host_726.oth.InvoiceStatus.PK_ShiftQueue	1	CLUSTERED	Y	Y		2465	157	0	0	2026-10-12 00:00:00	2026-10-11 02:04:39	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-10-11 02:04:39	USED	KEEP — primary key
host_726.oth.SupplierLine.UX_InvoiceHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:39	UNUSED	review carefully — unique
host_726.oth.StaffingArchive.IX_InvoiceStaging	2	NONCLUSTERED				0	0	0	0	never	2026-10-11 02:04:39	UNUSED	review, then DROP
host_726.oth.StaffingArchive.PK_PricingAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:39	UNUSED	KEEP — primary key
host_726.oth.StaffingArchive.UQ_SalesAudit	3	NONCLUSTERED	Y			22	2474	0	0	2026-10-11 23:52:40	2026-10-11 02:04:39	USED	keep — in use
host_726.oth.CustomerQueue.IX_WarehouseResult	2	NONCLUSTERED				12	21	0	0	2026-10-06 16:26:19	2026-10-11 02:04:39	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-10-11 02:04:39	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	66560	0	3189	2026-10-11 23:59:11	2026-10-11 02:04:39	USED	KEEP — primary key
host_726.sal.ClaimArchive.IX_RouteDetail	2	NONCLUSTERED				0	1	0	0	2026-10-07 11:06:17	2026-10-11 02:04:40	USED	keep — in use
host_726.sal.ClaimArchive.PK_LedgerHeader	1	CLUSTERED	Y	Y		0	0	1	0	2026-10-07 11:06:17	2026-10-11 02:04:40	USED	KEEP — primary key
host_726.sal.QuotaLine.PK_ContractArchive	1	CLUSTERED	Y	Y		31579	175003	0	34	2026-10-12 01:01:00	2026-10-11 02:04:40	USED	KEEP — primary key
host_726.sal.SalesStatus.PK_ShiftMonthly	1	CLUSTERED	Y	Y		477486	3441	0	347	2026-10-11 23:59:11	2026-10-11 02:04:40	USED	KEEP — primary key
host_726.sal.SettlementQueue.PK_StaffingSnapshot	1	CLUSTERED	Y	Y		0	531830	0	485493	2026-10-11 23:59:11	2026-10-11 02:04:40	USED	KEEP — primary key
host_726.sal.MeterHistory.PK_LedgerSnapshot	1	CLUSTERED	Y	Y		0	23263	0	485493	2026-10-11 23:59:11	2026-10-11 02:04:41	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		9	929	0	0	2026-10-11 22:26:07	2026-10-11 02:04:41	USED	KEEP — primary key
host_726.sal.RouteResult.UX_ContractEntry	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:41	UNUSED	review carefully — unique
host_726.sal.WarehouseDaily.PK_SettlementDetail	1	CLUSTERED	Y	Y		19392	11525	0	96	2026-10-11 23:48:13	2026-10-11 02:04:41	USED	KEEP — primary key
host_726.sal.WarehouseDaily.UX_BookingAudit	2	NONCLUSTERED	Y			2	0	0	95	2026-09-09 15:48:18	2026-10-11 02:04:41	USED	keep — in use
host_726.sal.InvoiceLog.PK_MeterAudit	1	CLUSTERED	Y	Y		748	941	0	738	2026-10-11 22:26:07	2026-10-11 02:04:41	USED	KEEP — primary key
host_726.sal.PolicySnapshot.PK_ReconcileQueue	1	CLUSTERED	Y	Y		0	2	0	738	2026-09-09 15:55:25	2026-10-11 02:04:41	USED	KEEP — primary key
host_726.sal.SettlementStatus.PK_ReconcileResult	1	CLUSTERED	Y	Y		6249	1193	2836	5701	2026-10-11 23:04:54	2026-10-11 02:04:41	USED	KEEP — primary key
host_726.sal.SettlementStatus.UX_StaffingMonthly	2	NONCLUSTERED	Y			2835	3	0	5696	2026-10-11 23:04:54	2026-10-11 13:03:34	USED	keep — in use
host_726.sal.ReconcileHistory.PK_PayrollHeader	1	CLUSTERED	Y	Y		335	676	1	670	2026-10-11 22:26:07	2026-10-11 02:04:41	USED	KEEP — primary key
host_726.sal.ReconcileHistory.UX_TicketQueue	2	NONCLUSTERED	Y			1	0	0	670	2026-09-09 14:08:21	2026-10-11 02:04:41	USED	keep — in use
host_726.sal.InvoiceEntry.PK_RouteQueue	1	CLUSTERED	Y	Y		0	0	0	670	never	2026-10-11 02:04:41	UNUSED	KEEP — primary key
host_726.sal.BillingQueue.PK_ReconcileHistory	1	CLUSTERED	Y	Y		0	2	0	5692	2026-10-08 08:41:45	2026-10-11 02:04:41	USED	KEEP — primary key
host_726.sal.RosterDetail.PK_BookingStaging	1	CLUSTERED	Y	Y		0	0	0	96	never	2026-10-11 02:04:42	UNUSED	KEEP — primary key
host_726.sal.RosterQueue.PK_ShiftQueue	1	CLUSTERED	Y	Y		0	20948	0	0	2026-10-11 23:59:11	2026-10-11 02:04:42	USED	KEEP — primary key
host_726.sal.RosterQueue.UX_RosterArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:42	UNUSED	review carefully — unique
host_726.sal.WarehouseHeader.PK_RouteEntry	1	CLUSTERED	Y	Y		0	513	0	0	2026-10-12 00:09:32	2026-10-11 02:04:42	USED	KEEP — primary key
host_726.sal.SupplierArchive.PK_SupplierStaging	1	CLUSTERED	Y	Y		0	88	0	0	2026-10-07 11:06:18	2026-10-11 02:04:42	USED	KEEP — primary key
host_726.sal.RosterQueue.PK_PolicyLog	1	CLUSTERED	Y	Y		0	23	0	0	2026-10-05 14:32:56	2026-10-11 02:04:42	USED	KEEP — primary key
host_726.sal.CustomerSnapshot.PK_RosterEntry	1	CLUSTERED	Y	Y		0	88	0	0	2026-10-07 11:06:18	2026-10-11 02:04:42	USED	KEEP — primary key
host_726.sal.LedgerStatus.PK_WarehouseStaging	1	CLUSTERED	Y	Y		23	19	0	0	2026-10-10 16:45:48	2026-10-11 02:04:42	USED	KEEP — primary key
host_726.sal.BookingLine.PK_PricingAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:42	UNUSED	KEEP — primary key
host_726.sal.PricingLine.PK_BatchLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:42	UNUSED	KEEP — primary key
host_726.sal.WarehouseStaging.PK_SettlementHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:42	UNUSED	KEEP — primary key
host_726.sal.StaffingArchive.PK_CatalogLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:42	UNUSED	KEEP — primary key
host_726.sal.WarehouseSummary.PK_RosterArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:42	UNUSED	KEEP — primary key
host_726.schedule.CustomerDetail.PK_CatalogStaging	1	CLUSTERED	Y	Y		0	330	5186198	0	2026-10-12 00:42:54	2026-10-11 02:04:43	USED	KEEP — primary key
host_726.schedule.CustomerDetail.UQ_BillingSnapshot	3	NONCLUSTERED	Y			5180017	2466	0	0	2026-10-12 00:42:54	2026-10-11 02:04:43	USED	keep — in use
host_726.schedule.CustomerDetail.UQ_CampaignResult	2	NONCLUSTERED	Y			5187678	2561	0	0	2026-10-12 00:42:54	2026-10-11 02:04:43	USED	keep — in use
host_726.schedule.InvoiceHistory.IX_StaffingHeader	3	NONCLUSTERED				0	0	0	0	never	2026-10-11 02:04:43	UNUSED	review, then DROP
host_726.schedule.InvoiceHistory.PK_ContractLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:04:43	UNUSED	KEEP — primary key
host_726.schedule.InvoiceHistory.UQ_LedgerResult	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:43	UNUSED	review carefully — unique
host_726.schedule.MeterStaging.PK_SettlementMonthly	1	CLUSTERED	Y	Y		4914062	0	0	2328	2026-10-12 00:42:58	2026-10-11 02:04:43	USED	KEEP — primary key
host_726.schedule.SettlementLine.PK_CampaignStatus	1	CLUSTERED	Y	Y		5709650	1349	0	4120	2026-10-12 01:01:43	2026-10-11 02:04:43	USED	KEEP — primary key
host_726.schedule.TicketEntry.PK_CampaignDaily	1	CLUSTERED	Y	Y		2843	4055	0	4119	2026-10-12 00:41:24	2026-10-11 02:04:43	USED	KEEP — primary key
host_726.schedule.QuotaSummary.PK_LedgerStatus	1	CLUSTERED	Y	Y		13125971	5917	0	1291	2026-10-12 00:42:54	2026-10-11 02:04:43	USED	KEEP — primary key
host_726.schedule.ShipmentLog.PK_SalesEntry	1	CLUSTERED	Y	Y		5204605	0	0	4632	2026-10-12 00:42:54	2026-10-12 00:37:51	USED	KEEP — primary key
host_726.schedule.PricingResult.PK_CampaignDaily	1	CLUSTERED	Y	Y		5181388	6483	0	1347	2026-10-12 00:42:54	2026-10-11 02:04:43	USED	KEEP — primary key
host_726.schedule.SupplierSnapshot.IX_BillingHeader	3	NONCLUSTERED				10805381	1465	0	17733909	2026-10-12 00:42:54	2026-10-12 00:37:49	USED	keep — in use
host_726.schedule.SupplierSnapshot.PK_AssetStatus	1	CLUSTERED	Y	Y		32380564	876884	10125232	22933866	2026-10-12 00:43:11	2026-10-12 00:37:49	USED	KEEP — primary key
host_726.schedule.SupplierSnapshot.IX_ContractLog	2	NONCLUSTERED	Y			16	3975229	0	10364988	2026-10-12 00:43:11	2026-10-12 00:37:49	USED	keep — in use
host_726.schedule.BatchDetail.PK_AssetDetail	1	CLUSTERED	Y	Y		0	1	0	0	2026-10-05 19:08:57	never	USED	KEEP — primary key
host_726.schedule.RosterSummary.IX_BatchDetail	2	NONCLUSTERED				9641739	549268	0	9825457	2026-10-12 00:42:40	2026-10-12 00:37:46	USED	keep — in use
host_726.schedule.RosterSummary.IX_ClaimHeader	3	NONCLUSTERED				5163005	497655	0	9825457	2026-10-12 00:41:43	2026-10-12 00:37:46	USED	keep — in use
host_726.schedule.RosterSummary.PK_CustomerAudit	1	CLUSTERED	Y	Y		196228881	3140	6736419	22184902	2026-10-12 01:01:43	2026-10-12 00:37:46	USED	KEEP — primary key
host_726.schedule.BillingDetail.IX_TicketHeader	2	NONCLUSTERED				74082586	526462	0	41614877	2026-10-12 00:42:49	2026-10-12 00:41:34	USED	keep — in use
host_726.schedule.BillingDetail.PK_BillingLog	1	CLUSTERED	Y	Y		298749375	1626208	51825890	48983541	2026-10-12 01:01:43	2026-10-12 00:41:33	USED	KEEP — primary key
host_726.schedule.PolicyStatus.IX_ForecastAudit	2	NONCLUSTERED				41869895	0	0	88253867	2026-10-12 00:42:56	2026-10-12 00:41:07	USED	keep — in use
host_726.schedule.PolicyStatus.IX_SupplierLine	3	NONCLUSTERED				73909568	1063	0	88253510	2026-10-12 00:43:15	2026-10-12 00:41:08	USED	keep — in use
host_726.schedule.PolicyStatus.PK_PricingDaily	1	CLUSTERED	Y	Y		104995370	1829	43816663	88253501	2026-10-12 00:42:57	2026-10-12 00:41:07	USED	KEEP — primary key
host_726.schedule.PolicyLine.IX_TerritorySnapshot	2	NONCLUSTERED				82449672	440	0	11888191	2026-10-12 00:42:54	2026-10-11 20:56:09	USED	keep — in use
host_726.schedule.PolicyLine.PK_BookingAudit	1	CLUSTERED	Y	Y		42943901	2112	2424052	19255990	2026-10-12 00:42:48	2026-10-11 20:56:09	USED	KEEP — primary key
host_726.schedule.AssetResult.IX_BillingResult	2	NONCLUSTERED				7502232	1	0	7502232	2026-10-12 00:42:54	never	USED	keep — in use
host_726.schedule.AssetResult.PK_TicketQueue	1	CLUSTERED	Y	Y		0	0	0	7502232	never	never	UNUSED	KEEP — primary key
host_726.schedule.InvoiceAudit.IX_StaffingQueue	2	NONCLUSTERED				141372461	274	0	34313302	2026-10-12 00:42:54	2026-10-12 00:38:26	USED	keep — in use
host_726.schedule.InvoiceAudit.PK_LedgerMonthly	1	CLUSTERED	Y	Y		46416352	178	2635128	34313383	2026-10-12 00:42:48	2026-10-12 00:38:26	USED	KEEP — primary key
host_726.schedule.SettlementLog.IX_TicketLine	2	NONCLUSTERED				78129048	0	0	100622303	2026-10-12 00:42:54	2026-10-12 00:41:48	USED	keep — in use
host_726.schedule.SettlementLog.IX_PolicyLine	3	NONCLUSTERED				12385769	275	0	100622303	2026-10-12 00:41:51	2026-10-12 00:41:48	USED	keep — in use
host_726.schedule.SettlementLog.PK_CatalogMonthly	1	CLUSTERED	Y	Y		145258336	9	7534207	111716621	2026-10-12 00:42:50	2026-10-12 00:41:47	USED	KEEP — primary key
host_726.schedule.ShiftHeader.IX_TicketStatus	4	NONCLUSTERED				1198	163	0	20146892	2026-10-07 13:48:43	2026-10-12 00:41:27	USED	keep — in use
host_726.schedule.ShiftHeader.IX_ShipmentLine	3	NONCLUSTERED				52546407	5	0	20146892	2026-10-12 00:43:11	2026-10-12 00:41:27	USED	keep — in use
host_726.schedule.ShiftHeader.PK_OrdersArchive	1	CLUSTERED	Y	Y		571010950	3270	15419592	35746796	2026-10-12 01:01:55	2026-10-12 00:41:27	USED	KEEP — primary key
host_726.schedule.ShiftHeader.IX_BookingStatus	2	NONCLUSTERED	Y			16496	7119	0	20146892	2026-10-12 00:43:12	2026-10-12 00:40:18	USED	keep — in use
host_726.schedule.PolicyLine.PK_RouteQueue	1	CLUSTERED	Y	Y		250419099	7579213	0	20812687	2026-10-12 01:01:56	2026-10-12 00:37:48	USED	KEEP — primary key
host_726.schedule.PolicyLine.UX_TerritoryHistory	2	NONCLUSTERED	Y		Y	0	0	0	10412771	never	2026-10-12 00:37:49	UNUSED	review carefully — unique
host_726.schedule.RosterHistory.IX_AssetSummary	2	NONCLUSTERED				41299639	527474	0	10412786	2026-10-12 01:01:55	2026-10-12 00:37:54	USED	keep — in use
host_726.schedule.RosterHistory.PK_WarehouseLine	1	CLUSTERED	Y	Y		17625018	0	526522	10412786	2026-10-12 01:01:43	2026-10-12 00:37:54	USED	KEEP — primary key
host_726.schedule.MeterStaging.IX_PayrollAudit	2	NONCLUSTERED				60746954	5793309	0	10412793	2026-10-12 01:01:55	2026-10-12 00:35:18	USED	keep — in use
host_726.schedule.MeterStaging.PK_PolicyArchive	1	CLUSTERED	Y	Y		13049580	4	2696025	10412791	2026-10-12 01:01:43	2026-10-12 00:35:18	USED	KEEP — primary key
host_726.schedule.CustomerHistory.IX_LedgerQueue	2	NONCLUSTERED				3517199	2110596	0	60583854	2026-10-12 01:01:54	2026-10-12 00:42:52	USED	keep — in use
host_726.schedule.CustomerHistory.PK_PayrollAudit	1	CLUSTERED	Y	Y		96360311	1275	1278536	61394745	2026-10-12 01:01:54	2026-10-12 00:42:52	USED	KEEP — primary key
host_726.schedule.RosterResult.IX_BookingAudit	2	NONCLUSTERED				53	2790	0	29471896	2026-10-01 09:37:51	2026-10-12 00:41:25	USED	keep — in use
host_726.schedule.RosterResult.IX_AssetStaging	3	NONCLUSTERED				18228298	9710	0	29471955	2026-10-12 00:43:11	2026-10-12 00:41:26	USED	keep — in use
host_726.schedule.RosterResult.PK_PricingSummary	1	CLUSTERED	Y	Y		76316067	12132	5698286	30283053	2026-10-12 01:01:43	2026-10-12 00:41:24	USED	KEEP — primary key
host_726.schedule.LedgerSnapshot.PK_RouteStatus	1	CLUSTERED	Y	Y		36396425	2761015	0	12	2026-10-12 01:01:54	2026-10-11 02:31:02	USED	KEEP — primary key
host_726.schedule.LedgerSnapshot.IX_TicketLine	2	NONCLUSTERED	Y			17	1	0	12	2026-09-09 13:01:17	2026-10-11 02:31:02	USED	keep — in use
host_726.schedule.RosterHistory.PK_MeterLine	1	CLUSTERED	Y	Y		21291615	13	0	2317	2026-10-12 01:01:43	2026-10-11 02:31:02	USED	KEEP — primary key
host_726.schedule.AssetStaging.PK_CampaignResult	1	CLUSTERED	Y	Y		15582281	2467	0	2317	2026-10-12 00:42:54	2026-10-11 02:31:02	USED	KEEP — primary key
host_726.schedule.CampaignDaily.IX_BookingArchive	2	NONCLUSTERED				0	1	0	65349	2026-10-01 15:39:54	2026-10-11 02:31:36	USED	keep — in use
host_726.schedule.CampaignDaily.PK_PricingEntry	1	CLUSTERED	Y	Y		0	28	0	65349	2026-10-11 21:02:32	2026-10-11 02:31:36	USED	KEEP — primary key
host_726.schedule.BatchSnapshot.IX_ShiftQueue	3	NONCLUSTERED				0	18594	0	66001	2026-10-12 01:01:50	2026-10-12 00:18:22	USED	keep — in use
host_726.schedule.BatchSnapshot.PK_ShiftHistory	1	CLUSTERED	Y	Y		0	18479	17322	74695	2026-10-12 01:01:49	2026-10-12 00:18:22	USED	KEEP — primary key
host_726.schedule.BatchSnapshot.UX_StaffingEntry	2	NONCLUSTERED	Y			75270	421	0	66001	2026-10-12 00:42:55	2026-10-12 00:18:22	USED	keep — in use
host_726.schedule.InvoiceLog.PK_CatalogSummary	1	CLUSTERED	Y	Y		1749072	2014981	44238	24	2026-10-12 01:01:54	2026-10-11 02:04:43	USED	KEEP — primary key
host_726.schedule.InvoiceLog.IX_WarehouseHeader	2	NONCLUSTERED	Y			44262	1	0	24	2026-10-12 00:15:01	2026-10-11 02:04:43	USED	keep — in use
host_726.schedule.ContractResult.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	1972346	0	24	2026-10-12 01:01:54	2026-10-11 02:04:43	USED	KEEP — primary key
host_726.schedule.ContractResult.UX_CampaignHistory	2	NONCLUSTERED	Y		Y	1835855	38	0	24	2026-10-12 00:55:39	2026-10-11 02:04:44	USED	keep — in use
host_726.schedule.BillingLog.PK_ContractResult	1	CLUSTERED	Y	Y		1055	3674	0	11	2026-10-12 01:01:54	2026-10-11 22:29:29	USED	KEEP — primary key
host_726.schedule.SalesArchive.IX_RosterStatus	1	CLUSTERED				0	0	0	21	never	2026-10-11 02:04:44	UNUSED	KEEP — table storage
host_726.schedule.CatalogHistory.PK_OrdersStatus	1	CLUSTERED	Y	Y		832603	28	0	0	2026-10-12 00:51:56	2026-10-11 02:04:44	USED	KEEP — primary key
host_726.schedule.CatalogHistory.IX_PricingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:04:44	UNUSED	review carefully — unique
host_726.schedule.engine.PK_ReconcileDaily	1	CLUSTERED	Y	Y		86253195	7	12823498	0	2026-10-12 00:42:59	2026-10-11 02:29:07	USED	KEEP — primary key
host_726.schedule.engine.UQ_MeterQueue	2	NONCLUSTERED	Y			12823582	0	0	0	2026-10-12 00:42:54	2026-10-11 02:29:07	USED	keep — in use
host_726.schedule.TerritoryAudit.PK_PayrollSnapshot	1	CLUSTERED	Y	Y		0	69	12437050	7736341	2026-10-12 00:42:59	2026-10-11 02:32:10	USED	KEEP — primary key
host_726.schedule.TerritoryAudit.UX_BookingHeader	2	NONCLUSTERED	Y		Y	12796405	217	0	5060589	2026-10-12 00:42:59	2026-10-11 02:32:10	USED	keep — in use
host_726.schedule.WarehouseArchive.IX_CustomerHistory	2	NONCLUSTERED				80	0	0	10425684	2026-09-14 10:55:41	2026-10-11 22:43:57	USED	keep — in use
host_726.schedule.WarehouseArchive.IX_OrdersHeader	3	NONCLUSTERED				5321318	67	0	10425684	2026-10-12 00:42:54	2026-10-11 22:43:57	USED	keep — in use
host_726.schedule.WarehouseArchive.PK_RouteAudit	1	CLUSTERED	Y	Y		18382231	6652407	84	18382273	2026-10-12 00:42:59	2026-10-11 02:32:10	USED	KEEP — primary key
host_726.schedule.LedgerMonthly.IX_CustomerMonthly	3	NONCLUSTERED				5321318	58	0	175689747	2026-10-12 00:42:54	2026-10-11 02:32:10	USED	keep — in use
host_726.schedule.LedgerMonthly.PK_ClaimLine	1	CLUSTERED	Y	Y		263534485	58	0	263534576	2026-10-12 00:42:58	2026-10-11 02:32:10	USED	KEEP — primary key
host_726.schedule.RouteAudit.IX_InvoiceHeader	2	NONCLUSTERED				7	0	0	5321320	2026-10-07 08:57:52	2026-10-11 02:32:10	USED	keep — in use
host_726.schedule.RouteAudit.IX_SettlementDetail	3	NONCLUSTERED			Y	0	5	0	5212797	2026-10-10 18:50:22	never	USED	keep — in use
host_726.schedule.RouteAudit.IX_CatalogArchive	4	NONCLUSTERED				17648	187	0	5321287	2026-10-10 18:52:12	2026-10-11 02:32:11	USED	keep — in use
host_726.schedule.RouteAudit.IX_QuotaStaging	5	NONCLUSTERED				0	667	0	5321287	2026-10-11 21:02:32	2026-10-11 02:32:11	USED	keep — in use
host_726.schedule.RouteAudit.PK_PayrollAudit	1	CLUSTERED	Y	Y		287	2837	18491	5321287	2026-10-11 21:02:32	2026-10-11 02:32:10	USED	KEEP — primary key
host_726.schedule.ShipmentHeader.PK_CampaignDetail	1	CLUSTERED	Y	Y		4543	1023	0	87848416	2026-10-11 06:48:39	2026-10-11 02:32:13	USED	KEEP — primary key
host_726.schedule.SupplierEntry.PK_AssetSnapshot	1	CLUSTERED	Y	Y		40159210	7	0	0	2026-10-12 00:42:54	2026-10-11 02:30:35	USED	KEEP — primary key
host_726.schedule.TerritoryDetail.PK_ReconcileMonthly	1	CLUSTERED	Y	Y		74	2	0	148	2026-10-10 18:50:52	2026-10-11 02:30:35	USED	KEEP — primary key
host_726.schedule.StaffingEntry.PK_QuotaDetail	1	CLUSTERED	Y	Y		420877618	204	104	198	2026-10-12 00:42:58	2026-10-11 02:30:36	USED	KEEP — primary key
host_726.schedule.StaffingEntry.UQ_TicketDetail	2	NONCLUSTERED	Y			116	42	0	74	2026-10-11 21:02:17	2026-10-11 02:30:36	USED	keep — in use
host_726.schedule.StaffingEntry.UX_PayrollDaily	3	NONCLUSTERED	Y		Y	80342630	104	0	124	2026-10-12 00:42:54	2026-10-11 02:30:36	USED	keep — in use
host_726.schedule.ForecastMonthly.PK_ForecastHistory	1	CLUSTERED	Y	Y		420899290	1085	69	841773977	2026-10-12 00:42:58	2026-10-11 02:32:16	USED	KEEP — primary key
host_726.schedule.CatalogEntry.PK_PolicyDetail	1	CLUSTERED	Y	Y		80342630	6	2	0	2026-10-12 00:42:54	2026-10-11 02:31:02	USED	KEEP — primary key
host_726.schedule.CatalogEntry.UQ_AssetAudit	2	NONCLUSTERED	Y			2	0	0	0	2026-10-02 15:11:35	2026-10-11 02:31:02	USED	keep — in use
host_726.schedule.ContractAudit.PK_TicketSummary	1	CLUSTERED	Y	Y		420877420	2	0	0	2026-10-12 00:42:58	2026-10-11 02:31:02	USED	KEEP — primary key
host_726.schedule.ContractAudit.UQ_OrdersStaging	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:31:02	UNUSED	review carefully — unique
host_726.schedule.ContractAudit.UX_BillingSnapshot	3	NONCLUSTERED	Y		Y	80342629	0	0	0	2026-10-12 00:42:54	2026-10-11 02:31:02	USED	keep — in use
host_726.schedule.SupplierSummary.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	127	16	15	2026-10-11 21:02:17	2026-10-11 02:31:02	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-11 02:31:02	USED	keep — in use
host_726.schedule.PayrollDaily.PK_CustomerQueue	1	CLUSTERED	Y	Y		56974057	1153991	0	10	2026-10-12 00:42:54	2026-10-11 02:31:02	USED	KEEP — primary key
host_726.schedule.WarehouseDaily.PK_QuotaAudit	1	CLUSTERED	Y	Y		86	47	8	18	2026-10-11 21:02:17	2026-10-11 02:31:02	USED	KEEP — primary key
host_726.schedule.WarehouseDaily.UQ_ShiftEntry	2	NONCLUSTERED	Y			24	42	0	6	2026-10-11 21:02:17	2026-10-11 02:31:02	USED	keep — in use
host_726.schedule.WarehouseDaily.UX_TerritorySummary	3	NONCLUSTERED	Y		Y	82	0	0	12	2026-10-10 18:50:52	2026-10-11 02:31:02	USED	keep — in use
host_726.schedule.sql.IX_PayrollEntry	3	NONCLUSTERED			Y	80342628	128	0	413	2026-10-12 00:42:54	2026-10-11 02:31:02	USED	keep — in use
host_726.schedule.sql.PK_ContractMonthly	1	CLUSTERED	Y	Y		1057	173	594	413	2026-10-11 21:02:17	2026-10-11 02:31:02	USED	KEEP — primary key
host_726.schedule.sql.UQ_SalesStatus	2	NONCLUSTERED	Y			1169	257	0	7	2026-10-10 18:51:13	2026-10-11 02:31:02	USED	keep — in use
host_726.schedule.LedgerStatus.PK_SettlementQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:02	UNUSED	KEEP — primary key
host_726.schedule.LedgerStatus.UQ_QuotaAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:31:02	UNUSED	review carefully — unique
host_726.schedule.OrdersQueue.PK_QuotaQueue	1	CLUSTERED	Y	Y		74	2	0	148	2026-10-10 18:50:52	2026-10-11 02:31:04	USED	KEEP — primary key
host_726.schedule.LedgerStaging.IX_StaffingLog	3	NONCLUSTERED				80343788	160	0	1291	2026-10-12 00:42:54	2026-10-11 02:31:04	USED	keep — in use
host_726.schedule.LedgerStaging.PK_ContractQueue	1	CLUSTERED	Y	Y		420878740	211	80342909	1291	2026-10-12 00:42:58	2026-10-11 02:31:04	USED	KEEP — primary key
host_726.schedule.LedgerStaging.UQ_TicketResult	2	NONCLUSTERED	Y			688	93	0	413	2026-10-11 21:02:17	2026-10-11 02:31:04	USED	keep — in use
host_726.schedule.LedgerStaging.UX_QuotaHeader	4	NONCLUSTERED	Y		Y	0	0	0	878	never	2026-10-11 02:31:04	UNUSED	review carefully — unique
host_726.schedule.step.PK_AssetStaging	1	CLUSTERED	Y	Y		85555506	11	2	0	2026-10-12 00:42:59	2026-10-11 02:31:05	USED	KEEP — primary key
host_726.schedule.step.UQ_AssetQueue	3	NONCLUSTERED	Y			2	0	0	0	2026-10-02 15:11:35	2026-10-11 02:31:05	USED	keep — in use
host_726.schedule.step.UQ_OrdersLine	2	NONCLUSTERED	Y			0	1	0	0	2026-09-11 20:30:27	2026-10-11 02:31:05	USED	keep — in use
host_726.schedule.ShipmentResult.PK_MeterSnapshot	1	CLUSTERED	Y	Y		74	2	0	148	2026-10-10 18:50:52	2026-10-11 02:31:08	USED	KEEP — primary key
host_726.schedule.WarehouseEntry.PK_SettlementLine	1	CLUSTERED	Y	Y		420877569	80342789	0	0	2026-10-12 00:42:58	2026-10-11 02:31:08	USED	KEEP — primary key
host_726.schedule.WarehouseEntry.UQ_ShiftSnapshot	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-11 02:31:08	UNUSED	review carefully — unique
host_726.schedule.WarehouseEntry.UX_OrdersLog	3	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-10-11 02:31:08	COLD	review carefully — unique
host_726.wps.ContractStatus.IX_RosterDaily	3	NONCLUSTERED				30	0	0	50929	2026-09-30 08:03:26	2026-10-11 02:31:08	USED	keep — in use
host_726.wps.ContractStatus.PK_ClaimLog	1	CLUSTERED	Y	Y		3	50922	45	50929	2026-10-12 01:01:00	2026-10-11 02:31:08	USED	KEEP — primary key
host_726.wps.ContractStatus.UX_TerritoryResult	2	NONCLUSTERED	Y		Y	0	0	0	7	never	2026-10-11 02:31:08	UNUSED	review carefully — unique
host_726.wps.ContractStatus.UX_SettlementDetail	4	NONCLUSTERED	Y			15	0	0	7	2026-09-29 15:35:25	2026-10-11 02:31:08	USED	keep — in use
host_726.wps.PolicyResult.IX_ContractSnapshot	2	NONCLUSTERED				0	0	0	21	never	2026-10-11 02:31:08	UNUSED	review, then DROP
host_726.wps.PolicyResult.PK_SettlementLine	1	CLUSTERED	Y	Y		409	3113	0	21	2026-10-11 22:23:41	2026-10-11 02:31:08	USED	KEEP — primary key
host_726.wps.LedgerMonthly.PK_BookingResult	1	CLUSTERED	Y	Y		0	0	0	32	never	2026-10-11 02:31:08	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-10-11 02:31:08	USED	KEEP — primary key
host_726.wps.SalesHeader.PK_ContractHistory	1	CLUSTERED	Y	Y		0	0	0	44	never	2026-10-11 02:31:08	UNUSED	KEEP — primary key
host_726.wps.ForecastResult.PK_QuotaLog	1	CLUSTERED	Y	Y		208	109	167815	362	2026-10-12 00:42:53	2026-10-11 02:31:08	USED	KEEP — primary key
host_726.wps.ForecastResult.UQ_ShipmentArchive	4	NONCLUSTERED	Y			173027	2	0	362	2026-10-12 00:42:53	2026-10-11 02:31:08	USED	keep — in use
host_726.wps.StaffingResult.PK_RosterStatus	1	CLUSTERED	Y	Y		8	47800	0	6	2026-10-12 01:01:00	2026-10-11 02:31:08	USED	KEEP — primary key
host_726.wps.StaffingStaging.PK_PolicyEntry	1	CLUSTERED	Y	Y		0	0	0	6	never	2026-10-11 02:31:08	UNUSED	KEEP — primary key
host_726.wps.QuotaDetail.PK_BatchQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:08	UNUSED	KEEP — primary key
host_726.wps.OrdersLog.PK_WarehouseArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-11 02:31:08	UNUSED	KEEP — primary key
host_726.wps.TerritoryQueue.IX_InvoiceAudit	11	NONCLUSTERED				1848	44	0	1971	2026-10-11 22:17:32	2026-10-11 02:31:08	USED	keep — in use
host_726.wps.TerritoryQueue.PK_RosterSnapshot	1	CLUSTERED	Y	Y		14	407	6903	1971	2026-10-12 00:41:12	2026-10-11 02:31:08	USED	KEEP — primary key
host_726.wps.TerritoryQueue.UX_MeterStaging	2	NONCLUSTERED	Y			509	4595	0	136	2026-10-12 00:41:12	2026-10-11 02:31:08	USED	keep — in use
host_726.wps.ContractEntry.PK_PayrollSummary	1	CLUSTERED	Y	Y		0	0	0	268	never	2026-10-11 02:31:08	UNUSED	KEEP — primary key
host_726.wps.TicketStatus.PK_InvoiceMonthly	1	CLUSTERED	Y	Y		0	10898	0	32	2026-10-11 23:59:00	2026-10-11 02:31:08	USED	KEEP — primary key
host_726.wps.SalesDetail.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	362	never	2026-10-11 02:31:08	UNUSED	KEEP — primary key
host_726.wps.ClaimResult.PK_TicketEntry	1	CLUSTERED	Y	Y		64	122	0	3	2026-10-11 22:17:31	2026-10-11 02:31:08	USED	KEEP — primary key
host_726.wps.CatalogSnapshot.PK_ForecastHeader	1	CLUSTERED	Y	Y		0	0	0	12	never	2026-10-11 02:31:08	UNUSED	KEEP — primary key
host_726.wps.BillingLine.PK_RosterResult	1	CLUSTERED	Y	Y		497	6584	0	0	2026-10-11 23:59:00	2026-10-11 02:31:08	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-10-11 02:31:08	USED	keep — in use
host_726.wps.BatchStatus.PK_ClaimLine	1	CLUSTERED	Y	Y		0	4114	4554	1	2026-10-11 22:23:02	2026-10-11 02:31:08	USED	KEEP — primary key
host_726.wps.BatchStatus.UQ_CustomerHeader	2	NONCLUSTERED	Y			4554	0	0	1	2026-10-11 22:05:04	2026-10-11 02:31:08	USED	keep — in use
host_726.wps.BookingResult.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-10-11 02:31:08	UNUSED	KEEP — primary key
host_726.wps.BookingStaging.PK_ForecastLog	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-10-11 02:31:08	UNUSED	KEEP — primary key
ASSET_Prod.dbo.PricingHeader.IX_StaffingHeader	3	NONCLUSTERED				0	0	0	481	never	2026-08-24 12:48:18	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_QuotaAudit	4	NONCLUSTERED				0	0	0	481	never	2026-08-24 12:48:18	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y		106248	17133	1	1362	2026-10-11 10:03:45	2026-08-24 12:50:52	USED	KEEP — primary key
ASSET_Prod.dbo.PricingHeader.UX_QuotaMonthly	2	NONCLUSTERED	Y			1	0	0	481	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	6415	0	0	2026-10-10 16:31:38	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	47	0	0	2026-10-07 15:39:49	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	395	0	10	2026-10-10 16:29:47	never	USED	KEEP — primary key
ASSET_Prod.dbo.SalesEntry.PK_BookingAudit	1	CLUSTERED	Y	Y		0	0	39	0	2026-10-10 16:21:02	never	USED	KEEP — primary key
ASSET_Prod.dbo.SalesEntry.UX_ShiftSnapshot	2	NONCLUSTERED	Y			39	0	0	0	2026-10-10 16:21:02	2026-07-29 08:09:18	USED	keep — in use
ASSET_Prod.dbo.RosterDaily.IX_RouteLine	2	NONCLUSTERED				33	0	0	0	2026-10-07 15:39:49	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	35	0	0	2026-10-07 15:39:49	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	32	0	0	2026-10-09 08:31:36	never	USED	KEEP — primary key
ASSET_Prod.dbo.BookingEntry.IX_ShipmentStatus	2	NONCLUSTERED				0	0	0	1362	never	2026-09-17 15:19:39	UNUSED	review, then DROP
ASSET_Prod.dbo.BookingEntry.PK_SettlementQueue	1	CLUSTERED	Y	Y		0	4287	0	1362	2026-10-10 16:32:11	never	USED	KEEP — primary key
ASSET_Prod.dbo.ReconcileMonthly.IX_ForecastDetail	2	NONCLUSTERED				0	0	0	9	never	2026-07-29 08:14:24	UNUSED	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_QuotaSummary	9	NONCLUSTERED			Y	0	0	0	9	never	2026-07-29 08:51:33	UNUSED	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.PK_SettlementDetail	1	CLUSTERED	Y	Y		0	74466	0	9	2026-10-10 16:32:19	2026-07-29 09:58:28	USED	KEEP — primary key
ASSET_Prod.dbo.ReconcileMonthly.UX_CustomerDetail	3	NONCLUSTERED	Y		Y	0	0	0	9	never	2026-07-29 08:15:18	UNUSED	review carefully — unique
ASSET_Prod.dbo.CampaignHeader.IX_SupplierResult	2	NONCLUSTERED				0	0	0	1485	never	2026-09-26 10:35:37	UNUSED	review, then DROP
ASSET_Prod.dbo.CampaignHeader.PK_ShiftHeader	1	CLUSTERED	Y	Y		172	98959	0	1655	2026-10-11 10:03:45	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	11	0	0	2026-10-06 08:39:19	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	11	0	0	2026-10-06 08:39:19	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	6519	0	0	2026-10-10 16:32:11	2026-07-29 08:16:57	USED	KEEP — primary key
ASSET_Prod.dbo.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	2697	0	0	2026-10-10 16:23:55	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	13	0	0	2026-10-07 10:37:44	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				2168	0	0	0	2026-10-10 16:32:19	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	8144	0	2026-10-10 16:31:38	2026-07-31 11:16:08	USED	KEEP — primary key
ASSET_Prod.dbo.SalesSnapshot.UX_ShiftResult	2	NONCLUSTERED	Y			8144	0	0	0	2026-10-10 16:31:38	2026-07-29 11:14:33	USED	keep — in use
ASSET_Prod.dbo.RouteHistory.PK_BillingArchive	1	CLUSTERED	Y	Y		1616	562	0	0	2026-10-10 16:31:35	2026-07-29 08:07:17	USED	KEEP — primary key