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-125 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-11T18:05:35Z

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
METER_Prod	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
SETTLEMENT	129	13	0	no action — cold indexes here are constraints or clustered
PAYROLL	1	1	0	no action — cold indexes here are constraints or clustered
APP	22	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	275780	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
PPG.dbo.MeterLog.IX_RosterHistory	0	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_TicketLog	0	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_RosterDaily	0	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_AssetEntry	0	never	COLD	review, then DROP
PPG.dbo.TerritorySnapshot.IX_SupplierEntry	0	never	COLD	review, then DROP
PPG.dbo.TicketDaily.IX_RouteMonthly	0	never	COLD	review, then DROP
PPG.dbo.Task.IX_PayrollDaily	0	never	COLD	review, then DROP
PPG.dbo.QuotaAudit.IX_OrdersAudit	0	never	COLD	review, then DROP
PPG.dbo.CustomerSummary.IX_BatchAudit	0	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStaging.IX_StaffingSnapshot	0	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStaging.IX_CatalogStatus	0	never	COLD	review, then DROP
BATCH_Test.dbo.MeterMonthly.IX_RouteHeader	0	never	COLD	review, then DROP
SALES.kar.LedgerLog.IX_PricingAudit	0	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_RosterHistory	0	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_TicketLog	0	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_RosterDaily	0	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_AssetEntry	0	never	COLD	review, then DROP
SALES.dbo.TicketDaily.IX_RouteMonthly	0	never	COLD	review, then DROP
SALES.dbo.Task.IX_PayrollDaily	0	never	COLD	review, then DROP
SALES.dbo.QuotaAudit.IX_OrdersAudit	0	never	COLD	review, then DROP
SALES.dbo.CustomerSummary.IX_BatchAudit	0	never	COLD	review, then DROP
SALES.dbo.LedgerStatus.IX_CampaignQueue	0	never	COLD	review, then DROP
SALES.dbo.PricingLine.IX_RosterSummary	0	never	COLD	review, then DROP
SALES.dbo.PricingLine.IX_LedgerDetail	0	never	COLD	review, then DROP
SALES.dbo.LedgerStaging.IX_StaffingSnapshot	0	never	COLD	review, then DROP
SALES.dbo.LedgerStaging.IX_CatalogStatus	0	never	COLD	review, then DROP
SALES.dbo.MeterMonthly.IX_RouteHeader	0	never	COLD	review, then DROP
METER_Prod.pto.ContractEntry.IX_CustomerDaily	0	never	COLD	review, then DROP
METER_Prod.pto.ClaimResult.IX_ContractDetail	0	never	COLD	review, then DROP
PPG.dbo.SettlementDetail.IX_StaffingLog	0	never	UNUSED	review, then DROP
PPG.dbo.SettlementDetail.IX_PayrollResult	0	never	UNUSED	review, then DROP
PPG.dbo.SettlementDetail.IX_RosterResult	0	never	UNUSED	review, then DROP
PPG.dbo.History.IX_OrdersLog	0	never	UNUSED	review, then DROP
PPG.dbo.History.IX_ContractQueue	0	never	UNUSED	review, then DROP
PPG.dbo.History.IX_PolicyDetail	0	never	UNUSED	review, then DROP
BATCH_Test.kar.LedgerLog.IX_PricingAudit	0	never	UNUSED	review, then DROP
SALES.dbo.History.IX_OrdersLog	0	never	UNUSED	review, then DROP
SALES.dbo.History.IX_ContractQueue	0	never	UNUSED	review, then DROP
SALES.dbo.History.IX_PolicyDetail	0	never	UNUSED	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_PayrollResult	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

Fragmented (1)

Total 10.6 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	45.8%	1,354	10.6	2026-09-11 15:36:02	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		1888519	1065	13011091	1024	2026-09-12 00:05:46	2026-09-12 01:00:01	USED	KEEP — primary key
APP.app.ShiftAudit.UX_PayrollAudit	4	NONCLUSTERED	Y			13012047	492	0	496	2026-09-12 00:05:46	2026-09-12 01:00:01	USED	keep — in use
APP.app.ReconcileDaily.PK_LedgerResult	1	CLUSTERED	Y	Y		9945460	17	0	13166	2026-09-11 20:18:46	2026-07-01 01:00:01	USED	KEEP — primary key
APP.app.PolicyStatus.PK_RouteArchive	1	CLUSTERED	Y	Y		976	11	0	6	2026-09-04 14:45:02	2026-05-16 01:00:01	USED	KEEP — primary key
APP.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	1	0	1008	2025-12-15 10:27:19	never	USED	KEEP — primary key
APP.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	2	0	13166	2025-12-15 10:49:01	never	USED	KEEP — primary key
APP.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		2716911	1346019	0	3	2026-09-11 20:18:46	2026-01-11 01:00:01	USED	KEEP — primary key
APP.app.CampaignAudit.PK_BillingMonthly	1	CLUSTERED	Y	Y		1821	12	0	231	2026-09-04 14:45:02	2026-05-12 01:00:01	USED	KEEP — primary key
APP.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		1994	2716100	0	77	2026-09-11 20:18:46	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		1345996	425	0	48	2026-09-11 20:18:46	2026-03-04 01:00:01	USED	KEEP — primary key
APP.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		1371065	52	0	51	2026-09-11 20:18:46	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		1370818	1089	0	32	2026-09-11 20:18:46	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.InvoiceHeader.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
STAFFING.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		0	1447	0	1437	2026-07-18 12:32:26	never	USED	KEEP — primary key
STAFFING.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	4	0	1437	2025-11-28 08:28:38	never	USED	KEEP — primary key
STAFFING.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		888	394	0	39	2026-09-04 14:45:02	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	479	0	29	2026-09-04 14:45:02	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	586	0	0	2026-09-04 14:43:23	2025-10-14 16:04:26	USED	KEEP — primary key
RECONCILE.inc.CampaignDaily.PK_ShiftStaging	1	CLUSTERED	Y	Y		592	1708	0	3	2026-09-04 14:45:02	2026-01-11 01:00:02	USED	KEEP — primary key
RECONCILE.inc.RosterArchive.PK_ContractQueue	1	CLUSTERED	Y	Y		69	596	0	1	2026-09-04 14:43:23	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	720	0	2	2026-09-04 14:43:23	2026-05-16 01:00:01	USED	KEEP — primary key
METER_Prod.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y		116773	6707295	729730	58	2026-09-11 20:27:45	2026-08-27 01:00:03	USED	KEEP — primary key
METER_Prod.app.ShiftAudit.UX_PayrollAudit	2	NONCLUSTERED	Y			21	179789	0	58	2026-09-11 18:57:37	2026-08-27 01:00:03	USED	keep — in use
METER_Prod.app.ShiftAudit.UX_BillingStatus	3	NONCLUSTERED	Y			913913	0	0	58	2026-09-11 20:05:52	2026-08-27 01:00:03	USED	keep — in use
METER_Prod.app.SettlementEntry.PK_ContractLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.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
METER_Prod.app.BillingAudit.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		893840	443	0	494	2026-09-11 20:27:44	2026-08-28 01:00:03	USED	KEEP — primary key
METER_Prod.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		434610	459762	0	76	2026-09-11 20:27:44	2026-08-28 01:00:03	USED	KEEP — primary key
METER_Prod.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	76	never	2026-08-28 01:00:03	UNUSED	review carefully — unique
METER_Prod.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		1655567	0	0	1264	2026-09-11 20:27:44	2026-09-11 01:00:02	USED	KEEP — primary key
METER_Prod.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	16	0	0	2026-04-17 20:36:48	never	USED	KEEP — primary key
METER_Prod.app.InvoiceLine.UX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
METER_Prod.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y		99646	810829	0	7	2026-09-11 20:27:44	2026-08-27 01:00:03	USED	KEEP — primary key
METER_Prod.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
METER_Prod.app.ClaimResult.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.bm.PricingQueue.PK_InvoiceArchive	1	CLUSTERED	Y	Y		2691133	111971	4	40526	2026-09-11 19:26:54	2026-09-12 01:00:03	USED	KEEP — primary key
METER_Prod.bm.PricingQueue.UX_InvoiceLog	2	NONCLUSTERED	Y			185961	39723	0	9628	2026-09-11 19:15:11	2026-09-12 01:00:03	USED	keep — in use
METER_Prod.bm.RosterDetail.PK_QuotaArchive	1	CLUSTERED	Y	Y		350026	3925487	0	31353	2026-09-11 19:26:54	2026-09-12 01:00:03	USED	KEEP — primary key
METER_Prod.bm.MeterEntry.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	1	0	9630	2026-04-23 12:53:05	never	USED	KEEP — primary key
METER_Prod.bm.MeterHistory.PK_BillingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.bm.QuotaEntry.PK_InvoiceAudit	1	CLUSTERED	Y	Y		0	5	0	18803	2026-02-05 10:43:08	never	USED	KEEP — primary key
METER_Prod.bm.OrdersResult.PK_SupplierStaging	1	CLUSTERED	Y	Y		1324185	2610213	612114	167569	2026-09-11 20:27:45	2026-09-12 01:00:04	USED	KEEP — primary key
METER_Prod.bm.OrdersResult.UX_PolicyMonthly	2	NONCLUSTERED	Y			994769	27938	0	25476	2026-09-11 20:27:44	2026-09-12 01:00:04	USED	keep — in use
METER_Prod.bm.TicketAudit.PK_WarehouseQueue	1	CLUSTERED	Y	Y		19721	88696	0	9034	2026-09-11 18:57:26	2026-09-12 01:00:05	USED	KEEP — primary key
METER_Prod.bm.TicketLog.PK_SalesStaging	1	CLUSTERED	Y	Y		39460	88699	0	28757	2026-09-11 18:57:26	2026-09-12 01:00:05	USED	KEEP — primary key
METER_Prod.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		937951	0	0	0	2026-09-11 20:27:44	2025-08-01 01:00:56	USED	KEEP — primary key
METER_Prod.dbo.BatchResult.PK_PolicySummary	1	CLUSTERED	Y	Y		1	561741	0	239944	2026-09-11 20:27:44	2026-09-12 01:00:05	USED	KEEP — primary key
METER_Prod.dbo.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		4255897	861357	81	78	2026-09-11 20:05:52	2026-09-04 01:00:04	USED	KEEP — primary key
METER_Prod.dbo.CatalogQueue.UX_ReconcileStaging	2	NONCLUSTERED	Y			14678	835896	0	78	2026-09-11 20:27:45	2026-09-04 01:00:04	USED	keep — in use
METER_Prod.dbo.OrdersAudit.PK_ReconcileStatus	1	CLUSTERED	Y	Y		4135479	1152336	7	1932	2026-09-11 20:27:45	2026-09-12 01:00:05	USED	KEEP — primary key
METER_Prod.dbo.OrdersAudit.UX_OrdersEntry	2	NONCLUSTERED	Y			30904	4482	0	1931	2026-09-11 18:56:57	2026-09-12 01:00:05	USED	keep — in use
METER_Prod.dbo.PricingMonthly.PK_LedgerDetail	1	CLUSTERED	Y	Y		0	0	0	1797	never	never	UNUSED	KEEP — primary key
METER_Prod.flx.SettlementResult.PK_ContractResult	1	CLUSTERED	Y	Y		126222	152705	0	17	2026-09-11 16:53:08	2026-07-05 01:00:05	USED	KEEP — primary key
METER_Prod.flx.InvoiceAudit.PK_CatalogAudit	1	CLUSTERED	Y	Y		297	11016	0	15	2026-09-11 16:18:53	never	USED	KEEP — primary key
METER_Prod.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
METER_Prod.flx.ShiftStaging.PK_PricingHeader	1	CLUSTERED	Y	Y		13486	7700	0	6743	2026-09-11 16:53:08	2026-09-12 01:00:05	USED	KEEP — primary key
METER_Prod.flx.InvoiceLine.PK_SettlementMonthly	1	CLUSTERED	Y	Y		633	5387	27850	824	2026-09-12 01:00:22	2026-09-10 01:00:04	USED	KEEP — primary key
METER_Prod.flx.InvoiceLine.UQ_LedgerResult	2	NONCLUSTERED	Y			31921	19	0	539	2026-09-11 16:13:57	2026-09-10 01:00:04	USED	keep — in use
METER_Prod.flx.AssetLog.PK_ContractLine	1	CLUSTERED	Y	Y		0	21096	0	616	2026-09-12 01:00:22	2026-09-10 01:00:04	USED	KEEP — primary key
METER_Prod.flx.CustomerLine.IX_SalesEntry	2	NONCLUSTERED				3685	1240	0	985	2026-09-09 14:27:28	2026-09-06 01:00:05	USED	keep — in use
METER_Prod.flx.CustomerLine.PK_ClaimAudit	1	CLUSTERED	Y	Y		80823	15251	44	987	2026-09-11 16:31:33	2026-09-06 01:00:05	USED	KEEP — primary key
METER_Prod.flx.CustomerLine.IX_InvoiceSummary	14	NONCLUSTERED	Y			0	4409	0	817	2026-09-11 16:16:31	2026-09-06 01:00:05	USED	keep — in use
METER_Prod.flx.BatchSummary.PK_MeterResult	1	CLUSTERED	Y	Y		0	0	0	10	never	never	UNUSED	KEEP — primary key
METER_Prod.flx.OrdersMonthly.IX_RosterMonthly	6	NONCLUSTERED				29078	0	0	13974	2026-09-11 16:22:26	2026-09-12 01:00:05	USED	keep — in use
METER_Prod.flx.OrdersMonthly.PK_PolicySnapshot	1	CLUSTERED	Y	Y		15639	81503	29064	13988	2026-09-11 16:32:46	2026-09-12 01:00:05	USED	KEEP — primary key
METER_Prod.flx.SalesLog.PK_ContractAudit	1	CLUSTERED	Y	Y		0	24083	0	10360	2026-09-11 16:32:46	never	USED	KEEP — primary key
METER_Prod.flx.PolicyDetail.PK_AssetSnapshot	1	CLUSTERED	Y	Y		0	4579	0	1759	2026-09-11 16:32:46	never	USED	KEEP — primary key
METER_Prod.flx.RosterStatus.PK_TerritoryHistory	1	CLUSTERED	Y	Y		35155	42229	0	13648	2026-09-11 16:23:42	2026-09-12 01:00:05	USED	KEEP — primary key
METER_Prod.flx.ClaimHeader.IX_WarehouseMonthly	15	NONCLUSTERED				239019	6	0	1701	2026-09-11 16:28:42	2026-09-12 01:00:05	USED	keep — in use
METER_Prod.flx.ClaimHeader.PK_BatchAudit	1	CLUSTERED	Y	Y		689052	165347	193260	1746	2026-09-11 16:48:37	2026-09-11 01:00:04	USED	KEEP — primary key
METER_Prod.flx.ClaimHeader.UX_SupplierDetail	2	NONCLUSTERED	Y			1084	15	0	1742	2026-09-11 16:53:08	2026-09-12 01:00:05	USED	keep — in use
METER_Prod.flx.ShiftArchive.PK_PricingEntry	1	CLUSTERED	Y	Y		0	1505	0	186	2026-09-10 15:32:18	never	USED	KEEP — primary key
METER_Prod.flx.QuotaStatus.PK_SalesResult	1	CLUSTERED	Y	Y		15	1306	0	11	2026-09-11 12:38:34	2026-09-10 01:00:05	USED	KEEP — primary key
METER_Prod.flx.SupplierDetail.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		0	9	0	11	2026-08-28 14:54:57	never	USED	KEEP — primary key
METER_Prod.flx.ContractQueue.PK_QuotaEntry	1	CLUSTERED	Y	Y		0	4	0	1825	2026-04-17 20:17:01	never	USED	KEEP — primary key
METER_Prod.flx.PricingHistory.IX_ShiftDaily	2	NONCLUSTERED				487646	21	0	4722	2026-09-11 16:48:37	2026-09-12 01:00:06	USED	keep — in use
METER_Prod.flx.PricingHistory.PK_ReconcileHistory	1	CLUSTERED	Y	Y		1674	52134	367368	4722	2026-09-11 16:32:46	2026-09-12 01:00:06	USED	KEEP — primary key
METER_Prod.flx.MeterArchive.IX_BatchHeader	2	NONCLUSTERED				522131	17	0	10557	2026-09-11 16:48:37	2026-09-12 01:00:06	USED	keep — in use
METER_Prod.flx.MeterArchive.PK_BatchDaily	1	CLUSTERED	Y	Y		3841	16663	401942	10567	2026-09-11 16:32:46	2026-09-12 01:00:06	USED	KEEP — primary key
METER_Prod.flx.InvoiceLine.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	8	0	7560	2026-08-19 19:33:14	never	USED	KEEP — primary key
METER_Prod.flx.BookingLog.PK_CatalogLine	1	CLUSTERED	Y	Y		0	5	0	3391	2026-04-11 14:15:45	never	USED	KEEP — primary key
METER_Prod.flx.PayrollSnapshot.PK_LedgerResult	1	CLUSTERED	Y	Y		2386857	32233	0	2055	2026-09-11 16:32:46	2026-09-12 01:00:05	USED	KEEP — primary key
METER_Prod.flx.SettlementLine.PK_QuotaHistory	1	CLUSTERED	Y	Y		60786	2509478	0	4921	2026-09-11 16:53:08	2026-09-12 01:00:06	USED	KEEP — primary key
METER_Prod.flx.SettlementLine.PK_SettlementEntry	1	CLUSTERED	Y	Y		0	173356	0	7997	2026-09-11 16:28:40	never	USED	KEEP — primary key
METER_Prod.flx.ShiftLine.PK_StaffingStaging	1	CLUSTERED	Y	Y		0	7	0	3368	2026-08-19 19:36:53	never	USED	KEEP — primary key
METER_Prod.flx.TicketDaily.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	4973	never	never	UNUSED	KEEP — primary key
METER_Prod.flx.MeterStaging.PK_CatalogResult	1	CLUSTERED	Y	Y		0	0	0	1575	never	never	UNUSED	KEEP — primary key
METER_Prod.flx.StaffingLine.PK_PolicyHistory	1	CLUSTERED	Y	Y		65996	372308	0	72605	2026-09-11 16:53:08	2026-09-12 01:00:06	USED	KEEP — primary key
METER_Prod.flx.ForecastQueue.PK_BillingEntry	1	CLUSTERED	Y	Y		20	13903	0	264	2026-09-11 16:18:54	never	USED	KEEP — primary key
METER_Prod.flx.QuotaResult.PK_InvoiceArchive	1	CLUSTERED	Y	Y		0	0	0	725	never	never	UNUSED	KEEP — primary key
METER_Prod.flx.CustomerSummary.PK_PricingLine	1	CLUSTERED	Y	Y		0	180671	0	59053	2026-09-11 16:53:08	never	USED	KEEP — primary key
METER_Prod.flx.RouteAudit.PK_ContractStatus	1	CLUSTERED	Y	Y		8860	3125	2149	908	2026-09-11 16:31:33	2026-09-06 01:00:05	USED	KEEP — primary key
METER_Prod.flx.RouteAudit.UX_BookingEntry	2	NONCLUSTERED	Y			2367	4920	0	219	2026-09-11 16:31:33	2026-09-06 01:00:05	USED	keep — in use
METER_Prod.flx.MeterSummary.PK_PolicyResult	1	CLUSTERED	Y	Y		415	9483	0	2050	2026-09-11 10:27:39	never	USED	KEEP — primary key
METER_Prod.flx.ContractDetail.PK_CampaignStaging	1	CLUSTERED	Y	Y		0	0	0	1	never	never	UNUSED	KEEP — primary key
METER_Prod.flx.WarehouseDaily.PK_QuotaLog	1	CLUSTERED	Y	Y		0	0	0	5	never	never	UNUSED	KEEP — primary key
METER_Prod.flx.TicketStaging.PK_ForecastArchive	1	CLUSTERED	Y	Y		211963	119036	1881	497	2026-09-11 16:48:37	2026-09-11 01:00:05	USED	KEEP — primary key
METER_Prod.flx.TicketStaging.UX_ShipmentStaging	2	NONCLUSTERED	Y			2209	2686	0	497	2026-09-10 15:21:33	2026-09-11 01:00:05	USED	keep — in use
METER_Prod.flx.MeterLine.PK_SettlementStaging	1	CLUSTERED	Y	Y		207411	117980	0	4949	2026-09-11 16:53:08	2026-09-12 01:00:06	USED	KEEP — primary key
METER_Prod.flx.MeterLine.UX_RouteStatus	2	NONCLUSTERED	Y			1654	125	0	4948	2026-09-11 14:58:53	2026-09-12 01:00:06	USED	keep — in use
METER_Prod.flx.TerritoryArchive.PK_OrdersLine	1	CLUSTERED	Y	Y		33528	2297910	0	1683	2026-09-11 16:53:08	2026-09-12 01:00:06	USED	KEEP — primary key
METER_Prod.flx.PolicyDaily.PK_RosterResult	1	CLUSTERED	Y	Y		0	3	0	303	2026-08-26 20:02:40	never	USED	KEEP — primary key
METER_Prod.flx.PolicyMonthly.PK_PayrollStaging	1	CLUSTERED	Y	Y		0	2	0	302	2026-06-17 07:37:37	never	USED	KEEP — primary key
METER_Prod.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
METER_Prod.flx.ForecastEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		2242	1325	0	5	2026-09-10 15:19:26	2026-08-29 01:00:05	USED	KEEP — primary key
METER_Prod.flx.ShiftSnapshot.PK_LedgerMonthly	1	CLUSTERED	Y	Y		0	1	0	2	2026-06-06 09:53:19	never	USED	KEEP — primary key
METER_Prod.flx.ShiftSnapshot.UQ_CatalogDetail	2	NONCLUSTERED	Y			537	4	0	2	2026-09-09 14:54:51	2026-06-07 20:13:04	USED	keep — in use
METER_Prod.inv.Inventory.PK_InvoiceSummary	1	CLUSTERED	Y	Y		767168	1115838	0	266579	2026-09-11 19:15:17	2026-09-12 01:00:06	USED	KEEP — primary key
METER_Prod.inv.SupplierStatus.PK_PolicySnapshot	1	CLUSTERED	Y	Y		499748	2401457	538110	148871	2026-09-11 19:15:16	2026-09-12 01:00:06	USED	KEEP — primary key
METER_Prod.inv.SupplierStatus.UX_SalesHeader	6	NONCLUSTERED	Y			589152	4484	0	59008	2026-09-11 16:26:32	2026-09-12 01:00:06	USED	keep — in use
METER_Prod.inv.ShipmentDetail.PK_WarehouseSummary	1	CLUSTERED	Y	Y		597468	174720	0	130489	2026-09-11 19:11:05	2026-09-12 01:00:06	USED	KEEP — primary key
METER_Prod.org.BatchDaily.PK_QuotaStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.org.BatchDaily.UX_PricingResult	2	NONCLUSTERED	Y			0	0	0	0	never	2024-10-05 22:14:24	COLD	review carefully — unique
METER_Prod.po.PO.PK_SettlementDaily	1	CLUSTERED	Y	Y		5602203	892376	31405	87052	2026-09-11 20:27:45	2026-09-12 01:00:06	USED	KEEP — primary key
METER_Prod.po.PO.UX_TerritoryMonthly	2	NONCLUSTERED	Y			617104	499330	0	14525	2026-09-11 20:27:44	2026-09-12 01:00:06	USED	keep — in use
METER_Prod.po.ClaimSummary.PK_BatchSnapshot	1	CLUSTERED	Y	Y		1635466	160644	251289	62276	2026-09-11 19:26:54	2026-09-12 01:00:07	USED	KEEP — primary key
METER_Prod.po.ClaimSummary.UX_PayrollResult	2	NONCLUSTERED	Y			330153	1	0	14420	2026-09-11 18:57:21	2026-09-12 01:00:07	USED	keep — in use
METER_Prod.po.RosterLog.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.po.AssetMonthly.PK_PolicyDetail	1	CLUSTERED	Y	Y		0	5	0	61808	2026-06-16 08:51:14	never	USED	KEEP — primary key
METER_Prod.pto.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		0	292	0	0	2026-08-14 09:48:44	never	USED	KEEP — primary key
METER_Prod.pto.ContractHeader.PK_ContractEntry	1	CLUSTERED	Y	Y		627	3	0	0	2026-08-14 09:48:44	never	USED	KEEP — primary key
METER_Prod.pto.ContractHeader.UX_SalesResult	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
METER_Prod.pto.SalesHistory.PK_TicketDetail	1	CLUSTERED	Y	Y		55	572	5	0	2026-08-14 09:48:44	never	USED	KEEP — primary key
METER_Prod.pto.SalesHistory.UX_ContractDetail	2	NONCLUSTERED	Y			10	0	0	0	2026-06-24 17:39:46	never	USED	keep — in use
METER_Prod.pto.ClaimResult.IX_ContractDetail	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
METER_Prod.pto.ClaimResult.PK_SalesLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.pto.LedgerResult.IX_TerritoryResult	2	NONCLUSTERED				238	0	0	0	2026-08-14 09:48:40	never	USED	keep — in use
METER_Prod.pto.LedgerResult.PK_TicketArchive	1	CLUSTERED	Y	Y		0	468	238	0	2026-08-14 09:48:41	never	USED	KEEP — primary key
METER_Prod.pto.ContractEntry.IX_CustomerDaily	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
METER_Prod.pto.ContractEntry.PK_SettlementDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.ops.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.ops.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		0	1	0	0	2026-03-23 13:51:17	never	USED	KEEP — primary key
METER_Prod.ops.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.audit.SupplierArchive.PK_PolicyQueue	1	CLUSTERED	Y	Y		121	0	0	0	2026-08-14 09:48:44	never	USED	KEEP — primary key
METER_Prod.audit.CatalogQueue.PK_TicketHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.audit.CampaignLine.PK_MeterStaging	1	CLUSTERED	Y	Y		0	121	0	0	2026-08-14 09:48:44	never	USED	KEEP — primary key
METER_Prod.audit.TicketLog.PK_ReconcileDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
METER_Prod.qc.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		13693	53228	0	17	2026-09-11 20:16:27	2026-08-29 01:00:06	USED	KEEP — primary key
METER_Prod.qc.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		11744	634260	0	47840	2026-09-11 20:27:44	2026-09-12 01:00:07	USED	KEEP — primary key
METER_Prod.qc.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	76	0	47822	2026-07-24 10:22:05	2026-09-12 01:00:08	USED	KEEP — primary key
METER_Prod.qc.CampaignSummary.PK_PricingStatus	1	CLUSTERED	Y	Y		483720	528501	0	84424	2026-09-11 20:27:45	2026-09-12 01:00:08	USED	KEEP — primary key
SETTLEMENT.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y		29847	201135	26448	15	2026-09-11 22:52:04	2026-08-20 01:00:08	USED	KEEP — primary key
SETTLEMENT.app.ShiftAudit.UX_PayrollAudit	2	NONCLUSTERED	Y			7	2055	0	13	2026-09-11 16:00:03	2026-08-20 01:00:08	USED	keep — in use
SETTLEMENT.app.ShiftAudit.UX_BillingStatus	3	NONCLUSTERED	Y			26994	1	0	13	2026-09-11 22:51:35	2026-08-20 01:00:08	USED	keep — in use
SETTLEMENT.app.SettlementEntry.PK_ContractLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.app.BillingAudit.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		31954	379	0	10	2026-09-11 22:52:04	2026-08-20 01:00:08	USED	KEEP — primary key
SETTLEMENT.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		19738	13008	0	41	2026-09-11 22:52:04	2026-05-22 01:00:05	USED	KEEP — primary key
SETTLEMENT.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	41	never	2026-08-22 01:00:09	UNUSED	review carefully — unique
SETTLEMENT.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		43847	9	0	482	2026-09-11 22:52:04	2026-08-22 01:00:09	USED	KEEP — primary key
SETTLEMENT.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	1	0	0	2026-08-21 13:07:16	never	USED	KEEP — primary key
SETTLEMENT.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.app.InvoiceLine.UX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SETTLEMENT.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y		20549	30093	0	15	2026-09-11 22:52:04	2026-08-21 01:00:08	USED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.app.ClaimResult.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.bm.PricingQueue.PK_InvoiceArchive	1	CLUSTERED	Y	Y		27414	2522	3	346	2026-09-11 22:51:56	2026-09-12 01:00:09	USED	KEEP — primary key
SETTLEMENT.bm.PricingQueue.UX_InvoiceLog	2	NONCLUSTERED	Y			732	154	0	166	2026-09-11 16:04:08	2026-09-12 01:00:09	USED	keep — in use
SETTLEMENT.bm.RosterDetail.PK_QuotaArchive	1	CLUSTERED	Y	Y		878	53079	0	244	2026-09-11 22:51:56	2026-09-12 01:00:09	USED	KEEP — primary key
SETTLEMENT.bm.MeterEntry.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	1	0	166	2026-04-23 10:52:23	never	USED	KEEP — primary key
SETTLEMENT.bm.MeterHistory.PK_BillingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.bm.QuotaEntry.PK_InvoiceAudit	1	CLUSTERED	Y	Y		0	0	0	268	never	never	UNUSED	KEEP — primary key
SETTLEMENT.bm.OrdersResult.PK_SupplierStaging	1	CLUSTERED	Y	Y		3304	27530	1446	595	2026-09-11 22:51:56	2026-09-12 01:00:09	USED	KEEP — primary key
SETTLEMENT.bm.OrdersResult.UX_PolicyMonthly	2	NONCLUSTERED	Y			1755	6	0	207	2026-09-11 22:51:39	2026-09-12 01:00:09	USED	keep — in use
SETTLEMENT.bm.TicketAudit.PK_WarehouseQueue	1	CLUSTERED	Y	Y		88	1651	0	91	2026-09-11 22:51:56	2026-09-12 01:00:09	USED	KEEP — primary key
SETTLEMENT.bm.TicketLog.PK_SalesStaging	1	CLUSTERED	Y	Y		184	1654	0	187	2026-09-11 22:51:56	2026-09-12 01:00:09	USED	KEEP — primary key
SETTLEMENT.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		25280	0	0	0	2026-09-11 22:51:56	2026-01-11 01:00:05	USED	KEEP — primary key
SETTLEMENT.dbo.BatchResult.PK_PolicySummary	1	CLUSTERED	Y	Y		0	1406	0	563	2026-09-11 22:51:38	2026-09-12 01:00:09	USED	KEEP — primary key
SETTLEMENT.dbo.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		42620	6552	0	0	2026-09-11 22:52:26	2026-01-11 01:00:05	USED	KEEP — primary key
SETTLEMENT.dbo.CatalogQueue.UX_ReconcileStaging	2	NONCLUSTERED	Y			179	23884	0	0	2026-09-11 22:51:48	2026-01-11 01:00:05	USED	keep — in use
SETTLEMENT.dbo.OrdersAudit.PK_ReconcileStatus	1	CLUSTERED	Y	Y		39854	6718	2	66	2026-09-11 22:51:56	2026-09-12 01:00:10	USED	KEEP — primary key
SETTLEMENT.dbo.OrdersAudit.UX_QuotaHeader	9	NONCLUSTERED	Y		Y	42	0	0	28	2026-09-11 11:26:45	never	USED	keep — in use
SETTLEMENT.dbo.OrdersAudit.UX_OrdersEntry	2	NONCLUSTERED	Y			364	317	0	64	2026-09-11 13:09:22	2026-09-12 01:00:10	USED	keep — in use
SETTLEMENT.dbo.PricingMonthly.PK_LedgerDetail	1	CLUSTERED	Y	Y		0	1	0	63	2026-09-04 09:28:18	never	USED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.flx.SettlementResult.PK_ContractResult	1	CLUSTERED	Y	Y		35035	11398	0	42	2026-09-11 16:13:37	2026-08-20 01:00:09	USED	KEEP — primary key
SETTLEMENT.flx.InvoiceAudit.PK_CatalogAudit	1	CLUSTERED	Y	Y		588	876	0	13	2026-09-10 15:57:22	never	USED	KEEP — primary key
SETTLEMENT.flx.ShiftStaging.PK_PricingHeader	1	CLUSTERED	Y	Y		540	3072	0	254	2026-09-11 14:42:13	2026-09-12 01:00:10	USED	KEEP — primary key
SETTLEMENT.flx.InvoiceLine.PK_SettlementMonthly	1	CLUSTERED	Y	Y		78	2490	624	406	2026-09-12 01:00:22	2026-08-20 01:00:09	USED	KEEP — primary key
SETTLEMENT.flx.InvoiceLine.UQ_LedgerResult	13	NONCLUSTERED	Y			1237	15	0	53	2026-09-10 15:11:58	2026-08-20 01:00:09	USED	keep — in use
SETTLEMENT.flx.ContractSummary.UQ_SalesQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SETTLEMENT.flx.AssetLog.PK_MeterLog	1	CLUSTERED	Y	Y		11	23509	0	304	2026-09-12 01:00:22	2026-08-20 01:00:09	USED	KEEP — primary key
SETTLEMENT.flx.CustomerLine.IX_SalesEntry	3	NONCLUSTERED				1128	128	0	139	2026-08-24 08:27:03	2026-08-20 01:00:09	USED	keep — in use
SETTLEMENT.flx.CustomerLine.PK_ClaimAudit	1	CLUSTERED	Y	Y		33943	7810	208	139	2026-09-11 11:07:21	2026-08-20 01:00:09	USED	KEEP — primary key
SETTLEMENT.flx.CustomerLine.IX_InvoiceSummary	9	NONCLUSTERED	Y			4	11	0	33	2026-08-16 13:17:08	2026-08-20 01:00:09	USED	keep — in use
SETTLEMENT.flx.BatchSummary.PK_MeterResult	1	CLUSTERED	Y	Y		0	4	0	15	2026-04-14 14:05:00	never	USED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.flx.OrdersMonthly.PK_PolicySnapshot	1	CLUSTERED	Y	Y		4483	13400	0	3974	2026-09-11 11:17:01	2026-09-12 01:00:10	USED	KEEP — primary key
SETTLEMENT.flx.SalesLog.PK_ContractAudit	1	CLUSTERED	Y	Y		0	16113	0	446	2026-09-11 11:17:01	never	USED	KEEP — primary key
SETTLEMENT.flx.PolicyDetail.PK_AssetSnapshot	1	CLUSTERED	Y	Y		4	2242	0	97	2026-09-11 11:17:01	never	USED	KEEP — primary key
SETTLEMENT.flx.RosterStatus.PK_TerritoryHistory	1	CLUSTERED	Y	Y		8436	45	0	616	2026-09-11 11:10:02	2026-09-11 01:00:08	USED	KEEP — primary key
SETTLEMENT.flx.ShipmentStaging.PK_CatalogSnapshot	1	CLUSTERED	Y	Y		0	1	0	1	2026-07-21 09:30:26	never	USED	KEEP — primary key
SETTLEMENT.flx.ClaimHeader.IX_WarehouseMonthly	15	NONCLUSTERED				91105	24	0	302	2026-09-11 11:10:02	2026-08-20 01:00:09	USED	keep — in use
SETTLEMENT.flx.ClaimHeader.PK_BatchAudit	1	CLUSTERED	Y	Y		91101	66982	90882	825	2026-09-11 14:46:06	2026-08-20 01:00:09	USED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.flx.ShiftArchive.PK_PricingEntry	1	CLUSTERED	Y	Y		0	1101	0	87	2026-08-27 08:02:53	never	USED	KEEP — primary key
SETTLEMENT.flx.QuotaStatus.PK_SalesResult	1	CLUSTERED	Y	Y		460	1340	0	288	2026-08-27 08:02:53	2026-08-25 01:00:19	USED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.flx.ContractQueue.PK_QuotaEntry	1	CLUSTERED	Y	Y		0	14	0	347	2026-08-21 12:07:16	never	USED	KEEP — primary key
SETTLEMENT.flx.PricingHistory.IX_ShiftDaily	2	NONCLUSTERED				64964	158	0	1079	2026-09-11 11:17:01	2026-08-20 01:00:09	USED	keep — in use
SETTLEMENT.flx.PricingHistory.PK_ReconcileHistory	1	CLUSTERED	Y	Y		419	3830	56640	1079	2026-09-11 11:17:01	2026-08-20 01:00:09	USED	KEEP — primary key
SETTLEMENT.flx.MeterArchive.IX_BatchHeader	7	NONCLUSTERED				15135	9	0	226	2026-09-11 11:17:01	2026-08-20 01:00:09	USED	keep — in use
SETTLEMENT.flx.MeterArchive.PK_BatchDaily	1	CLUSTERED	Y	Y		952	49278	12963	863	2026-09-11 11:17:01	2026-08-20 01:00:09	USED	KEEP — primary key
SETTLEMENT.flx.InvoiceLine.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	17	0	624	2026-08-18 20:59:53	never	USED	KEEP — primary key
SETTLEMENT.flx.BookingLog.PK_CatalogLine	1	CLUSTERED	Y	Y		0	6	0	449	2026-04-14 14:05:00	never	USED	KEEP — primary key
SETTLEMENT.flx.PayrollSnapshot.PK_LedgerResult	1	CLUSTERED	Y	Y		187422	6823	0	422	2026-09-11 11:17:01	2026-09-11 01:00:08	USED	KEEP — primary key
SETTLEMENT.flx.SettlementLine.PK_QuotaHistory	1	CLUSTERED	Y	Y		2525	220622	0	782	2026-09-11 14:46:06	2026-09-11 01:00:08	USED	KEEP — primary key
SETTLEMENT.flx.SettlementLine.PK_SettlementEntry	1	CLUSTERED	Y	Y		3	2932	0	1057	2026-09-11 11:09:18	2026-09-11 01:00:08	USED	KEEP — primary key
SETTLEMENT.flx.ShiftLine.PK_StaffingStaging	1	CLUSTERED	Y	Y		0	37	0	688	2026-08-19 00:28:12	never	USED	KEEP — primary key
SETTLEMENT.flx.TicketDaily.PK_ContractEntry	1	CLUSTERED	Y	Y		0	13	0	683	2026-08-19 00:25:25	never	USED	KEEP — primary key
SETTLEMENT.flx.MeterStaging.PK_CatalogResult	1	CLUSTERED	Y	Y		0	8	0	395	2026-08-18 16:05:12	never	USED	KEEP — primary key
SETTLEMENT.flx.StaffingLine.PK_PolicyHistory	1	CLUSTERED	Y	Y		46913	98197	0	87653	2026-09-11 14:46:06	2026-09-11 01:00:08	USED	KEEP — primary key
SETTLEMENT.flx.ForecastQueue.PK_BillingEntry	1	CLUSTERED	Y	Y		88	1186	0	336	2026-09-10 15:57:29	never	USED	KEEP — primary key
SETTLEMENT.flx.QuotaResult.PK_InvoiceArchive	1	CLUSTERED	Y	Y		0	10	0	32954	2026-08-18 23:10:52	never	USED	KEEP — primary key
SETTLEMENT.flx.CustomerSummary.PK_PricingLine	1	CLUSTERED	Y	Y		2	16517	0	3210	2026-09-11 14:46:06	2026-09-11 01:00:08	USED	KEEP — primary key
SETTLEMENT.flx.RouteAudit.PK_ContractStatus	1	CLUSTERED	Y	Y		8214	2767	302	348	2026-08-26 11:21:41	2026-08-20 01:00:10	USED	KEEP — primary key
SETTLEMENT.flx.RouteAudit.UX_BookingEntry	2	NONCLUSTERED	Y			529	369	0	232	2026-08-26 11:21:29	2026-08-20 01:00:10	USED	keep — in use
SETTLEMENT.flx.MeterSummary.PK_PolicyResult	1	CLUSTERED	Y	Y		293	5413	0	603	2026-08-26 11:21:41	never	USED	KEEP — primary key
SETTLEMENT.flx.ContractDetail.PK_CampaignStaging	1	CLUSTERED	Y	Y		0	7	0	5	2026-05-06 08:25:05	never	USED	KEEP — primary key
SETTLEMENT.flx.WarehouseDaily.PK_QuotaLog	1	CLUSTERED	Y	Y		0	4	0	39	2026-04-14 14:05:00	never	USED	KEEP — primary key
SETTLEMENT.flx.TicketStaging.PK_ForecastArchive	1	CLUSTERED	Y	Y		74251	34180	2776	354	2026-09-11 11:10:26	2026-08-20 01:00:10	USED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.flx.MeterLine.PK_SettlementStaging	1	CLUSTERED	Y	Y		32409	9948	6	494	2026-09-11 16:13:37	2026-09-11 01:00:08	USED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.flx.TerritoryArchive.PK_OrdersLine	1	CLUSTERED	Y	Y		3493	185306	0	588	2026-09-11 14:46:06	2026-09-11 01:00:08	USED	KEEP — primary key
SETTLEMENT.flx.PolicyDaily.PK_RosterResult	1	CLUSTERED	Y	Y		0	9	0	27	2026-08-25 09:50:49	never	USED	KEEP — primary key
SETTLEMENT.flx.PolicyMonthly.PK_PayrollStaging	1	CLUSTERED	Y	Y		0	2	0	25	2026-05-15 14:08:22	never	USED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.flx.ForecastEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		2693	2085	0	9	2026-08-22 15:26:53	2026-04-09 01:00:05	USED	KEEP — primary key
SETTLEMENT.flx.ShiftSnapshot.PK_LedgerMonthly	1	CLUSTERED	Y	Y		0	3	0	3	2026-05-30 11:25:24	never	USED	KEEP — primary key
SETTLEMENT.flx.ShiftSnapshot.UQ_CatalogDetail	2	NONCLUSTERED	Y			66	2	0	3	2026-08-19 16:18:13	2026-05-25 08:36:16	USED	keep — in use
SETTLEMENT.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
SETTLEMENT.inv.Inventory.PK_InvoiceSummary	1	CLUSTERED	Y	Y		7677	7465	0	1369	2026-09-11 15:16:53	2026-09-12 01:00:10	USED	KEEP — primary key
SETTLEMENT.inv.SupplierStatus.PK_PolicySnapshot	1	CLUSTERED	Y	Y		1146	22522	552	219	2026-09-11 15:16:53	2026-09-12 01:00:10	USED	KEEP — primary key
SETTLEMENT.inv.SupplierStatus.UX_SalesHeader	6	NONCLUSTERED	Y			700	95	0	87	2026-09-11 13:57:01	2026-09-12 01:00:10	USED	keep — in use
SETTLEMENT.inv.ShipmentDetail.PK_WarehouseSummary	1	CLUSTERED	Y	Y		1579	284	0	169	2026-09-11 16:00:55	2026-09-12 01:00:11	USED	KEEP — primary key
SETTLEMENT.org.BatchDaily.PK_QuotaStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.org.BatchDaily.UX_PricingResult	2	NONCLUSTERED	Y			0	0	0	0	never	2024-10-05 22:14:24	COLD	review carefully — unique
SETTLEMENT.po.PO.PK_SettlementDaily	1	CLUSTERED	Y	Y		52325	5275	38	392	2026-09-11 22:51:56	2026-09-12 01:00:11	USED	KEEP — primary key
SETTLEMENT.po.PO.UX_TerritoryMonthly	2	NONCLUSTERED	Y			674	2716	0	144	2026-09-11 16:04:04	2026-09-12 01:00:11	USED	keep — in use
SETTLEMENT.po.ClaimSummary.PK_BatchSnapshot	1	CLUSTERED	Y	Y		25292	2439	1470	389	2026-09-11 22:51:56	2026-09-12 01:00:11	USED	KEEP — primary key
SETTLEMENT.po.ClaimSummary.UX_PayrollResult	2	NONCLUSTERED	Y			1924	0	0	145	2026-09-11 16:13:40	2026-09-12 01:00:11	USED	keep — in use
SETTLEMENT.po.RosterLog.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SETTLEMENT.po.AssetMonthly.PK_PolicyDetail	1	CLUSTERED	Y	Y		0	15	0	350	2026-06-13 15:47:31	never	USED	KEEP — primary key
SETTLEMENT.pto.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		0	337	0	1	2026-09-10 08:25:50	never	USED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.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
SETTLEMENT.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
SETTLEMENT.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
SETTLEMENT.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
SETTLEMENT.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
SETTLEMENT.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
SETTLEMENT.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
SETTLEMENT.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
SETTLEMENT.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
SETTLEMENT.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
SETTLEMENT.ops.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-06-09 01:00:06	UNUSED	KEEP — primary key
SETTLEMENT.ops.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	0	0	1	never	never	UNUSED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.audit.CatalogQueue.PK_TicketHistory	1	CLUSTERED	Y	Y		0	2	0	0	2025-11-20 13:47:56	never	USED	KEEP — primary key
SETTLEMENT.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
SETTLEMENT.audit.TicketLog.PK_ReconcileDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	UNUSED	KEEP — primary key
SETTLEMENT.qc.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		171	268	0	0	2026-09-11 16:01:08	2026-01-11 01:00:06	USED	KEEP — primary key
SETTLEMENT.qc.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		64	691	0	98	2026-09-11 16:01:14	2026-09-12 01:00:11	USED	KEEP — primary key
SETTLEMENT.qc.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	0	0	86	never	2026-09-12 01:00:11	UNUSED	KEEP — primary key
SETTLEMENT.qc.CampaignSummary.PK_PricingStatus	1	CLUSTERED	Y	Y		454	21039	0	232	2026-09-11 22:51:35	2026-09-12 01:00:12	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	91620	0	30850	2026-09-11 21:51:15	never	USED	KEEP — primary key
SALES.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	30850	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	48702	0	28554	2026-09-11 21:50:00	2026-09-12 01:00:13	USED	KEEP — primary key
SALES.dbo.SupplierDaily.PK_LedgerAudit	1	CLUSTERED	Y	Y		0	10657678	0	0	2026-09-12 01:05:34	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	2217	0	0	2026-09-11 07:08:02	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		727536	88812	0	0	2026-09-12 01:02:35	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		31229	4812	0	0	2026-09-11 19:52:34	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			2719830	49975	115083	36338	2026-09-11 21:50:02	2026-09-12 01:00:15	USED	KEEP — table storage
SALES.dbo.Dashboard.IX_ContractDaily	25	NONCLUSTERED				20743	0	0	36338	2026-09-11 19:50:22	2026-09-12 01:03:18	USED	keep — in use
SALES.dbo.Dashboard.IX_BatchMonthly	23	NONCLUSTERED				2	165	0	36338	2026-09-08 17:11:20	2026-09-12 01:03:23	USED	keep — in use
SALES.dbo.Dashboard.IX_ShipmentMonthly	18	NONCLUSTERED				117183	125	0	36338	2026-09-11 19:50:06	2026-09-12 01:03:23	USED	keep — in use
SALES.dbo.Dashboard.IX_SupplierDaily	22	NONCLUSTERED				7	0	0	36338	2026-09-04 08:17:29	2026-09-12 01:03:27	USED	keep — in use
SALES.dbo.Dashboard.IX_BookingArchive	24	NONCLUSTERED				4	0	0	36338	2026-05-20 08:52:42	2026-09-12 01:03:35	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	2254	0	0	2026-09-11 07:08:02	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	29791	0	0	2026-09-11 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	29769	0	0	2026-09-11 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	665527	0	0	2026-09-12 01:02:35	2025-06-19 13:05:21	USED	KEEP — primary key
SALES.dbo.RouteResult.IX_BillingDetail	2	NONCLUSTERED	Y			633487	0	0	0	2026-09-12 01:02:35	2025-06-19 13:05:22	USED	keep — in use
SALES.dbo.RouteResult.PK_MeterHeader	1	CLUSTERED	Y	Y		0	0	633487	0	2026-09-12 01:02:35	2025-06-19 13:05:22	USED	KEEP — primary key
SALES.dbo.SettlementDetail.IX_RosterResult	2	NONCLUSTERED				0	308	0	0	2026-09-11 06:10:00	2025-06-19 13:05:21	USED	keep — in use
SALES.dbo.SettlementDetail.IX_PayrollResult	3	NONCLUSTERED				31410	0	0	0	2026-09-11 19:52:34	2025-06-19 13:05:21	USED	keep — in use
SALES.dbo.SettlementDetail.IX_StaffingLog	4	NONCLUSTERED				0	616	0	616	2026-09-11 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	616	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	643	140	924	2026-09-11 06:10:00	2025-06-19 13:05:21	USED	KEEP — primary key
SALES.dbo.InvoiceEntry.UX_ForecastSummary	6	NONCLUSTERED	Y			140	308	0	616	2026-09-11 06:10:00	2026-09-11 06:10:00	USED	keep — in use
SALES.dbo.ForecastQueue.PK_ShipmentHistory	1	CLUSTERED	Y	Y		0	0	0	616	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		1329617	695955	0	664716	2026-09-12 01:02:35	2026-09-12 01:03:43	USED	KEEP — primary key
SALES.dbo.ReconcileStaging.IX_ShipmentStatus	2	NONCLUSTERED	Y			664716	0	0	0	2026-09-12 01:02:35	never	USED	keep — in use
SALES.dbo.ReconcileStaging.PK_ContractStatus	1	CLUSTERED	Y	Y		0	664716	0	0	2026-09-12 01:02:35	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	664716	0	0	2026-09-12 01:02:35	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	88810	0	0	2026-09-12 01:02:33	never	USED	KEEP — primary key
SALES.dbo.PolicyLog.IX_OrdersDaily	2	NONCLUSTERED	Y			664716	0	0	31229	2026-09-12 01:02:35	2026-09-12 01:03:47	USED	keep — in use
SALES.dbo.PolicyLog.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	0	664716	31229	2026-09-12 01:02:35	2026-09-12 01:03:47	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		2658864	88810	0	0	2026-09-12 01:02:35	2025-06-19 13:05:24	USED	KEEP — primary key
SALES.dbo.WarehouseHistory.IX_PayrollDaily	2	NONCLUSTERED	Y			1329432	0	0	0	2026-09-12 01:02:35	never	USED	keep — in use
SALES.dbo.WarehouseHistory.PK_PricingEntry	1	CLUSTERED	Y	Y		0	88810	0	0	2026-09-12 01:02:33	never	USED	KEEP — primary key
SALES.dbo.PayrollStatus.IX_ContractQueue	2	NONCLUSTERED	Y			664716	0	0	0	2026-09-12 01:02:35	never	USED	keep — in use
SALES.dbo.PayrollStatus.PK_SalesResult	1	CLUSTERED	Y	Y		0	753526	0	0	2026-09-12 01:02:35	never	USED	KEEP — primary key
SALES.dbo.BillingDetail.IX_CampaignLine	2	NONCLUSTERED	Y			664716	10	0	31410	2026-09-12 01:02:35	2026-09-12 01:03:52	USED	keep — in use
SALES.dbo.BillingDetail.PK_ReconcileHeader	1	CLUSTERED	Y	Y		0	0	664716	31410	2026-09-12 01:02:35	2026-09-12 01:03:51	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	59236	0	29618	2026-09-11 21:50:02	2026-09-12 01:03:52	USED	KEEP — primary key
SALES.dbo.ShiftHeader.PK_ReconcileHeader	1	CLUSTERED	Y	Y		6050575	0	0	0	2026-09-12 01:05:32	2025-06-19 13:05:25	USED	KEEP — primary key
SALES.dbo.AssetQueue.IX_PricingLog	2	NONCLUSTERED	Y			16203	0	0	0	2026-09-11 07:08:02	2025-06-19 13:05:25	USED	keep — in use
SALES.dbo.AssetQueue.PK_PricingMonthly	1	CLUSTERED	Y	Y		2501	3005624	16203	0	2026-09-12 01:05:32	2025-06-19 13:05:25	USED	KEEP — primary key
SALES.dbo.WarehouseAudit.IX_WarehouseEntry	2	NONCLUSTERED	Y			2255	0	0	246	2026-09-11 07:08:02	2026-09-12 01:03:52	USED	keep — in use
SALES.dbo.WarehouseAudit.PK_ReconcileAudit	1	CLUSTERED	Y	Y		246	3021827	2255	246	2026-09-12 01:05:32	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		2265	4514	0	4522	2026-09-11 17:45:42	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	6953	0	0	2026-09-11 07:08:02	2025-06-19 13:05:30	USED	keep — in use
SALES.dbo.ReconcileDaily.PK_RosterResult	1	CLUSTERED	Y	Y		80	0	7151	0	2026-09-11 07:08:02	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		2217	0	0	0	2026-09-11 07:08:02	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	88810	0	0	2026-09-12 01:02:33	never	USED	keep — in use
SALES.dbo.OrdersDetail.PK_LedgerResult	1	CLUSTERED	Y	Y		924449	404983	0	0	2026-09-12 01:02:35	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		2467	2467	0	2467	2026-09-11 07:08:02	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		2406	0	0	0	2026-09-11 07:08:02	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		1329432	88810	0	0	2026-09-12 01:02:35	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		4848327	3106911	2	275767	2026-09-11 20:18:46	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		2149781	419	0	275794	2026-09-11 19:58:11	2026-09-12 01:04:01	USED	KEEP — primary key
SALES.kar.RosterSummary.IX_PricingDetail	2	NONCLUSTERED				0	0	0	275780	never	2026-09-12 01:04:07	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	275794	2026-08-28 16:11:07	2026-09-12 01:04:02	USED	KEEP — primary key
SALES.kar.SupplierArchive.IX_SettlementLine	9	NONCLUSTERED				1664829	25	0	275793	2026-09-11 20:18:46	2026-09-12 01:04:11	USED	keep — in use
SALES.kar.SupplierArchive.PK_QuotaSnapshot	1	CLUSTERED	Y	Y		314360	4665349	1664854	275794	2026-09-11 20:18:46	2026-09-12 01:04:11	USED	KEEP — primary key
SALES.kar.ClaimResult.IX_ContractHistory	9	NONCLUSTERED				307906	0	0	275793	2026-09-11 19:58:11	2026-09-12 01:04:15	USED	keep — in use
SALES.kar.ClaimResult.IX_QuotaSnapshot	8	NONCLUSTERED				493058	7779	0	275793	2026-09-11 19:58:11	2026-09-12 01:04:15	USED	keep — in use
SALES.kar.ClaimResult.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	959260	572873	275794	2026-09-11 19:58:11	2026-09-12 01:04:15	USED	KEEP — primary key
SALES.kar.RosterDaily.IX_ClaimSummary	12	NONCLUSTERED				46794	8903	0	275794	2026-09-11 16:48:50	2026-09-12 01:04:24	USED	keep — in use
SALES.kar.RosterDaily.IX_RouteDetail	16	NONCLUSTERED			Y	2639	5945	0	275793	2026-09-11 13:37:57	2026-09-12 01:04:24	USED	keep — in use
SALES.kar.RosterDaily.IX_CampaignStatus	19	NONCLUSTERED			Y	151	0	0	13	2026-09-11 08:11:51	2026-09-12 01:04:24	USED	keep — in use
SALES.kar.RosterDaily.PK_BillingAudit	1	CLUSTERED	Y	Y		0	45	8742	275794	2026-09-11 13:37:57	2026-09-12 01:04:17	USED	KEEP — primary key
SALES.kar.LedgerHeader.PK_TerritoryResult	1	CLUSTERED	Y	Y		6061	1851	0	646	2026-09-11 14:05:35	2026-09-10 01:08:15	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		3080274	490350	0	2116255	2026-09-11 20:18:46	2025-03-13 13:09:59	USED	KEEP — primary key
SALES.kar.SalesLine.UX_OrdersStatus	4	NONCLUSTERED	Y			1346004	2930708	0	0	2026-09-11 20:18:46	2025-04-11 12:42:09	USED	keep — in use
SALES.kar.ClaimDetail.PK_TicketStatus	1	CLUSTERED	Y	Y		449	496	0	302	2026-09-11 12:15:19	2026-09-12 01:04:27	USED	KEEP — primary key
SALES.kar.PayrollResult.PK_WarehouseDetail	1	CLUSTERED	Y	Y		2676	108	0	93	2026-09-11 16:35:07	2025-10-03 01:00:48	USED	KEEP — primary key
SALES.kar.AssetHeader.PK_BillingSummary	1	CLUSTERED	Y	Y		1841	1027940	0	2880	2026-09-11 20:18:46	never	USED	KEEP — primary key
SALES.kar.SettlementLog.PK_MeterDaily	1	CLUSTERED	Y	Y		2074416	0	0	848510	2026-09-11 19:56:42	2026-09-12 01:04:59	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