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

Host: 198.51.100.66

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

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

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

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

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

Metric	Count	Meaning
indexes_total	681	every index on a user table
used	331	had a seek, scan or lookup
unused	65	written but never read
cold	285	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	58	nonclustered, not unique, no constraint, never read
fragmented	16	above the rebuild threshold

By database

Database	Total	Cold	Droppable	Recommend action
host_726	580	221	30	review the drop candidates above
ASSET_Prod	56	35	27	review the drop candidates above
host-877	24	8	1	review the drop candidates above
host-871	21	21	0	no action — cold indexes here are constraints or clustered

Drop candidates (58)

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

Index	user_updates	last_read	State	Recommend action
host_726.schedule.RosterResult.IX_BookingAudit	372402	never	UNUSED	review, then DROP
host_726.schedule.ShiftHeader.IX_TicketStatus	174636	never	UNUSED	review, then DROP
host_726.schedule.WarehouseArchive.IX_CustomerHistory	116432	never	UNUSED	review, then DROP
host_726.schedule.RouteAudit.IX_InvoiceHeader	59100	never	UNUSED	review, then DROP
host_726.schedule.RouteAudit.IX_SettlementDetail	58216	never	UNUSED	review, then DROP
host_726.wps.ContractStatus.IX_RosterDaily	2328	never	UNUSED	review, then DROP
host_726.emp.SupplierStaging.IX_StaffingEntry	2051	never	UNUSED	review, then DROP
host_726.emp.SettlementQueue.IX_PolicyAudit	1777	never	UNUSED	review, then DROP
host_726.emp.SalesHeader.IX_BookingSummary	570	never	UNUSED	review, then DROP
host_726.emp.OrdersMonthly.IX_QuotaArchive	50	never	UNUSED	review, then DROP
host_726.emp.OrdersMonthly.IX_PayrollResult	41	never	UNUSED	review, then DROP
ASSET_Prod.dbo.ForecastDetail.IX_CampaignStatus	38	never	UNUSED	review, then DROP
ASSET_Prod.dbo.CampaignHeader.IX_SupplierResult	33	never	UNUSED	review, then DROP
host_726.org.QuotaEntry.IX_AssetHistory	24	never	UNUSED	review, then DROP
ASSET_Prod.dbo.BookingEntry.IX_ShipmentStatus	23	never	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_QuotaAudit	10	never	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_StaffingHeader	10	never	UNUSED	review, then DROP
host_726.guest.TerritoryQueue.IX_InvoiceStaging	0	never	COLD	review, then DROP
host_726.org.SupplierHistory.IX_ShipmentSummary	0	never	COLD	review, then DROP
host_726.org.BillingHeader.IX_ShiftHistory	0	never	COLD	review, then DROP
host_726.org.ShipmentSummary.IX_StaffingResult	0	never	COLD	review, then DROP
host_726.org.CustomerLine.IX_ForecastLine	0	never	COLD	review, then DROP
ASSET_Prod.dbo.RosterHeader.IX_ShipmentLog	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ContractStaging.IX_InvoiceLog	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_ForecastDetail	0	never	COLD	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_QuotaSummary	0	never	COLD	review, then DROP
ASSET_Prod.dbo.DOB.IX_CustomerSummary	0	never	COLD	review, then DROP
host_726.dbo.BatchResult.IX_ReconcileEntry	0	never	COLD	review, then DROP
host_726.dbo.BatchResult.IX_SettlementStaging	0	never	COLD	review, then DROP
host_726.dbo.OrdersSnapshot.IX_SalesQueue	0	never	COLD	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.BatchLog.IX_LedgerHistory	0	never	COLD	review, then DROP
ASSET_Prod.dbo.BatchLog.IX_TerritoryArchive	0	never	COLD	review, then DROP
host-877.app.WarehouseStatus.IX_BookingEntry	0	never	COLD	review, then DROP
host_726.wps.PolicyResult.IX_ContractSnapshot	0	never	COLD	review, then DROP
host_726.schedule.InvoiceHistory.IX_StaffingHeader	0	never	COLD	review, then DROP
host_726.dbo.CustomerArchive.IX_BillingHeader	0	never	COLD	review, then DROP
host_726.org.InvoiceStaging.IX_AssetAudit	0	never	COLD	review, then DROP
host_726.org.RosterMonthly.IX_AssetDetail	0	never	COLD	review, then DROP
host_726.sal.ClaimArchive.IX_RouteDetail	0	never	COLD	review, then DROP
host_726.oth.CustomerQueue.IX_WarehouseResult	0	never	COLD	review, then DROP
host_726.oth.StaffingArchive.IX_InvoiceStaging	0	never	COLD	review, then DROP
host_726.emp.StaffingMonthly.IX_ReconcileEntry	0	never	COLD	review, then DROP
host_726.dbo.SalesLine.IX_ReconcileResult	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.RosterDaily.IX_RouteLine	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 (16) — 16 partitions across 14 indexes

Total 1,667.0 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.RosterResult.IX_AssetStaging#p6	6/22	NONCLUSTERED	92.9%	1,004	7.8	2026-10-20 00:40:24	REBUILD
host_726.schedule.CampaignDaily.IX_BookingArchive	1/1	NONCLUSTERED	78.0%	3,345	26.1	2026-10-19 02:01:28	REBUILD
host_726.schedule.RouteAudit.IX_InvoiceHeader	1/1	NONCLUSTERED	67.5%	98,409	768.8	2026-10-19 02:22:07	REBUILD
host_726.emp.BillingAudit.IX_PolicyHeader	1/1	NONCLUSTERED	67.2%	9,800	76.6	2026-10-19 20:51:43	REBUILD
host_726.schedule.PolicyStatus.IX_SupplierLine#p6	6/22	NONCLUSTERED	63.3%	1,073	8.4	2026-10-20 00:42:34	REBUILD
host_726.emp.CampaignResult.IX_ClaimStatus	1/1	NONCLUSTERED	62.5%	37,478	292.8	2026-10-19 02:01:18	REBUILD
host_726.emp.TicketSnapshot.IX_BookingHistory	1/1	NONCLUSTERED	56.2%	12,632	98.7	2026-10-19 02:01:06	REORGANIZE
host_726.schedule.MeterStaging.IX_PayrollAudit#p11	11/22	NONCLUSTERED	48.2%	1,052	8.2	2026-10-20 00:35:26	REORGANIZE
host_726.emp.SupplierStaging.IX_StaffingSnapshot	1/1	NONCLUSTERED	45.8%	3,432	26.8	2026-10-19 02:00:44	REORGANIZE
host_726.schedule.MeterStaging.PK_PolicyArchive#p11	11/22	CLUSTERED	41.3%	2,492	19.5	2026-10-20 00:35:25	REORGANIZE
host_726.schedule.InvoiceAudit.IX_StaffingQueue#p11	11/22	NONCLUSTERED	36.0%	1,382	10.8	2026-10-20 00:39:25	REORGANIZE
host_726.emp.SupplierStaging.IX_CampaignResult	1/1	NONCLUSTERED	33.1%	2,629	20.5	2026-10-19 02:00:41	REORGANIZE
host_726.schedule.BillingDetail.IX_TicketHeader#p6	6/22	NONCLUSTERED	31.4%	1,105	8.6	2026-10-20 00:39:00	REORGANIZE
host_726.schedule.BillingDetail.IX_TicketHeader#p11	11/22	NONCLUSTERED	31.1%	20,766	162.2	2026-10-20 00:39:00	REORGANIZE
host_726.schedule.SettlementLog.IX_PolicyLine#p7	7/22	NONCLUSTERED	30.3%	1,067	8.3	2026-10-20 00:42:17	REORGANIZE
host_726.schedule.RosterResult.IX_AssetStaging#p11	11/22	NONCLUSTERED	30.3%	15,734	122.9	2026-10-20 00:40:24	REORGANIZE

All indexes (681)

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		454189	152	115153	148	2026-10-20 01:00:13	2026-10-18 02:00:00	USED	KEEP — primary key
host-877.app.Account.UX_PayrollAudit	2	NONCLUSTERED	Y			201357	0	0	128	2026-10-20 00:59:44	2026-10-19 02:00:01	USED	keep — in use
host-877.app.Account.UX_ContractSummary	7	NONCLUSTERED	Y		Y	20	0	0	20	2026-10-19 09:09:24	2026-10-18 02:00:00	USED	keep — in use
host-877.app.ReconcileDaily.PK_LedgerResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-877.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	142	never	2026-10-19 02:00:02	UNUSED	KEEP — primary key
host-877.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	10881	never	2026-10-19 02:00:02	UNUSED	KEEP — primary key
host-877.app.ForecastMonthly.IX_StaffingStatus	1	CLUSTERED				0	0	0	95	never	2026-10-19 02:00:02	UNUSED	KEEP — table storage
host-877.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		0	14209	0	0	2026-10-20 00:58:45	2026-10-18 02:00:01	USED	KEEP — primary key
host-877.app.CampaignAudit.PK_BillingMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-877.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		37313	2698	0	0	2026-10-20 00:59:44	2026-10-18 02:00:01	USED	KEEP — primary key
host-877.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:01	COLD	KEEP — primary key
host-877.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		20771	8	0	0	2026-10-20 01:00:13	2026-10-18 02:00:01	USED	KEEP — primary key
host-877.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:01	COLD	review carefully — unique
host-877.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y		2565	0	0	0	2026-10-20 00:04:09	2026-10-18 02:00:01	USED	KEEP — primary key
host-877.app.BatchQueue.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	892	0	0	2026-10-19 21:09:19	never	USED	KEEP — primary key
host-877.app.WarehouseStatus.IX_BookingEntry	9	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:00:01	COLD	review, then DROP
host-877.app.WarehouseStatus.UX_QuotaLine	2	NONCLUSTERED	Y			977	4357	0	0	2026-10-19 23:36:00	2026-10-18 02:00:02	USED	keep — in use
host-877.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		31218	0	0	0	2026-10-20 00:59:44	2026-10-18 02:00:02	USED	KEEP — primary key
host-877.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:02	COLD	KEEP — primary key
host-877.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		18289	99281	0	0	2026-10-20 00:59:44	2026-10-18 02:00:02	USED	KEEP — primary key
host-877.app.Permission.PK_ClaimHeader	1	CLUSTERED	Y	Y		16540	29364	0	0	2026-10-20 01:00:13	2026-10-18 02:00:02	USED	KEEP — primary key
host-877.app.Permission.UX_RouteQueue	2	NONCLUSTERED	Y			895	0	0	0	2026-10-19 21:09:19	2026-10-18 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-18 02:23:32	COLD	KEEP — primary key
host-871.app.Account.UX_PayrollAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:32	COLD	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-18 02:23:32	COLD	KEEP — primary key
host-871.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:32	COLD	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-18 02:23:32	COLD	KEEP — primary key
host-871.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:32	COLD	KEEP — primary key
host-871.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:32	COLD	KEEP — primary key
host-871.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:32	COLD	review carefully — unique
host-871.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:32	COLD	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-18 02:23:32	COLD	review carefully — unique
host-871.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:33	COLD	KEEP — primary key
host-871.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:33	COLD	KEEP — primary key
host-871.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:33	COLD	KEEP — primary key
host-871.app.Permission.PK_ClaimHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:33	COLD	KEEP — primary key
host-871.app.Permission.UX_RouteQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:33	COLD	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	0	0	0	never	2026-10-18 02:00:03	COLD	KEEP — primary key
host_726.cfg.QuotaStatus.UX_MeterSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:03	COLD	review carefully — unique
host_726.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		0	221	0	221	2026-10-20 00:35:17	2026-10-18 02:00:03	USED	KEEP — primary key
host_726.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	221	never	2026-10-19 02:00:04	UNUSED	KEEP — primary key
host_726.dbo.Jobs.PK_RosterStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:03	COLD	KEEP — primary key
host_726.dbo.Jobs.UQ_ContractMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:03	COLD	review carefully — unique
host_726.dbo.Keys.PK_BookingDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.OrdersSnapshot.IX_SalesQueue	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:00:03	COLD	review, then DROP
host_726.dbo.OrdersSnapshot.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:03	COLD	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	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.InvoiceSummary.PK_LedgerResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:04	COLD	KEEP — primary key
host_726.dbo.CustomerSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:04	COLD	KEEP — primary key
host_726.dbo.QuotaResult.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:04	COLD	KEEP — primary key
host_726.dbo.LedgerResult.PK_ForecastMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.BatchResult.IX_SettlementStaging	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:00:04	COLD	review, then DROP
host_726.dbo.BatchResult.IX_ReconcileEntry	3	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:00:04	COLD	review, then DROP
host_726.dbo.BatchResult.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:04	COLD	KEEP — primary key
host_726.dbo.PricingLog.PK_RouteLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.ClaimArchive.PK_StaffingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:04	COLD	KEEP — primary key
host_726.dbo.ClaimArchive.UQ_SupplierResult	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.CustomerArchive.IX_BillingHeader	3	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:00:04	COLD	review, then DROP
host_726.dbo.CustomerArchive.PK_AssetSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:04	COLD	KEEP — primary key
host_726.dbo.CustomerArchive.UQ_OrdersMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.Status.PK_ShiftLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:04	COLD	KEEP — primary key
host_726.dbo.Status.UQ_PricingHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.SupplierDetail.PK_ShiftResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.CampaignResult.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.TicketQueue.PK_CampaignEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.BookingStatus.PK_StaffingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:04	COLD	KEEP — primary key
host_726.dbo.BookingStatus.UQ_CatalogSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.BookingStatus.UQ_ContractEntry	3	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.BookingStatus.UQ_RouteLine	4	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.BillingHistory.PK_PayrollHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:04	COLD	KEEP — primary key
host_726.dbo.TicketQueue.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:04	COLD	KEEP — primary key
host_726.dbo.StaffingStaging.PK_SettlementHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.dbo.WarehouseEntry.PK_ShiftStatus	1	CLUSTERED	Y	Y		54856	155	0	0	2026-10-20 00:59:45	2026-10-18 02:00:04	USED	KEEP — primary key
host_726.dbo.WarehouseEntry.UX_CampaignHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.TicketSummary.PK_SalesLine	1	CLUSTERED				0	760	0	0	2026-10-19 18:14:04	2026-10-18 02:00:04	USED	KEEP — table storage
host_726.dbo.TerritoryEntry.PK_SalesSummary	1	CLUSTERED	Y	Y		34090	54	0	0	2026-10-20 00:59:45	2026-10-18 02:00:04	USED	KEEP — primary key
host_726.dbo.TerritoryEntry.UX_TerritoryQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.PolicyEntry.PK_TicketEntry	1	CLUSTERED	Y	Y		16474	158	0	0	2026-10-20 00:59:45	2026-10-18 02:00:04	USED	KEEP — primary key
host_726.dbo.PolicyEntry.UX_PolicyAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.CampaignHeader.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y		20953	172	0	0	2026-10-20 00:59:45	2026-10-18 02:00:04	USED	KEEP — primary key
host_726.dbo.CampaignHeader.UX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.WarehouseHeader.PK_OrdersQueue	1	CLUSTERED	Y	Y		0	87	0	0	2026-10-19 18:14:03	2026-10-18 02:00:04	USED	KEEP — primary key
host_726.dbo.WarehouseHeader.UX_TicketQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.RouteQueue.PK_SupplierAudit	1	CLUSTERED	Y	Y		35685	54	0	0	2026-10-20 00:59:45	2026-10-18 02:00:04	USED	KEEP — primary key
host_726.dbo.RouteQueue.UX_CampaignQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.CampaignAudit.PK_BatchSnapshot	1	CLUSTERED	Y	Y		16471	158	0	0	2026-10-20 00:59:45	2026-10-18 02:00:04	USED	KEEP — primary key
host_726.dbo.CampaignAudit.UX_SupplierArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbo.ShiftDaily.PK_ReconcileStatus	1	CLUSTERED	Y	Y		35851	54	0	0	2026-10-20 00:59:45	2026-10-18 02:00:04	USED	KEEP — primary key
host_726.dbo.ShiftDaily.UX_RouteDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:04	COLD	review carefully — unique
host_726.dbs.ShipmentStatus.UX_StaffingLog	8	NONCLUSTERED	Y		Y	2	0	0	2	2026-10-19 20:00:02	2026-10-18 02:00:04	USED	keep — in use
host_726.emp.WarehouseMonthly.PK_PricingHistory	1	CLUSTERED	Y	Y		498	1231	0	0	2026-10-20 00:35:04	2026-10-18 02:00:05	USED	KEEP — primary key
host_726.emp.WarehouseMonthly.UX_CustomerDetail	2	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-10-18 02:00:05	COLD	review carefully — unique
host_726.emp.SettlementLine.PK_LedgerAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:05	COLD	KEEP — primary key
host_726.emp.SalesDetail.PK_BillingLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:05	COLD	KEEP — primary key
host_726.emp.BatchMonthly.PK_TicketAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:05	COLD	KEEP — primary key
host_726.emp.RosterLog.PK_QuotaLog	1	CLUSTERED	Y	Y		14236	0	0	7118	2026-10-20 00:58:50	2026-10-18 02:00:05	USED	KEEP — primary key
host_726.emp.QuotaMonthly.IX_ShipmentEntry	2	NONCLUSTERED				21637	0	0	123	2026-10-20 00:59:45	2026-10-19 02:00:04	USED	keep — in use
host_726.emp.QuotaMonthly.PK_ReconcileDetail	1	CLUSTERED	Y	Y		123	67	21637	123	2026-10-20 00:59:45	2026-10-18 02:00:05	USED	KEEP — primary key
host_726.emp.OrdersEntry.PK_PolicyHeader	1	CLUSTERED	Y	Y		0	0	0	121	never	2026-10-19 02:00:05	UNUSED	KEEP — primary key
host_726.emp.PayrollSummary.PK_RouteSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:07	COLD	KEEP — primary key
host_726.emp.SettlementAudit.PK_ShiftStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:07	COLD	KEEP — primary key
host_726.emp.InvoiceLog.PK_BatchEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.InvoiceMonthly.PK_RouteEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.InvoiceMonthly.UX_CustomerSnapshot	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host_726.emp.CampaignEntry.PK_TicketMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.CampaignEntry.UX_CatalogHistory	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host_726.emp.RouteHistory.PK_CustomerMonthly	1	CLUSTERED	Y	Y		6	10	0	0	2026-10-20 00:00:02	2026-10-18 02:00:07	USED	KEEP — primary key
host_726.emp.RouteHistory.UX_CustomerQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:07	COLD	review carefully — unique
host_726.emp.CustomerHistory.PK_ShiftDaily	1	CLUSTERED	Y	Y		4	0	0	0	2026-10-19 15:44:20	2026-10-18 02:00:07	USED	KEEP — primary key
host_726.emp.ForecastEntry.PK_SettlementLog	1	CLUSTERED	Y	Y		0	34054	0	0	2026-10-20 00:59:26	2026-10-18 02:00:07	USED	KEEP — primary key
host_726.emp.ClaimQueue.PK_TerritoryResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:07	COLD	KEEP — primary key
host_726.emp.PolicyAudit.PK_ContractAudit	1	CLUSTERED	Y	Y		0	61059	0	0	2026-10-20 00:59:26	2026-10-18 02:00:07	USED	KEEP — primary key
host_726.emp.ShipmentSummary.PK_ShiftAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:08	COLD	KEEP — primary key
host_726.emp.BatchArchive.PK_ClaimHistory	1	CLUSTERED	Y	Y		27069	34022	0	0	2026-10-20 00:59:26	2026-10-18 02:00:08	USED	KEEP — primary key
host_726.emp.RosterSnapshot.PK_PolicyStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:08	COLD	KEEP — primary key
host_726.emp.MeterResult.IX_LedgerQueue	2	NONCLUSTERED				0	7294	0	63	2026-10-20 00:00:00	2026-10-19 02:00:06	USED	keep — in use
host_726.emp.MeterResult.PK_CustomerResult	1	CLUSTERED	Y	Y		266833	7488	0	63	2026-10-20 00:59:45	2026-10-18 02:00:08	USED	KEEP — primary key
host_726.emp.PayrollHeader.PK_TicketHistory	1	CLUSTERED	Y	Y		16532	18	0	63	2026-10-20 00:59:45	2026-10-18 02:00:08	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	4	0	0	2026-10-20 00:00:03	2026-10-18 02:00:08	USED	KEEP — primary key
host_726.emp.RouteHeader.PK_StaffingQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:08	COLD	KEEP — primary key
host_726.emp.MeterAudit.PK_ClaimLog	1	CLUSTERED	Y	Y		27	8684	0	27	2026-10-20 00:41:27	2026-10-18 02:00:08	USED	KEEP — primary key
host_726.emp.QuotaStatus.PK_OrdersArchive	1	CLUSTERED	Y	Y		0	0	0	3	never	2026-10-18 02:00:08	UNUSED	KEEP — primary key
host_726.emp.ShiftLine.IX_PricingAudit	3	NONCLUSTERED				6	0	0	0	2026-10-19 18:07:44	2026-10-18 02:00:09	USED	keep — in use
host_726.emp.ShiftLine.PK_SettlementStatus	1	CLUSTERED	Y	Y		0	9	6	3	2026-10-20 00:00:03	2026-10-18 02:00:09	USED	KEEP — primary key
host_726.emp.ShiftLine.UX_BookingDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:09	COLD	review carefully — unique
host_726.emp.CampaignHeader.PK_BillingQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.MeterStatus.PK_BillingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.WarehouseStaging.PK_CustomerEntry	1	CLUSTERED	Y	Y		0	0	0	3	never	2026-10-19 02:00:06	UNUSED	KEEP — primary key
host_726.emp.ForecastHeader.IX_WarehouseResult	2	NONCLUSTERED				833	0	0	3	2026-10-19 18:14:03	2026-10-18 02:00:09	USED	keep — in use
host_726.emp.ForecastHeader.PK_OrdersAudit	1	CLUSTERED	Y	Y		3	2	833	3	2026-10-19 18:14:03	2026-10-18 02:00:09	USED	KEEP — primary key
host_726.emp.SalesLog.PK_AssetStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:09	COLD	KEEP — primary key
host_726.emp.AssetDaily.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	1543	0	0	2026-10-19 18:14:04	2026-10-18 02:00:09	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				799	0	0	0	2026-10-19 18:14:03	2026-10-18 02:00:09	USED	keep — in use
host_726.emp.PricingDaily.PK_RouteEntry	1	CLUSTERED	Y	Y		0	22	799	0	2026-10-19 18:14:03	2026-10-18 02:00:09	USED	KEEP — primary key
host_726.emp.PolicyLog.PK_LedgerHistory	1	CLUSTERED	Y	Y		63	22	16471	63	2026-10-20 00:59:45	2026-10-18 02:00:09	USED	KEEP — primary key
host_726.emp.PolicyLog.UX_OrdersSnapshot	2	NONCLUSTERED	Y			16471	2	0	63	2026-10-20 00:59:45	2026-10-19 02:00:07	USED	keep — in use
host_726.emp.RouteAudit.PK_ClaimResult	1	CLUSTERED	Y	Y		0	0	0	3	never	2026-10-18 02:00:10	UNUSED	KEEP — primary key
host_726.emp.PayrollDaily.IX_BillingStaging	2	NONCLUSTERED				3	0	0	18	2026-10-19 15:44:20	2026-10-18 02:00:10	USED	keep — in use
host_726.emp.PayrollDaily.PK_OrdersSnapshot	1	CLUSTERED	Y	Y		0	3	0	18	2026-10-19 15:44:20	2026-10-18 02:00:10	USED	KEEP — primary key
host_726.emp.MeterHistory.IX_ContractArchive	17	NONCLUSTERED				436	138	0	86	2026-10-20 00:41:43	2026-10-19 02:00:07	USED	keep — in use
host_726.emp.MeterHistory.PK_BatchLog	1	CLUSTERED	Y	Y		534179	12336	243351	86	2026-10-20 01:00:06	2026-10-18 02:00:10	USED	KEEP — primary key
host_726.emp.MeterHistory.UX_BatchLog	2	NONCLUSTERED	Y		Y	0	0	0	86	never	2026-10-19 02:00:07	UNUSED	review carefully — unique
host_726.emp.MeterHistory.UX_ForecastHeader	20	NONCLUSTERED	Y			48991	108	0	86	2026-10-20 00:59:45	2026-10-19 02:00:07	USED	keep — in use
host_726.emp.MeterHistory.UX_CustomerSnapshot	3	NONCLUSTERED	Y		Y	4	24	0	86	2026-10-19 22:40:28	2026-10-19 02:00:07	USED	keep — in use
host_726.emp.MeterHistory.UX_QuotaStaging	4	NONCLUSTERED	Y			320382	54	0	86	2026-10-20 00:59:45	2026-10-19 02:00:07	USED	keep — in use
host_726.emp.ShiftSnapshot.IX_ForecastAudit	1	CLUSTERED				0	0	0	86	never	2026-10-19 02:00:08	UNUSED	KEEP — table storage
host_726.emp.TerritoryLine.PK_LedgerArchive	1	CLUSTERED	Y	Y		7945	3247	0	1778	2026-10-20 00:52:12	2026-10-18 02:00:12	USED	KEEP — primary key
host_726.emp.SalesStaging.PK_PolicyDaily	1	CLUSTERED	Y	Y		1164	49	0	234	2026-10-20 00:09:34	2026-10-18 02:00:12	USED	KEEP — primary key
host_726.emp.TerritoryDaily.PK_MeterLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:00:13	COLD	KEEP — primary key
host_726.emp.SettlementQueue.IX_PolicyAudit	2	NONCLUSTERED				0	0	0	1777	never	2026-10-19 02:00:09	UNUSED	review, then DROP
host_726.emp.SettlementQueue.PK_SalesEntry	1	CLUSTERED	Y	Y		0	4	0	1777	2026-10-19 18:07:46	2026-10-19 02:00:09	USED	KEEP — primary key
host_726.emp.StaffingMonthly.IX_ReconcileEntry	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:00:14	COLD	review, then DROP
host_726.emp.StaffingMonthly.IX_SalesQueue	3	NONCLUSTERED				1501	0	0	0	2026-10-19 22:40:28	2026-10-18 02:00:14	USED	keep — in use
host_726.emp.StaffingMonthly.PK_CampaignStatus	1	CLUSTERED	Y	Y		0	2358	159	0	2026-10-19 18:59:26	2026-10-18 02:00:14	USED	KEEP — primary key
host_726.emp.TicketQueue.PK_BatchDaily	1	CLUSTERED	Y	Y		0	0	833	120	2026-10-19 18:14:03	2026-10-18 02:00:14	USED	KEEP — primary key
host_726.emp.TicketQueue.UX_PayrollDaily	2	NONCLUSTERED	Y			833	0	0	120	2026-10-19 18:14:03	2026-10-18 02:00:14	USED	keep — in use
host_726.emp.MeterStatus.PK_CustomerDetail	1	CLUSTERED	Y	Y		0	0	0	120	never	2026-10-19 02:00:10	UNUSED	KEEP — primary key
host_726.emp.OrdersEntry.PK_TerritoryAudit	1	CLUSTERED	Y	Y		0	809	0	0	2026-10-19 18:14:04	2026-10-18 02:00:14	USED	KEEP — primary key
host_726.emp.InvoiceLog.PK_BillingDetail	1	CLUSTERED	Y	Y		0	0	0	85	never	2026-10-19 02:00:11	UNUSED	KEEP — primary key
host_726.emp.CampaignHistory.IX_QuotaDetail	2	NONCLUSTERED				297553	0	0	14	2026-10-20 01:00:24	2026-10-18 02:00:16	USED	keep — in use
host_726.emp.CampaignHistory.PK_AssetHeader	1	CLUSTERED	Y	Y		4	7643	297553	14	2026-10-20 01:00:24	2026-10-18 02:00:16	USED	KEEP — primary key
host_726.emp.ContractArchive.PK_BookingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.emp.RosterStaging.IX_ClaimLine	1	CLUSTERED				0	0	0	4	never	2026-10-18 02:00:16	UNUSED	KEEP — table storage
host_726.emp.TicketLine.PK_CampaignEntry	1	CLUSTERED	Y	Y		33	0	0	0	2026-10-19 18:07:46	2026-10-18 02:00:16	USED	KEEP — primary key
host_726.emp.BatchAudit.IX_PolicyArchive	20	NONCLUSTERED				50961	71	0	112776	2026-10-20 01:00:06	2026-10-19 02:00:12	USED	keep — in use
host_726.emp.BatchAudit.PK_ForecastSummary	1	CLUSTERED	Y	Y		225073	710	377359	150200	2026-10-20 01:00:06	2026-10-19 02:00:12	USED	KEEP — primary key
host_726.emp.BatchAudit.UX_LedgerStaging	2	NONCLUSTERED	Y			454291	0	0	112776	2026-10-20 01:00:06	2026-10-19 02:00:12	USED	keep — in use
host_726.emp.ClaimAudit.PK_LedgerDaily	1	CLUSTERED	Y	Y		0	0	0	760	never	never	UNUSED	KEEP — primary key
host_726.emp.ClaimAudit.UX_RouteMonthly	2	NONCLUSTERED	Y			376	384	0	760	2026-10-20 00:43:43	never	USED	keep — in use
host_726.emp.PolicyHistory.PK_OrdersDaily	1	CLUSTERED	Y	Y		74720	82	0	112180	2026-10-20 00:59:00	2026-10-20 00:43:34	USED	KEEP — primary key
host_726.emp.BillingEntry.PK_StaffingAudit	1	CLUSTERED	Y	Y		0	94	0	74712	2026-10-20 00:09:25	2026-10-19 20:07:07	USED	KEEP — primary key
host_726.emp.BillingEntry.UX_StaffingLog	2	NONCLUSTERED	Y			37244	0	0	74712	2026-10-20 00:59:00	2026-10-19 20:07:07	USED	keep — in use
host_726.emp.BillingAudit.IX_PolicyHeader	8	NONCLUSTERED				13340	0	0	74712	2026-10-20 00:56:09	2026-10-19 20:51:43	USED	keep — in use
host_726.emp.BillingAudit.PK_PolicyDetail	1	CLUSTERED	Y	Y		0	3	2	74712	2026-10-19 18:07:44	2026-10-19 20:51:43	USED	KEEP — primary key
host_726.emp.BillingAudit.UX_SupplierSnapshot	2	NONCLUSTERED	Y			37244	0	0	74712	2026-10-20 00:59:00	2026-10-19 20:51:42	USED	keep — in use
host_726.emp.ShipmentStaging.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	2	0	37244	2026-10-19 18:07:44	never	USED	KEEP — primary key
host_726.emp.ShipmentStaging.UX_RosterDaily	2	NONCLUSTERED	Y			376	36868	0	37244	2026-10-20 00:59:00	never	USED	keep — in use
host_726.emp.SalesLine.PK_CampaignResult	1	CLUSTERED	Y	Y		99776	7	0	112164	2026-10-20 00:59:00	2026-10-19 22:37:03	USED	KEEP — primary key
host_726.emp.LedgerSnapshot.PK_CampaignStatus	1	CLUSTERED	Y	Y		0	0	0	62	never	2026-10-19 02:00:31	UNUSED	KEEP — primary key
host_726.emp.ReconcileDetail.PK_CampaignQueue	1	CLUSTERED	Y	Y		23	933	0	26	2026-10-19 18:14:03	2026-10-18 02:00:33	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		30	101	0	0	2026-10-19 18:14:03	2026-10-18 02:00:33	USED	KEEP — primary key
host_726.emp.ReconcileStaging.UX_OrdersHistory	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:00:33	COLD	review carefully — unique
host_726.emp.MeterStatus.PK_ReconcileMonthly	1	CLUSTERED	Y	Y		37	29	28883	37	2026-10-20 00:59:45	2026-10-18 02:00:33	USED	KEEP — primary key
host_726.emp.MeterStatus.UX_ReconcileAudit	4	NONCLUSTERED	Y			28883	0	0	37	2026-10-20 00:59:45	2026-10-19 02:00:32	USED	keep — in use
host_726.emp.PricingAudit.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		0	0	0	3	never	2026-10-18 02:00:34	UNUSED	KEEP — primary key
host_726.emp.OrdersMonthly.IX_QuotaArchive	2	NONCLUSTERED			Y	0	0	0	50	never	2026-10-19 02:00:32	UNUSED	review, then DROP
host_726.emp.OrdersMonthly.IX_PayrollResult	3	NONCLUSTERED			Y	0	0	0	41	never	2026-10-19 02:00:32	UNUSED	review, then DROP
host_726.emp.OrdersMonthly.IX_TicketSnapshot	4	NONCLUSTERED				27894	0	0	98	2026-10-20 00:59:22	2026-10-19 02:00:32	USED	keep — in use
host_726.emp.OrdersMonthly.IX_SettlementLine	5	NONCLUSTERED				1	0	0	98	2026-10-19 10:42:19	2026-10-19 02:00:32	USED	keep — in use
host_726.emp.OrdersMonthly.PK_ShipmentSnapshot	1	CLUSTERED	Y	Y		376	40	0	98	2026-10-20 00:52:58	2026-10-19 02:00:32	USED	KEEP — primary key
host_726.emp.RosterQueue.PK_SettlementHistory	1	CLUSTERED	Y	Y		7884	381	0	0	2026-10-20 00:41:27	2026-10-18 02:00:35	USED	KEEP — primary key
host_726.emp.BatchResult.IX_BillingQueue	6	NONCLUSTERED				5257	0	0	1350	2026-10-20 00:35:17	2026-10-19 02:00:33	USED	keep — in use
host_726.emp.BatchResult.PK_InvoiceSummary	1	CLUSTERED	Y	Y		0	0	0	1350	never	2026-10-19 02:00:32	UNUSED	KEEP — primary key
host_726.emp.TicketAudit.IX_LedgerLog	2	NONCLUSTERED				3	0	0	74	2026-10-19 13:13:08	2026-10-19 02:00:34	USED	keep — in use
host_726.emp.TicketAudit.PK_LedgerStatus	1	CLUSTERED	Y	Y		0	0	3	74	2026-10-19 13:13:08	2026-10-19 02:00:34	USED	KEEP — primary key
host_726.emp.InvoiceResult.PK_ShipmentMonthly	1	CLUSTERED	Y	Y		0	0	0	74	never	2026-10-19 02:00:35	UNUSED	KEEP — primary key
host_726.emp.CustomerLog.IX_PolicyDaily	18	NONCLUSTERED				0	1102	0	774	2026-10-20 00:40:17	2026-10-19 02:00:35	USED	keep — in use
host_726.emp.CustomerLog.IX_PayrollResult	21	NONCLUSTERED				877103	79786	0	1547	2026-10-20 01:00:23	2026-10-19 02:00:35	USED	keep — in use
host_726.emp.CustomerLog.PK_StaffingDaily	1	CLUSTERED	Y	Y		331441	182	956829	1547	2026-10-20 01:00:24	2026-10-19 02:00:35	USED	KEEP — primary key
host_726.emp.InvoiceAudit.IX_SettlementResult	10	NONCLUSTERED				27943	3071	0	1043	2026-10-20 00:59:22	2026-10-19 02:00:37	USED	keep — in use
host_726.emp.InvoiceAudit.PK_QuotaEntry	1	CLUSTERED	Y	Y		0	17	2766	1043	2026-10-20 00:55:23	2026-10-19 02:00:36	USED	KEEP — primary key
host_726.emp.MeterSummary.PK_AssetEntry	1	CLUSTERED	Y	Y		0	0	0	739	never	2026-10-19 02:00:38	UNUSED	KEEP — primary key
host_726.emp.BatchDaily.IX_SupplierStatus	1	CLUSTERED				0	0	0	1262	never	2026-10-19 02:00:38	UNUSED	KEEP — table storage
host_726.emp.AssetSummary.PK_SupplierStaging	1	CLUSTERED	Y	Y		0	1	0	774	2026-10-19 01:15:17	2026-10-19 02:00:39	USED	KEEP — primary key
host_726.emp.SupplierStaging.IX_CampaignResult	24	NONCLUSTERED				0	7	0	2257	2026-10-19 10:54:19	2026-10-19 02:00:41	USED	keep — in use
host_726.emp.SupplierStaging.IX_StaffingSnapshot	30	NONCLUSTERED				308463	60	0	2257	2026-10-20 01:00:24	2026-10-19 02:00:44	USED	keep — in use
host_726.emp.SupplierStaging.IX_MeterStaging	16	NONCLUSTERED				27	0	0	2007	2026-10-19 15:03:19	2026-10-19 02:00:44	USED	keep — in use
host_726.emp.SupplierStaging.IX_StaffingEntry	25	NONCLUSTERED				0	0	0	2051	never	2026-10-19 02:00:44	UNUSED	review, then DROP
host_726.emp.SupplierStaging.PK_PayrollMonthly	1	CLUSTERED	Y	Y		251539	593	194274	2257	2026-10-20 01:00:24	2026-10-19 02:00:40	USED	KEEP — primary key
host_726.emp.SupplierStaging.IX_OrdersSnapshot	26	NONCLUSTERED	Y			5871	0	0	987	2026-10-20 00:31:51	2026-10-19 02:00:44	USED	keep — in use
host_726.emp.CustomerStatus.IX_ReconcileLine	10	NONCLUSTERED				33069	13776	0	3296	2026-10-20 00:59:22	2026-10-19 02:00:45	USED	keep — in use
host_726.emp.CustomerStatus.PK_PolicyHistory	1	CLUSTERED	Y	Y		0	57	12843	3296	2026-10-20 00:58:42	2026-10-19 02:00:45	USED	KEEP — primary key
host_726.emp.BillingAudit.PK_CustomerEntry	1	CLUSTERED	Y	Y		0	0	0	2364	never	2026-10-19 02:00:46	UNUSED	KEEP — primary key
host_726.emp.PolicyLine.PK_OrdersSummary	1	CLUSTERED	Y	Y		2	2700	0	6	2026-10-20 00:58:42	2026-10-19 02:00:46	USED	KEEP — primary key
host_726.emp.RouteStaging.PK_WarehouseLine	1	CLUSTERED	Y	Y		0	983	0	0	2026-10-20 00:16:28	2026-10-18 02:00:51	USED	KEEP — primary key
host_726.emp.CampaignMonthly.PK_OrdersArchive	1	CLUSTERED	Y	Y		0	1867	0	125	2026-10-20 00:58:42	2026-10-19 02:00:46	USED	KEEP — primary key
host_726.emp.CatalogSnapshot.PK_ClaimHistory	1	CLUSTERED	Y	Y		0	18	0	0	2026-10-19 19:22:06	2026-10-18 02:00:51	USED	KEEP — primary key
host_726.emp.TerritoryMonthly.IX_LedgerMonthly	1	CLUSTERED				0	0	0	1373	never	2026-10-19 02:00:47	UNUSED	KEEP — table storage
host_726.emp.BillingDaily.PK_CustomerLine	1	CLUSTERED	Y	Y		0	1020	1300	1574	2026-10-19 23:29:26	2026-10-19 02:00:47	USED	KEEP — primary key
host_726.emp.BillingDaily.UX_LedgerDaily	2	NONCLUSTERED	Y			1351	0	0	1574	2026-10-19 23:29:26	2026-10-19 02:00:48	USED	keep — in use
host_726.emp.SupplierHistory.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	1	0	2343	2026-10-19 01:15:00	2026-10-19 02:00:48	USED	KEEP — primary key
host_726.emp.ShipmentMonthly.IX_SupplierEntry	11	NONCLUSTERED				40807	0	0	29767	2026-10-20 00:59:22	2026-10-19 02:00:50	USED	keep — in use
host_726.emp.ShipmentMonthly.IX_InvoiceStaging	2	NONCLUSTERED				57404	0	0	29767	2026-10-20 00:57:59	2026-10-19 02:00:50	USED	keep — in use
host_726.emp.ShipmentMonthly.PK_BatchDaily	1	CLUSTERED	Y	Y		318	62	44967	30085	2026-10-20 00:57:59	2026-10-19 02:00:50	USED	KEEP — primary key
host_726.emp.AssetDetail.PK_ReconcileResult	1	CLUSTERED	Y	Y		0	0	0	13068	never	2026-10-19 02:00:52	UNUSED	KEEP — primary key
host_726.emp.AssetSnapshot.IX_ForecastStatus	5	NONCLUSTERED				117283	332	0	14617	2026-10-20 00:59:00	2026-10-19 02:00:53	USED	keep — in use
host_726.emp.AssetSnapshot.IX_SalesDaily	2	NONCLUSTERED				380547	2142	0	14617	2026-10-20 01:00:24	2026-10-19 02:00:56	USED	keep — in use
host_726.emp.AssetSnapshot.PK_OrdersDetail	1	CLUSTERED	Y	Y		10628	0	26676	14617	2026-10-20 00:58:02	2026-10-19 02:00:53	USED	KEEP — primary key
host_726.emp.PricingStatus.PK_PolicyStatus	1	CLUSTERED	Y	Y		0	0	0	14617	never	2026-10-19 02:00:57	UNUSED	KEEP — primary key
host_726.emp.TicketSnapshot.IX_BookingHistory	15	NONCLUSTERED				0	446	0	14446	2026-10-19 18:10:08	2026-10-19 02:01:06	USED	keep — in use
host_726.emp.TicketSnapshot.PK_CampaignQueue	1	CLUSTERED	Y	Y		395993	28777	1	14446	2026-10-20 01:00:24	2026-10-19 02:00:58	USED	KEEP — primary key
host_726.emp.TicketSnapshot.IX_ContractEntry	19	NONCLUSTERED	Y			26840	265	0	14446	2026-10-20 00:58:02	2026-10-19 02:01:06	USED	keep — in use
host_726.emp.MeterEntry.IX_OrdersAudit	1	CLUSTERED				0	1	0	9199	2026-10-19 14:46:48	2026-10-19 02:01:08	USED	KEEP — table storage
host_726.emp.ForecastMonthly.PK_CampaignSummary	1	CLUSTERED	Y	Y		0	1	0	14443	2026-10-19 01:15:01	2026-10-19 02:01:08	USED	KEEP — primary key
host_726.emp.PricingStatus.IX_QuotaLog	7	NONCLUSTERED				424	0	0	5678	2026-10-19 09:38:00	2026-10-19 02:01:11	USED	keep — in use
host_726.emp.PricingStatus.IX_ClaimEntry	2	NONCLUSTERED				263363	2944	0	5678	2026-10-20 01:00:21	2026-10-19 02:01:11	USED	keep — in use
host_726.emp.PricingStatus.PK_LedgerResult	1	CLUSTERED	Y	Y		205305	24	426	5678	2026-10-20 01:00:24	2026-10-19 02:01:11	USED	KEEP — primary key
host_726.emp.AssetDaily.IX_PayrollDaily	1	CLUSTERED				0	2	0	60	2026-10-19 14:46:32	2026-10-19 02:01:12	USED	KEEP — table storage
host_726.emp.PayrollHistory.PK_LedgerQueue	1	CLUSTERED	Y	Y		0	0	0	5678	never	2026-10-19 02:01:12	UNUSED	KEEP — primary key
host_726.emp.QuotaSummary.IX_StaffingQueue	10	NONCLUSTERED				27686	7023	0	1302	2026-10-20 00:59:22	2026-10-19 02:01:12	USED	keep — in use
host_726.emp.QuotaSummary.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	17	6730	1302	2026-10-20 00:58:51	2026-10-19 02:01:12	USED	KEEP — primary key
host_726.emp.PricingQueue.PK_PricingStaging	1	CLUSTERED	Y	Y		0	0	0	1010	never	2026-10-19 02:01:13	UNUSED	KEEP — primary key
host_726.emp.BookingMonthly.IX_ShipmentAudit	5	NONCLUSTERED				35381	174582	0	587	2026-10-20 01:00:22	2026-10-19 02:01:13	USED	keep — in use
host_726.emp.BookingMonthly.PK_WarehouseLog	1	CLUSTERED	Y	Y		0	0	0	587	never	2026-10-19 02:01:13	UNUSED	KEEP — primary key
host_726.emp.MeterSnapshot.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	0	0	587	never	2026-10-19 02:01:14	UNUSED	KEEP — primary key
host_726.emp.BatchMonthly.IX_ClaimSummary	18	NONCLUSTERED				0	25	0	585	2026-10-19 17:38:45	2026-10-19 02:01:14	USED	keep — in use
host_726.emp.BatchMonthly.PK_InvoiceDetail	1	CLUSTERED	Y	Y		382704	5505	24	585	2026-10-20 01:00:24	2026-10-19 02:01:14	USED	KEEP — primary key
host_726.emp.BatchMonthly.IX_TerritorySnapshot	19	NONCLUSTERED	Y			994	0	0	585	2026-10-20 00:40:43	2026-10-19 02:01:14	USED	keep — in use
host_726.emp.WarehouseMonthly.IX_InvoiceStatus	1	CLUSTERED				0	0	0	300	never	2026-10-19 02:01:15	UNUSED	KEEP — table storage
host_726.emp.StaffingAudit.PK_ForecastHeader	1	CLUSTERED	Y	Y		0	1	0	592	2026-10-19 01:15:14	2026-10-19 02:01:16	USED	KEEP — primary key
host_726.emp.BatchLog.PK_SalesDetail	1	CLUSTERED	Y	Y		180441	175411	0	1022	2026-10-20 01:00:24	2026-10-19 02:01:17	USED	KEEP — primary key
host_726.emp.ReconcileSummary.IX_ShipmentDetail	1	CLUSTERED				0	0	0	2	never	2026-10-19 02:01:17	UNUSED	KEEP — table storage
host_726.emp.RouteHistory.PK_MeterEntry	1	CLUSTERED	Y	Y		0	0	0	1022	never	2026-10-19 02:01:17	UNUSED	KEEP — primary key
host_726.emp.CampaignResult.IX_ClaimStatus	15	NONCLUSTERED				196199	0	0	112	2026-10-20 01:00:24	2026-10-19 02:01:18	USED	keep — in use
host_726.emp.CampaignResult.IX_CustomerQueue	6	NONCLUSTERED				294361	0	0	224	2026-10-20 01:00:24	2026-10-19 02:01:18	USED	keep — in use
host_726.emp.CampaignResult.PK_StaffingArchive	1	CLUSTERED	Y	Y		238803	754	490490	235	2026-10-20 01:00:24	2026-10-19 02:01:18	USED	KEEP — primary key
host_726.emp.SalesHeader.IX_BookingSummary	2	NONCLUSTERED				0	0	0	570	never	2026-10-19 02:01:23	UNUSED	review, then DROP
host_726.emp.SalesHeader.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	0	0	570	never	2026-10-19 02:01:23	UNUSED	KEEP — primary key
host_726.emp.PayrollHistory.PK_CampaignStaging	1	CLUSTERED	Y	Y		914	0	0	64	2026-10-19 18:16:54	2026-10-19 02:01:20	USED	KEEP — primary key
host_726.emp.TerritoryDaily.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	62	never	2026-10-19 02:01:20	UNUSED	KEEP — primary key
host_726.emp.CatalogSummary.IX_PricingSnapshot	27	NONCLUSTERED				12251	79	0	176	2026-10-20 00:58:50	2026-10-19 02:01:21	USED	keep — in use
host_726.emp.CatalogSummary.IX_WarehouseSnapshot	7	NONCLUSTERED				17021	833	0	130	2026-10-20 00:59:45	2026-10-19 02:01:21	USED	keep — in use
host_726.emp.CatalogSummary.IX_ReconcileSummary	21	NONCLUSTERED				122013	0	0	130	2026-10-20 00:59:26	2026-10-19 02:01:21	USED	keep — in use
host_726.emp.CatalogSummary.IX_AssetEntry	26	NONCLUSTERED				51812	248	0	176	2026-10-20 00:59:26	2026-10-19 02:01:21	USED	keep — in use
host_726.emp.CatalogSummary.PK_ShipmentStaging	1	CLUSTERED	Y	Y		301593	4637	182117	303	2026-10-20 00:59:45	2026-10-18 02:01:35	USED	KEEP — primary key
host_726.emp.CatalogSummary.UX_OrdersAudit	2	NONCLUSTERED	Y			25	14	0	130	2026-10-20 00:20:03	2026-10-19 02:01:21	USED	keep — in use
host_726.emp.CatalogSummary.UX_LedgerHistory	4	NONCLUSTERED	Y		Y	30890	0	0	181	2026-10-20 00:59:26	2026-10-19 02:01:21	USED	keep — in use
host_726.emp.TicketMonthly.PK_LedgerAudit	1	CLUSTERED	Y	Y		223	50	0	218	2026-10-19 18:16:54	2026-10-19 02:01:21	USED	KEEP — primary key
host_726.emp.BillingQueue.IX_AssetDetail	11	NONCLUSTERED				3	61	0	134	2026-10-19 13:57:14	2026-10-19 02:01:21	USED	keep — in use
host_726.emp.BillingQueue.IX_ContractSummary	8	NONCLUSTERED				116786	0	0	134	2026-10-20 00:59:00	2026-10-19 02:01:21	USED	keep — in use
host_726.emp.BillingQueue.PK_ShipmentEntry	1	CLUSTERED	Y	Y		0	1228	116788	134	2026-10-20 00:59:00	2026-10-19 02:01:21	USED	KEEP — primary key
host_726.emp.PricingAudit.IX_PricingMonthly	1	CLUSTERED				0	0	0	134	never	2026-10-19 02:01:22	UNUSED	KEEP — table storage
host_726.emp.CampaignResult.IX_SupplierLine	13	NONCLUSTERED				134	0	0	279	2026-10-20 00:00:00	2026-10-19 02:01:22	USED	keep — in use
host_726.emp.CampaignResult.PK_CustomerLine	1	CLUSTERED	Y	Y		0	114	134	279	2026-10-20 00:00:00	2026-10-19 02:01:22	USED	KEEP — primary key
host_726.guest.TerritoryQueue.IX_InvoiceStaging	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:41	COLD	review, then DROP
host_726.org.SettlementSnapshot.PK_org.SettlementSnapshot	1	CLUSTERED	Y	Y		0	1	0	0	2026-10-19 12:22:30	2026-10-18 02:01:48	USED	KEEP — primary key
host_726.org.SettlementSnapshot.UX_BillingLine	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:48	COLD	review carefully — unique
host_726.org.PolicySummary.IX_AssetEntry	3	NONCLUSTERED				63998	4033	0	2	2026-10-20 00:59:26	2026-10-18 02:01:48	USED	keep — in use
host_726.org.PolicySummary.PK_QuotaAudit	1	CLUSTERED	Y	Y		593197	55870	64201	8	2026-10-20 00:59:45	2026-10-18 02:01:48	USED	KEEP — primary key
host_726.org.PolicySummary.UX_ForecastHistory	2	NONCLUSTERED	Y		Y	209	0	0	2	2026-10-20 00:56:24	2026-10-18 02:01:48	USED	keep — in use
host_726.org.BatchMonthly.PK_WarehouseSummary	1	CLUSTERED	Y	Y		8	142	0	4	2026-10-19 21:09:19	2026-10-18 02:01:48	USED	KEEP — primary key
host_726.org.BatchMonthly.UX_SalesSnapshot	2	NONCLUSTERED	Y		Y	0	0	0	4	never	2026-10-18 02:01:48	UNUSED	review carefully — unique
host_726.org.CampaignQueue.PK_RosterDaily	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-10-18 02:01:49	UNUSED	KEEP — primary key
host_726.org.TicketLog.PK_WarehouseDetail	1	CLUSTERED	Y	Y		25	21	0	21	2026-10-19 16:20:35	2026-10-18 02:01:49	USED	KEEP — primary key
host_726.org.TicketLog.UX_SalesMonthly	4	NONCLUSTERED	Y			0	0	0	21	never	2026-10-18 02:01:49	UNUSED	review carefully — unique
host_726.org.Company.PK_QuotaStaging	1	CLUSTERED	Y	Y		124028	34393	3	0	2026-10-20 01:00:21	2026-10-18 02:01:49	USED	KEEP — primary key
host_726.org.Company.UX_PricingResult	2	NONCLUSTERED	Y		Y	0	3	0	0	2026-10-19 12:52:07	2026-10-18 02:01:49	USED	keep — in use
host_726.org.ShipmentAudit.PK_ForecastHeader	1	CLUSTERED	Y	Y		0	16858	137151	0	2026-10-20 01:00:00	2026-10-18 02:01:49	USED	KEEP — primary key
host_726.org.ShipmentAudit.UX_BatchArchive	2	NONCLUSTERED	Y			136981	171	0	0	2026-10-20 01:00:00	2026-10-18 02:01:49	USED	keep — in use
host_726.org.WarehouseStaging.PK_MeterHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:49	COLD	KEEP — primary key
host_726.org.BookingResult.PK_BillingQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.InvoiceQueue.PK_TicketEntry	1	CLUSTERED	Y	Y		0	6	0	0	2026-10-19 16:43:18	2026-10-18 02:01:49	USED	KEEP — primary key
host_726.org.PricingStatus.PK_TerritoryStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:49	COLD	KEEP — primary key
host_726.org.CatalogHeader.PK_ShiftStatus	1	CLUSTERED	Y	Y		35	50	0	0	2026-10-20 00:41:43	2026-10-18 02:01:49	USED	KEEP — primary key
host_726.org.PolicySummary.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:49	COLD	KEEP — primary key
host_726.org.CatalogAudit.PK_AssetStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:49	COLD	KEEP — primary key
host_726.org.OrdersSummary.PK_StaffingAudit	1	CLUSTERED	Y	Y		166	8	0	83	2026-10-19 18:11:44	2026-10-18 02:01:50	USED	KEEP — primary key
host_726.org.ContractResult.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	83	never	2026-10-18 02:01:50	UNUSED	KEEP — primary key
host_726.org.SupplierHistory.IX_ShipmentSummary	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:50	COLD	review, then DROP
host_726.org.SupplierHistory.PK_CustomerDetail	1	CLUSTERED	Y	Y		0	11076	0	0	2026-10-20 00:35:05	2026-10-18 02:01:50	USED	KEEP — primary key
host_726.org.ContractStaging.PK_CatalogDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.BatchSummary.PK_SettlementHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.org.BillingHeader.IX_ShiftHistory	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:50	COLD	review, then DROP
host_726.org.BillingHeader.PK_InvoiceMonthly	1	CLUSTERED	Y	Y		0	2097	0	0	2026-10-20 00:35:05	2026-10-18 02:01:50	USED	KEEP — primary key
host_726.org.ShipmentSummary.IX_StaffingResult	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:50	COLD	review, then DROP
host_726.org.ShipmentSummary.PK_ClaimDetail	1	CLUSTERED	Y	Y		0	2097	0	0	2026-10-20 00:35:05	2026-10-18 02:01:50	USED	KEEP — primary key
host_726.org.SalesStatus.IX_ClaimHeader	2	NONCLUSTERED	Y			2097	0	0	0	2026-10-20 00:35:05	2026-10-18 02:01:50	USED	keep — in use
host_726.org.SalesStatus.PK_CampaignSnapshot	1	CLUSTERED	Y	Y		0	0	2097	0	2026-10-20 00:35:05	2026-10-18 02:01:50	USED	KEEP — primary key
host_726.org.PolicyResult.PK_ForecastStaging	1	CLUSTERED	Y	Y		0	291145	0	0	2026-10-20 00:59:00	2026-10-18 02:01:50	USED	KEEP — primary key
host_726.org.AssetSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		7636	1193	0	0	2026-10-20 00:41:27	2026-10-18 02:01:50	USED	KEEP — primary key
host_726.org.AssetSummary.UX_ShipmentSummary	2	NONCLUSTERED	Y			0	233	0	0	2026-10-19 22:00:38	2026-10-18 02:01:50	USED	keep — in use
host_726.org.ShipmentQueue.PK_InvoiceStaging	1	CLUSTERED	Y	Y		20800	203672	0	0	2026-10-20 00:59:00	2026-10-18 02:01:50	USED	KEEP — primary key
host_726.org.PolicyEntry.PK_SettlementSnapshot	1	CLUSTERED	Y	Y		259	64	0	0	2026-10-20 00:52:58	2026-10-18 02:01:50	USED	KEEP — primary key
host_726.org.PolicyEntry.UX_ShiftSnapshot	2	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-10-18 02:01:50	COLD	review carefully — unique
host_726.org.MeterAudit.IX_WarehouseQueue	6	NONCLUSTERED				63	0	0	0	2026-10-20 00:20:03	2026-10-18 02:01:50	USED	keep — in use
host_726.org.MeterAudit.PK_BillingDetail	1	CLUSTERED	Y	Y		252	0	0	0	2026-10-20 00:52:58	2026-10-18 02:01:50	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	0	never	2026-10-18 02:01:52	COLD	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	1	0	0	2026-10-19 12:22:30	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		20392	21	1	0	2026-10-20 00:58:42	2026-10-18 02:01:52	USED	KEEP — primary key
host_726.org.ReconcileAudit.UQ_ShipmentResult	2	NONCLUSTERED	Y		Y	2	0	0	0	2026-10-19 10:56:11	2026-10-18 02:01:52	USED	keep — in use
host_726.org.StaffingAudit.PK_RosterArchive	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-10-18 02:01:52	UNUSED	KEEP — primary key
host_726.org.ShiftResult.PK_AssetAudit	1	CLUSTERED	Y	Y		238338	106772	0	1	2026-10-20 00:59:13	2026-10-18 02:01:52	USED	KEEP — primary key
host_726.org.BatchMonthly.PK_SalesLine	1	CLUSTERED	Y	Y		0	2234	0	0	2026-10-20 00:16:28	2026-10-18 02:01:53	USED	KEEP — primary key
host_726.org.RosterMonthly.IX_AssetDetail	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:53	COLD	review, then DROP
host_726.org.RosterMonthly.PK_ForecastDaily	1	CLUSTERED	Y	Y		0	3	0	0	2026-10-19 10:56:11	2026-10-18 02:01:53	USED	KEEP — primary key
host_726.org.InvoiceStaging.IX_AssetAudit	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:53	COLD	review, then DROP
host_726.org.InvoiceStaging.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:53	COLD	KEEP — primary key
host_726.org.StaffingAudit.PK_AssetLog	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-10-18 02:01:53	UNUSED	KEEP — primary key
host_726.org.Level.PK_ShiftStaging	1	CLUSTERED	Y	Y		52072	213	0	0	2026-10-20 00:59:26	2026-10-18 02:01:53	USED	KEEP — primary key
host_726.org.Level.UX_SettlementHistory	2	NONCLUSTERED	Y		Y	0	1	0	0	2026-10-19 12:22:30	2026-10-18 02:01:53	USED	keep — in use
host_726.org.ContractHistory.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:53	COLD	KEEP — primary key
host_726.org.QuotaEntry.IX_AssetHistory	2	NONCLUSTERED				0	0	0	24	never	2026-10-18 02:01:53	UNUSED	review, then DROP
host_726.org.QuotaEntry.PK_LedgerQueue	1	CLUSTERED	Y	Y		4	31066	0	24	2026-10-20 00:59:00	2026-10-18 02:01:53	USED	KEEP — primary key
host_726.org.ClaimQueue.PK_LedgerHistory	1	CLUSTERED	Y	Y		0	0	0	4	never	2026-10-18 02:01:53	UNUSED	KEEP — primary key
host_726.org.SupplierLine.PK_InvoiceStatus	1	CLUSTERED	Y	Y		14	580398	0	2	2026-10-20 00:56:09	2026-10-18 02:01:53	USED	KEEP — primary key
host_726.org.InvoiceHistory.PK_ContractDaily	1	CLUSTERED	Y	Y		1	13	0	1	2026-10-19 09:00:29	2026-10-18 02:01:53	USED	KEEP — primary key
host_726.org.AssetHeader.IX_PayrollAudit	2	NONCLUSTERED				580375	0	0	1097	2026-10-20 00:56:09	2026-10-18 02:01:53	USED	keep — in use
host_726.org.AssetHeader.PK_LedgerResult	1	CLUSTERED	Y	Y		369	0	0	1097	2026-10-19 11:37:52	2026-10-18 02:01:53	USED	KEEP — primary key
host_726.org.TerritoryStatus.PK_PayrollLine	1	CLUSTERED	Y	Y		0	0	0	6	never	2026-10-18 02:01:53	UNUSED	KEEP — primary key
host_726.org.RosterLine.PK_BillingDaily	1	CLUSTERED	Y	Y		0	0	0	2	never	2026-10-18 02:01:53	UNUSED	KEEP — primary key
host_726.org.ForecastArchive.PK_CampaignHeader	1	CLUSTERED	Y	Y		13140	6	0	0	2026-10-20 00:56:09	2026-10-18 02:01:53	USED	KEEP — primary key
host_726.org.PolicySummary.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	76791	0	0	2026-10-20 00:56:09	2026-10-18 02:01:53	USED	KEEP — primary key
host_726.org.ClaimMonthly.PK_RouteArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:53	COLD	KEEP — primary key
host_726.org.OrdersEntry.PK_MeterDaily	1	CLUSTERED	Y	Y		0	34186	0	0	2026-10-20 00:57:33	2026-10-18 02:01:53	USED	KEEP — primary key
host_726.org.LedgerStaging.PK_BatchLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:53	COLD	KEEP — primary key
host_726.org.Position.PK_PolicySummary	1	CLUSTERED	Y	Y		225962	1493	0	0	2026-10-20 00:59:45	2026-10-18 02:01:54	USED	KEEP — primary key
host_726.org.Position.UX_MeterArchive	2	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-10-18 02:01:54	COLD	review carefully — unique
host_726.org.CampaignQueue.PK_BillingArchive	1	CLUSTERED	Y	Y		7862	513	38	0	2026-10-20 00:41:27	2026-10-18 02:01:54	USED	KEEP — primary key
host_726.org.CampaignQueue.UX_TicketDaily	2	NONCLUSTERED	Y			64030	2	0	0	2026-10-20 00:59:26	2026-10-18 02:01:54	USED	keep — in use
host_726.org.MeterResult.PK_CatalogStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:54	COLD	KEEP — primary key
host_726.org.QuotaLine.PK_AssetAudit	1	CLUSTERED	Y	Y		0	0	1	0	2026-10-19 12:22:30	2026-10-18 02:01:54	USED	KEEP — primary key
host_726.org.QuotaLine.UX_PricingAudit	2	NONCLUSTERED	Y		Y	0	1	0	0	2026-10-19 12:22:30	never	USED	keep — in use
host_726.org.PayrollLog.PK_PayrollAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:54	COLD	KEEP — primary key
host_726.org.PayrollLog.UX_PayrollDetail	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:54	COLD	review carefully — unique
host_726.org.LedgerDaily.PK_ContractHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:54	COLD	KEEP — primary key
host_726.org.PricingArchive.PK_ShiftStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:54	COLD	KEEP — primary key
host_726.org.PricingArchive.UX_InvoiceAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:54	COLD	review carefully — unique
host_726.org.ForecastAudit.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	87	0	0	2026-10-19 18:14:03	2026-10-18 02:01:54	USED	KEEP — primary key
host_726.org.ForecastAudit.UX_ClaimArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:54	COLD	review carefully — unique
host_726.org.PayrollLine.PK_OrdersHistory	1	CLUSTERED	Y	Y		38	87	0	0	2026-10-19 18:14:03	2026-10-18 02:01:54	USED	KEEP — primary key
host_726.org.PayrollLine.UX_ShiftLog	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:54	COLD	review carefully — unique
host_726.org.BookingStaging.PK_AssetResult	1	CLUSTERED	Y	Y		186642	53363	0	0	2026-10-20 00:59:27	2026-10-18 02:01:54	USED	KEEP — primary key
host_726.org.ReconcileLine.PK_CustomerLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:54	COLD	KEEP — primary key
host_726.org.ShiftStaging.PK_BillingHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:54	COLD	KEEP — primary key
host_726.org.ShiftStaging.UQ_PolicyAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:54	COLD	review carefully — unique
host_726.org.CustomerLine.IX_ForecastLine	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:54	COLD	review, then DROP
host_726.org.CustomerLine.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	2038	0	0	2026-10-20 00:35:04	2026-10-18 02:01:54	USED	KEEP — primary key
host_726.org.CustomerLine.UQ_PayrollLog	3	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:54	COLD	review carefully — unique
host_726.org.InvoiceMonthly.PK_WarehouseQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:54	COLD	KEEP — primary key
host_726.org.InvoiceMonthly.UQ_MeterAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:54	COLD	review carefully — unique
host_726.org.QuotaStaging.PK_ShiftStaging	1	CLUSTERED	Y	Y		0	0	2038	0	2026-10-20 00:35:04	2026-10-18 02:01:54	USED	KEEP — primary key
host_726.org.QuotaStaging.UQ_ShiftMonthly	2	NONCLUSTERED	Y			2038	0	0	0	2026-10-20 00:35:04	2026-10-18 02:01:54	USED	keep — in use
host_726.org.BatchMonthly.PK_WarehouseHeader	1	CLUSTERED	Y	Y		0	2024	0	0	2026-10-20 00:35:04	2026-10-18 02:01:55	USED	KEEP — primary key
host_726.org.BatchMonthly.UQ_LedgerStaging	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:55	COLD	review carefully — unique
host_726.org.ClaimHeader.PK_ClaimArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:55	COLD	KEEP — primary key
host_726.org.SupplierResult.PK_ForecastQueue	1	CLUSTERED	Y	Y		0	5397	0	0	2026-10-19 23:36:00	2026-10-18 02:01:55	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		120	466	83059	208	2026-10-20 00:59:00	2026-10-18 02:01:55	USED	KEEP — primary key
host_726.org.ShiftResult.UX_LedgerStaging	2	NONCLUSTERED	Y			83061	0	0	208	2026-10-20 00:59:00	2026-10-19 02:01:23	USED	keep — in use
host_726.org.QuotaResult.PK_CampaignDaily	1	CLUSTERED	Y	Y		4772	8595	0	0	2026-10-20 01:00:22	2026-10-18 02:01:55	USED	KEEP — primary key
host_726.org.QuotaResult.UX_BatchDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:55	COLD	review carefully — unique
host_726.org.QuotaDetail.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		85	5573	0	0	2026-10-20 00:56:09	2026-10-18 02:01:55	USED	KEEP — primary key
host_726.org.BookingLog.PK_MeterStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:55	COLD	KEEP — primary key
host_726.org.SettlementAudit.PK_InvoiceSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:55	COLD	KEEP — primary key
host_726.oth.QuotaSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:55	COLD	KEEP — primary key
host_726.oth.InvoiceStatus.PK_ShiftQueue	1	CLUSTERED	Y	Y		93	4	0	0	2026-10-20 00:00:00	2026-10-18 02:01:55	USED	KEEP — primary key
host_726.oth.SupplierLine.PK_QuotaDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:55	COLD	KEEP — primary key
host_726.oth.SupplierLine.UX_InvoiceHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:55	COLD	review carefully — unique
host_726.oth.StaffingArchive.IX_InvoiceStaging	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:55	COLD	review, then DROP
host_726.oth.StaffingArchive.PK_PricingAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:55	COLD	KEEP — primary key
host_726.oth.StaffingArchive.UQ_SalesAudit	3	NONCLUSTERED	Y			0	93	0	0	2026-10-19 22:39:07	2026-10-18 02:01:55	USED	keep — in use
host_726.oth.CustomerQueue.IX_WarehouseResult	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:56	COLD	review, then DROP
host_726.oth.CustomerQueue.PK_TerritoryResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:56	COLD	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	2732	0	166	2026-10-20 00:41:27	2026-10-19 02:01:24	USED	KEEP — primary key
host_726.sal.ClaimArchive.IX_RouteDetail	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:56	COLD	review, then DROP
host_726.sal.ClaimArchive.PK_LedgerHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:56	COLD	KEEP — primary key
host_726.sal.QuotaLine.PK_ContractArchive	1	CLUSTERED	Y	Y		1640	6622	0	0	2026-10-20 01:00:00	2026-10-18 02:01:56	USED	KEEP — primary key
host_726.sal.SalesStatus.PK_ShiftMonthly	1	CLUSTERED	Y	Y		8050	19	0	4	2026-10-20 00:41:27	2026-10-18 02:01:56	USED	KEEP — primary key
host_726.sal.SettlementQueue.PK_StaffingSnapshot	1	CLUSTERED	Y	Y		0	9954	0	338	2026-10-20 00:41:27	2026-10-18 02:01:56	USED	KEEP — primary key
host_726.sal.MeterHistory.PK_LedgerSnapshot	1	CLUSTERED	Y	Y		0	1153	0	338	2026-10-20 00:35:05	2026-10-18 02:01:57	USED	KEEP — primary key
host_726.sal.ShipmentAudit.PK_BatchDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.sal.RouteResult.PK_OrdersAudit	1	CLUSTERED	Y	Y		0	3	0	0	2026-10-19 18:07:44	2026-10-18 02:01:57	USED	KEEP — primary key
host_726.sal.RouteResult.UX_ContractEntry	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:57	COLD	review carefully — unique
host_726.sal.WarehouseDaily.PK_SettlementDetail	1	CLUSTERED	Y	Y		369	204	0	0	2026-10-19 18:16:54	2026-10-18 02:01:57	USED	KEEP — primary key
host_726.sal.WarehouseDaily.UX_BookingAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:57	COLD	review carefully — unique
host_726.sal.InvoiceLog.PK_MeterAudit	1	CLUSTERED	Y	Y		0	3	0	0	2026-10-19 18:07:44	2026-10-18 02:01:57	USED	KEEP — primary key
host_726.sal.PolicySnapshot.PK_ReconcileQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:57	COLD	KEEP — primary key
host_726.sal.SettlementStatus.PK_ReconcileResult	1	CLUSTERED	Y	Y		0	5	43	0	2026-10-19 18:13:37	2026-10-18 02:01:57	USED	KEEP — primary key
host_726.sal.SettlementStatus.UX_StaffingMonthly	2	NONCLUSTERED	Y			43	0	0	0	2026-10-19 18:13:37	2026-10-18 02:01:57	USED	keep — in use
host_726.sal.ReconcileHistory.PK_PayrollHeader	1	CLUSTERED	Y	Y		0	3	0	0	2026-10-19 18:07:46	2026-10-18 02:01:57	USED	KEEP — primary key
host_726.sal.ReconcileHistory.UX_TicketQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:57	COLD	review carefully — unique
host_726.sal.InvoiceEntry.PK_RouteQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:57	COLD	KEEP — primary key
host_726.sal.BillingQueue.PK_ReconcileHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:57	COLD	KEEP — primary key
host_726.sal.RosterDetail.PK_BookingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:58	COLD	KEEP — primary key
host_726.sal.RosterQueue.PK_ShiftQueue	1	CLUSTERED	Y	Y		0	952	0	0	2026-10-20 00:35:04	2026-10-18 02:01:58	USED	KEEP — primary key
host_726.sal.RosterQueue.UX_RosterArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:58	COLD	review carefully — unique
host_726.sal.WarehouseHeader.PK_RouteEntry	1	CLUSTERED	Y	Y		0	30	0	0	2026-10-20 00:09:24	2026-10-18 02:01:58	USED	KEEP — primary key
host_726.sal.SupplierArchive.PK_SupplierStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:58	COLD	KEEP — primary key
host_726.sal.RosterQueue.PK_PolicyLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:58	COLD	KEEP — primary key
host_726.sal.CustomerSnapshot.PK_RosterEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:58	COLD	KEEP — primary key
host_726.sal.LedgerStatus.PK_WarehouseStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:58	COLD	KEEP — primary key
host_726.sal.BookingLine.PK_PricingAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:58	COLD	KEEP — primary key
host_726.sal.PricingLine.PK_BatchLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:58	COLD	KEEP — primary key
host_726.sal.WarehouseStaging.PK_SettlementHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:58	COLD	KEEP — primary key
host_726.sal.StaffingArchive.PK_CatalogLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:58	COLD	KEEP — primary key
host_726.sal.WarehouseSummary.PK_RosterArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:58	COLD	KEEP — primary key
host_726.schedule.CustomerDetail.PK_CatalogStaging	1	CLUSTERED	Y	Y		0	0	58467	0	2026-10-20 00:59:00	2026-10-18 02:01:59	USED	KEEP — primary key
host_726.schedule.CustomerDetail.UQ_BillingSnapshot	3	NONCLUSTERED	Y			58127	85	0	0	2026-10-20 00:59:00	2026-10-18 02:01:59	USED	keep — in use
host_726.schedule.CustomerDetail.UQ_CampaignResult	2	NONCLUSTERED	Y			58552	170	0	0	2026-10-20 00:59:00	2026-10-18 02:01:59	USED	keep — in use
host_726.schedule.InvoiceHistory.IX_StaffingHeader	3	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:01:59	COLD	review, then DROP
host_726.schedule.InvoiceHistory.PK_ContractLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:01:59	COLD	KEEP — primary key
host_726.schedule.InvoiceHistory.UQ_LedgerResult	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:59	COLD	review carefully — unique
host_726.schedule.MeterStaging.PK_SettlementMonthly	1	CLUSTERED	Y	Y		62125	0	0	85	2026-10-20 00:59:00	2026-10-18 02:01:59	USED	KEEP — primary key
host_726.schedule.SettlementLine.PK_CampaignStatus	1	CLUSTERED	Y	Y		69480	85	0	340	2026-10-20 00:59:13	2026-10-18 02:01:59	USED	KEEP — primary key
host_726.schedule.TicketEntry.PK_CampaignDaily	1	CLUSTERED	Y	Y		255	340	0	340	2026-10-20 00:41:43	2026-10-18 02:01:59	USED	KEEP — primary key
host_726.schedule.QuotaSummary.PK_LedgerStatus	1	CLUSTERED	Y	Y		175774	220	0	85	2026-10-20 00:59:00	2026-10-18 02:01:59	USED	KEEP — primary key
host_726.schedule.ShipmentLog.PK_SalesEntry	1	CLUSTERED	Y	Y		58382	0	0	170	2026-10-20 00:59:00	2026-10-20 00:38:45	USED	KEEP — primary key
host_726.schedule.PricingResult.PK_CampaignDaily	1	CLUSTERED	Y	Y		58212	340	0	85	2026-10-20 00:59:00	2026-10-18 02:01:59	USED	KEEP — primary key
host_726.schedule.SupplierSnapshot.IX_BillingHeader	3	NONCLUSTERED				154437	0	0	209646	2026-10-20 00:59:01	2026-10-20 00:41:45	USED	keep — in use
host_726.schedule.SupplierSnapshot.PK_AssetStatus	1	CLUSTERED	Y	Y		500235	12427	121261	267858	2026-10-20 00:59:01	2026-10-20 00:41:44	USED	KEEP — primary key
host_726.schedule.SupplierSnapshot.IX_ContractLog	2	NONCLUSTERED	Y			0	62578	0	116424	2026-10-20 00:59:01	2026-10-20 00:41:44	USED	keep — in use
host_726.schedule.ClaimAudit.PK_ForecastArchive	1	CLUSTERED	Y	Y		290975	85	0	174636	2026-10-20 00:59:00	2026-10-19 22:32:34	USED	KEEP — primary key
host_726.schedule.BatchDetail.PK_AssetDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host_726.schedule.RosterSummary.IX_BatchDetail	2	NONCLUSTERED				300190	0	0	124554	2026-10-20 00:59:00	2026-10-20 00:38:39	USED	keep — in use
host_726.schedule.RosterSummary.IX_ClaimHeader	3	NONCLUSTERED				62986	1	0	124554	2026-10-20 00:59:00	2026-10-20 00:38:39	USED	keep — in use
host_726.schedule.RosterSummary.PK_CustomerAudit	1	CLUSTERED	Y	Y		3790404	0	145186	435955	2026-10-20 00:59:13	2026-10-20 00:38:39	USED	KEEP — primary key
host_726.schedule.BillingDetail.IX_TicketHeader	2	NONCLUSTERED				859923	3	0	529370	2026-10-20 00:59:00	2026-10-20 00:39:00	USED	keep — in use
host_726.schedule.BillingDetail.PK_BillingLog	1	CLUSTERED	Y	Y		5945840	13291	510045	622790	2026-10-20 00:59:13	2026-10-20 00:41:57	USED	KEEP — primary key
host_726.schedule.PolicyStatus.IX_ForecastAudit	2	NONCLUSTERED				754054	0	0	1179246	2026-10-20 00:59:00	2026-10-20 00:41:26	USED	keep — in use
host_726.schedule.PolicyStatus.IX_SupplierLine	3	NONCLUSTERED				703354	39	0	1179246	2026-10-20 00:59:01	2026-10-20 00:42:34	USED	keep — in use
host_726.schedule.PolicyStatus.PK_PricingDaily	1	CLUSTERED	Y	Y		1454263	65	299416	1179246	2026-10-20 00:59:00	2026-10-20 00:42:33	USED	KEEP — primary key
host_726.schedule.PolicyLine.IX_TerritorySnapshot	2	NONCLUSTERED				1169234	1	0	155262	2026-10-20 00:59:00	2026-10-19 22:32:37	USED	keep — in use
host_726.schedule.PolicyLine.PK_BookingAudit	1	CLUSTERED	Y	Y		536963	65	30260	248322	2026-10-20 00:59:00	2026-10-19 22:32:37	USED	KEEP — primary key
host_726.schedule.AssetResult.IX_BillingResult	2	NONCLUSTERED				83959	0	0	83959	2026-10-20 00:59:00	never	USED	keep — in use
host_726.schedule.AssetResult.PK_TicketQueue	1	CLUSTERED	Y	Y		0	0	0	83959	never	never	UNUSED	KEEP — primary key
host_726.schedule.InvoiceAudit.IX_StaffingQueue	2	NONCLUSTERED				2489251	1	0	620562	2026-10-20 00:59:00	2026-10-20 00:39:25	USED	keep — in use
host_726.schedule.InvoiceAudit.PK_LedgerMonthly	1	CLUSTERED	Y	Y		923111	0	37591	620562	2026-10-20 00:59:00	2026-10-20 00:39:19	USED	KEEP — primary key
host_726.schedule.SettlementLog.IX_TicketLine	2	NONCLUSTERED				1310359	0	0	1365394	2026-10-20 00:59:00	2026-10-20 00:42:16	USED	keep — in use
host_726.schedule.SettlementLog.IX_PolicyLine	3	NONCLUSTERED				124225	1	0	1365394	2026-10-20 00:59:00	2026-10-20 00:42:17	USED	keep — in use
host_726.schedule.SettlementLog.PK_CatalogMonthly	1	CLUSTERED	Y	Y		2013423	0	10244	1551514	2026-10-20 00:59:00	2026-10-20 00:42:17	USED	KEEP — primary key
host_726.schedule.ShiftHeader.IX_TicketStatus	4	NONCLUSTERED				0	0	0	174636	never	2026-10-20 00:37:45	UNUSED	review, then DROP
host_726.schedule.ShiftHeader.IX_ShipmentLine	3	NONCLUSTERED				539041	0	0	174636	2026-10-20 00:59:01	2026-10-20 00:37:42	USED	keep — in use
host_726.schedule.ShiftHeader.PK_OrdersArchive	1	CLUSTERED	Y	Y		7926447	94	133183	291060	2026-10-20 01:00:24	2026-10-20 00:37:42	USED	KEEP — primary key
host_726.schedule.ShiftHeader.IX_BookingStatus	2	NONCLUSTERED	Y			0	269	0	174636	2026-10-20 00:43:43	2026-10-20 00:41:48	USED	keep — in use
host_726.schedule.PolicyLine.PK_RouteQueue	1	CLUSTERED	Y	Y		4740457	353	0	232848	2026-10-20 01:00:24	2026-10-20 00:38:51	USED	KEEP — primary key
host_726.schedule.PolicyLine.UX_TerritoryHistory	2	NONCLUSTERED	Y		Y	0	0	0	116424	never	2026-10-20 00:38:51	UNUSED	review carefully — unique
host_726.schedule.RosterHistory.IX_AssetSummary	2	NONCLUSTERED				780094	3	0	116424	2026-10-20 01:00:24	2026-10-19 22:30:27	USED	keep — in use
host_726.schedule.RosterHistory.PK_WarehouseLine	1	CLUSTERED	Y	Y		220652	0	3	116424	2026-10-20 00:59:13	2026-10-19 22:30:27	USED	KEEP — primary key
host_726.schedule.MeterStaging.IX_PayrollAudit	2	NONCLUSTERED				1087038	60442	0	116424	2026-10-20 01:00:24	2026-10-20 00:35:26	USED	keep — in use
host_726.schedule.MeterStaging.PK_PolicyArchive	1	CLUSTERED	Y	Y		181961	0	7796	116424	2026-10-20 00:59:13	2026-10-20 00:35:25	USED	KEEP — primary key
host_726.schedule.CustomerHistory.IX_LedgerQueue	2	NONCLUSTERED				89485	12902	0	744642	2026-10-20 00:59:00	2026-10-20 00:40:16	USED	keep — in use
host_726.schedule.CustomerHistory.PK_PayrollAudit	1	CLUSTERED	Y	Y		1185724	34	20634	775662	2026-10-20 00:59:13	2026-10-20 00:40:16	USED	KEEP — primary key
host_726.schedule.RosterResult.IX_BookingAudit	2	NONCLUSTERED				0	0	0	372402	never	2026-10-20 00:40:23	UNUSED	review, then DROP
host_726.schedule.RosterResult.IX_AssetStaging	3	NONCLUSTERED				309262	171	0	372402	2026-10-20 00:59:00	2026-10-20 00:40:24	USED	keep — in use
host_726.schedule.RosterResult.PK_PricingSummary	1	CLUSTERED	Y	Y		948311	517	151807	403422	2026-10-20 01:00:06	2026-10-20 00:43:29	USED	KEEP — primary key
host_726.schedule.LedgerSnapshot.PK_RouteStatus	1	CLUSTERED	Y	Y		408504	82513	0	0	2026-10-20 00:59:13	2026-10-18 02:23:28	USED	KEEP — primary key
host_726.schedule.LedgerSnapshot.IX_TicketLine	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:28	COLD	review carefully — unique
host_726.schedule.RosterHistory.PK_MeterLine	1	CLUSTERED	Y	Y		243946	0	0	85	2026-10-20 00:59:13	2026-10-18 02:23:28	USED	KEEP — primary key
host_726.schedule.AssetStaging.PK_CampaignResult	1	CLUSTERED	Y	Y		355075	85	0	85	2026-10-20 01:00:24	2026-10-18 02:23:29	USED	KEEP — primary key
host_726.schedule.TicketSnapshot.PK_PricingSummary	1	CLUSTERED	Y	Y		116679	0	0	255	2026-10-20 00:59:00	2026-10-18 02:23:29	USED	KEEP — primary key
host_726.schedule.CampaignDaily.IX_BookingArchive	2	NONCLUSTERED				0	2	0	53635	2026-10-19 14:49:06	2026-10-19 02:01:28	USED	keep — in use
host_726.schedule.CampaignDaily.PK_PricingEntry	1	CLUSTERED	Y	Y		1	13	2	53635	2026-10-19 14:54:06	2026-10-19 02:01:24	USED	KEEP — primary key
host_726.schedule.BatchSnapshot.IX_ShiftQueue	3	NONCLUSTERED				0	18702	0	64251	2026-10-20 01:00:09	2026-10-20 00:39:18	USED	keep — in use
host_726.schedule.BatchSnapshot.PK_ShiftHistory	1	CLUSTERED	Y	Y		0	11802	69	64491	2026-10-20 01:00:08	2026-10-20 00:39:18	USED	KEEP — primary key
host_726.schedule.BatchSnapshot.UX_StaffingEntry	2	NONCLUSTERED	Y			74696	3105	0	64251	2026-10-20 00:56:17	2026-10-20 00:39:18	USED	keep — in use
host_726.schedule.InvoiceLog.PK_CatalogSummary	1	CLUSTERED	Y	Y		31479	83503	1682	0	2026-10-20 00:59:24	2026-10-18 02:01:59	USED	KEEP — primary key
host_726.schedule.InvoiceLog.IX_WarehouseHeader	2	NONCLUSTERED	Y			1648	34	0	0	2026-10-20 00:40:43	2026-10-18 02:01:59	USED	keep — in use
host_726.schedule.ContractResult.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	51216	0	0	2026-10-20 00:58:50	2026-10-18 02:01:59	USED	KEEP — primary key
host_726.schedule.ContractResult.UX_CampaignHistory	2	NONCLUSTERED	Y		Y	65448	0	0	0	2026-10-20 00:59:24	2026-10-18 02:01:59	USED	keep — in use
host_726.schedule.BillingLog.PK_ContractResult	1	CLUSTERED	Y	Y		26836	89828	0	0	2026-10-20 00:59:24	2026-10-18 02:01:59	USED	KEEP — primary key
host_726.schedule.SalesArchive.IX_RosterStatus	1	CLUSTERED				0	0	0	0	never	2026-10-18 02:01:59	COLD	KEEP — table storage
host_726.schedule.CatalogHistory.PK_OrdersStatus	1	CLUSTERED	Y	Y		26174	0	0	0	2026-10-20 00:58:50	2026-10-18 02:01:59	USED	KEEP — primary key
host_726.schedule.CatalogHistory.IX_PricingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:01:59	COLD	review carefully — unique
host_726.schedule.engine.PK_ReconcileDaily	1	CLUSTERED	Y	Y		1084724	0	143059	0	2026-10-20 00:59:00	2026-10-18 02:21:32	USED	KEEP — primary key
host_726.schedule.engine.UQ_MeterQueue	2	NONCLUSTERED	Y			143059	0	0	0	2026-10-20 00:59:00	2026-10-18 02:21:32	USED	keep — in use
host_726.schedule.TerritoryAudit.PK_PayrollSnapshot	1	CLUSTERED	Y	Y		0	0	147357	120328	2026-10-20 00:59:00	2026-10-19 02:21:01	USED	KEEP — primary key
host_726.schedule.TerritoryAudit.UX_BookingHeader	2	NONCLUSTERED	Y		Y	178454	0	0	58211	2026-10-20 00:59:00	2026-10-19 02:21:10	USED	keep — in use
host_726.schedule.WarehouseArchive.IX_CustomerHistory	2	NONCLUSTERED				0	0	0	116432	never	2026-10-20 00:04:20	UNUSED	review, then DROP
host_726.schedule.WarehouseArchive.IX_OrdersHeader	3	NONCLUSTERED				59100	0	0	116432	2026-10-20 00:59:00	2026-10-20 00:04:20	USED	keep — in use
host_726.schedule.WarehouseArchive.PK_RouteAudit	1	CLUSTERED	Y	Y		201682	568935	0	201682	2026-10-20 00:59:00	never	USED	KEEP — primary key
host_726.schedule.LedgerMonthly.IX_CustomerMonthly	3	NONCLUSTERED				59100	0	0	2111896	2026-10-20 00:59:00	never	USED	keep — in use
host_726.schedule.LedgerMonthly.PK_ClaimLine	1	CLUSTERED	Y	Y		3167844	0	0	3167844	2026-10-20 00:59:00	never	USED	KEEP — primary key
host_726.schedule.RouteAudit.IX_InvoiceHeader	2	NONCLUSTERED				0	0	0	59100	never	2026-10-19 02:22:07	UNUSED	review, then DROP
host_726.schedule.RouteAudit.IX_SettlementDetail	3	NONCLUSTERED			Y	0	0	0	58216	never	never	UNUSED	review, then DROP
host_726.schedule.RouteAudit.IX_CatalogArchive	4	NONCLUSTERED				0	2	0	59100	2026-10-19 08:50:01	2026-10-19 02:22:08	USED	keep — in use
host_726.schedule.RouteAudit.IX_QuotaStaging	5	NONCLUSTERED				0	7	0	59100	2026-10-19 08:52:50	2026-10-19 02:22:08	USED	keep — in use
host_726.schedule.RouteAudit.PK_PayrollAudit	1	CLUSTERED	Y	Y		1	7	9	59100	2026-10-19 10:44:56	2026-10-19 02:21:11	USED	KEEP — primary key
host_726.schedule.ShipmentHeader.PK_CampaignDetail	1	CLUSTERED	Y	Y		115	57	0	1056020	2026-10-19 06:48:59	2026-10-19 02:22:11	USED	KEEP — primary key
host_726.schedule.SupplierEntry.PK_AssetSnapshot	1	CLUSTERED	Y	Y		485447	0	0	0	2026-10-20 00:59:00	2026-10-18 02:23:21	USED	KEEP — primary key
host_726.schedule.TerritoryDetail.PK_ReconcileMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:21	COLD	KEEP — primary key
host_726.schedule.StaffingEntry.PK_QuotaDetail	1	CLUSTERED	Y	Y		5279799	0	0	0	2026-10-20 00:59:00	2026-10-18 02:23:21	USED	KEEP — primary key
host_726.schedule.StaffingEntry.UQ_TicketDetail	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:21	COLD	review carefully — unique
host_726.schedule.StaffingEntry.UX_PayrollDaily	3	NONCLUSTERED	Y		Y	971989	0	0	0	2026-10-20 00:59:00	2026-10-18 02:23:21	USED	keep — in use
host_726.schedule.ForecastMonthly.PK_ForecastHistory	1	CLUSTERED	Y	Y		5280253	57	0	10559979	2026-10-20 00:59:00	2026-10-19 02:22:15	USED	KEEP — primary key
host_726.schedule.CatalogEntry.PK_PolicyDetail	1	CLUSTERED	Y	Y		971989	0	0	0	2026-10-20 00:59:00	2026-10-18 02:23:28	USED	KEEP — primary key
host_726.schedule.CatalogEntry.UQ_AssetAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:28	COLD	review carefully — unique
host_726.schedule.ContractAudit.PK_TicketSummary	1	CLUSTERED	Y	Y		5279799	0	0	0	2026-10-20 00:59:00	2026-10-18 02:23:28	USED	KEEP — primary key
host_726.schedule.ContractAudit.UQ_OrdersStaging	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:28	COLD	review carefully — unique
host_726.schedule.ContractAudit.UX_BillingSnapshot	3	NONCLUSTERED	Y		Y	971989	0	0	0	2026-10-20 00:59:00	2026-10-18 02:23:28	USED	keep — in use
host_726.schedule.CampaignStaging.PK_WarehouseHistory	1	CLUSTERED	Y	Y		112416	37475	0	149884	2026-10-20 00:59:01	2026-10-20 00:34:13	USED	KEEP — primary key
host_726.schedule.SupplierSummary.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:29	COLD	KEEP — primary key
host_726.schedule.SupplierSummary.UQ_BillingStaging	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:29	COLD	review carefully — unique
host_726.schedule.PayrollDaily.PK_CustomerQueue	1	CLUSTERED	Y	Y		684310	29155	0	0	2026-10-20 00:59:00	2026-10-18 02:23:29	USED	KEEP — primary key
host_726.schedule.WarehouseDaily.PK_QuotaAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:29	COLD	KEEP — primary key
host_726.schedule.WarehouseDaily.UQ_ShiftEntry	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:29	COLD	review carefully — unique
host_726.schedule.WarehouseDaily.UX_TerritorySummary	3	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-10-18 02:23:29	COLD	review carefully — unique
host_726.schedule.sql.IX_PayrollEntry	3	NONCLUSTERED			Y	971989	0	0	0	2026-10-20 00:59:00	2026-10-18 02:23:29	USED	keep — in use
host_726.schedule.sql.PK_ContractMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:29	COLD	KEEP — primary key
host_726.schedule.sql.UQ_SalesStatus	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:29	COLD	review carefully — unique
host_726.schedule.LedgerStatus.PK_SettlementQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:29	COLD	KEEP — primary key
host_726.schedule.LedgerStatus.UQ_QuotaAudit	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:29	COLD	review carefully — unique
host_726.schedule.OrdersQueue.PK_QuotaQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:29	COLD	KEEP — primary key
host_726.schedule.LedgerStaging.IX_StaffingLog	3	NONCLUSTERED				971989	0	0	0	2026-10-20 00:59:00	2026-10-18 02:23:29	USED	keep — in use
host_726.schedule.LedgerStaging.PK_ContractQueue	1	CLUSTERED	Y	Y		5279799	0	971989	0	2026-10-20 00:59:00	2026-10-18 02:23:29	USED	KEEP — primary key
host_726.schedule.LedgerStaging.UQ_TicketResult	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:29	COLD	review carefully — unique
host_726.schedule.LedgerStaging.UX_QuotaHeader	4	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-10-18 02:23:29	COLD	review carefully — unique
host_726.schedule.step.PK_AssetStaging	1	CLUSTERED	Y	Y		1030205	0	0	0	2026-10-20 00:59:00	2026-10-18 02:23:31	USED	KEEP — primary key
host_726.schedule.step.UQ_AssetQueue	3	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:31	COLD	review carefully — unique
host_726.schedule.step.UQ_OrdersLine	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:31	COLD	review carefully — unique
host_726.schedule.ShipmentResult.PK_MeterSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:31	COLD	KEEP — primary key
host_726.schedule.WarehouseEntry.PK_SettlementLine	1	CLUSTERED	Y	Y		5279799	971989	0	0	2026-10-20 00:59:00	2026-10-18 02:23:31	USED	KEEP — primary key
host_726.schedule.WarehouseEntry.UQ_ShiftSnapshot	2	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:31	COLD	review carefully — unique
host_726.schedule.WarehouseEntry.UX_OrdersLog	3	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-10-18 02:23:31	COLD	review carefully — unique
host_726.wps.ContractStatus.IX_RosterDaily	3	NONCLUSTERED				0	0	0	2328	never	2026-10-18 02:23:31	UNUSED	review, then DROP
host_726.wps.ContractStatus.PK_ClaimLog	1	CLUSTERED	Y	Y		0	2328	0	2328	2026-10-20 01:00:06	2026-10-18 02:23:31	USED	KEEP — primary key
host_726.wps.ContractStatus.UX_TerritoryResult	2	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-10-18 02:23:31	COLD	review carefully — unique
host_726.wps.ContractStatus.UX_SettlementDetail	4	NONCLUSTERED	Y			0	0	0	0	never	2026-10-18 02:23:31	COLD	review carefully — unique
host_726.wps.PolicyResult.IX_ContractSnapshot	2	NONCLUSTERED				0	0	0	0	never	2026-10-18 02:23:31	COLD	review, then DROP
host_726.wps.PolicyResult.PK_SettlementLine	1	CLUSTERED	Y	Y		10	103	0	0	2026-10-20 00:51:42	2026-10-18 02:23:31	USED	KEEP — primary key
host_726.wps.LedgerMonthly.PK_BookingResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:31	COLD	KEEP — primary key
host_726.wps.BookingStaging.PK_ClaimHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:31	COLD	KEEP — primary key
host_726.wps.SalesHeader.PK_ContractHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:31	COLD	KEEP — primary key
host_726.wps.ForecastResult.PK_QuotaLog	1	CLUSTERED	Y	Y		19	1	9145	6	2026-10-20 00:56:09	2026-10-19 02:22:21	USED	KEEP — primary key
host_726.wps.ForecastResult.UQ_ShipmentArchive	4	NONCLUSTERED	Y			9324	0	0	6	2026-10-20 00:56:09	2026-10-19 02:22:21	USED	keep — in use
host_726.wps.StaffingResult.PK_RosterStatus	1	CLUSTERED	Y	Y		0	2518	0	0	2026-10-20 01:00:00	2026-10-18 02:23:31	USED	KEEP — primary key
host_726.wps.StaffingStaging.PK_PolicyEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:31	COLD	KEEP — primary key
host_726.wps.QuotaDetail.PK_BatchQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:31	COLD	KEEP — primary key
host_726.wps.OrdersLog.PK_WarehouseArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:32	COLD	KEEP — primary key
host_726.wps.TerritoryQueue.IX_InvoiceAudit	11	NONCLUSTERED				83	0	0	56	2026-10-20 00:51:08	2026-10-19 02:22:21	USED	keep — in use
host_726.wps.TerritoryQueue.PK_RosterSnapshot	1	CLUSTERED	Y	Y		0	14	213	56	2026-10-20 00:52:06	2026-10-19 02:22:21	USED	KEEP — primary key
host_726.wps.TerritoryQueue.UX_MeterStaging	2	NONCLUSTERED	Y			12	122	0	3	2026-10-20 00:51:42	2026-10-19 02:22:21	USED	keep — in use
host_726.wps.ContractEntry.PK_PayrollSummary	1	CLUSTERED	Y	Y		0	0	0	3	never	2026-10-19 02:22:21	UNUSED	KEEP — primary key
host_726.wps.TicketStatus.PK_InvoiceMonthly	1	CLUSTERED	Y	Y		0	1864	0	10	2026-10-20 00:52:06	2026-10-19 02:22:21	USED	KEEP — primary key
host_726.wps.SalesDetail.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	6	never	2026-10-19 02:22:21	UNUSED	KEEP — primary key
host_726.wps.ClaimResult.PK_TicketEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:32	COLD	KEEP — primary key
host_726.wps.CatalogSnapshot.PK_ForecastHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:32	COLD	KEEP — primary key
host_726.wps.BillingLine.PK_RosterResult	1	CLUSTERED	Y	Y		17	1697	0	0	2026-10-19 23:59:00	2026-10-18 02:23:32	USED	KEEP — primary key
host_726.wps.BillingLine.UX_WarehouseLog	2	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-10-18 02:23:32	COLD	review carefully — unique
host_726.wps.BatchStatus.PK_ClaimLine	1	CLUSTERED	Y	Y		0	157	128	0	2026-10-20 00:52:06	2026-10-18 02:23:32	USED	KEEP — primary key
host_726.wps.BatchStatus.UQ_CustomerHeader	2	NONCLUSTERED	Y			128	0	0	0	2026-10-20 00:51:08	2026-10-18 02:23:32	USED	keep — in use
host_726.wps.BookingResult.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:32	COLD	KEEP — primary key
host_726.wps.BookingStaging.PK_ForecastLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-10-18 02:23:32	COLD	KEEP — primary key
ASSET_Prod.dbo.PricingHeader.IX_StaffingHeader	3	NONCLUSTERED				0	0	0	10	never	2026-10-14 07:47:41	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.IX_QuotaAudit	4	NONCLUSTERED				0	0	0	10	never	2026-10-14 07:47:41	UNUSED	review, then DROP
ASSET_Prod.dbo.PricingHeader.PK_CatalogDaily	1	CLUSTERED	Y	Y		2415	493	0	23	2026-10-19 19:09:13	2026-10-14 07:47:42	USED	KEEP — primary key
ASSET_Prod.dbo.PricingHeader.UX_QuotaMonthly	2	NONCLUSTERED	Y			0	0	0	10	never	2026-10-14 07:47:41	UNUSED	review carefully — unique
ASSET_Prod.dbo.RouteSnapshot.IX_ContractHeader	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 08:14:24	COLD	review, then DROP
ASSET_Prod.dbo.RouteSnapshot.PK_ContractStatus	1	CLUSTERED	Y	Y		0	152	0	0	2026-10-19 16:04:26	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	0	0	0	never	never	COLD	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	2	0	0	2026-10-19 10:26:20	never	USED	KEEP — primary key
ASSET_Prod.dbo.SalesEntry.PK_BookingAudit	1	CLUSTERED	Y	Y		0	0	2	0	2026-10-19 13:55:42	never	USED	KEEP — primary key
ASSET_Prod.dbo.SalesEntry.UX_ShiftSnapshot	2	NONCLUSTERED	Y			2	0	0	0	2026-10-19 13:55:42	2026-07-29 08:09:18	USED	keep — in use
ASSET_Prod.dbo.RosterDaily.IX_RouteLine	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 09:40:40	COLD	review, then DROP
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	0	0	0	never	never	COLD	KEEP — primary key
ASSET_Prod.dbo.ContractStaging.IX_InvoiceLog	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 08:14:24	COLD	review, then DROP
ASSET_Prod.dbo.ContractStaging.PK_TerritorySnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
ASSET_Prod.dbo.BookingEntry.IX_ShipmentStatus	2	NONCLUSTERED				0	0	0	23	never	2026-10-13 09:41:03	UNUSED	review, then DROP
ASSET_Prod.dbo.BookingEntry.PK_SettlementQueue	1	CLUSTERED	Y	Y		0	82	0	23	2026-10-19 19:09:09	never	USED	KEEP — primary key
ASSET_Prod.dbo.ReconcileMonthly.IX_ForecastDetail	2	NONCLUSTERED				0	0	0	0	never	2026-07-29 08:14:24	COLD	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_QuotaSummary	9	NONCLUSTERED			Y	0	0	0	0	never	2026-07-29 08:51:33	COLD	review, then DROP
ASSET_Prod.dbo.ReconcileMonthly.PK_SettlementDetail	1	CLUSTERED	Y	Y		0	1494	0	0	2026-10-19 19:09:13	2026-07-29 09:58:28	USED	KEEP — primary key
ASSET_Prod.dbo.ReconcileMonthly.UX_CustomerDetail	3	NONCLUSTERED	Y		Y	0	0	0	0	never	2026-07-29 08:15:18	COLD	review carefully — unique
ASSET_Prod.dbo.CampaignHeader.IX_SupplierResult	2	NONCLUSTERED				0	0	0	33	never	2026-10-19 10:13:13	UNUSED	review, then DROP
ASSET_Prod.dbo.CampaignHeader.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	2387	0	33	2026-10-19 19:09:09	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	0	0	0	never	2026-07-31 02:39:58	COLD	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	0	0	0	never	2026-07-29 09:41:31	COLD	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	38	never	2026-10-17 11:03:00	UNUSED	review, then DROP
ASSET_Prod.dbo.ForecastDetail.PK_BillingHistory	1	CLUSTERED	Y	Y		0	262	0	38	2026-10-20 00:07:00	2026-10-17 11:03:00	USED	KEEP — primary key
ASSET_Prod.dbo.ContractSummary.PK_BillingMonthly	1	CLUSTERED	Y	Y		38	38	0	114	2026-10-20 00:07:00	2026-10-17 11:02:51	USED	KEEP — primary key
ASSET_Prod.dbo.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	80	0	0	2026-10-19 16:04:26	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	0	0	0	never	2026-07-31 02:41:20	COLD	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				42	0	0	0	2026-10-19 15:58:51	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	203	0	2026-10-19 17:56:53	2026-07-31 11:16:08	USED	KEEP — primary key
ASSET_Prod.dbo.SalesSnapshot.UX_ShiftResult	2	NONCLUSTERED	Y			203	0	0	0	2026-10-19 17:56:53	2026-07-29 11:14:33	USED	keep — in use
ASSET_Prod.dbo.RouteHistory.PK_BillingArchive	1	CLUSTERED	Y	Y		74	103	0	0	2026-10-20 00:07:00	2026-07-29 08:07:17	USED	KEEP — primary key