Index Usage — ACME-192-0-2-243

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

Index Usage Report — ACME-192-0-2-243

Host: 192.0.2.243

Collected: 2026-09-15T18:01:15Z

Server dashboard: http://192.0.2.15:8080/report_dba/server-metrics.html?server=ACME-192-0-2-243

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

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

Metric	Count	Meaning
indexes_total	956	every index on a CatalogHistory table
used	376	had a seek, scan or lookup
unused	71	written but never read
cold	509	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	67	nonclustered, not unique, no constraint, never read
fragmented	1	above the rebuild threshold

By database

Database	Total	Cold	Droppable	Recommend action
BATCH_Test	188	152	24	review the drop candidates above
PPG	144	107	21	review the drop candidates above
SALES	187	99	20	review the drop candidates above
host-315	125	21	2	review the drop candidates above
CLAIM_Prod	58	58	0	no action — cold indexes here are constraints or clustered
CONTRACT	58	57	0	no action — cold indexes here are constraints or clustered
host-347	129	13	0	no action — cold indexes here are constraints or clustered
APP	22	1	0	no action — cold indexes here are constraints or clustered
PAYROLL	1	1	0	no action — cold indexes here are constraints or clustered

Drop candidates (67)

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
SALES.kar.RosterSummary.IX_PricingDetail	278882	never	UNUSED	review, then DROP
SALES.kar.RosterSummary.IX_InvoiceDaily	13	never	UNUSED	review, then DROP
BATCH_Test.dbo.Dashboard.IX_SupplierDaily	6	never	UNUSED	review, then DROP
BATCH_Test.kar.RosterSummary.IX_InvoiceDaily	5	never	UNUSED	review, then DROP
SALES.dbo.History.IX_PolicyDetail	0	never	UNUSED	review, then DROP
SALES.dbo.History.IX_ContractQueue	0	never	UNUSED	review, then DROP
SALES.dbo.History.IX_OrdersLog	0	never	UNUSED	review, then DROP
SALES.dbo.MeterMonthly.IX_RouteHeader	0	never	COLD	review, then DROP
SALES.dbo.LedgerStaging.IX_CatalogStatus	0	never	COLD	review, then DROP
SALES.dbo.LedgerStaging.IX_StaffingSnapshot	0	never	COLD	review, then DROP
SALES.dbo.PricingLine.IX_LedgerDetail	0	never	COLD	review, then DROP
SALES.dbo.PricingLine.IX_RosterSummary	0	never	COLD	review, then DROP
SALES.dbo.LedgerStatus.IX_CampaignQueue	0	never	COLD	review, then DROP
SALES.dbo.CustomerSummary.IX_BatchAudit	0	never	COLD	review, then DROP
SALES.dbo.QuotaAudit.IX_OrdersAudit	0	never	COLD	review, then DROP
SALES.dbo.Task.IX_PayrollDaily	0	never	COLD	review, then DROP
SALES.dbo.TicketDaily.IX_RouteMonthly	0	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_AssetEntry	0	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_RosterDaily	0	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_TicketLog	0	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_RosterHistory	0	never	COLD	review, then DROP
SALES.kar.LedgerLog.IX_PricingAudit	0	never	COLD	review, then DROP
BATCH_Test.dbo.MeterMonthly.IX_RouteHeader	0	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStaging.IX_CatalogStatus	0	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStaging.IX_StaffingSnapshot	0	never	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.IX_PayrollResult	0	never	COLD	review, then DROP
BATCH_Test.dbo.PricingLine.IX_LedgerDetail	0	never	COLD	review, then DROP
BATCH_Test.dbo.PricingLine.IX_RosterSummary	0	never	COLD	review, then DROP
BATCH_Test.dbo.History.IX_PolicyDetail	0	never	COLD	review, then DROP
BATCH_Test.dbo.History.IX_ContractQueue	0	never	COLD	review, then DROP
BATCH_Test.dbo.History.IX_OrdersLog	0	never	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.IX_RosterResult	0	never	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.IX_StaffingLog	0	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStatus.IX_CampaignQueue	0	never	COLD	review, then DROP
BATCH_Test.dbo.CustomerSummary.IX_BatchAudit	0	never	COLD	review, then DROP
BATCH_Test.dbo.QuotaAudit.IX_OrdersAudit	0	never	COLD	review, then DROP
BATCH_Test.dbo.Task.IX_PayrollDaily	0	never	COLD	review, then DROP
BATCH_Test.dbo.TicketDaily.IX_RouteMonthly	0	never	COLD	review, then DROP
BATCH_Test.dbo.TerritorySnapshot.IX_SupplierEntry	0	never	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_AssetEntry	0	never	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_RosterDaily	0	never	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_TicketLog	0	never	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_RosterHistory	0	never	COLD	review, then DROP
PPG.dbo.MeterMonthly.IX_RouteHeader	0	never	COLD	review, then DROP
PPG.dbo.LedgerStaging.IX_CatalogStatus	0	never	COLD	review, then DROP
PPG.dbo.LedgerStaging.IX_StaffingSnapshot	0	never	COLD	review, then DROP
PPG.dbo.PricingLine.IX_LedgerDetail	0	never	COLD	review, then DROP
PPG.dbo.PricingLine.IX_RosterSummary	0	never	COLD	review, then DROP
PPG.dbo.LedgerStatus.IX_CampaignQueue	0	never	COLD	review, then DROP
PPG.dbo.CustomerSummary.IX_BatchAudit	0	never	COLD	review, then DROP
PPG.dbo.QuotaAudit.IX_OrdersAudit	0	never	COLD	review, then DROP
PPG.dbo.Task.IX_PayrollDaily	0	never	COLD	review, then DROP
PPG.dbo.TicketDaily.IX_RouteMonthly	0	never	COLD	review, then DROP
PPG.dbo.TerritorySnapshot.IX_SupplierEntry	0	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_AssetEntry	0	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_RosterDaily	0	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_TicketLog	0	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_RosterHistory	0	never	COLD	review, then DROP
host-315.pto.ContractEntry.IX_CustomerDaily	0	never	COLD	review, then DROP
BATCH_Test.kar.LedgerLog.IX_PricingAudit	0	never	UNUSED	review, then DROP
PPG.dbo.History.IX_PolicyDetail	0	never	UNUSED	review, then DROP
PPG.dbo.History.IX_ContractQueue	0	never	UNUSED	review, then DROP
PPG.dbo.History.IX_OrdersLog	0	never	UNUSED	review, then DROP
PPG.dbo.SettlementDetail.IX_RosterResult	0	never	UNUSED	review, then DROP
PPG.dbo.SettlementDetail.IX_PayrollResult	0	never	UNUSED	review, then DROP
PPG.dbo.SettlementDetail.IX_StaffingLog	0	never	UNUSED	review, then DROP
host-315.pto.ClaimResult.IX_ContractDetail	0	never	COLD	review, then DROP

Fragmented (1)

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

Index	Part	Type	Frag	Pages	Size MB	Stats updated	Action
SALES\kar.ContractStaging.PK_CustomerSummary	1/1	CLUSTERED	44.9%	1,334	10.4	2026-09-15 16:25:19	REORGANIZE

All indexes (956)

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
APP.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y		1910297	1074	13153187	1040	2026-09-15 20:22:23	2026-09-16 01:00:00	USED	KEEP — primary key
APP.app.ShiftAudit.UX_PayrollAudit	4	NONCLUSTERED	Y			13154154	500	0	504	2026-09-15 20:22:23	2026-09-16 01:00:00	USED	keep — in use
APP.app.ReconcileDaily.PK_LedgerResult	1	CLUSTERED	Y	Y		10052560	17	0	13276	2026-09-15 20:22:23	2026-07-01 01:00:01	USED	KEEP — primary key
APP.app.PolicyStatus.PK_RouteArchive	1	CLUSTERED	Y	Y		990	11	0	6	2026-09-14 16:01:25	2026-05-16 01:00:01	USED	KEEP — primary key
APP.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	1	0	1024	2025-12-15 10:27:19	never	USED	KEEP — primary key
APP.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	2	0	13276	2025-12-15 10:49:01	never	USED	KEEP — primary key
APP.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		2748296	1361704	0	3	2026-09-15 20:22:18	2026-01-11 01:00:01	USED	KEEP — primary key
APP.app.CampaignAudit.PK_BillingMonthly	1	CLUSTERED	Y	Y		1837	12	0	235	2026-09-14 16:01:46	2026-05-12 01:00:01	USED	KEEP — primary key
APP.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		2001	2747474	0	77	2026-09-15 20:22:18	2026-07-01 01:00:01	USED	KEEP — primary key
APP.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	1	0	65	2025-12-15 08:50:36	never	USED	KEEP — primary key
APP.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		454	1004	0	57	2026-08-28 13:19:05	2026-02-27 01:00:01	USED	KEEP — primary key
APP.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y		0	1	0	0	2026-02-12 09:45:58	never	USED	KEEP — primary key
APP.app.BatchQueue.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	1	0	0	2026-02-12 09:46:25	never	USED	KEEP — primary key
APP.app.CampaignMonthly.PK_CatalogHeader	1	CLUSTERED	Y	Y		1361681	425	0	48	2026-09-15 20:22:18	2026-03-04 01:00:01	USED	KEEP — primary key
APP.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		1386761	52	0	51	2026-09-15 20:22:18	2026-02-27 01:00:01	USED	KEEP — primary key
APP.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	48	never	never	UNUSED	KEEP — primary key
APP.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	751	0	0	2026-06-30 09:58:25	never	USED	KEEP — primary key
APP.app.ReconcileSnapshot.PK_SupplierArchive	1	CLUSTERED	Y	Y		0	1	0	0	2026-02-12 09:49:30	never	USED	KEEP — primary key
APP.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y		1386507	1096	0	32	2026-09-15 20:22:18	2026-01-11 01:00:01	USED	KEEP — primary key
APP.app.ClaimResult.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	1	0	0	2026-02-12 09:50:39	never	USED	KEEP — primary key
APP.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
APP.dbo.ContractEntry.PK_SettlementStatus	1	CLUSTERED	Y	Y		0	1	0	22	2026-02-12 09:51:56	never	USED	KEEP — primary key
PAYROLL.dbo.SupplierStatus.PK_BookingHeader	1	CLUSTERED	Y	Y		1	5	0	4	2026-03-11 15:43:24	never	USED	KEEP — primary key
PAYROLL.dbo.CRED_1060.PK_BatchSnapshot	1	CLUSTERED	Y	Y		0	5	0	2	2026-02-26 14:45:40	never	USED	KEEP — primary key
PAYROLL.dbo.OrdersDaily.PK_ShiftResult	1	CLUSTERED	Y	Y		0	2	0	4	2026-02-26 15:52:45	never	USED	KEEP — primary key
report.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		0	1447	0	1437	2026-07-18 12:32:26	never	USED	KEEP — primary key
report.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	4	0	1437	2025-11-28 08:28:38	never	USED	KEEP — primary key
report.emp.ForecastStatus.PK_CampaignDetail	1	CLUSTERED	Y	Y		0	2874	0	1434	2026-08-03 10:25:49	2026-07-10 16:50:02	USED	KEEP — primary key
RECONCILE.inc.Incident.PK_CatalogDaily	1	CLUSTERED	Y	Y		898	398	0	39	2026-09-14 16:01:25	2026-07-25 01:00:01	USED	KEEP — primary key
RECONCILE.inc.Incident.UX_PolicyDetail	2	NONCLUSTERED	Y			0	0	0	29	never	2026-07-25 01:00:01	UNUSED	review carefully — unique
RECONCILE.inc.CatalogResult.PK_SettlementAudit	1	CLUSTERED	Y	Y		0	83	0	29	2026-07-24 13:32:50	never	USED	KEEP — primary key
RECONCILE.inc.CatalogResult.UX_WarehouseStatus	2	NONCLUSTERED	Y			0	0	0	29	never	2026-07-25 01:00:01	UNUSED	review carefully — unique
RECONCILE.inc.CampaignDaily.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	3	0	28	2025-12-23 14:56:46	never	USED	KEEP — primary key
RECONCILE.inc.MeterResult.PK_TicketSummary	1	CLUSTERED	Y	Y		0	4	0	2	2026-05-15 07:29:34	never	USED	KEEP — primary key
RECONCILE.inc.BookingDetail.PK_BookingHeader	1	CLUSTERED	Y	Y		0	486	0	29	2026-09-14 16:01:25	never	USED	KEEP — primary key
RECONCILE.inc.BookingDetail.UX_SettlementLog	2	NONCLUSTERED	Y			78	127	0	29	2026-07-24 13:32:50	2026-07-25 01:00:01	USED	keep — in use
RECONCILE.inc.AssetSummary.PK_BillingHistory	1	CLUSTERED	Y	Y		0	3	0	28	2025-12-23 14:56:46	never	USED	KEEP — primary key
RECONCILE.inc.OrdersHeader.PK_SupplierDetail	1	CLUSTERED	Y	Y		0	5	0	29	2026-05-15 07:29:34	never	USED	KEEP — primary key
RECONCILE.inc.OrdersHeader.UX_TerritoryLine	2	NONCLUSTERED	Y			78	0	0	29	2026-07-24 13:32:50	2026-07-25 01:00:01	USED	keep — in use
RECONCILE.inc.TicketLog.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	7	0	29	2026-05-15 07:31:13	never	USED	KEEP — primary key
RECONCILE.inc.StaffingArchive.PK_RouteArchive	1	CLUSTERED	Y	Y		0	3	0	28	2025-12-23 14:56:46	never	USED	KEEP — primary key
RECONCILE.inc.ContractHeader.PK_RosterHistory	1	CLUSTERED	Y	Y		0	3	0	28	2025-12-23 14:56:46	never	USED	KEEP — primary key
RECONCILE.inc.QuotaEntry.PK_ReconcileArchive	1	CLUSTERED	Y	Y		0	2	0	36	2026-05-15 07:27:31	never	USED	KEEP — primary key
RECONCILE.inc.StaffingQueue.PK_LedgerHistory	1	CLUSTERED	Y	Y		0	3	0	27	2026-05-15 07:29:34	never	USED	KEEP — primary key
RECONCILE.inc.StaffingQueue.UX_PayrollEntry	2	NONCLUSTERED	Y			76	0	0	27	2026-07-24 13:32:50	2026-07-25 01:00:01	USED	keep — in use
RECONCILE.inc.ForecastHistory.PK_LedgerLine	1	CLUSTERED	Y	Y		0	1	0	26	2025-12-15 08:42:11	never	USED	KEEP — primary key
RECONCILE.inc.ShipmentArchive.PK_PolicySnapshot	1	CLUSTERED	Y	Y		75	588	0	0	2026-09-14 16:00:34	2025-10-14 16:04:26	USED	KEEP — primary key
RECONCILE.inc.CampaignDaily.PK_ShiftStaging	1	CLUSTERED	Y	Y		599	1724	0	3	2026-09-14 16:01:25	2026-01-11 01:00:02	USED	KEEP — primary key
RECONCILE.inc.RosterArchive.PK_ContractQueue	1	CLUSTERED	Y	Y		69	598	0	1	2026-09-14 16:00:34	2026-01-11 01:00:02	USED	KEEP — primary key
RECONCILE.inc.RosterArchive.UX_InvoiceAudit	2	NONCLUSTERED	Y			0	0	0	1	never	2026-01-11 01:00:02	UNUSED	review carefully — unique
RECONCILE.inc.SalesEntry.PK_BillingQueue	1	CLUSTERED	Y	Y		0	722	0	2	2026-09-14 16:00:34	2026-05-16 01:00:01	USED	KEEP — primary key
host-315.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y		123088	6754075	740692	58	2026-09-15 21:20:34	2026-08-27 01:00:03	USED	KEEP — primary key
host-315.app.ShiftAudit.UX_PayrollAudit	2	NONCLUSTERED	Y			23	182666	0	58	2026-09-15 19:45:37	2026-08-27 01:00:03	USED	keep — in use
host-315.app.ShiftAudit.UX_BillingStatus	3	NONCLUSTERED	Y			928131	0	0	58	2026-09-15 21:20:34	2026-08-27 01:00:03	USED	keep — in use
host-315.app.SettlementEntry.PK_ContractLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		0	1	0	0	2025-12-16 13:09:25	2025-12-16 13:09:25	USED	KEEP — primary key
host-315.app.BillingAudit.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		906392	459	0	500	2026-09-15 21:20:34	2026-09-15 01:00:05	USED	KEEP — primary key
host-315.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		441503	465449	0	78	2026-09-15 21:20:34	2026-08-28 01:00:03	USED	KEEP — primary key
host-315.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	78	never	2026-09-15 01:00:05	UNUSED	review carefully — unique
host-315.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		1675760	0	0	1268	2026-09-15 21:20:34	2026-09-15 01:00:05	USED	KEEP — primary key
host-315.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	16	0	0	2026-04-17 20:36:48	never	USED	KEEP — primary key
host-315.app.InvoiceLine.UX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host-315.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y		101321	821917	0	7	2026-09-15 21:20:34	2026-08-27 01:00:03	USED	KEEP — primary key
host-315.app.CatalogMonthly.UX_RouteQueue	2	NONCLUSTERED	Y			3	8	0	5	2026-08-26 21:00:37	2026-08-27 01:00:03	USED	keep — in use
host-315.app.ClaimResult.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.bm.PricingQueue.PK_InvoiceArchive	1	CLUSTERED	Y	Y		2730760	113217	4	41086	2026-09-15 21:15:13	2026-09-16 01:00:02	USED	KEEP — primary key
host-315.bm.PricingQueue.UX_InvoiceLog	2	NONCLUSTERED	Y			188413	40327	0	9767	2026-09-15 21:14:51	2026-09-16 01:00:02	USED	keep — in use
host-315.bm.RosterDetail.PK_QuotaArchive	1	CLUSTERED	Y	Y		356656	3974228	0	31794	2026-09-15 21:15:13	2026-09-16 01:00:02	USED	KEEP — primary key
host-315.bm.MeterEntry.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	1	0	9769	2026-04-23 12:53:05	never	USED	KEEP — primary key
host-315.bm.MeterHistory.PK_BillingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.bm.QuotaEntry.PK_InvoiceAudit	1	CLUSTERED	Y	Y		0	6	0	19061	2026-09-14 09:18:10	never	USED	KEEP — primary key
host-315.bm.OrdersResult.PK_SupplierStaging	1	CLUSTERED	Y	Y		1349184	2655527	624150	170842	2026-09-15 21:20:34	2026-09-16 01:00:02	USED	KEEP — primary key
host-315.bm.OrdersResult.UX_PolicyMonthly	2	NONCLUSTERED	Y			1014281	27938	0	26039	2026-09-15 21:20:34	2026-09-16 01:00:02	USED	keep — in use
host-315.bm.TicketAudit.PK_WarehouseQueue	1	CLUSTERED	Y	Y		20051	89986	0	9153	2026-09-15 20:56:49	2026-09-16 01:00:03	USED	KEEP — primary key
host-315.bm.TicketLog.PK_SalesStaging	1	CLUSTERED	Y	Y		40120	89990	0	29206	2026-09-15 20:56:49	2026-09-16 01:00:03	USED	KEEP — primary key
host-315.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		952900	0	0	0	2026-09-15 21:20:34	2025-08-01 01:00:56	USED	KEEP — primary key
host-315.dbo.BatchResult.PK_PolicySummary	1	CLUSTERED	Y	Y		1	565337	0	244159	2026-09-15 17:51:50	2026-09-16 01:00:03	USED	KEEP — primary key
host-315.dbo.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		4324295	869021	81	78	2026-09-15 21:20:34	2026-09-04 01:00:04	USED	KEEP — primary key
host-315.dbo.CatalogQueue.UX_ReconcileStaging	2	NONCLUSTERED	Y			14983	849849	0	78	2026-09-15 21:20:34	2026-09-04 01:00:04	USED	keep — in use
host-315.dbo.OrdersAudit.PK_ReconcileStatus	1	CLUSTERED	Y	Y		4201954	1174303	7	1965	2026-09-15 21:20:34	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.dbo.OrdersAudit.UX_OrdersEntry	2	NONCLUSTERED	Y			31549	4871	0	1964	2026-09-15 19:43:25	2026-09-16 01:00:04	USED	keep — in use
host-315.dbo.PricingMonthly.PK_LedgerDetail	1	CLUSTERED	Y	Y		0	0	0	1830	never	never	UNUSED	KEEP — primary key
host-315.flx.SettlementResult.PK_ContractResult	1	CLUSTERED	Y	Y		130942	157628	0	17	2026-09-15 20:43:38	2026-07-05 01:00:05	USED	KEEP — primary key
host-315.flx.InvoiceAudit.PK_CatalogAudit	1	CLUSTERED	Y	Y		301	11313	0	15	2026-09-15 17:47:49	never	USED	KEEP — primary key
host-315.flx.ClaimHeader.PK_SalesStaging	1	CLUSTERED	Y	Y		7	61	0	16	2026-06-19 14:58:39	2026-06-19 13:09:33	USED	KEEP — primary key
host-315.flx.ShiftStaging.PK_PricingHeader	1	CLUSTERED	Y	Y		14664	8198	0	7332	2026-09-15 20:43:38	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.InvoiceLine.PK_SettlementMonthly	1	CLUSTERED	Y	Y		645	5516	28726	844	2026-09-16 00:00:57	2026-09-15 01:00:09	USED	KEEP — primary key
host-315.flx.InvoiceLine.UQ_LedgerResult	2	NONCLUSTERED	Y			32974	19	0	551	2026-09-15 19:49:00	2026-09-15 01:00:09	USED	keep — in use
host-315.flx.AssetLog.PK_ContractLine	1	CLUSTERED	Y	Y		0	21800	0	628	2026-09-16 00:00:57	2026-09-15 01:00:09	USED	KEEP — primary key
host-315.flx.CustomerLine.IX_SalesEntry	2	NONCLUSTERED				3688	1240	0	986	2026-09-15 13:04:20	2026-09-16 01:00:04	USED	keep — in use
host-315.flx.CustomerLine.PK_ClaimAudit	1	CLUSTERED	Y	Y		82587	15483	44	988	2026-09-15 19:49:00	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.CustomerLine.IX_InvoiceSummary	14	NONCLUSTERED	Y			0	4523	0	818	2026-09-15 12:57:14	2026-09-16 01:00:04	USED	keep — in use
host-315.flx.BatchSummary.PK_MeterResult	1	CLUSTERED	Y	Y		0	0	0	10	never	never	UNUSED	KEEP — primary key
host-315.flx.OrdersMonthly.IX_RosterMonthly	6	NONCLUSTERED				30916	0	0	14937	2026-09-15 17:51:08	2026-09-16 01:00:04	USED	keep — in use
host-315.flx.OrdersMonthly.PK_PolicySnapshot	1	CLUSTERED	Y	Y		16880	85658	30902	14951	2026-09-15 17:54:27	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.SalesLog.PK_ContractAudit	1	CLUSTERED	Y	Y		0	25450	0	11135	2026-09-15 17:54:27	never	USED	KEEP — primary key
host-315.flx.PolicyDetail.PK_AssetSnapshot	1	CLUSTERED	Y	Y		0	4842	0	2040	2026-09-15 17:54:27	never	USED	KEEP — primary key
host-315.flx.RosterStatus.PK_TerritoryHistory	1	CLUSTERED	Y	Y		36485	43793	0	14220	2026-09-15 17:51:06	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.ClaimHeader.IX_WarehouseMonthly	15	NONCLUSTERED				267945	6	0	1758	2026-09-15 19:48:51	2026-09-16 01:00:04	USED	keep — in use
host-315.flx.ClaimHeader.PK_BatchAudit	1	CLUSTERED	Y	Y		698899	191162	218321	1803	2026-09-15 20:04:28	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.ClaimHeader.UX_SupplierDetail	2	NONCLUSTERED	Y			1102	32	0	1799	2026-09-15 15:14:46	2026-09-16 01:00:04	USED	keep — in use
host-315.flx.ShiftArchive.PK_PricingEntry	1	CLUSTERED	Y	Y		0	1573	0	192	2026-09-15 15:37:44	never	USED	KEEP — primary key
host-315.flx.QuotaStatus.PK_SalesResult	1	CLUSTERED	Y	Y		15	1564	0	11	2026-09-15 15:37:17	2026-09-10 01:00:05	USED	KEEP — primary key
host-315.flx.SupplierDetail.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		0	9	0	11	2026-08-28 14:54:57	never	USED	KEEP — primary key
host-315.flx.ContractQueue.PK_QuotaEntry	1	CLUSTERED	Y	Y		0	6	0	1882	2026-09-14 09:35:14	never	USED	KEEP — primary key
host-315.flx.PricingHistory.IX_ShiftDaily	2	NONCLUSTERED				502681	21	0	4864	2026-09-15 19:49:00	2026-09-16 01:00:04	USED	keep — in use
host-315.flx.PricingHistory.PK_ReconcileHistory	1	CLUSTERED	Y	Y		1734	52134	379120	4864	2026-09-15 19:49:00	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.MeterArchive.IX_BatchHeader	2	NONCLUSTERED				537127	17	0	10799	2026-09-15 19:49:00	2026-09-16 01:00:04	USED	keep — in use
host-315.flx.MeterArchive.PK_BatchDaily	1	CLUSTERED	Y	Y		3940	16663	413655	10809	2026-09-15 19:49:00	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.InvoiceLine.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	8	0	7732	2026-08-19 19:33:14	never	USED	KEEP — primary key
host-315.flx.BookingLog.PK_CatalogLine	1	CLUSTERED	Y	Y		0	5	0	3484	2026-04-11 14:15:45	never	USED	KEEP — primary key
host-315.flx.PayrollSnapshot.PK_LedgerResult	1	CLUSTERED	Y	Y		2488433	33864	0	2103	2026-09-15 19:49:08	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.SettlementLine.PK_QuotaHistory	1	CLUSTERED	Y	Y		63284	2613668	0	4957	2026-09-15 19:49:08	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.SettlementLine.PK_SettlementEntry	1	CLUSTERED	Y	Y		0	175529	0	8232	2026-09-15 19:49:08	never	USED	KEEP — primary key
host-315.flx.ShiftLine.PK_StaffingStaging	1	CLUSTERED	Y	Y		0	7	0	3590	2026-08-19 19:36:53	never	USED	KEEP — primary key
host-315.flx.TicketDaily.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	5039	never	never	UNUSED	KEEP — primary key
host-315.flx.MeterStaging.PK_CatalogResult	1	CLUSTERED	Y	Y		0	0	0	1610	never	never	UNUSED	KEEP — primary key
host-315.flx.StaffingLine.PK_PolicyHistory	1	CLUSTERED	Y	Y		67652	383900	0	74305	2026-09-15 20:43:38	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.ForecastQueue.PK_BillingEntry	1	CLUSTERED	Y	Y		20	14351	0	267	2026-09-15 17:47:53	never	USED	KEEP — primary key
host-315.flx.QuotaResult.PK_InvoiceArchive	1	CLUSTERED	Y	Y		0	0	0	726	never	never	UNUSED	KEEP — primary key
host-315.flx.CustomerSummary.PK_PricingLine	1	CLUSTERED	Y	Y		0	185948	0	60677	2026-09-15 17:47:54	never	USED	KEEP — primary key
host-315.flx.RouteAudit.PK_ContractStatus	1	CLUSTERED	Y	Y		9009	3167	2177	920	2026-09-15 19:48:36	2026-09-06 01:00:05	USED	KEEP — primary key
host-315.flx.RouteAudit.UX_BookingEntry	2	NONCLUSTERED	Y			2401	5041	0	219	2026-09-15 13:35:18	2026-09-06 01:00:05	USED	keep — in use
host-315.flx.MeterSummary.PK_PolicyResult	1	CLUSTERED	Y	Y		415	9621	0	2062	2026-09-15 19:48:36	never	USED	KEEP — primary key
host-315.flx.ContractDetail.PK_CampaignStaging	1	CLUSTERED	Y	Y		0	0	0	1	never	never	UNUSED	KEEP — primary key
host-315.flx.WarehouseDaily.PK_QuotaLog	1	CLUSTERED	Y	Y		0	0	0	5	never	never	UNUSED	KEEP — primary key
host-315.flx.TicketStaging.PK_ForecastArchive	1	CLUSTERED	Y	Y		217085	121704	2346	498	2026-09-15 19:48:36	2026-09-15 01:00:11	USED	KEEP — primary key
host-315.flx.TicketStaging.UX_ShipmentStaging	2	NONCLUSTERED	Y			2674	2686	0	498	2026-09-14 19:57:00	2026-09-15 01:00:11	USED	keep — in use
host-315.flx.MeterLine.PK_SettlementStaging	1	CLUSTERED	Y	Y		213888	122398	0	5157	2026-09-15 20:43:38	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.MeterLine.UX_RouteStatus	2	NONCLUSTERED	Y			1686	125	0	5156	2026-09-15 14:57:06	2026-09-16 01:00:04	USED	keep — in use
host-315.flx.TerritoryArchive.PK_OrdersLine	1	CLUSTERED	Y	Y		34836	2394752	0	1825	2026-09-15 20:43:38	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.flx.PolicyDaily.PK_RosterResult	1	CLUSTERED	Y	Y		0	3	0	305	2026-08-26 20:02:40	never	USED	KEEP — primary key
host-315.flx.PolicyMonthly.PK_PayrollStaging	1	CLUSTERED	Y	Y		0	2	0	304	2026-06-17 07:37:37	never	USED	KEEP — primary key
host-315.flx.ForecastEntry.IX_AssetEntry	2	NONCLUSTERED				10	0	0	5	2026-05-28 15:42:06	2026-08-29 01:00:05	USED	keep — in use
host-315.flx.ForecastEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		2250	1334	0	5	2026-09-15 19:41:31	2026-08-29 01:00:05	USED	KEEP — primary key
host-315.flx.ShiftSnapshot.PK_LedgerMonthly	1	CLUSTERED	Y	Y		0	1	0	2	2026-06-06 09:53:19	never	USED	KEEP — primary key
host-315.flx.ShiftSnapshot.UQ_CatalogDetail	2	NONCLUSTERED	Y			549	4	0	2	2026-09-14 12:45:34	2026-06-07 20:13:04	USED	keep — in use
host-315.inv.Inventory.PK_InvoiceSummary	1	CLUSTERED	Y	Y		790335	1126921	0	270841	2026-09-15 18:03:06	2026-09-16 01:00:04	USED	KEEP — primary key
host-315.inv.SupplierStatus.PK_PolicySnapshot	1	CLUSTERED	Y	Y		507613	2448133	548701	151287	2026-09-15 21:17:39	2026-09-16 01:00:05	USED	KEEP — primary key
host-315.inv.SupplierStatus.UX_SalesHeader	6	NONCLUSTERED	Y			600654	4873	0	60077	2026-09-15 21:17:39	2026-09-16 01:00:05	USED	keep — in use
host-315.inv.ShipmentDetail.PK_WarehouseSummary	1	CLUSTERED	Y	Y		606922	177702	0	132734	2026-09-15 21:17:39	2026-09-16 01:00:05	USED	KEEP — primary key
host-315.org.BatchDaily.PK_QuotaStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.org.BatchDaily.UX_PricingResult	2	NONCLUSTERED	Y			0	0	0	0	never	2024-10-05 22:14:24	COLD	review carefully — unique
host-315.po.PO.PK_SettlementDaily	1	CLUSTERED	Y	Y		5698342	902710	32174	88237	2026-09-15 21:20:34	2026-09-16 01:00:05	USED	KEEP — primary key
host-315.po.PO.UX_TerritoryMonthly	2	NONCLUSTERED	Y			628276	508196	0	14830	2026-09-15 21:20:34	2026-09-16 01:00:05	USED	keep — in use
host-315.po.ClaimSummary.PK_BatchSnapshot	1	CLUSTERED	Y	Y		1655274	162490	255536	63216	2026-09-15 21:15:13	2026-09-16 01:00:05	USED	KEEP — primary key
host-315.po.ClaimSummary.UX_PayrollResult	2	NONCLUSTERED	Y			335715	1	0	14725	2026-09-15 21:15:13	2026-09-16 01:00:06	USED	keep — in use
host-315.po.RosterLog.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.po.AssetMonthly.PK_PolicyDetail	1	CLUSTERED	Y	Y		0	5	0	62739	2026-06-16 08:51:14	never	USED	KEEP — primary key
host-315.pto.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		0	298	0	0	2026-09-14 16:15:11	never	USED	KEEP — primary key
host-315.pto.ContractHeader.PK_ContractEntry	1	CLUSTERED	Y	Y		640	3	0	0	2026-09-14 16:15:11	never	USED	KEEP — primary key
host-315.pto.ContractHeader.UX_SalesResult	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host-315.pto.SalesHistory.PK_TicketDetail	1	CLUSTERED	Y	Y		57	583	5	0	2026-09-14 16:15:11	never	USED	KEEP — primary key
host-315.pto.SalesHistory.UX_ContractDetail	2	NONCLUSTERED	Y			10	0	0	0	2026-06-24 17:39:46	never	USED	keep — in use
host-315.pto.ClaimResult.IX_ContractDetail	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
host-315.pto.ClaimResult.PK_SalesLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.pto.LedgerResult.IX_TerritoryResult	2	NONCLUSTERED				243	0	0	0	2026-09-12 21:41:21	never	USED	keep — in use
host-315.pto.LedgerResult.PK_TicketArchive	1	CLUSTERED	Y	Y		0	478	243	0	2026-09-14 16:15:11	never	USED	KEEP — primary key
host-315.pto.ContractEntry.IX_CustomerDaily	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
host-315.pto.ContractEntry.PK_SettlementDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.ops.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.ops.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		0	1	0	0	2026-03-23 13:51:17	never	USED	KEEP — primary key
host-315.ops.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.audit.SupplierArchive.PK_PolicyQueue	1	CLUSTERED	Y	Y		125	0	0	0	2026-09-12 21:41:22	never	USED	KEEP — primary key
host-315.audit.CatalogQueue.PK_TicketHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.audit.CampaignLine.PK_MeterStaging	1	CLUSTERED	Y	Y		0	125	0	0	2026-09-12 21:41:22	never	USED	KEEP — primary key
host-315.audit.TicketLog.PK_ReconcileDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.qc.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		14047	54136	0	17	2026-09-15 19:41:58	2026-08-29 01:00:06	USED	KEEP — primary key
host-315.qc.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		12063	645626	0	48761	2026-09-15 21:20:34	2026-09-16 01:00:06	USED	KEEP — primary key
host-315.qc.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	76	0	48743	2026-07-24 10:22:05	2026-09-16 01:00:07	USED	KEEP — primary key
host-315.qc.CampaignSummary.PK_PricingStatus	1	CLUSTERED	Y	Y		492702	538234	0	86191	2026-09-15 21:20:34	2026-09-16 01:00:07	USED	KEEP — primary key
host-347.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y		30012	202265	26773	15	2026-09-15 20:49:40	2026-08-20 01:00:08	USED	KEEP — primary key
host-347.app.ShiftAudit.UX_PayrollAudit	2	NONCLUSTERED	Y			7	2090	0	13	2026-09-15 16:25:00	2026-08-20 01:00:08	USED	keep — in use
host-347.app.ShiftAudit.UX_BillingStatus	3	NONCLUSTERED	Y			27336	1	0	13	2026-09-15 20:30:16	2026-08-20 01:00:08	USED	keep — in use
host-347.app.SettlementEntry.PK_ContractLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		0	2	0	0	2026-04-14 09:36:32	2025-12-16 13:08:59	USED	KEEP — primary key
host-347.app.BillingAudit.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		32364	379	0	10	2026-09-15 20:49:40	2026-08-20 01:00:08	USED	KEEP — primary key
host-347.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		20048	13108	0	41	2026-09-15 20:49:40	2026-05-22 01:00:05	USED	KEEP — primary key
host-347.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	41	never	2026-08-22 01:00:09	UNUSED	review carefully — unique
host-347.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		44357	9	0	482	2026-09-15 20:49:40	2026-08-22 01:00:09	USED	KEEP — primary key
host-347.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	1	0	0	2026-08-21 13:07:16	never	USED	KEEP — primary key
host-347.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.InvoiceLine.UX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host-347.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y		20568	30484	0	15	2026-09-15 20:49:40	2026-08-21 01:00:08	USED	KEEP — primary key
host-347.app.CatalogMonthly.UX_RouteQueue	2	NONCLUSTERED	Y			3	17	0	10	2026-08-21 13:07:44	2026-08-21 01:00:08	USED	keep — in use
host-347.app.ClaimResult.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.bm.PricingQueue.PK_InvoiceArchive	1	CLUSTERED	Y	Y		29118	2650	3	364	2026-09-15 20:49:40	2026-09-16 01:00:08	USED	KEEP — primary key
host-347.bm.PricingQueue.UX_InvoiceLog	2	NONCLUSTERED	Y			785	160	0	173	2026-09-15 08:45:21	2026-09-16 01:00:08	USED	keep — in use
host-347.bm.RosterDetail.PK_QuotaArchive	1	CLUSTERED	Y	Y		949	56279	0	254	2026-09-15 20:49:40	2026-09-16 01:00:08	USED	KEEP — primary key
host-347.bm.MeterEntry.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	1	0	173	2026-04-23 10:52:23	never	USED	KEEP — primary key
host-347.bm.MeterHistory.PK_BillingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.bm.QuotaEntry.PK_InvoiceAudit	1	CLUSTERED	Y	Y		0	0	0	283	never	never	UNUSED	KEEP — primary key
host-347.bm.OrdersResult.PK_SupplierStaging	1	CLUSTERED	Y	Y		3487	28363	1568	634	2026-09-15 20:49:40	2026-09-13 01:00:11	USED	KEEP — primary key
host-347.bm.OrdersResult.UX_PolicyMonthly	2	NONCLUSTERED	Y			1911	13	0	221	2026-09-15 14:37:13	2026-09-13 01:00:11	USED	keep — in use
host-347.bm.TicketAudit.PK_WarehouseQueue	1	CLUSTERED	Y	Y		93	1761	0	99	2026-09-15 20:49:40	2026-09-13 01:00:12	USED	KEEP — primary key
host-347.bm.TicketLog.PK_SalesStaging	1	CLUSTERED	Y	Y		198	1764	0	200	2026-09-15 20:49:40	2026-09-13 01:00:12	USED	KEEP — primary key
host-347.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		25777	0	0	0	2026-09-15 20:49:40	2026-01-11 01:00:05	USED	KEEP — primary key
host-347.dbo.BatchResult.PK_PolicySummary	1	CLUSTERED	Y	Y		0	1451	0	589	2026-09-15 14:32:40	2026-09-13 01:00:13	USED	KEEP — primary key
host-347.dbo.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		44804	6756	0	0	2026-09-15 20:49:40	2026-01-11 01:00:05	USED	KEEP — primary key
host-347.dbo.CatalogQueue.UX_ReconcileStaging	2	NONCLUSTERED	Y			184	24171	0	0	2026-09-15 20:49:40	2026-01-11 01:00:05	USED	keep — in use
host-347.dbo.OrdersAudit.PK_ReconcileStatus	1	CLUSTERED	Y	Y		41824	6923	2	67	2026-09-15 20:49:40	2026-09-13 01:00:13	USED	KEEP — primary key
host-347.dbo.OrdersAudit.UX_QuotaHeader	9	NONCLUSTERED	Y		Y	43	0	0	29	2026-09-12 08:23:02	never	USED	keep — in use
host-347.dbo.OrdersAudit.UX_OrdersEntry	2	NONCLUSTERED	Y			375	317	0	65	2026-09-13 15:30:31	2026-09-13 01:00:13	USED	keep — in use
host-347.dbo.PricingMonthly.PK_LedgerDetail	1	CLUSTERED	Y	Y		0	1	0	64	2026-09-04 09:28:18	never	USED	KEEP — primary key
host-347.flx.BatchQueue.PK_BillingQueue	1	CLUSTERED	Y	Y		0	5	0	2	2026-08-15 11:29:22	2026-08-15 11:29:22	USED	KEEP — primary key
host-347.flx.SettlementResult.PK_ContractResult	1	CLUSTERED	Y	Y		35104	11432	0	42	2026-09-15 20:08:59	2026-08-20 01:00:09	USED	KEEP — primary key
host-347.flx.InvoiceAudit.PK_CatalogAudit	1	CLUSTERED	Y	Y		588	876	0	13	2026-09-10 15:57:22	never	USED	KEEP — primary key
host-347.flx.ShiftStaging.PK_PricingHeader	1	CLUSTERED	Y	Y		540	3088	0	254	2026-09-15 13:46:40	2026-09-12 01:00:10	USED	KEEP — primary key
host-347.flx.InvoiceLine.PK_SettlementMonthly	1	CLUSTERED	Y	Y		79	2555	627	416	2026-09-16 00:00:57	2026-09-16 01:00:08	USED	KEEP — primary key
host-347.flx.InvoiceLine.UQ_LedgerResult	13	NONCLUSTERED	Y			15	0	0	1	2026-09-15 20:09:08	2026-09-16 01:00:08	USED	keep — in use
host-347.flx.ContractSummary.UQ_SalesQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host-347.flx.AssetLog.PK_ContractLine	1	CLUSTERED	Y	Y		11	23663	0	306	2026-09-16 00:00:57	2026-09-16 01:00:08	USED	KEEP — primary key
host-347.flx.CustomerLine.IX_SalesEntry	3	NONCLUSTERED				1129	128	0	140	2026-09-12 15:16:29	2026-09-13 01:00:13	USED	keep — in use
host-347.flx.CustomerLine.PK_ClaimAudit	1	CLUSTERED	Y	Y		34258	7860	208	140	2026-09-15 20:30:16	2026-09-13 01:00:13	USED	KEEP — primary key
host-347.flx.CustomerLine.IX_InvoiceSummary	9	NONCLUSTERED	Y			4	11	0	34	2026-08-16 13:17:08	2026-09-13 01:00:13	USED	keep — in use
host-347.flx.BatchSummary.PK_MeterResult	1	CLUSTERED	Y	Y		0	4	0	15	2026-04-14 14:05:00	never	USED	KEEP — primary key
host-347.flx.OrdersMonthly.IX_RosterMonthly	6	NONCLUSTERED				10	6	0	1432	2026-08-27 15:47:17	2026-09-12 01:00:10	USED	keep — in use
host-347.flx.OrdersMonthly.PK_PolicySnapshot	1	CLUSTERED	Y	Y		4489	13422	0	3974	2026-09-14 13:55:21	2026-09-12 01:00:10	USED	KEEP — primary key
host-347.flx.SalesLog.PK_ContractAudit	1	CLUSTERED	Y	Y		0	16125	0	446	2026-09-14 13:55:21	never	USED	KEEP — primary key
host-347.flx.PolicyDetail.PK_AssetSnapshot	1	CLUSTERED	Y	Y		4	2245	0	97	2026-09-14 13:55:21	never	USED	KEEP — primary key
host-347.flx.RosterStatus.PK_TerritoryHistory	1	CLUSTERED	Y	Y		8450	45	0	616	2026-09-14 13:53:57	2026-09-11 01:00:08	USED	KEEP — primary key
host-347.flx.ShipmentStaging.PK_CatalogSnapshot	1	CLUSTERED	Y	Y		0	1	0	1	2026-07-21 09:30:26	never	USED	KEEP — primary key
host-347.flx.ClaimHeader.IX_WarehouseMonthly	15	NONCLUSTERED				91128	24	0	302	2026-09-15 16:22:06	2026-08-20 01:00:09	USED	keep — in use
host-347.flx.ClaimHeader.PK_BatchAudit	1	CLUSTERED	Y	Y		91189	67018	90905	825	2026-09-15 20:09:00	2026-08-20 01:00:09	USED	KEEP — primary key
host-347.flx.ClaimHeader.UX_SupplierDetail	2	NONCLUSTERED	Y			8625	198	0	822	2026-08-21 14:03:22	2026-08-20 01:00:09	USED	keep — in use
host-347.flx.ShiftArchive.PK_PricingEntry	1	CLUSTERED	Y	Y		0	1107	0	87	2026-09-14 13:56:26	never	USED	KEEP — primary key
host-347.flx.QuotaStatus.PK_SalesResult	1	CLUSTERED	Y	Y		460	1346	0	288	2026-09-14 13:56:26	2026-08-25 01:00:19	USED	KEEP — primary key
host-347.flx.SupplierDetail.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		2	327	0	286	2026-08-24 09:10:05	2026-08-25 01:00:19	USED	KEEP — primary key
host-347.flx.ContractQueue.PK_QuotaEntry	1	CLUSTERED	Y	Y		0	14	0	347	2026-08-21 12:07:16	never	USED	KEEP — primary key
host-347.flx.PricingHistory.IX_ShiftDaily	2	NONCLUSTERED				65043	158	0	1079	2026-09-15 16:21:50	2026-08-20 01:00:09	USED	keep — in use
host-347.flx.PricingHistory.PK_ReconcileHistory	1	CLUSTERED	Y	Y		419	3830	56711	1079	2026-09-15 16:21:50	2026-08-20 01:00:09	USED	KEEP — primary key
host-347.flx.MeterArchive.IX_BatchHeader	7	NONCLUSTERED				15214	9	0	226	2026-09-15 16:21:50	2026-08-20 01:00:09	USED	keep — in use
host-347.flx.MeterArchive.PK_BatchDaily	1	CLUSTERED	Y	Y		952	49278	13034	863	2026-09-15 16:21:50	2026-08-20 01:00:09	USED	KEEP — primary key
host-347.flx.InvoiceLine.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	18	0	625	2026-09-12 21:09:35	never	USED	KEEP — primary key
host-347.flx.BookingLog.PK_CatalogLine	1	CLUSTERED	Y	Y		0	6	0	449	2026-04-14 14:05:00	never	USED	KEEP — primary key
host-347.flx.PayrollSnapshot.PK_LedgerResult	1	CLUSTERED	Y	Y		187471	6844	0	422	2026-09-15 16:21:50	2026-09-11 01:00:08	USED	KEEP — primary key
host-347.flx.SettlementLine.PK_QuotaHistory	1	CLUSTERED	Y	Y		2532	220704	0	782	2026-09-15 16:21:50	2026-09-11 01:00:08	USED	KEEP — primary key
host-347.flx.SettlementLine.PK_SettlementEntry	1	CLUSTERED	Y	Y		3	2964	0	1057	2026-09-15 16:21:50	2026-09-11 01:00:08	USED	KEEP — primary key
host-347.flx.ShiftLine.PK_StaffingStaging	1	CLUSTERED	Y	Y		0	37	0	688	2026-08-19 00:28:12	never	USED	KEEP — primary key
host-347.flx.TicketDaily.PK_ContractEntry	1	CLUSTERED	Y	Y		0	13	0	683	2026-08-19 00:25:25	never	USED	KEEP — primary key
host-347.flx.MeterStaging.PK_CatalogResult	1	CLUSTERED	Y	Y		0	8	0	395	2026-08-18 16:05:12	never	USED	KEEP — primary key
host-347.flx.StaffingLine.PK_PolicyHistory	1	CLUSTERED	Y	Y		46919	98336	0	87653	2026-09-15 16:21:50	2026-09-11 01:00:08	USED	KEEP — primary key
host-347.flx.ForecastQueue.PK_BillingEntry	1	CLUSTERED	Y	Y		88	1186	0	336	2026-09-10 15:57:29	never	USED	KEEP — primary key
host-347.flx.QuotaResult.PK_InvoiceArchive	1	CLUSTERED	Y	Y		0	10	0	32954	2026-08-18 23:10:52	never	USED	KEEP — primary key
host-347.flx.CustomerSummary.PK_PricingLine	1	CLUSTERED	Y	Y		2	16537	0	3210	2026-09-15 13:26:31	2026-09-11 01:00:08	USED	KEEP — primary key
host-347.flx.RouteAudit.PK_ContractStatus	1	CLUSTERED	Y	Y		8271	2797	304	352	2026-09-15 20:30:16	2026-09-16 01:00:08	USED	KEEP — primary key
host-347.flx.RouteAudit.UX_BookingEntry	2	NONCLUSTERED	Y			532	394	0	235	2026-09-15 20:30:16	2026-09-16 01:00:08	USED	keep — in use
host-347.flx.MeterSummary.PK_PolicyResult	1	CLUSTERED	Y	Y		295	5506	0	607	2026-09-15 20:23:16	never	USED	KEEP — primary key
host-347.flx.ContractDetail.PK_CampaignStaging	1	CLUSTERED	Y	Y		0	7	0	5	2026-05-06 08:25:05	never	USED	KEEP — primary key
host-347.flx.WarehouseDaily.PK_QuotaLog	1	CLUSTERED	Y	Y		0	4	0	39	2026-04-14 14:05:00	never	USED	KEEP — primary key
host-347.flx.TicketStaging.PK_ForecastArchive	1	CLUSTERED	Y	Y		74919	34290	2776	354	2026-09-15 20:30:16	2026-08-20 01:00:10	USED	KEEP — primary key
host-347.flx.TicketStaging.UX_ShipmentStaging	2	NONCLUSTERED	Y			2830	1263	0	352	2026-08-19 10:22:48	2026-08-20 01:00:10	USED	keep — in use
host-347.flx.MeterLine.PK_SettlementStaging	1	CLUSTERED	Y	Y		32495	10008	6	494	2026-09-15 20:08:59	2026-09-11 01:00:08	USED	KEEP — primary key
host-347.flx.MeterLine.UX_RouteStatus	2	NONCLUSTERED	Y			353	133	0	491	2026-09-10 15:03:40	2026-09-11 01:00:08	USED	keep — in use
host-347.flx.TerritoryArchive.PK_OrdersLine	1	CLUSTERED	Y	Y		3538	185358	0	588	2026-09-15 16:22:06	2026-09-11 01:00:08	USED	KEEP — primary key
host-347.flx.PolicyDaily.PK_RosterResult	1	CLUSTERED	Y	Y		0	9	0	27	2026-08-25 09:50:49	never	USED	KEEP — primary key
host-347.flx.PolicyMonthly.PK_PayrollStaging	1	CLUSTERED	Y	Y		0	2	0	25	2026-05-15 14:08:22	never	USED	KEEP — primary key
host-347.flx.ForecastEntry.IX_AssetEntry	2	NONCLUSTERED				75	5	0	9	2026-07-09 15:54:02	2026-04-09 01:00:05	USED	keep — in use
host-347.flx.ForecastEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		2743	2106	0	9	2026-09-15 20:21:23	2026-04-09 01:00:05	USED	KEEP — primary key
host-347.flx.ShiftSnapshot.PK_LedgerMonthly	1	CLUSTERED	Y	Y		0	3	0	3	2026-05-30 11:25:24	never	USED	KEEP — primary key
host-347.flx.ShiftSnapshot.UQ_CatalogDetail	2	NONCLUSTERED	Y			67	3	0	3	2026-09-15 16:25:00	2026-05-25 08:36:16	USED	keep — in use
host-347.flx.ReconcileHistory.PK_PolicyAudit	1	CLUSTERED	Y	Y		0	4	0	1	2026-08-15 11:29:22	2026-08-15 11:29:22	USED	KEEP — primary key
host-347.inv.Inventory.PK_InvoiceSummary	1	CLUSTERED	Y	Y		7770	7503	0	1379	2026-09-15 09:17:36	2026-09-12 01:00:10	USED	KEEP — primary key
host-347.inv.SupplierStatus.PK_PolicySnapshot	1	CLUSTERED	Y	Y		1150	22732	572	223	2026-09-15 09:17:36	2026-09-16 01:00:08	USED	KEEP — primary key
host-347.inv.SupplierStatus.UX_SalesHeader	6	NONCLUSTERED	Y			725	95	0	90	2026-09-15 08:40:06	2026-09-16 01:00:08	USED	keep — in use
host-347.inv.ShipmentDetail.PK_WarehouseSummary	1	CLUSTERED	Y	Y		1695	285	0	179	2026-09-15 15:08:49	2026-09-16 01:00:08	USED	KEEP — primary key
host-347.org.BatchDaily.PK_QuotaStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.org.BatchDaily.UX_PricingResult	2	NONCLUSTERED	Y			0	0	0	0	never	2024-10-05 22:14:24	COLD	review carefully — unique
host-347.po.PO.PK_SettlementDaily	1	CLUSTERED	Y	Y		54586	5527	40	402	2026-09-15 20:49:40	2026-09-14 01:00:03	USED	KEEP — primary key
host-347.po.PO.UX_TerritoryMonthly	2	NONCLUSTERED	Y			717	2730	0	149	2026-09-15 09:17:36	2026-09-14 01:00:03	USED	keep — in use
host-347.po.ClaimSummary.PK_BatchSnapshot	1	CLUSTERED	Y	Y		26790	2524	1573	401	2026-09-15 20:49:40	2026-09-14 01:00:03	USED	KEEP — primary key
host-347.po.ClaimSummary.UX_PayrollResult	2	NONCLUSTERED	Y			2049	0	0	150	2026-09-15 09:58:24	2026-09-14 01:00:03	USED	keep — in use
host-347.po.RosterLog.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.po.AssetMonthly.PK_PolicyDetail	1	CLUSTERED	Y	Y		0	15	0	360	2026-06-13 15:47:31	never	USED	KEEP — primary key
host-347.pto.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		0	337	0	1	2026-09-10 08:25:50	never	USED	KEEP — primary key
host-347.pto.ContractHeader.PK_ContractEntry	1	CLUSTERED	Y	Y		612	240	0	5	2026-09-10 08:25:51	2026-06-07 01:00:06	USED	KEEP — primary key
host-347.pto.ContractHeader.UX_SalesResult	3	NONCLUSTERED	Y			2	0	0	1	2026-06-06 09:49:51	2026-06-07 01:00:06	USED	keep — in use
host-347.pto.SalesHistory.PK_TicketDetail	1	CLUSTERED	Y	Y		197	774	49	22	2026-09-10 08:25:51	2026-06-07 01:00:06	USED	KEEP — primary key
host-347.pto.SalesHistory.UX_ContractDetail	4	NONCLUSTERED	Y			99	0	0	6	2026-06-10 15:35:55	2026-06-07 01:00:06	USED	keep — in use
host-347.pto.ClaimResult.IX_ContractDetail	2	NONCLUSTERED				82	1	0	6	2026-06-17 15:59:00	2026-06-07 01:00:06	USED	keep — in use
host-347.pto.ClaimResult.PK_SalesLine	1	CLUSTERED	Y	Y		0	0	41	6	2026-06-17 15:59:00	2026-06-07 01:00:06	USED	KEEP — primary key
host-347.pto.LedgerResult.IX_TerritoryResult	3	NONCLUSTERED				316	0	0	21	2026-09-10 08:25:51	2026-06-11 01:00:05	USED	keep — in use
host-347.pto.LedgerResult.PK_TicketArchive	1	CLUSTERED	Y	Y		0	545	316	21	2026-09-10 08:25:51	2026-06-11 01:00:05	USED	KEEP — primary key
host-347.pto.ContractEntry.IX_CustomerDaily	2	NONCLUSTERED				82	0	0	5	2026-06-17 15:59:00	2026-06-11 01:00:05	USED	keep — in use
host-347.pto.ContractEntry.PK_SettlementDetail	1	CLUSTERED	Y	Y		0	0	41	5	2026-06-17 15:59:00	2026-06-11 01:00:05	USED	KEEP — primary key
host-347.ops.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		0	1	0	0	2026-06-08 09:15:20	2026-01-11 01:00:06	USED	KEEP — primary key
host-347.ops.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-06-09 01:00:06	UNUSED	KEEP — primary key
host-347.ops.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	0	0	1	never	never	UNUSED	KEEP — primary key
host-347.audit.SupplierArchive.PK_PolicyQueue	1	CLUSTERED	Y	Y		45	160	0	0	2026-08-25 14:55:16	2026-01-11 01:00:06	USED	KEEP — primary key
host-347.audit.CatalogQueue.PK_TicketHistory	1	CLUSTERED	Y	Y		0	2	0	0	2025-11-20 13:47:56	never	USED	KEEP — primary key
host-347.audit.CampaignLine.PK_MeterStaging	1	CLUSTERED	Y	Y		0	205	0	0	2026-08-25 14:55:16	2026-01-11 01:00:06	USED	KEEP — primary key
host-347.audit.TicketLog.PK_ReconcileDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	UNUSED	KEEP — primary key
host-347.qc.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		183	284	0	0	2026-09-14 08:30:07	2026-01-11 01:00:06	USED	KEEP — primary key
host-347.qc.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		73	747	0	109	2026-09-15 08:40:06	2026-09-13 01:00:15	USED	KEEP — primary key
host-347.qc.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	0	0	97	never	2026-09-13 01:00:15	UNUSED	KEEP — primary key
host-347.qc.CampaignSummary.PK_PricingStatus	1	CLUSTERED	Y	Y		478	21330	0	248	2026-09-15 20:30:16	2026-09-13 01:00:16	USED	KEEP — primary key
PPA.ppa.OrdersArchive.IX_QuotaMonthly	2	NONCLUSTERED			Y	54720	5	0	1798	2026-08-19 15:51:17	2026-08-20 01:03:40	USED	keep — in use
PPA.ppa.OrdersArchive.PK_BatchLine	1	CLUSTERED	Y	Y		204	61993	54717	2194	2026-08-19 15:51:59	2026-08-20 01:03:40	USED	KEEP — primary key
PPA.ppa.TicketMonthly.PK_RosterDaily	1	CLUSTERED	Y	Y		0	2	0	2124	2025-12-26 11:19:37	never	USED	KEEP — primary key
PPA.ppa.SalesLine.PK_LedgerLog	1	CLUSTERED	Y	Y		36	3493	0	76	2026-08-19 15:50:49	2026-01-25 01:00:22	USED	KEEP — primary key
PPA.ppa.BillingAudit.PK_ShipmentQueue	1	CLUSTERED	Y	Y		0	0	0	76	never	never	UNUSED	KEEP — primary key
PPA.ppa.BookingQueue.PK_ShiftHistory	1	CLUSTERED	Y	Y		19540	1880	0	1061	2026-08-19 15:51:47	2026-08-15 01:01:50	USED	KEEP — primary key
PPA.ppa.ReconcileDetail.PK_QuotaStaging	1	CLUSTERED	Y	Y		0	10	0	1067	2026-01-17 10:10:29	never	USED	KEEP — primary key
PPA.ppa.RosterLog.IX_QuotaSummary	2	NONCLUSTERED				20058	0	0	15539	2026-08-19 15:51:59	2026-08-18 01:03:56	USED	keep — in use
PPA.ppa.RosterLog.PK_CatalogAudit	1	CLUSTERED	Y	Y		18	4346	20058	15985	2026-08-19 15:51:59	2026-08-18 01:03:56	USED	KEEP — primary key
PPA.ppa.Record.IX_CustomerMonthly	10	NONCLUSTERED				13536	1881	0	14989	2026-08-18 14:18:41	2026-08-19 01:06:32	USED	keep — in use
PPA.ppa.Record.IX_CampaignMonthly	5	NONCLUSTERED				6199	2	0	15004	2026-08-19 15:51:48	2026-08-19 01:06:32	USED	keep — in use
PPA.ppa.Record.PK_CatalogLog	1	CLUSTERED	Y	Y		37	47300	21615	15022	2026-08-19 15:51:59	2026-08-19 01:06:31	USED	KEEP — primary key
PPA.ppa.BillingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	8	0	15014	2025-12-22 13:25:40	never	USED	KEEP — primary key
PPA.ppa.TerritoryAudit.PK_ShipmentQueue	1	CLUSTERED	Y	Y		741	37960	0	612	2026-08-19 15:51:47	2026-08-20 01:03:40	USED	KEEP — primary key
PPA.ppa.RosterLine.PK_CatalogMonthly	1	CLUSTERED	Y	Y		0	9	0	604	2025-12-22 15:38:24	never	USED	KEEP — primary key
PPG.dbo.RouteDetail.IX_SalesResult	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.RouteDetail.PK_ReconcileDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.TicketLine.IX_RosterLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.TicketLine.IX_BookingSnapshot	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.TicketLine.PK_SalesResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.AssetQueue.IX_ForecastSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2020-08-13 11:15:23	COLD	review carefully — unique
PPG.dbo.AssetQueue.PK_TerritoryQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2020-08-13 11:15:23	COLD	KEEP — primary key
PPG.dbo.ContractMonthly.IX_PayrollStaging	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.ContractMonthly.PK_RosterEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.ContractArchive.IX_PolicyDetail	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.ContractArchive.PK_TicketResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.ShipmentHeader.IX_CatalogStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.ShipmentHeader.PK_StaffingHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.ClaimStatus.IX_BookingEntry	2	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:01:58	UNUSED	review carefully — unique
PPG.dbo.ClaimStatus.PK_OrdersQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2020-08-18 09:28:17	COLD	KEEP — primary key
PPG.dbo.Bin.IX_CustomerResult	2	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:01:58	UNUSED	review carefully — unique
PPG.dbo.Bin.PK_InvoiceSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:01:58	UNUSED	KEEP — primary key
PPG.dbo.OrdersDetail.IX_PolicyHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:01:58	UNUSED	review carefully — unique
PPG.dbo.OrdersDetail.PK_AssetArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:01:58	UNUSED	KEEP — primary key
PPG.dbo.ForecastLine.PK_LedgerStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	UNUSED	KEEP — primary key
PPG.dbo.MeterSummary.IX_TerritoryArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.MeterSummary.IX_OrdersArchive	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.MeterSummary.IX_MeterHeader	4	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.MeterSummary.PK_BatchLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.BillingArchive.IX_PricingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	2020-08-13 11:15:20	COLD	review carefully — unique
PPG.dbo.BillingArchive.IX_CustomerSummary	3	NONCLUSTERED	Y			0	0	0	0	never	2020-08-13 11:15:20	COLD	review carefully — unique
PPG.dbo.BillingArchive.PK_ForecastStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2020-08-13 11:15:20	COLD	KEEP — primary key
PPG.dbo.ContractSummary.IX_QuotaSummary	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.ContractSummary.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.RouteQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:03	UNUSED	KEEP — primary key
PPG.dbo.RouteHeader.IX_StaffingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	2020-07-06 13:37:39	COLD	review carefully — unique
PPG.dbo.RouteHeader.PK_PricingMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2020-07-06 13:37:39	COLD	KEEP — primary key
PPG.dbo.PayrollLog.IX_BookingAudit	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.PayrollLog.PK_ShiftDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.AssetLog.IX_StaffingArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:02:09	UNUSED	review carefully — unique
PPG.dbo.AssetLog.PK_SalesEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:09	UNUSED	KEEP — primary key
PPG.dbo.AssetSummary.IX_CustomerLine	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.AssetSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.SalesSummary.IX_InvoiceMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:02:09	UNUSED	review carefully — unique
PPG.dbo.SalesSummary.PK_ShiftSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:09	UNUSED	KEEP — primary key
PPG.dbo.ShipmentArchive.PK_QuotaResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.SupplierLog.IX_TerritoryStaging	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.SupplierLog.PK_WarehouseAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.MeterMonthly.IX_RouteHeader	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.MeterMonthly.IX_ForecastEntry	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.MeterMonthly.PK_TerritoryDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.AssetResult.IX_ClaimLog	2	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:02:09	UNUSED	review carefully — unique
PPG.dbo.AssetResult.PK_ClaimLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.CatalogLine.IX_QuotaHistory	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.CatalogLine.PK_QuotaMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.LedgerStaging.IX_CatalogStatus	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.LedgerStaging.IX_StaffingSnapshot	3	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.LedgerStaging.PK_BookingSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.PricingLine.IX_LedgerDetail	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.PricingLine.IX_RosterSummary	3	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.PricingLine.PK_BookingQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.History.IX_PolicyDetail	2	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:02:11	UNUSED	review, then DROP
PPG.dbo.History.IX_ContractQueue	3	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:02:11	UNUSED	review, then DROP
PPG.dbo.History.IX_OrdersLog	4	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:02:11	UNUSED	review, then DROP
PPG.dbo.History.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:10	UNUSED	KEEP — primary key
PPG.dbo.AssetDaily.PK_StaffingHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2022-07-01 14:58:16	COLD	KEEP — primary key
PPG.dbo.SettlementArchive.PK_PayrollDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	2022-07-01 14:58:42	COLD	KEEP — primary key
PPG.dbo.Kit.IX_OrdersArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.Kit.PK_PayrollSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.InvoiceDaily.IX_TerritoryMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.InvoiceDaily.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.SettlementResult.PK_ForecastMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:12	UNUSED	KEEP — primary key
PPG.dbo.RouteResult.IX_BillingDetail	2	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:02:12	UNUSED	review carefully — unique
PPG.dbo.RouteResult.PK_MeterHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:12	UNUSED	KEEP — primary key
PPG.dbo.SettlementDetail.IX_RosterResult	2	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:02:12	UNUSED	review, then DROP
PPG.dbo.SettlementDetail.IX_PayrollResult	3	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:02:12	UNUSED	review, then DROP
PPG.dbo.SettlementDetail.IX_StaffingLog	4	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:02:12	UNUSED	review, then DROP
PPG.dbo.SettlementDetail.PK_TicketLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:12	UNUSED	KEEP — primary key
PPG.dbo.PolicyLine.IX_TerritoryHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2022-07-01 14:59:12	COLD	review carefully — unique
PPG.dbo.PolicyLine.PK_SupplierStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2022-07-01 14:59:12	COLD	KEEP — primary key
PPG.dbo.LedgerStatus.IX_CustomerLog	2	NONCLUSTERED	Y			0	0	0	0	never	2022-07-01 14:59:55	COLD	review carefully — unique
PPG.dbo.LedgerStatus.IX_CampaignQueue	3	NONCLUSTERED				0	0	0	0	never	2022-07-01 14:59:55	COLD	review, then DROP
PPG.dbo.LedgerStatus.PK_LedgerHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2022-07-01 14:59:55	COLD	KEEP — primary key
PPG.dbo.ReconcileHistory.IX_BatchDetail	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.ReconcileHistory.PK_BookingResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.StaffingSnapshot.PK_CustomerLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2022-07-01 14:55:55	COLD	KEEP — primary key
PPG.dbo.ReconcileStaging.IX_ShipmentStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.ReconcileStaging.PK_ContractStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.CampaignStaging.IX_MeterQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.CampaignStaging.PK_QuotaStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.CampaignLog.IX_CampaignEntry	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.CampaignLog.PK_OrdersSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.PolicyLog.IX_OrdersDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2022-07-01 14:53:17	COLD	review carefully — unique
PPG.dbo.PolicyLog.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2022-07-01 14:53:17	COLD	KEEP — primary key
PPG.dbo.SupplierSnapshot.IX_AssetSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.SupplierSnapshot.PK_RosterStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:12	UNUSED	KEEP — primary key
PPG.dbo.WarehouseHistory.IX_PayrollDaily	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.WarehouseHistory.PK_PricingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.PayrollStatus.IX_ContractQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.PayrollStatus.PK_SalesResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.BillingDetail.IX_CampaignLine	2	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:02:12	UNUSED	review carefully — unique
PPG.dbo.BillingDetail.PK_ReconcileHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:12	UNUSED	KEEP — primary key
PPG.dbo.ShiftHeader.PK_ReconcileHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:12	UNUSED	KEEP — primary key
PPG.dbo.AssetQueue.IX_PricingLog	5	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:02:12	UNUSED	review carefully — unique
PPG.dbo.AssetQueue.PK_PricingMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:12	UNUSED	KEEP — primary key
PPG.dbo.WarehouseAudit.IX_WarehouseEntry	3	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:02:12	UNUSED	review carefully — unique
PPG.dbo.WarehouseAudit.PK_ReconcileAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:12	UNUSED	KEEP — primary key
PPG.dbo.SettlementHistory.IX_TerritoryStaging	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.SettlementHistory.PK_ForecastLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.AssetResult.PK_BillingSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.CustomerSummary.IX_BatchAudit	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.CustomerSummary.PK_SupplierMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.QuotaAudit.IX_OrdersAudit	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.QuotaAudit.IX_TerritoryMonthly	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.QuotaAudit.PK_ShiftSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.ClaimSnapshot.IX_TicketHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:02:13	UNUSED	review carefully — unique
PPG.dbo.ClaimSnapshot.PK_ClaimEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:13	UNUSED	KEEP — primary key
PPG.dbo.ReconcileDaily.IX_StaffingHistory	2	NONCLUSTERED	Y			0	0	0	0	never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.ReconcileDaily.PK_RosterResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:13	UNUSED	KEEP — primary key
PPG.dbo.MeterQueue.IX_OrdersMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2020-08-13 11:15:19	COLD	review carefully — unique
PPG.dbo.MeterQueue.PK_ReconcileArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2020-08-13 11:15:19	COLD	KEEP — primary key
PPG.dbo.OrdersDetail.IX_WarehouseResult	2	NONCLUSTERED	Y			0	0	0	0	never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.OrdersDetail.IX_LedgerDaily	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.OrdersDetail.PK_LedgerResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2020-08-27 09:42:38	COLD	KEEP — primary key
PPG.dbo.Task.IX_PayrollDaily	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.Task.PK_ShipmentLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.InvoiceAudit.IX_RouteArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.InvoiceAudit.PK_CustomerLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.TicketDaily.IX_RouteMonthly	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.TicketDaily.PK_TerritoryLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.ContractAudit.IX_ShiftSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.ContractAudit.PK_InvoiceArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:13	UNUSED	KEEP — primary key
PPG.dbo.TerritorySnapshot.IX_QuotaHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.TerritorySnapshot.IX_SupplierEntry	3	NONCLUSTERED				0	0	0	0	never	2020-09-11 11:20:48	COLD	review, then DROP
PPG.dbo.TerritorySnapshot.PK_SalesHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:13	UNUSED	KEEP — primary key
PPG.dbo.SupplierHistory.PK_ContractLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:02:13	UNUSED	KEEP — primary key
PPG.dbo.OrdersResult.IX_BookingLog	2	NONCLUSTERED	Y			0	0	0	0	never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.OrdersResult.PK_AssetLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2020-08-13 14:55:16	COLD	KEEP — primary key
PPG.dbo.CustomerSummary.IX_OrdersDaily	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.CustomerSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.CustomerEntry.IX_SupplierQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.CustomerEntry.PK_InvoiceDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.MeterLog.IX_AssetEntry	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_RosterDaily	3	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_TicketLog	4	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_RosterHistory	5	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
PPG.dbo.MeterLog.PK_QuotaMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
PPG.dbo.WarehouseEntry.IX_BatchHeader	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.WarehouseEntry.PK_CampaignStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		0	92808	0	31250	2026-09-15 21:51:21	never	USED	KEEP — primary key
SALES.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	31250	never	never	UNUSED	KEEP — primary key
SALES.dbo.ContractEntry.PK_SettlementStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ForecastHistory.PK_SupplierSnapshot	1	CLUSTERED	Y	Y		0	49312	0	28893	2026-09-15 21:50:00	2026-09-16 01:00:10	USED	KEEP — primary key
SALES.dbo.SupplierDaily.PK_LedgerAudit	1	CLUSTERED	Y	Y		0	10795768	0	0	2026-09-16 01:01:14	2025-06-19 12:57:43	USED	KEEP — primary key
SALES.dbo.RouteDetail.IX_SalesResult	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.RouteDetail.PK_ReconcileDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.TicketLine.IX_RosterLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.TicketLine.IX_BookingSnapshot	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.TicketLine.PK_SalesResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.AssetQueue.IX_ForecastSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 12:55:51	COLD	review carefully — unique
SALES.dbo.AssetQueue.PK_TerritoryQueue	1	CLUSTERED	Y	Y		0	2237	0	0	2026-09-15 07:06:21	2025-06-19 12:55:51	USED	KEEP — primary key
SALES.dbo.ContractMonthly.IX_PayrollStaging	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.ContractMonthly.PK_RosterEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ContractArchive.IX_PolicyDetail	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.ContractArchive.PK_TicketResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ShipmentHeader.IX_CatalogStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.ShipmentHeader.PK_StaffingHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ClaimStatus.IX_BookingEntry	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.ClaimStatus.PK_OrdersQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.PolicySummary.PK_SupplierDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 12:57:44	COLD	KEEP — primary key
SALES.dbo.Bin.IX_CustomerResult	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 12:57:44	COLD	review carefully — unique
SALES.dbo.Bin.PK_InvoiceSummary	1	CLUSTERED	Y	Y		737222	89962	0	0	2026-09-16 00:57:34	2025-06-19 12:57:44	USED	KEEP — primary key
SALES.dbo.OrdersDetail.IX_PolicyHeader	2	NONCLUSTERED	Y			0	80	0	0	2026-08-27 10:27:32	2025-06-19 12:57:44	USED	keep — in use
SALES.dbo.OrdersDetail.PK_AssetArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ForecastLine.PK_LedgerStaging	1	CLUSTERED	Y	Y		0	2	0	0	2026-06-03 09:25:06	never	USED	KEEP — primary key
SALES.dbo.MeterSummary.IX_TerritoryArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.MeterSummary.IX_OrdersArchive	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.MeterSummary.IX_MeterHeader	4	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.MeterSummary.PK_BatchLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.BillingArchive.IX_PricingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 12:57:44	COLD	review carefully — unique
SALES.dbo.BillingArchive.IX_CustomerSummary	3	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 12:57:44	COLD	review carefully — unique
SALES.dbo.BillingArchive.PK_ForecastStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 12:57:44	COLD	KEEP — primary key
SALES.dbo.ContractSummary.IX_QuotaSummary	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.ContractSummary.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.RouteQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.RouteHeader.IX_StaffingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.RouteHeader.PK_PricingMonthly	1	CLUSTERED	Y	Y		31674	4856	0	0	2026-09-15 19:42:35	2022-05-31 16:13:23	USED	KEEP — primary key
SALES.dbo.PayrollLog.IX_BookingAudit	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.PayrollLog.PK_ShiftDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.AssetLog.IX_StaffingArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 12:57:44	COLD	review carefully — unique
SALES.dbo.AssetLog.PK_SalesEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.AssetSummary.IX_CustomerLine	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.AssetSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.Dashboard.IX_BatchMonthly	1	CLUSTERED	Y			2750730	50359	116336	36694	2026-09-15 21:50:02	2026-09-16 01:00:12	USED	KEEP — table storage
SALES.dbo.Dashboard.IX_ContractDaily	25	NONCLUSTERED				20743	0	0	36694	2026-09-11 19:50:22	2026-09-15 01:00:46	USED	keep — in use
SALES.dbo.Dashboard.IX_BatchMonthly	23	NONCLUSTERED				2	167	0	36694	2026-09-12 12:03:05	2026-09-15 01:00:48	USED	keep — in use
SALES.dbo.Dashboard.IX_ShipmentMonthly	18	NONCLUSTERED				118674	125	0	36694	2026-09-15 20:11:01	2026-09-15 01:00:59	USED	keep — in use
SALES.dbo.Dashboard.IX_SupplierDaily	22	NONCLUSTERED				7	0	0	36694	2026-09-04 08:17:29	2026-09-15 01:01:07	USED	keep — in use
SALES.dbo.Dashboard.IX_BookingArchive	24	NONCLUSTERED				4	0	0	36694	2026-05-20 08:52:42	2026-09-15 01:02:53	USED	keep — in use
SALES.dbo.SalesSummary.IX_InvoiceMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:05:14	COLD	review carefully — unique
SALES.dbo.SalesSummary.PK_ShiftSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ShipmentArchive.PK_QuotaResult	1	CLUSTERED	Y	Y		0	2274	0	0	2026-09-15 07:06:21	never	USED	KEEP — primary key
SALES.dbo.SupplierLog.IX_TerritoryStaging	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.SupplierLog.PK_WarehouseAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.MeterMonthly.IX_RouteHeader	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
SALES.dbo.MeterMonthly.IX_ForecastEntry	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.MeterMonthly.PK_TerritoryDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.AssetResult.IX_ClaimLog	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:05:14	COLD	review carefully — unique
SALES.dbo.AssetResult.PK_ClaimLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.CatalogLine.IX_QuotaHistory	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.CatalogLine.PK_QuotaMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.LedgerStaging.IX_CatalogStatus	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
SALES.dbo.LedgerStaging.IX_StaffingSnapshot	3	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
SALES.dbo.LedgerStaging.PK_BookingSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.PricingLine.IX_LedgerDetail	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
SALES.dbo.PricingLine.IX_RosterSummary	3	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
SALES.dbo.PricingLine.PK_BookingQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.History.IX_PolicyDetail	2	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:00:46	UNUSED	review, then DROP
SALES.dbo.History.IX_ContractQueue	3	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:00:49	UNUSED	review, then DROP
SALES.dbo.History.IX_OrdersLog	4	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:00:50	UNUSED	review, then DROP
SALES.dbo.History.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	30175	0	0	2026-09-15 21:50:02	2026-01-11 01:00:45	USED	KEEP — primary key
SALES.dbo.AssetDaily.PK_StaffingHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:00:51	UNUSED	KEEP — primary key
SALES.dbo.SettlementArchive.PK_PayrollDaily	1	CLUSTERED	Y	Y		10	30153	0	0	2026-09-15 21:50:02	2026-01-11 01:00:51	USED	KEEP — primary key
SALES.dbo.Kit.IX_OrdersArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.Kit.PK_PayrollSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.InvoiceDaily.IX_TerritoryMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.InvoiceDaily.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.SettlementResult.PK_ForecastMonthly	1	CLUSTERED	Y	Y		0	674331	0	0	2026-09-16 00:57:34	2025-06-19 13:05:21	USED	KEEP — primary key
SALES.dbo.RouteResult.IX_BillingDetail	2	NONCLUSTERED	Y			641838	0	0	0	2026-09-16 00:57:34	2025-06-19 13:05:22	USED	keep — in use
SALES.dbo.RouteResult.PK_MeterHeader	1	CLUSTERED	Y	Y		0	0	641838	0	2026-09-16 00:57:34	2025-06-19 13:05:22	USED	KEEP — primary key
SALES.dbo.SettlementDetail.IX_RosterResult	2	NONCLUSTERED				0	312	0	0	2026-09-15 06:10:00	2025-06-19 13:05:21	USED	keep — in use
SALES.dbo.SettlementDetail.IX_PayrollResult	3	NONCLUSTERED				31855	0	0	0	2026-09-15 19:42:35	2025-06-19 13:05:21	USED	keep — in use
SALES.dbo.SettlementDetail.IX_StaffingLog	4	NONCLUSTERED				0	624	0	624	2026-09-15 12:00:00	2025-06-19 13:05:21	USED	keep — in use
SALES.dbo.SettlementDetail.PK_TicketLine	1	CLUSTERED	Y	Y		0	15	0	624	2026-06-04 12:55:24	2025-06-19 13:05:21	USED	KEEP — primary key
SALES.dbo.InvoiceEntry.PK_StaffingHistory	1	CLUSTERED	Y	Y		0	651	140	936	2026-09-15 06:10:00	2025-06-19 13:05:21	USED	KEEP — primary key
SALES.dbo.InvoiceEntry.UX_ForecastSummary	6	NONCLUSTERED	Y			140	312	0	624	2026-09-15 06:10:00	2026-09-15 06:10:00	USED	keep — in use
SALES.dbo.ForecastQueue.PK_ShipmentHistory	1	CLUSTERED	Y	Y		0	0	0	624	never	never	UNUSED	KEEP — primary key
SALES.dbo.PolicyLine.IX_TerritoryHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:05:22	COLD	review carefully — unique
SALES.dbo.PolicyLine.PK_SupplierStatus	1	CLUSTERED	Y	Y		0	10	0	0	2026-06-04 12:55:24	2025-06-19 13:05:22	USED	KEEP — primary key
SALES.dbo.LedgerStatus.IX_CustomerLog	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:05:22	COLD	review carefully — unique
SALES.dbo.LedgerStatus.IX_CampaignQueue	3	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:05:22	COLD	review, then DROP
SALES.dbo.LedgerStatus.PK_LedgerHeader	1	CLUSTERED	Y	Y		0	10	0	0	2026-06-04 12:55:24	2025-06-19 13:05:22	USED	KEEP — primary key
SALES.dbo.ReconcileHistory.IX_BatchDetail	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.ReconcileHistory.PK_BookingResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.StaffingSnapshot.PK_CustomerLog	1	CLUSTERED	Y	Y		1347209	705196	0	673512	2026-09-16 00:57:34	2026-09-15 01:02:59	USED	KEEP — primary key
SALES.dbo.ReconcileStaging.IX_ShipmentStatus	2	NONCLUSTERED	Y			673512	0	0	0	2026-09-16 00:57:34	never	USED	keep — in use
SALES.dbo.ReconcileStaging.PK_ContractStatus	1	CLUSTERED	Y	Y		0	673512	0	0	2026-09-16 00:57:34	never	USED	KEEP — primary key
SALES.dbo.CampaignStaging.IX_MeterQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.CampaignStaging.PK_QuotaStatus	1	CLUSTERED	Y	Y		0	673512	0	0	2026-09-16 00:57:34	never	USED	KEEP — primary key
SALES.dbo.CampaignLog.IX_CampaignEntry	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.CampaignLog.PK_OrdersSummary	1	CLUSTERED	Y	Y		0	89960	0	0	2026-09-16 00:57:34	never	USED	KEEP — primary key
SALES.dbo.PolicyLog.IX_OrdersDaily	2	NONCLUSTERED	Y			673512	0	0	31674	2026-09-16 00:57:34	2026-09-15 01:03:02	USED	keep — in use
SALES.dbo.PolicyLog.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	0	673512	31674	2026-09-16 00:57:34	2026-09-15 01:03:02	USED	KEEP — primary key
SALES.dbo.SupplierSnapshot.IX_AssetSummary	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.SupplierSnapshot.PK_RosterStaging	1	CLUSTERED	Y	Y		2694048	89960	0	0	2026-09-16 00:57:34	2025-06-19 13:05:24	USED	KEEP — primary key
SALES.dbo.WarehouseHistory.IX_PayrollDaily	2	NONCLUSTERED	Y			1347024	0	0	0	2026-09-16 00:57:34	never	USED	keep — in use
SALES.dbo.WarehouseHistory.PK_PricingEntry	1	CLUSTERED	Y	Y		0	89960	0	0	2026-09-16 00:57:34	never	USED	KEEP — primary key
SALES.dbo.PayrollStatus.IX_ContractQueue	2	NONCLUSTERED	Y			673512	0	0	0	2026-09-16 00:57:34	never	USED	keep — in use
SALES.dbo.PayrollStatus.PK_SalesResult	1	CLUSTERED	Y	Y		0	763472	0	0	2026-09-16 00:57:34	never	USED	KEEP — primary key
SALES.dbo.BillingDetail.IX_CampaignLine	2	NONCLUSTERED	Y			673512	10	0	31855	2026-09-16 00:57:34	2026-09-15 01:03:07	USED	keep — in use
SALES.dbo.BillingDetail.PK_ReconcileHeader	1	CLUSTERED	Y	Y		0	0	673512	31855	2026-09-16 00:57:34	2026-09-15 01:03:06	USED	KEEP — primary key
SALES.dbo.QuotaHeader.PK_ContractLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.WarehouseSnapshot.PK_BookingLog	1	CLUSTERED	Y	Y		0	60004	0	30002	2026-09-15 21:50:02	2026-09-15 01:03:07	USED	KEEP — primary key
SALES.dbo.ShiftHeader.PK_ReconcileHeader	1	CLUSTERED	Y	Y		6120291	0	0	0	2026-09-16 01:00:50	2025-06-19 13:05:25	USED	KEEP — primary key
SALES.dbo.AssetQueue.IX_PricingLog	2	NONCLUSTERED	Y			16345	0	0	0	2026-09-15 10:41:17	2025-06-19 13:05:25	USED	keep — in use
SALES.dbo.AssetQueue.PK_PricingMonthly	1	CLUSTERED	Y	Y		2524	3040309	16345	0	2026-09-16 01:00:50	2025-06-19 13:05:25	USED	KEEP — primary key
SALES.dbo.WarehouseAudit.IX_WarehouseEntry	2	NONCLUSTERED	Y			2275	0	0	249	2026-09-15 07:06:21	2026-09-15 01:03:07	USED	keep — in use
SALES.dbo.WarehouseAudit.PK_ReconcileAudit	1	CLUSTERED	Y	Y		249	3056654	2275	249	2026-09-16 01:00:50	2025-06-19 13:05:25	USED	KEEP — primary key
SALES.dbo.SettlementHistory.IX_TerritoryStaging	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.SettlementHistory.PK_ForecastLog	1	CLUSTERED	Y	Y		80	0	0	0	2026-08-27 10:27:32	never	USED	KEEP — primary key
SALES.dbo.AssetResult.PK_BillingSummary	1	CLUSTERED	Y	Y		2285	4554	0	4562	2026-09-15 17:45:11	never	USED	KEEP — primary key
SALES.dbo.CustomerSummary.IX_BatchAudit	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
SALES.dbo.CustomerSummary.PK_SupplierMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.QuotaAudit.IX_OrdersAudit	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
SALES.dbo.QuotaAudit.IX_TerritoryMonthly	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.QuotaAudit.PK_ShiftSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ClaimSnapshot.IX_TicketHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2023-11-01 08:22:19	COLD	review carefully — unique
SALES.dbo.ClaimSnapshot.PK_ClaimEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2023-11-01 08:22:19	COLD	KEEP — primary key
SALES.dbo.ReconcileDaily.IX_StaffingHistory	2	NONCLUSTERED	Y			198	7015	0	0	2026-09-15 10:41:17	2025-06-19 13:05:30	USED	keep — in use
SALES.dbo.ReconcileDaily.PK_RosterResult	1	CLUSTERED	Y	Y		80	0	7213	0	2026-09-15 10:41:17	2025-06-19 13:05:30	USED	KEEP — primary key
SALES.dbo.MeterQueue.IX_OrdersMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:05:30	COLD	review carefully — unique
SALES.dbo.MeterQueue.PK_ReconcileArchive	1	CLUSTERED	Y	Y		2237	0	0	0	2026-09-15 07:06:21	2025-06-19 13:05:30	USED	KEEP — primary key
SALES.dbo.OrdersDetail.IX_WarehouseResult	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.OrdersDetail.IX_LedgerDaily	3	NONCLUSTERED	Y			0	89960	0	0	2026-09-16 00:57:34	never	USED	keep — in use
SALES.dbo.OrdersDetail.PK_LedgerResult	1	CLUSTERED	Y	Y		933245	413779	0	0	2026-09-16 00:57:34	never	USED	KEEP — primary key
SALES.dbo.Task.IX_PayrollDaily	2	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:05:30	COLD	review, then DROP
SALES.dbo.Task.PK_ShipmentLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:05:30	COLD	KEEP — primary key
SALES.dbo.InvoiceAudit.IX_RouteArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.InvoiceAudit.PK_CustomerLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.TicketDaily.IX_RouteMonthly	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
SALES.dbo.TicketDaily.PK_TerritoryLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.ContractAudit.IX_ShiftSummary	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.ContractAudit.PK_InvoiceArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:05:30	COLD	KEEP — primary key
SALES.dbo.TerritorySnapshot.IX_QuotaHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2023-11-24 07:37:19	COLD	review carefully — unique
SALES.dbo.TerritorySnapshot.IX_SupplierEntry	3	NONCLUSTERED				0	40	0	0	2026-08-27 10:27:33	2023-11-24 07:37:19	USED	keep — in use
SALES.dbo.TerritorySnapshot.PK_SalesHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:05:30	COLD	KEEP — primary key
SALES.dbo.SupplierHistory.PK_ContractLine	1	CLUSTERED	Y	Y		2489	2489	0	2489	2026-09-15 10:41:16	never	USED	KEEP — primary key
SALES.dbo.OrdersResult.IX_BookingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.OrdersResult.PK_AssetLine	1	CLUSTERED	Y	Y		2428	0	0	0	2026-09-15 10:41:17	2025-06-19 13:05:31	USED	KEEP — primary key
SALES.dbo.CustomerSummary.IX_OrdersDaily	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.CustomerSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:05:31	COLD	KEEP — primary key
SALES.dbo.CustomerEntry.IX_SupplierQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.CustomerEntry.PK_InvoiceDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.MeterLog.IX_AssetEntry	2	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:05:31	COLD	review, then DROP
SALES.dbo.MeterLog.IX_RosterDaily	3	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:05:31	COLD	review, then DROP
SALES.dbo.MeterLog.IX_TicketLog	4	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:05:31	COLD	review, then DROP
SALES.dbo.MeterLog.IX_RosterHistory	5	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:05:31	COLD	review, then DROP
SALES.dbo.MeterLog.PK_QuotaMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:05:31	COLD	KEEP — primary key
SALES.dbo.WarehouseEntry.IX_BatchHeader	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.WarehouseEntry.PK_CampaignStatus	1	CLUSTERED	Y	Y		1347024	89960	0	0	2026-09-16 00:57:34	never	USED	KEEP — primary key
SALES.dbo.QuotaResult.PK_ReconcileDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.QuotaResult.IX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.kar.Bin.PK_InvoiceSummary	1	CLUSTERED	Y	Y		4901719	3143028	2	278869	2026-09-15 20:22:23	2025-02-25 14:34:51	USED	KEEP — primary key
SALES.kar.Bin.UX_PayrollAudit	2	NONCLUSTERED	Y			2	0	0	0	2026-08-26 11:33:38	2025-06-19 13:05:31	USED	keep — in use
SALES.kar.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		0	3	0	0	2026-05-20 08:50:18	never	USED	KEEP — primary key
SALES.kar.ContractStaging.PK_CustomerSummary	1	CLUSTERED	Y	Y		2173849	419	0	278896	2026-09-15 20:13:13	2026-09-15 16:25:19	USED	KEEP — primary key
SALES.kar.RosterSummary.IX_PricingDetail	2	NONCLUSTERED				0	0	0	278882	never	2026-09-15 01:03:17	UNUSED	review, then DROP
SALES.kar.RosterSummary.IX_InvoiceDaily	9	NONCLUSTERED			Y	0	0	0	13	never	never	UNUSED	review, then DROP
SALES.kar.RosterSummary.PK_AssetAudit	1	CLUSTERED	Y	Y		0	16	0	278896	2026-08-28 16:11:07	2026-09-15 01:03:12	USED	KEEP — primary key
SALES.kar.SupplierArchive.IX_SettlementLine	9	NONCLUSTERED				1683777	25	0	278895	2026-09-15 20:22:18	2026-09-15 16:46:30	USED	keep — in use
SALES.kar.SupplierArchive.PK_QuotaSnapshot	1	CLUSTERED	Y	Y		317883	4720592	1683802	278896	2026-09-15 20:22:23	2026-09-15 16:46:30	USED	KEEP — primary key
SALES.kar.ClaimResult.IX_ContractHistory	9	NONCLUSTERED				311428	0	0	278895	2026-09-15 20:13:13	2026-09-15 16:25:18	USED	keep — in use
SALES.kar.ClaimResult.IX_QuotaSnapshot	8	NONCLUSTERED				498422	7793	0	278895	2026-09-15 20:14:31	2026-09-15 16:25:18	USED	keep — in use
SALES.kar.ClaimResult.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	969652	579433	278896	2026-09-15 20:13:13	2026-09-15 16:25:18	USED	KEEP — primary key
SALES.kar.RosterDaily.IX_ClaimSummary	12	NONCLUSTERED				47360	8949	0	278896	2026-09-15 18:14:19	2026-09-15 01:03:34	USED	keep — in use
SALES.kar.RosterDaily.IX_RouteDetail	16	NONCLUSTERED			Y	2652	6073	0	278895	2026-09-15 16:27:08	2026-09-15 01:03:34	USED	keep — in use
SALES.kar.RosterDaily.IX_CampaignStatus	19	NONCLUSTERED			Y	151	0	0	13	2026-09-11 08:11:51	2026-09-15 13:26:14	USED	keep — in use
SALES.kar.RosterDaily.PK_BillingAudit	1	CLUSTERED	Y	Y		0	45	8883	278896	2026-09-15 16:27:08	2026-09-15 01:03:27	USED	KEEP — primary key
SALES.kar.LedgerHeader.PK_TerritoryResult	1	CLUSTERED	Y	Y		6128	1876	0	656	2026-09-14 15:13:28	2026-09-15 01:03:35	USED	KEEP — primary key
SALES.kar.LedgerLog.IX_PricingAudit	9	NONCLUSTERED				0	0	0	0	never	2025-03-07 15:46:11	COLD	review, then DROP
SALES.kar.SalesLine.PK_LedgerLog	1	CLUSTERED	Y	Y		3114129	496008	0	2139762	2026-09-15 20:22:18	2025-03-13 13:09:59	USED	KEEP — primary key
SALES.kar.SalesLine.UX_OrdersStatus	4	NONCLUSTERED	Y			1361689	2964577	0	0	2026-09-15 20:22:23	2025-04-11 12:42:09	USED	keep — in use
SALES.kar.ClaimDetail.PK_TicketStatus	1	CLUSTERED	Y	Y		449	500	0	306	2026-09-15 12:15:10	2026-09-15 01:03:35	USED	KEEP — primary key
SALES.kar.PayrollResult.PK_WarehouseDetail	1	CLUSTERED	Y	Y		2699	108	0	93	2026-09-15 15:50:23	2025-10-03 01:00:48	USED	KEEP — primary key
SALES.kar.AssetHeader.PK_BillingSummary	1	CLUSTERED	Y	Y		1858	1039677	0	2901	2026-09-15 20:22:18	never	USED	KEEP — primary key
SALES.kar.SettlementLog.PK_MeterDaily	1	CLUSTERED	Y	Y		2098639	0	0	858346	2026-09-15 20:22:23	2026-09-15 16:18:35	USED	KEEP — primary key
BATCH_Test.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ContractEntry.PK_SettlementStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ForecastHistory.PK_SupplierSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:07	COLD	KEEP — primary key
BATCH_Test.dbo.SupplierDaily.PK_LedgerAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:12	COLD	KEEP — primary key
BATCH_Test.dbo.RouteDetail.IX_SalesResult	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.RouteDetail.PK_ReconcileDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.TicketLine.IX_RosterLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.TicketLine.IX_BookingSnapshot	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.TicketLine.PK_SalesResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.AssetQueue.IX_ForecastSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:12:29	COLD	review carefully — unique
BATCH_Test.dbo.AssetQueue.PK_TerritoryQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:12:29	COLD	KEEP — primary key
BATCH_Test.dbo.ContractMonthly.IX_PayrollStaging	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.ContractMonthly.PK_RosterEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ContractArchive.IX_PolicyDetail	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.ContractArchive.PK_TicketResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ShipmentHeader.IX_CatalogStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.ShipmentHeader.PK_StaffingHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ClaimStatus.IX_BookingEntry	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.ClaimStatus.PK_OrdersQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.PolicySummary.PK_SupplierDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:14	COLD	KEEP — primary key
BATCH_Test.dbo.Bin.IX_CustomerResult	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.Bin.PK_InvoiceSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:14	COLD	KEEP — primary key
BATCH_Test.dbo.OrdersDetail.IX_PolicyHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.OrdersDetail.PK_AssetArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ForecastLine.PK_LedgerStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.MeterSummary.IX_TerritoryArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.MeterSummary.IX_OrdersArchive	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.MeterSummary.IX_MeterHeader	4	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.MeterSummary.PK_BatchLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.BillingArchive.IX_PricingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.BillingArchive.IX_CustomerSummary	3	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.BillingArchive.PK_ForecastStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:14	COLD	KEEP — primary key
BATCH_Test.dbo.ContractSummary.IX_QuotaSummary	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.ContractSummary.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.RouteQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.RouteHeader.IX_StaffingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.RouteHeader.PK_PricingMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2022-05-31 16:13:23	COLD	KEEP — primary key
BATCH_Test.dbo.PayrollLog.IX_BookingAudit	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.PayrollLog.PK_ShiftDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.AssetLog.IX_StaffingArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.AssetLog.PK_SalesEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.AssetSummary.IX_CustomerLine	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.AssetSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.Dashboard.IX_BatchMonthly	1	CLUSTERED	Y			2572	13	251	6	2026-07-24 14:02:59	2026-06-04 01:04:27	USED	KEEP — table storage
BATCH_Test.dbo.Dashboard.IX_ContractDaily	11	NONCLUSTERED				181	0	0	6	2026-07-24 14:02:59	2026-06-04 01:05:04	USED	keep — in use
BATCH_Test.dbo.Dashboard.IX_BatchMonthly	12	NONCLUSTERED				0	2	0	6	2026-06-03 12:43:30	2026-06-04 01:05:04	USED	keep — in use
BATCH_Test.dbo.Dashboard.IX_ShipmentMonthly	13	NONCLUSTERED				115	0	0	6	2026-07-07 15:37:30	2026-06-04 01:05:04	USED	keep — in use
BATCH_Test.dbo.Dashboard.IX_SupplierDaily	14	NONCLUSTERED				0	0	0	6	never	2026-06-04 01:05:05	UNUSED	review, then DROP
BATCH_Test.dbo.Dashboard.IX_BookingArchive	15	NONCLUSTERED				6	0	0	6	2026-05-19 16:17:51	2026-06-04 01:05:06	USED	keep — in use
BATCH_Test.dbo.SalesSummary.IX_InvoiceMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:23	COLD	review carefully — unique
BATCH_Test.dbo.SalesSummary.PK_ShiftSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ShipmentArchive.PK_QuotaResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.SupplierLog.IX_TerritoryStaging	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.SupplierLog.PK_WarehouseAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.MeterMonthly.IX_RouteHeader	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
BATCH_Test.dbo.MeterMonthly.IX_ForecastEntry	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.MeterMonthly.PK_TerritoryDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.AssetResult.IX_ClaimLog	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:23	COLD	review carefully — unique
BATCH_Test.dbo.AssetResult.PK_ClaimLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.CatalogLine.IX_QuotaHistory	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.CatalogLine.PK_QuotaMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.LedgerStaging.IX_CatalogStatus	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStaging.IX_StaffingSnapshot	3	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStaging.PK_BookingSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.PricingLine.IX_LedgerDetail	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
BATCH_Test.dbo.PricingLine.IX_RosterSummary	3	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
BATCH_Test.dbo.PricingLine.PK_BookingQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.History.IX_PolicyDetail	2	NONCLUSTERED				0	0	0	0	never	2025-04-11 10:33:55	COLD	review, then DROP
BATCH_Test.dbo.History.IX_ContractQueue	3	NONCLUSTERED				0	0	0	0	never	2025-04-11 10:34:08	COLD	review, then DROP
BATCH_Test.dbo.History.IX_OrdersLog	4	NONCLUSTERED				0	0	0	0	never	2025-04-11 10:34:14	COLD	review, then DROP
BATCH_Test.dbo.History.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:01:48	UNUSED	KEEP — primary key
BATCH_Test.dbo.AssetDaily.PK_StaffingHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:01:50	UNUSED	KEEP — primary key
BATCH_Test.dbo.SettlementArchive.PK_PayrollDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:01:53	UNUSED	KEEP — primary key
BATCH_Test.dbo.Kit.IX_OrdersArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.Kit.PK_PayrollSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.InvoiceDaily.IX_TerritoryMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.InvoiceDaily.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.SettlementResult.PK_ForecastMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.RouteResult.IX_BillingDetail	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:30	COLD	review carefully — unique
BATCH_Test.dbo.RouteResult.PK_MeterHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.SettlementDetail.IX_RosterResult	2	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.IX_PayrollResult	3	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.IX_StaffingLog	4	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.PK_TicketLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.InvoiceEntry.PK_StaffingHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.InvoiceEntry.UX_ForecastSummary	6	NONCLUSTERED	Y			0	0	0	0	never	2025-04-05 06:10:01	COLD	review carefully — unique
BATCH_Test.dbo.ForecastQueue.PK_ShipmentHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.PolicyLine.IX_TerritoryHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:30	COLD	review carefully — unique
BATCH_Test.dbo.PolicyLine.PK_SupplierStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.LedgerStatus.IX_CustomerLog	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:30	COLD	review carefully — unique
BATCH_Test.dbo.LedgerStatus.IX_CampaignQueue	3	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.LedgerStatus.PK_LedgerHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.ReconcileHistory.IX_BatchDetail	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.ReconcileHistory.PK_BookingResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.StaffingSnapshot.PK_CustomerLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2026-01-11 01:01:54	UNUSED	KEEP — primary key
BATCH_Test.dbo.ReconcileStaging.IX_ShipmentStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.ReconcileStaging.PK_ContractStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.CampaignStaging.IX_MeterQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.CampaignStaging.PK_QuotaStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.CampaignLog.IX_CampaignEntry	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.CampaignLog.PK_OrdersSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.PolicyLog.IX_OrdersDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:31	COLD	review carefully — unique
BATCH_Test.dbo.PolicyLog.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:31	COLD	KEEP — primary key
BATCH_Test.dbo.SupplierSnapshot.IX_AssetSummary	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.SupplierSnapshot.PK_RosterStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.WarehouseHistory.IX_PayrollDaily	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.WarehouseHistory.PK_PricingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.PayrollStatus.IX_ContractQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.PayrollStatus.PK_SalesResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.BillingDetail.IX_CampaignLine	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:32	COLD	review carefully — unique
BATCH_Test.dbo.BillingDetail.PK_ReconcileHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.QuotaHeader.PK_ContractLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.WarehouseSnapshot.PK_BookingLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.ShiftHeader.PK_ReconcileHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.AssetQueue.IX_PricingLog	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:32	COLD	review carefully — unique
BATCH_Test.dbo.AssetQueue.PK_PricingMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.WarehouseAudit.IX_WarehouseEntry	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:32	COLD	review carefully — unique
BATCH_Test.dbo.WarehouseAudit.PK_ReconcileAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.SettlementHistory.IX_TerritoryStaging	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.SettlementHistory.PK_ForecastLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.AssetResult.PK_BillingSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.CustomerSummary.IX_BatchAudit	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
BATCH_Test.dbo.CustomerSummary.PK_SupplierMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.QuotaAudit.IX_OrdersAudit	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
BATCH_Test.dbo.QuotaAudit.IX_TerritoryMonthly	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.QuotaAudit.PK_ShiftSnapshot	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ClaimSnapshot.IX_TicketHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2023-11-01 08:22:19	COLD	review carefully — unique
BATCH_Test.dbo.ClaimSnapshot.PK_ClaimEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2023-11-01 08:22:19	COLD	KEEP — primary key
BATCH_Test.dbo.ReconcileDaily.IX_StaffingHistory	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:38	COLD	review carefully — unique
BATCH_Test.dbo.ReconcileDaily.PK_RosterResult	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.MeterQueue.IX_OrdersMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:38	COLD	review carefully — unique
BATCH_Test.dbo.MeterQueue.PK_ReconcileArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.OrdersDetail.IX_WarehouseResult	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.OrdersDetail.IX_LedgerDaily	3	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.OrdersDetail.PK_LedgerResult	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.Task.IX_PayrollDaily	2	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:38	COLD	review, then DROP
BATCH_Test.dbo.Task.PK_ShipmentLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.InvoiceAudit.IX_RouteArchive	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.InvoiceAudit.PK_CustomerLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.TicketDaily.IX_RouteMonthly	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
BATCH_Test.dbo.TicketDaily.PK_TerritoryLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ContractAudit.IX_ShiftSummary	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.ContractAudit.PK_InvoiceArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.TerritorySnapshot.IX_QuotaHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2023-11-24 07:37:19	COLD	review carefully — unique
BATCH_Test.dbo.TerritorySnapshot.IX_SupplierEntry	3	NONCLUSTERED				0	0	0	0	never	2023-11-24 07:37:19	COLD	review, then DROP
BATCH_Test.dbo.TerritorySnapshot.PK_SalesHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.SupplierHistory.PK_ContractLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.OrdersResult.IX_BookingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.OrdersResult.PK_AssetLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.CustomerSummary.IX_OrdersDaily	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.CustomerSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.CustomerEntry.IX_SupplierQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.CustomerEntry.PK_InvoiceDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.MeterLog.IX_AssetEntry	2	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:38	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_RosterDaily	3	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:38	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_TicketLog	4	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:38	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_RosterHistory	5	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:38	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.PK_QuotaMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.WarehouseEntry.IX_BatchHeader	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.WarehouseEntry.PK_CampaignStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.QuotaResult.PK_ReconcileDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
BATCH_Test.dbo.QuotaResult.IX_BillingLog	2	NONCLUSTERED	Y			0	1	0	0	2026-06-03 09:36:29	never	USED	keep — in use
BATCH_Test.kar.Bin.PK_InvoiceSummary	1	CLUSTERED	Y	Y		5171	7143	5	292	2026-08-06 08:05:37	2025-02-25 14:34:51	USED	KEEP — primary key
BATCH_Test.kar.Bin.UX_PayrollAudit	2	NONCLUSTERED	Y			0	5	0	0	2026-04-20 11:05:57	2025-06-19 13:13:38	USED	keep — in use
BATCH_Test.kar.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		0	7	0	1	2026-06-18 15:23:09	never	USED	KEEP — primary key
BATCH_Test.kar.BookingAudit.PK_RouteHistory	1	CLUSTERED	Y	Y		91	276	0	6	2026-07-24 14:03:54	2026-06-20 09:04:42	USED	KEEP — primary key
BATCH_Test.kar.ContractStaging.PK_CustomerSummary	1	CLUSTERED	Y	Y		2626	78	0	339	2026-07-24 14:04:35	2026-07-25 01:02:56	USED	KEEP — primary key
BATCH_Test.kar.RosterSummary.IX_PricingDetail	6	NONCLUSTERED				0	1	0	304	2026-06-03 10:30:05	2026-07-25 01:02:56	USED	keep — in use
BATCH_Test.kar.RosterSummary.IX_InvoiceDaily	11	NONCLUSTERED			Y	0	0	0	5	never	2026-07-25 01:02:56	UNUSED	review, then DROP
BATCH_Test.kar.RosterSummary.PK_AssetAudit	1	CLUSTERED	Y	Y		0	45	0	313	2026-07-01 10:30:48	2026-07-25 01:02:56	USED	KEEP — primary key
BATCH_Test.kar.SupplierArchive.IX_SettlementLine	12	NONCLUSTERED				3826	173	0	340	2026-07-24 14:16:42	2026-07-25 01:02:56	USED	keep — in use
BATCH_Test.kar.SupplierArchive.PK_QuotaSnapshot	1	CLUSTERED	Y	Y		1426	5764	3843	341	2026-07-24 14:16:42	2026-07-25 01:02:56	USED	KEEP — primary key
BATCH_Test.kar.ClaimResult.IX_ContractHistory	11	NONCLUSTERED				969	0	0	342	2026-07-24 14:04:35	2026-07-25 01:02:56	USED	keep — in use
BATCH_Test.kar.ClaimResult.IX_QuotaSnapshot	9	NONCLUSTERED				768	76	0	342	2026-07-24 14:02:59	2026-07-25 01:02:56	USED	keep — in use
BATCH_Test.kar.ClaimResult.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		4	2086	1711	346	2026-07-24 14:04:35	2026-07-25 01:02:56	USED	KEEP — primary key
BATCH_Test.kar.RosterDaily.IX_ClaimSummary	15	NONCLUSTERED				335	153	0	337	2026-07-23 14:08:30	2026-07-25 01:02:56	USED	keep — in use
BATCH_Test.kar.RosterDaily.IX_RouteDetail	14	NONCLUSTERED			Y	5	43	0	335	2026-07-23 13:37:29	2026-07-25 01:02:56	USED	keep — in use
BATCH_Test.kar.RosterDaily.IX_CampaignStatus	22	NONCLUSTERED			Y	176	0	0	5	2026-06-30 16:00:30	2026-07-25 01:02:56	USED	keep — in use
BATCH_Test.kar.RosterDaily.PK_BillingAudit	1	CLUSTERED	Y	Y		0	187	371	338	2026-07-23 14:08:30	2026-07-25 01:02:56	USED	KEEP — primary key
BATCH_Test.kar.LedgerHeader.PK_TerritoryResult	1	CLUSTERED	Y	Y		431	199	0	56	2026-07-09 12:56:32	2026-07-10 01:00:40	USED	KEEP — primary key
BATCH_Test.kar.LedgerLog.IX_PricingAudit	9	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:01:55	UNUSED	review, then DROP
BATCH_Test.kar.SalesLine.PK_LedgerLog	1	CLUSTERED	Y	Y		3391	2480	0	3006	2026-08-06 08:05:37	2025-03-13 13:09:59	USED	KEEP — primary key
BATCH_Test.kar.SalesLine.UX_OrdersStatus	4	NONCLUSTERED	Y			1	1105	0	0	2026-07-24 14:04:35	2025-04-16 09:16:28	USED	keep — in use
BATCH_Test.kar.ClaimDetail.PK_TicketStatus	1	CLUSTERED	Y	Y		500	88	0	0	2026-07-23 12:43:44	2025-07-15 01:01:41	USED	KEEP — primary key
BATCH_Test.kar.PayrollResult.PK_WarehouseDetail	1	CLUSTERED	Y	Y		143	395	0	20	2026-07-09 11:11:29	2026-07-03 01:00:33	USED	KEEP — primary key
BATCH_Test.kar.AssetHeader.PK_BillingSummary	1	CLUSTERED	Y	Y		0	4404	0	0	2026-08-06 08:05:37	never	USED	KEEP — primary key
BATCH_Test.kar.SettlementLog.PK_MeterDaily	1	CLUSTERED	Y	Y		1175	0	0	357	2026-07-24 14:03:03	2026-07-25 01:02:57	USED	KEEP — primary key
PAYROLL.dbo.ContractDaily.IX_SalesEntry	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
CLAIM_Prod.bm.BOM.PK_MeterHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.bm.CatalogQueue.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.bm.ShiftEntry.PK_RouteStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.bm.BillingArchive.PK_AssetMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.bm.ForecastDetail.PK_CatalogLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.dbo.StaffingEntry.PK_AssetStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.dbo.QuotaLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-03-20 00:42:51	COLD	KEEP — primary key
CLAIM_Prod.dbo.QuotaLine.UX_ForecastSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2024-03-19 23:35:10	COLD	review carefully — unique
CLAIM_Prod.dbo.QuotaResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.dbo.QuotaResult.IX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
CLAIM_Prod.lib.Color.PK_ReconcileStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.lib.SalesLine.PK_StaffingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-10-17 10:54:55	COLD	KEEP — primary key
CLAIM_Prod.lib.SalesLine.UX_QuotaArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2024-10-17 10:54:55	COLD	review carefully — unique
CLAIM_Prod.lib.CustomerLog.PK_ClaimMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:48:57	COLD	KEEP — primary key
CLAIM_Prod.lib.BillingArchive.PK_StaffingDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-05-03 14:41:51	COLD	KEEP — primary key
CLAIM_Prod.lib.BillingArchive.UX_CustomerEntry	9	NONCLUSTERED	Y			0	0	0	0	never	2024-05-02 14:04:36	COLD	review carefully — unique
CLAIM_Prod.lib.CustomerArchive.PK_ForecastSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-12-04 09:26:29	COLD	KEEP — primary key
CLAIM_Prod.lib.SettlementHeader.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-04-19 11:10:12	COLD	KEEP — primary key
CLAIM_Prod.lib.SettlementHeader.UX_ForecastDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2024-03-20 09:31:23	COLD	review carefully — unique
CLAIM_Prod.lib.SupplierSummary.PK_BookingHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.lib.LedgerSnapshot.PK_ClaimDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.lib.RouteDetail.PK_SalesStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-05-02 14:04:52	COLD	KEEP — primary key
CLAIM_Prod.lib.ReconcileEntry.PK_BatchLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-10-17 11:25:37	COLD	KEEP — primary key
CLAIM_Prod.lib.RouteStatus.PK_ShiftAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.lib.InvoiceLine.PK_AssetArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-09 23:44:04	COLD	KEEP — primary key
CLAIM_Prod.lib.Size.PK_ClaimArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-08-06 09:47:03	COLD	KEEP — primary key
CLAIM_Prod.lib.StaffingQueue.PK_CampaignAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-08-06 09:34:07	COLD	KEEP — primary key
CLAIM_Prod.lib.MeterAudit.PK_TerritoryDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-08-06 09:34:07	COLD	KEEP — primary key
CLAIM_Prod.lib.RosterResult.PK_ShipmentEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:48:50	COLD	KEEP — primary key
CLAIM_Prod.lib.BookingResult.PK_ForecastLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-04-19 11:10:12	COLD	KEEP — primary key
CLAIM_Prod.lib.MeterAudit.PK_ReconcileDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-22 15:14:21	COLD	KEEP — primary key
CLAIM_Prod.lib.ContractLog.PK_TerritoryLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:56:33	COLD	KEEP — primary key
CLAIM_Prod.lib.CustomerLine.PK_QuotaArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:56:33	COLD	KEEP — primary key
CLAIM_Prod.sm.QuotaHistory.PK_BatchLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-30 14:06:31	COLD	KEEP — primary key
CLAIM_Prod.sm.InvoiceStaging.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:48:57	COLD	KEEP — primary key
CLAIM_Prod.sm.PricingStatus.PK_LedgerHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:48:57	COLD	KEEP — primary key
CLAIM_Prod.sm.TerritoryArchive.PK_TerritoryLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-04-17 13:41:28	COLD	KEEP — primary key
CLAIM_Prod.sm.TerritoryArchive.UX_PayrollResult	4	NONCLUSTERED	Y			0	0	0	0	never	2024-04-17 13:41:50	COLD	review carefully — unique
CLAIM_Prod.sm.BookingResult.PK_RosterStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-08-28 12:42:56	COLD	KEEP — primary key
CLAIM_Prod.sm.TerritoryMonthly.PK_BookingAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:48:57	COLD	KEEP — primary key
CLAIM_Prod.sm.TerritoryMonthly.UX_StaffingResult	2	NONCLUSTERED	Y			0	0	0	0	never	2024-09-04 07:48:57	COLD	review carefully — unique
CLAIM_Prod.sm.QuotaDaily.PK_BookingDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.QuotaDaily.UX_QuotaQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2024-09-17 13:31:33	COLD	review carefully — unique
CLAIM_Prod.sm.CatalogResult.PK_SalesStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-22 10:51:51	COLD	KEEP — primary key
CLAIM_Prod.sm.BatchAudit.PK_ReconcileHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.ShiftDaily.PK_ClaimHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-17 13:31:33	COLD	KEEP — primary key
CLAIM_Prod.sm.OrdersMonthly.PK_PolicyHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.InvoiceLine.PK_PayrollDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.BillingEntry.PK_SettlementArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.ShipmentDaily.PK_CatalogDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.ShipmentDaily.UX_TicketMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2024-09-17 13:31:33	COLD	review carefully — unique
CLAIM_Prod.sm.PolicyHeader.PK_CustomerSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.PolicyHeader.UX_LedgerDetail	2	NONCLUSTERED	Y			0	0	0	0	never	2024-09-17 13:31:33	COLD	review carefully — unique
CLAIM_Prod.sm.RouteDetail.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-22 10:51:51	COLD	KEEP — primary key
CLAIM_Prod.sm.QuotaStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.ContractAudit.PK_ReconcileArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.BookingHeader.PK_ShipmentArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-22 16:30:38	COLD	KEEP — primary key
CONTRACT.bm.BOM.PK_MeterHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-26 16:17:16	COLD	KEEP — primary key
CONTRACT.bm.CatalogQueue.PK_StaffingSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.bm.ShiftEntry.PK_RouteStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.bm.BillingArchive.PK_AssetMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.bm.ForecastDetail.PK_CatalogLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.dbo.StaffingEntry.PK_AssetStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.dbo.QuotaLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-03-20 00:42:51	COLD	KEEP — primary key
CONTRACT.dbo.QuotaLine.UX_ForecastSummary	2	NONCLUSTERED	Y			0	0	0	0	never	2024-03-19 23:35:10	COLD	review carefully — unique
CONTRACT.dbo.QuotaResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.dbo.QuotaResult.IX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
CONTRACT.lib.Color.PK_ReconcileStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-27 11:05:56	COLD	KEEP — primary key
CONTRACT.lib.SalesLine.PK_StaffingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-10-17 10:54:55	COLD	KEEP — primary key
CONTRACT.lib.SalesLine.UX_QuotaArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2024-10-17 10:54:55	COLD	review carefully — unique
CONTRACT.lib.CustomerLog.PK_ClaimMonthly	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:48:57	COLD	KEEP — primary key
CONTRACT.lib.BillingArchive.PK_StaffingDetail	1	CLUSTERED	Y	Y		0	1	0	0	2026-01-09 09:30:59	2024-05-03 14:41:51	USED	KEEP — primary key
CONTRACT.lib.BillingArchive.UX_CustomerEntry	9	NONCLUSTERED	Y			0	0	0	0	never	2024-05-02 14:04:36	COLD	review carefully — unique
CONTRACT.lib.CustomerArchive.PK_ForecastSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-25 08:33:29	COLD	KEEP — primary key
CONTRACT.lib.SettlementHeader.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-04-19 11:10:12	COLD	KEEP — primary key
CONTRACT.lib.SettlementHeader.UX_ForecastDaily	2	NONCLUSTERED	Y			0	0	0	0	never	2024-03-20 09:31:23	COLD	review carefully — unique
CONTRACT.lib.SupplierSummary.PK_BookingHeader	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.lib.LedgerSnapshot.PK_ClaimDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.lib.RouteDetail.PK_SalesStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-05-02 14:04:52	COLD	KEEP — primary key
CONTRACT.lib.ReconcileEntry.PK_BatchLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-10-17 11:25:37	COLD	KEEP — primary key
CONTRACT.lib.RouteStatus.PK_ShiftAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.lib.InvoiceLine.PK_AssetArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-27 12:41:06	COLD	KEEP — primary key
CONTRACT.lib.Size.PK_ClaimArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-08-06 09:47:03	COLD	KEEP — primary key
CONTRACT.lib.StaffingQueue.PK_CampaignAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-08-06 09:34:07	COLD	KEEP — primary key
CONTRACT.lib.MeterAudit.PK_TerritoryDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-08-06 09:34:07	COLD	KEEP — primary key
CONTRACT.lib.RosterResult.PK_ShipmentEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:48:50	COLD	KEEP — primary key
CONTRACT.lib.BookingResult.PK_ForecastLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-04-19 11:10:12	COLD	KEEP — primary key
CONTRACT.lib.MeterAudit.PK_ReconcileDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-21 09:20:39	COLD	KEEP — primary key
CONTRACT.lib.ContractLog.PK_TerritoryLog	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:56:33	COLD	KEEP — primary key
CONTRACT.lib.CustomerLine.PK_QuotaArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:56:33	COLD	KEEP — primary key
CONTRACT.sm.QuotaHistory.PK_BatchLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-30 14:06:31	COLD	KEEP — primary key
CONTRACT.sm.InvoiceStaging.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:48:57	COLD	KEEP — primary key
CONTRACT.sm.PricingStatus.PK_LedgerHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:48:57	COLD	KEEP — primary key
CONTRACT.sm.TerritoryArchive.PK_TerritoryLine	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-04-17 13:41:28	COLD	KEEP — primary key
CONTRACT.sm.TerritoryArchive.UX_PayrollResult	4	NONCLUSTERED	Y			0	0	0	0	never	2024-04-17 13:41:50	COLD	review carefully — unique
CONTRACT.sm.BookingResult.PK_RosterStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-08-28 12:42:56	COLD	KEEP — primary key
CONTRACT.sm.TerritoryMonthly.PK_BookingAudit	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-04 07:48:57	COLD	KEEP — primary key
CONTRACT.sm.TerritoryMonthly.UX_StaffingResult	2	NONCLUSTERED	Y			0	0	0	0	never	2024-09-04 07:48:57	COLD	review carefully — unique
CONTRACT.sm.QuotaDaily.PK_BookingDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.sm.QuotaDaily.UX_QuotaQueue	2	NONCLUSTERED	Y			0	0	0	0	never	2024-09-17 13:31:33	COLD	review carefully — unique
CONTRACT.sm.CatalogResult.PK_SalesStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-26 08:10:58	COLD	KEEP — primary key
CONTRACT.sm.BatchAudit.PK_ReconcileHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.sm.ShiftDaily.PK_ClaimHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-09-17 13:31:33	COLD	KEEP — primary key
CONTRACT.sm.OrdersMonthly.PK_PolicyHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.sm.InvoiceLine.PK_PayrollDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.sm.BillingEntry.PK_SettlementArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.sm.ShipmentDaily.PK_CatalogDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.sm.ShipmentDaily.UX_TicketMonthly	2	NONCLUSTERED	Y			0	0	0	0	never	2024-09-17 13:31:33	COLD	review carefully — unique
CONTRACT.sm.PolicyHeader.PK_CustomerSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.sm.PolicyHeader.UX_LedgerDetail	2	NONCLUSTERED	Y			0	0	0	0	never	2024-09-17 13:31:33	COLD	review carefully — unique
CONTRACT.sm.RouteDetail.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-26 08:10:58	COLD	KEEP — primary key
CONTRACT.sm.QuotaStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.sm.ContractAudit.PK_ReconcileArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
CONTRACT.sm.BookingHeader.PK_ShipmentArchive	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-11-26 08:10:58	COLD	KEEP — primary key