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

Index reportsSQL Server 13ACME-203-0-113-170 ACME-198-51-100-45 ACME-192-0-2-15-MSSQL25-1433 ACME-198-51-100-66 ACME-192-0-2-136-MSSQLLAB-1433 ACME-198-51-100-210 ACME-198-51-100-60ACME-192-0-2-243ACME-203-0-113-99 ACME-203-0-113-69 ACME-192-0-2-97 ACME-192-0-2-242 ACME-203-0-113-155Oracle 3ACME-192-0-2-136-ORALAB-1521 ACME-192-0-2-120 ACME-198-51-100-125PostgreSQL 2ACME-192-0-2-15-PG-5433 ACME-192-0-2-136-PGLAB-5432

Host: 192.0.2.243

Collected: 2026-10-19T18:03:03Z

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	994	every index on a user table
used	451	had a seek, scan or lookup
unused	72	written but never read
cold	471	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	63	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	61	16	review the drop candidates above
host-315	125	21	2	review the drop candidates above
CLAIM_Prod	58	58	0	no action — cold indexes here are constraints or clustered
CONTRACT	58	57	0	no action — cold indexes here are constraints or clustered
host-347	167	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 (63)

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

Fragmented (1)

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

Index	Part	Type	Frag	Pages	Size MB	Stats updated	Action
SALES.kar.ContractStaging.PK_CustomerSummary	1/1	CLUSTERED	46.1%	1,450	11.3	2026-10-19 16:22:42	REORGANIZE

All indexes (994)

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.Account.PK_SettlementResult	1	CLUSTERED	Y	Y		2145763	1150	14733064	1181	2026-10-19 20:23:29	2026-10-20 01:00:01	USED	KEEP — primary key
APP.app.Account.UX_PayrollAudit	4	NONCLUSTERED	Y			14734162	568	0	572	2026-10-19 20:23:29	2026-10-20 01:00:01	USED	keep — in use
APP.app.ReconcileDaily.PK_LedgerResult	1	CLUSTERED	Y	Y		11255768	17	0	14566	2026-10-19 20:23:29	2026-09-18 01:00:02	USED	KEEP — primary key
APP.app.PolicyStatus.PK_RouteArchive	1	CLUSTERED	Y	Y		1183	12	0	8	2026-10-03 08:31:13	2026-10-02 01:00:01	USED	KEEP — primary key
APP.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	1	0	1163	2025-12-15 10:27:19	never	USED	KEEP — primary key
APP.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	2	0	14566	2025-12-15 10:49:01	never	USED	KEEP — primary key
APP.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		3085597	1530263	0	3	2026-10-19 20:23:29	2026-01-11 01:00:01	USED	KEEP — primary key
APP.app.CampaignAudit.PK_BillingMonthly	1	CLUSTERED	Y	Y		2156	12	0	261	2026-10-03 08:31:20	2026-05-12 01:00:01	USED	KEEP — primary key
APP.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		2127	3084659	0	81	2026-10-19 20:23:29	2026-10-02 01:00:01	USED	KEEP — primary key
APP.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	1	0	69	2025-12-15 08:50:36	never	USED	KEEP — primary key
APP.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		458	1032	0	58	2026-10-01 07:53:42	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		1530238	427	0	49	2026-10-19 20:23:29	2026-03-04 01:00:01	USED	KEEP — primary key
APP.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		1555480	54	0	52	2026-10-19 20:23:29	2026-02-27 01:00:01	USED	KEEP — primary key
APP.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	49	never	never	UNUSED	KEEP — primary key
APP.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	755	0	0	2026-09-17 10:00:13	never	USED	KEEP — primary key
APP.app.Notification.PK_SupplierArchive	1	CLUSTERED	Y	Y		0	1	0	0	2026-02-12 09:49:30	never	USED	KEEP — primary key
APP.app.Permission.PK_ClaimHeader	1	CLUSTERED	Y	Y		1555133	1195	0	32	2026-10-19 20:23:29	2026-01-11 01:00:01	USED	KEEP — primary key
APP.app.Token.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	25	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.Users.PK_BatchSnapshot	1	CLUSTERED	Y	Y		0	5	0	2	2026-02-26 14:45:40	never	USED	KEEP — primary key
PAYROLL.dbo.OrdersDaily.PK_ShiftResult	1	CLUSTERED	Y	Y		0	2	0	4	2026-02-26 15:52:45	never	USED	KEEP — primary key
report.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		0	1449	0	1437	2026-10-06 10:55:35	never	USED	KEEP — primary key
report.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	6	0	1437	2026-10-06 10:55:35	never	USED	KEEP — primary key
report.emp.ForecastStatus.PK_CampaignDetail	1	CLUSTERED	Y	Y		0	2876	0	1434	2026-10-06 10:55:34	2026-07-10 16:50:02	USED	KEEP — primary key
RECONCILE.inc.Incident.PK_CatalogDaily	1	CLUSTERED	Y	Y		1039	461	2	47	2026-10-03 08:31:13	2026-10-01 01:00:02	USED	KEEP — primary key
RECONCILE.inc.Incident.UX_PolicyDetail	2	NONCLUSTERED	Y			7	0	0	35	2026-09-30 09:27:48	2026-10-01 01:00:02	USED	keep — in use
RECONCILE.inc.CatalogResult.PK_SettlementAudit	1	CLUSTERED	Y	Y		0	94	0	32	2026-09-30 09:52:48	never	USED	KEEP — primary key
RECONCILE.inc.CatalogResult.UX_WarehouseStatus	2	NONCLUSTERED	Y			0	0	0	31	never	2026-10-01 01:00:02	UNUSED	review carefully — unique
RECONCILE.inc.CampaignDaily.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	5	0	30	2026-09-30 09:36:03	never	USED	KEEP — primary key
RECONCILE.inc.MeterResult.PK_TicketSummary	1	CLUSTERED	Y	Y		0	6	0	3	2026-09-30 09:36:03	never	USED	KEEP — primary key
RECONCILE.inc.BookingDetail.PK_BookingHeader	1	CLUSTERED	Y	Y		0	582	0	31	2026-10-03 08:31:13	never	USED	KEEP — primary key
RECONCILE.inc.BookingDetail.UX_SettlementLog	2	NONCLUSTERED	Y			86	127	0	31	2026-09-30 09:52:48	2026-10-01 01:00:02	USED	keep — in use
RECONCILE.inc.AssetSummary.PK_BillingHistory	1	CLUSTERED	Y	Y		0	5	0	30	2026-09-30 09:36:03	never	USED	KEEP — primary key
RECONCILE.inc.OrdersHeader.PK_SupplierDetail	1	CLUSTERED	Y	Y		0	9	0	32	2026-09-30 09:35:30	never	USED	KEEP — primary key
RECONCILE.inc.OrdersHeader.UX_TerritoryLine	2	NONCLUSTERED	Y			87	0	0	31	2026-09-30 09:52:48	2026-10-01 01:00:02	USED	keep — in use
RECONCILE.inc.TicketLog.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	11	0	32	2026-09-30 09:36:03	never	USED	KEEP — primary key
RECONCILE.inc.StaffingArchive.PK_RouteArchive	1	CLUSTERED	Y	Y		0	5	0	30	2026-09-30 09:36:03	never	USED	KEEP — primary key
RECONCILE.inc.ContractHeader.PK_RosterHistory	1	CLUSTERED	Y	Y		0	5	0	30	2026-09-30 09:36:03	never	USED	KEEP — primary key
RECONCILE.inc.QuotaEntry.PK_ReconcileArchive	1	CLUSTERED	Y	Y		0	12	0	42	2026-09-30 09:36:03	never	USED	KEEP — primary key
RECONCILE.inc.StaffingQueue.PK_LedgerHistory	1	CLUSTERED	Y	Y		0	5	0	30	2026-09-30 09:35:30	never	USED	KEEP — primary key
RECONCILE.inc.StaffingQueue.UX_PayrollEntry	2	NONCLUSTERED	Y			85	0	0	29	2026-09-30 09:52:48	2026-10-01 01:00:02	USED	keep — in use
RECONCILE.inc.ForecastHistory.PK_LedgerLine	1	CLUSTERED	Y	Y		0	3	0	28	2026-09-30 09:36:03	never	USED	KEEP — primary key
RECONCILE.inc.ShipmentArchive.PK_PolicySnapshot	1	CLUSTERED	Y	Y		82	678	0	0	2026-10-03 08:30:06	2025-10-14 16:04:26	USED	KEEP — primary key
RECONCILE.inc.CampaignDaily.PK_ShiftStaging	1	CLUSTERED	Y	Y		701	2004	0	3	2026-10-03 08:31:13	2026-01-11 01:00:02	USED	KEEP — primary key
RECONCILE.inc.RosterArchive.PK_ContractQueue	1	CLUSTERED	Y	Y		76	689	0	1	2026-10-03 08:30:06	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	827	0	5	2026-10-03 08:30:06	2026-10-02 01:00:02	USED	KEEP — primary key
host-315.app.Account.PK_SettlementResult	1	CLUSTERED	Y	Y		213073	7192246	834515	63	2026-10-19 22:20:18	2026-10-18 01:00:03	USED	KEEP — primary key
host-315.app.Account.UX_PayrollAudit	2	NONCLUSTERED	Y			116	209972	0	63	2026-10-19 17:58:14	2026-10-18 01:00:03	USED	keep — in use
host-315.app.Account.UX_BillingStatus	3	NONCLUSTERED	Y			1048703	1	0	63	2026-10-19 21:38:48	2026-10-18 01:00:03	USED	keep — in use
host-315.app.SettlementEntry.PK_ContractLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		0	1	0	0	2025-12-16 13:09:25	2025-12-16 13:09:25	USED	KEEP — primary key
host-315.app.BillingAudit.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		1021255	535	0	516	2026-10-19 22:20:18	2026-10-18 01:00:03	USED	KEEP — primary key
host-315.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		509055	512909	0	86	2026-10-19 22:20:18	2026-09-24 01:00:06	USED	KEEP — primary key
host-315.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	86	never	2026-10-18 01:00:03	UNUSED	review carefully — unique
host-315.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		1861741	2	0	1326	2026-10-19 22:20:18	2026-10-15 01:00:02	USED	KEEP — primary key
host-315.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	16	0	0	2026-04-17 20:36:48	never	USED	KEEP — primary key
host-315.app.InvoiceLine.UX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host-315.app.Permission.PK_ClaimHeader	1	CLUSTERED	Y	Y		118432	921093	0	7	2026-10-19 22:20:18	2026-08-27 01:00:03	USED	KEEP — primary key
host-315.app.Permission.UX_RouteQueue	2	NONCLUSTERED	Y			3	9	0	5	2026-10-13 08:46:03	2026-08-27 01:00:03	USED	keep — in use
host-315.app.Token.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.bm.PricingQueue.PK_InvoiceArchive	1	CLUSTERED	Y	Y		3061131	121990	4	47004	2026-10-19 22:20:27	2026-10-20 01:00:03	USED	KEEP — primary key
host-315.bm.PricingQueue.UX_InvoiceLog	2	NONCLUSTERED	Y			211200	46885	0	11080	2026-10-19 18:51:11	2026-10-20 01:00:03	USED	keep — in use
host-315.bm.RosterDetail.PK_QuotaArchive	1	CLUSTERED	Y	Y		413359	4365071	0	36385	2026-10-19 22:20:27	2026-10-20 01:00:03	USED	KEEP — primary key
host-315.bm.MeterEntry.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	3	0	11082	2026-09-16 12:38:30	never	USED	KEEP — primary key
host-315.bm.MeterHistory.PK_BillingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.bm.QuotaEntry.PK_InvoiceAudit	1	CLUSTERED	Y	Y		0	8	0	21701	2026-09-16 12:38:30	never	USED	KEEP — primary key
host-315.bm.OrdersResult.PK_SupplierStaging	1	CLUSTERED	Y	Y		1535958	2998321	724390	199938	2026-10-19 22:20:27	2026-10-20 01:00:08	USED	KEEP — primary key
host-315.bm.OrdersResult.UX_PolicyMonthly	2	NONCLUSTERED	Y			1164784	29066	0	31726	2026-10-19 22:20:27	2026-10-20 01:00:08	USED	keep — in use
host-315.bm.TicketAudit.PK_WarehouseQueue	1	CLUSTERED	Y	Y		23249	100517	0	10460	2026-10-19 17:38:14	2026-10-20 01:00:08	USED	KEEP — primary key
host-315.bm.TicketLog.PK_SalesStaging	1	CLUSTERED	Y	Y		46519	100521	0	33711	2026-10-19 17:38:14	2026-10-20 01:00:08	USED	KEEP — primary key
host-315.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		1082410	0	0	0	2026-10-19 22:20:18	2025-08-01 01:00:56	USED	KEEP — primary key
host-315.dbo.BatchResult.PK_PolicySummary	1	CLUSTERED	Y	Y		1	574619	0	281722	2026-10-19 17:49:03	2026-10-20 01:00:09	USED	KEEP — primary key
host-315.dbo.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		4902251	943157	87	84	2026-10-19 22:20:27	2026-10-17 01:00:05	USED	KEEP — primary key
host-315.dbo.CatalogQueue.UX_ReconcileStaging	2	NONCLUSTERED	Y			17594	954520	0	84	2026-10-19 22:20:18	2026-10-17 01:00:05	USED	keep — in use
host-315.dbo.Product.PK_ReconcileStatus	1	CLUSTERED	Y	Y		4764293	1336930	7	2184	2026-10-19 22:20:27	2026-10-20 01:00:09	USED	KEEP — primary key
host-315.dbo.Product.UX_OrdersEntry	2	NONCLUSTERED	Y			36994	8493	0	2183	2026-10-19 16:01:50	2026-10-20 01:00:09	USED	keep — in use
host-315.dbo.PricingMonthly.PK_LedgerDetail	1	CLUSTERED	Y	Y		0	0	0	2049	never	never	UNUSED	KEEP — primary key
host-315.flx.SettlementResult.PK_ContractResult	1	CLUSTERED	Y	Y		190203	215761	0	21	2026-10-19 21:38:48	2026-10-09 01:00:06	USED	KEEP — primary key
host-315.flx.InvoiceAudit.PK_CatalogAudit	1	CLUSTERED	Y	Y		652	15780	0	68	2026-10-19 21:38:17	never	USED	KEEP — primary key
host-315.flx.ClaimHeader.PK_SalesStaging	1	CLUSTERED	Y	Y		7	61	0	16	2026-06-19 14:58:39	2026-06-19 13:09:33	USED	KEEP — primary key
host-315.flx.ShiftStaging.PK_PricingHeader	1	CLUSTERED	Y	Y		22220	12925	0	11110	2026-10-19 16:30:13	2026-10-20 01:00:10	USED	KEEP — primary key
host-315.flx.InvoiceLine.PK_SettlementMonthly	1	CLUSTERED	Y	Y		1196	8678	44523	1482	2026-10-20 00:59:31	2026-10-18 01:00:06	USED	KEEP — primary key
host-315.flx.InvoiceLine.UQ_LedgerResult	2	NONCLUSTERED	Y			55993	19	0	1058	2026-10-19 17:06:44	2026-10-18 01:00:06	USED	keep — in use
host-315.flx.AssetLog.PK_ContractLine	1	CLUSTERED	Y	Y		0	37447	0	1164	2026-10-20 00:59:31	2026-10-18 01:00:06	USED	KEEP — primary key
host-315.flx.CustomerLine.IX_SalesEntry	2	NONCLUSTERED				3821	1400	0	1095	2026-10-19 15:45:19	2026-10-20 01:00:10	USED	keep — in use
host-315.flx.CustomerLine.PK_ClaimAudit	1	CLUSTERED	Y	Y		117689	20237	96	1100	2026-10-19 17:06:44	2026-10-14 01:00:05	USED	KEEP — primary key
host-315.flx.CustomerLine.IX_InvoiceSummary	14	NONCLUSTERED	Y			7	6527	0	927	2026-10-19 15:10:01	2026-10-20 01:00:10	USED	keep — in use
host-315.flx.BatchSummary.PK_MeterResult	1	CLUSTERED	Y	Y		0	2	0	10	2026-09-28 10:52:56	never	USED	KEEP — primary key
host-315.flx.OrdersMonthly.IX_RosterMonthly	6	NONCLUSTERED				52696	0	0	22937	2026-10-19 20:06:13	2026-10-20 01:00:10	USED	keep — in use
host-315.flx.OrdersMonthly.PK_PolicySnapshot	1	CLUSTERED	Y	Y		26478	121096	52682	22951	2026-10-19 20:06:13	2026-10-20 01:00:10	USED	KEEP — primary key
host-315.flx.SalesLog.PK_ContractAudit	1	CLUSTERED	Y	Y		0	37574	0	17023	2026-10-19 20:06:13	never	USED	KEEP — primary key
host-315.flx.PolicyDetail.PK_AssetSnapshot	1	CLUSTERED	Y	Y		0	6842	0	3238	2026-10-19 16:30:13	never	USED	KEEP — primary key
host-315.flx.RosterStatus.PK_TerritoryHistory	1	CLUSTERED	Y	Y		51539	60831	0	20656	2026-10-19 20:06:11	2026-10-20 01:00:10	USED	KEEP — primary key
host-315.flx.ClaimHeader.IX_WarehouseMonthly	15	NONCLUSTERED				1301086	7	0	2198	2026-10-19 20:06:12	2026-10-20 01:00:10	USED	keep — in use
host-315.flx.ClaimHeader.PK_BatchAudit	1	CLUSTERED	Y	Y		839864	1202600	1191836	2243	2026-10-19 21:38:48	2026-10-20 01:00:10	USED	KEEP — primary key
host-315.flx.ClaimHeader.UX_SupplierDetail	2	NONCLUSTERED	Y			1294	52	0	2239	2026-10-19 14:35:00	2026-10-20 01:00:11	USED	keep — in use
host-315.flx.ShiftArchive.PK_PricingEntry	1	CLUSTERED	Y	Y		0	1963	0	218	2026-10-19 15:31:42	never	USED	KEEP — primary key
host-315.flx.QuotaStatus.PK_SalesResult	1	CLUSTERED	Y	Y		69	4027	0	48	2026-10-19 16:19:01	2026-10-20 01:00:12	USED	KEEP — primary key
host-315.flx.SupplierDetail.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		0	9	0	48	2026-08-28 14:54:57	never	USED	KEEP — primary key
host-315.flx.ContractQueue.PK_QuotaEntry	1	CLUSTERED	Y	Y		0	6	0	2322	2026-09-14 09:35:14	never	USED	KEEP — primary key
host-315.flx.PricingHistory.IX_ShiftDaily	2	NONCLUSTERED				693296	28	0	6152	2026-10-19 21:38:48	2026-10-20 01:00:12	USED	keep — in use
host-315.flx.PricingHistory.PK_ReconcileHistory	1	CLUSTERED	Y	Y		2259	52134	530619	6152	2026-10-19 21:38:48	2026-10-20 01:00:12	USED	KEEP — primary key
host-315.flx.MeterArchive.IX_BatchHeader	2	NONCLUSTERED				727426	25	0	13779	2026-10-19 21:38:48	2026-10-20 01:00:12	USED	keep — in use
host-315.flx.MeterArchive.PK_BatchDaily	1	CLUSTERED	Y	Y		6082	16673	564867	13808	2026-10-19 21:38:48	2026-10-20 01:00:12	USED	KEEP — primary key
host-315.flx.InvoiceLine.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	8	0	9681	2026-08-19 19:33:14	never	USED	KEEP — primary key
host-315.flx.BookingLog.PK_CatalogLine	1	CLUSTERED	Y	Y		0	5	0	4294	2026-04-11 14:15:45	never	USED	KEEP — primary key
host-315.flx.PayrollSnapshot.PK_LedgerResult	1	CLUSTERED	Y	Y		6889949	54745	0	3203	2026-10-19 21:38:48	2026-10-20 01:00:11	USED	KEEP — primary key
host-315.flx.SettlementLine.PK_QuotaHistory	1	CLUSTERED	Y	Y		96456	7045020	0	6572	2026-10-19 21:38:48	2026-10-20 01:00:11	USED	KEEP — primary key
host-315.flx.SettlementLine.PK_SettlementEntry	1	CLUSTERED	Y	Y		0	211365	0	20808	2026-10-19 21:38:48	never	USED	KEEP — primary key
host-315.flx.ShiftLine.PK_StaffingStaging	1	CLUSTERED	Y	Y		0	7	0	15788	2026-08-19 19:36:53	never	USED	KEEP — primary key
host-315.flx.TicketDaily.PK_ContractEntry	1	CLUSTERED	Y	Y		0	0	0	8111	never	never	UNUSED	KEEP — primary key
host-315.flx.MeterStaging.PK_CatalogResult	1	CLUSTERED	Y	Y		0	0	0	2448	never	never	UNUSED	KEEP — primary key
host-315.flx.StaffingLine.PK_PolicyHistory	1	CLUSTERED	Y	Y		90621	538332	0	101557	2026-10-19 21:38:48	2026-10-20 01:00:11	USED	KEEP — primary key
host-315.flx.ForecastQueue.PK_BillingEntry	1	CLUSTERED	Y	Y		32	19645	0	524	2026-10-19 20:17:14	never	USED	KEEP — primary key
host-315.flx.QuotaResult.PK_InvoiceArchive	1	CLUSTERED	Y	Y		0	0	0	1588	never	never	UNUSED	KEEP — primary key
host-315.flx.CustomerSummary.PK_PricingLine	1	CLUSTERED	Y	Y		0	249014	0	82416	2026-10-19 21:38:48	never	USED	KEEP — primary key
host-315.flx.RouteAudit.PK_ContractStatus	1	CLUSTERED	Y	Y		12555	3986	2975	1234	2026-10-19 15:45:19	2026-10-14 01:00:06	USED	KEEP — primary key
host-315.flx.RouteAudit.UX_BookingEntry	2	NONCLUSTERED	Y			3251	7915	0	263	2026-10-19 15:45:19	2026-10-14 01:00:06	USED	keep — in use
host-315.flx.MeterSummary.PK_PolicyResult	1	CLUSTERED	Y	Y		484	12577	0	2642	2026-10-19 14:32:36	never	USED	KEEP — primary key
host-315.flx.ContractDetail.PK_CampaignStaging	1	CLUSTERED	Y	Y		0	0	0	1	never	never	UNUSED	KEEP — primary key
host-315.flx.WarehouseDaily.PK_QuotaLog	1	CLUSTERED	Y	Y		0	0	0	5	never	never	UNUSED	KEEP — primary key
host-315.flx.TicketStaging.PK_ForecastArchive	1	CLUSTERED	Y	Y		294045	158031	2496	635	2026-10-19 21:38:48	2026-10-20 01:00:12	USED	KEEP — primary key
host-315.flx.TicketStaging.UX_ShipmentStaging	2	NONCLUSTERED	Y			2824	5610	0	635	2026-10-19 16:18:57	2026-10-20 01:00:12	USED	keep — in use
host-315.flx.MeterLine.PK_SettlementStaging	1	CLUSTERED	Y	Y		301642	173945	0	7799	2026-10-19 21:38:48	2026-10-20 01:00:12	USED	KEEP — primary key
host-315.flx.MeterLine.UX_RouteStatus	2	NONCLUSTERED	Y			2303	125	0	7798	2026-10-19 16:19:53	2026-10-20 01:00:12	USED	keep — in use
host-315.flx.TerritoryArchive.PK_OrdersLine	1	CLUSTERED	Y	Y		56300	6725180	0	2793	2026-10-19 20:06:12	2026-10-20 01:00:13	USED	KEEP — primary key
host-315.flx.PolicyDaily.PK_RosterResult	1	CLUSTERED	Y	Y		0	3	0	398	2026-08-26 20:02:40	never	USED	KEEP — primary key
host-315.flx.PolicyMonthly.PK_PayrollStaging	1	CLUSTERED	Y	Y		0	2	0	397	2026-06-17 07:37:37	never	USED	KEEP — primary key
host-315.flx.ForecastEntry.IX_AssetEntry	2	NONCLUSTERED				10	14	0	5	2026-10-17 16:09:39	2026-08-29 01:00:05	USED	keep — in use
host-315.flx.ForecastEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		2554	1599	0	5	2026-10-17 15:38:57	2026-08-29 01:00:05	USED	KEEP — primary key
host-315.flx.ShiftSnapshot.PK_LedgerMonthly	1	CLUSTERED	Y	Y		0	2	0	2	2026-09-22 11:26:49	never	USED	KEEP — primary key
host-315.flx.ShiftSnapshot.UQ_CatalogDetail	2	NONCLUSTERED	Y			1056	4	0	2	2026-10-17 14:54:54	2026-06-07 20:13:04	USED	keep — in use
host-315.inv.Inventory.PK_InvoiceSummary	1	CLUSTERED	Y	Y		999735	1223571	0	306747	2026-10-19 18:57:43	2026-10-20 01:00:13	USED	KEEP — primary key
host-315.inv.SupplierStatus.PK_PolicySnapshot	1	CLUSTERED	Y	Y		577599	2879537	641073	173606	2026-10-19 18:57:42	2026-10-20 01:00:13	USED	KEEP — primary key
host-315.inv.SupplierStatus.UX_SalesHeader	6	NONCLUSTERED	Y			701191	8494	0	69944	2026-10-19 18:01:29	2026-10-20 01:00:13	USED	keep — in use
host-315.inv.ShipmentDetail.PK_WarehouseSummary	1	CLUSTERED	Y	Y		692175	200894	0	152718	2026-10-19 18:03:34	2026-10-20 01:00:13	USED	KEEP — primary key
host-315.org.Company.PK_QuotaStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.org.Company.UX_PricingResult	2	NONCLUSTERED	Y			0	0	0	0	never	2024-10-05 22:14:24	COLD	review carefully — unique
host-315.po.PO.PK_SettlementDaily	1	CLUSTERED	Y	Y		6536287	981861	42280	98614	2026-10-19 22:20:27	2026-10-20 01:00:13	USED	KEEP — primary key
host-315.po.PO.UX_TerritoryMonthly	2	NONCLUSTERED	Y			708718	586342	0	17433	2026-10-19 20:53:09	2026-10-20 01:00:13	USED	keep — in use
host-315.po.ClaimSummary.PK_BatchSnapshot	1	CLUSTERED	Y	Y		1809743	175687	298091	71488	2026-10-19 20:53:09	2026-10-20 01:00:13	USED	KEEP — primary key
host-315.po.ClaimSummary.UX_PayrollResult	2	NONCLUSTERED	Y			389600	1	0	17324	2026-10-19 16:25:46	2026-10-20 01:00:14	USED	keep — in use
host-315.po.RosterLog.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.po.AssetMonthly.PK_PolicyDetail	1	CLUSTERED	Y	Y		0	8	0	70983	2026-09-16 13:46:16	never	USED	KEEP — primary key
host-315.pto.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		0	304	0	0	2026-10-03 12:44:55	never	USED	KEEP — primary key
host-315.pto.ContractHeader.PK_ContractEntry	1	CLUSTERED	Y	Y		650	3	0	0	2026-10-03 12:44:55	never	USED	KEEP — primary key
host-315.pto.ContractHeader.UX_SalesResult	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host-315.pto.SalesHistory.PK_TicketDetail	1	CLUSTERED	Y	Y		58	592	5	0	2026-10-03 12:44:55	never	USED	KEEP — primary key
host-315.pto.SalesHistory.UX_ContractDetail	2	NONCLUSTERED	Y			10	0	0	0	2026-06-24 17:39:46	never	USED	keep — in use
host-315.pto.ClaimResult.IX_ContractDetail	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
host-315.pto.ClaimResult.PK_SalesLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.pto.LedgerResult.IX_TerritoryResult	2	NONCLUSTERED				246	0	0	0	2026-10-03 12:40:50	never	USED	keep — in use
host-315.pto.LedgerResult.PK_TicketArchive	1	CLUSTERED	Y	Y		0	485	246	0	2026-10-03 12:44:55	never	USED	KEEP — primary key
host-315.pto.ContractEntry.IX_CustomerDaily	2	NONCLUSTERED				0	0	0	0	never	never	COLD	review, then DROP
host-315.pto.ContractEntry.PK_SettlementDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.ops.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.ops.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		0	1	0	0	2026-03-23 13:51:17	never	USED	KEEP — primary key
host-315.ops.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.audit.Shipping.PK_PolicyQueue	1	CLUSTERED	Y	Y		128	0	0	0	2026-10-03 12:40:59	never	USED	KEEP — primary key
host-315.audit.CatalogQueue.PK_TicketHistory	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.audit.CampaignLine.PK_MeterStaging	1	CLUSTERED	Y	Y		0	128	0	0	2026-10-03 12:40:59	never	USED	KEEP — primary key
host-315.audit.TicketLog.PK_ReconcileDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-315.qc.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		17311	60977	0	23	2026-10-19 22:20:26	2026-10-17 01:00:09	USED	KEEP — primary key
host-315.qc.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		15157	729564	0	57701	2026-10-19 18:51:17	2026-10-20 01:00:14	USED	KEEP — primary key
host-315.qc.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	77	0	57683	2026-10-17 09:19:08	2026-10-20 01:00:15	USED	KEEP — primary key
host-315.qc.CampaignSummary.PK_PricingStatus	1	CLUSTERED	Y	Y		554147	618219	0	100892	2026-10-19 22:20:18	2026-10-20 01:00:15	USED	KEEP — primary key
host-347.app.Account.PK_SettlementResult	1	CLUSTERED	Y	Y		33929	219041	28811	18	2026-10-19 15:55:20	2026-08-20 01:00:08	USED	KEEP — primary key
host-347.app.Account.UX_PayrollAudit	2	NONCLUSTERED	Y			13	3256	0	15	2026-10-19 15:49:36	2026-10-01 01:00:16	USED	keep — in use
host-347.app.Account.UX_BillingStatus	3	NONCLUSTERED	Y			29459	1	0	15	2026-10-19 12:53:50	2026-10-01 01:00:17	USED	keep — in use
host-347.app.SettlementEntry.PK_ContractLog	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		0	2	0	0	2026-04-14 09:36:32	2025-12-16 13:08:59	USED	KEEP — primary key
host-347.app.BillingAudit.PK_PolicyLine	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		40027	471	0	10	2026-10-19 15:55:20	2026-08-20 01:00:08	USED	KEEP — primary key
host-347.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		25876	15125	0	47	2026-10-19 15:55:20	2026-05-22 01:00:05	USED	KEEP — primary key
host-347.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			0	0	0	47	never	2026-10-11 01:00:10	UNUSED	review carefully — unique
host-347.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		53979	16	0	516	2026-10-19 15:55:20	2026-10-11 01:00:10	USED	KEEP — primary key
host-347.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		0	2	0	0	2026-10-09 08:34:48	never	USED	KEEP — primary key
host-347.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.app.InvoiceLine.UX_BillingLog	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host-347.app.Permission.PK_ClaimHeader	1	CLUSTERED	Y	Y		24972	38098	0	22	2026-10-19 15:55:20	2026-10-07 01:00:09	USED	KEEP — primary key
host-347.app.Permission.UX_RouteQueue	2	NONCLUSTERED	Y			3	55	0	15	2026-10-09 14:01:51	2026-10-07 01:00:09	USED	keep — in use
host-347.app.Token.PK_ShipmentStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.bm.PricingQueue.PK_InvoiceArchive	1	CLUSTERED	Y	Y		49709	4349	15	639	2026-10-19 15:55:20	2026-10-18 01:00:14	USED	KEEP — primary key
host-347.bm.PricingQueue.UX_InvoiceLog	2	NONCLUSTERED	Y			1597	204	0	289	2026-10-17 14:42:03	2026-10-18 01:00:14	USED	keep — in use
host-347.bm.RosterDetail.PK_QuotaArchive	1	CLUSTERED	Y	Y		1198	96683	0	383	2026-10-19 15:55:20	2026-10-18 01:00:14	USED	KEEP — primary key
host-347.bm.MeterEntry.PK_CustomerMonthly	1	CLUSTERED	Y	Y		0	2	0	279	2026-10-08 13:44:11	never	USED	KEEP — primary key
host-347.bm.MeterHistory.PK_BillingStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.bm.QuotaEntry.PK_InvoiceAudit	1	CLUSTERED	Y	Y		0	3	0	526	2026-10-12 15:22:14	never	USED	KEEP — primary key
host-347.bm.OrdersResult.PK_SupplierStaging	1	CLUSTERED	Y	Y		3963	35073	1940	771	2026-10-19 15:55:20	2026-10-18 01:00:15	USED	KEEP — primary key
host-347.bm.OrdersResult.UX_PolicyMonthly	2	NONCLUSTERED	Y			2316	14	0	271	2026-10-19 11:13:19	2026-10-18 01:00:15	USED	keep — in use
host-347.bm.TicketAudit.IX_TerritoryMonthly	8	NONCLUSTERED				5	4	0	155	2026-10-19 14:30:05	2026-10-20 01:00:17	USED	keep — in use
host-347.bm.TicketAudit.PK_WarehouseQueue	1	CLUSTERED	Y	Y		418	3822	359	308	2026-10-19 15:55:20	2026-10-20 01:00:17	USED	KEEP — primary key
host-347.bm.TicketAudit.UQ_ContractSnapshot	7	NONCLUSTERED	Y		Y	454	1	0	159	2026-10-19 15:48:30	2026-10-20 01:00:17	USED	keep — in use
host-347.bm.TicketLog.PK_SalesStaging	1	CLUSTERED	Y	Y		293	3187	0	363	2026-10-19 15:55:20	2026-10-20 01:00:17	USED	KEEP — primary key
host-347.bm.CatalogHistory.IX_WarehouseDetail	2	NONCLUSTERED				13	34	0	164	2026-10-19 15:48:30	2026-10-20 01:00:17	USED	keep — in use
host-347.bm.CatalogHistory.PK_PricingHistory	1	CLUSTERED	Y	Y		1032	184	1	204	2026-10-19 15:48:30	2026-10-20 01:00:17	USED	KEEP — primary key
host-347.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		30809	4	0	0	2026-10-19 15:55:20	2026-01-11 01:00:05	USED	KEEP — primary key
host-347.dbo.BatchResult.PK_PolicySummary	1	CLUSTERED	Y	Y		0	1545	0	696	2026-10-19 14:30:21	2026-10-20 01:00:17	USED	KEEP — primary key
host-347.dbo.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		69007	9599	0	0	2026-10-19 15:55:20	2026-01-11 01:00:05	USED	KEEP — primary key
host-347.dbo.CatalogQueue.UX_ReconcileStaging	2	NONCLUSTERED	Y			211	28396	0	0	2026-10-19 15:55:20	2026-01-11 01:00:05	USED	keep — in use
host-347.dbo.ShiftResult.IX_SalesHeader	3	NONCLUSTERED				131	10	0	415	2026-10-16 04:45:44	2026-10-17 01:00:13	USED	keep — in use
host-347.dbo.ShiftResult.PK_MeterStaging	1	CLUSTERED	Y	Y		26345	2628	267	415	2026-10-19 15:55:24	2026-10-17 01:00:13	USED	KEEP — primary key
host-347.dbo.ShiftResult.UQ_RosterArchive	2	NONCLUSTERED	Y			667	138	0	316	2026-10-17 14:18:58	2026-10-17 01:00:13	USED	keep — in use
host-347.dbo.BookingArchive.PK_StaffingDaily	1	CLUSTERED	Y	Y		0	1	328	121	2026-10-17 14:18:58	never	USED	KEEP — primary key
host-347.dbo.BookingArchive.UQ_RosterStatus	2	NONCLUSTERED	Y			437	13	0	121	2026-10-17 14:18:58	2026-10-13 01:00:10	USED	keep — in use
host-347.dbo.OrdersDetail.IX_PolicyMonthly	2	NONCLUSTERED				3	0	0	294	2026-10-08 08:27:46	2026-10-17 01:00:13	USED	keep — in use
host-347.dbo.OrdersDetail.PK_BillingStaging	1	CLUSTERED	Y	Y		0	2	0	294	2026-10-08 08:24:50	never	USED	KEEP — primary key
host-347.dbo.ForecastMonthly.PK_LedgerEntry	1	CLUSTERED	Y	Y		0	6	330	88	2026-10-17 14:18:58	never	USED	KEEP — primary key
host-347.dbo.ForecastMonthly.UQ_SupplierHeader	2	NONCLUSTERED	Y			90	332	0	88	2026-10-17 14:18:58	2026-10-02 01:00:10	USED	keep — in use
host-347.dbo.RouteLog.IX_CampaignQueue	3	NONCLUSTERED				717	97	0	572	2026-10-17 14:21:31	2026-10-17 01:00:13	USED	keep — in use
host-347.dbo.RouteLog.PK_ContractHistory	1	CLUSTERED	Y	Y		0	5857	1	572	2026-10-19 15:55:24	2026-10-17 01:00:13	USED	KEEP — primary key
host-347.dbo.RouteLog.UQ_StaffingQueue	2	NONCLUSTERED	Y			995	0	0	536	2026-10-17 14:18:58	2026-10-17 01:00:13	USED	keep — in use
host-347.dbo.PayrollStatus.IX_StaffingHeader	2	NONCLUSTERED				3	0	0	316	2026-10-08 08:27:46	2026-10-17 01:00:14	USED	keep — in use
host-347.dbo.PayrollStatus.PK_PricingQueue	1	CLUSTERED	Y	Y		0	1	0	316	2026-09-30 13:25:31	never	USED	KEEP — primary key
host-347.dbo.Product.PK_ReconcileStatus	1	CLUSTERED	Y	Y		64750	9766	15	127	2026-10-19 15:55:20	2026-10-17 01:00:14	USED	KEEP — primary key
host-347.dbo.Product.UX_QuotaHeader	9	NONCLUSTERED	Y		Y	105	0	0	85	2026-10-16 09:48:36	2026-10-17 01:00:14	USED	keep — in use
host-347.dbo.Product.UX_OrdersEntry	2	NONCLUSTERED	Y			537	324	0	125	2026-10-17 14:41:25	2026-10-17 01:00:14	USED	keep — in use
host-347.dbo.CampaignDetail.IX_BillingStatus	4	NONCLUSTERED				2	1	0	103	2026-10-09 11:38:06	2026-10-17 01:00:14	USED	keep — in use
host-347.dbo.CampaignDetail.IX_ShiftQueue	3	NONCLUSTERED				58	3	0	103	2026-10-13 14:42:58	2026-10-17 01:00:14	USED	keep — in use
host-347.dbo.CampaignDetail.PK_ClaimArchive	1	CLUSTERED	Y	Y		0	19089	37	103	2026-10-19 15:55:21	2026-10-17 01:00:14	USED	KEEP — primary key
host-347.dbo.CampaignDetail.UQ_PolicyStaging	2	NONCLUSTERED	Y			84	1	0	77	2026-10-16 09:48:36	2026-10-17 01:00:14	USED	keep — in use
host-347.dbo.CatalogHeader.PK_StaffingLog	1	CLUSTERED	Y	Y		0	1	0	97	2026-10-02 14:36:12	never	USED	KEEP — primary key
host-347.dbo.PricingMonthly.PK_LedgerDetail	1	CLUSTERED	Y	Y		0	2	0	120	2026-10-02 14:36:12	never	USED	KEEP — primary key
host-347.dbo.ContractSummary.PK_AssetStatus	1	CLUSTERED	Y	Y		2219	19	525	7	2026-10-19 08:14:51	2026-10-08 01:00:12	USED	KEEP — primary key
host-347.dbo.ContractSummary.UQ_BillingStatus	2	NONCLUSTERED	Y			54	525	0	7	2026-10-16 09:34:21	2026-10-08 01:00:12	USED	keep — in use
host-347.dbo.Unit.PK_ForecastLine	1	CLUSTERED	Y	Y		0	96	267	123	2026-10-17 14:18:58	never	USED	KEEP — primary key
host-347.dbo.Unit.UQ_ClaimHeader	2	NONCLUSTERED	Y			170	269	0	123	2026-10-16 09:34:16	2026-10-15 01:00:14	USED	keep — in use
host-347.flx.SettlementResult.PK_ContractResult	1	CLUSTERED	Y	Y		36264	11815	0	42	2026-10-19 12:53:50	2026-08-20 01:00:09	USED	KEEP — primary key
host-347.flx.InvoiceAudit.PK_CatalogAudit	1	CLUSTERED	Y	Y		590	889	0	13	2026-10-17 12:58:08	never	USED	KEEP — primary key
host-347.flx.ShiftStaging.PK_PricingHeader	1	CLUSTERED	Y	Y		548	3134	0	258	2026-10-17 16:06:09	2026-09-24 01:00:20	USED	KEEP — primary key
host-347.flx.InvoiceLine.PK_SettlementMonthly	1	CLUSTERED	Y	Y		92	3168	780	525	2026-10-20 00:59:31	2026-10-18 01:00:18	USED	KEEP — primary key
host-347.flx.InvoiceLine.UQ_LedgerResult	13	NONCLUSTERED	Y			312	0	0	10	2026-10-19 10:22:43	2026-10-18 01:00:18	USED	keep — in use
host-347.flx.ContractSummary.UQ_SalesQueue	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
host-347.flx.AssetLog.PK_ContractLine	1	CLUSTERED	Y	Y		11	24794	0	317	2026-10-20 00:59:31	2026-10-18 01:00:18	USED	KEEP — primary key
host-347.flx.CustomerLine.IX_SalesEntry	3	NONCLUSTERED				1331	276	0	173	2026-10-17 15:20:58	2026-09-23 01:00:10	USED	keep — in use
host-347.flx.CustomerLine.PK_ClaimAudit	1	CLUSTERED	Y	Y		36743	8327	225	174	2026-10-19 10:22:43	2026-09-23 01:00:10	USED	KEEP — primary key
host-347.flx.CustomerLine.IX_InvoiceSummary	9	NONCLUSTERED	Y			4	17	0	67	2026-09-21 08:45:22	2026-09-23 01:00:10	USED	keep — in use
host-347.flx.BatchSummary.PK_MeterResult	1	CLUSTERED	Y	Y		0	4	0	18	2026-04-14 14:05:00	never	USED	KEEP — primary key
host-347.flx.OrdersMonthly.IX_RosterMonthly	6	NONCLUSTERED				10	6	0	1449	2026-08-27 15:47:17	2026-10-20 01:00:18	USED	keep — in use
host-347.flx.OrdersMonthly.PK_PolicySnapshot	1	CLUSTERED	Y	Y		4547	13743	0	3991	2026-10-19 12:53:50	2026-10-20 01:00:18	USED	KEEP — primary key
host-347.flx.SalesLog.PK_ContractAudit	1	CLUSTERED	Y	Y		0	16238	0	452	2026-10-19 12:52:08	never	USED	KEEP — primary key
host-347.flx.PolicyDetail.PK_AssetSnapshot	1	CLUSTERED	Y	Y		4	2273	0	99	2026-10-17 16:06:09	never	USED	KEEP — primary key
host-347.flx.RosterStatus.PK_TerritoryHistory	1	CLUSTERED	Y	Y		8584	45	0	624	2026-10-19 12:53:50	2026-10-20 01:00:18	USED	KEEP — primary key
host-347.flx.ClaimHeader.IX_WarehouseMonthly	15	NONCLUSTERED				97238	24	0	315	2026-10-19 12:53:50	2026-10-18 01:00:18	USED	keep — in use
host-347.flx.ClaimHeader.PK_BatchAudit	1	CLUSTERED	Y	Y		92405	69939	97012	838	2026-10-19 12:53:50	2026-10-18 01:00:18	USED	KEEP — primary key
host-347.flx.ClaimHeader.UX_SupplierDetail	2	NONCLUSTERED	Y			8634	198	0	835	2026-10-17 13:01:08	2026-10-18 01:00:18	USED	keep — in use
host-347.flx.ShiftArchive.PK_PricingEntry	1	CLUSTERED	Y	Y		0	1122	0	89	2026-10-17 16:06:44	never	USED	KEEP — primary key
host-347.flx.QuotaStatus.PK_SalesResult	1	CLUSTERED	Y	Y		460	1393	0	288	2026-10-17 16:06:44	2026-08-25 01:00:19	USED	KEEP — primary key
host-347.flx.SupplierDetail.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		2	327	0	286	2026-08-24 09:10:05	2026-08-25 01:00:19	USED	KEEP — primary key
host-347.flx.ContractQueue.PK_QuotaEntry	1	CLUSTERED	Y	Y		0	14	0	360	2026-08-21 12:07:16	never	USED	KEEP — primary key
host-347.flx.PricingHistory.IX_ShiftDaily	2	NONCLUSTERED				66364	158	0	1101	2026-10-19 12:53:34	2026-10-18 01:00:20	USED	keep — in use
host-347.flx.PricingHistory.PK_ReconcileHistory	1	CLUSTERED	Y	Y		426	3830	57724	1101	2026-10-19 12:53:34	2026-10-18 01:00:20	USED	KEEP — primary key
host-347.flx.MeterArchive.IX_BatchHeader	7	NONCLUSTERED				16527	9	0	264	2026-10-19 12:53:34	2026-10-18 01:00:20	USED	keep — in use
host-347.flx.MeterArchive.PK_BatchDaily	1	CLUSTERED	Y	Y		969	49278	14048	901	2026-10-19 12:53:34	2026-10-18 01:00:20	USED	KEEP — primary key
host-347.flx.InvoiceLine.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		0	18	0	650	2026-09-12 21:09:35	never	USED	KEEP — primary key
host-347.flx.BookingLog.PK_CatalogLine	1	CLUSTERED	Y	Y		0	6	0	466	2026-04-14 14:05:00	never	USED	KEEP — primary key
host-347.flx.PayrollSnapshot.PK_LedgerResult	1	CLUSTERED	Y	Y		196179	7006	0	429	2026-10-19 12:53:34	2026-10-18 01:00:18	USED	KEEP — primary key
host-347.flx.SettlementLine.PK_QuotaHistory	1	CLUSTERED	Y	Y		2633	229754	0	788	2026-10-19 12:53:34	2026-10-18 01:00:19	USED	KEEP — primary key
host-347.flx.SettlementLine.PK_SettlementEntry	1	CLUSTERED	Y	Y		3	3442	0	1065	2026-10-19 12:52:08	2026-10-18 01:00:19	USED	KEEP — primary key
host-347.flx.ShiftLine.PK_StaffingStaging	1	CLUSTERED	Y	Y		0	37	0	695	2026-08-19 00:28:12	never	USED	KEEP — primary key
host-347.flx.TicketDaily.PK_ContractEntry	1	CLUSTERED	Y	Y		0	13	0	688	2026-08-19 00:25:25	never	USED	KEEP — primary key
host-347.flx.MeterStaging.PK_CatalogResult	1	CLUSTERED	Y	Y		0	8	0	400	2026-08-18 16:05:12	never	USED	KEEP — primary key
host-347.flx.StaffingLine.PK_PolicyHistory	1	CLUSTERED	Y	Y		46972	99691	0	87703	2026-10-19 12:53:50	2026-10-18 01:00:19	USED	KEEP — primary key
host-347.flx.ForecastQueue.PK_BillingEntry	1	CLUSTERED	Y	Y		88	1244	0	337	2026-10-17 13:47:24	never	USED	KEEP — primary key
host-347.flx.QuotaResult.PK_InvoiceArchive	1	CLUSTERED	Y	Y		0	10	0	32956	2026-08-18 23:10:52	never	USED	KEEP — primary key
host-347.flx.CustomerSummary.PK_PricingLine	1	CLUSTERED	Y	Y		2	17135	0	3237	2026-10-17 15:05:24	2026-09-24 01:00:21	USED	KEEP — primary key
host-347.flx.RouteAudit.PK_ContractStatus	1	CLUSTERED	Y	Y		8640	3030	336	370	2026-10-17 15:29:40	2026-10-13 01:00:12	USED	KEEP — primary key
host-347.flx.RouteAudit.UX_BookingEntry	2	NONCLUSTERED	Y			575	628	0	245	2026-10-17 15:20:58	2026-10-13 01:00:13	USED	keep — in use
host-347.flx.MeterSummary.PK_PolicyResult	1	CLUSTERED	Y	Y		301	6146	0	646	2026-10-17 15:29:40	never	USED	KEEP — primary key
host-347.flx.ContractDetail.PK_CampaignStaging	1	CLUSTERED	Y	Y		0	7	0	5	2026-05-06 08:25:05	never	USED	KEEP — primary key
host-347.flx.WarehouseDaily.PK_QuotaLog	1	CLUSTERED	Y	Y		0	4	0	40	2026-04-14 14:05:00	never	USED	KEEP — primary key
host-347.flx.TicketStaging.PK_ForecastArchive	1	CLUSTERED	Y	Y		81116	35676	2812	354	2026-10-19 09:55:05	2026-08-20 01:00:10	USED	KEEP — primary key
host-347.flx.TicketStaging.UX_ShipmentStaging	2	NONCLUSTERED	Y			2866	1273	0	352	2026-10-17 14:03:27	2026-08-20 01:00:10	USED	keep — in use
host-347.flx.MeterLine.PK_SettlementStaging	1	CLUSTERED	Y	Y		33561	10336	6	503	2026-10-19 12:53:50	2026-10-18 01:00:20	USED	KEEP — primary key
host-347.flx.MeterLine.UX_RouteStatus	2	NONCLUSTERED	Y			357	133	0	500	2026-10-17 10:25:45	2026-10-18 01:00:20	USED	keep — in use
host-347.flx.TerritoryArchive.PK_OrdersLine	1	CLUSTERED	Y	Y		3960	193734	0	597	2026-10-19 12:53:50	2026-10-18 01:00:20	USED	KEEP — primary key
host-347.flx.PolicyDaily.PK_RosterResult	1	CLUSTERED	Y	Y		0	9	0	27	2026-08-25 09:50:49	never	USED	KEEP — primary key
host-347.flx.PolicyMonthly.PK_PayrollStaging	1	CLUSTERED	Y	Y		0	2	0	25	2026-05-15 14:08:22	never	USED	KEEP — primary key
host-347.flx.ForecastEntry.IX_AssetEntry	2	NONCLUSTERED				77	6	0	9	2026-09-21 14:05:19	2026-04-09 01:00:05	USED	keep — in use
host-347.flx.ForecastEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		2999	2264	0	9	2026-10-17 15:29:33	2026-04-09 01:00:05	USED	KEEP — primary key
host-347.flx.ShiftSnapshot.PK_LedgerMonthly	1	CLUSTERED	Y	Y		0	3	0	3	2026-05-30 11:25:24	never	USED	KEEP — primary key
host-347.flx.ShiftSnapshot.UQ_CatalogDetail	2	NONCLUSTERED	Y			76	3	0	3	2026-10-17 14:04:33	2026-05-25 08:36:16	USED	keep — in use
host-347.inv.Inventory.PK_InvoiceSummary	1	CLUSTERED	Y	Y		8724	8761	0	1558	2026-10-17 14:41:25	2026-10-18 01:00:20	USED	KEEP — primary key
host-347.inv.ShipmentSummary.IX_TicketDaily	7	NONCLUSTERED			Y	73	1236	0	197	2026-10-16 09:35:40	2026-10-17 01:00:15	USED	keep — in use
host-347.inv.ShipmentSummary.IX_CatalogAudit	3	NONCLUSTERED				260	155	0	231	2026-10-16 09:49:55	2026-10-17 01:00:15	USED	keep — in use
host-347.inv.ShipmentSummary.PK_BookingHeader	1	CLUSTERED	Y	Y		8	89	521	231	2026-10-17 14:21:32	2026-10-17 01:00:15	USED	KEEP — primary key
host-347.inv.ShipmentSummary.UQ_TicketHistory	2	NONCLUSTERED	Y			534	119	0	84	2026-10-17 14:21:32	2026-10-17 01:00:15	USED	keep — in use
host-347.inv.ReconcileMonthly.IX_ShiftLog	4	NONCLUSTERED				0	4	0	226	2026-10-13 10:32:27	2026-10-17 01:00:15	USED	keep — in use
host-347.inv.ReconcileMonthly.IX_ForecastAudit	3	NONCLUSTERED				3	1	0	226	2026-10-09 10:10:49	2026-10-17 01:00:15	USED	keep — in use
host-347.inv.ReconcileMonthly.IX_BookingDaily	2	NONCLUSTERED				308	110	0	191	2026-10-16 09:59:53	2026-10-17 01:00:15	USED	keep — in use
host-347.inv.ReconcileMonthly.PK_WarehouseDetail	1	CLUSTERED	Y	Y		2	1890	51	228	2026-10-17 14:21:32	2026-10-17 01:00:15	USED	KEEP — primary key
host-347.inv.SupplierStatus.PK_PolicySnapshot	1	CLUSTERED	Y	Y		1240	26175	703	286	2026-10-19 13:39:27	2026-10-18 01:00:20	USED	KEEP — primary key
host-347.inv.SupplierStatus.UX_SalesHeader	6	NONCLUSTERED	Y			887	101	0	114	2026-10-17 14:41:25	2026-10-18 01:00:20	USED	keep — in use
host-347.inv.ShipmentDetail.PK_WarehouseSummary	1	CLUSTERED	Y	Y		2328	322	0	228	2026-10-19 11:12:58	2026-10-18 01:00:21	USED	KEEP — primary key
host-347.org.Company.PK_QuotaStaging	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.org.Company.UX_PricingResult	2	NONCLUSTERED	Y			0	0	0	0	never	2024-10-05 22:14:24	COLD	review carefully — unique
host-347.po.CustomerArchive.PK_ForecastResult	1	CLUSTERED	Y	Y		3074	1556	4	173	2026-10-19 08:14:51	2026-10-17 01:00:15	USED	KEEP — primary key
host-347.po.CustomerArchive.UQ_MeterQueue	2	NONCLUSTERED	Y			175	1	0	131	2026-10-16 09:34:42	2026-10-17 01:00:15	USED	keep — in use
host-347.po.ShiftQueue.IX_MeterStaging	2	NONCLUSTERED				2686	191	0	297	2026-10-19 08:14:51	2026-10-17 01:00:15	USED	keep — in use
host-347.po.ShiftQueue.PK_PayrollLog	1	CLUSTERED	Y	Y		130	3571	2	351	2026-10-19 08:14:51	2026-10-17 01:00:15	USED	KEEP — primary key
host-347.po.CustomerQueue.PK_RosterArchive	1	CLUSTERED	Y	Y		0	3	0	266	2026-10-03 08:23:33	never	USED	KEEP — primary key
host-347.po.PricingHistory.PK_SettlementStatus	1	CLUSTERED	Y	Y		0	0	0	124	never	never	UNUSED	KEEP — primary key
host-347.po.PO.PK_SettlementDaily	1	CLUSTERED	Y	Y		80253	8283	52	529	2026-10-19 15:55:20	2026-10-17 01:00:15	USED	KEEP — primary key
host-347.po.PO.UX_TerritoryMonthly	2	NONCLUSTERED	Y			884	4045	0	177	2026-10-19 15:52:42	2026-10-17 01:00:15	USED	keep — in use
host-347.po.ClaimSummary.PK_BatchSnapshot	1	CLUSTERED	Y	Y		45994	4021	2221	547	2026-10-19 15:55:20	2026-10-17 01:00:15	USED	KEEP — primary key
host-347.po.ClaimSummary.UX_PayrollResult	2	NONCLUSTERED	Y			2919	3	0	178	2026-10-19 14:04:01	2026-10-17 01:00:15	USED	keep — in use
host-347.po.RosterLog.PK_QuotaDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
host-347.po.AssetMonthly.PK_PolicyDetail	1	CLUSTERED	Y	Y		0	15	0	482	2026-06-13 15:47:31	never	USED	KEEP — primary key
host-347.pto.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		0	342	0	1	2026-10-13 15:07:59	never	USED	KEEP — primary key
host-347.pto.ContractHeader.PK_ContractEntry	1	CLUSTERED	Y	Y		687	242	0	5	2026-10-15 11:23:50	2026-06-07 01:00:06	USED	KEEP — primary key
host-347.pto.ContractHeader.UX_SalesResult	3	NONCLUSTERED	Y			2	0	0	1	2026-06-06 09:49:51	2026-06-07 01:00:06	USED	keep — in use
host-347.pto.SalesHistory.PK_TicketDetail	1	CLUSTERED	Y	Y		200	848	50	22	2026-10-15 11:23:50	2026-06-07 01:00:06	USED	KEEP — primary key
host-347.pto.SalesHistory.UX_ContractDetail	4	NONCLUSTERED	Y			101	0	0	6	2026-10-10 11:19:10	2026-06-07 01:00:06	USED	keep — in use
host-347.pto.ClaimResult.IX_ContractDetail	2	NONCLUSTERED				82	1	0	6	2026-06-17 15:59:00	2026-06-07 01:00:06	USED	keep — in use
host-347.pto.ClaimResult.PK_SalesLine	1	CLUSTERED	Y	Y		0	0	41	6	2026-06-17 15:59:00	2026-06-07 01:00:06	USED	KEEP — primary key
host-347.pto.LedgerResult.IX_TerritoryResult	3	NONCLUSTERED				384	0	0	21	2026-10-15 11:23:50	2026-06-11 01:00:05	USED	keep — in use
host-347.pto.LedgerResult.PK_TicketArchive	1	CLUSTERED	Y	Y		0	554	384	21	2026-10-15 11:23:50	2026-06-11 01:00:05	USED	KEEP — primary key
host-347.pto.ContractEntry.IX_CustomerDaily	2	NONCLUSTERED				82	0	0	5	2026-06-17 15:59:00	2026-06-11 01:00:05	USED	keep — in use
host-347.pto.ContractEntry.PK_SettlementDetail	1	CLUSTERED	Y	Y		0	0	41	5	2026-06-17 15:59:00	2026-06-11 01:00:05	USED	KEEP — primary key
host-347.ops.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		0	1	0	0	2026-06-08 09:15:20	2026-01-11 01:00:06	USED	KEEP — primary key
host-347.ops.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		0	0	0	1	never	2026-06-09 01:00:06	UNUSED	KEEP — primary key
host-347.ops.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	0	0	1	never	never	UNUSED	KEEP — primary key
host-347.audit.Shipping.PK_PolicyQueue	1	CLUSTERED	Y	Y		45	164	0	0	2026-10-13 15:09:19	2026-01-11 01:00:06	USED	KEEP — primary key
host-347.audit.CatalogQueue.PK_TicketHistory	1	CLUSTERED	Y	Y		0	2	0	0	2025-11-20 13:47:56	never	USED	KEEP — primary key
host-347.audit.CampaignLine.PK_MeterStaging	1	CLUSTERED	Y	Y		0	209	0	0	2026-10-13 15:09:19	2026-01-11 01:00:06	USED	KEEP — primary key
host-347.audit.TicketLog.PK_ReconcileDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	never	UNUSED	KEEP — primary key
host-347.qc.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		210	351	0	0	2026-10-19 11:14:12	2026-01-11 01:00:06	USED	KEEP — primary key
host-347.qc.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		85	897	0	127	2026-10-19 11:14:12	2026-10-20 01:00:18	USED	KEEP — primary key
host-347.qc.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		0	0	0	115	never	2026-10-20 01:00:18	UNUSED	KEEP — primary key
host-347.qc.CampaignSummary.PK_PricingStatus	1	CLUSTERED	Y	Y		554	23294	0	300	2026-10-19 12:53:50	2026-10-18 01:00:23	USED	KEEP — primary key
PPA.ppa.OrdersArchive.IX_QuotaMonthly	2	NONCLUSTERED			Y	54734	5	0	1800	2026-10-12 09:18:30	2026-09-17 01:05:52	USED	keep — in use
PPA.ppa.OrdersArchive.PK_BatchLine	1	CLUSTERED	Y	Y		204	62017	54731	2196	2026-10-12 09:18:30	2026-09-17 01:05:52	USED	KEEP — primary key
PPA.ppa.TicketMonthly.PK_RosterDaily	1	CLUSTERED	Y	Y		0	2	0	2126	2025-12-26 11:19:37	never	USED	KEEP — primary key
PPA.ppa.Machine.PK_LedgerLog	1	CLUSTERED	Y	Y		36	3494	0	76	2026-09-16 10:13:46	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	1881	0	1061	2026-09-16 10:09:18	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				20074	0	0	15539	2026-09-16 10:14:52	2026-08-18 01:03:56	USED	keep — in use
PPA.ppa.RosterLog.PK_CatalogAudit	1	CLUSTERED	Y	Y		18	4346	20074	15985	2026-09-16 10:14:52	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	47324	21615	15022	2026-10-12 09:18:12	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	37969	0	615	2026-09-16 10:13:29	2026-09-17 01:05:52	USED	KEEP — primary key
PPA.ppa.RosterLine.PK_CatalogMonthly	1	CLUSTERED	Y	Y		0	9	0	607	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.Area.IX_CatalogStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.Area.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.Binding.IX_PolicyHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2026-01-11 01:01:58	UNUSED	review carefully — unique
PPG.dbo.Binding.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.Client.IX_StaffingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	2020-07-06 13:37:39	COLD	review carefully — unique
PPG.dbo.Client.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.Location.IX_RosterResult	2	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:02:12	UNUSED	review, then DROP
PPG.dbo.Location.IX_PayrollResult	3	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:02:12	UNUSED	review, then DROP
PPG.dbo.Location.IX_StaffingLog	4	NONCLUSTERED				0	0	0	0	never	2026-01-11 01:02:12	UNUSED	review, then DROP
PPG.dbo.Location.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.Zone.IX_BatchHeader	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
PPG.dbo.Zone.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	102906	0	34650	2026-10-19 21:52:09	never	USED	KEEP — primary key
SALES.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		0	0	0	34650	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	54426	0	31665	2026-10-19 21:50:00	2026-10-20 01:00:22	USED	KEEP — primary key
SALES.dbo.SupplierDaily.PK_LedgerAudit	1	CLUSTERED	Y	Y		0	11970422	0	0	2026-10-20 01:02:58	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			3	6	0	0	2026-09-30 17:12:38	2025-06-19 12:55:51	USED	keep — in use
SALES.dbo.AssetQueue.PK_TerritoryQueue	1	CLUSTERED	Y	Y		12	2474	6	0	2026-10-19 13:56:04	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	1	0	0	2026-09-30 17:09:40	never	USED	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	1	0	0	2026-09-30 17:09:40	never	USED	KEEP — primary key
SALES.dbo.Area.IX_CatalogStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.Area.PK_StaffingHeader	1	CLUSTERED	Y	Y		0	1	0	0	2026-09-30 17:09:40	never	USED	KEEP — primary key
SALES.dbo.ClaimStatus.IX_BookingEntry	2	NONCLUSTERED	Y			0	1	0	0	2026-09-30 17:09:40	never	USED	keep — in use
SALES.dbo.ClaimStatus.PK_OrdersQueue	1	CLUSTERED	Y	Y		0	0	1	0	2026-09-30 17:09:40	never	USED	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		838455	99762	0	0	2026-10-20 01:02:35	2025-06-19 12:57:44	USED	KEEP — primary key
SALES.dbo.Binding.IX_PolicyHeader	2	NONCLUSTERED	Y			0	102	0	0	2026-10-14 13:47:25	2025-06-19 12:57:44	USED	keep — in use
SALES.dbo.Binding.PK_AssetArchive	1	CLUSTERED	Y	Y		0	15	0	0	2026-09-30 17:12:38	never	USED	KEEP — primary key
SALES.dbo.ForecastLine.PK_LedgerStaging	1	CLUSTERED	Y	Y		0	8	0	0	2026-09-30 17:12:38	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			12	0	0	0	2026-09-30 17:12:38	2025-06-19 12:57:44	USED	keep — in use
SALES.dbo.BillingArchive.IX_CustomerSummary	3	NONCLUSTERED	Y			6	6	0	0	2026-09-30 17:12:38	2025-06-19 12:57:44	USED	keep — in use
SALES.dbo.BillingArchive.PK_ForecastStatus	1	CLUSTERED	Y	Y		48	3	0	0	2026-09-30 17:12:38	2025-06-19 12:57:44	USED	KEEP — primary key
SALES.dbo.ContractSummary.IX_QuotaSummary	2	NONCLUSTERED	Y			3	19	0	0	2026-09-30 17:12:38	never	USED	keep — in use
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	1	never	never	UNUSED	KEEP — primary key
SALES.dbo.Client.IX_StaffingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.Client.PK_PricingMonthly	1	CLUSTERED	Y	Y		35551	5328	0	0	2026-10-19 19:37:35	2022-05-31 16:13:23	USED	KEEP — primary key
SALES.dbo.PayrollLog.IX_BookingAudit	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.PayrollLog.PK_ShiftDaily	1	CLUSTERED	Y	Y		0	0	0	0	never	never	COLD	KEEP — primary key
SALES.dbo.AssetLog.IX_StaffingArchive	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 12:57:44	COLD	review carefully — unique
SALES.dbo.AssetLog.PK_SalesEntry	1	CLUSTERED	Y	Y		0	12	0	0	2026-09-30 17:11:33	never	USED	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	6	0	0	2026-09-30 17:12:21	never	USED	KEEP — primary key
SALES.dbo.Dashboard.IX_BatchMonthly	1	CLUSTERED	Y			3113392	53631	131064	40200	2026-10-19 21:50:02	2026-10-20 01:00:25	USED	KEEP — table storage
SALES.dbo.Dashboard.IX_ContractDaily	25	NONCLUSTERED				23106	0	0	40200	2026-10-17 14:29:55	2026-10-18 01:01:19	USED	keep — in use
SALES.dbo.Dashboard.IX_BatchMonthly	23	NONCLUSTERED				2	177	0	40200	2026-10-13 13:31:09	2026-10-18 01:01:30	USED	keep — in use
SALES.dbo.Dashboard.IX_ShipmentMonthly	18	NONCLUSTERED				133291	133	0	40200	2026-10-19 20:17:10	2026-10-18 01:01:37	USED	keep — in use
SALES.dbo.Dashboard.IX_SupplierDaily	22	NONCLUSTERED				7	0	0	40200	2026-09-04 08:17:29	2026-10-18 01:01:50	USED	keep — in use
SALES.dbo.Dashboard.IX_BookingArchive	24	NONCLUSTERED				4	0	0	40200	2026-05-20 08:52:42	2026-10-18 01:01:54	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	12	0	0	2026-09-30 17:11:33	never	USED	KEEP — primary key
SALES.dbo.ShipmentArchive.PK_QuotaResult	1	CLUSTERED	Y	Y		0	2509	0	0	2026-10-19 13:56:03	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	6	never	2026-10-01 01:02:53	UNUSED	review, then DROP
SALES.dbo.History.IX_ContractQueue	3	NONCLUSTERED				0	0	0	6	never	2026-10-01 01:02:53	UNUSED	review, then DROP
SALES.dbo.History.IX_OrdersLog	4	NONCLUSTERED				0	0	0	6	never	2026-10-01 01:02:53	UNUSED	review, then DROP
SALES.dbo.History.PK_CatalogQueue	1	CLUSTERED	Y	Y		0	33448	0	6	2026-10-19 21:50:02	2026-10-01 01:02:03	USED	KEEP — primary key
SALES.dbo.AssetDaily.PK_StaffingHistory	1	CLUSTERED	Y	Y		6	0	0	6	2026-09-30 17:12:38	2026-10-01 01:02:54	USED	KEEP — primary key
SALES.dbo.SettlementArchive.PK_PayrollDaily	1	CLUSTERED	Y	Y		16	33426	0	6	2026-10-19 21:50:02	2026-10-01 01:02:54	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		25	767933	0	2	2026-10-20 01:02:35	2026-10-01 01:02:55	USED	KEEP — primary key
SALES.dbo.RouteResult.IX_BillingDetail	2	NONCLUSTERED	Y			731468	0	0	2	2026-10-20 01:02:35	2026-10-01 01:02:55	USED	keep — in use
SALES.dbo.RouteResult.PK_MeterHeader	1	CLUSTERED	Y	Y		22	2	731464	4	2026-10-20 01:02:35	2026-10-01 01:02:55	USED	KEEP — primary key
SALES.dbo.Location.IX_RosterResult	2	NONCLUSTERED				0	346	0	0	2026-10-19 06:10:00	2025-06-19 13:05:21	USED	keep — in use
SALES.dbo.Location.IX_PayrollResult	3	NONCLUSTERED				35739	0	0	0	2026-10-19 19:37:35	2025-06-19 13:05:21	USED	keep — in use
SALES.dbo.Location.IX_StaffingLog	4	NONCLUSTERED				2	692	0	692	2026-10-19 12:00:00	2025-06-19 13:05:21	USED	keep — in use
SALES.dbo.Location.PK_TicketLine	1	CLUSTERED	Y	Y		71	38	20	694	2026-10-09 23:02:06	2025-06-19 13:05:21	USED	KEEP — primary key
SALES.dbo.InvoiceEntry.PK_StaffingHistory	1	CLUSTERED	Y	Y		0	720	148	1038	2026-10-19 06:10:00	2025-06-19 13:05:21	USED	KEEP — primary key
SALES.dbo.InvoiceEntry.UX_ForecastSummary	6	NONCLUSTERED	Y			148	346	0	692	2026-10-19 06:10:00	2026-10-19 06:10:00	USED	keep — in use
SALES.dbo.ForecastQueue.PK_ShipmentHistory	1	CLUSTERED	Y	Y		0	0	0	692	never	never	UNUSED	KEEP — primary key
SALES.dbo.PolicyLine.IX_TerritoryHeader	2	NONCLUSTERED	Y			6	0	0	12	2026-09-30 17:12:38	2026-10-01 01:02:55	USED	keep — in use
SALES.dbo.PolicyLine.PK_SupplierStatus	1	CLUSTERED	Y	Y		99	26	6	24	2026-10-09 22:56:47	2026-10-01 01:02:55	USED	KEEP — primary key
SALES.dbo.LedgerStatus.IX_CustomerLog	2	NONCLUSTERED	Y			0	0	0	18	never	2026-10-01 01:02:55	UNUSED	review carefully — unique
SALES.dbo.LedgerStatus.IX_CampaignQueue	3	NONCLUSTERED				96	0	0	18	2026-09-30 17:12:39	2026-10-01 01:02:55	USED	keep — in use
SALES.dbo.LedgerStatus.PK_LedgerHeader	1	CLUSTERED	Y	Y		71	12	34	26	2026-10-09 22:56:47	2026-10-01 01:02:55	USED	KEEP — primary key
SALES.dbo.ReconcileHistory.IX_BatchDetail	2	NONCLUSTERED	Y			12	0	0	12	2026-09-30 17:12:39	never	USED	keep — in use
SALES.dbo.ReconcileHistory.PK_BookingResult	1	CLUSTERED	Y	Y		0	3	0	12	2026-09-30 17:11:01	never	USED	KEEP — primary key
SALES.dbo.StaffingSnapshot.PK_CustomerLog	1	CLUSTERED	Y	Y		1534197	802546	0	766979	2026-10-20 01:02:35	2026-10-18 01:02:01	USED	KEEP — primary key
SALES.dbo.ReconcileStaging.IX_ShipmentStatus	2	NONCLUSTERED	Y			766983	0	0	0	2026-10-20 01:02:35	never	USED	keep — in use
SALES.dbo.ReconcileStaging.PK_ContractStatus	1	CLUSTERED	Y	Y		0	766982	0	0	2026-10-20 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	766988	0	0	2026-10-20 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	99751	0	0	2026-10-20 01:02:34	never	USED	KEEP — primary key
SALES.dbo.PolicyLog.IX_OrdersDaily	2	NONCLUSTERED	Y			766990	0	0	35540	2026-10-20 01:02:35	2026-10-18 01:02:19	USED	keep — in use
SALES.dbo.PolicyLog.PK_ShiftHeader	1	CLUSTERED	Y	Y		0	0	766988	35540	2026-10-20 01:02:35	2026-10-18 01:02:19	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		3067953	99751	0	0	2026-10-20 01:02:35	2025-06-19 13:05:24	USED	KEEP — primary key
SALES.dbo.WarehouseHistory.IX_PayrollDaily	2	NONCLUSTERED	Y			1533967	0	0	0	2026-10-20 01:02:35	never	USED	keep — in use
SALES.dbo.WarehouseHistory.PK_PricingEntry	1	CLUSTERED	Y	Y		0	99751	0	0	2026-10-20 01:02:34	never	USED	KEEP — primary key
SALES.dbo.PayrollStatus.IX_ContractQueue	2	NONCLUSTERED	Y			766979	0	0	0	2026-10-20 01:02:35	never	USED	keep — in use
SALES.dbo.PayrollStatus.PK_SalesResult	1	CLUSTERED	Y	Y		0	866749	0	0	2026-10-20 01:02:35	never	USED	KEEP — primary key
SALES.dbo.BillingDetail.IX_CampaignLine	2	NONCLUSTERED	Y			767016	12	0	35721	2026-10-20 01:02:35	2026-10-18 01:02:31	USED	keep — in use
SALES.dbo.BillingDetail.PK_ReconcileHeader	1	CLUSTERED	Y	Y		0	8	767004	35721	2026-10-20 01:02:35	2026-10-18 01:02:31	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	66532	0	33266	2026-10-19 21:50:02	2026-10-18 01:02:32	USED	KEEP — primary key
SALES.dbo.ShiftHeader.PK_ReconcileHeader	1	CLUSTERED	Y	Y		6810944	0	0	0	2026-10-20 01:02:40	2025-06-19 13:05:25	USED	KEEP — primary key
SALES.dbo.AssetQueue.IX_PricingLog	2	NONCLUSTERED	Y			18021	0	0	0	2026-10-19 13:56:04	2025-06-19 13:05:25	USED	keep — in use
SALES.dbo.AssetQueue.PK_PricingMonthly	1	CLUSTERED	Y	Y		2789	3383580	18021	0	2026-10-20 01:02:40	2025-06-19 13:05:25	USED	KEEP — primary key
SALES.dbo.WarehouseAudit.IX_WarehouseEntry	2	NONCLUSTERED	Y			2510	0	0	279	2026-10-19 13:56:03	2026-10-18 01:02:32	USED	keep — in use
SALES.dbo.WarehouseAudit.PK_ReconcileAudit	1	CLUSTERED	Y	Y		279	3401601	2510	279	2026-10-20 01:02:40	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		101	2	0	0	2026-10-14 13:47:25	never	USED	KEEP — primary key
SALES.dbo.AssetResult.PK_BillingSummary	1	CLUSTERED	Y	Y		2520	5024	0	5032	2026-10-19 17:10:03	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			24	2	0	0	2026-09-30 17:12:38	2023-11-01 08:22:19	USED	keep — in use
SALES.dbo.ClaimSnapshot.PK_ClaimEntry	1	CLUSTERED	Y	Y		54	0	6	0	2026-09-30 17:12:38	2023-11-01 08:22:19	USED	KEEP — primary key
SALES.dbo.ReconcileDaily.IX_StaffingHistory	2	NONCLUSTERED	Y			206	7729	0	0	2026-10-19 13:56:04	2025-06-19 13:05:30	USED	keep — in use
SALES.dbo.ReconcileDaily.PK_RosterResult	1	CLUSTERED	Y	Y		108	1	7935	0	2026-10-19 13:56:04	2025-06-19 13:05:30	USED	KEEP — primary key
SALES.dbo.MeterQueue.IX_OrdersMonthly	2	NONCLUSTERED	Y			1	0	0	0	2026-09-30 17:09:40	2025-06-19 13:05:30	USED	keep — in use
SALES.dbo.MeterQueue.PK_ReconcileArchive	1	CLUSTERED	Y	Y		2505	8	1	0	2026-10-19 13:56:04	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	99751	0	0	2026-10-20 01:02:34	never	USED	keep — in use
SALES.dbo.OrdersDetail.PK_LedgerResult	1	CLUSTERED	Y	Y		1026717	507257	0	0	2026-10-20 01:02:35	never	USED	KEEP — primary key
SALES.dbo.Task.IX_PayrollDaily	2	NONCLUSTERED				35	0	0	28	2026-09-30 17:12:39	2026-10-01 01:03:03	USED	keep — in use
SALES.dbo.Task.PK_ShipmentLine	1	CLUSTERED	Y	Y		22	0	11	32	2026-09-30 17:12:38	2026-10-01 01:03:03	USED	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		2	0	0	0	2026-09-30 17:11:01	never	USED	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		6	0	0	0	2026-09-30 17:11:33	2025-06-19 13:05:30	USED	KEEP — primary key
SALES.dbo.TerritorySnapshot.IX_QuotaHeader	2	NONCLUSTERED	Y			6	2	0	0	2026-09-30 17:11:33	2023-11-24 07:37:19	USED	keep — in use
SALES.dbo.TerritorySnapshot.IX_SupplierEntry	3	NONCLUSTERED				0	55	0	0	2026-10-14 13:47:25	2023-11-24 07:37:19	USED	keep — in use
SALES.dbo.TerritorySnapshot.PK_SalesHeader	1	CLUSTERED	Y	Y		4	10	7	0	2026-09-30 17:12:42	2025-06-19 13:05:30	USED	KEEP — primary key
SALES.dbo.SupplierHistory.PK_ContractLine	1	CLUSTERED	Y	Y		2729	2729	0	2729	2026-10-19 13:56:03	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		2679	6	0	0	2026-10-19 13:56:04	2025-06-19 13:05:31	USED	KEEP — primary key
SALES.dbo.CustomerSummary.IX_OrdersDaily	2	NONCLUSTERED	Y			6	0	0	12	2026-09-30 17:12:38	never	USED	keep — in use
SALES.dbo.CustomerSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		50	0	6	12	2026-09-30 17:12:39	2026-10-01 01:03:03	USED	KEEP — primary key
SALES.dbo.CustomerEntry.IX_SupplierQueue	2	NONCLUSTERED	Y			6	0	0	6	2026-09-30 17:12:39	never	USED	keep — in use
SALES.dbo.CustomerEntry.PK_InvoiceDaily	1	CLUSTERED	Y	Y		0	2	0	6	2026-09-30 17:11:01	never	USED	KEEP — primary key
SALES.dbo.MeterLog.IX_AssetEntry	2	NONCLUSTERED				78	0	0	30	2026-09-30 17:12:39	2026-10-01 01:03:03	USED	keep — in use
SALES.dbo.MeterLog.IX_RosterDaily	3	NONCLUSTERED				32	0	0	32	2026-09-30 17:12:39	2026-10-01 01:03:03	USED	keep — in use
SALES.dbo.MeterLog.IX_TicketLog	4	NONCLUSTERED				0	0	0	30	never	2026-10-01 01:03:03	UNUSED	review, then DROP
SALES.dbo.MeterLog.IX_RosterHistory	5	NONCLUSTERED				0	0	0	30	never	2026-10-01 01:03:03	UNUSED	review, then DROP
SALES.dbo.MeterLog.PK_QuotaMonthly	1	CLUSTERED	Y	Y		32	28	84	40	2026-09-30 17:12:38	2026-10-01 01:03:03	USED	KEEP — primary key
SALES.dbo.Zone.IX_BatchHeader	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
SALES.dbo.Zone.PK_CampaignStatus	1	CLUSTERED	Y	Y		1533973	99758	0	0	2026-10-20 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		5502737	3552155	2	313902	2026-10-19 20:23:29	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		2443180	419	0	313929	2026-10-19 20:22:34	2026-10-19 16:22:42	USED	KEEP — primary key
SALES.kar.RosterSummary.IX_PricingDetail	2	NONCLUSTERED				0	0	0	313915	never	2026-10-18 01:02:39	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	313929	2026-08-28 16:11:07	2026-10-18 01:02:37	USED	KEEP — primary key
SALES.kar.SupplierArchive.IX_SettlementLine	9	NONCLUSTERED				1894806	25	0	313928	2026-10-19 20:23:29	2026-10-19 17:15:40	USED	keep — in use
SALES.kar.SupplierArchive.PK_QuotaSnapshot	1	CLUSTERED	Y	Y		355205	5342756	1894831	313929	2026-10-19 20:23:29	2026-10-19 17:15:40	USED	KEEP — primary key
SALES.kar.ClaimResult.IX_ContractHistory	9	NONCLUSTERED				347640	0	0	313928	2026-10-19 20:22:34	2026-10-19 16:02:57	USED	keep — in use
SALES.kar.ClaimResult.IX_QuotaSnapshot	8	NONCLUSTERED				557272	8579	0	313928	2026-10-19 20:17:10	2026-10-19 16:02:57	USED	keep — in use
SALES.kar.ClaimResult.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		0	1089927	650429	313929	2026-10-19 20:23:29	2026-10-19 16:02:57	USED	KEEP — primary key
SALES.kar.RosterDaily.IX_ClaimSummary	12	NONCLUSTERED				54269	9415	0	313929	2026-10-19 18:55:52	2026-10-18 01:02:55	USED	keep — in use
SALES.kar.RosterDaily.IX_RouteDetail	16	NONCLUSTERED			Y	2968	6661	0	313928	2026-10-19 15:54:06	2026-10-18 01:02:55	USED	keep — in use
SALES.kar.RosterDaily.IX_CampaignStatus	19	NONCLUSTERED			Y	210	0	0	13	2026-10-17 10:19:29	never	USED	keep — in use
SALES.kar.RosterDaily.PK_BillingAudit	1	CLUSTERED	Y	Y		0	45	9846	313929	2026-10-19 15:54:06	2026-10-18 01:02:51	USED	KEEP — primary key
SALES.kar.LedgerHeader.PK_TerritoryResult	1	CLUSTERED	Y	Y		7407	2241	0	793	2026-10-19 14:02:48	2026-10-18 01:02:57	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.Machine.PK_LedgerLog	1	CLUSTERED	Y	Y		3495614	558777	0	2403357	2026-10-19 20:23:29	2025-03-13 13:09:59	USED	KEEP — primary key
SALES.kar.Machine.UX_OrdersStatus	4	NONCLUSTERED	Y			1530247	3345595	0	0	2026-10-19 20:23:29	2025-04-11 12:42:09	USED	keep — in use
SALES.kar.ClaimDetail.PK_TicketStatus	1	CLUSTERED	Y	Y		457	537	0	340	2026-10-19 12:15:13	2026-10-19 01:00:39	USED	KEEP — primary key
SALES.kar.PayrollResult.PK_WarehouseDetail	1	CLUSTERED	Y	Y		2955	108	0	93	2026-10-19 17:46:56	2025-10-03 01:00:48	USED	KEEP — primary key
SALES.kar.AssetHeader.PK_BillingSummary	1	CLUSTERED	Y	Y		2001	1169116	0	3117	2026-10-19 20:23:29	never	USED	KEEP — primary key
SALES.kar.SettlementLog.PK_MeterDaily	1	CLUSTERED	Y	Y		2387258	0	0	978364	2026-10-19 20:22:36	2026-10-19 18:21:46	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.Area.IX_CatalogStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.Area.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.Binding.IX_PolicyHeader	2	NONCLUSTERED	Y			0	0	0	0	never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.Binding.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.Client.IX_StaffingStatus	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.Client.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.Location.IX_RosterResult	2	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.Location.IX_PayrollResult	3	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.Location.IX_StaffingLog	4	NONCLUSTERED				0	0	0	0	never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.Location.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.Zone.IX_BatchHeader	2	NONCLUSTERED	Y			0	0	0	0	never	never	COLD	review carefully — unique
BATCH_Test.dbo.Zone.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	7144	5	292	2026-09-23 13:41:53	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	190	371	338	2026-09-23 13:42:05	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.Machine.PK_LedgerLog	1	CLUSTERED	Y	Y		3391	2481	0	3006	2026-09-23 13:41:53	2025-03-13 13:09:59	USED	KEEP — primary key
BATCH_Test.kar.Machine.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	4405	0	0	2026-09-23 13:41:53	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.Item.PK_StaffingDetail	1	CLUSTERED	Y	Y		0	0	0	0	never	2024-05-03 14:41:51	COLD	KEEP — primary key
CLAIM_Prod.lib.Item.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.Unit.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.Item.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.Item.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.Unit.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