Index Usage — ACME-192-0-2-15-MSSQL25-1433

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

Index Usage Report — ACME-192-0-2-15-MSSQL25-1433

Host: 192.0.2.15

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

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

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

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

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

Metric	Count	Meaning
indexes_total	956	every index on a CatalogHistory table
used	0	had a seek, scan or lookup
unused	0	written but never read
cold	956	never read AND never written since restart
disabled	0	ALTER INDEX ... DISABLE was run
droppable	113	nonclustered, not unique, no constraint, never read

By database

Database	Total	Cold	Droppable	Recommend action
BATCH_Test	188	188	35	review the drop candidates above
SALES	187	187	35	review the drop candidates above
PPG	144	144	21	review the drop candidates above
host-347	129	129	9	review the drop candidates above
host-315	125	125	9	review the drop candidates above
PPA	15	15	4	review the drop candidates above
CLAIM_Prod	58	58	0	no action — cold indexes here are constraints or clustered
CONTRACT	58	58	0	no action — cold indexes here are constraints or clustered
RECONCILE	23	23	0	no action — cold indexes here are constraints or clustered
APP	22	22	0	no action — cold indexes here are constraints or clustered
PAYROLL	3	3	0	no action — cold indexes here are constraints or clustered
report	3	3	0	no action — cold indexes here are constraints or clustered
PAYROLL	1	1	0	no action — cold indexes here are constraints or clustered

Drop candidates (113)

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

Index	last_read	State	Recommend action
host-347.flx.PricingHistory.IX_ShiftDaily	never	COLD	review, then DROP
host-347.flx.MeterArchive.IX_BatchHeader	never	COLD	review, then DROP
SALES.dbo.Dashboard.IX_BatchMonthly	never	COLD	review, then DROP
SALES.dbo.Dashboard.IX_ShipmentMonthly	never	COLD	review, then DROP
SALES.dbo.Dashboard.IX_SupplierDaily	never	COLD	review, then DROP
SALES.dbo.Dashboard.IX_BookingArchive	never	COLD	review, then DROP
SALES.dbo.MeterMonthly.IX_RouteHeader	never	COLD	review, then DROP
SALES.dbo.LedgerStaging.IX_CatalogStatus	never	COLD	review, then DROP
SALES.dbo.LedgerStaging.IX_StaffingSnapshot	never	COLD	review, then DROP
SALES.dbo.PricingLine.IX_LedgerDetail	never	COLD	review, then DROP
SALES.dbo.PricingLine.IX_RosterSummary	never	COLD	review, then DROP
SALES.dbo.History.IX_PolicyDetail	never	COLD	review, then DROP
SALES.dbo.History.IX_ContractQueue	never	COLD	review, then DROP
SALES.dbo.History.IX_OrdersLog	never	COLD	review, then DROP
SALES.dbo.SettlementDetail.IX_RosterResult	never	COLD	review, then DROP
SALES.dbo.SettlementDetail.IX_PayrollResult	never	COLD	review, then DROP
SALES.dbo.SettlementDetail.IX_StaffingLog	never	COLD	review, then DROP
SALES.dbo.LedgerStatus.IX_CampaignQueue	never	COLD	review, then DROP
SALES.dbo.CustomerSummary.IX_BatchAudit	never	COLD	review, then DROP
SALES.dbo.QuotaAudit.IX_OrdersAudit	never	COLD	review, then DROP
BATCH_Test.kar.RosterDaily.IX_CampaignStatus	never	COLD	review, then DROP
BATCH_Test.kar.RosterDaily.IX_RouteDetail	never	COLD	review, then DROP
BATCH_Test.kar.RosterDaily.IX_ClaimSummary	never	COLD	review, then DROP
BATCH_Test.kar.RosterSummary.IX_PricingDetail	never	COLD	review, then DROP
BATCH_Test.kar.RosterSummary.IX_InvoiceDaily	never	COLD	review, then DROP
BATCH_Test.dbo.Task.IX_PayrollDaily	never	COLD	review, then DROP
BATCH_Test.kar.ClaimResult.IX_QuotaSnapshot	never	COLD	review, then DROP
BATCH_Test.kar.ClaimResult.IX_ContractHistory	never	COLD	review, then DROP
BATCH_Test.kar.SupplierArchive.IX_SettlementLine	never	COLD	review, then DROP
BATCH_Test.dbo.QuotaAudit.IX_OrdersAudit	never	COLD	review, then DROP
BATCH_Test.dbo.CustomerSummary.IX_BatchAudit	never	COLD	review, then DROP
PPG.dbo.MeterMonthly.IX_RouteHeader	never	COLD	review, then DROP
PPG.dbo.LedgerStaging.IX_CatalogStatus	never	COLD	review, then DROP
PPG.dbo.LedgerStaging.IX_StaffingSnapshot	never	COLD	review, then DROP
PPG.dbo.PricingLine.IX_LedgerDetail	never	COLD	review, then DROP
PPG.dbo.PricingLine.IX_RosterSummary	never	COLD	review, then DROP
PPG.dbo.History.IX_PolicyDetail	never	COLD	review, then DROP
PPG.dbo.History.IX_ContractQueue	never	COLD	review, then DROP
PPG.dbo.History.IX_OrdersLog	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStatus.IX_CampaignQueue	never	COLD	review, then DROP
host-315.pto.ContractEntry.IX_CustomerDaily	never	COLD	review, then DROP
PPG.dbo.SettlementDetail.IX_RosterResult	never	COLD	review, then DROP
PPG.dbo.SettlementDetail.IX_PayrollResult	never	COLD	review, then DROP
PPG.dbo.SettlementDetail.IX_StaffingLog	never	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.IX_StaffingLog	never	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.IX_PayrollResult	never	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.IX_RosterResult	never	COLD	review, then DROP
BATCH_Test.dbo.History.IX_OrdersLog	never	COLD	review, then DROP
BATCH_Test.dbo.History.IX_ContractQueue	never	COLD	review, then DROP
BATCH_Test.dbo.History.IX_PolicyDetail	never	COLD	review, then DROP
BATCH_Test.dbo.PricingLine.IX_RosterSummary	never	COLD	review, then DROP
BATCH_Test.dbo.PricingLine.IX_LedgerDetail	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStaging.IX_StaffingSnapshot	never	COLD	review, then DROP
PPG.dbo.LedgerStatus.IX_CampaignQueue	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStaging.IX_CatalogStatus	never	COLD	review, then DROP
BATCH_Test.dbo.MeterMonthly.IX_RouteHeader	never	COLD	review, then DROP
BATCH_Test.dbo.Dashboard.IX_BookingArchive	never	COLD	review, then DROP
BATCH_Test.dbo.Dashboard.IX_SupplierDaily	never	COLD	review, then DROP
BATCH_Test.dbo.Dashboard.IX_ShipmentMonthly	never	COLD	review, then DROP
BATCH_Test.dbo.Dashboard.IX_BatchMonthly	never	COLD	review, then DROP
BATCH_Test.dbo.Dashboard.IX_ContractDaily	never	COLD	review, then DROP
SALES.dbo.TerritorySnapshot.IX_SupplierEntry	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_AssetEntry	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_RosterDaily	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_TicketLog	never	COLD	review, then DROP
SALES.dbo.MeterLog.IX_RosterHistory	never	COLD	review, then DROP
SALES.kar.RosterSummary.IX_PricingDetail	never	COLD	review, then DROP
SALES.kar.RosterSummary.IX_InvoiceDaily	never	COLD	review, then DROP
SALES.kar.SupplierArchive.IX_SettlementLine	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_RosterHistory	never	COLD	review, then DROP
SALES.kar.ClaimResult.IX_ContractHistory	never	COLD	review, then DROP
SALES.kar.ClaimResult.IX_QuotaSnapshot	never	COLD	review, then DROP
SALES.kar.RosterDaily.IX_ClaimSummary	never	COLD	review, then DROP
SALES.kar.RosterDaily.IX_RouteDetail	never	COLD	review, then DROP
SALES.kar.RosterDaily.IX_CampaignStatus	never	COLD	review, then DROP
SALES.kar.LedgerLog.IX_PricingAudit	never	COLD	review, then DROP
BATCH_Test.kar.LedgerLog.IX_PricingAudit	never	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_RosterHistory	never	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_TicketLog	never	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_RosterDaily	never	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_AssetEntry	never	COLD	review, then DROP
PPA.ppa.OrdersArchive.IX_QuotaMonthly	never	COLD	review, then DROP
PPA.ppa.RosterLog.IX_QuotaSummary	never	COLD	review, then DROP
BATCH_Test.dbo.TerritorySnapshot.IX_SupplierEntry	never	COLD	review, then DROP
BATCH_Test.dbo.TicketDaily.IX_RouteMonthly	never	COLD	review, then DROP
PPA.ppa.Record.IX_CustomerMonthly	never	COLD	review, then DROP
PPA.ppa.Record.IX_CampaignMonthly	never	COLD	review, then DROP
host-347.pto.LedgerResult.IX_TerritoryResult	never	COLD	review, then DROP
host-347.pto.ClaimResult.IX_ContractDetail	never	COLD	review, then DROP
PPG.dbo.Task.IX_PayrollDaily	never	COLD	review, then DROP
host-315.flx.CustomerLine.IX_SalesEntry	never	COLD	review, then DROP
PPG.dbo.TicketDaily.IX_RouteMonthly	never	COLD	review, then DROP
PPG.dbo.TerritorySnapshot.IX_SupplierEntry	never	COLD	review, then DROP
host-315.flx.OrdersMonthly.IX_RosterMonthly	never	COLD	review, then DROP
host-315.flx.ClaimHeader.IX_WarehouseMonthly	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_AssetEntry	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_RosterDaily	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_TicketLog	never	COLD	review, then DROP
host-315.flx.PricingHistory.IX_ShiftDaily	never	COLD	review, then DROP
host-315.flx.MeterArchive.IX_BatchHeader	never	COLD	review, then DROP
host-347.flx.ForecastEntry.IX_AssetEntry	never	COLD	review, then DROP
host-315.flx.ForecastEntry.IX_AssetEntry	never	COLD	review, then DROP
host-315.pto.ClaimResult.IX_ContractDetail	never	COLD	review, then DROP
host-315.pto.LedgerResult.IX_TerritoryResult	never	COLD	review, then DROP
host-347.flx.ClaimHeader.IX_WarehouseMonthly	never	COLD	review, then DROP
host-347.flx.OrdersMonthly.IX_RosterMonthly	never	COLD	review, then DROP
host-347.flx.CustomerLine.IX_SalesEntry	never	COLD	review, then DROP
PPG.dbo.CustomerSummary.IX_BatchAudit	never	COLD	review, then DROP
SALES.dbo.TicketDaily.IX_RouteMonthly	never	COLD	review, then DROP
SALES.dbo.Task.IX_PayrollDaily	never	COLD	review, then DROP
SALES.dbo.Dashboard.IX_ContractDaily	never	COLD	review, then DROP
PPG.dbo.QuotaAudit.IX_OrdersAudit	never	COLD	review, then DROP
host-347.pto.ContractEntry.IX_CustomerDaily	never	COLD	review, then DROP

All indexes (956)

Every index on the instance, including the healthy ones — the answer to "is THIS index used?" has to be here, not only the problems.

Index	id	Type	Uniq	PK	Filt	last_read	last_stats_update	State	Recommend action
APP.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:01	COLD	KEEP — primary key
APP.app.ShiftAudit.UX_PayrollAudit	4	NONCLUSTERED	Y			never	2026-09-15 01:00:01	COLD	review carefully — unique
APP.app.ReconcileDaily.PK_LedgerResult	1	CLUSTERED	Y	Y		never	2026-07-01 01:00:01	COLD	KEEP — primary key
APP.app.PolicyStatus.PK_RouteArchive	1	CLUSTERED	Y	Y		never	2026-05-16 01:00:01	COLD	KEEP — primary key
APP.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
APP.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
APP.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:01	COLD	KEEP — primary key
APP.app.CampaignAudit.PK_BillingMonthly	1	CLUSTERED	Y	Y		never	2026-05-12 01:00:01	COLD	KEEP — primary key
APP.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		never	2026-07-01 01:00:01	COLD	KEEP — primary key
APP.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
APP.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		never	2026-02-27 01:00:01	COLD	KEEP — primary key
APP.app.PricingLog.PK_AssetResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
APP.app.BatchQueue.PK_ShiftHeader	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
APP.app.CampaignMonthly.PK_CatalogHeader	1	CLUSTERED	Y	Y		never	2026-03-04 01:00:01	COLD	KEEP — primary key
APP.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		never	2026-02-27 01:00:01	COLD	KEEP — primary key
APP.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
APP.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
APP.app.ReconcileSnapshot.PK_SupplierArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
APP.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:01	COLD	KEEP — primary key
APP.app.ClaimResult.PK_ShipmentStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
APP.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
APP.dbo.ContractEntry.PK_SettlementStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PAYROLL.dbo.SupplierStatus.PK_BookingHeader	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PAYROLL.dbo.CRED_1060.PK_BatchSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PAYROLL.dbo.OrdersDaily.PK_ShiftResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
report.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
report.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
report.emp.ForecastStatus.PK_CampaignDetail	1	CLUSTERED	Y	Y		never	2026-07-10 16:50:02	COLD	KEEP — primary key
RECONCILE.inc.Incident.PK_CatalogDaily	1	CLUSTERED	Y	Y		never	2026-07-25 01:00:01	COLD	KEEP — primary key
RECONCILE.inc.Incident.UX_PolicyDetail	2	NONCLUSTERED	Y			never	2026-07-25 01:00:01	COLD	review carefully — unique
RECONCILE.inc.CatalogResult.PK_SettlementAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.CatalogResult.UX_WarehouseStatus	2	NONCLUSTERED	Y			never	2026-07-25 01:00:01	COLD	review carefully — unique
RECONCILE.inc.CampaignDaily.PK_CustomerMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.MeterResult.PK_TicketSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.BookingDetail.PK_BookingHeader	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.BookingDetail.UX_SettlementLog	2	NONCLUSTERED	Y			never	2026-07-25 01:00:01	COLD	review carefully — unique
RECONCILE.inc.AssetSummary.PK_BillingHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.OrdersHeader.PK_SupplierDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.OrdersHeader.UX_TerritoryLine	2	NONCLUSTERED	Y			never	2026-07-25 01:00:01	COLD	review carefully — unique
RECONCILE.inc.TicketLog.PK_CatalogQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.StaffingArchive.PK_RouteArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.ContractHeader.PK_RosterHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.QuotaEntry.PK_ReconcileArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.StaffingQueue.PK_LedgerHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.StaffingQueue.UX_PayrollEntry	2	NONCLUSTERED	Y			never	2026-07-25 01:00:01	COLD	review carefully — unique
RECONCILE.inc.ForecastHistory.PK_LedgerLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
RECONCILE.inc.ShipmentArchive.PK_PolicySnapshot	1	CLUSTERED	Y	Y		never	2025-10-14 16:04:26	COLD	KEEP — primary key
RECONCILE.inc.CampaignDaily.PK_ShiftStaging	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:02	COLD	KEEP — primary key
RECONCILE.inc.RosterArchive.PK_ContractQueue	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:02	COLD	KEEP — primary key
RECONCILE.inc.RosterArchive.UX_InvoiceAudit	2	NONCLUSTERED	Y			never	2026-01-11 01:00:02	COLD	review carefully — unique
RECONCILE.inc.SalesEntry.PK_BillingQueue	1	CLUSTERED	Y	Y		never	2026-05-16 01:00:01	COLD	KEEP — primary key
host-315.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y		never	2026-08-27 01:00:03	COLD	KEEP — primary key
host-315.app.ShiftAudit.UX_PayrollAudit	2	NONCLUSTERED	Y			never	2026-08-27 01:00:03	COLD	review carefully — unique
host-315.app.ShiftAudit.UX_BillingStatus	3	NONCLUSTERED	Y			never	2026-08-27 01:00:03	COLD	review carefully — unique
host-315.app.SettlementEntry.PK_ContractLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		never	2025-12-16 13:09:25	COLD	KEEP — primary key
host-315.app.BillingAudit.PK_PolicyLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:05	COLD	KEEP — primary key
host-315.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		never	2026-08-28 01:00:03	COLD	KEEP — primary key
host-315.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			never	2026-09-15 01:00:05	COLD	review carefully — unique
host-315.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:05	COLD	KEEP — primary key
host-315.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.app.InvoiceLine.UX_BillingLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
host-315.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y		never	2026-08-27 01:00:03	COLD	KEEP — primary key
host-315.app.CatalogMonthly.UX_RouteQueue	2	NONCLUSTERED	Y			never	2026-08-27 01:00:03	COLD	review carefully — unique
host-315.app.ClaimResult.PK_ShipmentStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.bm.PricingQueue.PK_InvoiceArchive	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:05	COLD	KEEP — primary key
host-315.bm.PricingQueue.UX_InvoiceLog	2	NONCLUSTERED	Y			never	2026-09-15 01:00:05	COLD	review carefully — unique
host-315.bm.RosterDetail.PK_QuotaArchive	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:05	COLD	KEEP — primary key
host-315.bm.MeterEntry.PK_CustomerMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.bm.MeterHistory.PK_BillingStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.bm.QuotaEntry.PK_InvoiceAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.bm.OrdersResult.PK_SupplierStaging	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:06	COLD	KEEP — primary key
host-315.bm.OrdersResult.UX_PolicyMonthly	2	NONCLUSTERED	Y			never	2026-09-15 01:00:06	COLD	review carefully — unique
host-315.bm.TicketAudit.PK_WarehouseQueue	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:07	COLD	KEEP — primary key
host-315.bm.TicketLog.PK_SalesStaging	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:07	COLD	KEEP — primary key
host-315.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		never	2025-08-01 01:00:56	COLD	KEEP — primary key
host-315.dbo.BatchResult.PK_PolicySummary	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:08	COLD	KEEP — primary key
host-315.dbo.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		never	2026-09-04 01:00:04	COLD	KEEP — primary key
host-315.dbo.CatalogQueue.UX_ReconcileStaging	2	NONCLUSTERED	Y			never	2026-09-04 01:00:04	COLD	review carefully — unique
host-315.dbo.OrdersAudit.PK_ReconcileStatus	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:08	COLD	KEEP — primary key
host-315.dbo.OrdersAudit.UX_OrdersEntry	2	NONCLUSTERED	Y			never	2026-09-15 01:00:08	COLD	review carefully — unique
host-315.dbo.PricingMonthly.PK_LedgerDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.SettlementResult.PK_ContractResult	1	CLUSTERED	Y	Y		never	2026-07-05 01:00:05	COLD	KEEP — primary key
host-315.flx.InvoiceAudit.PK_CatalogAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.ClaimHeader.PK_SalesStaging	1	CLUSTERED	Y	Y		never	2026-06-19 13:09:33	COLD	KEEP — primary key
host-315.flx.ShiftStaging.PK_PricingHeader	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:09	COLD	KEEP — primary key
host-315.flx.InvoiceLine.PK_SettlementMonthly	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:09	COLD	KEEP — primary key
host-315.flx.InvoiceLine.UQ_LedgerResult	2	NONCLUSTERED	Y			never	2026-09-15 01:00:09	COLD	review carefully — unique
host-315.flx.AssetLog.PK_ContractLine	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:09	COLD	KEEP — primary key
host-315.flx.CustomerLine.IX_SalesEntry	2	NONCLUSTERED				never	2026-09-06 01:00:05	COLD	review, then DROP
host-315.flx.CustomerLine.PK_ClaimAudit	1	CLUSTERED	Y	Y		never	2026-09-06 01:00:05	COLD	KEEP — primary key
host-315.flx.CustomerLine.IX_InvoiceSummary	14	NONCLUSTERED	Y			never	2026-09-06 01:00:05	COLD	review carefully — unique
host-315.flx.BatchSummary.PK_MeterResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.OrdersMonthly.IX_RosterMonthly	6	NONCLUSTERED				never	2026-09-15 01:00:09	COLD	review, then DROP
host-315.flx.OrdersMonthly.PK_PolicySnapshot	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:09	COLD	KEEP — primary key
host-315.flx.SalesLog.PK_ContractAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.PolicyDetail.PK_AssetSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.RosterStatus.PK_TerritoryHistory	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:10	COLD	KEEP — primary key
host-315.flx.ClaimHeader.IX_WarehouseMonthly	15	NONCLUSTERED				never	2026-09-15 01:00:10	COLD	review, then DROP
host-315.flx.ClaimHeader.PK_BatchAudit	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:10	COLD	KEEP — primary key
host-315.flx.ClaimHeader.UX_SupplierDetail	2	NONCLUSTERED	Y			never	2026-09-15 01:00:10	COLD	review carefully — unique
host-315.flx.ShiftArchive.PK_PricingEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.QuotaStatus.PK_SalesResult	1	CLUSTERED	Y	Y		never	2026-09-10 01:00:05	COLD	KEEP — primary key
host-315.flx.SupplierDetail.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.ContractQueue.PK_QuotaEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.PricingHistory.IX_ShiftDaily	2	NONCLUSTERED				never	2026-09-15 01:00:11	COLD	review, then DROP
host-315.flx.PricingHistory.PK_ReconcileHistory	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:11	COLD	KEEP — primary key
host-315.flx.MeterArchive.IX_BatchHeader	2	NONCLUSTERED				never	2026-09-15 01:00:11	COLD	review, then DROP
host-315.flx.MeterArchive.PK_BatchDaily	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:11	COLD	KEEP — primary key
host-315.flx.InvoiceLine.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.BookingLog.PK_CatalogLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.PayrollSnapshot.PK_LedgerResult	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:10	COLD	KEEP — primary key
host-315.flx.SettlementLine.PK_QuotaHistory	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:10	COLD	KEEP — primary key
host-315.flx.SettlementLine.PK_SettlementEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.ShiftLine.PK_StaffingStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.TicketDaily.PK_ContractEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.MeterStaging.PK_CatalogResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.StaffingLine.PK_PolicyHistory	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:11	COLD	KEEP — primary key
host-315.flx.ForecastQueue.PK_BillingEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.QuotaResult.PK_InvoiceArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.CustomerSummary.PK_PricingLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.RouteAudit.PK_ContractStatus	1	CLUSTERED	Y	Y		never	2026-09-06 01:00:05	COLD	KEEP — primary key
host-315.flx.RouteAudit.UX_BookingEntry	2	NONCLUSTERED	Y			never	2026-09-06 01:00:05	COLD	review carefully — unique
host-315.flx.MeterSummary.PK_PolicyResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.ContractDetail.PK_CampaignStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.WarehouseDaily.PK_QuotaLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.TicketStaging.PK_ForecastArchive	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:11	COLD	KEEP — primary key
host-315.flx.TicketStaging.UX_ShipmentStaging	2	NONCLUSTERED	Y			never	2026-09-15 01:00:11	COLD	review carefully — unique
host-315.flx.MeterLine.PK_SettlementStaging	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:11	COLD	KEEP — primary key
host-315.flx.MeterLine.UX_RouteStatus	2	NONCLUSTERED	Y			never	2026-09-15 01:00:12	COLD	review carefully — unique
host-315.flx.TerritoryArchive.PK_OrdersLine	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:12	COLD	KEEP — primary key
host-315.flx.PolicyDaily.PK_RosterResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.PolicyMonthly.PK_PayrollStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.ForecastEntry.IX_AssetEntry	2	NONCLUSTERED				never	2026-08-29 01:00:05	COLD	review, then DROP
host-315.flx.ForecastEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		never	2026-08-29 01:00:05	COLD	KEEP — primary key
host-315.flx.ShiftSnapshot.PK_LedgerMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.flx.ShiftSnapshot.UQ_CatalogDetail	2	NONCLUSTERED	Y			never	2026-06-07 20:13:04	COLD	review carefully — unique
host-315.inv.Inventory.PK_InvoiceSummary	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:12	COLD	KEEP — primary key
host-315.inv.SupplierStatus.PK_PolicySnapshot	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:12	COLD	KEEP — primary key
host-315.inv.SupplierStatus.UX_SalesHeader	6	NONCLUSTERED	Y			never	2026-09-15 01:00:12	COLD	review carefully — unique
host-315.inv.ShipmentDetail.PK_WarehouseSummary	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:13	COLD	KEEP — primary key
host-315.org.BatchDaily.PK_QuotaStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.org.BatchDaily.UX_PricingResult	2	NONCLUSTERED	Y			never	2024-10-05 22:14:24	COLD	review carefully — unique
host-315.po.PO.PK_SettlementDaily	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:13	COLD	KEEP — primary key
host-315.po.PO.UX_TerritoryMonthly	2	NONCLUSTERED	Y			never	2026-09-15 01:00:13	COLD	review carefully — unique
host-315.po.ClaimSummary.PK_BatchSnapshot	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:13	COLD	KEEP — primary key
host-315.po.ClaimSummary.UX_PayrollResult	2	NONCLUSTERED	Y			never	2026-09-15 01:00:13	COLD	review carefully — unique
host-315.po.RosterLog.PK_QuotaDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.po.AssetMonthly.PK_PolicyDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.pto.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.pto.ContractHeader.PK_ContractEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.pto.ContractHeader.UX_SalesResult	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
host-315.pto.SalesHistory.PK_TicketDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.pto.SalesHistory.UX_ContractDetail	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
host-315.pto.ClaimResult.IX_ContractDetail	2	NONCLUSTERED				never	never	COLD	review, then DROP
host-315.pto.ClaimResult.PK_SalesLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.pto.LedgerResult.IX_TerritoryResult	2	NONCLUSTERED				never	never	COLD	review, then DROP
host-315.pto.LedgerResult.PK_TicketArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.pto.ContractEntry.IX_CustomerDaily	2	NONCLUSTERED				never	never	COLD	review, then DROP
host-315.pto.ContractEntry.PK_SettlementDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.ops.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.ops.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.ops.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.audit.SupplierArchive.PK_PolicyQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.audit.CatalogQueue.PK_TicketHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.audit.CampaignLine.PK_MeterStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.audit.TicketLog.PK_ReconcileDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-315.qc.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		never	2026-08-29 01:00:06	COLD	KEEP — primary key
host-315.qc.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:14	COLD	KEEP — primary key
host-315.qc.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:15	COLD	KEEP — primary key
host-315.qc.CampaignSummary.PK_PricingStatus	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:16	COLD	KEEP — primary key
host-347.app.ShiftAudit.PK_SettlementResult	1	CLUSTERED	Y	Y		never	2026-08-20 01:00:08	COLD	KEEP — primary key
host-347.app.ShiftAudit.UX_PayrollAudit	2	NONCLUSTERED	Y			never	2026-08-20 01:00:08	COLD	review carefully — unique
host-347.app.ShiftAudit.UX_BillingStatus	3	NONCLUSTERED	Y			never	2026-08-20 01:00:08	COLD	review carefully — unique
host-347.app.SettlementEntry.PK_ContractLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.app.SupplierLog.PK_SalesDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.app.ReconcileQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.app.App.PK_InvoiceResult	1	CLUSTERED	Y	Y		never	2025-12-16 13:08:59	COLD	KEEP — primary key
host-347.app.BillingAudit.PK_PolicyLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.app.MeterArchive.PK_BillingStaging	1	CLUSTERED	Y	Y		never	2026-08-20 01:00:08	COLD	KEEP — primary key
host-347.app.LedgerDaily.PK_CustomerStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.app.Group.PK_BookingEntry	1	CLUSTERED	Y	Y		never	2026-05-22 01:00:05	COLD	KEEP — primary key
host-347.app.Group.UX_LedgerSummary	2	NONCLUSTERED	Y			never	2026-08-22 01:00:09	COLD	review carefully — unique
host-347.app.ShipmentResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		never	2026-08-22 01:00:09	COLD	KEEP — primary key
host-347.app.TerritoryQueue.PK_SettlementLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.app.InvoiceLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.app.InvoiceLine.UX_BillingLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
host-347.app.CatalogMonthly.PK_ClaimHeader	1	CLUSTERED	Y	Y		never	2026-08-21 01:00:08	COLD	KEEP — primary key
host-347.app.CatalogMonthly.UX_RouteQueue	2	NONCLUSTERED	Y			never	2026-08-21 01:00:08	COLD	review carefully — unique
host-347.app.ClaimResult.PK_ShipmentStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.bm.PricingQueue.PK_InvoiceArchive	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:10	COLD	KEEP — primary key
host-347.bm.PricingQueue.UX_InvoiceLog	2	NONCLUSTERED	Y			never	2026-09-13 01:00:10	COLD	review carefully — unique
host-347.bm.RosterDetail.PK_QuotaArchive	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:11	COLD	KEEP — primary key
host-347.bm.MeterEntry.PK_CustomerMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.bm.MeterHistory.PK_BillingStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.bm.QuotaEntry.PK_InvoiceAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.bm.OrdersResult.PK_SupplierStaging	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:11	COLD	KEEP — primary key
host-347.bm.OrdersResult.UX_PolicyMonthly	2	NONCLUSTERED	Y			never	2026-09-13 01:00:11	COLD	review carefully — unique
host-347.bm.TicketAudit.PK_WarehouseQueue	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:12	COLD	KEEP — primary key
host-347.bm.TicketLog.PK_SalesStaging	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:12	COLD	KEEP — primary key
host-347.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:05	COLD	KEEP — primary key
host-347.dbo.BatchResult.PK_PolicySummary	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:13	COLD	KEEP — primary key
host-347.dbo.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:05	COLD	KEEP — primary key
host-347.dbo.CatalogQueue.UX_ReconcileStaging	2	NONCLUSTERED	Y			never	2026-01-11 01:00:05	COLD	review carefully — unique
host-347.dbo.OrdersAudit.PK_ReconcileStatus	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:13	COLD	KEEP — primary key
host-347.dbo.OrdersAudit.UX_QuotaHeader	9	NONCLUSTERED	Y		Y	never	never	COLD	review carefully — unique
host-347.dbo.OrdersAudit.UX_OrdersEntry	2	NONCLUSTERED	Y			never	2026-09-13 01:00:13	COLD	review carefully — unique
host-347.dbo.PricingMonthly.PK_LedgerDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.BatchQueue.PK_BillingQueue	1	CLUSTERED	Y	Y		never	2026-08-15 11:29:22	COLD	KEEP — primary key
host-347.flx.SettlementResult.PK_ContractResult	1	CLUSTERED	Y	Y		never	2026-08-20 01:00:09	COLD	KEEP — primary key
host-347.flx.InvoiceAudit.PK_CatalogAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.ShiftStaging.PK_PricingHeader	1	CLUSTERED	Y	Y		never	2026-09-12 01:00:10	COLD	KEEP — primary key
host-347.flx.InvoiceLine.PK_SettlementMonthly	1	CLUSTERED	Y	Y		never	2026-08-20 01:00:09	COLD	KEEP — primary key
host-347.flx.InvoiceLine.UQ_LedgerResult	13	NONCLUSTERED	Y			never	2026-09-12 20:43:34	COLD	review carefully — unique
host-347.flx.ContractSummary.UQ_SalesQueue	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
host-347.flx.AssetLog.PK_ContractLine	1	CLUSTERED	Y	Y		never	2026-08-20 01:00:09	COLD	KEEP — primary key
host-347.flx.CustomerLine.IX_SalesEntry	3	NONCLUSTERED				never	2026-09-13 01:00:13	COLD	review, then DROP
host-347.flx.CustomerLine.PK_ClaimAudit	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:13	COLD	KEEP — primary key
host-347.flx.CustomerLine.IX_InvoiceSummary	9	NONCLUSTERED	Y			never	2026-09-13 01:00:13	COLD	review carefully — unique
host-347.flx.BatchSummary.PK_MeterResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.OrdersMonthly.IX_RosterMonthly	6	NONCLUSTERED				never	2026-09-12 01:00:10	COLD	review, then DROP
host-347.flx.OrdersMonthly.PK_PolicySnapshot	1	CLUSTERED	Y	Y		never	2026-09-12 01:00:10	COLD	KEEP — primary key
host-347.flx.SalesLog.PK_ContractAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.PolicyDetail.PK_AssetSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.RosterStatus.PK_TerritoryHistory	1	CLUSTERED	Y	Y		never	2026-09-11 01:00:08	COLD	KEEP — primary key
host-347.flx.ShipmentStaging.PK_CatalogSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.ClaimHeader.IX_WarehouseMonthly	15	NONCLUSTERED				never	2026-08-20 01:00:09	COLD	review, then DROP
host-347.flx.ClaimHeader.PK_BatchAudit	1	CLUSTERED	Y	Y		never	2026-08-20 01:00:09	COLD	KEEP — primary key
host-347.flx.ClaimHeader.UX_SupplierDetail	2	NONCLUSTERED	Y			never	2026-08-20 01:00:09	COLD	review carefully — unique
host-347.flx.ShiftArchive.PK_PricingEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.QuotaStatus.PK_SalesResult	1	CLUSTERED	Y	Y		never	2026-08-25 01:00:19	COLD	KEEP — primary key
host-347.flx.SupplierDetail.PK_ForecastSnapshot	1	CLUSTERED	Y	Y		never	2026-08-25 01:00:19	COLD	KEEP — primary key
host-347.flx.ContractQueue.PK_QuotaEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.PricingHistory.IX_ShiftDaily	2	NONCLUSTERED				never	2026-08-20 01:00:09	COLD	review, then DROP
host-347.flx.PricingHistory.PK_ReconcileHistory	1	CLUSTERED	Y	Y		never	2026-08-20 01:00:09	COLD	KEEP — primary key
host-347.flx.MeterArchive.IX_BatchHeader	7	NONCLUSTERED				never	2026-08-20 01:00:09	COLD	review, then DROP
host-347.flx.MeterArchive.PK_BatchDaily	1	CLUSTERED	Y	Y		never	2026-08-20 01:00:09	COLD	KEEP — primary key
host-347.flx.InvoiceLine.PK_WarehouseSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.BookingLog.PK_CatalogLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.PayrollSnapshot.PK_LedgerResult	1	CLUSTERED	Y	Y		never	2026-09-11 01:00:08	COLD	KEEP — primary key
host-347.flx.SettlementLine.PK_QuotaHistory	1	CLUSTERED	Y	Y		never	2026-09-11 01:00:08	COLD	KEEP — primary key
host-347.flx.SettlementLine.PK_SettlementEntry	1	CLUSTERED	Y	Y		never	2026-09-11 01:00:08	COLD	KEEP — primary key
host-347.flx.ShiftLine.PK_StaffingStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.TicketDaily.PK_ContractEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.MeterStaging.PK_CatalogResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.StaffingLine.PK_PolicyHistory	1	CLUSTERED	Y	Y		never	2026-09-11 01:00:08	COLD	KEEP — primary key
host-347.flx.ForecastQueue.PK_BillingEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.QuotaResult.PK_InvoiceArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.CustomerSummary.PK_PricingLine	1	CLUSTERED	Y	Y		never	2026-09-11 01:00:08	COLD	KEEP — primary key
host-347.flx.RouteAudit.PK_ContractStatus	1	CLUSTERED	Y	Y		never	2026-08-20 01:00:10	COLD	KEEP — primary key
host-347.flx.RouteAudit.UX_BookingEntry	2	NONCLUSTERED	Y			never	2026-09-13 01:00:14	COLD	review carefully — unique
host-347.flx.MeterSummary.PK_PolicyResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.ContractDetail.PK_CampaignStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.WarehouseDaily.PK_QuotaLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.TicketStaging.PK_ForecastArchive	1	CLUSTERED	Y	Y		never	2026-08-20 01:00:10	COLD	KEEP — primary key
host-347.flx.TicketStaging.UX_ShipmentStaging	2	NONCLUSTERED	Y			never	2026-08-20 01:00:10	COLD	review carefully — unique
host-347.flx.MeterLine.PK_SettlementStaging	1	CLUSTERED	Y	Y		never	2026-09-11 01:00:08	COLD	KEEP — primary key
host-347.flx.MeterLine.UX_RouteStatus	2	NONCLUSTERED	Y			never	2026-09-11 01:00:08	COLD	review carefully — unique
host-347.flx.TerritoryArchive.PK_OrdersLine	1	CLUSTERED	Y	Y		never	2026-09-11 01:00:08	COLD	KEEP — primary key
host-347.flx.PolicyDaily.PK_RosterResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.PolicyMonthly.PK_PayrollStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.ForecastEntry.IX_AssetEntry	2	NONCLUSTERED				never	2026-04-09 01:00:05	COLD	review, then DROP
host-347.flx.ForecastEntry.PK_ReconcileSnapshot	1	CLUSTERED	Y	Y		never	2026-04-09 01:00:05	COLD	KEEP — primary key
host-347.flx.ShiftSnapshot.PK_LedgerMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.flx.ShiftSnapshot.UQ_CatalogDetail	2	NONCLUSTERED	Y			never	2026-05-25 08:36:16	COLD	review carefully — unique
host-347.flx.ReconcileHistory.PK_PolicyAudit	1	CLUSTERED	Y	Y		never	2026-08-15 11:29:22	COLD	KEEP — primary key
host-347.inv.Inventory.PK_InvoiceSummary	1	CLUSTERED	Y	Y		never	2026-09-12 01:00:10	COLD	KEEP — primary key
host-347.inv.SupplierStatus.PK_PolicySnapshot	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:14	COLD	KEEP — primary key
host-347.inv.SupplierStatus.UX_SalesHeader	6	NONCLUSTERED	Y			never	2026-09-13 01:00:14	COLD	review carefully — unique
host-347.inv.ShipmentDetail.PK_WarehouseSummary	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:14	COLD	KEEP — primary key
host-347.org.BatchDaily.PK_QuotaStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.org.BatchDaily.UX_PricingResult	2	NONCLUSTERED	Y			never	2024-10-05 22:14:24	COLD	review carefully — unique
host-347.po.PO.PK_SettlementDaily	1	CLUSTERED	Y	Y		never	2026-09-14 01:00:03	COLD	KEEP — primary key
host-347.po.PO.UX_TerritoryMonthly	2	NONCLUSTERED	Y			never	2026-09-14 01:00:03	COLD	review carefully — unique
host-347.po.ClaimSummary.PK_BatchSnapshot	1	CLUSTERED	Y	Y		never	2026-09-14 01:00:03	COLD	KEEP — primary key
host-347.po.ClaimSummary.UX_PayrollResult	2	NONCLUSTERED	Y			never	2026-09-14 01:00:03	COLD	review carefully — unique
host-347.po.RosterLog.PK_QuotaDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.po.AssetMonthly.PK_PolicyDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.pto.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.pto.ContractHeader.PK_ContractEntry	1	CLUSTERED	Y	Y		never	2026-06-07 01:00:06	COLD	KEEP — primary key
host-347.pto.ContractHeader.UX_SalesResult	3	NONCLUSTERED	Y			never	2026-06-07 01:00:06	COLD	review carefully — unique
host-347.pto.SalesHistory.PK_TicketDetail	1	CLUSTERED	Y	Y		never	2026-06-07 01:00:06	COLD	KEEP — primary key
host-347.pto.SalesHistory.UX_ContractDetail	4	NONCLUSTERED	Y			never	2026-06-07 01:00:06	COLD	review carefully — unique
host-347.pto.ClaimResult.IX_ContractDetail	2	NONCLUSTERED				never	2026-06-07 01:00:06	COLD	review, then DROP
host-347.pto.ClaimResult.PK_SalesLine	1	CLUSTERED	Y	Y		never	2026-06-07 01:00:06	COLD	KEEP — primary key
host-347.pto.LedgerResult.IX_TerritoryResult	3	NONCLUSTERED				never	2026-06-11 01:00:05	COLD	review, then DROP
host-347.pto.LedgerResult.PK_TicketArchive	1	CLUSTERED	Y	Y		never	2026-06-11 01:00:05	COLD	KEEP — primary key
host-347.pto.ContractEntry.IX_CustomerDaily	2	NONCLUSTERED				never	2026-06-11 01:00:05	COLD	review, then DROP
host-347.pto.ContractEntry.PK_SettlementDetail	1	CLUSTERED	Y	Y		never	2026-06-11 01:00:05	COLD	KEEP — primary key
host-347.ops.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:06	COLD	KEEP — primary key
host-347.ops.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		never	2026-06-09 01:00:06	COLD	KEEP — primary key
host-347.ops.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.audit.SupplierArchive.PK_PolicyQueue	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:06	COLD	KEEP — primary key
host-347.audit.CatalogQueue.PK_TicketHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.audit.CampaignLine.PK_MeterStaging	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:06	COLD	KEEP — primary key
host-347.audit.TicketLog.PK_ReconcileDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
host-347.qc.TerritoryHistory.PK_RosterDetail	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:06	COLD	KEEP — primary key
host-347.qc.BookingStaging.PK_TicketArchive	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:15	COLD	KEEP — primary key
host-347.qc.BookingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:15	COLD	KEEP — primary key
host-347.qc.CampaignSummary.PK_PricingStatus	1	CLUSTERED	Y	Y		never	2026-09-13 01:00:16	COLD	KEEP — primary key
PPA.ppa.OrdersArchive.IX_QuotaMonthly	2	NONCLUSTERED			Y	never	2026-08-20 01:03:40	COLD	review, then DROP
PPA.ppa.OrdersArchive.PK_BatchLine	1	CLUSTERED	Y	Y		never	2026-08-20 01:03:40	COLD	KEEP — primary key
PPA.ppa.TicketMonthly.PK_RosterDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPA.ppa.SalesLine.PK_LedgerLog	1	CLUSTERED	Y	Y		never	2026-01-25 01:00:22	COLD	KEEP — primary key
PPA.ppa.BillingAudit.PK_ShipmentQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPA.ppa.BookingQueue.PK_ShiftHistory	1	CLUSTERED	Y	Y		never	2026-08-15 01:01:50	COLD	KEEP — primary key
PPA.ppa.ReconcileDetail.PK_QuotaStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPA.ppa.RosterLog.IX_QuotaSummary	2	NONCLUSTERED				never	2026-08-18 01:03:56	COLD	review, then DROP
PPA.ppa.RosterLog.PK_CatalogAudit	1	CLUSTERED	Y	Y		never	2026-08-18 01:03:56	COLD	KEEP — primary key
PPA.ppa.Record.IX_CustomerMonthly	10	NONCLUSTERED				never	2026-08-19 01:06:32	COLD	review, then DROP
PPA.ppa.Record.IX_CampaignMonthly	5	NONCLUSTERED				never	2026-08-19 01:06:32	COLD	review, then DROP
PPA.ppa.Record.PK_CatalogLog	1	CLUSTERED	Y	Y		never	2026-08-19 01:06:31	COLD	KEEP — primary key
PPA.ppa.BillingEntry.PK_BillingEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPA.ppa.TerritoryAudit.PK_ShipmentQueue	1	CLUSTERED	Y	Y		never	2026-08-20 01:03:40	COLD	KEEP — primary key
PPA.ppa.RosterLine.PK_CatalogMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.RouteDetail.IX_SalesResult	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.RouteDetail.PK_ReconcileDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.TicketLine.IX_RosterLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.TicketLine.IX_BookingSnapshot	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.TicketLine.PK_SalesResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.AssetQueue.IX_ForecastSummary	2	NONCLUSTERED	Y			never	2020-08-13 11:15:23	COLD	review carefully — unique
PPG.dbo.AssetQueue.PK_TerritoryQueue	1	CLUSTERED	Y	Y		never	2020-08-13 11:15:23	COLD	KEEP — primary key
PPG.dbo.ContractMonthly.IX_PayrollStaging	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.ContractMonthly.PK_RosterEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.ContractArchive.IX_PolicyDetail	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.ContractArchive.PK_TicketResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.ShipmentHeader.IX_CatalogStatus	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.ShipmentHeader.PK_StaffingHeader	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.ClaimStatus.IX_BookingEntry	2	NONCLUSTERED	Y			never	2026-01-11 01:01:58	COLD	review carefully — unique
PPG.dbo.ClaimStatus.PK_OrdersQueue	1	CLUSTERED	Y	Y		never	2020-08-18 09:28:17	COLD	KEEP — primary key
PPG.dbo.Bin.IX_CustomerResult	2	NONCLUSTERED	Y			never	2026-01-11 01:01:58	COLD	review carefully — unique
PPG.dbo.Bin.PK_InvoiceSummary	1	CLUSTERED	Y	Y		never	2026-01-11 01:01:58	COLD	KEEP — primary key
PPG.dbo.OrdersDetail.IX_PolicyHeader	2	NONCLUSTERED	Y			never	2026-01-11 01:01:58	COLD	review carefully — unique
PPG.dbo.OrdersDetail.PK_AssetArchive	1	CLUSTERED	Y	Y		never	2026-01-11 01:01:58	COLD	KEEP — primary key
PPG.dbo.ForecastLine.PK_LedgerStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.MeterSummary.IX_TerritoryArchive	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.MeterSummary.IX_OrdersArchive	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.MeterSummary.IX_MeterHeader	4	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.MeterSummary.PK_BatchLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.BillingArchive.IX_PricingStatus	2	NONCLUSTERED	Y			never	2020-08-13 11:15:20	COLD	review carefully — unique
PPG.dbo.BillingArchive.IX_CustomerSummary	3	NONCLUSTERED	Y			never	2020-08-13 11:15:20	COLD	review carefully — unique
PPG.dbo.BillingArchive.PK_ForecastStatus	1	CLUSTERED	Y	Y		never	2020-08-13 11:15:20	COLD	KEEP — primary key
PPG.dbo.ContractSummary.IX_QuotaSummary	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.ContractSummary.PK_ContractEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.RouteQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:03	COLD	KEEP — primary key
PPG.dbo.RouteHeader.IX_StaffingStatus	2	NONCLUSTERED	Y			never	2020-07-06 13:37:39	COLD	review carefully — unique
PPG.dbo.RouteHeader.PK_PricingMonthly	1	CLUSTERED	Y	Y		never	2020-07-06 13:37:39	COLD	KEEP — primary key
PPG.dbo.PayrollLog.IX_BookingAudit	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.PayrollLog.PK_ShiftDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.AssetLog.IX_StaffingArchive	2	NONCLUSTERED	Y			never	2026-01-11 01:02:09	COLD	review carefully — unique
PPG.dbo.AssetLog.PK_SalesEntry	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:09	COLD	KEEP — primary key
PPG.dbo.AssetSummary.IX_CustomerLine	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.AssetSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.SalesSummary.IX_InvoiceMonthly	2	NONCLUSTERED	Y			never	2026-01-11 01:02:09	COLD	review carefully — unique
PPG.dbo.SalesSummary.PK_ShiftSummary	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:09	COLD	KEEP — primary key
PPG.dbo.ShipmentArchive.PK_QuotaResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.SupplierLog.IX_TerritoryStaging	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.SupplierLog.PK_WarehouseAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.MeterMonthly.IX_RouteHeader	2	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.MeterMonthly.IX_ForecastEntry	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.MeterMonthly.PK_TerritoryDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.AssetResult.IX_ClaimLog	2	NONCLUSTERED	Y			never	2026-01-11 01:02:09	COLD	review carefully — unique
PPG.dbo.AssetResult.PK_ClaimLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.CatalogLine.IX_QuotaHistory	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.CatalogLine.PK_QuotaMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.LedgerStaging.IX_CatalogStatus	2	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.LedgerStaging.IX_StaffingSnapshot	3	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.LedgerStaging.PK_BookingSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.PricingLine.IX_LedgerDetail	2	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.PricingLine.IX_RosterSummary	3	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.PricingLine.PK_BookingQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.History.IX_PolicyDetail	2	NONCLUSTERED				never	2026-01-11 01:02:11	COLD	review, then DROP
PPG.dbo.History.IX_ContractQueue	3	NONCLUSTERED				never	2026-01-11 01:02:11	COLD	review, then DROP
PPG.dbo.History.IX_OrdersLog	4	NONCLUSTERED				never	2026-01-11 01:02:11	COLD	review, then DROP
PPG.dbo.History.PK_CatalogQueue	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:10	COLD	KEEP — primary key
PPG.dbo.AssetDaily.PK_StaffingHistory	1	CLUSTERED	Y	Y		never	2022-07-01 14:58:16	COLD	KEEP — primary key
PPG.dbo.SettlementArchive.PK_PayrollDaily	1	CLUSTERED	Y	Y		never	2022-07-01 14:58:42	COLD	KEEP — primary key
PPG.dbo.Kit.IX_OrdersArchive	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.Kit.PK_PayrollSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.InvoiceDaily.IX_TerritoryMonthly	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.InvoiceDaily.PK_QuotaDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.SettlementResult.PK_ForecastMonthly	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:12	COLD	KEEP — primary key
PPG.dbo.RouteResult.IX_BillingDetail	2	NONCLUSTERED	Y			never	2026-01-11 01:02:12	COLD	review carefully — unique
PPG.dbo.RouteResult.PK_MeterHeader	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:12	COLD	KEEP — primary key
PPG.dbo.SettlementDetail.IX_RosterResult	2	NONCLUSTERED				never	2026-01-11 01:02:12	COLD	review, then DROP
PPG.dbo.SettlementDetail.IX_PayrollResult	3	NONCLUSTERED				never	2026-01-11 01:02:12	COLD	review, then DROP
PPG.dbo.SettlementDetail.IX_StaffingLog	4	NONCLUSTERED				never	2026-01-11 01:02:12	COLD	review, then DROP
PPG.dbo.SettlementDetail.PK_TicketLine	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:12	COLD	KEEP — primary key
PPG.dbo.PolicyLine.IX_TerritoryHeader	2	NONCLUSTERED	Y			never	2022-07-01 14:59:12	COLD	review carefully — unique
PPG.dbo.PolicyLine.PK_SupplierStatus	1	CLUSTERED	Y	Y		never	2022-07-01 14:59:12	COLD	KEEP — primary key
PPG.dbo.LedgerStatus.IX_CustomerLog	2	NONCLUSTERED	Y			never	2022-07-01 14:59:55	COLD	review carefully — unique
PPG.dbo.LedgerStatus.IX_CampaignQueue	3	NONCLUSTERED				never	2022-07-01 14:59:55	COLD	review, then DROP
PPG.dbo.LedgerStatus.PK_LedgerHeader	1	CLUSTERED	Y	Y		never	2022-07-01 14:59:55	COLD	KEEP — primary key
PPG.dbo.ReconcileHistory.IX_BatchDetail	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.ReconcileHistory.PK_BookingResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.StaffingSnapshot.PK_CustomerLog	1	CLUSTERED	Y	Y		never	2022-07-01 14:55:55	COLD	KEEP — primary key
PPG.dbo.ReconcileStaging.IX_ShipmentStatus	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.ReconcileStaging.PK_ContractStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.CampaignStaging.IX_MeterQueue	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.CampaignStaging.PK_QuotaStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.CampaignLog.IX_CampaignEntry	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.CampaignLog.PK_OrdersSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.PolicyLog.IX_OrdersDaily	2	NONCLUSTERED	Y			never	2022-07-01 14:53:17	COLD	review carefully — unique
PPG.dbo.PolicyLog.PK_ShiftHeader	1	CLUSTERED	Y	Y		never	2022-07-01 14:53:17	COLD	KEEP — primary key
PPG.dbo.SupplierSnapshot.IX_AssetSummary	2	NONCLUSTERED	Y			never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.SupplierSnapshot.PK_RosterStaging	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:12	COLD	KEEP — primary key
PPG.dbo.WarehouseHistory.IX_PayrollDaily	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.WarehouseHistory.PK_PricingEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.PayrollStatus.IX_ContractQueue	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.PayrollStatus.PK_SalesResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.BillingDetail.IX_CampaignLine	2	NONCLUSTERED	Y			never	2026-01-11 01:02:12	COLD	review carefully — unique
PPG.dbo.BillingDetail.PK_ReconcileHeader	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:12	COLD	KEEP — primary key
PPG.dbo.ShiftHeader.PK_ReconcileHeader	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:12	COLD	KEEP — primary key
PPG.dbo.AssetQueue.IX_PricingLog	5	NONCLUSTERED	Y			never	2026-01-11 01:02:12	COLD	review carefully — unique
PPG.dbo.AssetQueue.PK_PricingMonthly	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:12	COLD	KEEP — primary key
PPG.dbo.WarehouseAudit.IX_WarehouseEntry	3	NONCLUSTERED	Y			never	2026-01-11 01:02:12	COLD	review carefully — unique
PPG.dbo.WarehouseAudit.PK_ReconcileAudit	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:12	COLD	KEEP — primary key
PPG.dbo.SettlementHistory.IX_TerritoryStaging	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.SettlementHistory.PK_ForecastLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.AssetResult.PK_BillingSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.CustomerSummary.IX_BatchAudit	2	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.CustomerSummary.PK_SupplierMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.QuotaAudit.IX_OrdersAudit	2	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.QuotaAudit.IX_TerritoryMonthly	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.QuotaAudit.PK_ShiftSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.ClaimSnapshot.IX_TicketHeader	2	NONCLUSTERED	Y			never	2026-01-11 01:02:13	COLD	review carefully — unique
PPG.dbo.ClaimSnapshot.PK_ClaimEntry	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:13	COLD	KEEP — primary key
PPG.dbo.ReconcileDaily.IX_StaffingHistory	2	NONCLUSTERED	Y			never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.ReconcileDaily.PK_RosterResult	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:13	COLD	KEEP — primary key
PPG.dbo.MeterQueue.IX_OrdersMonthly	2	NONCLUSTERED	Y			never	2020-08-13 11:15:19	COLD	review carefully — unique
PPG.dbo.MeterQueue.PK_ReconcileArchive	1	CLUSTERED	Y	Y		never	2020-08-13 11:15:19	COLD	KEEP — primary key
PPG.dbo.OrdersDetail.IX_WarehouseResult	2	NONCLUSTERED	Y			never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.OrdersDetail.IX_LedgerDaily	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.OrdersDetail.PK_LedgerResult	1	CLUSTERED	Y	Y		never	2020-08-27 09:42:38	COLD	KEEP — primary key
PPG.dbo.Task.IX_PayrollDaily	2	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.Task.PK_ShipmentLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.InvoiceAudit.IX_RouteArchive	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.InvoiceAudit.PK_CustomerLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.TicketDaily.IX_RouteMonthly	2	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.TicketDaily.PK_TerritoryLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.ContractAudit.IX_ShiftSummary	2	NONCLUSTERED	Y			never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.ContractAudit.PK_InvoiceArchive	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:13	COLD	KEEP — primary key
PPG.dbo.TerritorySnapshot.IX_QuotaHeader	2	NONCLUSTERED	Y			never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.TerritorySnapshot.IX_SupplierEntry	3	NONCLUSTERED				never	2020-09-11 11:20:48	COLD	review, then DROP
PPG.dbo.TerritorySnapshot.PK_SalesHeader	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:13	COLD	KEEP — primary key
PPG.dbo.SupplierHistory.PK_ContractLine	1	CLUSTERED	Y	Y		never	2026-01-11 01:02:13	COLD	KEEP — primary key
PPG.dbo.OrdersResult.IX_BookingLog	2	NONCLUSTERED	Y			never	2020-09-11 11:20:48	COLD	review carefully — unique
PPG.dbo.OrdersResult.PK_AssetLine	1	CLUSTERED	Y	Y		never	2020-08-13 14:55:16	COLD	KEEP — primary key
PPG.dbo.CustomerSummary.IX_OrdersDaily	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.CustomerSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.CustomerEntry.IX_SupplierQueue	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.CustomerEntry.PK_InvoiceDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.MeterLog.IX_AssetEntry	2	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_RosterDaily	3	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_TicketLog	4	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.MeterLog.IX_RosterHistory	5	NONCLUSTERED				never	never	COLD	review, then DROP
PPG.dbo.MeterLog.PK_QuotaMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
PPG.dbo.WarehouseEntry.IX_BatchHeader	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
PPG.dbo.WarehouseEntry.PK_CampaignStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.ContractEntry.PK_SettlementStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.ForecastHistory.PK_SupplierSnapshot	1	CLUSTERED	Y	Y		never	2026-09-15 01:00:25	COLD	KEEP — primary key
SALES.dbo.SupplierDaily.PK_LedgerAudit	1	CLUSTERED	Y	Y		never	2025-06-19 12:57:43	COLD	KEEP — primary key
SALES.dbo.RouteDetail.IX_SalesResult	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.RouteDetail.PK_ReconcileDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.TicketLine.IX_RosterLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.TicketLine.IX_BookingSnapshot	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.TicketLine.PK_SalesResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.AssetQueue.IX_ForecastSummary	2	NONCLUSTERED	Y			never	2025-06-19 12:55:51	COLD	review carefully — unique
SALES.dbo.AssetQueue.PK_TerritoryQueue	1	CLUSTERED	Y	Y		never	2025-06-19 12:55:51	COLD	KEEP — primary key
SALES.dbo.ContractMonthly.IX_PayrollStaging	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.ContractMonthly.PK_RosterEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.ContractArchive.IX_PolicyDetail	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.ContractArchive.PK_TicketResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.ShipmentHeader.IX_CatalogStatus	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.ShipmentHeader.PK_StaffingHeader	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.ClaimStatus.IX_BookingEntry	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.ClaimStatus.PK_OrdersQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.PolicySummary.PK_SupplierDetail	1	CLUSTERED	Y	Y		never	2025-06-19 12:57:44	COLD	KEEP — primary key
SALES.dbo.Bin.IX_CustomerResult	2	NONCLUSTERED	Y			never	2025-06-19 12:57:44	COLD	review carefully — unique
SALES.dbo.Bin.PK_InvoiceSummary	1	CLUSTERED	Y	Y		never	2025-06-19 12:57:44	COLD	KEEP — primary key
SALES.dbo.OrdersDetail.IX_PolicyHeader	2	NONCLUSTERED	Y			never	2025-06-19 12:57:44	COLD	review carefully — unique
SALES.dbo.OrdersDetail.PK_AssetArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.ForecastLine.PK_LedgerStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.MeterSummary.IX_TerritoryArchive	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.MeterSummary.IX_OrdersArchive	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.MeterSummary.IX_MeterHeader	4	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.MeterSummary.PK_BatchLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.BillingArchive.IX_PricingStatus	2	NONCLUSTERED	Y			never	2025-06-19 12:57:44	COLD	review carefully — unique
SALES.dbo.BillingArchive.IX_CustomerSummary	3	NONCLUSTERED	Y			never	2025-06-19 12:57:44	COLD	review carefully — unique
SALES.dbo.BillingArchive.PK_ForecastStatus	1	CLUSTERED	Y	Y		never	2025-06-19 12:57:44	COLD	KEEP — primary key
SALES.dbo.ContractSummary.IX_QuotaSummary	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.ContractSummary.PK_ContractEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.RouteQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.RouteHeader.IX_StaffingStatus	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.RouteHeader.PK_PricingMonthly	1	CLUSTERED	Y	Y		never	2022-05-31 16:13:23	COLD	KEEP — primary key
SALES.dbo.PayrollLog.IX_BookingAudit	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.PayrollLog.PK_ShiftDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.AssetLog.IX_StaffingArchive	2	NONCLUSTERED	Y			never	2025-06-19 12:57:44	COLD	review carefully — unique
SALES.dbo.AssetLog.PK_SalesEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.AssetSummary.IX_CustomerLine	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.AssetSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.Dashboard.IX_BatchMonthly	1	CLUSTERED	Y			never	2026-09-15 01:00:28	COLD	KEEP — table storage
SALES.dbo.Dashboard.IX_ContractDaily	25	NONCLUSTERED				never	2026-09-15 01:00:46	COLD	review, then DROP
SALES.dbo.Dashboard.IX_BatchMonthly	23	NONCLUSTERED				never	2026-09-15 01:00:48	COLD	review, then DROP
SALES.dbo.Dashboard.IX_ShipmentMonthly	18	NONCLUSTERED				never	2026-09-15 01:00:59	COLD	review, then DROP
SALES.dbo.Dashboard.IX_SupplierDaily	22	NONCLUSTERED				never	2026-09-15 01:01:07	COLD	review, then DROP
SALES.dbo.Dashboard.IX_BookingArchive	24	NONCLUSTERED				never	2026-09-15 01:02:53	COLD	review, then DROP
SALES.dbo.SalesSummary.IX_InvoiceMonthly	2	NONCLUSTERED	Y			never	2025-06-19 13:05:14	COLD	review carefully — unique
SALES.dbo.SalesSummary.PK_ShiftSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.ShipmentArchive.PK_QuotaResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.SupplierLog.IX_TerritoryStaging	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.SupplierLog.PK_WarehouseAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.MeterMonthly.IX_RouteHeader	2	NONCLUSTERED				never	never	COLD	review, then DROP
SALES.dbo.MeterMonthly.IX_ForecastEntry	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.MeterMonthly.PK_TerritoryDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.AssetResult.IX_ClaimLog	2	NONCLUSTERED	Y			never	2025-06-19 13:05:14	COLD	review carefully — unique
SALES.dbo.AssetResult.PK_ClaimLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.CatalogLine.IX_QuotaHistory	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.CatalogLine.PK_QuotaMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.LedgerStaging.IX_CatalogStatus	2	NONCLUSTERED				never	never	COLD	review, then DROP
SALES.dbo.LedgerStaging.IX_StaffingSnapshot	3	NONCLUSTERED				never	never	COLD	review, then DROP
SALES.dbo.LedgerStaging.PK_BookingSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.PricingLine.IX_LedgerDetail	2	NONCLUSTERED				never	never	COLD	review, then DROP
SALES.dbo.PricingLine.IX_RosterSummary	3	NONCLUSTERED				never	never	COLD	review, then DROP
SALES.dbo.PricingLine.PK_BookingQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.History.IX_PolicyDetail	2	NONCLUSTERED				never	2026-01-11 01:00:46	COLD	review, then DROP
SALES.dbo.History.IX_ContractQueue	3	NONCLUSTERED				never	2026-01-11 01:00:49	COLD	review, then DROP
SALES.dbo.History.IX_OrdersLog	4	NONCLUSTERED				never	2026-01-11 01:00:50	COLD	review, then DROP
SALES.dbo.History.PK_CatalogQueue	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:45	COLD	KEEP — primary key
SALES.dbo.AssetDaily.PK_StaffingHistory	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:51	COLD	KEEP — primary key
SALES.dbo.SettlementArchive.PK_PayrollDaily	1	CLUSTERED	Y	Y		never	2026-01-11 01:00:51	COLD	KEEP — primary key
SALES.dbo.Kit.IX_OrdersArchive	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.Kit.PK_PayrollSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.InvoiceDaily.IX_TerritoryMonthly	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.InvoiceDaily.PK_QuotaDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.SettlementResult.PK_ForecastMonthly	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:21	COLD	KEEP — primary key
SALES.dbo.RouteResult.IX_BillingDetail	2	NONCLUSTERED	Y			never	2025-06-19 13:05:22	COLD	review carefully — unique
SALES.dbo.RouteResult.PK_MeterHeader	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:22	COLD	KEEP — primary key
SALES.dbo.SettlementDetail.IX_RosterResult	2	NONCLUSTERED				never	2025-06-19 13:05:21	COLD	review, then DROP
SALES.dbo.SettlementDetail.IX_PayrollResult	3	NONCLUSTERED				never	2025-06-19 13:05:21	COLD	review, then DROP
SALES.dbo.SettlementDetail.IX_StaffingLog	4	NONCLUSTERED				never	2025-06-19 13:05:21	COLD	review, then DROP
SALES.dbo.SettlementDetail.PK_TicketLine	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:21	COLD	KEEP — primary key
SALES.dbo.InvoiceEntry.PK_StaffingHistory	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:21	COLD	KEEP — primary key
SALES.dbo.InvoiceEntry.UX_ForecastSummary	6	NONCLUSTERED	Y			never	2026-09-14 06:10:00	COLD	review carefully — unique
SALES.dbo.ForecastQueue.PK_ShipmentHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.PolicyLine.IX_TerritoryHeader	2	NONCLUSTERED	Y			never	2025-06-19 13:05:22	COLD	review carefully — unique
SALES.dbo.PolicyLine.PK_SupplierStatus	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:22	COLD	KEEP — primary key
SALES.dbo.LedgerStatus.IX_CustomerLog	2	NONCLUSTERED	Y			never	2025-06-19 13:05:22	COLD	review carefully — unique
SALES.dbo.LedgerStatus.IX_CampaignQueue	3	NONCLUSTERED				never	2025-06-19 13:05:22	COLD	review, then DROP
SALES.dbo.LedgerStatus.PK_LedgerHeader	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:22	COLD	KEEP — primary key
SALES.dbo.ReconcileHistory.IX_BatchDetail	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.ReconcileHistory.PK_BookingResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.StaffingSnapshot.PK_CustomerLog	1	CLUSTERED	Y	Y		never	2026-09-15 01:02:59	COLD	KEEP — primary key
SALES.dbo.ReconcileStaging.IX_ShipmentStatus	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.ReconcileStaging.PK_ContractStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.CampaignStaging.IX_MeterQueue	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.CampaignStaging.PK_QuotaStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.CampaignLog.IX_CampaignEntry	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.CampaignLog.PK_OrdersSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.PolicyLog.IX_OrdersDaily	2	NONCLUSTERED	Y			never	2026-09-15 01:03:02	COLD	review carefully — unique
SALES.dbo.PolicyLog.PK_ShiftHeader	1	CLUSTERED	Y	Y		never	2026-09-15 01:03:02	COLD	KEEP — primary key
SALES.dbo.SupplierSnapshot.IX_AssetSummary	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.SupplierSnapshot.PK_RosterStaging	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:24	COLD	KEEP — primary key
SALES.dbo.WarehouseHistory.IX_PayrollDaily	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.WarehouseHistory.PK_PricingEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.PayrollStatus.IX_ContractQueue	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.PayrollStatus.PK_SalesResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.BillingDetail.IX_CampaignLine	2	NONCLUSTERED	Y			never	2026-09-15 01:03:07	COLD	review carefully — unique
SALES.dbo.BillingDetail.PK_ReconcileHeader	1	CLUSTERED	Y	Y		never	2026-09-15 01:03:06	COLD	KEEP — primary key
SALES.dbo.QuotaHeader.PK_ContractLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.WarehouseSnapshot.PK_BookingLog	1	CLUSTERED	Y	Y		never	2026-09-15 01:03:07	COLD	KEEP — primary key
SALES.dbo.ShiftHeader.PK_ReconcileHeader	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:25	COLD	KEEP — primary key
SALES.dbo.AssetQueue.IX_PricingLog	2	NONCLUSTERED	Y			never	2025-06-19 13:05:25	COLD	review carefully — unique
SALES.dbo.AssetQueue.PK_PricingMonthly	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:25	COLD	KEEP — primary key
SALES.dbo.WarehouseAudit.IX_WarehouseEntry	2	NONCLUSTERED	Y			never	2026-09-15 01:03:07	COLD	review carefully — unique
SALES.dbo.WarehouseAudit.PK_ReconcileAudit	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:25	COLD	KEEP — primary key
SALES.dbo.SettlementHistory.IX_TerritoryStaging	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.SettlementHistory.PK_ForecastLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.AssetResult.PK_BillingSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.CustomerSummary.IX_BatchAudit	2	NONCLUSTERED				never	never	COLD	review, then DROP
SALES.dbo.CustomerSummary.PK_SupplierMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.QuotaAudit.IX_OrdersAudit	2	NONCLUSTERED				never	never	COLD	review, then DROP
SALES.dbo.QuotaAudit.IX_TerritoryMonthly	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.QuotaAudit.PK_ShiftSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.ClaimSnapshot.IX_TicketHeader	2	NONCLUSTERED	Y			never	2023-11-01 08:22:19	COLD	review carefully — unique
SALES.dbo.ClaimSnapshot.PK_ClaimEntry	1	CLUSTERED	Y	Y		never	2023-11-01 08:22:19	COLD	KEEP — primary key
SALES.dbo.ReconcileDaily.IX_StaffingHistory	2	NONCLUSTERED	Y			never	2025-06-19 13:05:30	COLD	review carefully — unique
SALES.dbo.ReconcileDaily.PK_RosterResult	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:30	COLD	KEEP — primary key
SALES.dbo.MeterQueue.IX_OrdersMonthly	2	NONCLUSTERED	Y			never	2025-06-19 13:05:30	COLD	review carefully — unique
SALES.dbo.MeterQueue.PK_ReconcileArchive	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:30	COLD	KEEP — primary key
SALES.dbo.OrdersDetail.IX_WarehouseResult	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.OrdersDetail.IX_LedgerDaily	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.OrdersDetail.PK_LedgerResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.Task.IX_PayrollDaily	2	NONCLUSTERED				never	2025-06-19 13:05:30	COLD	review, then DROP
SALES.dbo.Task.PK_ShipmentLine	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:30	COLD	KEEP — primary key
SALES.dbo.InvoiceAudit.IX_RouteArchive	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.InvoiceAudit.PK_CustomerLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.TicketDaily.IX_RouteMonthly	2	NONCLUSTERED				never	never	COLD	review, then DROP
SALES.dbo.TicketDaily.PK_TerritoryLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.ContractAudit.IX_ShiftSummary	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.ContractAudit.PK_InvoiceArchive	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:30	COLD	KEEP — primary key
SALES.dbo.TerritorySnapshot.IX_QuotaHeader	2	NONCLUSTERED	Y			never	2023-11-24 07:37:19	COLD	review carefully — unique
SALES.dbo.TerritorySnapshot.IX_SupplierEntry	3	NONCLUSTERED				never	2023-11-24 07:37:19	COLD	review, then DROP
SALES.dbo.TerritorySnapshot.PK_SalesHeader	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:30	COLD	KEEP — primary key
SALES.dbo.SupplierHistory.PK_ContractLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.OrdersResult.IX_BookingLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.OrdersResult.PK_AssetLine	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:31	COLD	KEEP — primary key
SALES.dbo.CustomerSummary.IX_OrdersDaily	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.CustomerSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:31	COLD	KEEP — primary key
SALES.dbo.CustomerEntry.IX_SupplierQueue	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.CustomerEntry.PK_InvoiceDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.MeterLog.IX_AssetEntry	2	NONCLUSTERED				never	2025-06-19 13:05:31	COLD	review, then DROP
SALES.dbo.MeterLog.IX_RosterDaily	3	NONCLUSTERED				never	2025-06-19 13:05:31	COLD	review, then DROP
SALES.dbo.MeterLog.IX_TicketLog	4	NONCLUSTERED				never	2025-06-19 13:05:31	COLD	review, then DROP
SALES.dbo.MeterLog.IX_RosterHistory	5	NONCLUSTERED				never	2025-06-19 13:05:31	COLD	review, then DROP
SALES.dbo.MeterLog.PK_QuotaMonthly	1	CLUSTERED	Y	Y		never	2025-06-19 13:05:31	COLD	KEEP — primary key
SALES.dbo.WarehouseEntry.IX_BatchHeader	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.dbo.WarehouseEntry.PK_CampaignStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.QuotaResult.PK_ReconcileDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.dbo.QuotaResult.IX_BillingLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
SALES.kar.Bin.PK_InvoiceSummary	1	CLUSTERED	Y	Y		never	2025-02-25 14:34:51	COLD	KEEP — primary key
SALES.kar.Bin.UX_PayrollAudit	2	NONCLUSTERED	Y			never	2025-06-19 13:05:31	COLD	review carefully — unique
SALES.kar.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.kar.ContractStaging.PK_CustomerSummary	1	CLUSTERED	Y	Y		never	2026-09-15 01:03:11	COLD	KEEP — primary key
SALES.kar.RosterSummary.IX_PricingDetail	2	NONCLUSTERED				never	2026-09-15 01:03:17	COLD	review, then DROP
SALES.kar.RosterSummary.IX_InvoiceDaily	9	NONCLUSTERED			Y	never	never	COLD	review, then DROP
SALES.kar.RosterSummary.PK_AssetAudit	1	CLUSTERED	Y	Y		never	2026-09-15 01:03:12	COLD	KEEP — primary key
SALES.kar.SupplierArchive.IX_SettlementLine	9	NONCLUSTERED				never	2026-09-15 01:03:22	COLD	review, then DROP
SALES.kar.SupplierArchive.PK_QuotaSnapshot	1	CLUSTERED	Y	Y		never	2026-09-15 01:03:22	COLD	KEEP — primary key
SALES.kar.ClaimResult.IX_ContractHistory	9	NONCLUSTERED				never	2026-09-15 01:03:24	COLD	review, then DROP
SALES.kar.ClaimResult.IX_QuotaSnapshot	8	NONCLUSTERED				never	2026-09-15 01:03:24	COLD	review, then DROP
SALES.kar.ClaimResult.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		never	2026-09-15 01:03:24	COLD	KEEP — primary key
SALES.kar.RosterDaily.IX_ClaimSummary	12	NONCLUSTERED				never	2026-09-15 01:03:34	COLD	review, then DROP
SALES.kar.RosterDaily.IX_RouteDetail	16	NONCLUSTERED			Y	never	2026-09-15 01:03:34	COLD	review, then DROP
SALES.kar.RosterDaily.IX_CampaignStatus	19	NONCLUSTERED			Y	never	never	COLD	review, then DROP
SALES.kar.RosterDaily.PK_BillingAudit	1	CLUSTERED	Y	Y		never	2026-09-15 01:03:27	COLD	KEEP — primary key
SALES.kar.LedgerHeader.PK_TerritoryResult	1	CLUSTERED	Y	Y		never	2026-09-15 01:03:35	COLD	KEEP — primary key
SALES.kar.LedgerLog.IX_PricingAudit	9	NONCLUSTERED				never	2025-03-07 15:46:11	COLD	review, then DROP
SALES.kar.SalesLine.PK_LedgerLog	1	CLUSTERED	Y	Y		never	2025-03-13 13:09:59	COLD	KEEP — primary key
SALES.kar.SalesLine.UX_OrdersStatus	4	NONCLUSTERED	Y			never	2025-04-11 12:42:09	COLD	review carefully — unique
SALES.kar.ClaimDetail.PK_TicketStatus	1	CLUSTERED	Y	Y		never	2026-09-15 01:03:35	COLD	KEEP — primary key
SALES.kar.PayrollResult.PK_WarehouseDetail	1	CLUSTERED	Y	Y		never	2025-10-03 01:00:48	COLD	KEEP — primary key
SALES.kar.AssetHeader.PK_BillingSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
SALES.kar.SettlementLog.PK_MeterDaily	1	CLUSTERED	Y	Y		never	2026-09-15 01:04:17	COLD	KEEP — primary key
BATCH_Test.dbo.ContractResult.PK_CampaignResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.SettlementStaging.PK_TicketStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ContractEntry.PK_SettlementStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ForecastHistory.PK_SupplierSnapshot	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:07	COLD	KEEP — primary key
BATCH_Test.dbo.SupplierDaily.PK_LedgerAudit	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:12	COLD	KEEP — primary key
BATCH_Test.dbo.RouteDetail.IX_SalesResult	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.RouteDetail.PK_ReconcileDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.TicketLine.IX_RosterLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.TicketLine.IX_BookingSnapshot	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.TicketLine.PK_SalesResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.AssetQueue.IX_ForecastSummary	2	NONCLUSTERED	Y			never	2025-06-19 13:12:29	COLD	review carefully — unique
BATCH_Test.dbo.AssetQueue.PK_TerritoryQueue	1	CLUSTERED	Y	Y		never	2025-06-19 13:12:29	COLD	KEEP — primary key
BATCH_Test.dbo.ContractMonthly.IX_PayrollStaging	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.ContractMonthly.PK_RosterEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ContractArchive.IX_PolicyDetail	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.ContractArchive.PK_TicketResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ShipmentHeader.IX_CatalogStatus	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.ShipmentHeader.PK_StaffingHeader	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ClaimStatus.IX_BookingEntry	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.ClaimStatus.PK_OrdersQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.PolicySummary.PK_SupplierDetail	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:14	COLD	KEEP — primary key
BATCH_Test.dbo.Bin.IX_CustomerResult	2	NONCLUSTERED	Y			never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.Bin.PK_InvoiceSummary	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:14	COLD	KEEP — primary key
BATCH_Test.dbo.OrdersDetail.IX_PolicyHeader	2	NONCLUSTERED	Y			never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.OrdersDetail.PK_AssetArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ForecastLine.PK_LedgerStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.MeterSummary.IX_TerritoryArchive	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.MeterSummary.IX_OrdersArchive	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.MeterSummary.IX_MeterHeader	4	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.MeterSummary.PK_BatchLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.BillingArchive.IX_PricingStatus	2	NONCLUSTERED	Y			never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.BillingArchive.IX_CustomerSummary	3	NONCLUSTERED	Y			never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.BillingArchive.PK_ForecastStatus	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:14	COLD	KEEP — primary key
BATCH_Test.dbo.ContractSummary.IX_QuotaSummary	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.ContractSummary.PK_ContractEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.RouteQueue.PK_RosterQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.RouteHeader.IX_StaffingStatus	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.RouteHeader.PK_PricingMonthly	1	CLUSTERED	Y	Y		never	2022-05-31 16:13:23	COLD	KEEP — primary key
BATCH_Test.dbo.PayrollLog.IX_BookingAudit	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.PayrollLog.PK_ShiftDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.AssetLog.IX_StaffingArchive	2	NONCLUSTERED	Y			never	2025-06-19 13:13:14	COLD	review carefully — unique
BATCH_Test.dbo.AssetLog.PK_SalesEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.AssetSummary.IX_CustomerLine	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.AssetSummary.PK_TicketStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.Dashboard.IX_BatchMonthly	1	CLUSTERED	Y			never	2026-06-04 01:04:27	COLD	KEEP — table storage
BATCH_Test.dbo.Dashboard.IX_ContractDaily	11	NONCLUSTERED				never	2026-06-04 01:05:04	COLD	review, then DROP
BATCH_Test.dbo.Dashboard.IX_BatchMonthly	12	NONCLUSTERED				never	2026-06-04 01:05:04	COLD	review, then DROP
BATCH_Test.dbo.Dashboard.IX_ShipmentMonthly	13	NONCLUSTERED				never	2026-06-04 01:05:04	COLD	review, then DROP
BATCH_Test.dbo.Dashboard.IX_SupplierDaily	14	NONCLUSTERED				never	2026-06-04 01:05:05	COLD	review, then DROP
BATCH_Test.dbo.Dashboard.IX_BookingArchive	15	NONCLUSTERED				never	2026-06-04 01:05:06	COLD	review, then DROP
BATCH_Test.dbo.SalesSummary.IX_InvoiceMonthly	2	NONCLUSTERED	Y			never	2025-06-19 13:13:23	COLD	review carefully — unique
BATCH_Test.dbo.SalesSummary.PK_ShiftSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ShipmentArchive.PK_QuotaResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.SupplierLog.IX_TerritoryStaging	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.SupplierLog.PK_WarehouseAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.MeterMonthly.IX_RouteHeader	2	NONCLUSTERED				never	never	COLD	review, then DROP
BATCH_Test.dbo.MeterMonthly.IX_ForecastEntry	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.MeterMonthly.PK_TerritoryDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.AssetResult.IX_ClaimLog	2	NONCLUSTERED	Y			never	2025-06-19 13:13:23	COLD	review carefully — unique
BATCH_Test.dbo.AssetResult.PK_ClaimLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.CatalogLine.IX_QuotaHistory	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.CatalogLine.PK_QuotaMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.LedgerStaging.IX_CatalogStatus	2	NONCLUSTERED				never	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStaging.IX_StaffingSnapshot	3	NONCLUSTERED				never	never	COLD	review, then DROP
BATCH_Test.dbo.LedgerStaging.PK_BookingSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.PricingLine.IX_LedgerDetail	2	NONCLUSTERED				never	never	COLD	review, then DROP
BATCH_Test.dbo.PricingLine.IX_RosterSummary	3	NONCLUSTERED				never	never	COLD	review, then DROP
BATCH_Test.dbo.PricingLine.PK_BookingQueue	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.History.IX_PolicyDetail	2	NONCLUSTERED				never	2025-04-11 10:33:55	COLD	review, then DROP
BATCH_Test.dbo.History.IX_ContractQueue	3	NONCLUSTERED				never	2025-04-11 10:34:08	COLD	review, then DROP
BATCH_Test.dbo.History.IX_OrdersLog	4	NONCLUSTERED				never	2025-04-11 10:34:14	COLD	review, then DROP
BATCH_Test.dbo.History.PK_CatalogQueue	1	CLUSTERED	Y	Y		never	2026-01-11 01:01:48	COLD	KEEP — primary key
BATCH_Test.dbo.AssetDaily.PK_StaffingHistory	1	CLUSTERED	Y	Y		never	2026-01-11 01:01:50	COLD	KEEP — primary key
BATCH_Test.dbo.SettlementArchive.PK_PayrollDaily	1	CLUSTERED	Y	Y		never	2026-01-11 01:01:53	COLD	KEEP — primary key
BATCH_Test.dbo.Kit.IX_OrdersArchive	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.Kit.PK_PayrollSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.InvoiceDaily.IX_TerritoryMonthly	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.InvoiceDaily.PK_QuotaDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.SettlementResult.PK_ForecastMonthly	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.RouteResult.IX_BillingDetail	2	NONCLUSTERED	Y			never	2025-06-19 13:13:30	COLD	review carefully — unique
BATCH_Test.dbo.RouteResult.PK_MeterHeader	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.SettlementDetail.IX_RosterResult	2	NONCLUSTERED				never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.IX_PayrollResult	3	NONCLUSTERED				never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.IX_StaffingLog	4	NONCLUSTERED				never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.SettlementDetail.PK_TicketLine	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.InvoiceEntry.PK_StaffingHistory	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.InvoiceEntry.UX_ForecastSummary	6	NONCLUSTERED	Y			never	2025-04-05 06:10:01	COLD	review carefully — unique
BATCH_Test.dbo.ForecastQueue.PK_ShipmentHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.PolicyLine.IX_TerritoryHeader	2	NONCLUSTERED	Y			never	2025-06-19 13:13:30	COLD	review carefully — unique
BATCH_Test.dbo.PolicyLine.PK_SupplierStatus	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.LedgerStatus.IX_CustomerLog	2	NONCLUSTERED	Y			never	2025-06-19 13:13:30	COLD	review carefully — unique
BATCH_Test.dbo.LedgerStatus.IX_CampaignQueue	3	NONCLUSTERED				never	2025-06-19 13:13:30	COLD	review, then DROP
BATCH_Test.dbo.LedgerStatus.PK_LedgerHeader	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:30	COLD	KEEP — primary key
BATCH_Test.dbo.ReconcileHistory.IX_BatchDetail	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.ReconcileHistory.PK_BookingResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.StaffingSnapshot.PK_CustomerLog	1	CLUSTERED	Y	Y		never	2026-01-11 01:01:54	COLD	KEEP — primary key
BATCH_Test.dbo.ReconcileStaging.IX_ShipmentStatus	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.ReconcileStaging.PK_ContractStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.CampaignStaging.IX_MeterQueue	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.CampaignStaging.PK_QuotaStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.CampaignLog.IX_CampaignEntry	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.CampaignLog.PK_OrdersSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.PolicyLog.IX_OrdersDaily	2	NONCLUSTERED	Y			never	2025-06-19 13:13:31	COLD	review carefully — unique
BATCH_Test.dbo.PolicyLog.PK_ShiftHeader	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:31	COLD	KEEP — primary key
BATCH_Test.dbo.SupplierSnapshot.IX_AssetSummary	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.SupplierSnapshot.PK_RosterStaging	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.WarehouseHistory.IX_PayrollDaily	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.WarehouseHistory.PK_PricingEntry	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.PayrollStatus.IX_ContractQueue	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.PayrollStatus.PK_SalesResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.BillingDetail.IX_CampaignLine	2	NONCLUSTERED	Y			never	2025-06-19 13:13:32	COLD	review carefully — unique
BATCH_Test.dbo.BillingDetail.PK_ReconcileHeader	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.QuotaHeader.PK_ContractLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.WarehouseSnapshot.PK_BookingLog	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.ShiftHeader.PK_ReconcileHeader	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.AssetQueue.IX_PricingLog	2	NONCLUSTERED	Y			never	2025-06-19 13:13:32	COLD	review carefully — unique
BATCH_Test.dbo.AssetQueue.PK_PricingMonthly	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.WarehouseAudit.IX_WarehouseEntry	2	NONCLUSTERED	Y			never	2025-06-19 13:13:32	COLD	review carefully — unique
BATCH_Test.dbo.WarehouseAudit.PK_ReconcileAudit	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:32	COLD	KEEP — primary key
BATCH_Test.dbo.SettlementHistory.IX_TerritoryStaging	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.SettlementHistory.PK_ForecastLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.AssetResult.PK_BillingSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.CustomerSummary.IX_BatchAudit	2	NONCLUSTERED				never	never	COLD	review, then DROP
BATCH_Test.dbo.CustomerSummary.PK_SupplierMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.QuotaAudit.IX_OrdersAudit	2	NONCLUSTERED				never	never	COLD	review, then DROP
BATCH_Test.dbo.QuotaAudit.IX_TerritoryMonthly	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.QuotaAudit.PK_ShiftSnapshot	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ClaimSnapshot.IX_TicketHeader	2	NONCLUSTERED	Y			never	2023-11-01 08:22:19	COLD	review carefully — unique
BATCH_Test.dbo.ClaimSnapshot.PK_ClaimEntry	1	CLUSTERED	Y	Y		never	2023-11-01 08:22:19	COLD	KEEP — primary key
BATCH_Test.dbo.ReconcileDaily.IX_StaffingHistory	2	NONCLUSTERED	Y			never	2025-06-19 13:13:38	COLD	review carefully — unique
BATCH_Test.dbo.ReconcileDaily.PK_RosterResult	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.MeterQueue.IX_OrdersMonthly	2	NONCLUSTERED	Y			never	2025-06-19 13:13:38	COLD	review carefully — unique
BATCH_Test.dbo.MeterQueue.PK_ReconcileArchive	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.OrdersDetail.IX_WarehouseResult	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.OrdersDetail.IX_LedgerDaily	3	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.OrdersDetail.PK_LedgerResult	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.Task.IX_PayrollDaily	2	NONCLUSTERED				never	2025-06-19 13:13:38	COLD	review, then DROP
BATCH_Test.dbo.Task.PK_ShipmentLine	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.InvoiceAudit.IX_RouteArchive	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.InvoiceAudit.PK_CustomerLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.TicketDaily.IX_RouteMonthly	2	NONCLUSTERED				never	never	COLD	review, then DROP
BATCH_Test.dbo.TicketDaily.PK_TerritoryLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.ContractAudit.IX_ShiftSummary	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.ContractAudit.PK_InvoiceArchive	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.TerritorySnapshot.IX_QuotaHeader	2	NONCLUSTERED	Y			never	2023-11-24 07:37:19	COLD	review carefully — unique
BATCH_Test.dbo.TerritorySnapshot.IX_SupplierEntry	3	NONCLUSTERED				never	2023-11-24 07:37:19	COLD	review, then DROP
BATCH_Test.dbo.TerritorySnapshot.PK_SalesHeader	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.SupplierHistory.PK_ContractLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.OrdersResult.IX_BookingLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.OrdersResult.PK_AssetLine	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.CustomerSummary.IX_OrdersDaily	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.CustomerSummary.PK_QuotaDetail	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.CustomerEntry.IX_SupplierQueue	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.CustomerEntry.PK_InvoiceDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.MeterLog.IX_AssetEntry	2	NONCLUSTERED				never	2025-06-19 13:13:38	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_RosterDaily	3	NONCLUSTERED				never	2025-06-19 13:13:38	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_TicketLog	4	NONCLUSTERED				never	2025-06-19 13:13:38	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.IX_RosterHistory	5	NONCLUSTERED				never	2025-06-19 13:13:38	COLD	review, then DROP
BATCH_Test.dbo.MeterLog.PK_QuotaMonthly	1	CLUSTERED	Y	Y		never	2025-06-19 13:13:38	COLD	KEEP — primary key
BATCH_Test.dbo.WarehouseEntry.IX_BatchHeader	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.dbo.WarehouseEntry.PK_CampaignStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.QuotaResult.PK_ReconcileDaily	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.dbo.QuotaResult.IX_BillingLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
BATCH_Test.kar.Bin.PK_InvoiceSummary	1	CLUSTERED	Y	Y		never	2025-02-25 14:34:51	COLD	KEEP — primary key
BATCH_Test.kar.Bin.UX_PayrollAudit	2	NONCLUSTERED	Y			never	2025-06-19 13:13:38	COLD	review carefully — unique
BATCH_Test.kar.CatalogQueue.PK_RouteAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.kar.BookingAudit.PK_RouteHistory	1	CLUSTERED	Y	Y		never	2026-06-20 09:04:42	COLD	KEEP — primary key
BATCH_Test.kar.ContractStaging.PK_CustomerSummary	1	CLUSTERED	Y	Y		never	2026-07-25 01:02:56	COLD	KEEP — primary key
BATCH_Test.kar.RosterSummary.IX_PricingDetail	6	NONCLUSTERED				never	2026-07-25 01:02:56	COLD	review, then DROP
BATCH_Test.kar.RosterSummary.IX_InvoiceDaily	11	NONCLUSTERED			Y	never	2026-07-25 01:02:56	COLD	review, then DROP
BATCH_Test.kar.RosterSummary.PK_AssetAudit	1	CLUSTERED	Y	Y		never	2026-07-25 01:02:56	COLD	KEEP — primary key
BATCH_Test.kar.SupplierArchive.IX_SettlementLine	12	NONCLUSTERED				never	2026-07-25 01:02:56	COLD	review, then DROP
BATCH_Test.kar.SupplierArchive.PK_QuotaSnapshot	1	CLUSTERED	Y	Y		never	2026-07-25 01:02:56	COLD	KEEP — primary key
BATCH_Test.kar.ClaimResult.IX_ContractHistory	11	NONCLUSTERED				never	2026-07-25 01:02:56	COLD	review, then DROP
BATCH_Test.kar.ClaimResult.IX_QuotaSnapshot	9	NONCLUSTERED				never	2026-07-25 01:02:56	COLD	review, then DROP
BATCH_Test.kar.ClaimResult.PK_WarehouseMonthly	1	CLUSTERED	Y	Y		never	2026-07-25 01:02:56	COLD	KEEP — primary key
BATCH_Test.kar.RosterDaily.IX_ClaimSummary	15	NONCLUSTERED				never	2026-07-25 01:02:56	COLD	review, then DROP
BATCH_Test.kar.RosterDaily.IX_RouteDetail	14	NONCLUSTERED			Y	never	2026-07-25 01:02:56	COLD	review, then DROP
BATCH_Test.kar.RosterDaily.IX_CampaignStatus	22	NONCLUSTERED			Y	never	2026-07-25 01:02:56	COLD	review, then DROP
BATCH_Test.kar.RosterDaily.PK_BillingAudit	1	CLUSTERED	Y	Y		never	2026-07-25 01:02:56	COLD	KEEP — primary key
BATCH_Test.kar.LedgerHeader.PK_TerritoryResult	1	CLUSTERED	Y	Y		never	2026-07-10 01:00:40	COLD	KEEP — primary key
BATCH_Test.kar.LedgerLog.IX_PricingAudit	9	NONCLUSTERED				never	2026-01-11 01:01:55	COLD	review, then DROP
BATCH_Test.kar.SalesLine.PK_LedgerLog	1	CLUSTERED	Y	Y		never	2025-03-13 13:09:59	COLD	KEEP — primary key
BATCH_Test.kar.SalesLine.UX_OrdersStatus	4	NONCLUSTERED	Y			never	2025-04-16 09:16:28	COLD	review carefully — unique
BATCH_Test.kar.ClaimDetail.PK_TicketStatus	1	CLUSTERED	Y	Y		never	2025-07-15 01:01:41	COLD	KEEP — primary key
BATCH_Test.kar.PayrollResult.PK_WarehouseDetail	1	CLUSTERED	Y	Y		never	2026-07-03 01:00:33	COLD	KEEP — primary key
BATCH_Test.kar.AssetHeader.PK_BillingSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
BATCH_Test.kar.SettlementLog.PK_MeterDaily	1	CLUSTERED	Y	Y		never	2026-07-25 01:02:57	COLD	KEEP — primary key
PAYROLL.dbo.ContractDaily.IX_SalesEntry	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
CLAIM_Prod.bm.BOM.PK_MeterHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.bm.CatalogQueue.PK_StaffingSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.bm.ShiftEntry.PK_RouteStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.bm.BillingArchive.PK_AssetMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.bm.ForecastDetail.PK_CatalogLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.dbo.StaffingEntry.PK_AssetStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.dbo.QuotaLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		never	2024-03-20 00:42:51	COLD	KEEP — primary key
CLAIM_Prod.dbo.QuotaLine.UX_ForecastSummary	2	NONCLUSTERED	Y			never	2024-03-19 23:35:10	COLD	review carefully — unique
CLAIM_Prod.dbo.QuotaResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.dbo.QuotaResult.IX_BillingLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
CLAIM_Prod.lib.Color.PK_ReconcileStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.lib.SalesLine.PK_StaffingEntry	1	CLUSTERED	Y	Y		never	2024-10-17 10:54:55	COLD	KEEP — primary key
CLAIM_Prod.lib.SalesLine.UX_QuotaArchive	2	NONCLUSTERED	Y			never	2024-10-17 10:54:55	COLD	review carefully — unique
CLAIM_Prod.lib.CustomerLog.PK_ClaimMonthly	1	CLUSTERED	Y	Y		never	2024-09-04 07:48:57	COLD	KEEP — primary key
CLAIM_Prod.lib.BillingArchive.PK_StaffingDetail	1	CLUSTERED	Y	Y		never	2024-05-03 14:41:51	COLD	KEEP — primary key
CLAIM_Prod.lib.BillingArchive.UX_CustomerEntry	9	NONCLUSTERED	Y			never	2024-05-02 14:04:36	COLD	review carefully — unique
CLAIM_Prod.lib.CustomerArchive.PK_ForecastSummary	1	CLUSTERED	Y	Y		never	2024-12-04 09:26:29	COLD	KEEP — primary key
CLAIM_Prod.lib.SettlementHeader.PK_ShiftHeader	1	CLUSTERED	Y	Y		never	2024-04-19 11:10:12	COLD	KEEP — primary key
CLAIM_Prod.lib.SettlementHeader.UX_ForecastDaily	2	NONCLUSTERED	Y			never	2024-03-20 09:31:23	COLD	review carefully — unique
CLAIM_Prod.lib.SupplierSummary.PK_BookingHeader	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.lib.LedgerSnapshot.PK_ClaimDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.lib.RouteDetail.PK_SalesStaging	1	CLUSTERED	Y	Y		never	2024-05-02 14:04:52	COLD	KEEP — primary key
CLAIM_Prod.lib.ReconcileEntry.PK_BatchLog	1	CLUSTERED	Y	Y		never	2024-10-17 11:25:37	COLD	KEEP — primary key
CLAIM_Prod.lib.RouteStatus.PK_ShiftAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.lib.InvoiceLine.PK_AssetArchive	1	CLUSTERED	Y	Y		never	2024-09-09 23:44:04	COLD	KEEP — primary key
CLAIM_Prod.lib.Size.PK_ClaimArchive	1	CLUSTERED	Y	Y		never	2024-08-06 09:47:03	COLD	KEEP — primary key
CLAIM_Prod.lib.StaffingQueue.PK_CampaignAudit	1	CLUSTERED	Y	Y		never	2024-08-06 09:34:07	COLD	KEEP — primary key
CLAIM_Prod.lib.MeterAudit.PK_TerritoryDaily	1	CLUSTERED	Y	Y		never	2024-08-06 09:34:07	COLD	KEEP — primary key
CLAIM_Prod.lib.RosterResult.PK_ShipmentEntry	1	CLUSTERED	Y	Y		never	2024-09-04 07:48:50	COLD	KEEP — primary key
CLAIM_Prod.lib.BookingResult.PK_ForecastLine	1	CLUSTERED	Y	Y		never	2024-04-19 11:10:12	COLD	KEEP — primary key
CLAIM_Prod.lib.MeterAudit.PK_ReconcileDaily	1	CLUSTERED	Y	Y		never	2024-11-22 15:14:21	COLD	KEEP — primary key
CLAIM_Prod.lib.ContractLog.PK_TerritoryLog	1	CLUSTERED	Y	Y		never	2024-09-04 07:56:33	COLD	KEEP — primary key
CLAIM_Prod.lib.CustomerLine.PK_QuotaArchive	1	CLUSTERED	Y	Y		never	2024-09-04 07:56:33	COLD	KEEP — primary key
CLAIM_Prod.sm.QuotaHistory.PK_BatchLine	1	CLUSTERED	Y	Y		never	2024-09-30 14:06:31	COLD	KEEP — primary key
CLAIM_Prod.sm.InvoiceStaging.PK_QuotaDaily	1	CLUSTERED	Y	Y		never	2024-09-04 07:48:57	COLD	KEEP — primary key
CLAIM_Prod.sm.PricingStatus.PK_LedgerHistory	1	CLUSTERED	Y	Y		never	2024-09-04 07:48:57	COLD	KEEP — primary key
CLAIM_Prod.sm.TerritoryArchive.PK_TerritoryLine	1	CLUSTERED	Y	Y		never	2024-04-17 13:41:28	COLD	KEEP — primary key
CLAIM_Prod.sm.TerritoryArchive.UX_PayrollResult	4	NONCLUSTERED	Y			never	2024-04-17 13:41:50	COLD	review carefully — unique
CLAIM_Prod.sm.BookingResult.PK_RosterStaging	1	CLUSTERED	Y	Y		never	2024-08-28 12:42:56	COLD	KEEP — primary key
CLAIM_Prod.sm.TerritoryMonthly.PK_BookingAudit	1	CLUSTERED	Y	Y		never	2024-09-04 07:48:57	COLD	KEEP — primary key
CLAIM_Prod.sm.TerritoryMonthly.UX_StaffingResult	2	NONCLUSTERED	Y			never	2024-09-04 07:48:57	COLD	review carefully — unique
CLAIM_Prod.sm.QuotaDaily.PK_BookingDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.QuotaDaily.UX_QuotaQueue	2	NONCLUSTERED	Y			never	2024-09-17 13:31:33	COLD	review carefully — unique
CLAIM_Prod.sm.CatalogResult.PK_SalesStatus	1	CLUSTERED	Y	Y		never	2024-11-22 10:51:51	COLD	KEEP — primary key
CLAIM_Prod.sm.BatchAudit.PK_ReconcileHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.ShiftDaily.PK_ClaimHistory	1	CLUSTERED	Y	Y		never	2024-09-17 13:31:33	COLD	KEEP — primary key
CLAIM_Prod.sm.OrdersMonthly.PK_PolicyHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.InvoiceLine.PK_PayrollDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.BillingEntry.PK_SettlementArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.ShipmentDaily.PK_CatalogDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.ShipmentDaily.UX_TicketMonthly	2	NONCLUSTERED	Y			never	2024-09-17 13:31:33	COLD	review carefully — unique
CLAIM_Prod.sm.PolicyHeader.PK_CustomerSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.PolicyHeader.UX_LedgerDetail	2	NONCLUSTERED	Y			never	2024-09-17 13:31:33	COLD	review carefully — unique
CLAIM_Prod.sm.RouteDetail.PK_SalesDetail	1	CLUSTERED	Y	Y		never	2024-11-22 10:51:51	COLD	KEEP — primary key
CLAIM_Prod.sm.QuotaStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.ContractAudit.PK_ReconcileArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CLAIM_Prod.sm.BookingHeader.PK_ShipmentArchive	1	CLUSTERED	Y	Y		never	2024-11-22 16:30:38	COLD	KEEP — primary key
CONTRACT.bm.BOM.PK_MeterHistory	1	CLUSTERED	Y	Y		never	2024-11-26 16:17:16	COLD	KEEP — primary key
CONTRACT.bm.CatalogQueue.PK_StaffingSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.bm.ShiftEntry.PK_RouteStatus	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.bm.BillingArchive.PK_AssetMonthly	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.bm.ForecastDetail.PK_CatalogLog	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.cfg.QuotaStatus.PK_StaffingLine	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.dbo.StaffingEntry.PK_AssetStaging	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.dbo.QuotaLine.PK_ClaimSummary	1	CLUSTERED	Y	Y		never	2024-03-20 00:42:51	COLD	KEEP — primary key
CONTRACT.dbo.QuotaLine.UX_ForecastSummary	2	NONCLUSTERED	Y			never	2024-03-19 23:35:10	COLD	review carefully — unique
CONTRACT.dbo.QuotaResult.PK_SettlementSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.dbo.QuotaResult.IX_BillingLog	2	NONCLUSTERED	Y			never	never	COLD	review carefully — unique
CONTRACT.lib.Color.PK_ReconcileStaging	1	CLUSTERED	Y	Y		never	2024-11-27 11:05:56	COLD	KEEP — primary key
CONTRACT.lib.SalesLine.PK_StaffingEntry	1	CLUSTERED	Y	Y		never	2024-10-17 10:54:55	COLD	KEEP — primary key
CONTRACT.lib.SalesLine.UX_QuotaArchive	2	NONCLUSTERED	Y			never	2024-10-17 10:54:55	COLD	review carefully — unique
CONTRACT.lib.CustomerLog.PK_ClaimMonthly	1	CLUSTERED	Y	Y		never	2024-09-04 07:48:57	COLD	KEEP — primary key
CONTRACT.lib.BillingArchive.PK_StaffingDetail	1	CLUSTERED	Y	Y		never	2024-05-03 14:41:51	COLD	KEEP — primary key
CONTRACT.lib.BillingArchive.UX_CustomerEntry	9	NONCLUSTERED	Y			never	2024-05-02 14:04:36	COLD	review carefully — unique
CONTRACT.lib.CustomerArchive.PK_ForecastSummary	1	CLUSTERED	Y	Y		never	2024-11-25 08:33:29	COLD	KEEP — primary key
CONTRACT.lib.SettlementHeader.PK_ShiftHeader	1	CLUSTERED	Y	Y		never	2024-04-19 11:10:12	COLD	KEEP — primary key
CONTRACT.lib.SettlementHeader.UX_ForecastDaily	2	NONCLUSTERED	Y			never	2024-03-20 09:31:23	COLD	review carefully — unique
CONTRACT.lib.SupplierSummary.PK_BookingHeader	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.lib.LedgerSnapshot.PK_ClaimDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.lib.RouteDetail.PK_SalesStaging	1	CLUSTERED	Y	Y		never	2024-05-02 14:04:52	COLD	KEEP — primary key
CONTRACT.lib.ReconcileEntry.PK_BatchLog	1	CLUSTERED	Y	Y		never	2024-10-17 11:25:37	COLD	KEEP — primary key
CONTRACT.lib.RouteStatus.PK_ShiftAudit	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.lib.InvoiceLine.PK_AssetArchive	1	CLUSTERED	Y	Y		never	2024-11-27 12:41:06	COLD	KEEP — primary key
CONTRACT.lib.Size.PK_ClaimArchive	1	CLUSTERED	Y	Y		never	2024-08-06 09:47:03	COLD	KEEP — primary key
CONTRACT.lib.StaffingQueue.PK_CampaignAudit	1	CLUSTERED	Y	Y		never	2024-08-06 09:34:07	COLD	KEEP — primary key
CONTRACT.lib.MeterAudit.PK_TerritoryDaily	1	CLUSTERED	Y	Y		never	2024-08-06 09:34:07	COLD	KEEP — primary key
CONTRACT.lib.RosterResult.PK_ShipmentEntry	1	CLUSTERED	Y	Y		never	2024-09-04 07:48:50	COLD	KEEP — primary key
CONTRACT.lib.BookingResult.PK_ForecastLine	1	CLUSTERED	Y	Y		never	2024-04-19 11:10:12	COLD	KEEP — primary key
CONTRACT.lib.MeterAudit.PK_ReconcileDaily	1	CLUSTERED	Y	Y		never	2024-11-21 09:20:39	COLD	KEEP — primary key
CONTRACT.lib.ContractLog.PK_TerritoryLog	1	CLUSTERED	Y	Y		never	2024-09-04 07:56:33	COLD	KEEP — primary key
CONTRACT.lib.CustomerLine.PK_QuotaArchive	1	CLUSTERED	Y	Y		never	2024-09-04 07:56:33	COLD	KEEP — primary key
CONTRACT.sm.QuotaHistory.PK_BatchLine	1	CLUSTERED	Y	Y		never	2024-09-30 14:06:31	COLD	KEEP — primary key
CONTRACT.sm.InvoiceStaging.PK_QuotaDaily	1	CLUSTERED	Y	Y		never	2024-09-04 07:48:57	COLD	KEEP — primary key
CONTRACT.sm.PricingStatus.PK_LedgerHistory	1	CLUSTERED	Y	Y		never	2024-09-04 07:48:57	COLD	KEEP — primary key
CONTRACT.sm.TerritoryArchive.PK_TerritoryLine	1	CLUSTERED	Y	Y		never	2024-04-17 13:41:28	COLD	KEEP — primary key
CONTRACT.sm.TerritoryArchive.UX_PayrollResult	4	NONCLUSTERED	Y			never	2024-04-17 13:41:50	COLD	review carefully — unique
CONTRACT.sm.BookingResult.PK_RosterStaging	1	CLUSTERED	Y	Y		never	2024-08-28 12:42:56	COLD	KEEP — primary key
CONTRACT.sm.TerritoryMonthly.PK_BookingAudit	1	CLUSTERED	Y	Y		never	2024-09-04 07:48:57	COLD	KEEP — primary key
CONTRACT.sm.TerritoryMonthly.UX_StaffingResult	2	NONCLUSTERED	Y			never	2024-09-04 07:48:57	COLD	review carefully — unique
CONTRACT.sm.QuotaDaily.PK_BookingDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.sm.QuotaDaily.UX_QuotaQueue	2	NONCLUSTERED	Y			never	2024-09-17 13:31:33	COLD	review carefully — unique
CONTRACT.sm.CatalogResult.PK_SalesStatus	1	CLUSTERED	Y	Y		never	2024-11-26 08:10:58	COLD	KEEP — primary key
CONTRACT.sm.BatchAudit.PK_ReconcileHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.sm.ShiftDaily.PK_ClaimHistory	1	CLUSTERED	Y	Y		never	2024-09-17 13:31:33	COLD	KEEP — primary key
CONTRACT.sm.OrdersMonthly.PK_PolicyHistory	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.sm.InvoiceLine.PK_PayrollDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.sm.BillingEntry.PK_SettlementArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.sm.ShipmentDaily.PK_CatalogDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.sm.ShipmentDaily.UX_TicketMonthly	2	NONCLUSTERED	Y			never	2024-09-17 13:31:33	COLD	review carefully — unique
CONTRACT.sm.PolicyHeader.PK_CustomerSummary	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.sm.PolicyHeader.UX_LedgerDetail	2	NONCLUSTERED	Y			never	2024-09-17 13:31:33	COLD	review carefully — unique
CONTRACT.sm.RouteDetail.PK_SalesDetail	1	CLUSTERED	Y	Y		never	2024-11-26 08:10:58	COLD	KEEP — primary key
CONTRACT.sm.QuotaStatus.PK_ShiftDetail	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.sm.ContractAudit.PK_ReconcileArchive	1	CLUSTERED	Y	Y		never	never	COLD	KEEP — primary key
CONTRACT.sm.BookingHeader.PK_ShipmentArchive	1	CLUSTERED	Y	Y		never	2024-11-26 08:10:58	COLD	KEEP — primary key