DBA BrainIndex UsageACME-198-51-100-45snapshot 2026-10-03 01:04:44 +08Fleet inventoryServer metricsSLAIndex usage

ACME-198-51-100-45

SQL Server · index usage

1,701
indexes total
682
used
792
unused
227
cold
0
disabled
120
droppable
0
disabled clustered
0
missing suggestions
Index reportsSQL Server 13ACME-203-0-113-170ACME-198-51-100-45ACME-192-0-2-15-MSSQL25-1433ACME-198-51-100-66ACME-198-51-100-210ACME-198-51-100-60ACME-192-0-2-243ACME-203-0-113-99ACME-198-51-100-92ACME-203-0-113-69ACME-192-0-2-97ACME-192-0-2-242ACME-203-0-113-155Oracle 1ACME-198-51-100-125PostgreSQL 1ACME-192-0-2-15-PG-5433

Host: 198.51.100.45

Collected: 2026-10-02T17:04:44Z

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

Fleet inventory: http://203.0.113.28: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.

MetricCountMeaning
indexes_total1701every index on a user table
used682had a seek, scan or lookup
unused792written but never read
cold227never read AND never written since restart
disabled0ALTER INDEX ... DISABLE was run
droppable120nonclustered, not unique, no constraint, never read
fragmented38above the rebuild threshold

By database

DatabaseTotalColdDisabledDroppableRecommend action
ASSET62829048review the drop candidates above
host_72655749042review the drop candidates above
QUOTA328107029review the drop candidates above
host-87724301review the drop candidates above
CLAIM_Prod581900no action — cold indexes here are constraints or clustered
CONTRACT581100no action — cold indexes here are constraints or clustered
host-72725500no action — cold indexes here are constraints or clustered
host-40022300no action — cold indexes here are constraints or clustered
host-9311100no action — cold indexes here are constraints or clustered

Drop candidates (120)

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

Indexuser_updateslast_readStateRecommend action
host_726.schedule.RosterResult.IX_BookingAudit3155045neverUNUSEDreview, then DROP
ASSET.schedule.WarehouseArchive.IX_CustomerHistory644600neverUNUSEDreview, then DROP
host_726.schedule.WarehouseArchive.IX_CustomerHistory553991neverUNUSEDreview, then DROP
ASSET.schedule.RouteAudit.IX_SettlementDetail322300neverUNUSEDreview, then DROP
host_726.schedule.RouteAudit.IX_InvoiceHeader277148neverUNUSEDreview, then DROP
host_726.schedule.RouteAudit.IX_QuotaStaging277148neverUNUSEDreview, then DROP
host_726.schedule.RouteAudit.IX_SettlementDetail276988neverUNUSEDreview, then DROP
ASSET.schedule.MeterSnapshot.IX_MeterLog16909neverUNUSEDreview, then DROP
ASSET.emp.SupplierStaging.IX_MeterStaging12170neverUNUSEDreview, then DROP
ASSET.schedule.QuotaDetail.IX_QuotaMonthly7977neverUNUSEDreview, then DROP
ASSET.schedule.QuotaDetail.IX_TicketSummary7977neverUNUSEDreview, then DROP
ASSET.emp.SettlementQueue.IX_PolicyAudit4156neverUNUSEDreview, then DROP
ASSET.emp.SalesHeader.IX_BookingSummary499neverUNUSEDreview, then DROP
host_726.emp.OrdersMonthly.IX_SettlementLine174neverUNUSEDreview, then DROP
host_726.emp.OrdersMonthly.IX_QuotaArchive153neverUNUSEDreview, then DROP
host_726.emp.SalesHeader.IX_BookingSummary134neverUNUSEDreview, then DROP
ASSET.emp.OrdersMonthly.IX_QuotaArchive116neverUNUSEDreview, then DROP
host_726.emp.SupplierStaging.IX_StaffingEntry68neverUNUSEDreview, then DROP
host_726.emp.SupplierStaging.IX_MeterStaging60neverUNUSEDreview, then DROP
host_726.emp.SettlementQueue.IX_PolicyAudit40neverUNUSEDreview, then DROP
host_726.emp.StaffingMonthly.IX_ReconcileEntry38neverUNUSEDreview, then DROP
ASSET.dbo.BatchResult.IX_SettlementStaging8neverUNUSEDreview, then DROP
ASSET.dbo.BatchResult.IX_ReconcileEntry8neverUNUSEDreview, then DROP
ASSET.dbo.CustomerArchive.IX_BillingHeader8neverUNUSEDreview, then DROP
ASSET.org.RosterMonthly.IX_AssetDetail4neverUNUSEDreview, then DROP
ASSET.org.InvoiceStaging.IX_AssetAudit4neverUNUSEDreview, then DROP
ASSET.rec.BillingStaging.IX_BillingSnapshot2neverUNUSEDreview, then DROP
ASSET.rec.BillingStaging.IX_ForecastLog2neverUNUSEDreview, then DROP
host_726.emp.TicketAudit.IX_LedgerLog1neverUNUSEDreview, then DROP
host_726.org.QuotaEntry.IX_AssetHistory1neverUNUSEDreview, then DROP
ASSET.rec.MeterStaging.IX_CampaignResult1neverUNUSEDreview, then DROP
ASSET.rec.MeterStaging.IX_PricingStatus1neverUNUSEDreview, then DROP
ASSET.rec.TicketDetail.IX_ContractHeader1neverUNUSEDreview, then DROP
ASSET.rec.TicketDetail.IX_BookingEntry1neverUNUSEDreview, then DROP
host-877.dbo.QuotaArchive.IX_InvoiceAudit0neverUNUSEDreview, then DROP
host_726.dbo.QuotaArchive.IX_InvoiceAudit0neverUNUSEDreview, then DROP
host_726.emp.ShiftLine.IX_PricingAudit0neverUNUSEDreview, then DROP
host_726.emp.OrdersMonthly.IX_PayrollResult0neverUNUSEDreview, then DROP
host_726.org.SupplierHistory.IX_ShipmentSummary0neverUNUSEDreview, then DROP
host_726.org.BillingHeader.IX_ShiftHistory0neverUNUSEDreview, then DROP
host_726.org.ShipmentSummary.IX_StaffingResult0neverUNUSEDreview, then DROP
host_726.org.RosterMonthly.IX_AssetDetail0neverUNUSEDreview, then DROP
host_726.org.InvoiceStaging.IX_AssetAudit0neverUNUSEDreview, then DROP
host_726.org.CustomerLine.IX_ForecastLine0neverUNUSEDreview, then DROP
host_726.oth.StaffingArchive.IX_InvoiceStaging0neverUNUSEDreview, then DROP
host_726.sal.ClaimArchive.IX_RouteDetail0neverUNUSEDreview, then DROP
host_726.schedule.InvoiceHistory.IX_StaffingHeader0neverUNUSEDreview, then DROP
host_726.schedule.SalesDaily.IX_ForecastHistory0neverUNUSEDreview, then DROP
host_726.schedule.SalesDaily.IX_QuotaSummary0neverUNUSEDreview, then DROP
host_726.schedule.ContractStaging.IX_StaffingLine0neverUNUSEDreview, then DROP
host_726.schedule.ContractStaging.IX_ShiftSummary0neverUNUSEDreview, then DROP
host_726.schedule.SupplierEntry.IX_InvoiceStaging0neverUNUSEDreview, then DROP
host_726.schedule.SupplierEntry.IX_StaffingDaily0neverUNUSEDreview, then DROP
host_726.schedule.ForecastEntry.IX_ContractHistory0neverUNUSEDreview, then DROP
host_726.schedule.ForecastEntry.IX_ForecastLine0neverUNUSEDreview, then DROP
host_726.schedule.QuotaDetail.IX_QuotaMonthly0neverUNUSEDreview, then DROP
host_726.schedule.QuotaDetail.IX_TicketSummary0neverUNUSEDreview, then DROP
host_726.schedule.MeterSnapshot.IX_StaffingSummary0neverUNUSEDreview, then DROP
host_726.schedule.MeterSnapshot.IX_MeterLog0neverUNUSEDreview, then DROP
QUOTA.emp.QuotaMonthly.IX_ShipmentEntry0neverUNUSEDreview, then DROP
QUOTA.emp.MeterResult.IX_LedgerQueue0neverUNUSEDreview, then DROP
QUOTA.emp.ShiftLine.IX_PricingAudit0neverUNUSEDreview, then DROP
QUOTA.emp.ForecastHeader.IX_WarehouseResult0neverUNUSEDreview, then DROP
QUOTA.emp.PricingDaily.IX_ShiftAudit0neverUNUSEDreview, then DROP
QUOTA.emp.MeterHistory.IX_ContractArchive0neverUNUSEDreview, then DROP
QUOTA.emp.CampaignHistory.IX_QuotaDetail0neverUNUSEDreview, then DROP
QUOTA.emp.SupplierStaging.IX_MeterStaging0neverUNUSEDreview, then DROP
QUOTA.emp.ShipmentMonthly.IX_InvoiceStaging0neverUNUSEDreview, then DROP
QUOTA.emp.AssetSnapshot.IX_SalesDaily0neverUNUSEDreview, then DROP
QUOTA.emp.PricingStatus.IX_QuotaLog0neverUNUSEDreview, then DROP
QUOTA.emp.PricingStatus.IX_ClaimEntry0neverUNUSEDreview, then DROP
QUOTA.emp.BookingMonthly.IX_ShipmentAudit0neverUNUSEDreview, then DROP
QUOTA.emp.CampaignResult.IX_ForecastAudit0neverUNUSEDreview, then DROP
QUOTA.emp.CampaignResult.IX_CustomerQueue0neverUNUSEDreview, then DROP
QUOTA.emp.CatalogSummary.IX_WarehouseSnapshot0neverUNUSEDreview, then DROP
QUOTA.emp.CatalogSummary.IX_ReconcileSummary0neverUNUSEDreview, then DROP
QUOTA.emp.BillingQueue.IX_ContractSummary0neverUNUSEDreview, then DROP
QUOTA.org.PolicySummary.IX_AssetEntry0neverUNUSEDreview, then DROP
QUOTA.org.RosterMonthly.IX_AssetDetail0neverUNUSEDreview, then DROP
QUOTA.org.InvoiceStaging.IX_AssetAudit0neverUNUSEDreview, then DROP
QUOTA.org.QuotaEntry.IX_AssetHistory0neverUNUSEDreview, then DROP
ASSET.emp.StaffingMonthly.IX_ReconcileEntry0neverUNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_BookingLine0neverUNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_InvoiceMonthly0neverUNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_RouteStatus0neverUNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_ForecastMonthly0neverUNUSEDreview, then DROP
ASSET.emp.OrdersMonthly.IX_PayrollResult0neverUNUSEDreview, then DROP
ASSET.emp.TicketAudit.IX_LedgerLog0neverUNUSEDreview, then DROP
ASSET.org.SupplierHistory.IX_ShipmentSummary0neverUNUSEDreview, then DROP
ASSET.org.BillingHeader.IX_ShiftHistory0neverUNUSEDreview, then DROP
ASSET.org.ShipmentSummary.IX_StaffingResult0neverUNUSEDreview, then DROP
ASSET.org.QuotaEntry.IX_AssetHistory0neverUNUSEDreview, then DROP
ASSET.oth.StaffingArchive.IX_InvoiceStaging0neverUNUSEDreview, then DROP
ASSET.sal.ClaimArchive.IX_RouteDetail0neverUNUSEDreview, then DROP
ASSET.schedule.InvoiceHistory.IX_StaffingHeader0neverUNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_SettlementStatus0neverUNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_InvoiceSummary0neverUNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_WarehouseStaging0neverUNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_WarehouseStatus0neverUNUSEDreview, then DROP
ASSET.schedule.SalesDaily.IX_ForecastHistory0neverUNUSEDreview, then DROP
ASSET.schedule.SalesDaily.IX_QuotaSummary0neverUNUSEDreview, then DROP
ASSET.schedule.ContractStaging.IX_StaffingLine0neverUNUSEDreview, then DROP
ASSET.schedule.ContractStaging.IX_ShiftSummary0neverUNUSEDreview, then DROP
ASSET.schedule.SupplierEntry.IX_InvoiceStaging0neverUNUSEDreview, then DROP
ASSET.schedule.SupplierEntry.IX_StaffingDaily0neverUNUSEDreview, then DROP
host_726.schedule.PricingSnapshot.IX_SettlementStatus0neverCOLDreview, then DROP
host_726.schedule.PricingSnapshot.IX_InvoiceSummary0neverCOLDreview, then DROP
host_726.schedule.PricingSnapshot.IX_WarehouseStaging0neverCOLDreview, then DROP
host_726.schedule.PricingSnapshot.IX_WarehouseStatus0neverCOLDreview, then DROP
QUOTA.emp.SettlementQueue.IX_PolicyAudit0neverCOLDreview, then DROP
QUOTA.emp.StaffingMonthly.IX_ReconcileEntry0neverCOLDreview, then DROP
QUOTA.emp.StaffingMonthly.IX_SalesQueue0neverCOLDreview, then DROP
QUOTA.emp.TicketAudit.IX_LedgerLog0neverCOLDreview, then DROP
QUOTA.org.SupplierHistory.IX_ShipmentSummary0neverCOLDreview, then DROP
QUOTA.org.BillingHeader.IX_ShiftHistory0neverCOLDreview, then DROP
QUOTA.org.ShipmentSummary.IX_StaffingResult0neverCOLDreview, then DROP
ASSET.dbo.ShiftResult.IX_SalesHeader0neverCOLDreview, then DROP
ASSET.dbo.OrdersDetail.IX_PolicyMonthly0neverCOLDreview, then DROP
ASSET.dbo.RouteLog.IX_CampaignQueue0neverCOLDreview, then DROP
ASSET.dbo.PayrollStatus.IX_StaffingHeader0neverCOLDreview, then DROP

Fragmented (38) — 38 partitions across 32 indexes

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

IndexPartTypeFragPagesSize MBStats updatedAction
host_726.schedule.RouteAudit.IX_InvoiceHeader1/1NONCLUSTERED99.5%2,74721.52026-10-02 12:28:47REBUILD
ASSET.schedule.SettlementLog.PK_CatalogMonthly#p2525/25CLUSTERED99.3%3,46727.12026-10-02 02:05:01REBUILD
host_726.schedule.ShiftHeader.IX_ShipmentLine1/1NONCLUSTERED99.2%80,146626.12026-10-02 16:10:18REBUILD
host_726.schedule.ShiftHeader.IX_TicketStatus1/1NONCLUSTERED99.2%52,931413.52026-10-02 16:10:19REBUILD
ASSET.schedule.ShiftHeader.IX_ShipmentLine#p2424/25NONCLUSTERED99.2%1,42711.12026-10-02 02:02:35REBUILD
ASSET.schedule.ShiftHeader.IX_TicketStatus#p2323/25NONCLUSTERED99.2%1,0588.32026-10-02 02:02:35REBUILD
ASSET.schedule.RouteAudit.IX_InvoiceHeader1/1NONCLUSTERED99.2%8,56966.92026-10-02 01:39:55REBUILD
ASSET.schedule.BillingDetail.PK_BillingLog#p2525/25CLUSTERED99.1%2,24917.62026-10-02 02:04:02REBUILD
ASSET.schedule.SettlementLog.IX_TicketLine#p2525/25NONCLUSTERED99.1%1,0027.82026-10-02 02:05:01REBUILD
ASSET.schedule.ShiftHeader.IX_TicketStatus#p2424/25NONCLUSTERED99.1%1,0037.82026-10-02 02:02:35REBUILD
ASSET.schedule.ShiftHeader.IX_ShipmentLine#p2323/25NONCLUSTERED99.0%1,57412.32026-10-02 02:02:35REBUILD
ASSET.schedule.ShiftHeader.IX_TicketStatus#p2222/25NONCLUSTERED98.8%1,2139.52026-10-02 02:02:35REBUILD
ASSET.schedule.ShiftHeader.IX_TicketStatus#p2121/25NONCLUSTERED98.7%1,1909.32026-10-02 02:02:35REBUILD
ASSET.schedule.PolicyStatus.IX_ForecastAudit#p2525/25NONCLUSTERED98.2%1,36910.72026-10-02 13:27:21REBUILD
ASSET.schedule.RosterResult.PK_PricingSummary#p2525/25CLUSTERED93.8%3,13024.52026-10-02 02:05:19REBUILD
ASSET.schedule.ShiftHeader.IX_BookingStatus#p2121/25NONCLUSTERED80.6%1,1358.92026-10-02 02:02:35REBUILD
ASSET.schedule.PolicyStatus.PK_PricingDaily#p2525/25CLUSTERED77.1%5,18840.52026-10-02 13:27:21REBUILD
ASSET.schedule.ShiftHeader.IX_BookingStatus#p2222/25NONCLUSTERED77.1%1,0668.32026-10-02 02:02:35REBUILD
ASSET.schedule.SupplierSnapshot.IX_ContractLog#p2121/25NONCLUSTERED76.7%1,1448.92026-10-02 02:02:23REBUILD
ASSET.schedule.SupplierSnapshot.IX_ContractLog#p2222/25NONCLUSTERED75.4%1,0718.42026-10-02 02:02:23REBUILD
ASSET.schedule.PolicyStatus.IX_SupplierLine#p2525/25NONCLUSTERED67.3%1,41311.02026-10-02 13:27:21REBUILD
ASSET.schedule.CustomerHistory.PK_PayrollAudit#p2525/25CLUSTERED66.9%1,42711.12026-10-02 02:04:23REBUILD
host_726.schedule.BillingDetail.IX_TicketHeader1/1NONCLUSTERED56.0%295,2282306.52026-10-02 16:10:25REORGANIZE
host_726.schedule.RosterResult.PK_PricingSummary1/1CLUSTERED55.2%1,254,9309804.12026-10-02 16:11:30REORGANIZE
host_726.schedule.SettlementLog.IX_PolicyLine1/1NONCLUSTERED54.0%251,5571965.32026-10-02 16:10:38REORGANIZE
host_726.schedule.SettlementLog.IX_TicketLine1/1NONCLUSTERED53.9%337,4972636.72026-10-02 16:10:37REORGANIZE
host_726.schedule.PolicyStatus.PK_PricingDaily1/1CLUSTERED53.4%1,884,43914722.22026-10-02 16:11:14REORGANIZE
host_726.schedule.SettlementLog.PK_CatalogMonthly1/1CLUSTERED53.2%1,385,77610826.42026-10-02 16:10:37REORGANIZE
host_726.schedule.BillingDetail.PK_BillingLog1/1CLUSTERED53.0%1,004,5187847.82026-10-02 16:10:25REORGANIZE
host_726.schedule.PolicyStatus.IX_ForecastAudit1/1NONCLUSTERED51.2%613,9264796.32026-10-02 16:11:14REORGANIZE
host_726.schedule.RosterResult.IX_AssetStaging1/1NONCLUSTERED51.1%247,7991935.92026-10-02 16:11:30REORGANIZE
host_726.schedule.PolicyStatus.IX_SupplierLine1/1NONCLUSTERED49.0%457,4433573.82026-10-02 16:11:15REORGANIZE
host_726.schedule.CustomerHistory.PK_PayrollAudit1/1CLUSTERED44.5%609,2644759.92026-10-02 16:11:15REORGANIZE
host_726.schedule.ShiftHeader.IX_BookingStatus1/1NONCLUSTERED40.7%32,221251.72026-10-02 16:10:18REORGANIZE
ASSET.emp.BatchAudit.UX_LedgerStaging1/1NONCLUSTERED39.6%21,220165.82026-10-01 03:16:20REORGANIZE
host_726.schedule.SupplierSnapshot.PK_AssetStatus1/1CLUSTERED34.6%145,5621137.22026-10-02 16:10:10REORGANIZE
host_726.emp.PolicyHistory.PK_OrdersDaily1/1CLUSTERED32.7%119,744935.52026-10-02 16:11:40REORGANIZE
host_726.schedule.CampaignDaily.PK_PricingEntry1/1CLUSTERED30.4%5,21340.7neverREORGANIZE

All indexes (1701)

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

IndexidTypeUniqPKConstrFiltDisabledseeksscanslookupsupdateslast_readlast_stats_updateStateRecommend action
host-877.app.Account.PK_SettlementResult1CLUSTEREDYY23290423183350542026-10-02 15:00:142026-10-02 01:00:04USEDKEEP — primary key
host-877.app.Account.UX_PayrollAudit2NONCLUSTEREDY24028050262026-10-02 14:58:152026-10-02 01:00:04USEDkeep — in use
host-877.app.Account.UX_ContractSummary25NONCLUSTEREDYY2800282026-10-02 09:00:562026-10-02 01:00:04USEDkeep — in use
host-877.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-877.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY0005052never2026-10-02 01:00:05UNUSEDKEEP — primary key
host-877.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY000111never2026-10-02 01:00:06UNUSEDKEEP — primary key
host-877.app.App.PK_InvoiceResult1CLUSTEREDYY0590002026-10-02 14:58:152026-09-27 03:30:06USEDKEEP — primary key
host-877.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-877.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY1941989002026-10-02 14:58:152026-09-27 03:30:06USEDKEEP — primary key
host-877.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY0000never2026-09-27 03:30:06UNUSEDKEEP — primary key
host-877.app.Group.PK_BookingEntry1CLUSTEREDYY177634002026-10-02 14:58:152026-09-27 03:30:06USEDKEEP — primary key
host-877.app.Group.UX_LedgerSummary2NONCLUSTEREDY0000never2026-09-27 03:30:06UNUSEDreview carefully — unique
host-877.app.PricingLog.PK_AssetResult1CLUSTEREDYY77100722026-10-02 14:58:152026-09-29 01:00:07USEDKEEP — primary key
host-877.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY0327002026-10-02 11:24:592026-09-27 03:30:06USEDKEEP — primary key
host-877.app.WarehouseStatus.UX_QuotaLine2NONCLUSTEREDY227886002026-10-02 14:58:152026-09-27 03:30:06USEDkeep — in use
host-877.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY90920152026-10-02 14:58:152026-10-02 01:00:06USEDKEEP — primary key
host-877.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY00015never2026-10-02 01:00:06UNUSEDKEEP — primary key
host-877.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY631705002026-10-02 13:55:422026-09-27 03:30:07USEDKEEP — primary key
host-877.app.Permission.PK_ClaimHeader1CLUSTEREDYY1521344402026-10-02 14:58:152026-09-27 03:30:07USEDKEEP — primary key
host-877.app.Permission.UX_RouteQueue5NONCLUSTEREDY4933002026-10-02 14:58:152026-09-27 03:30:07USEDkeep — in use
host-877.app.Token.PK_ShipmentStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-877.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-27 03:30:07UNUSEDKEEP — primary key
host-877.dbo.QuotaArchive.IX_AssetResult1CLUSTEREDYY0000never2026-09-27 03:30:07UNUSEDKEEP — primary key
host-877.dbo.QuotaArchive.IX_InvoiceAudit2NONCLUSTERED0000never2026-09-27 03:30:07UNUSEDreview, then DROP
host-400.app.Account.PK_SettlementResult1CLUSTEREDYY0000never2026-09-27 03:30:08UNUSEDKEEP — primary key
host-400.app.Account.UX_PayrollAudit2NONCLUSTEREDY0000never2026-09-27 03:30:08UNUSEDreview carefully — unique
host-400.app.Account.UX_ContractSummary25NONCLUSTEREDYY0000never2026-09-27 03:30:08UNUSEDreview carefully — unique
host-400.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-400.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY0000never2026-09-27 03:30:09UNUSEDKEEP — primary key
host-400.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY0000never2026-09-27 03:30:09UNUSEDKEEP — primary key
host-400.app.App.PK_InvoiceResult1CLUSTEREDYY0000never2026-09-27 03:30:09UNUSEDKEEP — primary key
host-400.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-400.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY0000never2026-09-27 03:30:09UNUSEDKEEP — primary key
host-400.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY0000never2026-09-27 03:30:09UNUSEDKEEP — primary key
host-400.app.Group.PK_BookingEntry1CLUSTEREDYY0000never2026-09-27 03:30:09UNUSEDKEEP — primary key
host-400.app.Group.UX_LedgerSummary2NONCLUSTEREDY0000never2026-09-27 03:30:09UNUSEDreview carefully — unique
host-400.app.PricingLog.PK_AssetResult1CLUSTEREDYY0000never2026-09-27 03:30:10UNUSEDKEEP — primary key
host-400.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY0000never2026-09-27 03:30:10UNUSEDKEEP — primary key
host-400.app.WarehouseStatus.UX_QuotaLine2NONCLUSTEREDY0000never2026-09-27 03:30:10UNUSEDreview carefully — unique
host-400.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY0000never2026-09-27 03:30:10UNUSEDKEEP — primary key
host-400.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY0000never2026-09-27 03:30:10UNUSEDKEEP — primary key
host-400.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY0000never2026-09-27 03:30:10UNUSEDKEEP — primary key
host-400.app.Permission.PK_ClaimHeader1CLUSTEREDYY0000never2026-09-27 03:30:10UNUSEDKEEP — primary key
host-400.app.Permission.UX_RouteQueue5NONCLUSTEREDY0000never2026-09-27 03:30:10UNUSEDreview carefully — unique
host-400.app.Token.PK_ShipmentStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-400.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-27 03:30:10UNUSEDKEEP — primary key
host-727.app.Account.PK_SettlementResult1CLUSTEREDYY1532358814226591682026-10-02 21:00:002026-09-30 01:00:06USEDKEEP — primary key
host-727.app.Account.UX_PayrollAudit2NONCLUSTEREDY21913320091682026-10-02 19:52:362026-10-02 01:00:07USEDkeep — in use
host-727.app.Account.UX_ContractSummary11NONCLUSTEREDYY0000never2026-09-30 01:00:06COLDreview carefully — unique
host-727.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-727.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY0009164never2026-10-02 01:00:08UNUSEDKEEP — primary key
host-727.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY00040173never2026-10-02 01:00:08UNUSEDKEEP — primary key
host-727.app.App.PK_InvoiceResult1CLUSTEREDYY01428002026-10-02 19:52:362026-09-27 03:30:13USEDKEEP — primary key
host-727.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-727.app.CampaignDetail.PK_PolicyLine1CLUSTEREDYY0000never2026-09-27 03:30:13UNUSEDKEEP — primary key
host-727.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY535526980532026-10-02 19:53:352026-09-30 01:00:07USEDKEEP — primary key
host-727.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY00053never2026-09-30 01:00:07UNUSEDKEEP — primary key
host-727.app.Group.PK_BookingEntry1CLUSTEREDYY4777103032026-10-02 19:53:352026-09-27 03:30:13USEDKEEP — primary key
host-727.app.Group.UX_LedgerSummary6NONCLUSTEREDY0003never2026-10-02 01:00:08UNUSEDreview carefully — unique
host-727.app.PricingLog.PK_AssetResult1CLUSTEREDYY176400282026-10-02 19:52:362026-10-02 01:00:08USEDKEEP — primary key
host-727.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY0888002026-10-02 18:27:422026-09-27 03:30:13USEDKEEP — primary key
host-727.app.WarehouseStatus.UX_QuotaLine8NONCLUSTEREDY55621800282026-10-02 19:53:352026-10-02 01:00:09USEDkeep — in use
host-727.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY2757001802026-10-02 19:52:362026-10-02 01:00:09USEDKEEP — primary key
host-727.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY000180never2026-10-02 01:00:09UNUSEDKEEP — primary key
host-727.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY13083630002026-10-02 19:52:362026-09-27 03:30:14USEDKEEP — primary key
host-727.app.Permission.PK_ClaimHeader1CLUSTEREDYY16321951012026-10-02 19:52:362026-09-27 03:30:14USEDKEEP — primary key
host-727.app.Permission.UX_RouteQueue7NONCLUSTEREDY0001never2026-09-27 03:30:14UNUSEDreview carefully — unique
host-727.app.Token.PK_ShipmentStaging1CLUSTEREDYY0000never2026-09-27 03:30:14UNUSEDKEEP — primary key
host-727.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-27 03:30:14UNUSEDKEEP — primary key
host-727.org.CatalogQueue.PK_RouteAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-727.org.SalesArchive.PK_TicketDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-931.dbo.CampaignStaging.PK_BookingDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-27 03:30:17UNUSEDKEEP — primary key
host_726.cfg.QuotaStatus.UX_MeterSummary2NONCLUSTEREDY0000never2026-09-27 03:30:17UNUSEDreview carefully — unique
host_726.dbo.ContractResult.PK_CampaignResult1CLUSTEREDYY07072026-10-02 02:15:032026-09-27 03:30:17USEDKEEP — primary key
host_726.dbo.SettlementStaging.PK_TicketStaging1CLUSTEREDYY0007never2026-10-02 01:00:10UNUSEDKEEP — primary key
host_726.dbo.SupplierDetail.PK_ShiftResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.dbo.CampaignResult.PK_InvoiceSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.dbo.TicketQueue.PK_CampaignEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.dbo.WarehouseEntry.PK_ShiftStatus1CLUSTEREDYY359045002026-10-02 19:53:172026-09-27 03:30:17USEDKEEP — primary key
host_726.dbo.WarehouseEntry.UX_CampaignHeader2NONCLUSTEREDY0000never2026-09-27 03:30:17UNUSEDreview carefully — unique
host_726.dbo.TicketSummary.PK_SalesLine1CLUSTERED0200002026-10-02 14:29:082026-09-27 03:30:17USEDKEEP — table storage
host_726.dbo.TerritoryEntry.PK_SalesSummary1CLUSTEREDYY55117002026-10-02 19:53:172026-09-27 03:30:17USEDKEEP — primary key
host_726.dbo.TerritoryEntry.UX_TerritoryQueue2NONCLUSTEREDY0000never2026-09-27 03:30:17UNUSEDreview carefully — unique
host_726.dbo.PolicyEntry.PK_TicketEntry1CLUSTEREDYY29058002026-10-02 19:53:172026-09-27 03:30:17USEDKEEP — primary key
host_726.dbo.PolicyEntry.UX_PolicyAudit2NONCLUSTEREDY0000never2026-09-27 03:30:17UNUSEDreview carefully — unique
host_726.dbo.CampaignHeader.PK_InvoiceSnapshot1CLUSTEREDYY279965002026-10-02 19:53:172026-09-27 03:30:18USEDKEEP — primary key
host_726.dbo.CampaignHeader.UX_BillingLog2NONCLUSTEREDY0000never2026-09-27 03:30:18UNUSEDreview carefully — unique
host_726.dbo.WarehouseHeader.PK_OrdersQueue1CLUSTEREDYY039002026-10-01 15:55:542026-09-27 03:30:18USEDKEEP — primary key
host_726.dbo.WarehouseHeader.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-27 03:30:18UNUSEDreview carefully — unique
host_726.dbo.RouteQueue.PK_SupplierAudit1CLUSTEREDYY55217002026-10-02 19:53:172026-09-27 03:30:18USEDKEEP — primary key
host_726.dbo.RouteQueue.UX_CampaignQueue2NONCLUSTEREDY0000never2026-09-27 03:30:18UNUSEDreview carefully — unique
host_726.dbo.CampaignAudit.PK_BatchSnapshot1CLUSTEREDYY29058002026-10-02 19:53:172026-09-27 03:30:18USEDKEEP — primary key
host_726.dbo.CampaignAudit.UX_SupplierArchive2NONCLUSTEREDY0000never2026-09-27 03:30:18UNUSEDreview carefully — unique
host_726.dbo.ShiftDaily.PK_ReconcileStatus1CLUSTEREDYY55217002026-10-02 19:53:172026-09-27 03:30:18USEDKEEP — primary key
host_726.dbo.ShiftDaily.UX_RouteDaily2NONCLUSTEREDY0000never2026-09-27 03:30:18UNUSEDreview carefully — unique
host_726.dbo.QuotaArchive.IX_AssetResult1CLUSTEREDYY0000never2026-09-27 03:30:17UNUSEDKEEP — primary key
host_726.dbo.QuotaArchive.IX_InvoiceAudit2NONCLUSTERED0000never2026-09-27 03:30:17UNUSEDreview, then DROP
host_726.emp.WarehouseMonthly.PK_PricingHistory1CLUSTEREDYY20244012026-10-02 14:29:082026-09-29 01:00:19USEDKEEP — primary key
host_726.emp.WarehouseMonthly.UX_CustomerDetail2NONCLUSTEREDYY0001never2026-09-29 01:00:19UNUSEDreview carefully — unique
host_726.emp.SettlementLine.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-27 03:30:18UNUSEDKEEP — primary key
host_726.emp.SalesDetail.PK_BillingLog1CLUSTEREDYY0368002026-10-03 00:04:002026-09-27 03:30:18USEDKEEP — primary key
host_726.emp.BatchMonthly.PK_TicketAudit1CLUSTEREDYY0000never2026-09-27 03:30:19UNUSEDKEEP — primary key
host_726.emp.RosterLog.PK_QuotaLog1CLUSTEREDYY14200712026-10-02 12:58:112026-09-27 03:30:19USEDKEEP — primary key
host_726.emp.QuotaMonthly.IX_ShipmentEntry15NONCLUSTERED2755001732026-10-02 15:00:142026-10-02 01:00:11USEDkeep — in use
host_726.emp.QuotaMonthly.PK_ReconcileDetail1CLUSTEREDYY16527551732026-10-02 15:00:142026-10-02 01:00:11USEDKEEP — primary key
host_726.emp.OrdersEntry.PK_PolicyHeader1CLUSTEREDYY00038never2026-10-02 01:00:12UNUSEDKEEP — primary key
host_726.emp.PayrollSummary.PK_RouteSummary1CLUSTEREDYY0368002026-10-03 00:04:002026-09-27 03:30:20USEDKEEP — primary key
host_726.emp.SettlementAudit.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-27 03:30:20UNUSEDKEEP — primary key
host_726.emp.InvoiceLog.PK_BatchEntry1CLUSTEREDYY0000never2026-09-27 03:30:20UNUSEDKEEP — primary key
host_726.emp.InvoiceMonthly.PK_RouteEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.InvoiceMonthly.UX_CustomerSnapshot2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
host_726.emp.CampaignEntry.PK_TicketMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.CampaignEntry.UX_CatalogHistory2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
host_726.emp.RouteHistory.PK_CustomerMonthly1CLUSTEREDYY05002026-09-30 07:59:012026-09-27 03:30:20USEDKEEP — primary key
host_726.emp.RouteHistory.UX_CustomerQueue2NONCLUSTEREDY0000never2026-09-27 03:30:20UNUSEDreview carefully — unique
host_726.emp.CustomerHistory.PK_ShiftDaily1CLUSTEREDYY280002026-10-01 15:44:162026-09-27 03:30:21USEDKEEP — primary key
host_726.emp.ForecastEntry.PK_SettlementLog1CLUSTEREDYY0138002026-10-02 12:58:112026-09-27 03:30:21USEDKEEP — primary key
host_726.emp.ClaimQueue.PK_TerritoryResult1CLUSTEREDYY0000never2026-09-27 03:30:21UNUSEDKEEP — primary key
host_726.emp.PolicyAudit.PK_ContractAudit1CLUSTEREDYY0317002026-10-02 14:51:232026-09-27 03:30:21USEDKEEP — primary key
host_726.emp.ShipmentSummary.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-27 03:30:21UNUSEDKEEP — primary key
host_726.emp.BatchArchive.PK_ClaimHistory1CLUSTEREDYY3135002026-10-02 14:51:232026-09-27 03:30:21USEDKEEP — primary key
host_726.emp.RosterSnapshot.PK_PolicyStaging1CLUSTEREDYY0000never2026-09-27 03:30:21UNUSEDKEEP — primary key
host_726.emp.MeterResult.IX_LedgerQueue11NONCLUSTERED0840522026-10-02 14:58:152026-10-02 01:00:12USEDkeep — in use
host_726.emp.MeterResult.PK_CustomerResult1CLUSTEREDYY61883700522026-10-03 00:00:022026-10-02 01:00:12USEDKEEP — primary key
host_726.emp.PayrollHeader.PK_TicketHistory1CLUSTEREDYY29710802026-10-02 14:29:082026-10-02 01:00:13USEDKEEP — primary key
host_726.emp.OrdersAudit.PK_ShipmentHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.RosterResult.PK_MeterAudit1CLUSTEREDYY0399002026-10-03 00:04:002026-09-27 03:30:22USEDKEEP — primary key
host_726.emp.RouteHeader.PK_StaffingQueue1CLUSTEREDYY0000never2026-09-27 03:30:23UNUSEDKEEP — primary key
host_726.emp.MeterAudit.PK_ClaimLog1CLUSTEREDYY21960302026-10-02 14:29:082026-10-02 01:00:13USEDKEEP — primary key
host_726.emp.QuotaStatus.PK_OrdersArchive1CLUSTEREDYY0002never2026-10-02 01:00:14UNUSEDKEEP — primary key
host_726.emp.ShiftLine.IX_PricingAudit14NONCLUSTERED0000never2026-09-27 03:30:23UNUSEDreview, then DROP
host_726.emp.ShiftLine.PK_SettlementStatus1CLUSTEREDYY1371502026-10-03 00:04:002026-09-27 03:30:23USEDKEEP — primary key
host_726.emp.ShiftLine.UX_BookingDaily2NONCLUSTEREDY50002026-10-01 13:47:412026-09-27 03:30:23USEDkeep — in use
host_726.emp.CampaignHeader.PK_BillingQueue1CLUSTEREDYY0000never2026-09-27 03:30:23UNUSEDKEEP — primary key
host_726.emp.MeterStatus.PK_BillingStaging1CLUSTEREDYY0000never2026-09-27 03:30:24UNUSEDKEEP — primary key
host_726.emp.WarehouseStaging.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-27 03:30:24UNUSEDKEEP — primary key
host_726.emp.ForecastHeader.IX_WarehouseResult6NONCLUSTERED2330002026-10-02 14:29:082026-09-27 03:30:24USEDkeep — in use
host_726.emp.ForecastHeader.PK_OrdersAudit1CLUSTEREDYY0023302026-10-02 14:29:082026-09-27 03:30:24USEDKEEP — primary key
host_726.emp.SalesLog.PK_AssetStaging1CLUSTEREDYY0000never2026-09-27 03:30:24UNUSEDKEEP — primary key
host_726.emp.AssetDaily.PK_CustomerMonthly1CLUSTEREDYY0412002026-10-02 14:29:082026-09-27 03:30:24USEDKEEP — primary key
host_726.emp.StaffingDaily.PK_BookingLog1CLUSTEREDYY0000never2026-09-27 03:30:24UNUSEDKEEP — primary key
host_726.emp.ClaimResult.PK_TerritoryQueue1CLUSTEREDYY0000never2026-09-27 03:30:24UNUSEDKEEP — primary key
host_726.emp.CatalogLog.PK_ReconcileHeader1CLUSTEREDYY0000never2026-09-27 03:30:24UNUSEDKEEP — primary key
host_726.emp.ShipmentSnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-27 03:30:25UNUSEDKEEP — primary key
host_726.emp.PricingDaily.IX_ShiftAudit2NONCLUSTERED20002026-09-28 09:19:442026-09-27 03:30:25USEDkeep — in use
host_726.emp.PricingDaily.PK_RouteEntry1CLUSTEREDYY0216202026-10-02 14:29:082026-09-27 03:30:25USEDKEEP — primary key
host_726.emp.PolicyLog.PK_LedgerHistory1CLUSTEREDYY90281422026-10-02 14:29:082026-10-02 01:00:14USEDKEEP — primary key
host_726.emp.PolicyLog.UX_OrdersSnapshot4NONCLUSTEREDY28100422026-10-02 14:29:082026-10-02 01:00:14USEDkeep — in use
host_726.emp.RouteAudit.PK_ClaimResult1CLUSTEREDYY0002never2026-10-02 01:00:14UNUSEDKEEP — primary key
host_726.emp.PayrollDaily.IX_BillingStaging2NONCLUSTERED200122026-10-01 15:44:16neverUSEDkeep — in use
host_726.emp.PayrollDaily.PK_OrdersSnapshot1CLUSTEREDYY020122026-10-01 15:44:16neverUSEDKEEP — primary key
host_726.emp.MeterHistory.IX_ContractArchive11NONCLUSTERED71900932026-10-02 16:10:112026-10-02 01:00:15USEDkeep — in use
host_726.emp.MeterHistory.PK_BatchLog1CLUSTEREDYY56847359172871002026-10-03 00:03:572026-10-02 01:00:15USEDKEEP — primary key
host_726.emp.MeterHistory.UX_BatchLog3NONCLUSTEREDYY00093never2026-10-02 01:00:15UNUSEDreview carefully — unique
host_726.emp.MeterHistory.UX_ForecastHeader23NONCLUSTEREDY329900932026-10-02 15:00:142026-10-02 01:00:15USEDkeep — in use
host_726.emp.MeterHistory.UX_CustomerSnapshot2NONCLUSTEREDYY200932026-09-28 14:31:152026-10-02 01:00:15USEDkeep — in use
host_726.emp.MeterHistory.UX_QuotaStaging13NONCLUSTEREDY391700932026-10-02 15:00:142026-10-02 01:00:15USEDkeep — in use
host_726.emp.TerritoryLine.PK_LedgerArchive1CLUSTEREDYY440380722026-10-02 12:58:392026-09-29 01:00:24USEDKEEP — primary key
host_726.emp.SalesStaging.PK_PolicyDaily1CLUSTEREDYY348272072026-10-02 14:29:082026-09-27 03:30:27USEDKEEP — primary key
host_726.emp.TerritoryDaily.PK_MeterLog1CLUSTEREDYY0000never2026-09-27 03:30:27UNUSEDKEEP — primary key
host_726.emp.SettlementQueue.IX_PolicyAudit2NONCLUSTERED00040never2026-10-01 01:00:14UNUSEDreview, then DROP
host_726.emp.SettlementQueue.PK_SalesEntry1CLUSTEREDYY00040never2026-10-01 01:00:14UNUSEDKEEP — primary key
host_726.emp.StaffingMonthly.IX_ReconcileEntry2NONCLUSTERED00038never2026-09-29 01:00:25UNUSEDreview, then DROP
host_726.emp.StaffingMonthly.IX_SalesQueue3NONCLUSTERED65160382026-10-02 14:29:082026-09-29 01:00:25USEDkeep — in use
host_726.emp.StaffingMonthly.PK_CampaignStatus1CLUSTEREDYY21652263382026-10-02 14:29:082026-09-29 01:00:25USEDKEEP — primary key
host_726.emp.TicketQueue.PK_BatchDaily1CLUSTEREDYY00233362026-10-02 14:29:082026-10-02 01:00:16USEDKEEP — primary key
host_726.emp.TicketQueue.UX_PayrollDaily2NONCLUSTEREDY23300362026-10-02 14:29:082026-10-02 01:00:16USEDkeep — in use
host_726.emp.MeterStatus.PK_CustomerDetail1CLUSTEREDYY00036never2026-10-02 01:00:16UNUSEDKEEP — primary key
host_726.emp.OrdersEntry.PK_TerritoryAudit1CLUSTEREDYY0583002026-10-03 00:04:002026-09-27 03:30:28USEDKEEP — primary key
host_726.emp.InvoiceLog.PK_BillingDetail1CLUSTEREDYY00021never2026-10-02 01:00:19UNUSEDKEEP — primary key
host_726.emp.CampaignHistory.IX_QuotaDetail2NONCLUSTERED5538000002026-10-02 12:58:472026-09-27 03:30:29USEDkeep — in use
host_726.emp.CampaignHistory.PK_AssetHeader1CLUSTEREDYY040555380002026-10-02 16:10:192026-09-27 03:30:29USEDKEEP — primary key
host_726.emp.ContractArchive.PK_BookingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.TicketLine.PK_CampaignEntry1CLUSTEREDYY06002026-10-01 10:46:112026-09-27 03:30:29USEDKEEP — primary key
host_726.emp.BatchAudit.IX_PolicyArchive15NONCLUSTERED35429503259022026-10-02 16:11:512026-10-02 15:53:02USEDkeep — in use
host_726.emp.BatchAudit.PK_ForecastSummary1CLUSTEREDYY1085571085440494345362026-10-02 16:11:512026-10-02 15:53:02USEDKEEP — primary key
host_726.emp.BatchAudit.UX_LedgerStaging2NONCLUSTEREDY761216003259022026-10-02 16:11:462026-10-02 15:53:02USEDkeep — in use
host_726.emp.ClaimAudit.PK_LedgerDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.ClaimAudit.UX_RouteMonthly2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
host_726.emp.PolicyHistory.PK_OrdersDaily1CLUSTEREDYY12324316402318992026-10-02 16:11:402026-10-02 16:11:40USEDKEEP — primary key
host_726.emp.BillingEntry.PK_StaffingAudit1CLUSTEREDYY013401232652026-10-02 00:05:362026-10-02 01:01:51USEDKEEP — primary key
host_726.emp.BillingEntry.UX_StaffingLog2NONCLUSTEREDY145894201232652026-10-02 16:11:362026-10-02 01:01:51USEDkeep — in use
host_726.emp.BillingAudit.IX_PolicyHeader8NONCLUSTERED2001232652026-09-28 14:13:362026-09-27 03:31:33USEDkeep — in use
host_726.emp.BillingAudit.PK_PolicyDetail1CLUSTEREDYY000123265never2026-09-27 03:31:33UNUSEDKEEP — primary key
host_726.emp.BillingAudit.UX_SupplierSnapshot2NONCLUSTEREDY145399201232652026-10-02 16:11:372026-09-27 03:31:33USEDkeep — in use
host_726.emp.ShipmentStaging.PK_TerritoryStatus1CLUSTEREDYY0920146312026-10-02 16:11:372026-09-27 03:31:34USEDKEEP — primary key
host_726.emp.ShipmentStaging.UX_RosterDaily2NONCLUSTEREDY1453900146312026-10-02 12:58:482026-09-27 03:31:34USEDkeep — in use
host_726.emp.SalesLine.PK_CampaignResult1CLUSTEREDYY123633002318992026-10-02 16:11:422026-10-02 16:08:42USEDKEEP — primary key
host_726.emp.LedgerSnapshot.PK_CampaignStatus1CLUSTEREDYY00020never2026-10-02 01:01:53UNUSEDKEEP — primary key
host_726.emp.ReconcileDetail.PK_CampaignQueue1CLUSTEREDYY02420352026-10-02 14:29:082026-10-02 01:01:53USEDKEEP — primary key
host_726.emp.PolicyStaging.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.ReconcileStaging.PK_ContractStaging1CLUSTEREDYY7245002026-10-02 19:53:172026-09-27 03:31:41USEDKEEP — primary key
host_726.emp.ReconcileStaging.UX_OrdersHistory2NONCLUSTEREDY0000never2026-09-27 03:31:41UNUSEDreview carefully — unique
host_726.emp.MeterStatus.PK_ReconcileMonthly1CLUSTEREDYY202794712026-10-02 15:00:142026-10-02 01:01:53USEDKEEP — primary key
host_726.emp.MeterStatus.UX_ReconcileAudit7NONCLUSTEREDY279400712026-10-02 15:00:142026-10-02 01:01:53USEDkeep — in use
host_726.emp.PricingAudit.PK_ReconcileSnapshot1CLUSTEREDYY0002never2026-10-02 01:01:54UNUSEDKEEP — primary key
host_726.emp.OrdersMonthly.IX_QuotaArchive2NONCLUSTEREDY000153never2026-10-02 01:01:54UNUSEDreview, then DROP
host_726.emp.OrdersMonthly.IX_PayrollResult3NONCLUSTEREDY0000never2026-10-02 01:01:54UNUSEDreview, then DROP
host_726.emp.OrdersMonthly.IX_TicketSnapshot4NONCLUSTERED4406901742026-10-02 14:51:232026-10-02 01:01:54USEDkeep — in use
host_726.emp.OrdersMonthly.IX_SettlementLine5NONCLUSTERED000174never2026-10-02 01:01:54UNUSEDreview, then DROP
host_726.emp.OrdersMonthly.PK_ShipmentSnapshot1CLUSTEREDYY1001742026-09-25 16:11:422026-10-02 01:01:54USEDKEEP — primary key
host_726.emp.RosterQueue.PK_SettlementHistory1CLUSTEREDYY0196002026-10-02 11:05:122026-09-27 03:31:42USEDKEEP — primary key
host_726.emp.TicketAudit.IX_LedgerLog2NONCLUSTERED0001never2026-09-29 01:02:13UNUSEDreview, then DROP
host_726.emp.TicketAudit.PK_LedgerStatus1CLUSTEREDYY0001never2026-09-29 01:02:13UNUSEDKEEP — primary key
host_726.emp.InvoiceResult.PK_ShipmentMonthly1CLUSTEREDYY0001never2026-09-29 01:02:13UNUSEDKEEP — primary key
host_726.emp.CustomerLog.IX_PolicyDaily20NONCLUSTERED0360162026-10-02 02:15:022026-10-02 01:01:54USEDkeep — in use
host_726.emp.CustomerLog.IX_PayrollResult21NONCLUSTERED110761600252026-10-02 12:58:482026-10-02 01:01:54USEDkeep — in use
host_726.emp.CustomerLog.PK_StaffingDaily1CLUSTEREDYY2753721107640252026-10-02 16:10:212026-10-02 01:01:54USEDKEEP — primary key
host_726.emp.InvoiceAudit.IX_SettlementResult10NONCLUSTERED185160192026-10-02 14:51:232026-10-02 01:01:55USEDkeep — in use
host_726.emp.InvoiceAudit.PK_QuotaEntry1CLUSTEREDYY0206192026-10-02 02:15:032026-10-02 01:01:55USEDKEEP — primary key
host_726.emp.MeterSummary.PK_AssetEntry1CLUSTEREDYY00016never2026-10-02 01:01:55UNUSEDKEEP — primary key
host_726.emp.AssetSummary.PK_SupplierStaging1CLUSTEREDYY070162026-10-02 02:15:022026-10-02 01:01:55USEDKEEP — primary key
host_726.emp.SupplierStaging.IX_CampaignResult22NONCLUSTERED01240722026-10-02 13:55:472026-10-02 01:01:55USEDkeep — in use
host_726.emp.SupplierStaging.IX_StaffingSnapshot25NONCLUSTERED2773511420722026-10-02 16:10:212026-10-02 01:01:55USEDkeep — in use
host_726.emp.SupplierStaging.IX_MeterStaging16NONCLUSTERED00060never2026-10-02 01:01:55UNUSEDreview, then DROP
host_726.emp.SupplierStaging.IX_StaffingEntry24NONCLUSTERED00068never2026-10-02 01:01:55UNUSEDreview, then DROP
host_726.emp.SupplierStaging.PK_PayrollMonthly1CLUSTEREDYY84590216722026-10-02 14:58:162026-10-02 01:01:55USEDKEEP — primary key
host_726.emp.CustomerStatus.IX_ReconcileLine10NONCLUSTERED2531910422026-10-02 14:51:222026-10-02 01:01:56USEDkeep — in use
host_726.emp.CustomerStatus.PK_PolicyHistory1CLUSTEREDYY07176422026-10-02 13:01:362026-10-02 01:01:56USEDKEEP — primary key
host_726.emp.BillingAudit.PK_CustomerEntry1CLUSTEREDYY00033never2026-10-02 01:01:56UNUSEDKEEP — primary key
host_726.emp.PolicyLine.PK_OrdersSummary1CLUSTEREDYY034002026-10-02 13:01:362026-09-27 03:31:45USEDKEEP — primary key
host_726.emp.RouteStaging.PK_WarehouseLine1CLUSTEREDYY09002026-10-02 12:58:112026-09-27 03:31:45USEDKEEP — primary key
host_726.emp.CampaignMonthly.PK_OrdersArchive1CLUSTEREDYY029002026-10-02 13:01:362026-09-27 03:31:45USEDKEEP — primary key
host_726.emp.CatalogSnapshot.PK_ClaimHistory1CLUSTEREDYY0000never2026-09-27 03:31:46UNUSEDKEEP — primary key
host_726.emp.BillingDaily.PK_CustomerLine1CLUSTEREDYY01628162026-10-02 12:58:392026-09-27 03:31:46USEDKEEP — primary key
host_726.emp.BillingDaily.UX_LedgerDaily2NONCLUSTEREDY2800162026-10-02 12:58:392026-09-27 03:31:46USEDkeep — in use
host_726.emp.SupplierHistory.PK_WarehouseMonthly1CLUSTEREDYY070672026-10-02 02:15:022026-10-02 01:01:56USEDKEEP — primary key
host_726.emp.ShipmentMonthly.IX_SupplierEntry12NONCLUSTERED19700272026-10-02 14:51:222026-10-02 01:01:57USEDkeep — in use
host_726.emp.ShipmentMonthly.IX_InvoiceStaging5NONCLUSTERED51600272026-10-02 15:00:142026-10-02 01:01:57USEDkeep — in use
host_726.emp.ShipmentMonthly.PK_BatchDaily1CLUSTEREDYY20504292026-10-02 15:00:142026-10-02 01:01:57USEDKEEP — primary key
host_726.emp.AssetDetail.PK_ReconcileResult1CLUSTEREDYY00016never2026-10-02 01:01:57UNUSEDKEEP — primary key
host_726.emp.AssetSnapshot.IX_ForecastStatus6NONCLUSTERED2769471210202026-10-02 16:10:202026-10-02 01:01:57USEDkeep — in use
host_726.emp.AssetSnapshot.IX_SalesDaily5NONCLUSTERED45536310202026-10-03 00:03:562026-10-02 01:01:57USEDkeep — in use
host_726.emp.AssetSnapshot.PK_OrdersDetail1CLUSTEREDYY304202026-09-28 14:13:362026-10-02 01:01:57USEDKEEP — primary key
host_726.emp.PricingStatus.PK_PolicyStatus1CLUSTEREDYY00018never2026-10-02 01:01:58UNUSEDKEEP — primary key
host_726.emp.TicketSnapshot.IX_BookingHistory14NONCLUSTERED06610172026-10-02 16:10:202026-10-02 01:01:58USEDkeep — in use
host_726.emp.TicketSnapshot.PK_CampaignQueue1CLUSTEREDYY27762536690172026-10-03 00:03:562026-10-02 01:01:58USEDKEEP — primary key
host_726.emp.ForecastMonthly.PK_CampaignSummary1CLUSTEREDYY070152026-10-02 02:15:022026-10-02 01:01:59USEDKEEP — primary key
host_726.emp.PricingStatus.IX_QuotaLog8NONCLUSTERED8000152026-10-02 14:51:232026-10-02 01:01:59USEDkeep — in use
host_726.emp.PricingStatus.IX_ClaimEntry6NONCLUSTERED27722037310152026-10-03 00:03:562026-10-02 01:01:59USEDkeep — in use
host_726.emp.PricingStatus.PK_LedgerResult1CLUSTEREDYY360180152026-10-02 14:58:162026-10-02 01:01:59USEDKEEP — primary key
host_726.emp.PayrollHistory.PK_LedgerQueue1CLUSTEREDYY00013never2026-10-02 01:01:59UNUSEDKEEP — primary key
host_726.emp.QuotaSummary.IX_StaffingQueue10NONCLUSTERED185620192026-10-02 14:51:232026-10-02 01:02:00USEDkeep — in use
host_726.emp.QuotaSummary.PK_LedgerEntry1CLUSTEREDYY0753192026-10-02 02:15:022026-10-02 01:02:00USEDKEEP — primary key
host_726.emp.PricingQueue.PK_PricingStaging1CLUSTEREDYY00016never2026-10-02 01:02:00UNUSEDKEEP — primary key
host_726.emp.BookingMonthly.IX_ShipmentAudit5NONCLUSTERED1018304569010172026-10-03 00:03:562026-10-02 01:02:00USEDkeep — in use
host_726.emp.BookingMonthly.PK_WarehouseLog1CLUSTEREDYY00017never2026-10-02 01:02:00UNUSEDKEEP — primary key
host_726.emp.MeterSnapshot.PK_StaffingSummary1CLUSTEREDYY00017never2026-10-02 01:02:00UNUSEDKEEP — primary key
host_726.emp.BatchMonthly.IX_ClaimSummary17NONCLUSTERED0300162026-10-02 02:15:022026-10-02 01:02:01USEDkeep — in use
host_726.emp.BatchMonthly.PK_InvoiceDetail1CLUSTEREDYY45308910552423162026-10-03 00:03:562026-10-02 01:02:01USEDKEEP — primary key
host_726.emp.StaffingAudit.PK_ForecastHeader1CLUSTEREDYY070162026-10-02 02:15:022026-10-02 01:02:02USEDKEEP — primary key
host_726.emp.BatchLog.PK_SalesDetail1CLUSTEREDYY05583910182026-10-03 00:03:572026-10-02 01:02:02USEDKEEP — primary key
host_726.emp.RouteHistory.PK_MeterEntry1CLUSTEREDYY00018never2026-10-02 01:02:03UNUSEDKEEP — primary key
host_726.emp.CampaignResult.IX_ClaimStatus14NONCLUSTERED78700362026-10-02 14:58:162026-10-02 01:02:03USEDkeep — in use
host_726.emp.CampaignResult.IX_CustomerQueue12NONCLUSTERED45233300722026-10-02 12:58:482026-10-02 01:02:04USEDkeep — in use
host_726.emp.CampaignResult.PK_StaffingArchive1CLUSTEREDYY44292554381762026-10-02 16:10:212026-10-02 01:02:03USEDKEEP — primary key
host_726.emp.SalesHeader.IX_BookingSummary2NONCLUSTERED000134never2026-10-02 01:02:07UNUSEDreview, then DROP
host_726.emp.SalesHeader.PK_CatalogQueue1CLUSTEREDYY000134never2026-10-02 01:02:07UNUSEDKEEP — primary key
host_726.emp.PayrollHistory.PK_CampaignStaging1CLUSTEREDYY465368022026-10-03 00:04:002026-09-27 03:31:54USEDKEEP — primary key
host_726.emp.TerritoryDaily.PK_RouteArchive1CLUSTEREDYY0002never2026-09-27 03:31:54UNUSEDKEEP — primary key
host_726.emp.CatalogSummary.IX_PricingSnapshot24NONCLUSTERED1301030522026-10-02 14:51:232026-10-02 01:02:05USEDkeep — in use
host_726.emp.CatalogSummary.IX_WarehouseSnapshot19NONCLUSTERED2652650512026-10-02 16:10:112026-10-02 01:02:05USEDkeep — in use
host_726.emp.CatalogSummary.IX_ReconcileSummary16NONCLUSTERED100000512026-10-02 14:51:232026-10-02 01:02:05USEDkeep — in use
host_726.emp.CatalogSummary.IX_AssetEntry25NONCLUSTERED182320522026-10-02 12:58:112026-10-02 01:02:05USEDkeep — in use
host_726.emp.CatalogSummary.PK_ShipmentStaging1CLUSTEREDYY2793412782045572026-10-03 00:00:002026-10-02 01:02:05USEDKEEP — primary key
host_726.emp.CatalogSummary.UX_OrdersAudit5NONCLUSTEREDY16670512026-10-02 11:05:152026-10-02 01:02:05USEDkeep — in use
host_726.emp.CatalogSummary.UX_LedgerHistory12NONCLUSTEREDYY55600562026-10-02 14:51:232026-10-02 01:02:05USEDkeep — in use
host_726.emp.TicketMonthly.PK_LedgerAudit1CLUSTEREDYY693032026-10-02 10:59:572026-09-27 03:31:56USEDKEEP — primary key
host_726.emp.BillingQueue.IX_AssetDetail11NONCLUSTERED0980542026-10-02 02:18:582026-10-02 01:02:06USEDkeep — in use
host_726.emp.BillingQueue.IX_ContractSummary8NONCLUSTERED27771700542026-10-02 14:58:152026-10-02 01:02:06USEDkeep — in use
host_726.emp.BillingQueue.PK_ShipmentEntry1CLUSTEREDYY0609277710542026-10-02 16:10:112026-10-02 01:02:06USEDKEEP — primary key
host_726.emp.CampaignResult.IX_SupplierLine10NONCLUSTERED5900522026-10-02 11:23:272026-10-02 01:02:06USEDkeep — in use
host_726.emp.CampaignResult.PK_CustomerLine1CLUSTEREDYY05259522026-10-02 11:23:272026-10-02 01:02:06USEDKEEP — primary key
host_726.org.SettlementSnapshot.PK_org.SettlementSnapshot1CLUSTEREDYY01002026-09-28 11:20:202026-09-27 03:31:57USEDKEEP — primary key
host_726.org.SettlementSnapshot.UX_BillingLine2NONCLUSTEREDY0000never2026-09-27 03:31:57UNUSEDreview carefully — unique
host_726.org.PolicySummary.IX_AssetEntry18NONCLUSTERED3082980142026-10-02 14:58:152026-09-29 01:02:25USEDkeep — in use
host_726.org.PolicySummary.PK_QuotaAudit1CLUSTEREDYY3225682388282026-10-02 14:58:162026-09-29 01:02:25USEDKEEP — primary key
host_726.org.PolicySummary.UX_ForecastHistory2NONCLUSTEREDYY870072026-10-02 14:58:152026-09-29 01:02:25USEDkeep — in use
host_726.org.BatchMonthly.PK_WarehouseSummary1CLUSTEREDYY099002026-10-02 08:41:572026-09-27 03:31:58USEDKEEP — primary key
host_726.org.BatchMonthly.UX_SalesSnapshot2NONCLUSTEREDYY0000never2026-09-27 03:31:58UNUSEDreview carefully — unique
host_726.org.CampaignQueue.PK_RosterDaily1CLUSTEREDYY0000never2026-09-27 03:31:58UNUSEDKEEP — primary key
host_726.org.TicketLog.PK_WarehouseDetail1CLUSTEREDYY26240232026-10-02 11:02:552026-09-27 03:31:58USEDKEEP — primary key
host_726.org.TicketLog.UX_SalesMonthly4NONCLUSTEREDY00023never2026-10-02 01:02:07UNUSEDreview carefully — unique
host_726.org.Company.PK_QuotaStaging1CLUSTEREDYY14051342812522026-10-03 00:04:002026-09-27 03:31:58USEDKEEP — primary key
host_726.org.Company.UX_PricingResult8NONCLUSTEREDYY025022026-10-01 15:40:542026-09-27 03:31:58USEDkeep — in use
host_726.org.ShipmentAudit.PK_ForecastHeader1CLUSTEREDYY02507152875102026-10-03 00:04:002026-09-27 03:31:58USEDKEEP — primary key
host_726.org.ShipmentAudit.UX_BatchArchive2NONCLUSTEREDY1528643109002026-10-03 00:04:002026-09-27 03:31:58USEDkeep — in use
host_726.org.WarehouseStaging.PK_MeterHistory1CLUSTEREDYY0000never2026-09-27 03:31:59UNUSEDKEEP — primary key
host_726.org.BookingResult.PK_BillingQueue1CLUSTEREDYY0000never2026-09-27 03:31:59UNUSEDKEEP — primary key
host_726.org.InvoiceQueue.PK_TicketEntry1CLUSTEREDYY88012026-10-01 13:47:412026-09-27 03:31:59USEDKEEP — primary key
host_726.org.PricingStatus.PK_TerritoryStatus1CLUSTEREDYY0002never2026-09-27 03:31:59UNUSEDKEEP — primary key
host_726.org.CatalogHeader.PK_ShiftStatus1CLUSTEREDYY111620172026-10-02 16:10:102026-09-27 03:31:59USEDKEEP — primary key
host_726.org.PolicySummary.PK_CatalogQueue1CLUSTEREDYY00017never2026-09-29 01:02:25UNUSEDKEEP — primary key
host_726.org.CatalogAudit.PK_AssetStatus1CLUSTEREDYY0002never2026-09-27 03:31:59UNUSEDKEEP — primary key
host_726.org.OrdersSummary.PK_StaffingAudit1CLUSTEREDYY0000never2026-09-27 03:31:59UNUSEDKEEP — primary key
host_726.org.ContractResult.PK_PolicyLine1CLUSTEREDYY0000never2026-09-27 03:31:59UNUSEDKEEP — primary key
host_726.org.SupplierHistory.IX_ShipmentSummary2NONCLUSTERED0000never2026-09-27 03:31:59UNUSEDreview, then DROP
host_726.org.SupplierHistory.PK_CustomerDetail1CLUSTEREDYY0000never2026-09-27 03:31:59UNUSEDKEEP — primary key
host_726.org.ContractStaging.PK_CatalogDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.BatchSummary.PK_SettlementHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.BillingHeader.IX_ShiftHistory2NONCLUSTERED0000never2026-09-27 03:31:59UNUSEDreview, then DROP
host_726.org.BillingHeader.PK_InvoiceMonthly1CLUSTEREDYY0000never2026-09-27 03:31:59UNUSEDKEEP — primary key
host_726.org.ShipmentSummary.IX_StaffingResult2NONCLUSTERED0000never2026-09-27 03:31:59UNUSEDreview, then DROP
host_726.org.ShipmentSummary.PK_ClaimDetail1CLUSTEREDYY0000never2026-09-27 03:31:59UNUSEDKEEP — primary key
host_726.org.SalesStatus.IX_ClaimHeader2NONCLUSTEREDY0000never2026-09-27 03:31:59UNUSEDreview carefully — unique
host_726.org.SalesStatus.PK_CampaignSnapshot1CLUSTEREDYY0000never2026-09-27 03:31:59UNUSEDKEEP — primary key
host_726.org.PolicyResult.PK_ForecastStaging1CLUSTEREDYY131385090002026-10-02 16:10:142026-09-27 03:32:00USEDKEEP — primary key
host_726.org.AssetSummary.PK_TicketStaging1CLUSTEREDYY0261072026-10-02 14:58:152026-09-29 01:02:25USEDKEEP — primary key
host_726.org.AssetSummary.UX_ShipmentSummary4NONCLUSTEREDY120072026-09-28 11:19:202026-09-29 01:02:25USEDkeep — in use
host_726.org.ShipmentQueue.PK_InvoiceStaging1CLUSTEREDYY268265739012026-10-02 16:11:312026-09-29 01:02:25USEDKEEP — primary key
host_726.org.PolicyEntry.PK_SettlementSnapshot1CLUSTEREDYY22173052026-10-02 11:02:552026-09-29 00:20:00USEDKEEP — primary key
host_726.org.PolicyEntry.UX_ShiftSnapshot9NONCLUSTEREDYY0005never2026-09-29 00:20:00UNUSEDreview carefully — unique
host_726.org.MeterAudit.IX_WarehouseQueue3NONCLUSTERED1640002026-10-02 11:02:552026-09-27 03:32:00USEDkeep — in use
host_726.org.MeterAudit.PK_BillingDetail1CLUSTEREDYY10002026-09-25 16:11:422026-09-27 03:32:00USEDKEEP — primary key
host_726.org.BillingHeader.PK_ContractStaging1CLUSTEREDYY0000never2026-09-27 03:32:00UNUSEDKEEP — primary key
host_726.org.TicketSnapshot.PK_ForecastSnapshot1CLUSTEREDYY0000never2026-09-27 03:32:00UNUSEDKEEP — primary key
host_726.org.CustomerStaging.PK_CustomerHeader1CLUSTEREDYY0000never2026-09-27 03:32:00UNUSEDKEEP — primary key
host_726.org.KPI.PK_ShiftLine1CLUSTEREDYY0000never2026-09-27 03:32:00UNUSEDKEEP — primary key
host_726.org.KPI.UX_ShiftHeader8NONCLUSTEREDYY0000never2026-09-27 03:32:00UNUSEDreview carefully — unique
host_726.org.StaffingArchive.PK_SettlementResult1CLUSTEREDYY01002026-09-28 11:20:202026-09-27 03:32:01USEDKEEP — primary key
host_726.org.CustomerEntry.PK_RouteSummary1CLUSTEREDYY0000never2026-09-27 03:32:01UNUSEDKEEP — primary key
host_726.org.PricingDaily.PK_CampaignArchive1CLUSTEREDYY0000never2026-09-27 03:32:01UNUSEDKEEP — primary key
host_726.org.PricingDaily.UX_BillingArchive2NONCLUSTEREDY0000never2026-09-27 03:32:01UNUSEDreview carefully — unique
host_726.org.TicketLine.PK_SupplierMonthly1CLUSTEREDYY0000never2026-09-27 03:32:01UNUSEDKEEP — primary key
host_726.org.BillingArchive.PK_MeterSummary1CLUSTEREDYY0000never2026-09-27 03:32:01UNUSEDKEEP — primary key
host_726.org.MeterEntry.PK_SupplierLog1CLUSTEREDYY0000never2026-09-27 03:32:01UNUSEDKEEP — primary key
host_726.org.ReconcileAudit.PK_PolicyLog1CLUSTEREDYY31310012026-10-02 19:53:212026-09-29 01:02:26USEDKEEP — primary key
host_726.org.ReconcileAudit.UQ_ShipmentResult2NONCLUSTEREDYY0001never2026-09-29 01:02:26UNUSEDreview carefully — unique
host_726.org.StaffingAudit.PK_RosterArchive1CLUSTEREDYY0000never2026-09-27 03:32:01UNUSEDKEEP — primary key
host_726.org.ShiftResult.PK_AssetAudit1CLUSTEREDYY109046109869012026-10-02 16:11:502026-09-29 01:02:26USEDKEEP — primary key
host_726.org.BatchMonthly.PK_SalesLine1CLUSTEREDYY0110002026-10-02 12:58:112026-09-27 03:32:02USEDKEEP — primary key
host_726.org.RosterMonthly.IX_AssetDetail2NONCLUSTERED0000never2026-09-27 03:32:02UNUSEDreview, then DROP
host_726.org.RosterMonthly.PK_ForecastDaily1CLUSTEREDYY057002026-10-01 00:05:062026-09-27 03:32:02USEDKEEP — primary key
host_726.org.InvoiceStaging.IX_AssetAudit2NONCLUSTERED0000never2026-09-27 03:32:02UNUSEDreview, then DROP
host_726.org.InvoiceStaging.PK_CustomerMonthly1CLUSTEREDYY0000never2026-09-27 03:32:02UNUSEDKEEP — primary key
host_726.org.StaffingAudit.PK_AssetLog1CLUSTEREDYY0000never2026-09-27 03:32:02UNUSEDKEEP — primary key
host_726.org.Level.PK_ShiftStaging1CLUSTEREDYY21181072026-10-02 12:58:112026-09-29 01:02:26USEDKEEP — primary key
host_726.org.Level.UX_SettlementHistory2NONCLUSTEREDYY0007never2026-09-29 01:02:26UNUSEDreview carefully — unique
host_726.org.ContractHistory.PK_RouteArchive1CLUSTEREDYY0000never2026-09-27 03:32:02UNUSEDKEEP — primary key
host_726.org.QuotaEntry.IX_AssetHistory2NONCLUSTERED0001never2026-09-29 01:02:27UNUSEDreview, then DROP
host_726.org.QuotaEntry.PK_LedgerQueue1CLUSTEREDYY0262926012026-10-02 16:11:312026-09-29 01:02:27USEDKEEP — primary key
host_726.org.ClaimQueue.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-27 03:32:02UNUSEDKEEP — primary key
host_726.org.SupplierLine.PK_InvoiceStatus1CLUSTEREDYY4881002026-10-01 10:32:452026-09-27 03:32:02USEDKEEP — primary key
host_726.org.InvoiceHistory.PK_ContractDaily1CLUSTEREDYY0000never2026-09-27 03:32:03UNUSEDKEEP — primary key
host_726.org.AssetHeader.IX_PayrollAudit2NONCLUSTERED4880002026-10-01 10:32:452026-09-27 03:32:03USEDkeep — in use
host_726.org.AssetHeader.PK_LedgerResult1CLUSTEREDYY10002026-09-28 11:21:552026-09-27 03:32:03USEDKEEP — primary key
host_726.org.TerritoryStatus.PK_PayrollLine1CLUSTEREDYY0000never2026-09-27 03:32:03UNUSEDKEEP — primary key
host_726.org.RosterLine.PK_BillingDaily1CLUSTEREDYY0000never2026-09-27 03:32:03UNUSEDKEEP — primary key
host_726.org.ForecastArchive.PK_CampaignHeader1CLUSTEREDYY18012026-09-28 11:21:492026-09-29 01:02:27USEDKEEP — primary key
host_726.org.PolicySummary.PK_WarehouseSnapshot1CLUSTEREDYY096002026-10-01 10:32:452026-09-27 03:32:03USEDKEEP — primary key
host_726.org.ClaimMonthly.PK_RouteArchive1CLUSTEREDYY0000never2026-09-27 03:32:03UNUSEDKEEP — primary key
host_726.org.OrdersEntry.PK_MeterDaily1CLUSTEREDYY075002026-10-02 08:47:002026-09-27 03:32:03USEDKEEP — primary key
host_726.org.LedgerStaging.PK_BatchLine1CLUSTEREDYY0000never2026-09-27 03:32:03UNUSEDKEEP — primary key
host_726.org.Position.PK_PolicySummary1CLUSTEREDYY2274513062026-10-02 14:58:162026-09-29 01:02:27USEDKEEP — primary key
host_726.org.Position.UX_MeterArchive2NONCLUSTEREDYY0006never2026-09-29 00:20:00UNUSEDreview carefully — unique
host_726.org.CampaignQueue.PK_BillingArchive1CLUSTEREDYY28963652026-10-02 11:02:552026-09-29 01:02:27USEDKEEP — primary key
host_726.org.CampaignQueue.UX_TicketDaily2NONCLUSTEREDY3200052026-10-02 14:51:232026-09-29 01:02:27USEDkeep — in use
host_726.org.MeterResult.PK_CatalogStaging1CLUSTEREDYY0000never2026-09-27 03:32:04UNUSEDKEEP — primary key
host_726.org.QuotaLine.PK_AssetAudit1CLUSTEREDYY01002026-09-28 11:20:202026-09-27 03:32:04USEDKEEP — primary key
host_726.org.QuotaLine.UX_PricingAudit2NONCLUSTEREDYY0000never2026-09-27 03:32:04UNUSEDreview carefully — unique
host_726.org.PayrollLog.PK_PayrollAudit1CLUSTEREDYY0000never2026-09-27 03:32:04UNUSEDKEEP — primary key
host_726.org.PayrollLog.UX_PayrollDetail2NONCLUSTEREDY0000never2026-09-27 03:32:04UNUSEDreview carefully — unique
host_726.org.LedgerDaily.PK_ContractHeader1CLUSTEREDYY0000never2026-09-27 03:32:04UNUSEDKEEP — primary key
host_726.org.PricingArchive.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-27 03:32:04UNUSEDKEEP — primary key
host_726.org.PricingArchive.UX_InvoiceAudit2NONCLUSTEREDY0000never2026-09-27 03:32:04UNUSEDreview carefully — unique
host_726.org.ForecastAudit.PK_WarehouseSnapshot1CLUSTEREDYY039002026-10-01 15:55:542026-09-27 03:32:04USEDKEEP — primary key
host_726.org.ForecastAudit.UX_ClaimArchive2NONCLUSTEREDY0000never2026-09-27 03:32:04UNUSEDreview carefully — unique
host_726.org.PayrollLine.PK_OrdersHistory1CLUSTEREDYY039002026-10-01 15:55:542026-09-27 03:32:04USEDKEEP — primary key
host_726.org.PayrollLine.UX_ShiftLog2NONCLUSTEREDY0000never2026-09-27 03:32:04UNUSEDreview carefully — unique
host_726.org.BookingStaging.PK_AssetResult1CLUSTEREDYY387132788032026-10-02 16:11:462026-09-29 01:02:27USEDKEEP — primary key
host_726.org.ReconcileLine.PK_CustomerLog1CLUSTEREDYY0000never2026-09-27 03:32:05UNUSEDKEEP — primary key
host_726.org.ShiftStaging.PK_BillingHistory1CLUSTEREDYY0000never2026-09-27 03:32:05UNUSEDKEEP — primary key
host_726.org.ShiftStaging.UQ_PolicyAudit2NONCLUSTEREDY0000never2026-09-27 03:32:05UNUSEDreview carefully — unique
host_726.org.CustomerLine.IX_ForecastLine3NONCLUSTERED0000never2026-09-27 03:32:05UNUSEDreview, then DROP
host_726.org.CustomerLine.PK_LedgerEntry1CLUSTEREDYY0000never2026-09-27 03:32:05UNUSEDKEEP — primary key
host_726.org.CustomerLine.UQ_PayrollLog2NONCLUSTEREDY0000never2026-09-27 03:32:05UNUSEDreview carefully — unique
host_726.org.InvoiceMonthly.PK_WarehouseQueue1CLUSTEREDYY0000never2026-09-27 03:32:05UNUSEDKEEP — primary key
host_726.org.InvoiceMonthly.UQ_MeterAudit2NONCLUSTEREDY0000never2026-09-27 03:32:05UNUSEDreview carefully — unique
host_726.org.QuotaStaging.PK_ShiftStaging1CLUSTEREDYY02002026-09-28 14:45:202026-09-27 03:32:05USEDKEEP — primary key
host_726.org.QuotaStaging.UQ_ShiftMonthly2NONCLUSTEREDY0000never2026-09-27 03:32:05UNUSEDreview carefully — unique
host_726.org.BatchMonthly.PK_WarehouseHeader1CLUSTEREDYY0000never2026-09-27 03:32:05UNUSEDKEEP — primary key
host_726.org.BatchMonthly.UQ_LedgerStaging2NONCLUSTEREDY0000never2026-09-27 03:32:05UNUSEDreview carefully — unique
host_726.org.ClaimHeader.PK_ClaimArchive1CLUSTEREDYY0000never2026-09-27 03:32:05UNUSEDKEEP — primary key
host_726.org.SupplierResult.PK_ForecastQueue1CLUSTEREDYY121170012026-10-02 14:58:152026-09-29 01:02:28USEDKEEP — primary key
host_726.org.RouteSummary.PK_RosterAudit1CLUSTEREDYY0000never2026-09-27 03:32:05UNUSEDKEEP — primary key
host_726.org.RouteSummary.UX_SupplierSummary2NONCLUSTEREDYY0000never2026-09-27 03:32:05COLDreview carefully — unique
host_726.org.ClaimDetail.PK_RouteMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.ShiftResult.PK_ForecastEntry1CLUSTEREDYY811232773411682026-10-02 16:10:112026-10-02 01:02:07USEDKEEP — primary key
host_726.org.ShiftResult.UX_LedgerStaging7NONCLUSTEREDY277341001682026-10-02 16:10:112026-10-02 01:02:07USEDkeep — in use
host_726.org.QuotaResult.PK_CampaignDaily1CLUSTEREDYY143124012026-10-02 16:10:102026-09-29 01:02:28USEDKEEP — primary key
host_726.org.QuotaResult.UX_BatchDaily2NONCLUSTEREDY0001never2026-09-29 01:02:28UNUSEDreview carefully — unique
host_726.org.QuotaDetail.PK_WarehouseMonthly1CLUSTEREDYY01108000012026-10-02 16:10:192026-09-29 01:02:28USEDKEEP — primary key
host_726.org.BookingLog.PK_MeterStaging1CLUSTEREDYY0000never2026-09-27 03:32:06UNUSEDKEEP — primary key
host_726.org.SettlementAudit.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-27 03:32:06UNUSEDKEEP — primary key
host_726.oth.QuotaSummary.PK_QuotaDetail1CLUSTEREDYY01002026-09-28 11:08:122026-09-27 03:32:06USEDKEEP — primary key
host_726.oth.InvoiceStatus.PK_ShiftQueue1CLUSTEREDYY231002026-10-03 00:00:002026-09-27 03:32:06USEDKEEP — primary key
host_726.oth.SupplierLine.PK_QuotaDetail1CLUSTEREDYY0000never2026-09-27 03:32:07UNUSEDKEEP — primary key
host_726.oth.SupplierLine.UX_InvoiceHeader2NONCLUSTEREDY0000never2026-09-27 03:32:07UNUSEDreview carefully — unique
host_726.oth.StaffingArchive.IX_InvoiceStaging2NONCLUSTERED0000never2026-09-27 03:32:07UNUSEDreview, then DROP
host_726.oth.StaffingArchive.PK_PricingAudit1CLUSTEREDYY0000never2026-09-27 03:32:07UNUSEDKEEP — primary key
host_726.oth.StaffingArchive.UQ_SalesAudit3NONCLUSTEREDY153002026-10-02 08:17:182026-09-27 03:32:07USEDkeep — in use
host_726.oth.CustomerQueue.IX_WarehouseResult2NONCLUSTERED151002026-10-02 08:17:182026-09-27 03:32:07USEDkeep — in use
host_726.oth.CustomerQueue.PK_TerritoryResult1CLUSTEREDYY030002026-10-02 08:17:182026-09-27 03:32:07USEDKEEP — primary key
host_726.rec.Candidate.PK_BookingArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.Candidate.UX_CatalogLine2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
host_726.rec.AssetEntry.PK_BatchArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.ShipmentDetail.PK_QuotaResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.ShipmentDetail.UX_SalesLog2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
host_726.rec.CustomerLine.PK_ShiftStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.SettlementAudit.PK_PricingHeader1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.PricingResult.PK_AssetHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.OrdersMonthly.PK_ContractStatus1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.OrdersMonthly.UX_AssetSnapshot2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
host_726.rec.RosterArchive.PK_ContractAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.SalesQueue.PK_LedgerLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.MeterArchive.PK_ForecastResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.MeterArchive.UX_PayrollLine2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
host_726.rec.PayrollStatus.PK_ForecastMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.CampaignStatus.PK_InvoiceHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.ReconcileStatus.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.ShipmentMonthly.PK_ContractEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.ForecastSummary.PK_ReconcileLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.CustomerDetail.PK_SalesSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.AssetSnapshot.PK_PolicyResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.AssetSnapshot.UX_ContractArchive2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
host_726.rec.CustomerQueue.PK_InvoiceLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.BatchSnapshot.PK_TicketLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.StaffingLine.PK_RosterSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.LedgerStatus.PK_InvoiceDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.sal.SalesHistory.PK_QuotaLine1CLUSTEREDYY0000never2026-09-27 03:32:07UNUSEDKEEP — primary key
host_726.sal.ClaimArchive.IX_RouteDetail2NONCLUSTERED0000never2026-09-27 03:32:08UNUSEDreview, then DROP
host_726.sal.ClaimArchive.PK_LedgerHeader1CLUSTEREDYY0000never2026-09-27 03:32:08UNUSEDKEEP — primary key
host_726.sal.QuotaLine.PK_ContractArchive1CLUSTEREDYY033056002026-10-03 00:04:002026-09-27 03:32:08USEDKEEP — primary key
host_726.sal.SalesStatus.PK_ShiftMonthly1CLUSTEREDYY0371002026-10-03 00:04:002026-09-27 03:32:08USEDKEEP — primary key
host_726.sal.SettlementQueue.PK_StaffingSnapshot1CLUSTEREDYY0373002026-10-03 00:04:002026-09-27 03:32:09USEDKEEP — primary key
host_726.sal.MeterHistory.PK_LedgerSnapshot1CLUSTEREDYY0000never2026-09-27 03:32:09UNUSEDKEEP — primary key
host_726.sal.ShipmentAudit.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.sal.RouteResult.PK_OrdersAudit1CLUSTEREDYY0000never2026-09-27 03:32:09UNUSEDKEEP — primary key
host_726.sal.RouteResult.UX_ContractEntry2NONCLUSTEREDY0000never2026-09-27 03:32:09UNUSEDreview carefully — unique
host_726.sal.WarehouseDaily.PK_SettlementDetail1CLUSTEREDYY16358202026-10-02 11:24:592026-09-27 03:32:09USEDKEEP — primary key
host_726.sal.WarehouseDaily.UX_BookingAudit2NONCLUSTEREDY20002026-10-02 08:48:342026-09-27 03:32:09USEDkeep — in use
host_726.sal.InvoiceLog.PK_MeterAudit1CLUSTEREDYY0000never2026-09-27 03:32:09UNUSEDKEEP — primary key
host_726.sal.PolicySnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-27 03:32:10UNUSEDKEEP — primary key
host_726.sal.SettlementStatus.PK_ReconcileResult1CLUSTEREDYY001702026-10-02 08:44:012026-09-27 03:32:10USEDKEEP — primary key
host_726.sal.SettlementStatus.UX_StaffingMonthly2NONCLUSTEREDY170002026-10-02 08:44:012026-09-27 03:32:10USEDkeep — in use
host_726.sal.ReconcileHistory.PK_PayrollHeader1CLUSTEREDYY0000never2026-09-27 03:32:10UNUSEDKEEP — primary key
host_726.sal.ReconcileHistory.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-27 03:32:10UNUSEDreview carefully — unique
host_726.sal.InvoiceEntry.PK_RouteQueue1CLUSTEREDYY0000never2026-09-27 03:32:10UNUSEDKEEP — primary key
host_726.sal.BillingQueue.PK_ReconcileHistory1CLUSTEREDYY0000never2026-09-27 03:32:10UNUSEDKEEP — primary key
host_726.sal.RosterDetail.PK_BookingStaging1CLUSTEREDYY0000never2026-09-27 03:32:10UNUSEDKEEP — primary key
host_726.sal.RosterQueue.PK_ShiftQueue1CLUSTEREDYY01002026-09-28 15:11:302026-09-27 03:32:11USEDKEEP — primary key
host_726.sal.RosterQueue.UX_RosterArchive2NONCLUSTEREDY0000never2026-09-27 03:32:11UNUSEDreview carefully — unique
host_726.sal.WarehouseHeader.PK_RouteEntry1CLUSTEREDYY071002026-10-02 00:05:312026-09-27 03:32:11USEDKEEP — primary key
host_726.sal.SupplierArchive.PK_SupplierStaging1CLUSTEREDYY0368002026-10-03 00:04:002026-09-27 03:32:11USEDKEEP — primary key
host_726.sal.RosterQueue.PK_PolicyLog1CLUSTEREDYY0000never2026-09-27 03:32:11UNUSEDKEEP — primary key
host_726.sal.CustomerSnapshot.PK_RosterEntry1CLUSTEREDYY0368002026-10-03 00:04:002026-09-27 03:32:11USEDKEEP — primary key
host_726.sal.LedgerStatus.PK_WarehouseStaging1CLUSTEREDYY0000never2026-09-27 03:32:11UNUSEDKEEP — primary key
host_726.sal.BookingLine.PK_PricingAudit1CLUSTEREDYY0000never2026-09-27 03:32:11UNUSEDKEEP — primary key
host_726.sal.PricingLine.PK_BatchLine1CLUSTEREDYY0000never2026-09-27 03:32:11UNUSEDKEEP — primary key
host_726.sal.WarehouseStaging.PK_SettlementHistory1CLUSTEREDYY0000never2026-09-27 03:32:11UNUSEDKEEP — primary key
host_726.sal.StaffingArchive.PK_CatalogLine1CLUSTEREDYY0000never2026-09-27 03:32:11UNUSEDKEEP — primary key
host_726.sal.WarehouseSummary.PK_RosterArchive1CLUSTEREDYY0000never2026-09-27 03:32:11UNUSEDKEEP — primary key
host_726.schedule.CustomerDetail.PK_CatalogStaging1CLUSTEREDYY05327708102026-10-02 16:10:112026-09-27 03:32:11USEDKEEP — primary key
host_726.schedule.CustomerDetail.UQ_BillingSnapshot3NONCLUSTEREDY0000never2026-09-27 03:32:11UNUSEDreview carefully — unique
host_726.schedule.CustomerDetail.UQ_CampaignResult2NONCLUSTEREDY27712894002026-10-02 16:10:112026-09-27 03:32:11USEDkeep — in use
host_726.schedule.InvoiceHistory.IX_StaffingHeader3NONCLUSTERED0000never2026-09-27 03:32:11UNUSEDreview, then DROP
host_726.schedule.InvoiceHistory.PK_ContractLog1CLUSTEREDYY0000never2026-09-27 03:32:11UNUSEDKEEP — primary key
host_726.schedule.InvoiceHistory.UQ_LedgerResult2NONCLUSTEREDY0000never2026-09-27 03:32:11UNUSEDreview carefully — unique
host_726.schedule.MeterStaging.PK_SettlementMonthly1CLUSTEREDYY525949001092026-10-02 16:11:312026-10-02 01:02:08USEDKEEP — primary key
host_726.schedule.SettlementLine.PK_CampaignStatus1CLUSTEREDYY2771174701432026-10-02 16:10:112026-10-02 01:02:08USEDKEEP — primary key
host_726.schedule.TicketEntry.PK_CampaignDaily1CLUSTEREDYY7416801432026-10-02 14:35:342026-10-02 01:02:08USEDKEEP — primary key
host_726.schedule.QuotaSummary.PK_LedgerStatus1CLUSTEREDYY3866342050352026-10-02 16:10:112026-10-02 01:02:08USEDKEEP — primary key
host_726.schedule.ShipmentLog.PK_SalesEntry1CLUSTEREDYY277211002182026-10-02 16:10:142026-10-02 16:09:01USEDKEEP — primary key
host_726.schedule.PricingResult.PK_CampaignDaily1CLUSTEREDYY471410472026-10-02 14:35:342026-09-27 03:32:12USEDKEEP — primary key
host_726.schedule.SupplierSnapshot.IX_BillingHeader3NONCLUSTERED9859530013427512026-10-02 16:10:192026-10-02 16:10:10USEDkeep — in use
host_726.schedule.SupplierSnapshot.PK_AssetStatus1CLUSTEREDYY1463796764291946716197442026-10-02 16:11:442026-10-02 16:10:10USEDKEEP — primary key
host_726.schedule.SupplierSnapshot.IX_ContractLog2NONCLUSTEREDY97420962605539862026-10-02 16:11:442026-10-02 16:10:10USEDkeep — in use
host_726.schedule.BatchDetail.PK_AssetDetail1CLUSTEREDYY0000never2026-09-27 03:34:05UNUSEDKEEP — primary key
host_726.schedule.RosterSummary.IX_BatchDetail2NONCLUSTERED78884338010516972026-10-02 16:10:312026-10-02 01:19:11USEDkeep — in use
host_726.schedule.RosterSummary.IX_ClaimHeader3NONCLUSTERED2629410010516972026-10-02 16:10:042026-10-02 01:19:11USEDkeep — in use
host_726.schedule.RosterSummary.PK_CustomerAudit1CLUSTEREDYY2348561314405412526292412026-10-02 16:10:592026-10-02 01:19:11USEDKEEP — primary key
host_726.schedule.BillingDetail.IX_TicketHeader2NONCLUSTERED769425823044697082026-10-02 16:11:162026-10-02 16:10:25USEDkeep — in use
host_726.schedule.BillingDetail.PK_BillingLog1CLUSTEREDYY3500707539561024852584802026-10-02 16:11:512026-10-02 16:10:25USEDKEEP — primary key
host_726.schedule.PolicyStatus.IX_ForecastAudit2NONCLUSTERED46577900099910102026-10-02 16:11:282026-10-02 16:11:14USEDkeep — in use
host_726.schedule.PolicyStatus.IX_SupplierLine3NONCLUSTERED90662618099910102026-10-02 16:11:512026-10-02 16:11:15USEDkeep — in use
host_726.schedule.PolicyStatus.PK_PricingDaily1CLUSTEREDYY1052745663599562199910102026-10-02 16:11:312026-10-02 16:11:14USEDKEEP — primary key
host_726.schedule.PolicyLine.IX_TerritorySnapshot2NONCLUSTERED884264796771013146092026-10-02 16:11:242026-10-02 01:37:38USEDkeep — in use
host_726.schedule.PolicyLine.PK_BookingAudit1CLUSTEREDYY496726128145821033722026-10-02 16:11:162026-10-02 01:37:38USEDKEEP — primary key
host_726.schedule.AssetResult.IX_BillingResult2NONCLUSTERED539810005398102026-10-02 16:09:49neverUSEDkeep — in use
host_726.schedule.AssetResult.PK_TicketQueue1CLUSTEREDYY000539810neverneverUNUSEDKEEP — primary key
host_726.schedule.InvoiceAudit.IX_StaffingQueue2NONCLUSTERED15856733484050039438282026-10-02 16:11:222026-10-02 01:37:39USEDkeep — in use
host_726.schedule.InvoiceAudit.PK_LedgerMonthly1CLUSTEREDYY43334009661630257839438282026-10-02 16:11:152026-10-02 01:37:39USEDKEEP — primary key
host_726.schedule.SettlementLog.IX_TicketLine2NONCLUSTERED987650600110427192026-10-02 16:11:222026-10-02 16:10:37USEDkeep — in use
host_726.schedule.SettlementLog.IX_PolicyLine3NONCLUSTERED128441280110427192026-10-02 16:10:402026-10-02 16:10:38USEDkeep — in use
host_726.schedule.SettlementLog.PK_CatalogMonthly1CLUSTEREDYY158598360500729126202472026-10-02 16:11:172026-10-02 16:10:37USEDKEEP — primary key
host_726.schedule.PricingSnapshot.IX_SettlementStatus2NONCLUSTERED0000neverneverCOLDreview, then DROP
host_726.schedule.PricingSnapshot.IX_InvoiceSummary3NONCLUSTERED0000neverneverCOLDreview, then DROP
host_726.schedule.PricingSnapshot.IX_WarehouseStaging4NONCLUSTERED0000neverneverCOLDreview, then DROP
host_726.schedule.PricingSnapshot.IX_WarehouseStatus5NONCLUSTERED0000neverneverCOLDreview, then DROP
host_726.schedule.PricingSnapshot.PK_RosterEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.schedule.ShiftHeader.IX_TicketStatus4NONCLUSTERED01011079722026-09-30 02:14:392026-10-02 16:10:19USEDkeep — in use
host_726.schedule.ShiftHeader.IX_ShipmentLine3NONCLUSTERED27135040011079762026-10-02 16:11:442026-10-02 16:10:18USEDkeep — in use
host_726.schedule.ShiftHeader.PK_OrdersArchive1CLUSTEREDYY55095215777263919389512026-10-02 16:11:462026-10-02 16:10:18USEDKEEP — primary key
host_726.schedule.ShiftHeader.IX_BookingStatus2NONCLUSTEREDY974290011079722026-10-02 16:11:462026-10-02 16:10:18USEDkeep — in use
host_726.schedule.PolicyLine.PK_RouteQueue1CLUSTEREDYY22110157427735011079722026-10-02 16:11:512026-10-02 01:38:00USEDKEEP — primary key
host_726.schedule.PolicyLine.UX_TerritoryHistory2NONCLUSTEREDYY000553986never2026-10-02 01:38:00UNUSEDreview carefully — unique
host_726.schedule.SalesDaily.IX_ForecastHistory2NONCLUSTERED0000never2026-09-27 04:57:18UNUSEDreview, then DROP
host_726.schedule.SalesDaily.IX_QuotaSummary3NONCLUSTERED0000never2026-09-27 04:57:18UNUSEDreview, then DROP
host_726.schedule.SalesDaily.PK_ClaimResult1CLUSTEREDYY0000never2026-09-27 04:57:18UNUSEDKEEP — primary key
host_726.schedule.RosterHistory.IX_AssetSummary2NONCLUSTERED1605761005539862026-10-02 16:10:592026-10-02 01:38:01USEDkeep — in use
host_726.schedule.RosterHistory.PK_WarehouseLine1CLUSTEREDYY13424702305539862026-10-02 16:11:312026-10-02 01:38:01USEDKEEP — primary key
host_726.schedule.ContractStaging.IX_StaffingLine2NONCLUSTERED0000never2026-09-27 04:57:18UNUSEDreview, then DROP
host_726.schedule.ContractStaging.IX_ShiftSummary3NONCLUSTERED0000never2026-09-27 04:57:18UNUSEDreview, then DROP
host_726.schedule.ContractStaging.PK_PolicyLine1CLUSTEREDYY0000never2026-09-27 04:57:18UNUSEDKEEP — primary key
host_726.schedule.MeterStaging.IX_PayrollAudit2NONCLUSTERED228170228120705539872026-10-03 00:03:562026-10-02 01:38:01USEDkeep — in use
host_726.schedule.MeterStaging.PK_PolicyArchive1CLUSTEREDYY10797390155539872026-10-02 16:10:262026-10-02 01:38:01USEDKEEP — primary key
host_726.schedule.SupplierEntry.IX_InvoiceStaging2NONCLUSTERED0000never2026-09-27 04:57:19UNUSEDreview, then DROP
host_726.schedule.SupplierEntry.IX_StaffingDaily3NONCLUSTERED0000never2026-09-27 04:57:19UNUSEDreview, then DROP
host_726.schedule.SupplierEntry.PK_MeterQueue1CLUSTEREDYY0000never2026-09-27 04:57:19UNUSEDKEEP — primary key
host_726.schedule.ForecastEntry.IX_ContractHistory2NONCLUSTERED0000never2026-09-27 04:57:19UNUSEDreview, then DROP
host_726.schedule.ForecastEntry.IX_ForecastLine3NONCLUSTERED0000never2026-09-27 04:57:19UNUSEDreview, then DROP
host_726.schedule.ForecastEntry.PK_MeterSummary1CLUSTEREDYY02002026-10-02 14:20:022026-09-27 04:57:19USEDKEEP — primary key
host_726.schedule.CustomerHistory.IX_LedgerQueue2NONCLUSTERED850540406063101082026-10-02 16:11:232026-10-02 16:11:15USEDkeep — in use
host_726.schedule.CustomerHistory.PK_PayrollAudit1CLUSTEREDYY9666332036766865730292026-10-02 16:11:232026-10-02 16:11:15USEDKEEP — primary key
host_726.schedule.QuotaDetail.IX_QuotaMonthly2NONCLUSTERED0000never2026-09-27 05:05:37UNUSEDreview, then DROP
host_726.schedule.QuotaDetail.IX_TicketSummary3NONCLUSTERED0000never2026-09-27 05:05:37UNUSEDreview, then DROP
host_726.schedule.QuotaDetail.PK_RosterHeader1CLUSTEREDYY0000never2026-09-27 05:05:37UNUSEDKEEP — primary key
host_726.schedule.RosterResult.IX_BookingAudit2NONCLUSTERED0003155045never2026-10-02 16:11:30UNUSEDreview, then DROP
host_726.schedule.RosterResult.IX_AssetStaging3NONCLUSTERED130584429031550452026-10-02 16:11:432026-10-02 16:11:30USEDkeep — in use
host_726.schedule.RosterResult.PK_PricingSummary1CLUSTEREDYY590463111939451534179652026-10-02 16:11:512026-10-02 16:11:30USEDKEEP — primary key
host_726.schedule.MeterSnapshot.IX_StaffingSummary2NONCLUSTERED0000never2026-09-27 05:17:45UNUSEDreview, then DROP
host_726.schedule.MeterSnapshot.IX_MeterLog3NONCLUSTERED0000never2026-09-27 05:17:45UNUSEDreview, then DROP
host_726.schedule.MeterSnapshot.PK_CampaignSnapshot1CLUSTEREDYY0000never2026-09-27 05:17:45UNUSEDKEEP — primary key
host_726.schedule.LedgerSnapshot.PK_RouteStatus1CLUSTEREDYY1939490109459012026-10-02 16:10:212026-10-01 03:14:45USEDKEEP — primary key
host_726.schedule.LedgerSnapshot.IX_TicketLine2NONCLUSTEREDY10012026-10-01 02:12:272026-10-01 03:14:45USEDkeep — in use
host_726.schedule.RosterHistory.PK_MeterLine1CLUSTEREDYY1108109001092026-10-02 16:10:142026-10-01 03:14:45USEDKEEP — primary key
host_726.schedule.AssetStaging.PK_CampaignResult1CLUSTEREDYY554095001092026-10-02 16:10:192026-10-01 03:14:45USEDKEEP — primary key
host_726.schedule.CampaignDaily.IX_BookingArchive2NONCLUSTERED0201147662026-10-01 13:25:012026-10-02 01:02:08USEDkeep — in use
host_726.schedule.CampaignDaily.PK_PricingEntry1CLUSTEREDYY01101147662026-10-02 14:11:48neverUSEDKEEP — primary key
host_726.schedule.BatchSnapshot.IX_ShiftQueue3NONCLUSTERED0800501179062026-10-03 00:04:402026-10-02 12:37:19USEDkeep — in use
host_726.schedule.BatchSnapshot.PK_ShiftHistory1CLUSTEREDYY03002483201314782026-10-03 00:04:402026-10-02 12:45:37USEDKEEP — primary key
host_726.schedule.BatchSnapshot.UX_StaffingEntry2NONCLUSTEREDY226552320401179062026-10-02 12:58:492026-10-02 12:45:37USEDkeep — in use
host_726.schedule.InvoiceLog.PK_CatalogSummary1CLUSTEREDYY67134612882026-10-02 14:58:172026-10-02 01:02:08USEDKEEP — primary key
host_726.schedule.InvoiceLog.IX_WarehouseHeader2NONCLUSTEREDY1360082026-10-02 13:03:512026-10-02 01:02:08USEDkeep — in use
host_726.schedule.ContractResult.PK_StaffingSummary1CLUSTEREDYY0576082026-10-02 14:58:172026-10-02 01:02:08USEDKEEP — primary key
host_726.schedule.ContractResult.UX_CampaignHistory2NONCLUSTEREDYY53115082026-10-02 13:55:472026-10-02 01:02:08USEDkeep — in use
host_726.schedule.BillingLog.PK_ContractResult1CLUSTEREDYY2095510152026-10-02 14:58:172026-10-02 01:02:08USEDKEEP — primary key
host_726.schedule.SalesArchive.IX_RosterStatus1CLUSTERED0007never2026-10-02 01:02:08UNUSEDKEEP — table storage
host_726.schedule.CatalogHistory.PK_OrdersStatus1CLUSTEREDYY2228002026-10-02 13:01:362026-09-27 03:32:12USEDKEEP — primary key
host_726.schedule.CatalogHistory.IX_PricingStatus2NONCLUSTEREDY0000never2026-09-27 03:32:12UNUSEDreview carefully — unique
host_726.schedule.engine.PK_ReconcileDaily1CLUSTEREDYY7304814681696202026-10-02 16:11:322026-09-27 05:17:45USEDKEEP — primary key
host_726.schedule.engine.UQ_MeterQueue2NONCLUSTEREDY8169710002026-10-02 16:09:492026-09-27 05:17:45USEDkeep — in use
host_726.schedule.TerritoryAudit.PK_PayrollSnapshot1CLUSTEREDYY008165805396962026-10-02 12:58:482026-10-02 01:38:17USEDKEEP — primary key
host_726.schedule.TerritoryAudit.UX_BookingHeader2NONCLUSTEREDYY816580002768842026-10-02 12:58:482026-10-02 11:07:14USEDkeep — in use
host_726.schedule.WarehouseArchive.IX_CustomerHistory2NONCLUSTERED000553991never2026-10-02 12:38:28UNUSEDreview, then DROP
host_726.schedule.WarehouseArchive.IX_OrdersHeader3NONCLUSTERED277154905539912026-10-02 16:09:492026-10-02 12:38:28USEDkeep — in use
host_726.schedule.WarehouseArchive.PK_RouteAudit1CLUSTEREDYY84503227716508450472026-10-02 16:11:322026-10-02 12:45:32USEDKEEP — primary key
host_726.schedule.LedgerMonthly.IX_CustomerMonthly3NONCLUSTERED27715490149211712026-10-02 16:09:49neverUSEDkeep — in use
host_726.schedule.LedgerMonthly.PK_ClaimLine1CLUSTEREDYY2238173190223817482026-10-02 16:11:322026-10-02 12:35:29USEDKEEP — primary key
host_726.schedule.RouteAudit.IX_InvoiceHeader2NONCLUSTERED000277148never2026-10-02 12:28:47UNUSEDreview, then DROP
host_726.schedule.RouteAudit.IX_SettlementDetail3NONCLUSTEREDY000276988neverneverUNUSEDreview, then DROP
host_726.schedule.RouteAudit.IX_CatalogArchive4NONCLUSTERED3631002771482026-10-03 00:03:572026-10-02 12:28:47USEDkeep — in use
host_726.schedule.RouteAudit.IX_QuotaStaging5NONCLUSTERED000277148never2026-10-02 12:28:47UNUSEDreview, then DROP
host_726.schedule.RouteAudit.PK_PayrollAudit1CLUSTEREDYY01636312771482026-10-03 00:03:572026-10-02 12:28:47USEDKEEP — primary key
host_726.schedule.ShipmentHeader.PK_CampaignDetail1CLUSTEREDYY432435074606912026-10-02 06:48:362026-10-02 05:05:03USEDKEEP — primary key
host_726.schedule.SupplierEntry.PK_AssetSnapshot1CLUSTEREDYY34603896002026-10-02 16:11:232026-09-27 05:17:48USEDKEEP — primary key
host_726.schedule.TerritoryDetail.PK_ReconcileMonthly1CLUSTEREDYY700142026-10-02 13:28:232026-10-02 01:38:24USEDKEEP — primary key
host_726.schedule.StaffingEntry.PK_QuotaDetail1CLUSTEREDYY412417952419232026-10-02 16:11:312026-10-02 01:38:24USEDKEEP — primary key
host_726.schedule.StaffingEntry.UQ_TicketDetail2NONCLUSTEREDY126072026-10-02 13:28:232026-10-02 01:38:24USEDkeep — in use
host_726.schedule.StaffingEntry.UX_PayrollDaily3NONCLUSTEREDYY6920775190162026-10-02 16:11:232026-10-02 01:38:24USEDkeep — in use
host_726.schedule.ForecastMonthly.PK_ForecastHistory1CLUSTEREDYY412427614350824841142026-10-02 16:11:322026-10-02 05:05:03USEDKEEP — primary key
host_726.schedule.CatalogEntry.PK_PolicyDetail1CLUSTEREDYY69207756002026-10-02 16:11:232026-09-27 05:17:50USEDKEEP — primary key
host_726.schedule.CatalogEntry.UQ_AssetAudit2NONCLUSTEREDY0000never2026-09-27 05:17:50UNUSEDreview carefully — unique
host_726.schedule.ContractAudit.PK_TicketSummary1CLUSTEREDYY412417722002026-10-02 16:11:312026-09-27 05:17:50USEDKEEP — primary key
host_726.schedule.ContractAudit.UQ_OrdersStaging2NONCLUSTEREDY0000never2026-09-27 05:17:50UNUSEDreview carefully — unique
host_726.schedule.ContractAudit.UX_BillingSnapshot3NONCLUSTEREDYY69207750002026-10-02 16:11:232026-09-27 05:17:50USEDkeep — in use
host_726.schedule.SupplierSummary.PK_LedgerEntry1CLUSTEREDYY02016152026-10-02 13:28:232026-10-01 03:14:45USEDKEEP — primary key
host_726.schedule.SupplierSummary.UQ_BillingStaging2NONCLUSTEREDY1600142026-09-30 08:22:442026-10-01 03:14:45USEDkeep — in use
host_726.schedule.PayrollDaily.PK_CustomerQueue1CLUSTEREDYY6012369349210102026-10-02 16:11:232026-10-01 03:14:45USEDKEEP — primary key
host_726.schedule.WarehouseDaily.PK_QuotaAudit1CLUSTEREDYY19126182026-10-02 13:28:232026-10-01 03:14:45USEDKEEP — primary key
host_726.schedule.WarehouseDaily.UQ_ShiftEntry2NONCLUSTEREDY248062026-10-01 13:21:342026-10-01 03:14:45USEDkeep — in use
host_726.schedule.WarehouseDaily.UX_TerritorySummary3NONCLUSTEREDYY1300122026-10-02 13:28:232026-10-01 03:14:45USEDkeep — in use
host_726.schedule.sql.IX_PayrollEntry3NONCLUSTEREDY6920780140172026-10-02 16:11:232026-09-27 05:17:51USEDkeep — in use
host_726.schedule.sql.PK_ContractMonthly1CLUSTEREDYY573252172026-10-02 13:28:232026-09-27 05:17:51USEDKEEP — primary key
host_726.schedule.sql.UQ_SalesStatus2NONCLUSTEREDY6618002026-10-02 13:28:232026-09-27 05:17:51USEDkeep — in use
host_726.schedule.LedgerStatus.PK_SettlementQueue1CLUSTEREDYY0000never2026-09-27 05:17:51UNUSEDKEEP — primary key
host_726.schedule.LedgerStatus.UQ_QuotaAudit2NONCLUSTEREDY0000never2026-09-27 05:17:51UNUSEDreview carefully — unique
host_726.schedule.OrdersQueue.PK_QuotaQueue1CLUSTEREDYY700142026-10-02 13:28:232026-10-02 01:38:32USEDKEEP — primary key
host_726.schedule.LedgerStaging.IX_StaffingLog3NONCLUSTERED6920837140472026-10-02 16:11:232026-10-02 01:38:32USEDkeep — in use
host_726.schedule.LedgerStaging.PK_ContractQueue1CLUSTEREDYY41241824326920789472026-10-02 16:11:312026-10-02 01:38:32USEDKEEP — primary key
host_726.schedule.LedgerStaging.UQ_TicketResult2NONCLUSTEREDY2480172026-10-01 13:21:342026-10-02 01:38:32USEDkeep — in use
host_726.schedule.LedgerStaging.UX_QuotaHeader4NONCLUSTEREDYY00030never2026-10-02 01:38:32UNUSEDreview carefully — unique
host_726.schedule.step.PK_AssetStaging1CLUSTEREDYY71977756002026-10-02 16:11:322026-09-27 05:17:53USEDKEEP — primary key
host_726.schedule.step.UQ_AssetQueue3NONCLUSTEREDY0000never2026-09-27 05:17:53UNUSEDreview carefully — unique
host_726.schedule.step.UQ_OrdersLine2NONCLUSTEREDY0000never2026-09-27 05:17:53UNUSEDreview carefully — unique
host_726.schedule.ShipmentResult.PK_MeterSnapshot1CLUSTEREDYY700142026-10-02 13:28:232026-10-02 01:38:34USEDKEEP — primary key
host_726.schedule.WarehouseEntry.PK_SettlementLine1CLUSTEREDYY412417866920791002026-10-02 16:11:312026-09-27 05:17:53USEDKEEP — primary key
host_726.schedule.WarehouseEntry.UQ_ShiftSnapshot2NONCLUSTEREDY0000never2026-09-27 05:17:53UNUSEDreview carefully — unique
host_726.schedule.WarehouseEntry.UX_OrdersLog3NONCLUSTEREDYY0000never2026-09-27 05:17:53COLDreview carefully — unique
host_726.wps.ContractStatus.IX_RosterDaily2NONCLUSTERED5200220582026-10-03 00:00:022026-10-02 01:38:34USEDkeep — in use
host_726.wps.ContractStatus.PK_ClaimLog1CLUSTEREDYY82203995220582026-10-03 00:04:432026-10-02 01:38:34USEDKEEP — primary key
host_726.wps.ContractStatus.UX_TerritoryResult3NONCLUSTEREDYY00019never2026-10-02 01:38:34UNUSEDreview carefully — unique
host_726.wps.ContractStatus.UX_SettlementDetail4NONCLUSTEREDY4300192026-10-02 09:11:292026-10-02 01:38:34USEDkeep — in use
host_726.wps.PolicyResult.IX_ContractSnapshot2NONCLUSTERED473001602026-10-02 08:27:152026-10-02 01:38:34USEDkeep — in use
host_726.wps.PolicyResult.PK_SettlementLine1CLUSTEREDYY7561604521602026-10-02 14:51:232026-10-02 01:38:34USEDKEEP — primary key
host_726.wps.LedgerMonthly.PK_BookingResult1CLUSTEREDYY000331never2026-10-02 01:38:34UNUSEDKEEP — primary key
host_726.wps.BookingStaging.PK_ClaimHistory1CLUSTEREDYY12467503562026-10-02 14:51:232026-10-02 01:38:34USEDKEEP — primary key
host_726.wps.SalesHeader.PK_ContractHistory1CLUSTEREDYY000944never2026-10-02 01:38:34UNUSEDKEEP — primary key
host_726.wps.ForecastResult.PK_QuotaLog1CLUSTEREDYY18316948412442026-10-02 14:51:232026-10-01 03:14:48USEDKEEP — primary key
host_726.wps.ForecastResult.UQ_ShipmentArchive5NONCLUSTEREDY111019012442026-10-03 00:00:002026-10-02 01:38:34USEDkeep — in use
host_726.wps.StaffingResult.PK_RosterStatus1CLUSTEREDYY011380002026-10-03 00:04:002026-09-27 05:17:54USEDKEEP — primary key
host_726.wps.StaffingStaging.PK_PolicyEntry1CLUSTEREDYY0000never2026-09-27 05:17:54UNUSEDKEEP — primary key
host_726.wps.QuotaDetail.PK_BatchQueue1CLUSTEREDYY0000never2026-09-27 05:17:54UNUSEDKEEP — primary key
host_726.wps.OrdersLog.PK_WarehouseArchive1CLUSTEREDYY0000never2026-09-27 05:17:54UNUSEDKEEP — primary key
host_726.wps.TerritoryQueue.IX_InvoiceAudit10NONCLUSTERED1306101772026-10-02 13:12:122026-10-02 01:38:35USEDkeep — in use
host_726.wps.TerritoryQueue.PK_RosterSnapshot1CLUSTEREDYY991534551772026-10-02 14:51:232026-10-02 01:38:35USEDKEEP — primary key
host_726.wps.TerritoryQueue.UX_MeterStaging2NONCLUSTEREDY3011301772026-10-02 14:51:232026-10-02 01:38:35USEDkeep — in use
host_726.wps.ContractEntry.PK_PayrollSummary1CLUSTEREDYY000188never2026-10-02 01:38:35UNUSEDKEEP — primary key
host_726.wps.TicketStatus.PK_InvoiceMonthly1CLUSTEREDYY0703032026-10-02 14:51:232026-09-29 01:07:29USEDKEEP — primary key
host_726.wps.SalesDetail.PK_SettlementLine1CLUSTEREDYY000454never2026-10-02 01:38:35UNUSEDKEEP — primary key
host_726.wps.ClaimResult.PK_TicketEntry1CLUSTEREDYY8366002026-10-03 00:00:022026-09-27 05:17:55USEDKEEP — primary key
host_726.wps.CatalogSnapshot.PK_ForecastHeader1CLUSTEREDYY0000never2026-09-27 05:17:55UNUSEDKEEP — primary key
host_726.wps.BillingLine.PK_RosterResult1CLUSTEREDYY716513002026-10-03 00:00:022026-09-27 05:17:55USEDKEEP — primary key
host_726.wps.BillingLine.UX_WarehouseLog2NONCLUSTEREDYY30002026-10-02 08:47:332026-09-27 05:17:55USEDkeep — in use
host_726.wps.BatchStatus.PK_ClaimLine1CLUSTEREDYY044612612026-10-02 14:51:232026-09-27 05:17:55USEDKEEP — primary key
host_726.wps.BatchStatus.UQ_CustomerHeader2NONCLUSTEREDY1260012026-10-02 08:48:032026-09-27 05:17:55USEDkeep — in use
host_726.wps.BookingResult.PK_WarehouseMonthly1CLUSTEREDYY0001never2026-09-27 05:17:55UNUSEDKEEP — primary key
host_726.wps.BookingStaging.PK_ForecastLog1CLUSTEREDYY04032026-09-28 14:35:112026-09-27 05:17:55USEDKEEP — primary key
QUOTA.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-27 05:17:57UNUSEDKEEP — primary key
QUOTA.cfg.QuotaStatus.UX_MeterSummary2NONCLUSTEREDY0000never2026-09-27 05:17:57UNUSEDreview carefully — unique
QUOTA.dbo.ContractResult.PK_CampaignResult1CLUSTEREDYY0000never2026-09-27 05:17:57UNUSEDKEEP — primary key
QUOTA.dbo.SettlementStaging.PK_TicketStaging1CLUSTEREDYY0000never2026-09-27 05:17:57UNUSEDKEEP — primary key
QUOTA.dbo.SupplierDetail.PK_ShiftResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.dbo.CampaignResult.PK_InvoiceSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.dbo.TicketQueue.PK_CampaignEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.dbo.TicketEntry.PK_StaffingDaily1CLUSTEREDYY0000never2026-09-27 05:17:58UNUSEDKEEP — primary key
QUOTA.dbo.WarehouseEntry.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-27 05:17:58UNUSEDKEEP — primary key
QUOTA.dbo.WarehouseEntry.UX_CampaignHeader2NONCLUSTEREDY0000never2026-09-27 05:17:58UNUSEDreview carefully — unique
QUOTA.dbo.TicketSummary.PK_SalesLine1CLUSTERED0000never2026-09-27 05:17:58UNUSEDKEEP — table storage
QUOTA.dbo.TerritoryEntry.PK_SalesSummary1CLUSTEREDYY0000never2026-09-27 05:17:58UNUSEDKEEP — primary key
QUOTA.dbo.TerritoryEntry.UX_TerritoryQueue2NONCLUSTEREDY0000never2026-09-27 05:17:58UNUSEDreview carefully — unique
QUOTA.dbo.PolicyEntry.PK_TicketEntry1CLUSTEREDYY0000never2026-09-27 05:17:58UNUSEDKEEP — primary key
QUOTA.dbo.PolicyEntry.UX_PolicyAudit2NONCLUSTEREDY0000never2026-09-27 05:17:58UNUSEDreview carefully — unique
QUOTA.dbo.CampaignHeader.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-27 05:17:58UNUSEDKEEP — primary key
QUOTA.dbo.CampaignHeader.UX_BillingLog2NONCLUSTEREDY0000never2026-09-27 05:17:58UNUSEDreview carefully — unique
QUOTA.dbo.WarehouseHeader.PK_OrdersQueue1CLUSTEREDYY0000never2026-09-27 05:17:58UNUSEDKEEP — primary key
QUOTA.dbo.WarehouseHeader.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-27 05:17:58UNUSEDreview carefully — unique
QUOTA.dbo.RouteQueue.PK_SupplierAudit1CLUSTEREDYY0000never2026-09-27 05:17:58UNUSEDKEEP — primary key
QUOTA.dbo.RouteQueue.UX_CampaignQueue2NONCLUSTEREDY0000never2026-09-27 05:17:58UNUSEDreview carefully — unique
QUOTA.dbo.CampaignAudit.PK_BatchSnapshot1CLUSTEREDYY0000never2026-09-27 05:17:58UNUSEDKEEP — primary key
QUOTA.dbo.CampaignAudit.UX_SupplierArchive2NONCLUSTEREDY0000never2026-09-27 05:17:58UNUSEDreview carefully — unique
QUOTA.dbo.ShiftDaily.PK_ReconcileStatus1CLUSTEREDYY0000never2026-09-27 05:17:58UNUSEDKEEP — primary key
QUOTA.dbo.ShiftDaily.UX_RouteDaily2NONCLUSTEREDY0000never2026-09-27 05:17:59UNUSEDreview carefully — unique
QUOTA.emp.WarehouseMonthly.PK_PricingHistory1CLUSTEREDYY0000never2026-09-27 05:17:59UNUSEDKEEP — primary key
QUOTA.emp.WarehouseMonthly.UX_CustomerDetail2NONCLUSTEREDYY0000never2026-09-27 05:17:59UNUSEDreview carefully — unique
QUOTA.emp.SettlementLine.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-27 05:17:59UNUSEDKEEP — primary key
QUOTA.emp.SalesDetail.PK_BillingLog1CLUSTEREDYY0000never2026-09-27 05:17:59UNUSEDKEEP — primary key
QUOTA.emp.BatchMonthly.PK_TicketAudit1CLUSTEREDYY0000never2026-09-27 05:17:59UNUSEDKEEP — primary key
QUOTA.emp.RosterLog.PK_QuotaLog1CLUSTEREDYY0000never2026-09-27 05:17:59UNUSEDKEEP — primary key
QUOTA.emp.QuotaMonthly.IX_ShipmentEntry15NONCLUSTERED0000never2026-09-27 05:17:59UNUSEDreview, then DROP
QUOTA.emp.QuotaMonthly.PK_ReconcileDetail1CLUSTEREDYY0000never2026-09-27 05:17:59UNUSEDKEEP — primary key
QUOTA.emp.OrdersEntry.PK_PolicyHeader1CLUSTEREDYY0000never2026-09-27 05:17:59UNUSEDKEEP — primary key
QUOTA.emp.PayrollSummary.PK_RouteSummary1CLUSTEREDYY0000never2026-09-27 05:18:00UNUSEDKEEP — primary key
QUOTA.emp.SettlementAudit.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-27 05:18:00UNUSEDKEEP — primary key
QUOTA.emp.InvoiceLog.PK_BatchEntry1CLUSTEREDYY0000never2026-09-27 05:18:00UNUSEDKEEP — primary key
QUOTA.emp.InvoiceMonthly.PK_RouteEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.InvoiceMonthly.UX_CustomerSnapshot2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.CampaignEntry.PK_TicketMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.CampaignEntry.UX_CatalogHistory2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.RouteHistory.PK_CustomerMonthly1CLUSTEREDYY0000never2026-09-27 05:18:00UNUSEDKEEP — primary key
QUOTA.emp.RouteHistory.UX_CustomerQueue2NONCLUSTEREDY0000never2026-09-27 05:18:00UNUSEDreview carefully — unique
QUOTA.emp.CustomerHistory.PK_ShiftDaily1CLUSTEREDYY0000never2026-09-27 05:18:01UNUSEDKEEP — primary key
QUOTA.emp.ForecastEntry.PK_SettlementLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ClaimQueue.PK_TerritoryResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.PolicyAudit.PK_ContractAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ShipmentSummary.PK_ShiftAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.BatchArchive.PK_ClaimHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.RosterSnapshot.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.MeterResult.IX_LedgerQueue11NONCLUSTERED0000never2026-09-27 05:18:01UNUSEDreview, then DROP
QUOTA.emp.MeterResult.PK_CustomerResult1CLUSTEREDYY0000never2026-09-27 05:18:01UNUSEDKEEP — primary key
QUOTA.emp.PayrollHeader.PK_TicketHistory1CLUSTEREDYY0000never2026-09-27 05:18:01UNUSEDKEEP — primary key
QUOTA.emp.OrdersAudit.PK_ShipmentHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.RosterResult.PK_MeterAudit1CLUSTEREDYY0000never2026-09-27 05:18:01UNUSEDKEEP — primary key
QUOTA.emp.RouteHeader.PK_StaffingQueue1CLUSTEREDYY0000never2026-09-27 05:18:02UNUSEDKEEP — primary key
QUOTA.emp.MeterAudit.PK_ClaimLog1CLUSTEREDYY0000never2026-09-27 05:18:02UNUSEDKEEP — primary key
QUOTA.emp.QuotaStatus.PK_OrdersArchive1CLUSTEREDYY0000never2026-09-27 05:18:02UNUSEDKEEP — primary key
QUOTA.emp.ShiftLine.IX_PricingAudit13NONCLUSTERED0000never2026-09-27 05:18:02UNUSEDreview, then DROP
QUOTA.emp.ShiftLine.PK_SettlementStatus1CLUSTEREDYY0000never2026-09-27 05:18:02UNUSEDKEEP — primary key
QUOTA.emp.ShiftLine.UX_BookingDaily2NONCLUSTEREDY0000never2026-09-27 05:18:02UNUSEDreview carefully — unique
QUOTA.emp.CampaignHeader.PK_BillingQueue1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.MeterStatus.PK_BillingStaging1CLUSTEREDYY0000never2026-09-27 05:18:02UNUSEDKEEP — primary key
QUOTA.emp.WarehouseStaging.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-27 05:18:02UNUSEDKEEP — primary key
QUOTA.emp.ForecastHeader.IX_WarehouseResult6NONCLUSTERED0000never2026-09-27 05:18:02UNUSEDreview, then DROP
QUOTA.emp.ForecastHeader.PK_OrdersAudit1CLUSTEREDYY0000never2026-09-27 05:18:02UNUSEDKEEP — primary key
QUOTA.emp.SalesLog.PK_AssetStaging1CLUSTEREDYY0000never2026-09-27 05:18:03UNUSEDKEEP — primary key
QUOTA.emp.AssetDaily.PK_CustomerMonthly1CLUSTEREDYY0000never2026-09-27 05:18:03UNUSEDKEEP — primary key
QUOTA.emp.StaffingDaily.PK_BookingLog1CLUSTEREDYY0000never2026-09-27 05:18:03UNUSEDKEEP — primary key
QUOTA.emp.ReconcileDetail.PK_AssetHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ClaimResult.PK_TerritoryQueue1CLUSTEREDYY0000never2026-09-27 05:18:03UNUSEDKEEP — primary key
QUOTA.emp.CatalogLog.PK_ReconcileHeader1CLUSTEREDYY0000never2026-09-27 05:18:03UNUSEDKEEP — primary key
QUOTA.emp.ShipmentSnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-27 05:18:03UNUSEDKEEP — primary key
QUOTA.emp.PricingDaily.IX_ShiftAudit2NONCLUSTERED0000never2026-09-27 05:18:03UNUSEDreview, then DROP
QUOTA.emp.PricingDaily.PK_RouteEntry1CLUSTEREDYY0000never2026-09-27 05:18:03UNUSEDKEEP — primary key
QUOTA.emp.PolicyLog.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-27 05:18:03UNUSEDKEEP — primary key
QUOTA.emp.PolicyLog.UX_OrdersSnapshot4NONCLUSTEREDY0000never2026-09-27 05:18:03UNUSEDreview carefully — unique
QUOTA.emp.RouteAudit.PK_ClaimResult1CLUSTEREDYY0000never2026-09-27 05:18:03UNUSEDKEEP — primary key
QUOTA.emp.WarehouseArchive.PK_StaffingArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.MeterHistory.IX_ContractArchive11NONCLUSTERED0000never2026-09-27 05:18:04UNUSEDreview, then DROP
QUOTA.emp.MeterHistory.PK_BatchLog1CLUSTEREDYY0000never2026-09-27 05:18:04UNUSEDKEEP — primary key
QUOTA.emp.MeterHistory.UX_BatchLog3NONCLUSTEREDYY0000never2026-09-27 05:18:04UNUSEDreview carefully — unique
QUOTA.emp.MeterHistory.UX_ForecastHeader20NONCLUSTEREDY0000never2026-09-27 05:18:04UNUSEDreview carefully — unique
QUOTA.emp.MeterHistory.UX_CustomerSnapshot2NONCLUSTEREDYY0000never2026-09-27 05:18:04UNUSEDreview carefully — unique
QUOTA.emp.MeterHistory.UX_QuotaStaging13NONCLUSTEREDY0000never2026-09-27 05:18:04UNUSEDreview carefully — unique
QUOTA.emp.TerritoryLine.PK_LedgerArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.SalesStaging.PK_PolicyDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.TerritoryDaily.PK_MeterLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.SettlementQueue.IX_PolicyAudit2NONCLUSTERED0000neverneverCOLDreview, then DROP
QUOTA.emp.SettlementQueue.PK_SalesEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.StaffingMonthly.IX_ReconcileEntry2NONCLUSTERED0000neverneverCOLDreview, then DROP
QUOTA.emp.StaffingMonthly.IX_SalesQueue3NONCLUSTERED0000neverneverCOLDreview, then DROP
QUOTA.emp.StaffingMonthly.PK_CampaignStatus1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.TicketQueue.PK_BatchDaily1CLUSTEREDYY0000never2026-09-27 05:18:04UNUSEDKEEP — primary key
QUOTA.emp.TicketQueue.UX_PayrollDaily2NONCLUSTEREDY0000never2026-09-27 05:18:04UNUSEDreview carefully — unique
QUOTA.emp.MeterStatus.PK_CustomerDetail1CLUSTEREDYY0000never2026-09-27 05:18:04UNUSEDKEEP — primary key
QUOTA.emp.OrdersEntry.PK_TerritoryAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.InvoiceLog.PK_BillingDetail1CLUSTEREDYY0000never2026-09-27 05:18:04UNUSEDKEEP — primary key
QUOTA.emp.CampaignHistory.IX_QuotaDetail2NONCLUSTERED0000never2026-09-27 05:18:04UNUSEDreview, then DROP
QUOTA.emp.CampaignHistory.PK_AssetHeader1CLUSTEREDYY0000never2026-09-27 05:18:04UNUSEDKEEP — primary key
QUOTA.emp.ContractArchive.PK_BookingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.TicketLine.PK_CampaignEntry1CLUSTEREDYY0000never2026-09-27 05:18:05UNUSEDKEEP — primary key
QUOTA.emp.BatchAudit.PK_ForecastSummary1CLUSTEREDYY0000never2026-09-27 05:18:05UNUSEDKEEP — primary key
QUOTA.emp.BatchAudit.UX_LedgerStaging2NONCLUSTEREDY0000never2026-09-27 05:18:05UNUSEDreview carefully — unique
QUOTA.emp.ClaimAudit.PK_LedgerDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ClaimAudit.UX_RouteMonthly2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.PolicyHistory.PK_OrdersDaily1CLUSTEREDYY0000never2026-09-27 05:18:06UNUSEDKEEP — primary key
QUOTA.emp.BillingEntry.PK_StaffingAudit1CLUSTEREDYY0000never2026-09-27 05:18:07UNUSEDKEEP — primary key
QUOTA.emp.BillingEntry.UX_StaffingLog2NONCLUSTEREDY0000never2026-09-27 05:18:07UNUSEDreview carefully — unique
QUOTA.emp.BillingAudit.PK_PolicyDetail1CLUSTEREDYY0000never2026-09-27 05:18:07UNUSEDKEEP — primary key
QUOTA.emp.BillingAudit.UX_SupplierSnapshot2NONCLUSTEREDY0000never2026-09-27 05:18:07UNUSEDreview carefully — unique
QUOTA.emp.ShipmentStaging.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-27 05:18:07UNUSEDKEEP — primary key
QUOTA.emp.ShipmentStaging.UX_RosterDaily2NONCLUSTEREDY0000never2026-09-27 05:18:07UNUSEDreview carefully — unique
QUOTA.emp.SalesLine.PK_CampaignResult1CLUSTEREDYY0000never2026-09-27 05:18:08UNUSEDKEEP — primary key
QUOTA.emp.ContractLog.PK_BookingSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ContractLog.UX_ClaimDetail2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.LedgerSnapshot.PK_CampaignStatus1CLUSTEREDYY0000never2026-09-27 05:18:08UNUSEDKEEP — primary key
QUOTA.emp.BookingSnapshot.PK_ReconcileStaging1CLUSTEREDYY0000never2026-09-27 05:18:08UNUSEDKEEP — primary key
QUOTA.emp.ReconcileDetail.PK_CampaignQueue1CLUSTEREDYY0000never2026-09-27 05:18:08UNUSEDKEEP — primary key
QUOTA.emp.PolicyStaging.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ReconcileStaging.PK_ContractStaging1CLUSTEREDYY0000never2026-09-27 05:18:09UNUSEDKEEP — primary key
QUOTA.emp.ReconcileStaging.UX_OrdersHistory2NONCLUSTEREDY0000never2026-09-27 05:18:09UNUSEDreview carefully — unique
QUOTA.emp.MeterStatus.PK_ReconcileMonthly1CLUSTEREDYY0000never2026-09-27 05:18:09UNUSEDKEEP — primary key
QUOTA.emp.MeterStatus.UX_ReconcileAudit7NONCLUSTEREDY0000never2026-09-27 05:18:09UNUSEDreview carefully — unique
QUOTA.emp.PricingAudit.PK_ReconcileSnapshot1CLUSTEREDYY0000never2026-09-27 05:18:09UNUSEDKEEP — primary key
QUOTA.emp.RosterQueue.PK_SettlementHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ContractLog.PK_SupplierStatus1CLUSTEREDYY0000never2026-09-27 05:18:09UNUSEDKEEP — primary key
QUOTA.emp.BatchStatus.PK_QuotaLog1CLUSTEREDYY0000never2026-09-27 05:18:09UNUSEDKEEP — primary key
QUOTA.emp.CampaignArchive.PK_BatchSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.TerritoryEntry.PK_SupplierStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.OrdersResult.PK_PayrollEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.PayrollResult.PK_QuotaMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.StaffingArchive.PK_SupplierMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.TicketAudit.IX_LedgerLog2NONCLUSTERED0000neverneverCOLDreview, then DROP
QUOTA.emp.TicketAudit.PK_LedgerStatus1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.InvoiceResult.PK_ShipmentMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.CustomerLog.PK_StaffingDaily1CLUSTEREDYY0000never2026-09-27 05:18:09UNUSEDKEEP — primary key
QUOTA.emp.InvoiceAudit.PK_QuotaEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.MeterSummary.PK_AssetEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.AssetSummary.PK_SupplierStaging1CLUSTEREDYY0000never2026-09-27 05:18:11UNUSEDKEEP — primary key
QUOTA.emp.SupplierStaging.IX_MeterStaging12NONCLUSTERED0000never2026-09-27 05:18:11UNUSEDreview, then DROP
QUOTA.emp.SupplierStaging.PK_PayrollMonthly1CLUSTEREDYY0000never2026-09-27 05:18:11UNUSEDKEEP — primary key
QUOTA.emp.CustomerStatus.PK_PolicyHistory1CLUSTEREDYY0000never2026-09-27 05:18:11UNUSEDKEEP — primary key
QUOTA.emp.BillingAudit.PK_CustomerEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.PolicyLine.PK_OrdersSummary1CLUSTEREDYY0000never2026-09-27 05:18:12UNUSEDKEEP — primary key
QUOTA.emp.RouteStaging.PK_WarehouseLine1CLUSTEREDYY0000never2026-09-27 05:18:12UNUSEDKEEP — primary key
QUOTA.emp.CampaignMonthly.PK_OrdersArchive1CLUSTEREDYY0000never2026-09-27 05:18:12UNUSEDKEEP — primary key
QUOTA.emp.CatalogSnapshot.PK_ClaimHistory1CLUSTEREDYY0000never2026-09-27 05:18:12UNUSEDKEEP — primary key
QUOTA.emp.BillingDaily.PK_CustomerLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.BillingDaily.UX_LedgerDaily2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.SupplierHistory.PK_WarehouseMonthly1CLUSTEREDYY0000never2026-09-27 05:18:12UNUSEDKEEP — primary key
QUOTA.emp.ShipmentMonthly.IX_InvoiceStaging5NONCLUSTERED0000never2026-09-27 05:18:12UNUSEDreview, then DROP
QUOTA.emp.ShipmentMonthly.PK_BatchDaily1CLUSTEREDYY0000never2026-09-27 05:18:12UNUSEDKEEP — primary key
QUOTA.emp.AssetDetail.PK_ReconcileResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.AssetSnapshot.IX_SalesDaily5NONCLUSTERED0000never2026-09-27 05:18:13UNUSEDreview, then DROP
QUOTA.emp.AssetSnapshot.PK_OrdersDetail1CLUSTEREDYY0000never2026-09-27 05:18:13UNUSEDKEEP — primary key
QUOTA.emp.PricingStatus.PK_PolicyStatus1CLUSTEREDYY0000never2026-09-27 05:18:13UNUSEDKEEP — primary key
QUOTA.emp.TicketSnapshot.PK_CampaignQueue1CLUSTEREDYY0000never2026-09-27 05:18:13UNUSEDKEEP — primary key
QUOTA.emp.ForecastMonthly.PK_CampaignSummary1CLUSTEREDYY0000never2026-09-27 05:18:13UNUSEDKEEP — primary key
QUOTA.emp.PricingStatus.IX_QuotaLog8NONCLUSTERED0000never2026-09-27 05:18:13UNUSEDreview, then DROP
QUOTA.emp.PricingStatus.IX_ClaimEntry6NONCLUSTERED0000never2026-09-27 05:18:13UNUSEDreview, then DROP
QUOTA.emp.PricingStatus.PK_LedgerResult1CLUSTEREDYY0000never2026-09-27 05:18:13UNUSEDKEEP — primary key
QUOTA.emp.PayrollHistory.PK_LedgerQueue1CLUSTEREDYY0000never2026-09-27 05:18:13UNUSEDKEEP — primary key
QUOTA.emp.QuotaSummary.PK_LedgerEntry1CLUSTEREDYY0000never2026-09-27 05:18:13UNUSEDKEEP — primary key
QUOTA.emp.PricingQueue.PK_PricingStaging1CLUSTEREDYY0000never2026-09-27 05:18:13UNUSEDKEEP — primary key
QUOTA.emp.BookingMonthly.IX_ShipmentAudit5NONCLUSTERED0000never2026-09-27 05:18:14UNUSEDreview, then DROP
QUOTA.emp.BookingMonthly.PK_WarehouseLog1CLUSTEREDYY0000never2026-09-27 05:18:14UNUSEDKEEP — primary key
QUOTA.emp.MeterSnapshot.PK_StaffingSummary1CLUSTEREDYY0000never2026-09-27 05:18:14UNUSEDKEEP — primary key
QUOTA.emp.BatchMonthly.PK_InvoiceDetail1CLUSTEREDYY0000never2026-09-27 05:18:14UNUSEDKEEP — primary key
QUOTA.emp.StaffingAudit.PK_ForecastHeader1CLUSTEREDYY0000never2026-09-27 05:18:14UNUSEDKEEP — primary key
QUOTA.emp.BatchLog.PK_SalesDetail1CLUSTEREDYY0000never2026-09-27 05:18:14UNUSEDKEEP — primary key
QUOTA.emp.RouteHistory.PK_MeterEntry1CLUSTEREDYY0000never2026-09-27 05:18:14UNUSEDKEEP — primary key
QUOTA.emp.CampaignResult.IX_ForecastAudit9NONCLUSTERED0000never2026-09-27 05:18:14UNUSEDreview, then DROP
QUOTA.emp.CampaignResult.IX_CustomerQueue12NONCLUSTERED0000never2026-09-27 05:18:14UNUSEDreview, then DROP
QUOTA.emp.CampaignResult.PK_StaffingArchive1CLUSTEREDYY0000never2026-09-27 05:18:14UNUSEDKEEP — primary key
QUOTA.emp.PayrollHistory.PK_CampaignStaging1CLUSTEREDYY0000never2026-09-27 05:18:15UNUSEDKEEP — primary key
QUOTA.emp.TerritoryDaily.PK_RouteArchive1CLUSTEREDYY0000never2026-09-27 05:18:15UNUSEDKEEP — primary key
QUOTA.emp.CatalogSummary.IX_WarehouseSnapshot19NONCLUSTERED0000never2026-09-27 05:18:15UNUSEDreview, then DROP
QUOTA.emp.CatalogSummary.IX_ReconcileSummary16NONCLUSTERED0000never2026-09-27 05:18:15UNUSEDreview, then DROP
QUOTA.emp.CatalogSummary.PK_ShipmentStaging1CLUSTEREDYY0000never2026-09-27 05:18:15UNUSEDKEEP — primary key
QUOTA.emp.CatalogSummary.UX_OrdersAudit5NONCLUSTEREDY0000never2026-09-27 05:18:15UNUSEDreview carefully — unique
QUOTA.emp.CatalogSummary.UX_LedgerHistory12NONCLUSTEREDYY0000never2026-09-27 05:18:15UNUSEDreview carefully — unique
QUOTA.emp.TicketMonthly.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-27 05:18:16UNUSEDKEEP — primary key
QUOTA.emp.BillingQueue.IX_ContractSummary8NONCLUSTERED0000never2026-09-27 05:18:16UNUSEDreview, then DROP
QUOTA.emp.BillingQueue.PK_ShipmentEntry1CLUSTEREDYY0000never2026-09-27 05:18:16UNUSEDKEEP — primary key
QUOTA.emp.CampaignResult.PK_CustomerLine1CLUSTEREDYY0000never2026-09-27 05:18:16UNUSEDKEEP — primary key
QUOTA.org.SettlementSnapshot.PK_org.SettlementSnapshot1CLUSTEREDYY0000never2026-09-27 05:18:16UNUSEDKEEP — primary key
QUOTA.org.SettlementSnapshot.UX_BillingLine2NONCLUSTEREDY0000never2026-09-27 05:18:16UNUSEDreview carefully — unique
QUOTA.org.PolicySummary.IX_AssetEntry17NONCLUSTERED0000never2026-09-27 05:18:16UNUSEDreview, then DROP
QUOTA.org.PolicySummary.PK_QuotaAudit1CLUSTEREDYY0000never2026-09-27 05:18:16UNUSEDKEEP — primary key
QUOTA.org.PolicySummary.UX_ForecastHistory2NONCLUSTEREDYY0000never2026-09-27 05:18:16UNUSEDreview carefully — unique
QUOTA.org.CampaignQueue.PK_RosterDaily1CLUSTEREDYY0000never2026-09-27 05:18:16UNUSEDKEEP — primary key
QUOTA.org.TicketLog.PK_WarehouseDetail1CLUSTEREDYY0000never2026-09-27 05:18:17UNUSEDKEEP — primary key
QUOTA.org.TicketLog.UX_SalesMonthly4NONCLUSTEREDY0000never2026-09-27 05:18:17UNUSEDreview carefully — unique
QUOTA.org.Company.PK_QuotaStaging1CLUSTEREDYY0000never2026-09-27 05:18:17UNUSEDKEEP — primary key
QUOTA.org.Company.UX_PricingResult8NONCLUSTEREDYY0000never2026-09-27 05:18:17UNUSEDreview carefully — unique
QUOTA.org.ShipmentAudit.PK_ForecastHeader1CLUSTEREDYY0000never2026-09-27 05:18:17UNUSEDKEEP — primary key
QUOTA.org.ShipmentAudit.UX_BatchArchive2NONCLUSTEREDY0000never2026-09-27 05:18:17UNUSEDreview carefully — unique
QUOTA.org.BookingResult.PK_BillingQueue1CLUSTEREDYY0000never2026-09-27 05:18:17UNUSEDKEEP — primary key
QUOTA.org.InvoiceQueue.PK_TicketEntry1CLUSTEREDYY0000never2026-09-27 05:18:17UNUSEDKEEP — primary key
QUOTA.org.PricingStatus.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-27 05:18:17UNUSEDKEEP — primary key
QUOTA.org.CatalogAudit.PK_AssetStatus1CLUSTEREDYY0000never2026-09-27 05:18:17UNUSEDKEEP — primary key
QUOTA.org.OrdersSummary.PK_StaffingAudit1CLUSTEREDYY0000never2026-09-27 05:18:17UNUSEDKEEP — primary key
QUOTA.org.ContractResult.PK_PolicyLine1CLUSTEREDYY0000never2026-09-27 05:18:17UNUSEDKEEP — primary key
QUOTA.org.SupplierStatus.PK_StaffingResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.SupplierHistory.IX_ShipmentSummary2NONCLUSTERED0000neverneverCOLDreview, then DROP
QUOTA.org.SupplierHistory.PK_CustomerDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.ContractStaging.PK_CatalogDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.BatchSummary.PK_SettlementHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.BillingHeader.IX_ShiftHistory2NONCLUSTERED0000neverneverCOLDreview, then DROP
QUOTA.org.BillingHeader.PK_InvoiceMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.ShipmentSummary.IX_StaffingResult2NONCLUSTERED0000neverneverCOLDreview, then DROP
QUOTA.org.ShipmentSummary.PK_ClaimDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.SalesStatus.IX_ClaimHeader2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.org.SalesStatus.PK_CampaignSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.AssetSummary.PK_TicketStaging1CLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDKEEP — primary key
QUOTA.org.AssetSummary.UX_ShipmentSummary4NONCLUSTEREDY0000never2026-09-27 05:18:18UNUSEDreview carefully — unique
QUOTA.org.ShipmentQueue.PK_InvoiceStaging1CLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDKEEP — primary key
QUOTA.org.PolicyEntry.PK_SettlementSnapshot1CLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDKEEP — primary key
QUOTA.org.PolicyEntry.UX_ShiftSnapshot9NONCLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDreview carefully — unique
QUOTA.org.MeterAudit.PK_BillingDetail1CLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDKEEP — primary key
QUOTA.org.BillingHeader.PK_ContractStaging1CLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDKEEP — primary key
QUOTA.org.TicketSnapshot.PK_ForecastSnapshot1CLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDKEEP — primary key
QUOTA.org.CustomerStaging.PK_CustomerHeader1CLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDKEEP — primary key
QUOTA.org.KPI.PK_ShiftLine1CLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDKEEP — primary key
QUOTA.org.KPI.UX_ShiftHeader8NONCLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDreview carefully — unique
QUOTA.org.StaffingArchive.PK_SettlementResult1CLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDKEEP — primary key
QUOTA.org.CustomerEntry.PK_RouteSummary1CLUSTEREDYY0000never2026-09-27 05:18:18UNUSEDKEEP — primary key
QUOTA.org.PricingDaily.PK_CampaignArchive1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.PricingDaily.UX_BillingArchive2NONCLUSTEREDY0000never2026-09-27 05:18:19UNUSEDreview carefully — unique
QUOTA.org.TicketLine.PK_SupplierMonthly1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.BillingArchive.PK_MeterSummary1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.MeterEntry.PK_SupplierLog1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.ShiftResult.PK_AssetAudit1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.BatchMonthly.PK_SalesLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.RosterMonthly.IX_AssetDetail2NONCLUSTERED0000never2026-09-27 05:18:19UNUSEDreview, then DROP
QUOTA.org.RosterMonthly.PK_ForecastDaily1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.InvoiceStaging.IX_AssetAudit2NONCLUSTERED0000never2026-09-27 05:18:19UNUSEDreview, then DROP
QUOTA.org.InvoiceStaging.PK_CustomerMonthly1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.StaffingAudit.PK_AssetLog1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.Level.PK_ShiftStaging1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.Level.UX_SettlementHistory2NONCLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDreview carefully — unique
QUOTA.org.ContractHistory.PK_RouteArchive1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.QuotaEntry.IX_AssetHistory2NONCLUSTERED0000never2026-09-27 05:18:19UNUSEDreview, then DROP
QUOTA.org.QuotaEntry.PK_LedgerQueue1CLUSTEREDYY0000never2026-09-27 05:18:19UNUSEDKEEP — primary key
QUOTA.org.ClaimQueue.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-27 05:18:20UNUSEDKEEP — primary key
QUOTA.org.Position.PK_PolicySummary1CLUSTEREDYY0000never2026-09-27 05:18:20UNUSEDKEEP — primary key
QUOTA.org.Position.UX_MeterArchive2NONCLUSTEREDYY0000never2026-09-27 05:18:20UNUSEDreview carefully — unique
QUOTA.org.CampaignQueue.PK_BillingArchive1CLUSTEREDYY0000never2026-09-27 05:18:20UNUSEDKEEP — primary key
QUOTA.org.CampaignQueue.UX_TicketDaily2NONCLUSTEREDY0000never2026-09-27 05:18:20UNUSEDreview carefully — unique
QUOTA.org.MeterResult.PK_CatalogStaging1CLUSTEREDYY0000never2026-09-27 05:18:20UNUSEDKEEP — primary key
QUOTA.org.LedgerDaily.PK_ContractHeader1CLUSTEREDYY0000never2026-09-27 05:18:20UNUSEDKEEP — primary key
QUOTA.org.PricingArchive.PK_ShiftStatus1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.PricingArchive.UX_InvoiceAudit2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.org.ForecastAudit.PK_WarehouseSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.ForecastAudit.UX_ClaimArchive2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.org.PayrollLine.PK_OrdersHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.PayrollLine.UX_ShiftLog2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.org.BookingStaging.PK_AssetResult1CLUSTEREDYY0000never2026-09-27 05:18:20UNUSEDKEEP — primary key
QUOTA.org.ReconcileLine.PK_CustomerLog1CLUSTEREDYY0000never2026-09-27 05:18:21UNUSEDKEEP — primary key
QUOTA.org.SupplierResult.PK_ForecastQueue1CLUSTEREDYY0000never2026-09-27 05:18:21UNUSEDKEEP — primary key
QUOTA.org.RouteSummary.PK_RosterAudit1CLUSTEREDYY0000never2026-09-27 05:18:21UNUSEDKEEP — primary key
QUOTA.org.RouteSummary.UX_SupplierSummary2NONCLUSTEREDYY0000never2026-09-27 05:18:21COLDreview carefully — unique
QUOTA.org.ClaimDetail.PK_RouteMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.ShiftResult.PK_ForecastEntry1CLUSTEREDYY0000never2026-09-27 05:18:21UNUSEDKEEP — primary key
QUOTA.org.ShiftResult.UX_LedgerStaging7NONCLUSTEREDY0000never2026-09-27 05:18:21UNUSEDreview carefully — unique
QUOTA.org.QuotaResult.PK_CampaignDaily1CLUSTEREDYY0000never2026-09-27 05:18:21UNUSEDKEEP — primary key
QUOTA.org.QuotaResult.UX_BatchDaily2NONCLUSTEREDY0000never2026-09-27 05:18:21UNUSEDreview carefully — unique
QUOTA.org.SettlementAudit.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-27 05:18:21UNUSEDKEEP — primary key
QUOTA.rec.Candidate.PK_BookingArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.Candidate.UX_CatalogLine2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.rec.AssetEntry.PK_BatchArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.ShipmentDetail.PK_QuotaResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.ShipmentDetail.UX_SalesLog2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.rec.CustomerLine.PK_ShiftStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.SettlementAudit.PK_PricingHeader1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.PricingResult.PK_AssetHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.OrdersMonthly.PK_ContractStatus1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.OrdersMonthly.UX_AssetSnapshot2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.rec.RosterArchive.PK_ContractAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.SalesQueue.PK_LedgerLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.MeterArchive.PK_ForecastResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.MeterArchive.UX_PayrollLine2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.rec.PayrollStatus.PK_ForecastMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.CampaignStatus.PK_InvoiceHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.ReconcileStatus.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.ShipmentMonthly.PK_ContractEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.ForecastSummary.PK_ReconcileLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.CustomerDetail.PK_SalesSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.AssetSnapshot.PK_PolicyResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.AssetSnapshot.UX_ContractArchive2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.rec.CustomerQueue.PK_InvoiceLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.BatchSnapshot.PK_TicketLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.StaffingLine.PK_RosterSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.LedgerStatus.PK_InvoiceDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.SalesHistory.PK_QuotaLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.QuotaLine.PK_ContractArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.SalesStatus.PK_ShiftMonthly1CLUSTEREDYY0000never2026-09-27 05:18:22UNUSEDKEEP — primary key
QUOTA.sal.SettlementQueue.PK_StaffingSnapshot1CLUSTEREDYY0000never2026-09-27 05:18:22UNUSEDKEEP — primary key
QUOTA.sal.SettlementQueue.UX_BillingResult2NONCLUSTEREDY0000never2026-09-27 05:18:22UNUSEDreview carefully — unique
QUOTA.sal.MeterHistory.PK_LedgerSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.ShipmentAudit.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.RouteResult.PK_OrdersAudit1CLUSTEREDYY0000never2026-09-27 05:18:22UNUSEDKEEP — primary key
QUOTA.sal.RouteResult.UX_ContractEntry2NONCLUSTEREDY0000never2026-09-27 05:18:22UNUSEDreview carefully — unique
QUOTA.sal.OrdersHeader.PK_PayrollResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.WarehouseDaily.PK_SettlementDetail1CLUSTEREDYY0000never2026-09-27 05:18:22UNUSEDKEEP — primary key
QUOTA.sal.WarehouseDaily.UX_BookingAudit2NONCLUSTEREDY0000never2026-09-27 05:18:22UNUSEDreview carefully — unique
QUOTA.sal.InvoiceLog.PK_MeterAudit1CLUSTEREDYY0000never2026-09-27 05:18:22UNUSEDKEEP — primary key
QUOTA.sal.PolicySnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-27 05:18:22UNUSEDKEEP — primary key
QUOTA.sal.SettlementStatus.PK_ReconcileResult1CLUSTEREDYY0000never2026-09-27 05:18:22UNUSEDKEEP — primary key
QUOTA.sal.SettlementStatus.UX_StaffingMonthly2NONCLUSTEREDY0000never2026-09-27 05:18:22UNUSEDreview carefully — unique
QUOTA.sal.ReconcileHistory.PK_PayrollHeader1CLUSTEREDYY0000never2026-09-27 05:18:23UNUSEDKEEP — primary key
QUOTA.sal.ReconcileHistory.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-27 05:18:23UNUSEDreview carefully — unique
QUOTA.sal.InvoiceEntry.PK_RouteQueue1CLUSTEREDYY0000never2026-09-27 05:18:23UNUSEDKEEP — primary key
QUOTA.sal.BillingQueue.PK_ReconcileHistory1CLUSTEREDYY0000never2026-09-27 05:18:23UNUSEDKEEP — primary key
QUOTA.sal.RosterDetail.PK_BookingStaging1CLUSTEREDYY0000never2026-09-27 05:18:23UNUSEDKEEP — primary key
QUOTA.sal.RosterQueue.PK_ShiftQueue1CLUSTEREDYY0000never2026-09-27 05:18:23UNUSEDKEEP — primary key
QUOTA.sal.RosterQueue.UX_RosterArchive2NONCLUSTEREDY0000never2026-09-27 05:18:23UNUSEDreview carefully — unique
QUOTA.sal.WarehouseHeader.PK_RouteEntry1CLUSTEREDYY0000never2026-09-27 05:18:23UNUSEDKEEP — primary key
QUOTA.sal.SupplierArchive.PK_SupplierStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.RosterQueue.PK_PolicyLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.CustomerSnapshot.PK_RosterEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.LedgerStatus.PK_WarehouseStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.BookingLine.PK_PricingAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.PricingLine.PK_BatchLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.WarehouseStaging.PK_SettlementHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.StaffingArchive.PK_CatalogLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.WarehouseSummary.PK_RosterArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-27 05:18:26UNUSEDKEEP — primary key
ASSET.cfg.QuotaStatus.UX_MeterSummary2NONCLUSTEREDY0000never2026-09-27 05:18:26UNUSEDreview carefully — unique
ASSET.dbo.ContractResult.PK_CampaignResult1CLUSTEREDYY07072026-10-02 02:15:032026-09-27 05:18:26USEDKEEP — primary key
ASSET.dbo.SettlementStaging.PK_TicketStaging1CLUSTEREDYY0007never2026-10-01 03:14:55UNUSEDKEEP — primary key
ASSET.dbo.Jobs.PK_RosterStatus1CLUSTEREDYY8268368002026-10-03 00:00:022026-09-27 05:18:27USEDKEEP — primary key
ASSET.dbo.Jobs.UQ_ContractMonthly2NONCLUSTEREDY0000never2026-09-27 05:18:27UNUSEDreview carefully — unique
ASSET.dbo.Keys.PK_BookingDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.OrdersSnapshot.IX_SalesQueue2NONCLUSTERED0184027562026-10-03 00:00:022026-10-02 01:38:41USEDkeep — in use
ASSET.dbo.OrdersSnapshot.PK_PolicyLine1CLUSTEREDYY17084552055122026-10-03 00:00:022026-10-02 01:38:41USEDKEEP — primary key
ASSET.dbo.SalesLine.IX_ReconcileResult2NONCLUSTERED18422901842026-10-03 00:00:022026-10-02 01:38:42USEDkeep — in use
ASSET.dbo.SalesLine.PK_MeterStatus1CLUSTEREDYY032301842026-10-03 00:00:022026-10-02 01:38:42USEDKEEP — primary key
ASSET.dbo.InvoiceSummary.PK_LedgerResult1CLUSTEREDYY183238805512026-10-03 00:00:022026-10-02 01:38:42USEDKEEP — primary key
ASSET.dbo.CustomerSummary.PK_TicketStaging1CLUSTEREDYY6980736071642026-10-03 00:00:022026-10-02 01:38:42USEDKEEP — primary key
ASSET.dbo.QuotaResult.PK_TerritoryStatus1CLUSTEREDYY69800002026-10-03 00:00:012026-09-27 05:18:28USEDKEEP — primary key
ASSET.dbo.LedgerResult.PK_ForecastMonthly1CLUSTEREDYY18436801842026-10-03 00:00:022026-10-02 01:38:45USEDKEEP — primary key
ASSET.dbo.BatchResult.IX_SettlementStaging2NONCLUSTERED0008never2026-10-02 01:38:45UNUSEDreview, then DROP
ASSET.dbo.BatchResult.IX_ReconcileEntry3NONCLUSTERED0008never2026-10-02 01:38:45UNUSEDreview, then DROP
ASSET.dbo.BatchResult.PK_ContractEntry1CLUSTEREDYY0008never2026-10-02 01:38:45UNUSEDKEEP — primary key
ASSET.dbo.PricingLog.PK_RouteLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.ClaimArchive.PK_StaffingStaging1CLUSTEREDYY2572184002026-10-03 00:00:022026-09-27 05:18:31USEDKEEP — primary key
ASSET.dbo.ClaimArchive.UQ_SupplierResult2NONCLUSTEREDY0000never2026-09-27 05:18:31UNUSEDreview carefully — unique
ASSET.dbo.CustomerArchive.IX_BillingHeader3NONCLUSTERED0008never2026-09-27 05:18:31UNUSEDreview, then DROP
ASSET.dbo.CustomerArchive.PK_AssetSummary1CLUSTEREDYY242204082026-10-03 00:00:002026-09-27 05:18:31USEDKEEP — primary key
ASSET.dbo.CustomerArchive.UQ_OrdersMonthly2NONCLUSTEREDY0000never2026-09-27 05:18:31UNUSEDreview carefully — unique
ASSET.dbo.Status.PK_ShiftLine1CLUSTEREDYY12859552002026-10-03 00:00:022026-09-27 05:18:31USEDKEEP — primary key
ASSET.dbo.Status.UQ_PricingHeader2NONCLUSTEREDY0000never2026-09-27 05:18:32UNUSEDreview carefully — unique
ASSET.dbo.CatalogLine.PK_PricingQueue1CLUSTEREDYY00016never2026-10-02 01:38:45UNUSEDKEEP — primary key
ASSET.dbo.SupplierDetail.PK_ShiftResult1CLUSTEREDYY0000never2026-09-27 05:18:32UNUSEDKEEP — primary key
ASSET.dbo.CampaignResult.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-27 05:18:32UNUSEDKEEP — primary key
ASSET.dbo.TicketQueue.PK_CampaignEntry1CLUSTEREDYY0000never2026-09-27 05:18:32UNUSEDKEEP — primary key
ASSET.dbo.Color.PK_ReconcileStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.Color.UQ_CatalogStaging2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
ASSET.dbo.WarehouseEntry.PK_ShiftStatus1CLUSTEREDYY4097784002026-10-02 21:00:002026-09-27 05:18:32USEDKEEP — primary key
ASSET.dbo.WarehouseEntry.UX_CampaignHeader2NONCLUSTEREDY0000never2026-09-27 05:18:32UNUSEDreview carefully — unique
ASSET.dbo.TicketSummary.PK_SalesLine1CLUSTERED0554002026-10-02 18:25:082026-09-27 05:18:32USEDKEEP — table storage
ASSET.dbo.TerritoryEntry.PK_SalesSummary1CLUSTEREDYY135422002026-10-02 19:46:512026-09-27 05:18:32USEDKEEP — primary key
ASSET.dbo.TerritoryEntry.UX_TerritoryQueue2NONCLUSTEREDY0000never2026-09-27 05:18:32UNUSEDreview carefully — unique
ASSET.dbo.PolicyEntry.PK_TicketEntry1CLUSTEREDYY70499002026-10-02 19:46:512026-09-27 05:18:33USEDKEEP — primary key
ASSET.dbo.PolicyEntry.UX_PolicyAudit2NONCLUSTEREDY0000never2026-09-27 05:18:33UNUSEDreview carefully — unique
ASSET.dbo.CampaignHeader.PK_InvoiceSnapshot1CLUSTEREDYY38829110002026-10-02 21:00:002026-09-27 05:18:33USEDKEEP — primary key
ASSET.dbo.CampaignHeader.UX_BillingLog2NONCLUSTEREDY0000never2026-09-27 05:18:33UNUSEDreview carefully — unique
ASSET.dbo.ShiftResult.IX_SalesHeader3NONCLUSTERED0000neverneverCOLDreview, then DROP
ASSET.dbo.ShiftResult.PK_MeterStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.ShiftResult.UQ_RosterArchive2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
ASSET.dbo.BookingArchive.PK_StaffingDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.BookingArchive.UQ_RosterStatus2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
ASSET.dbo.OrdersDetail.IX_PolicyMonthly2NONCLUSTERED0000neverneverCOLDreview, then DROP
ASSET.dbo.OrdersDetail.PK_BillingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.ForecastMonthly.PK_LedgerEntry1CLUSTEREDYY0003never2026-09-27 05:18:33UNUSEDKEEP — primary key
ASSET.dbo.ForecastMonthly.UQ_SupplierHeader2NONCLUSTEREDY30032026-09-25 12:40:132026-09-27 05:18:33USEDkeep — in use
ASSET.dbo.RouteLog.IX_CampaignQueue3NONCLUSTERED0000neverneverCOLDreview, then DROP
ASSET.dbo.RouteLog.PK_ContractHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.RouteLog.UQ_StaffingQueue2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
ASSET.dbo.PayrollStatus.IX_StaffingHeader2NONCLUSTERED0000neverneverCOLDreview, then DROP
ASSET.dbo.PayrollStatus.PK_PricingQueue1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.WarehouseHeader.PK_OrdersQueue1CLUSTEREDYY068002026-10-02 18:26:382026-09-27 05:18:33USEDKEEP — primary key
ASSET.dbo.WarehouseHeader.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-27 05:18:33UNUSEDreview carefully — unique
ASSET.dbo.RouteQueue.PK_SupplierAudit1CLUSTEREDYY144222002026-10-02 19:46:512026-09-27 05:18:33USEDKEEP — primary key
ASSET.dbo.RouteQueue.UX_CampaignQueue2NONCLUSTEREDY0000never2026-09-27 05:18:33UNUSEDreview carefully — unique
ASSET.dbo.CampaignAudit.PK_BatchSnapshot1CLUSTEREDYY697103002026-10-02 19:46:512026-09-27 05:18:33USEDKEEP — primary key
ASSET.dbo.CampaignAudit.UX_SupplierArchive2NONCLUSTEREDY0000never2026-09-27 05:18:33UNUSEDreview carefully — unique
ASSET.dbo.ShiftHistory.IX_SupplierLog2NONCLUSTEREDY0000never2026-09-27 05:18:34UNUSEDreview carefully — unique
ASSET.dbo.Unit.PK_ForecastLine1CLUSTEREDYY0006never2026-09-27 05:18:34UNUSEDKEEP — primary key
ASSET.dbo.Unit.UQ_ClaimHeader2NONCLUSTEREDY60062026-09-25 12:40:132026-09-27 05:18:34USEDkeep — in use
ASSET.dbo.ShiftDaily.PK_ReconcileStatus1CLUSTEREDYY144316002026-10-02 19:46:512026-09-27 05:18:34USEDKEEP — primary key
ASSET.dbo.ShiftDaily.UX_RouteDaily2NONCLUSTEREDY0000never2026-09-27 05:18:34UNUSEDreview carefully — unique
ASSET.emp.WarehouseMonthly.PK_PricingHistory1CLUSTEREDYY5341151102026-10-02 19:53:352026-09-27 05:18:34USEDKEEP — primary key
ASSET.emp.WarehouseMonthly.UX_CustomerDetail2NONCLUSTEREDYY110002026-10-02 19:53:352026-09-27 05:18:34USEDkeep — in use
ASSET.emp.SettlementLine.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-27 05:18:34UNUSEDKEEP — primary key
ASSET.emp.SalesDetail.PK_BillingLog1CLUSTEREDYY092002026-10-02 23:27:052026-09-27 05:18:34USEDKEEP — primary key
ASSET.emp.BatchMonthly.PK_TicketAudit1CLUSTEREDYY0000never2026-09-27 05:18:34UNUSEDKEEP — primary key
ASSET.emp.RosterLog.PK_QuotaLog1CLUSTEREDYY5254000262702026-10-02 15:51:072026-09-27 05:18:34USEDKEEP — primary key
ASSET.emp.QuotaMonthly.IX_ShipmentEntry19NONCLUSTERED38655002012026-10-02 21:00:002026-10-01 03:14:56USEDkeep — in use
ASSET.emp.QuotaMonthly.PK_ReconcileDetail1CLUSTEREDYY436386552012026-10-02 21:00:002026-09-30 02:57:54USEDKEEP — primary key
ASSET.emp.OrdersEntry.PK_PolicyHeader1CLUSTEREDYY00065never2026-10-01 03:14:56UNUSEDKEEP — primary key
ASSET.emp.PayrollSummary.PK_RouteSummary1CLUSTEREDYY092002026-10-02 23:27:052026-09-27 05:18:37USEDKEEP — primary key
ASSET.emp.SettlementAudit.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-27 05:18:37UNUSEDKEEP — primary key
ASSET.emp.InvoiceLog.PK_BatchEntry1CLUSTEREDYY0000never2026-09-27 05:18:37UNUSEDKEEP — primary key
ASSET.emp.InvoiceMonthly.PK_RouteEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.InvoiceMonthly.UX_CustomerSnapshot2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
ASSET.emp.CampaignEntry.PK_TicketMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.CampaignEntry.UX_CatalogHistory2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
ASSET.emp.RouteHistory.PK_CustomerMonthly1CLUSTEREDYY1315002026-10-02 19:53:352026-09-27 05:18:37USEDKEEP — primary key
ASSET.emp.RouteHistory.UX_CustomerQueue2NONCLUSTEREDY0000never2026-09-27 05:18:37UNUSEDreview carefully — unique
ASSET.emp.CustomerHistory.PK_ShiftDaily1CLUSTEREDYY320002026-10-02 18:26:412026-09-27 05:18:38USEDKEEP — primary key
ASSET.emp.ForecastEntry.PK_SettlementLog1CLUSTEREDYY028984002026-10-01 09:22:012026-09-27 05:18:38USEDKEEP — primary key
ASSET.emp.ClaimQueue.PK_TerritoryResult1CLUSTEREDYY0000never2026-09-27 05:18:38UNUSEDKEEP — primary key
ASSET.emp.PolicyAudit.PK_ContractAudit1CLUSTEREDYY029398002026-10-01 13:06:542026-09-27 05:18:38USEDKEEP — primary key
ASSET.emp.ShipmentSummary.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-27 05:18:38UNUSEDKEEP — primary key
ASSET.emp.BatchArchive.PK_ClaimHistory1CLUSTEREDYY2938811002026-10-01 13:06:542026-09-27 05:18:38USEDKEEP — primary key
ASSET.emp.RosterSnapshot.PK_PolicyStaging1CLUSTEREDYY0000never2026-09-27 05:18:39UNUSEDKEEP — primary key
ASSET.emp.MeterResult.IX_LedgerQueue9NONCLUSTERED026670672026-10-02 19:53:362026-10-01 03:14:57USEDkeep — in use
ASSET.emp.MeterResult.PK_CustomerResult1CLUSTEREDYY15041511340672026-10-02 21:00:002026-09-30 02:57:55USEDKEEP — primary key
ASSET.emp.PayrollHeader.PK_TicketHistory1CLUSTEREDYY71930952026-10-02 18:26:412026-09-30 02:57:56USEDKEEP — primary key
ASSET.emp.OrdersAudit.PK_ShipmentHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.RosterResult.PK_MeterAudit1CLUSTEREDYY0104002026-10-03 00:00:002026-09-27 05:18:39USEDKEEP — primary key
ASSET.emp.RouteHeader.PK_StaffingQueue1CLUSTEREDYY0000never2026-09-27 05:18:40UNUSEDKEEP — primary key
ASSET.emp.MeterAudit.PK_ClaimLog1CLUSTEREDYY75850352026-10-02 19:50:052026-09-30 02:57:56USEDKEEP — primary key
ASSET.emp.QuotaStatus.PK_OrdersArchive1CLUSTEREDYY0005never2026-09-30 02:57:56UNUSEDKEEP — primary key
ASSET.emp.ShiftLine.IX_PricingAudit13NONCLUSTERED40002026-10-02 19:47:272026-09-27 05:18:40USEDkeep — in use
ASSET.emp.ShiftLine.PK_SettlementStatus1CLUSTEREDYY9101602026-10-02 23:27:052026-09-27 05:18:40USEDKEEP — primary key
ASSET.emp.ShiftLine.UX_BookingDaily2NONCLUSTEREDY20002026-10-01 09:21:112026-09-27 05:18:40USEDkeep — in use
ASSET.emp.CampaignHeader.PK_BillingQueue1CLUSTEREDYY07002026-10-01 08:37:22neverUSEDKEEP — primary key
ASSET.emp.MeterStatus.PK_BillingStaging1CLUSTEREDYY0000never2026-09-27 05:18:41UNUSEDKEEP — primary key
ASSET.emp.WarehouseStaging.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-27 05:18:41UNUSEDKEEP — primary key
ASSET.emp.ForecastHeader.IX_WarehouseResult3NONCLUSTERED5910012026-10-02 18:26:412026-09-27 05:18:41USEDkeep — in use
ASSET.emp.ForecastHeader.PK_OrdersAudit1CLUSTEREDYY1459112026-10-02 19:47:272026-09-27 05:18:41USEDKEEP — primary key
ASSET.emp.SalesLog.PK_AssetStaging1CLUSTEREDYY0000never2026-09-27 05:18:41UNUSEDKEEP — primary key
ASSET.emp.AssetDaily.PK_CustomerMonthly1CLUSTEREDYY01129002026-10-02 18:26:42neverUSEDKEEP — primary key
ASSET.emp.StaffingDaily.PK_BookingLog1CLUSTEREDYY015002026-10-01 08:45:06neverUSEDKEEP — primary key
ASSET.emp.ClaimResult.PK_TerritoryQueue1CLUSTEREDYY0000never2026-09-27 05:18:42UNUSEDKEEP — primary key
ASSET.emp.CatalogLog.PK_ReconcileHeader1CLUSTEREDYY0000never2026-09-27 05:18:42UNUSEDKEEP — primary key
ASSET.emp.ShipmentSnapshot.PK_ReconcileQueue1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.PricingDaily.IX_ShiftAudit2NONCLUSTERED5760002026-10-02 19:47:272026-09-27 05:18:42USEDkeep — in use
ASSET.emp.PricingDaily.PK_RouteEntry1CLUSTEREDYY0857602026-10-02 19:47:272026-09-27 05:18:42USEDKEEP — primary key
ASSET.emp.PolicyLog.PK_LedgerHistory1CLUSTEREDYY248691572026-10-02 15:52:152026-09-30 02:57:56USEDKEEP — primary key
ASSET.emp.PolicyLog.UX_OrdersSnapshot5NONCLUSTEREDY69100572026-10-02 15:52:152026-10-01 03:14:57USEDkeep — in use
ASSET.emp.RouteAudit.PK_ClaimResult1CLUSTEREDYY0005never2026-09-30 02:57:56UNUSEDKEEP — primary key
ASSET.emp.PayrollDaily.IX_BillingStaging2NONCLUSTERED1000302026-09-29 09:55:032026-09-27 05:18:43USEDkeep — in use
ASSET.emp.PayrollDaily.PK_OrdersSnapshot1CLUSTEREDYY005302026-09-29 09:55:032026-09-27 05:18:43USEDKEEP — primary key
ASSET.emp.MeterHistory.IX_ContractArchive19NONCLUSTERED410901202026-10-02 18:26:442026-10-01 03:14:58USEDkeep — in use
ASSET.emp.MeterHistory.PK_BatchLog1CLUSTEREDYY119407553401714241272026-10-03 00:04:422026-09-30 02:57:57USEDKEEP — primary key
ASSET.emp.MeterHistory.UX_BatchLog2NONCLUSTEREDYY000120never2026-10-01 03:14:58UNUSEDreview carefully — unique
ASSET.emp.MeterHistory.UX_ForecastHeader23NONCLUSTEREDY39666801202026-10-02 21:00:002026-10-01 03:14:58USEDkeep — in use
ASSET.emp.MeterHistory.UX_CustomerSnapshot3NONCLUSTEREDYY0101202026-09-27 21:27:382026-10-01 03:14:58USEDkeep — in use
ASSET.emp.MeterHistory.UX_QuotaStaging4NONCLUSTEREDY132772001202026-10-02 21:00:002026-10-01 03:14:58USEDkeep — in use
ASSET.emp.TerritoryLine.PK_LedgerArchive1CLUSTEREDYY34609153041652026-10-02 15:51:072026-09-27 05:18:43USEDKEEP — primary key
ASSET.emp.SalesStaging.PK_PolicyDaily1CLUSTEREDYY543126092026-10-02 18:26:422026-09-27 05:18:44USEDKEEP — primary key
ASSET.emp.TerritoryDaily.PK_MeterLog1CLUSTEREDYY0000never2026-09-27 05:18:44UNUSEDKEEP — primary key
ASSET.emp.SettlementQueue.IX_PolicyAudit2NONCLUSTERED0004156never2026-10-01 03:14:59UNUSEDreview, then DROP
ASSET.emp.SettlementQueue.PK_SalesEntry1CLUSTEREDYY04041562026-10-02 19:47:272026-10-01 03:14:59USEDKEEP — primary key
ASSET.emp.StaffingMonthly.IX_ReconcileEntry8NONCLUSTERED0000never2026-09-27 05:18:44UNUSEDreview, then DROP
ASSET.emp.StaffingMonthly.IX_SalesQueue9NONCLUSTERED15400002026-10-02 18:27:422026-09-27 05:18:44USEDkeep — in use
ASSET.emp.StaffingMonthly.PK_CampaignStatus1CLUSTEREDYY0141768602026-10-02 18:27:412026-09-27 05:18:44USEDKEEP — primary key
ASSET.emp.TicketQueue.PK_BatchDaily1CLUSTEREDYY00593602026-10-02 19:47:272026-10-01 03:14:59USEDKEEP — primary key
ASSET.emp.TicketQueue.UX_PayrollDaily2NONCLUSTEREDY59300602026-10-02 19:47:272026-10-01 03:14:59USEDkeep — in use
ASSET.emp.MeterStatus.PK_CustomerDetail1CLUSTEREDYY00060never2026-10-01 03:14:59UNUSEDKEEP — primary key
ASSET.emp.OrdersEntry.PK_TerritoryAudit1CLUSTEREDYY0691002026-10-02 23:27:052026-09-27 05:18:45USEDKEEP — primary key
ASSET.emp.InvoiceLog.PK_BillingDetail1CLUSTEREDYY00042never2026-10-01 03:14:59UNUSEDKEEP — primary key
ASSET.emp.CampaignHistory.IX_QuotaDetail2NONCLUSTERED3218930002026-10-02 18:56:102026-09-27 05:18:46USEDkeep — in use
ASSET.emp.CampaignHistory.PK_AssetHeader1CLUSTEREDYY032689232189302026-10-02 19:47:272026-09-27 05:18:45USEDKEEP — primary key
ASSET.emp.ContractArchive.PK_BookingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.TicketLine.PK_CampaignEntry1CLUSTEREDYY3510002026-10-02 19:47:272026-09-27 05:18:46USEDKEEP — primary key
ASSET.emp.BatchAudit.IX_ShiftSnapshot23NONCLUSTERED64584341409667452026-10-03 00:04:422026-10-01 03:15:20USEDkeep — in use
ASSET.emp.BatchAudit.PK_ForecastSummary1CLUSTEREDYY3222061138195800712889792026-10-03 00:04:422026-10-01 03:15:00USEDKEEP — primary key
ASSET.emp.BatchAudit.UX_LedgerStaging10NONCLUSTEREDY2298531609667452026-10-02 19:52:382026-10-01 03:16:20USEDkeep — in use
ASSET.emp.ClaimAudit.PK_LedgerDaily1CLUSTEREDYY0001neverneverUNUSEDKEEP — primary key
ASSET.emp.ClaimAudit.UX_RouteMonthly12NONCLUSTEREDY01012026-09-29 02:00:04neverUSEDkeep — in use
ASSET.emp.PolicyHistory.PK_OrdersDaily1CLUSTEREDYY3954987907177932026-10-02 19:47:262026-10-02 02:05:21USEDKEEP — primary key
ASSET.emp.ForecastQueue.IX_BookingLine12NONCLUSTERED0000never2026-09-27 05:19:51UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_InvoiceMonthly15NONCLUSTERED0000never2026-09-27 05:19:54UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_RouteStatus13NONCLUSTERED0000never2026-09-27 05:19:56UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_ForecastMonthly14NONCLUSTERED0000never2026-09-27 05:19:58UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.PK_CustomerHistory1CLUSTEREDYY0000never2026-09-27 05:19:51UNUSEDKEEP — primary key
ASSET.emp.ForecastQueue.IX_ForecastMonthly2NONCLUSTEREDY0000never2026-09-27 05:19:59UNUSEDreview carefully — unique
ASSET.emp.ShipmentArchive.PK_ReconcileStaging1CLUSTEREDYY0000never2026-09-27 05:20:00UNUSEDKEEP — primary key
ASSET.emp.BillingEntry.PK_StaffingAudit1CLUSTEREDYY02733955442026-10-02 19:47:282026-10-02 01:38:59USEDKEEP — primary key
ASSET.emp.BillingEntry.UX_StaffingLog2NONCLUSTEREDY732762403955442026-10-02 18:56:112026-10-02 01:38:59USEDkeep — in use
ASSET.emp.BillingAudit.IX_PolicyHeader9NONCLUSTERED8422203955442026-10-02 19:47:262026-09-27 05:20:16USEDkeep — in use
ASSET.emp.BillingAudit.PK_PolicyDetail1CLUSTEREDYY0023955442026-10-02 19:47:262026-09-27 05:20:16USEDKEEP — primary key
ASSET.emp.BillingAudit.UX_SupplierSnapshot2NONCLUSTEREDY732613603955442026-10-02 18:56:112026-09-27 05:20:16USEDkeep — in use
ASSET.emp.ShipmentStaging.PK_TerritoryStatus1CLUSTEREDYY020732962026-10-02 19:47:262026-09-27 05:20:17USEDKEEP — primary key
ASSET.emp.ShipmentStaging.UX_RosterDaily2NONCLUSTEREDY73260360732962026-10-02 18:56:112026-09-27 05:20:17USEDkeep — in use
ASSET.emp.SalesLine.PK_CampaignResult1CLUSTEREDYY39654521007177902026-10-02 19:52:382026-10-02 01:39:01USEDKEEP — primary key
ASSET.emp.LedgerSnapshot.PK_CampaignStatus1CLUSTEREDYY00035never2026-10-01 03:17:05UNUSEDKEEP — primary key
ASSET.emp.ReconcileDetail.PK_CampaignQueue1CLUSTEREDYY16270392026-10-02 18:26:422026-09-30 02:59:43USEDKEEP — primary key
ASSET.emp.PolicyStaging.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.ReconcileStaging.PK_ContractStaging1CLUSTEREDYY18879002026-10-02 19:46:512026-09-27 05:20:19USEDKEEP — primary key
ASSET.emp.ReconcileStaging.UX_OrdersHistory2NONCLUSTEREDY0000never2026-09-27 05:20:19UNUSEDreview carefully — unique
ASSET.emp.MeterStatus.PK_ReconcileMonthly1CLUSTEREDYY73538843762026-10-02 21:00:002026-09-30 02:59:43USEDKEEP — primary key
ASSET.emp.MeterStatus.UX_ReconcileAudit5NONCLUSTEREDY3884300762026-10-02 21:00:002026-09-30 02:59:43USEDkeep — in use
ASSET.emp.PricingAudit.PK_ReconcileSnapshot1CLUSTEREDYY0005never2026-09-30 02:59:43UNUSEDKEEP — primary key
ASSET.emp.OrdersMonthly.IX_QuotaArchive5NONCLUSTEREDY000116never2026-10-01 03:17:05UNUSEDreview, then DROP
ASSET.emp.OrdersMonthly.IX_PayrollResult4NONCLUSTEREDY0000never2026-10-01 03:17:05UNUSEDreview, then DROP
ASSET.emp.OrdersMonthly.IX_TicketSnapshot2NONCLUSTERED6211801572026-10-02 18:27:422026-10-01 03:17:05USEDkeep — in use
ASSET.emp.OrdersMonthly.IX_SettlementLine3NONCLUSTERED12001572026-09-27 21:27:402026-10-01 03:17:05USEDkeep — in use
ASSET.emp.OrdersMonthly.PK_ShipmentSnapshot1CLUSTEREDYY6001572026-10-01 08:37:142026-10-01 03:17:05USEDKEEP — primary key
ASSET.emp.MeterAudit.PK_BatchDaily1CLUSTEREDYY0000never2026-09-27 05:20:20UNUSEDKEEP — primary key
ASSET.emp.ContractMonthly.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-27 05:20:20UNUSEDKEEP — primary key
ASSET.emp.RosterQueue.PK_SettlementHistory1CLUSTEREDYY14456002026-10-02 19:53:352026-09-27 05:20:20USEDKEEP — primary key
ASSET.emp.TicketAudit.IX_LedgerLog2NONCLUSTERED0000never2026-09-27 05:20:20UNUSEDreview, then DROP
ASSET.emp.TicketAudit.PK_LedgerStatus1CLUSTEREDYY0000never2026-09-27 05:20:20UNUSEDKEEP — primary key
ASSET.emp.InvoiceResult.PK_ShipmentMonthly1CLUSTEREDYY0000never2026-09-27 05:20:20UNUSEDKEEP — primary key
ASSET.emp.CustomerLog.IX_PayrollResult20NONCLUSTERED128889164449501572026-10-03 00:04:422026-09-27 05:20:21USEDkeep — in use
ASSET.emp.CustomerLog.PK_StaffingDaily1CLUSTEREDYY96750864472412888921572026-10-03 00:04:422026-09-27 05:20:21USEDKEEP — primary key
ASSET.emp.InvoiceAudit.IX_SettlementResult10NONCLUSTERED42800812026-10-01 13:06:542026-09-27 05:20:21USEDkeep — in use
ASSET.emp.InvoiceAudit.PK_QuotaEntry1CLUSTEREDYY0920812026-10-02 02:15:032026-09-27 05:20:21USEDKEEP — primary key
ASSET.emp.MeterSummary.PK_AssetEntry1CLUSTEREDYY00067never2026-09-27 05:20:21UNUSEDKEEP — primary key
ASSET.emp.AssetSummary.PK_SupplierStaging1CLUSTEREDYY070822026-10-02 02:15:032026-09-27 05:20:21USEDKEEP — primary key
ASSET.emp.SupplierStaging.IX_StaffingSnapshot24NONCLUSTERED5562755500122392026-10-03 00:04:422026-10-02 01:39:02USEDkeep — in use
ASSET.emp.SupplierStaging.IX_MeterStaging17NONCLUSTERED00012170never2026-10-02 01:39:02UNUSEDreview, then DROP
ASSET.emp.SupplierStaging.IX_StaffingEntry23NONCLUSTERED010121902026-09-26 15:53:412026-10-02 01:39:02USEDkeep — in use
ASSET.emp.SupplierStaging.PK_PayrollMonthly1CLUSTEREDYY365042109434233144122792026-10-03 00:04:422026-10-02 01:39:02USEDKEEP — primary key
ASSET.emp.CustomerStatus.IX_ReconcileLine10NONCLUSTERED4886111080323292026-10-02 16:00:402026-10-02 01:39:03USEDkeep — in use
ASSET.emp.CustomerStatus.PK_PolicyHistory1CLUSTEREDYY0142685090323292026-10-02 16:00:402026-10-02 01:39:03USEDKEEP — primary key
ASSET.emp.BillingAudit.PK_CustomerEntry1CLUSTEREDYY00024277never2026-10-02 01:39:03UNUSEDKEEP — primary key
ASSET.emp.PolicyLine.PK_OrdersSummary1CLUSTEREDYY0166002026-10-02 16:00:402026-09-27 05:20:23USEDKEEP — primary key
ASSET.emp.RouteStaging.PK_WarehouseLine1CLUSTEREDYY046002026-10-01 07:43:052026-09-27 05:20:23USEDKEEP — primary key
ASSET.emp.CampaignMonthly.PK_OrdersArchive1CLUSTEREDYY0128012026-10-02 16:00:402026-09-27 05:20:23USEDKEEP — primary key
ASSET.emp.CatalogSnapshot.PK_ClaimHistory1CLUSTEREDYY0000never2026-09-27 05:20:23UNUSEDKEEP — primary key
ASSET.emp.BillingDaily.PK_CustomerLine1CLUSTEREDYY04078415340882026-10-02 14:37:162026-09-27 05:20:23USEDKEEP — primary key
ASSET.emp.BillingDaily.UX_LedgerDaily2NONCLUSTEREDY41540040882026-10-02 14:37:162026-09-27 05:20:23USEDkeep — in use
ASSET.emp.BillingHistory.PK_TerritorySummary1CLUSTEREDYY0000never2026-09-27 05:20:23UNUSEDKEEP — primary key
ASSET.emp.SupplierHistory.PK_WarehouseMonthly1CLUSTEREDYY0110122282026-10-02 02:15:032026-10-02 01:39:03USEDKEEP — primary key
ASSET.emp.ShipmentMonthly.IX_SupplierEntry12NONCLUSTERED51800259922026-10-01 13:06:542026-09-28 22:13:55USEDkeep — in use
ASSET.emp.ShipmentMonthly.IX_InvoiceStaging5NONCLUSTERED1425600259922026-10-02 21:00:002026-09-28 22:13:55USEDkeep — in use
ASSET.emp.ShipmentMonthly.PK_BatchDaily1CLUSTEREDYY4710218259962026-10-02 21:00:002026-09-28 22:14:59USEDKEEP — primary key
ASSET.emp.AssetDetail.PK_ReconcileResult1CLUSTEREDYY00011983never2026-09-29 01:11:28UNUSEDKEEP — primary key
ASSET.emp.AssetSnapshot.IX_ForecastStatus7NONCLUSTERED339091214040342026-10-02 18:56:102026-09-30 02:59:46USEDkeep — in use
ASSET.emp.AssetSnapshot.IX_SalesDaily5NONCLUSTERED15107011247040342026-10-03 00:04:422026-09-30 02:59:46USEDkeep — in use
ASSET.emp.AssetSnapshot.PK_OrdersDetail1CLUSTEREDYY401684440342026-09-28 22:38:572026-09-30 02:59:46USEDKEEP — primary key
ASSET.emp.PricingStatus.PK_PolicyStatus1CLUSTEREDYY0004030never2026-09-30 02:59:46UNUSEDKEEP — primary key
ASSET.emp.TicketSnapshot.PK_CampaignQueue1CLUSTEREDYY706885122990119852026-10-03 00:04:422026-09-30 02:59:46USEDKEEP — primary key
ASSET.emp.ForecastMonthly.PK_CampaignSummary1CLUSTEREDYY070119812026-10-02 02:15:032026-09-30 02:59:46USEDKEEP — primary key
ASSET.emp.PricingStatus.IX_QuotaLog8NONCLUSTERED42150040142026-09-29 16:19:392026-09-30 02:59:47USEDkeep — in use
ASSET.emp.PricingStatus.IX_ClaimEntry6NONCLUSTERED37592911621040142026-10-03 00:04:412026-09-30 02:59:47USEDkeep — in use
ASSET.emp.PricingStatus.PK_LedgerResult1CLUSTEREDYY323122151421540142026-10-03 00:04:422026-09-30 02:59:47USEDKEEP — primary key
ASSET.emp.PayrollHistory.PK_LedgerQueue1CLUSTEREDYY0004003never2026-09-30 02:59:47UNUSEDKEEP — primary key
ASSET.emp.QuotaSummary.IX_StaffingQueue10NONCLUSTERED447337720305442026-10-02 02:15:032026-09-29 01:11:29USEDkeep — in use
ASSET.emp.QuotaSummary.PK_LedgerEntry1CLUSTEREDYY0880831765305442026-10-02 02:15:032026-09-29 01:11:29USEDKEEP — primary key
ASSET.emp.PricingQueue.PK_PricingStaging1CLUSTEREDYY00022913never2026-09-29 01:11:29UNUSEDKEEP — primary key
ASSET.emp.BookingMonthly.IX_ShipmentAudit5NONCLUSTERED8531860483078082026-10-03 00:04:412026-09-29 01:11:29USEDkeep — in use
ASSET.emp.BookingMonthly.IX_RosterStatus6NONCLUSTERED288072282745020072026-10-02 19:52:382026-09-29 01:11:29USEDkeep — in use
ASSET.emp.BookingMonthly.PK_WarehouseLog1CLUSTEREDYY0007808never2026-09-29 01:11:29UNUSEDKEEP — primary key
ASSET.emp.MeterSnapshot.PK_StaffingSummary1CLUSTEREDYY0007808never2026-09-29 01:11:30UNUSEDKEEP — primary key
ASSET.emp.BatchMonthly.PK_InvoiceDetail1CLUSTEREDYY7051043373030191602026-10-03 00:04:422026-09-29 01:11:30USEDKEEP — primary key
ASSET.emp.StaffingAudit.PK_ForecastHeader1CLUSTEREDYY070191612026-10-02 02:15:032026-09-29 01:11:30USEDKEEP — primary key
ASSET.emp.BatchLog.IX_TerritoryDetail5NONCLUSTERED29503200120122026-10-02 19:52:382026-09-29 01:11:30USEDkeep — in use
ASSET.emp.BatchLog.PK_SalesDetail1CLUSTEREDYY322247385799295025458362026-10-03 00:04:422026-09-29 01:11:30USEDKEEP — primary key
ASSET.emp.RouteHistory.PK_MeterEntry1CLUSTEREDYY00045836never2026-09-29 01:11:31UNUSEDKEEP — primary key
ASSET.emp.CampaignResult.IX_ForecastAudit16NONCLUSTERED6434110712026-10-02 19:52:392026-09-30 02:59:47USEDkeep — in use
ASSET.emp.CampaignResult.IX_ClaimStatus14NONCLUSTERED645994601122026-10-03 00:04:422026-09-30 02:59:47USEDkeep — in use
ASSET.emp.CampaignResult.IX_CustomerQueue13NONCLUSTERED644480002242026-10-03 00:04:422026-09-30 02:59:47USEDkeep — in use
ASSET.emp.CampaignResult.PK_StaffingArchive1CLUSTEREDYY64469152212894702262026-10-03 00:04:422026-09-27 05:20:28USEDKEEP — primary key
ASSET.emp.SalesHeader.IX_BookingSummary2NONCLUSTERED000499never2026-10-02 01:39:06UNUSEDreview, then DROP
ASSET.emp.SalesHeader.PK_CatalogQueue1CLUSTEREDYY000499never2026-10-02 01:39:06UNUSEDKEEP — primary key
ASSET.emp.PayrollHistory.PK_CampaignStaging1CLUSTEREDYY122492012026-10-02 23:27:052026-09-27 05:20:29USEDKEEP — primary key
ASSET.emp.TerritoryDaily.PK_RouteArchive1CLUSTEREDYY0001never2026-09-27 05:20:29UNUSEDKEEP — primary key
ASSET.emp.CatalogSummary.IX_PricingSnapshot25NONCLUSTERED552001332026-10-02 14:33:572026-10-02 01:39:04USEDkeep — in use
ASSET.emp.CatalogSummary.IX_WarehouseSnapshot21NONCLUSTERED52990601332026-10-02 19:53:362026-10-02 01:39:04USEDkeep — in use
ASSET.emp.CatalogSummary.IX_ReconcileSummary23NONCLUSTERED84293001332026-10-02 18:27:422026-10-02 01:39:04USEDkeep — in use
ASSET.emp.CatalogSummary.IX_AssetEntry26NONCLUSTERED470407801332026-10-02 19:50:022026-10-02 01:39:04USEDkeep — in use
ASSET.emp.CatalogSummary.PK_ShipmentStaging1CLUSTEREDYY73055925741762591352026-10-03 00:00:002026-10-01 03:17:07USEDKEEP — primary key
ASSET.emp.CatalogSummary.UX_OrdersAudit14NONCLUSTEREDY1333501332026-10-02 18:27:412026-10-02 01:39:04USEDkeep — in use
ASSET.emp.CatalogSummary.UX_LedgerHistory15NONCLUSTEREDYY90844201352026-10-02 18:27:422026-10-02 01:39:04USEDkeep — in use
ASSET.emp.TicketMonthly.PK_LedgerAudit1CLUSTEREDYY16336012026-10-02 19:53:362026-09-27 05:20:30USEDKEEP — primary key
ASSET.emp.BillingQueue.IX_AssetDetail11NONCLUSTERED848701842026-10-02 18:57:552026-10-02 01:39:05USEDkeep — in use
ASSET.emp.BillingQueue.IX_ContractSummary8NONCLUSTERED395603001842026-10-02 19:52:382026-10-01 03:17:08USEDkeep — in use
ASSET.emp.BillingQueue.PK_ShipmentEntry1CLUSTEREDYY016443956031842026-10-02 19:52:382026-10-01 03:17:08USEDKEEP — primary key
ASSET.emp.CampaignResult.IX_SupplierLine14NONCLUSTERED193001302026-10-02 18:27:412026-10-02 01:39:05USEDkeep — in use
ASSET.emp.CampaignResult.PK_CustomerLine1CLUSTEREDYY01231931302026-10-02 18:27:412026-10-02 01:39:05USEDKEEP — primary key
ASSET.org.SettlementSnapshot.PK_org.SettlementSnapshot1CLUSTEREDYY012002026-10-02 14:24:122026-09-27 05:20:32USEDKEEP — primary key
ASSET.org.SettlementSnapshot.UX_BillingLine3NONCLUSTEREDY0000never2026-09-27 05:20:32UNUSEDreview carefully — unique
ASSET.org.PolicySummary.IX_AssetEntry11NONCLUSTERED474288820732026-10-02 19:52:382026-10-02 01:39:06USEDkeep — in use
ASSET.org.PolicySummary.PK_QuotaAudit1CLUSTEREDYY26079348832481291632026-10-02 19:53:362026-10-02 01:39:06USEDKEEP — primary key
ASSET.org.PolicySummary.UX_ForecastHistory4NONCLUSTEREDYY80060372026-10-02 19:50:022026-10-02 01:39:06USEDkeep — in use
ASSET.org.BatchMonthly.PK_WarehouseSummary1CLUSTEREDYY383570232026-10-02 14:33:572026-09-30 02:59:51USEDKEEP — primary key
ASSET.org.BatchMonthly.UX_SalesSnapshot2NONCLUSTEREDYY00020neverneverUNUSEDreview carefully — unique
ASSET.org.CampaignQueue.PK_RosterDaily1CLUSTEREDYY00091never2026-10-02 01:39:06UNUSEDKEEP — primary key
ASSET.org.TicketLog.PK_WarehouseDetail1CLUSTEREDYY55530532026-10-02 18:27:412026-09-27 05:20:33USEDKEEP — primary key
ASSET.org.TicketLog.UX_SalesMonthly4NONCLUSTEREDY00053never2026-10-01 03:17:10UNUSEDreview carefully — unique
ASSET.org.Company.PK_QuotaStaging1CLUSTEREDYY108476148206902026-10-03 00:04:422026-09-27 05:20:33USEDKEEP — primary key
ASSET.org.Company.UX_PricingResult7NONCLUSTEREDYY069002026-10-02 13:55:152026-09-27 05:20:33USEDkeep — in use
ASSET.org.ShipmentAudit.PK_ForecastHeader1CLUSTEREDYY04297385599502026-10-03 00:04:002026-09-27 05:20:33USEDKEEP — primary key
ASSET.org.ShipmentAudit.UX_BatchArchive2NONCLUSTEREDY85593661002026-10-03 00:04:002026-09-27 05:20:33USEDkeep — in use
ASSET.org.WarehouseStaging.PK_MeterHistory1CLUSTEREDYY0000never2026-09-27 05:20:33UNUSEDKEEP — primary key
ASSET.org.BookingResult.PK_BillingQueue1CLUSTEREDYY0000never2026-09-27 05:20:34UNUSEDKEEP — primary key
ASSET.org.InvoiceQueue.PK_TicketEntry1CLUSTEREDYY119002026-10-01 09:21:122026-09-27 05:20:34USEDKEEP — primary key
ASSET.org.PricingStatus.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-27 05:20:34UNUSEDKEEP — primary key
ASSET.org.CatalogHeader.PK_ShiftStatus1CLUSTEREDYY594002026-10-02 16:01:122026-09-27 05:20:34USEDKEEP — primary key
ASSET.org.PolicySummary.PK_CatalogQueue1CLUSTEREDYY0000never2026-09-27 05:20:34UNUSEDKEEP — primary key
ASSET.org.CatalogAudit.PK_AssetStatus1CLUSTEREDYY0000never2026-09-27 05:20:34UNUSEDKEEP — primary key
ASSET.org.OrdersSummary.PK_StaffingAudit1CLUSTEREDYY05002026-10-02 19:50:052026-09-27 05:20:34USEDKEEP — primary key
ASSET.org.ContractResult.PK_PolicyLine1CLUSTEREDYY0000never2026-09-27 05:20:34UNUSEDKEEP — primary key
ASSET.org.SupplierHistory.IX_ShipmentSummary2NONCLUSTERED0000never2026-09-27 05:20:34UNUSEDreview, then DROP
ASSET.org.SupplierHistory.PK_CustomerDetail1CLUSTEREDYY03002026-09-28 13:46:512026-09-27 05:20:34USEDKEEP — primary key
ASSET.org.ContractStaging.PK_CatalogDetail1CLUSTEREDYY0000never2026-09-27 05:20:34UNUSEDKEEP — primary key
ASSET.org.BatchSummary.PK_SettlementHistory1CLUSTEREDYY0000never2026-09-27 05:20:34UNUSEDKEEP — primary key
ASSET.org.BillingHeader.IX_ShiftHistory2NONCLUSTERED0000never2026-09-27 05:20:35UNUSEDreview, then DROP
ASSET.org.BillingHeader.PK_InvoiceMonthly1CLUSTEREDYY01002026-09-28 13:46:512026-09-27 05:20:35USEDKEEP — primary key
ASSET.org.ShipmentSummary.IX_StaffingResult2NONCLUSTERED0000never2026-09-27 05:20:35UNUSEDreview, then DROP
ASSET.org.ShipmentSummary.PK_ClaimDetail1CLUSTEREDYY01002026-09-28 13:46:512026-09-27 05:20:35USEDKEEP — primary key
ASSET.org.SalesStatus.IX_ClaimHeader2NONCLUSTEREDY10002026-09-28 13:46:512026-09-27 05:20:35USEDkeep — in use
ASSET.org.SalesStatus.PK_CampaignSnapshot1CLUSTEREDYY00102026-09-28 13:46:512026-09-27 05:20:35USEDKEEP — primary key
ASSET.org.PolicyResult.PK_ForecastStaging1CLUSTEREDYY31611324002026-10-02 18:56:102026-09-27 05:20:35USEDKEEP — primary key
ASSET.org.AssetSummary.PK_TicketStaging1CLUSTEREDYY15725002026-10-02 19:52:362026-09-27 05:20:35USEDKEEP — primary key
ASSET.org.AssetSummary.UX_ShipmentSummary4NONCLUSTEREDY0000never2026-09-27 05:20:35UNUSEDreview carefully — unique
ASSET.org.ShipmentQueue.PK_InvoiceStaging1CLUSTEREDYY636292716012026-10-02 19:52:392026-09-27 05:20:35USEDKEEP — primary key
ASSET.org.PolicyEntry.PK_SettlementSnapshot1CLUSTEREDYY332400132026-10-02 18:27:422026-09-30 02:59:51USEDKEEP — primary key
ASSET.org.PolicyEntry.UX_ShiftSnapshot5NONCLUSTEREDYY00013never2026-09-30 02:59:51UNUSEDreview carefully — unique
ASSET.org.MeterAudit.IX_WarehouseQueue3NONCLUSTERED15900132026-10-02 18:27:422026-09-30 02:59:52USEDkeep — in use
ASSET.org.MeterAudit.PK_BillingDetail1CLUSTEREDYY00013never2026-09-30 02:59:52UNUSEDKEEP — primary key
ASSET.org.BillingHeader.PK_ContractStaging1CLUSTEREDYY0000never2026-09-27 05:20:36UNUSEDKEEP — primary key
ASSET.org.TicketSnapshot.PK_ForecastSnapshot1CLUSTEREDYY0000never2026-09-27 05:20:36UNUSEDKEEP — primary key
ASSET.org.CustomerStaging.PK_CustomerHeader1CLUSTEREDYY00014never2026-09-30 02:59:52UNUSEDKEEP — primary key
ASSET.org.KPI.PK_ShiftLine1CLUSTEREDYY01012026-09-29 09:44:372026-09-27 05:20:36USEDKEEP — primary key
ASSET.org.KPI.UX_ShiftHeader4NONCLUSTEREDYY0001never2026-09-27 05:20:36UNUSEDreview carefully — unique
ASSET.org.StaffingArchive.PK_SettlementResult1CLUSTEREDYY011002026-09-29 10:52:382026-09-27 05:20:36USEDKEEP — primary key
ASSET.org.CustomerEntry.PK_RouteSummary1CLUSTEREDYY0000never2026-09-27 05:20:36UNUSEDKEEP — primary key
ASSET.org.PricingDaily.PK_CampaignArchive1CLUSTEREDYY0000never2026-09-27 05:20:36UNUSEDKEEP — primary key
ASSET.org.PricingDaily.UX_BillingArchive5NONCLUSTEREDY0000never2026-09-27 05:20:36UNUSEDreview carefully — unique
ASSET.org.TicketLine.PK_SupplierMonthly1CLUSTEREDYY0000never2026-09-27 05:20:37UNUSEDKEEP — primary key
ASSET.org.BillingArchive.PK_MeterSummary1CLUSTEREDYY0000never2026-09-27 05:20:37UNUSEDKEEP — primary key
ASSET.org.MeterEntry.PK_SupplierLog1CLUSTEREDYY0001never2026-09-27 05:20:37UNUSEDKEEP — primary key
ASSET.org.ReconcileAudit.PK_PolicyLog1CLUSTEREDYY1289637042026-10-02 19:46:552026-09-27 05:20:37USEDKEEP — primary key
ASSET.org.ReconcileAudit.UQ_ShipmentResult2NONCLUSTEREDYY60042026-10-02 14:30:232026-09-29 01:11:35USEDkeep — in use
ASSET.org.StaffingAudit.PK_RosterArchive1CLUSTEREDYY0006never2026-09-29 01:11:35UNUSEDKEEP — primary key
ASSET.org.ShiftResult.PK_AssetAudit1CLUSTEREDYY1556082328553092026-10-02 19:53:352026-09-27 05:20:37USEDKEEP — primary key
ASSET.org.BatchMonthly.PK_SalesLine1CLUSTEREDYY118700022026-10-02 15:51:072026-09-29 01:11:35USEDKEEP — primary key
ASSET.org.RosterMonthly.IX_AssetDetail2NONCLUSTERED0004never2026-09-29 01:11:35UNUSEDreview, then DROP
ASSET.org.RosterMonthly.PK_ForecastDaily1CLUSTEREDYY298042026-10-02 14:32:012026-09-29 01:11:35USEDKEEP — primary key
ASSET.org.InvoiceStaging.IX_AssetAudit2NONCLUSTERED0004never2026-09-29 01:11:35UNUSEDreview, then DROP
ASSET.org.InvoiceStaging.PK_CustomerMonthly1CLUSTEREDYY0004never2026-09-29 01:11:35UNUSEDKEEP — primary key
ASSET.org.StaffingAudit.PK_AssetLog1CLUSTEREDYY0006never2026-09-29 01:11:35UNUSEDKEEP — primary key
ASSET.org.Level.PK_ShiftStaging1CLUSTEREDYY473981300512026-10-02 16:00:402026-09-30 02:59:52USEDKEEP — primary key
ASSET.org.Level.UX_SettlementHistory2NONCLUSTEREDYY1300512026-09-29 09:47:162026-09-30 02:59:52USEDkeep — in use
ASSET.org.ContractHistory.PK_RouteArchive1CLUSTEREDYY00075never2026-09-30 02:59:52UNUSEDKEEP — primary key
ASSET.org.QuotaEntry.IX_AssetHistory2NONCLUSTERED0000never2026-09-27 05:20:38UNUSEDreview, then DROP
ASSET.org.QuotaEntry.PK_LedgerQueue1CLUSTEREDYY0283804002026-10-02 18:56:112026-09-27 05:20:38USEDKEEP — primary key
ASSET.org.ClaimQueue.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-27 05:20:38UNUSEDKEEP — primary key
ASSET.org.SupplierLine.PK_CatalogStaging1CLUSTEREDYY3630880002026-09-28 22:38:572026-09-27 05:20:39USEDKEEP — primary key
ASSET.org.InvoiceHistory.PK_BillingLog1CLUSTEREDYY0000never2026-09-27 05:20:39UNUSEDKEEP — primary key
ASSET.org.AssetHeader.IX_PayrollAudit2NONCLUSTERED3630880002026-09-28 22:38:572026-09-27 05:20:39USEDkeep — in use
ASSET.org.AssetHeader.PK_LedgerResult1CLUSTEREDYY0000never2026-09-27 05:20:39UNUSEDKEEP — primary key
ASSET.org.TerritoryStatus.PK_PayrollLine1CLUSTEREDYY0000never2026-09-27 05:20:39UNUSEDKEEP — primary key
ASSET.org.RosterLine.PK_LedgerStaging1CLUSTEREDYY0000never2026-09-27 05:20:39UNUSEDKEEP — primary key
ASSET.org.ForecastArchive.PK_PricingHistory1CLUSTEREDYY842817012026-10-01 15:50:362026-09-27 05:20:39USEDKEEP — primary key
ASSET.org.PolicySummary.PK_ForecastQueue1CLUSTEREDYY148149042026-10-01 13:45:032026-09-27 05:20:39USEDKEEP — primary key
ASSET.org.ClaimMonthly.PK_BookingDetail1CLUSTEREDYY0001never2026-09-27 05:20:39UNUSEDKEEP — primary key
ASSET.org.OrdersEntry.PK_MeterDaily1CLUSTEREDYY04472002026-09-28 22:13:552026-09-27 05:20:39USEDKEEP — primary key
ASSET.org.LedgerStaging.PK_BatchLine1CLUSTEREDYY0000never2026-09-27 05:20:39UNUSEDKEEP — primary key
ASSET.org.Position.PK_PolicySummary1CLUSTEREDYY1442788640252026-10-02 19:53:352026-09-30 02:59:52USEDKEEP — primary key
ASSET.org.Position.UX_MeterArchive5NONCLUSTEREDYY00025never2026-09-30 02:59:53UNUSEDreview carefully — unique
ASSET.org.CampaignQueue.PK_BillingArchive1CLUSTEREDYY258267195182026-10-02 19:53:352026-09-30 02:59:53USEDKEEP — primary key
ASSET.org.CampaignQueue.UX_TicketDaily2NONCLUSTEREDY47353230122026-10-02 18:27:412026-09-30 02:59:53USEDkeep — in use
ASSET.org.MeterResult.PK_CatalogStaging1CLUSTEREDYY00030never2026-09-30 02:59:53UNUSEDKEEP — primary key
ASSET.org.QuotaLine.PK_AssetAudit1CLUSTEREDYY253822026-09-29 10:53:332026-09-30 02:59:53USEDKEEP — primary key
ASSET.org.QuotaLine.UX_PricingAudit2NONCLUSTEREDYY038022026-09-29 10:53:332026-09-30 02:59:53USEDkeep — in use
ASSET.org.PayrollLog.PK_PayrollAudit1CLUSTEREDYY0000never2026-09-27 05:20:40UNUSEDKEEP — primary key
ASSET.org.PayrollLog.UX_PayrollDetail2NONCLUSTEREDY0000never2026-09-27 05:20:40UNUSEDreview carefully — unique
ASSET.org.LedgerDaily.PK_ContractHeader1CLUSTEREDYY00026never2026-09-30 02:59:53UNUSEDKEEP — primary key
ASSET.org.PricingArchive.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-27 05:20:41UNUSEDKEEP — primary key
ASSET.org.PricingArchive.UX_InvoiceAudit4NONCLUSTEREDY0000never2026-09-27 05:20:41UNUSEDreview carefully — unique
ASSET.org.ForecastAudit.PK_WarehouseSnapshot1CLUSTEREDYY068002026-10-02 18:26:382026-09-27 05:20:41USEDKEEP — primary key
ASSET.org.ForecastAudit.UX_ClaimArchive2NONCLUSTEREDY0000never2026-09-27 05:20:41UNUSEDreview carefully — unique
ASSET.org.PayrollLine.PK_OrdersHistory1CLUSTEREDYY3868002026-10-02 19:47:272026-09-27 05:20:41USEDKEEP — primary key
ASSET.org.PayrollLine.UX_ShiftLog2NONCLUSTEREDY0000never2026-09-27 05:20:41UNUSEDreview carefully — unique
ASSET.org.BookingStaging.PK_AssetResult1CLUSTEREDYY6978524581002026-10-02 19:52:392026-09-27 05:20:41USEDKEEP — primary key
ASSET.org.ReconcileLine.PK_CustomerLog1CLUSTEREDYY0000never2026-09-27 05:20:41UNUSEDKEEP — primary key
ASSET.org.ShiftStaging.PK_BillingHistory1CLUSTEREDYY02002026-09-29 10:09:222026-09-27 05:20:42USEDKEEP — primary key
ASSET.org.ShiftStaging.UQ_PolicyAudit2NONCLUSTEREDY0000never2026-09-27 05:20:42UNUSEDreview carefully — unique
ASSET.org.CustomerLine.IX_ForecastLine3NONCLUSTERED20002026-09-29 10:09:222026-09-27 05:20:42USEDkeep — in use
ASSET.org.CustomerLine.PK_LedgerEntry1CLUSTEREDYY0173002026-10-02 14:29:172026-09-27 05:20:42USEDKEEP — primary key
ASSET.org.CustomerLine.UQ_PayrollLog2NONCLUSTEREDY0000never2026-09-27 05:20:42UNUSEDreview carefully — unique
ASSET.org.InvoiceMonthly.PK_WarehouseQueue1CLUSTEREDYY0000never2026-09-27 05:20:42UNUSEDKEEP — primary key
ASSET.org.InvoiceMonthly.UQ_MeterAudit2NONCLUSTEREDY02002026-09-29 10:09:222026-09-27 05:20:42USEDkeep — in use
ASSET.org.QuotaStaging.PK_ShiftStaging1CLUSTEREDYY05502026-10-02 14:29:172026-09-27 05:20:42USEDKEEP — primary key
ASSET.org.QuotaStaging.UQ_ShiftMonthly2NONCLUSTEREDY50002026-10-02 14:29:172026-09-27 05:20:42USEDkeep — in use
ASSET.org.BatchMonthly.PK_WarehouseHeader1CLUSTEREDYY0173002026-10-02 14:29:172026-09-27 05:20:42USEDKEEP — primary key
ASSET.org.BatchMonthly.UQ_LedgerStaging2NONCLUSTEREDY0000never2026-09-27 05:20:42UNUSEDreview carefully — unique
ASSET.org.ClaimHeader.PK_ClaimArchive1CLUSTEREDYY0000never2026-09-27 05:20:42UNUSEDKEEP — primary key
ASSET.org.SupplierResult.PK_ForecastQueue1CLUSTEREDYY332778002026-10-02 19:53:352026-09-27 05:20:42USEDKEEP — primary key
ASSET.org.RouteSummary.PK_RosterAudit1CLUSTEREDYY0000never2026-09-27 05:20:42UNUSEDKEEP — primary key
ASSET.org.RouteSummary.UX_SupplierSummary2NONCLUSTEREDYY0000never2026-09-27 05:20:42UNUSEDreview carefully — unique
ASSET.org.ClaimDetail.PK_RouteMonthly1CLUSTEREDYY0000never2026-09-27 05:20:42UNUSEDKEEP — primary key
ASSET.org.ShiftResult.PK_ForecastEntry1CLUSTEREDYY2224923228854822026-10-02 19:52:382026-10-01 03:17:11USEDKEEP — primary key
ASSET.org.ShiftResult.UX_LedgerStaging7NONCLUSTEREDY322887004822026-10-02 19:52:382026-10-02 01:39:07USEDkeep — in use
ASSET.org.QuotaResult.PK_CampaignDaily1CLUSTEREDYY410366002026-10-02 19:53:352026-09-27 05:20:42USEDKEEP — primary key
ASSET.org.QuotaResult.UX_BatchDaily5NONCLUSTEREDY0000never2026-09-27 05:20:42UNUSEDreview carefully — unique
ASSET.org.QuotaDetail.PK_WarehouseMonthly1CLUSTEREDYY01293027002026-10-02 18:56:102026-09-27 05:20:43USEDKEEP — primary key
ASSET.org.BookingLog.PK_MeterStaging1CLUSTEREDYY0000never2026-09-27 05:20:43UNUSEDKEEP — primary key
ASSET.org.SettlementAudit.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-27 05:20:43UNUSEDKEEP — primary key
ASSET.oth.QuotaSummary.PK_QuotaDetail1CLUSTEREDYY01002026-09-29 16:13:392026-09-27 05:20:44USEDKEEP — primary key
ASSET.oth.InvoiceStatus.PK_ShiftQueue1CLUSTEREDYY214002026-10-03 00:00:002026-09-27 05:20:44USEDKEEP — primary key
ASSET.oth.SupplierLine.PK_QuotaDetail1CLUSTEREDYY0000never2026-09-27 05:20:44UNUSEDKEEP — primary key
ASSET.oth.SupplierLine.UX_InvoiceHeader2NONCLUSTEREDY0000never2026-09-27 05:20:44UNUSEDreview carefully — unique
ASSET.oth.StaffingArchive.IX_InvoiceStaging2NONCLUSTERED0000never2026-09-27 05:20:44UNUSEDreview, then DROP
ASSET.oth.StaffingArchive.PK_PricingAudit1CLUSTEREDYY0000never2026-09-27 05:20:44UNUSEDKEEP — primary key
ASSET.oth.StaffingArchive.UQ_SalesAudit3NONCLUSTEREDY63002026-10-01 13:07:012026-09-27 05:20:44USEDkeep — in use
ASSET.oth.CustomerQueue.IX_WarehouseResult2NONCLUSTERED61002026-09-29 16:13:392026-09-27 05:20:44USEDkeep — in use
ASSET.oth.CustomerQueue.PK_TerritoryResult1CLUSTEREDYY012002026-09-28 11:20:432026-09-27 05:20:44USEDKEEP — primary key
ASSET.rec.Candidate.PK_BookingArchive1CLUSTEREDYY0000never2026-09-27 05:20:44UNUSEDKEEP — primary key
ASSET.rec.Candidate.UX_CatalogLine2NONCLUSTEREDY0000never2026-09-27 05:20:44UNUSEDreview carefully — unique
ASSET.rec.AssetEntry.PK_BatchArchive1CLUSTEREDYY0000never2026-09-27 05:20:44UNUSEDKEEP — primary key
ASSET.rec.ShipmentDetail.PK_QuotaResult1CLUSTEREDYY0000never2026-09-27 05:20:44UNUSEDKEEP — primary key
ASSET.rec.ShipmentDetail.UX_SalesLog2NONCLUSTEREDY0000never2026-09-27 05:20:44UNUSEDreview carefully — unique
ASSET.rec.CustomerLine.PK_ShiftStaging1CLUSTEREDYY0000never2026-09-27 05:20:44UNUSEDKEEP — primary key
ASSET.rec.SettlementAudit.PK_PricingHeader1CLUSTEREDYY0000never2026-09-27 05:20:44UNUSEDKEEP — primary key
ASSET.rec.PricingResult.PK_AssetHistory1CLUSTEREDYY0000never2026-09-27 05:20:45UNUSEDKEEP — primary key
ASSET.rec.OrdersMonthly.PK_ContractStatus1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.rec.OrdersMonthly.UX_AssetSnapshot2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
ASSET.rec.RosterArchive.PK_ContractAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.rec.SalesQueue.PK_LedgerLog1CLUSTEREDYY0000never2026-09-27 05:20:45UNUSEDKEEP — primary key
ASSET.rec.MeterArchive.PK_ForecastResult1CLUSTEREDYY0000never2026-09-27 05:20:45UNUSEDKEEP — primary key
ASSET.rec.MeterArchive.UX_PayrollLine2NONCLUSTEREDY0000never2026-09-27 05:20:45UNUSEDreview carefully — unique
ASSET.rec.PayrollStatus.PK_ForecastMonthly1CLUSTEREDYY0000never2026-09-27 05:20:45UNUSEDKEEP — primary key
ASSET.rec.CampaignStatus.PK_InvoiceHistory1CLUSTEREDYY0000never2026-09-27 05:20:45UNUSEDKEEP — primary key
ASSET.rec.ReconcileStatus.PK_BatchDaily1CLUSTEREDYY0000never2026-09-27 05:20:45UNUSEDKEEP — primary key
ASSET.rec.ShipmentMonthly.PK_ContractEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.rec.ForecastSummary.PK_ReconcileLog1CLUSTEREDYY0000never2026-09-27 05:20:45UNUSEDKEEP — primary key
ASSET.rec.CustomerDetail.PK_SalesSnapshot1CLUSTEREDYY0000never2026-09-27 05:20:45UNUSEDKEEP — primary key
ASSET.rec.AssetSnapshot.PK_PolicyResult1CLUSTEREDYY010002026-10-02 14:33:452026-09-27 05:20:45USEDKEEP — primary key
ASSET.rec.AssetSnapshot.UX_ContractArchive2NONCLUSTEREDY0000never2026-09-27 05:20:45UNUSEDreview carefully — unique
ASSET.rec.CustomerQueue.PK_InvoiceLog1CLUSTEREDYY0000never2026-09-27 05:20:45UNUSEDKEEP — primary key
ASSET.rec.BatchSnapshot.PK_TicketLine1CLUSTEREDYY0000never2026-09-27 05:20:46UNUSEDKEEP — primary key
ASSET.rec.MeterStaging.IX_CampaignResult3NONCLUSTERED0001neverneverUNUSEDreview, then DROP
ASSET.rec.MeterStaging.IX_CustomerResult5NONCLUSTERED08012026-09-28 14:07:25neverUSEDkeep — in use
ASSET.rec.MeterStaging.IX_PricingStatus4NONCLUSTERED0001neverneverUNUSEDreview, then DROP
ASSET.rec.MeterStaging.PK_OrdersMonthly1CLUSTEREDYY45012026-10-02 13:04:26neverUSEDKEEP — primary key
ASSET.rec.MeterStaging.UX_WarehouseMonthly2NONCLUSTEREDY91012026-10-02 13:04:26neverUSEDkeep — in use
ASSET.rec.PolicyDetail.IX_PolicyDaily2NONCLUSTERED10012026-09-28 11:29:412026-10-02 13:04:26USEDkeep — in use
ASSET.rec.PolicyDetail.IX_OrdersArchive3NONCLUSTERED13012026-10-02 13:04:262026-10-02 13:04:26USEDkeep — in use
ASSET.rec.PolicyDetail.PK_ForecastMonthly1CLUSTEREDYY03222026-10-02 13:04:262026-10-02 13:04:26USEDKEEP — primary key
ASSET.rec.InvoiceEntry.IX_InvoiceEntry2NONCLUSTERED01012026-09-28 08:35:22neverUSEDkeep — in use
ASSET.rec.InvoiceEntry.IX_RouteStaging3NONCLUSTERED41012026-09-28 14:07:25neverUSEDkeep — in use
ASSET.rec.InvoiceEntry.PK_InvoiceAudit1CLUSTEREDYY05512026-09-28 14:38:00neverUSEDKEEP — primary key
ASSET.rec.TicketDetail.IX_SalesSnapshot4NONCLUSTERED01012026-09-28 13:44:43neverUSEDkeep — in use
ASSET.rec.TicketDetail.IX_ContractHeader2NONCLUSTERED0001never2026-10-02 13:04:26UNUSEDreview, then DROP
ASSET.rec.TicketDetail.IX_BookingEntry3NONCLUSTERED0001neverneverUNUSEDreview, then DROP
ASSET.rec.TicketDetail.PK_PolicyMonthly1CLUSTEREDYY01012026-10-02 13:04:26neverUSEDKEEP — primary key
ASSET.rec.BillingStaging.IX_BillingSnapshot2NONCLUSTERED0002neverneverUNUSEDreview, then DROP
ASSET.rec.BillingStaging.IX_ForecastLog3NONCLUSTERED0002neverneverUNUSEDreview, then DROP
ASSET.rec.BillingStaging.IX_ShipmentResult4NONCLUSTERED20022026-09-28 11:29:36neverUSEDkeep — in use
ASSET.rec.BillingStaging.PK_LedgerSummary1CLUSTEREDYY06222026-09-28 14:38:03neverUSEDKEEP — primary key
ASSET.rec.StaffingLine.PK_RosterSnapshot1CLUSTEREDYY01002026-09-26 14:41:052026-09-27 05:20:46USEDKEEP — primary key
ASSET.rec.LedgerStatus.PK_InvoiceDetail1CLUSTEREDYY0000never2026-09-27 05:20:46UNUSEDKEEP — primary key
ASSET.sal.SalesHistory.PK_QuotaLine1CLUSTEREDYY0000never2026-09-27 05:20:46UNUSEDKEEP — primary key
ASSET.sal.ClaimArchive.IX_RouteDetail2NONCLUSTERED0000never2026-09-27 05:20:46UNUSEDreview, then DROP
ASSET.sal.ClaimArchive.PK_LedgerHeader1CLUSTEREDYY0000never2026-09-27 05:20:46UNUSEDKEEP — primary key
ASSET.sal.QuotaLine.PK_ContractArchive1CLUSTEREDYY011031002026-10-03 00:04:002026-09-27 05:20:46USEDKEEP — primary key
ASSET.sal.SalesStatus.PK_ShiftMonthly1CLUSTEREDYY48119042026-10-02 23:27:052026-09-27 05:20:47USEDKEEP — primary key
ASSET.sal.SettlementQueue.PK_StaffingSnapshot1CLUSTEREDYY013908062026-10-02 23:27:052026-09-27 05:20:47USEDKEEP — primary key
ASSET.sal.MeterHistory.PK_LedgerSnapshot1CLUSTEREDYY0208062026-10-02 19:50:052026-09-27 05:20:47USEDKEEP — primary key
ASSET.sal.ShipmentAudit.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.sal.RouteResult.PK_OrdersAudit1CLUSTEREDYY010002026-10-02 19:53:352026-09-27 05:20:48USEDKEEP — primary key
ASSET.sal.RouteResult.UX_ContractEntry2NONCLUSTEREDY0000never2026-09-27 05:20:48UNUSEDreview carefully — unique
ASSET.sal.WarehouseDaily.PK_SettlementDetail1CLUSTEREDYY3321169612026-10-02 19:53:362026-09-27 05:20:48USEDKEEP — primary key
ASSET.sal.WarehouseDaily.UX_BookingAudit2NONCLUSTEREDY960012026-10-02 19:50:022026-09-27 05:20:48USEDkeep — in use
ASSET.sal.InvoiceLog.PK_MeterAudit1CLUSTEREDYY810082026-10-02 19:53:362026-09-27 05:20:48USEDKEEP — primary key
ASSET.sal.PolicySnapshot.PK_ReconcileQueue1CLUSTEREDYY0008never2026-09-27 05:20:48UNUSEDKEEP — primary key
ASSET.sal.SettlementStatus.PK_ReconcileResult1CLUSTEREDYY7212103722026-10-02 19:53:362026-09-27 05:20:48USEDKEEP — primary key
ASSET.sal.SettlementStatus.UX_StaffingMonthly2NONCLUSTEREDY10300722026-10-02 19:50:022026-09-27 05:20:49USEDkeep — in use
ASSET.sal.ReconcileHistory.PK_PayrollHeader1CLUSTEREDYY7100142026-10-02 19:53:362026-09-27 05:20:49USEDKEEP — primary key
ASSET.sal.ReconcileHistory.UX_TicketQueue2NONCLUSTEREDY00014never2026-09-27 05:20:49UNUSEDreview carefully — unique
ASSET.sal.InvoiceEntry.PK_RouteQueue1CLUSTEREDYY00014never2026-09-27 05:20:49UNUSEDKEEP — primary key
ASSET.sal.BillingQueue.PK_ReconcileHistory1CLUSTEREDYY00072never2026-09-27 05:20:49UNUSEDKEEP — primary key
ASSET.sal.RosterDetail.PK_BookingStaging1CLUSTEREDYY0001never2026-09-27 05:20:49UNUSEDKEEP — primary key
ASSET.sal.RosterQueue.PK_ShiftQueue1CLUSTEREDYY08002026-10-02 19:53:352026-09-27 05:20:49USEDKEEP — primary key
ASSET.sal.RosterQueue.UX_RosterArchive2NONCLUSTEREDY0000never2026-09-27 05:20:49UNUSEDreview carefully — unique
ASSET.sal.WarehouseHeader.PK_RouteEntry1CLUSTEREDYY029002026-10-02 00:05:012026-09-27 05:20:50USEDKEEP — primary key
ASSET.sal.SupplierArchive.PK_SupplierStaging1CLUSTEREDYY092002026-10-02 23:27:072026-09-27 05:20:50USEDKEEP — primary key
ASSET.sal.RosterQueue.PK_PolicyLog1CLUSTEREDYY0000never2026-09-27 05:20:50UNUSEDKEEP — primary key
ASSET.sal.CustomerSnapshot.PK_RosterEntry1CLUSTEREDYY092002026-10-02 23:27:072026-09-27 05:20:50USEDKEEP — primary key
ASSET.sal.LedgerStatus.PK_WarehouseStaging1CLUSTEREDYY0000never2026-09-27 05:20:50UNUSEDKEEP — primary key
ASSET.sal.BookingLine.PK_PricingAudit1CLUSTEREDYY0000never2026-09-27 05:20:50UNUSEDKEEP — primary key
ASSET.sal.PricingLine.PK_BatchLine1CLUSTEREDYY0000never2026-09-27 05:20:50UNUSEDKEEP — primary key
ASSET.sal.WarehouseStaging.PK_SettlementHistory1CLUSTEREDYY0000never2026-09-27 05:20:50UNUSEDKEEP — primary key
ASSET.sal.StaffingArchive.PK_CatalogLine1CLUSTEREDYY0000never2026-09-27 05:20:50UNUSEDKEEP — primary key
ASSET.sal.WarehouseSummary.PK_RosterArchive1CLUSTEREDYY0000never2026-09-27 05:20:50UNUSEDKEEP — primary key
ASSET.schedule.CustomerDetail.PK_CatalogStaging1CLUSTEREDYY07132201902026-10-02 18:56:102026-09-27 05:20:52USEDKEEP — primary key
ASSET.schedule.CustomerDetail.UQ_BillingSnapshot2NONCLUSTEREDY3219531002026-10-02 18:56:102026-09-27 05:20:52USEDkeep — in use
ASSET.schedule.CustomerDetail.UQ_CampaignResult3NONCLUSTEREDY32214335002026-10-02 18:56:102026-09-27 05:20:52USEDkeep — in use
ASSET.schedule.InvoiceHistory.IX_StaffingHeader3NONCLUSTERED0000never2026-09-27 05:20:52UNUSEDreview, then DROP
ASSET.schedule.InvoiceHistory.PK_ContractLog1CLUSTEREDYY0000never2026-09-27 05:20:52UNUSEDKEEP — primary key
ASSET.schedule.InvoiceHistory.UQ_LedgerResult2NONCLUSTEREDY0000never2026-09-27 05:20:52UNUSEDreview carefully — unique
ASSET.schedule.MeterStaging.PK_SettlementMonthly1CLUSTEREDYY56765300472026-10-02 18:56:112026-10-01 03:17:13USEDKEEP — primary key
ASSET.schedule.SettlementLine.PK_CampaignStatus1CLUSTEREDYY6441085601592026-10-02 18:56:102026-09-27 05:20:55USEDKEEP — primary key
ASSET.schedule.TicketEntry.PK_CampaignDaily1CLUSTEREDYY6322001592026-10-02 02:04:552026-09-27 05:20:55USEDKEEP — primary key
ASSET.schedule.QuotaSummary.PK_LedgerStatus1CLUSTEREDYY974024540402026-10-02 18:56:102026-10-01 03:17:13USEDKEEP — primary key
ASSET.schedule.ShipmentLog.PK_SalesEntry1CLUSTEREDYY32234300902026-10-02 18:56:102026-10-02 15:36:43USEDKEEP — primary key
ASSET.schedule.PricingResult.PK_CampaignDaily1CLUSTEREDYY3220061610532026-10-02 18:56:102026-09-27 05:20:55USEDKEEP — primary key
ASSET.schedule.SupplierSnapshot.IX_BillingHeader12NONCLUSTERED14240160014953642026-10-02 18:56:112026-10-02 02:02:24USEDkeep — in use
ASSET.schedule.SupplierSnapshot.PK_AssetStatus1CLUSTEREDYY232676492110197918176172026-10-02 18:56:112026-10-02 02:02:23USEDKEEP — primary key
ASSET.schedule.SupplierSnapshot.IX_ContractLog2NONCLUSTEREDY1106439532026-10-01 02:05:552026-10-02 02:02:23USEDkeep — in use
ASSET.schedule.BatchDetail.PK_AssetDetail1CLUSTEREDYY0000never2026-09-27 05:21:08UNUSEDKEEP — primary key
ASSET.schedule.RosterSummary.IX_BatchDetail3NONCLUSTERED2838440011352822026-10-02 18:56:102026-10-02 01:39:16USEDkeep — in use
ASSET.schedule.RosterSummary.IX_ClaimHeader2NONCLUSTERED1134831769011352822026-10-02 18:56:102026-10-02 01:39:16USEDkeep — in use
ASSET.schedule.RosterSummary.PK_CustomerAudit1CLUSTEREDYY25257076370529228381062026-10-02 18:56:112026-10-02 01:39:16USEDKEEP — primary key
ASSET.schedule.BillingDetail.IX_TicketHeader2NONCLUSTERED5512978153048247362026-10-02 18:56:112026-10-02 02:04:03USEDkeep — in use
ASSET.schedule.BillingDetail.PK_BillingLog1CLUSTEREDYY4098333870348341656761482026-10-02 18:56:112026-10-02 02:04:02USEDKEEP — primary key
ASSET.schedule.PolicyStatus.IX_ForecastAudit2NONCLUSTERED830753600107846202026-10-02 18:56:112026-10-02 13:27:21USEDkeep — in use
ASSET.schedule.PolicyStatus.IX_SupplierLine3NONCLUSTERED44114221520107846202026-10-02 18:56:112026-10-02 13:27:21USEDkeep — in use
ASSET.schedule.PolicyStatus.PK_PricingDaily1CLUSTEREDYY13751596311427008107846202026-10-02 18:56:112026-10-02 13:27:21USEDKEEP — primary key
ASSET.schedule.PolicyLine.IX_TerritorySnapshot2NONCLUSTERED9950675184014190862026-10-02 18:56:112026-10-02 01:39:22USEDkeep — in use
ASSET.schedule.PolicyLine.PK_BookingAudit1CLUSTEREDYY50907964230140822704982026-10-02 18:56:112026-10-02 01:39:22USEDKEEP — primary key
ASSET.schedule.AssetResult.IX_BillingResult2NONCLUSTERED605678006056782026-10-02 18:56:10neverUSEDkeep — in use
ASSET.schedule.AssetResult.PK_TicketQueue1CLUSTEREDYY000605678neverneverUNUSEDKEEP — primary key
ASSET.schedule.InvoiceAudit.IX_StaffingQueue2NONCLUSTERED1739371887042571262026-10-02 18:56:112026-10-02 01:39:22USEDkeep — in use
ASSET.schedule.InvoiceAudit.PK_LedgerMonthly1CLUSTEREDYY50267524635262542571262026-10-02 18:56:112026-10-02 01:39:22USEDKEEP — primary key
ASSET.schedule.SettlementLog.IX_TicketLine2NONCLUSTERED888758900119198362026-10-02 18:56:112026-10-02 02:05:01USEDkeep — in use
ASSET.schedule.SettlementLog.IX_PolicyLine3NONCLUSTERED1135218880119198362026-10-02 18:56:102026-10-02 02:05:01USEDkeep — in use
ASSET.schedule.SettlementLog.PK_CatalogMonthly1CLUSTEREDYY19209007022136226602026-10-02 18:56:112026-10-02 02:05:01USEDKEEP — primary key
ASSET.schedule.PricingSnapshot.IX_SettlementStatus15NONCLUSTERED0000never2026-09-27 05:24:45UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_InvoiceSummary3NONCLUSTERED0000never2026-09-27 05:24:45UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_WarehouseStaging4NONCLUSTERED0000never2026-09-27 05:24:45UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_WarehouseStatus2NONCLUSTERED0000never2026-09-27 05:24:45UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.PK_RosterEntry1CLUSTEREDYY0000never2026-09-27 05:24:44UNUSEDKEEP — primary key
ASSET.schedule.ShiftHeader.IX_TicketStatus3NONCLUSTERED2101012891052026-10-01 02:06:152026-10-02 02:02:35USEDkeep — in use
ASSET.schedule.ShiftHeader.IX_ShipmentLine4NONCLUSTERED41860072012891052026-10-02 18:56:112026-10-02 02:02:35USEDkeep — in use
ASSET.schedule.ShiftHeader.PK_OrdersArchive1CLUSTEREDYY6182186365128958422558642026-10-03 00:04:422026-10-02 02:02:35USEDKEEP — primary key
ASSET.schedule.ShiftHeader.IX_BookingStatus2NONCLUSTEREDY1104012891052026-10-02 13:26:482026-10-02 02:02:35USEDkeep — in use
ASSET.schedule.PolicyLine.PK_RouteQueue1CLUSTEREDYY26859922870286012891182026-10-03 00:04:422026-10-01 03:23:59USEDKEEP — primary key
ASSET.schedule.PolicyLine.UX_TerritoryHistory2NONCLUSTEREDYY000644612never2026-10-01 03:23:59UNUSEDreview carefully — unique
ASSET.schedule.SalesDaily.IX_ForecastHistory2NONCLUSTERED0000never2026-09-27 05:25:36UNUSEDreview, then DROP
ASSET.schedule.SalesDaily.IX_QuotaSummary3NONCLUSTERED0000never2026-09-27 05:25:36UNUSEDreview, then DROP
ASSET.schedule.SalesDaily.PK_ClaimResult1CLUSTEREDYY0000never2026-09-27 05:25:36UNUSEDKEEP — primary key
ASSET.schedule.RosterHistory.IX_AssetSummary2NONCLUSTERED339070321606445932026-10-03 00:04:422026-10-02 01:39:36USEDkeep — in use
ASSET.schedule.RosterHistory.PK_WarehouseLine1CLUSTEREDYY149547635976445932026-10-02 18:56:112026-10-02 01:39:36USEDKEEP — primary key
ASSET.schedule.ContractStaging.IX_StaffingLine2NONCLUSTERED0000never2026-09-27 05:25:36UNUSEDreview, then DROP
ASSET.schedule.ContractStaging.IX_ShiftSummary3NONCLUSTERED0000never2026-09-27 05:25:36UNUSEDreview, then DROP
ASSET.schedule.ContractStaging.PK_PolicyLine1CLUSTEREDYY0000never2026-09-27 05:25:36UNUSEDKEEP — primary key
ASSET.schedule.MeterStaging.IX_PayrollAudit2NONCLUSTERED498755233966906446012026-10-03 00:04:422026-10-01 03:24:00USEDkeep — in use
ASSET.schedule.MeterStaging.PK_PolicyArchive1CLUSTEREDYY936357095696446012026-10-02 18:56:102026-10-01 03:24:00USEDKEEP — primary key
ASSET.schedule.SupplierEntry.IX_InvoiceStaging2NONCLUSTERED0000never2026-09-27 05:25:37UNUSEDreview, then DROP
ASSET.schedule.SupplierEntry.IX_StaffingDaily3NONCLUSTERED0000never2026-09-27 05:25:37UNUSEDreview, then DROP
ASSET.schedule.SupplierEntry.PK_MeterQueue1CLUSTEREDYY0000never2026-09-27 05:25:37UNUSEDKEEP — primary key
ASSET.schedule.ForecastEntry.IX_ContractHistory2NONCLUSTERED7500222026-10-02 13:26:492026-10-02 01:39:36USEDkeep — in use
ASSET.schedule.ForecastEntry.IX_ForecastLine3NONCLUSTERED0230222026-10-01 09:20:372026-10-02 01:39:36USEDkeep — in use
ASSET.schedule.ForecastEntry.PK_MeterSummary1CLUSTEREDYY02898442026-10-02 14:20:452026-10-02 01:39:36USEDKEEP — primary key
ASSET.schedule.CustomerHistory.IX_LedgerQueue2NONCLUSTERED4511381499068113642026-10-02 19:52:392026-10-02 02:04:23USEDkeep — in use
ASSET.schedule.CustomerHistory.PK_PayrollAudit1CLUSTEREDYY109011413131370951682026-10-02 18:58:222026-10-02 02:04:23USEDKEEP — primary key
ASSET.schedule.QuotaDetail.IX_QuotaMonthly2NONCLUSTERED0007977never2026-10-02 01:39:47UNUSEDreview, then DROP
ASSET.schedule.QuotaDetail.IX_TicketSummary3NONCLUSTERED0007977never2026-10-02 01:39:47UNUSEDreview, then DROP
ASSET.schedule.QuotaDetail.PK_RosterHeader1CLUSTEREDYY03747079992026-10-02 13:27:202026-10-02 01:39:47USEDKEEP — primary key
ASSET.schedule.RosterResult.IX_BookingAudit2NONCLUSTERED044034057122026-09-29 02:02:362026-10-02 02:05:20USEDkeep — in use
ASSET.schedule.RosterResult.IX_AssetStaging3NONCLUSTERED1737861292034057122026-10-02 18:56:112026-10-02 02:05:20USEDkeep — in use
ASSET.schedule.RosterResult.PK_PricingSummary1CLUSTEREDYY905567820052641336895152026-10-03 00:04:422026-10-02 02:05:19USEDKEEP — primary key
ASSET.schedule.MeterSnapshot.IX_StaffingSummary2NONCLUSTERED374700169092026-10-02 13:27:202026-10-02 01:39:53USEDkeep — in use
ASSET.schedule.MeterSnapshot.IX_MeterLog3NONCLUSTERED00016909never2026-10-02 01:39:53UNUSEDreview, then DROP
ASSET.schedule.MeterSnapshot.PK_CampaignSnapshot1CLUSTEREDYY003747169312026-10-02 13:27:202026-10-02 01:39:53USEDKEEP — primary key
ASSET.schedule.LedgerSnapshot.PK_RouteStatus1CLUSTEREDYY2255897330128012026-10-02 18:56:102026-10-01 03:27:02USEDKEEP — primary key
ASSET.schedule.LedgerSnapshot.IX_TicketLine2NONCLUSTEREDY11012026-10-01 02:05:552026-10-01 03:27:02USEDkeep — in use
ASSET.schedule.RosterHistory.PK_MeterLine1CLUSTEREDYY193242050452026-10-02 18:56:102026-10-01 03:27:03USEDKEEP — primary key
ASSET.schedule.AssetStaging.PK_CampaignResult1CLUSTEREDYY966504100452026-10-02 18:56:102026-10-01 03:27:03USEDKEEP — primary key
ASSET.schedule.CampaignDaily.IX_BookingArchive2NONCLUSTERED11003341882026-09-28 08:37:112026-10-02 01:39:08USEDkeep — in use
ASSET.schedule.CampaignDaily.PK_PricingEntry1CLUSTEREDYY020113341882026-10-01 14:28:342026-10-02 01:39:08USEDKEEP — primary key
ASSET.schedule.BatchSnapshot.IX_ShiftQueue3NONCLUSTERED06675603588472026-10-03 00:04:372026-10-02 14:31:38USEDkeep — in use
ASSET.schedule.BatchSnapshot.PK_ShiftHistory1CLUSTEREDYY366064153743712152026-10-03 00:04:372026-10-02 14:31:38USEDKEEP — primary key
ASSET.schedule.BatchSnapshot.UX_StaffingEntry2NONCLUSTEREDY3825131858003588472026-10-02 18:56:112026-10-02 14:31:38USEDkeep — in use
ASSET.schedule.RouteLine.PK_MeterLine1CLUSTEREDYY0000never2026-09-27 05:20:54UNUSEDKEEP — primary key
ASSET.schedule.InvoiceLog.PK_CatalogSummary1CLUSTEREDYY2047945888296192026-10-02 19:52:392026-09-27 05:20:55USEDKEEP — primary key
ASSET.schedule.InvoiceLog.IX_WarehouseHeader2NONCLUSTEREDY31500192026-10-01 13:55:132026-10-02 01:39:09USEDkeep — in use
ASSET.schedule.ContractResult.PK_StaffingSummary1CLUSTEREDYY0466020192026-10-02 19:52:392026-09-27 05:20:55USEDKEEP — primary key
ASSET.schedule.ContractResult.UX_CampaignHistory2NONCLUSTEREDYY19968370192026-10-02 18:59:572026-09-27 05:20:55USEDkeep — in use
ASSET.schedule.BillingLog.PK_ContractResult1CLUSTEREDYY45565210610372026-10-02 19:52:392026-09-27 05:20:56USEDKEEP — primary key
ASSET.schedule.SalesArchive.IX_RosterStatus1CLUSTERED00018never2026-10-02 01:39:10UNUSEDKEEP — table storage
ASSET.schedule.CatalogHistory.PK_OrdersStatus1CLUSTEREDYY4545120002026-10-02 18:56:012026-09-27 05:20:56USEDKEEP — primary key
ASSET.schedule.CatalogHistory.IX_PricingStatus2NONCLUSTEREDY0000never2026-09-27 05:20:56UNUSEDreview carefully — unique
ASSET.schedule.engine.PK_ReconcileDaily1CLUSTEREDYY8261087792798102026-10-02 18:56:112026-09-27 05:26:53USEDKEEP — primary key
ASSET.schedule.engine.UQ_MeterQueue2NONCLUSTEREDY9279890002026-10-02 18:56:102026-09-27 05:26:53USEDkeep — in use
ASSET.schedule.TerritoryAudit.PK_PayrollSnapshot1CLUSTEREDYY009270946052362026-10-02 18:56:112026-10-02 01:39:54USEDKEEP — primary key
ASSET.schedule.TerritoryAudit.UX_BookingHeader2NONCLUSTEREDYY927094003218582026-10-02 18:56:112026-10-02 01:39:54USEDkeep — in use
ASSET.schedule.WarehouseArchive.IX_CustomerHistory2NONCLUSTERED000644600never2026-10-02 14:37:19UNUSEDreview, then DROP
ASSET.schedule.WarehouseArchive.IX_OrdersHeader3NONCLUSTERED322303006446002026-10-02 18:56:102026-10-02 14:37:19USEDkeep — in use
ASSET.schedule.WarehouseArchive.PK_RouteAudit1CLUSTEREDYY1005380322308010053802026-10-02 18:56:112026-10-02 13:27:20USEDKEEP — primary key
ASSET.schedule.LedgerMonthly.IX_CustomerMonthly3NONCLUSTERED32230310164297482026-10-02 18:56:10neverUSEDkeep — in use
ASSET.schedule.LedgerMonthly.PK_ClaimLine1CLUSTEREDYY2464462200246446222026-10-02 18:56:112026-10-02 15:03:01USEDKEEP — primary key
ASSET.schedule.RouteAudit.IX_InvoiceHeader2NONCLUSTERED2003223032026-09-26 08:46:372026-10-02 01:39:55USEDkeep — in use
ASSET.schedule.RouteAudit.IX_SettlementDetail16NONCLUSTEREDY000322300neverneverUNUSEDreview, then DROP
ASSET.schedule.RouteAudit.IX_CatalogArchive3NONCLUSTERED112441103223032026-10-03 00:04:422026-10-02 01:39:55USEDkeep — in use
ASSET.schedule.RouteAudit.IX_QuotaStaging4NONCLUSTERED0803223032026-10-01 14:28:352026-10-02 01:39:55USEDkeep — in use
ASSET.schedule.RouteAudit.PK_PayrollAudit1CLUSTEREDYY124112623223032026-10-03 00:04:422026-10-02 01:39:54USEDKEEP — primary key
ASSET.schedule.ShipmentHeader.PK_CampaignDetail1CLUSTEREDYY714455082151912026-10-02 06:48:362026-10-02 02:35:08USEDKEEP — primary key
ASSET.schedule.SupplierEntry.PK_AssetSnapshot1CLUSTEREDYY38046177002026-10-02 18:56:112026-09-27 05:27:11USEDKEEP — primary key
ASSET.schedule.TerritoryDetail.PK_ReconcileMonthly1CLUSTEREDYY820162026-10-02 15:44:442026-10-02 01:39:58USEDKEEP — primary key
ASSET.schedule.StaffingEntry.PK_QuotaDetail1CLUSTEREDYY448885262830222026-10-02 18:56:112026-10-02 01:39:58USEDKEEP — primary key
ASSET.schedule.StaffingEntry.UQ_TicketDetail2NONCLUSTEREDY811082026-10-02 15:44:442026-10-02 01:39:58USEDkeep — in use
ASSET.schedule.StaffingEntry.UX_PayrollDaily3NONCLUSTEREDYY7609205300142026-10-02 18:56:112026-10-02 01:39:58USEDkeep — in use
ASSET.schedule.ForecastMonthly.PK_ForecastHistory1CLUSTEREDYY448911354640897790802026-10-02 18:56:112026-10-02 03:48:38USEDKEEP — primary key
ASSET.schedule.CatalogEntry.PK_PolicyDetail1CLUSTEREDYY76092056502026-10-02 18:56:112026-09-27 05:27:33USEDKEEP — primary key
ASSET.schedule.CatalogEntry.UQ_AssetAudit2NONCLUSTEREDY50002026-10-02 14:16:012026-09-27 05:27:33USEDkeep — in use
ASSET.schedule.ContractAudit.PK_TicketSummary1CLUSTEREDYY448885042002026-10-02 18:56:112026-09-27 05:27:33USEDKEEP — primary key
ASSET.schedule.ContractAudit.UQ_OrdersStaging2NONCLUSTEREDY0000never2026-09-27 05:27:33UNUSEDreview carefully — unique
ASSET.schedule.ContractAudit.UX_BillingSnapshot3NONCLUSTEREDYY76091960002026-10-02 18:56:112026-09-27 05:27:33USEDkeep — in use
ASSET.schedule.SupplierSummary.PK_LedgerEntry1CLUSTEREDYY040002026-10-02 15:44:442026-09-27 05:27:33USEDKEEP — primary key
ASSET.schedule.SupplierSummary.UQ_BillingStaging2NONCLUSTEREDY0000never2026-09-27 05:27:33UNUSEDreview carefully — unique
ASSET.schedule.PayrollDaily.PK_CustomerQueue1CLUSTEREDYY6527457156002026-10-02 18:56:112026-09-27 05:27:33USEDKEEP — primary key
ASSET.schedule.WarehouseDaily.PK_QuotaAudit1CLUSTEREDYY818502026-10-02 15:44:442026-09-27 05:27:33USEDKEEP — primary key
ASSET.schedule.WarehouseDaily.UQ_ShiftEntry2NONCLUSTEREDY013002026-10-01 13:21:342026-09-27 05:27:34USEDkeep — in use
ASSET.schedule.WarehouseDaily.UX_TerritorySummary3NONCLUSTEREDYY220002026-10-02 15:44:442026-09-27 05:27:34USEDkeep — in use
ASSET.schedule.sql.IX_PayrollEntry3NONCLUSTEREDY7609204250172026-10-02 18:56:112026-09-27 05:27:34USEDkeep — in use
ASSET.schedule.sql.PK_ContractMonthly1CLUSTEREDYY634261172026-10-02 16:14:322026-09-27 05:27:34USEDKEEP — primary key
ASSET.schedule.sql.UQ_SalesStatus2NONCLUSTEREDY7826002026-10-02 15:44:442026-09-27 05:27:34USEDkeep — in use
ASSET.schedule.LedgerStatus.PK_SettlementQueue1CLUSTEREDYY0000never2026-09-27 05:27:34UNUSEDKEEP — primary key
ASSET.schedule.LedgerStatus.UQ_QuotaAudit2NONCLUSTEREDY0000never2026-09-27 05:27:34UNUSEDreview carefully — unique
ASSET.schedule.OrdersQueue.PK_QuotaQueue1CLUSTEREDYY820162026-10-02 15:44:442026-10-02 01:40:28USEDKEEP — primary key
ASSET.schedule.LedgerStaging.IX_StaffingLog4NONCLUSTERED7609313170532026-10-02 18:56:112026-10-02 01:40:28USEDkeep — in use
ASSET.schedule.LedgerStaging.PK_ContractQueue1CLUSTEREDYY44888608547609258532026-10-02 18:56:112026-10-02 01:40:28USEDKEEP — primary key
ASSET.schedule.LedgerStaging.UQ_TicketResult2NONCLUSTEREDY720172026-10-02 15:44:442026-10-02 01:40:28USEDkeep — in use
ASSET.schedule.LedgerStaging.UX_QuotaHeader3NONCLUSTEREDYY00034never2026-10-02 01:40:28UNUSEDreview carefully — unique
ASSET.schedule.InvoiceStatus.PK_AssetStaging1CLUSTEREDYY03022026-10-02 16:14:04neverUSEDKEEP — primary key
ASSET.schedule.step.PK_AssetStaging1CLUSTEREDYY793151011702026-10-02 18:56:112026-09-27 05:27:35USEDKEEP — primary key
ASSET.schedule.step.UQ_AssetQueue2NONCLUSTEREDY50002026-10-02 14:16:012026-09-27 05:27:35USEDkeep — in use
ASSET.schedule.step.UQ_OrdersLine5NONCLUSTEREDY71002026-10-02 15:24:152026-09-27 05:27:35USEDkeep — in use
ASSET.schedule.ShipmentResult.PK_MeterSnapshot1CLUSTEREDYY1540182026-10-02 16:14:262026-10-02 01:40:31USEDKEEP — primary key
ASSET.schedule.WarehouseEntry.PK_SettlementLine1CLUSTEREDYY448885227609223002026-10-02 18:56:112026-09-27 05:27:35USEDKEEP — primary key
ASSET.schedule.WarehouseEntry.UQ_ShiftSnapshot2NONCLUSTEREDY0000never2026-09-27 05:27:35UNUSEDreview carefully — unique
ASSET.schedule.WarehouseEntry.UX_OrdersLog3NONCLUSTEREDYY90002026-09-25 14:04:162026-09-27 05:27:35USEDkeep — in use
ASSET.wps.ContractStatus.IX_RosterDaily4NONCLUSTERED12300110922026-10-01 13:46:092026-09-30 03:16:17USEDkeep — in use
ASSET.wps.ContractStatus.PK_ClaimLog1CLUSTEREDYY3211019290110922026-10-03 00:04:002026-09-30 03:16:17USEDKEEP — primary key
ASSET.wps.ContractStatus.UX_TerritoryResult14NONCLUSTEREDYY00073never2026-09-30 03:16:17UNUSEDreview carefully — unique
ASSET.wps.ContractStatus.UX_SettlementDetail2NONCLUSTEREDY16700732026-09-29 16:16:332026-09-30 03:16:17USEDkeep — in use
ASSET.wps.PolicyResult.IX_ContractSnapshot2NONCLUSTERED33520682026-09-29 16:19:352026-09-30 03:16:17USEDkeep — in use
ASSET.wps.PolicyResult.PK_SettlementLine1CLUSTEREDYY151479332682026-09-29 18:44:122026-09-30 03:16:17USEDKEEP — primary key
ASSET.wps.LedgerMonthly.PK_LedgerMonthly1CLUSTEREDYY00080never2026-09-30 03:16:18UNUSEDKEEP — primary key
ASSET.wps.BookingStaging.PK_ClaimHistory1CLUSTEREDYY363710942026-09-29 18:44:122026-09-30 03:16:18USEDKEEP — primary key
ASSET.wps.SalesHeader.PK_ContractHistory1CLUSTEREDYY000111never2026-09-30 03:16:18UNUSEDKEEP — primary key
ASSET.wps.ForecastResult.PK_QuotaLog1CLUSTEREDYY82136115722812026-10-02 14:40:392026-10-01 03:27:08USEDKEEP — primary key
ASSET.wps.ForecastResult.UQ_ShipmentArchive5NONCLUSTEREDY119923302812026-10-03 00:00:002026-10-01 03:27:08USEDkeep — in use
ASSET.wps.StaffingResult.PK_RosterStatus1CLUSTEREDYY211421012026-10-03 00:04:002026-09-27 05:27:36USEDKEEP — primary key
ASSET.wps.StaffingStaging.PK_PolicyEntry1CLUSTEREDYY0001never2026-09-29 02:05:31UNUSEDKEEP — primary key
ASSET.wps.CustomerSnapshot.PK_WarehouseArchive1CLUSTEREDYY0000never2026-09-27 05:27:37UNUSEDKEEP — primary key
ASSET.wps.LedgerQueue.PK_BatchQueue1CLUSTEREDYY0000never2026-09-27 05:27:37UNUSEDKEEP — primary key
ASSET.wps.TerritoryQueue.IX_InvoiceAudit10NONCLUSTERED1132350752026-09-29 18:44:122026-09-30 03:16:18USEDkeep — in use
ASSET.wps.TerritoryQueue.PK_RosterSnapshot1CLUSTEREDYY49165489752026-10-02 14:40:392026-09-30 03:16:18USEDKEEP — primary key
ASSET.wps.TerritoryQueue.UX_MeterStaging2NONCLUSTEREDY267680682026-10-02 14:40:392026-09-30 03:16:18USEDkeep — in use
ASSET.wps.ContractEntry.PK_PayrollSummary1CLUSTEREDYY00088never2026-09-30 03:16:18UNUSEDKEEP — primary key
ASSET.wps.TicketStatus.PK_InvoiceMonthly1CLUSTEREDYY0446320042026-09-29 18:44:122026-09-29 02:05:31USEDKEEP — primary key
ASSET.wps.TicketStatus.UQ_OrdersQueue2NONCLUSTEREDY2000042026-09-29 16:19:102026-09-29 02:05:31USEDkeep — in use
ASSET.wps.SalesDetail.PK_SettlementLine1CLUSTEREDYY000281never2026-10-01 03:27:09UNUSEDKEEP — primary key
ASSET.wps.ClaimResult.PK_TicketEntry1CLUSTEREDYY235100002026-10-01 13:46:092026-09-27 05:27:37USEDKEEP — primary key
ASSET.wps.CatalogSnapshot.PK_ForecastHeader1CLUSTEREDYY0001never2026-09-29 02:05:32UNUSEDKEEP — primary key
ASSET.wps.BillingLine.PK_RosterResult1CLUSTEREDYY27213430062026-10-01 13:46:092026-09-27 05:27:38USEDKEEP — primary key
ASSET.wps.BillingLine.UX_WarehouseLog2NONCLUSTEREDYY60062026-09-26 15:51:392026-09-27 05:27:38USEDkeep — in use
ASSET.wps.BatchStatus.PK_ClaimLine1CLUSTEREDYY0140719712026-09-29 18:44:122026-09-27 05:27:38USEDKEEP — primary key
ASSET.wps.BatchStatus.UQ_CustomerHeader2NONCLUSTEREDY1970012026-09-29 16:19:122026-09-27 05:27:38USEDkeep — in use
ASSET.wps.BookingResult.PK_WarehouseMonthly1CLUSTEREDYY0001never2026-09-27 05:27:38UNUSEDKEEP — primary key
ASSET.wps.BookingStaging.PK_ForecastLog1CLUSTEREDYY011062026-09-25 09:17:582026-09-27 05:27:38USEDKEEP — primary key
CLAIM_Prod.bm.BOM.PK_MeterHistory1CLUSTEREDYY0000never2026-09-27 05:27:39UNUSEDKEEP — primary key
CLAIM_Prod.bm.CatalogQueue.PK_StaffingSummary1CLUSTEREDYY0000never2026-09-27 05:27:39UNUSEDKEEP — primary key
CLAIM_Prod.bm.ShiftEntry.PK_RouteStatus1CLUSTEREDYY0000never2026-09-27 05:27:39UNUSEDKEEP — primary key
CLAIM_Prod.bm.BillingArchive.PK_AssetMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.bm.ForecastDetail.PK_CatalogLog1CLUSTEREDYY0000never2026-09-27 05:27:39UNUSEDKEEP — primary key
CLAIM_Prod.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.dbo.StaffingEntry.PK_AssetStaging1CLUSTEREDYY0000never2026-09-27 05:27:39UNUSEDKEEP — primary key
CLAIM_Prod.dbo.QuotaLine.PK_ClaimSummary1CLUSTEREDYY0000never2026-09-27 05:27:39UNUSEDKEEP — primary key
CLAIM_Prod.dbo.QuotaLine.UX_ForecastSummary2NONCLUSTEREDY0000never2026-09-27 05:27:39UNUSEDreview carefully — unique
CLAIM_Prod.dbo.QuotaResult.PK_SettlementSummary1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.dbo.QuotaResult.IX_BillingLog2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
CLAIM_Prod.lib.Color.PK_ReconcileStaging1CLUSTEREDYY0000never2026-09-27 05:27:39UNUSEDKEEP — primary key
CLAIM_Prod.lib.SalesLine.PK_StaffingEntry1CLUSTEREDYY0000never2026-09-27 05:27:39UNUSEDKEEP — primary key
CLAIM_Prod.lib.SalesLine.UX_QuotaArchive2NONCLUSTEREDY0000never2026-09-27 05:27:39UNUSEDreview carefully — unique
CLAIM_Prod.lib.CustomerLog.PK_ClaimMonthly1CLUSTEREDYY0000never2026-09-27 05:27:39UNUSEDKEEP — primary key
CLAIM_Prod.lib.Item.PK_StaffingDetail1CLUSTEREDYY0000never2026-09-27 05:27:40UNUSEDKEEP — primary key
CLAIM_Prod.lib.Item.UX_CustomerEntry9NONCLUSTEREDY0000never2026-09-27 05:27:40UNUSEDreview carefully — unique
CLAIM_Prod.lib.CustomerArchive.PK_ForecastSummary1CLUSTEREDYY0000never2026-09-27 05:27:41UNUSEDKEEP — primary key
CLAIM_Prod.lib.SettlementHeader.PK_ShiftHeader1CLUSTEREDYY0000never2026-09-27 05:27:41UNUSEDKEEP — primary key
CLAIM_Prod.lib.SettlementHeader.UX_ForecastDaily2NONCLUSTEREDY0000never2026-09-27 05:27:41UNUSEDreview carefully — unique
CLAIM_Prod.lib.SupplierSummary.PK_BookingHeader1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.lib.LedgerSnapshot.PK_ClaimDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.lib.RouteDetail.PK_SalesStaging1CLUSTEREDYY0000never2026-09-27 05:27:41UNUSEDKEEP — primary key
CLAIM_Prod.lib.ReconcileEntry.PK_BatchLog1CLUSTEREDYY0000never2026-09-27 05:27:41UNUSEDKEEP — primary key
CLAIM_Prod.lib.RouteStatus.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-27 05:27:41UNUSEDKEEP — primary key
CLAIM_Prod.lib.InvoiceLine.PK_AssetArchive1CLUSTEREDYY0000never2026-09-27 05:27:41UNUSEDKEEP — primary key
CLAIM_Prod.lib.Size.PK_ClaimArchive1CLUSTEREDYY0000never2026-09-27 05:27:42UNUSEDKEEP — primary key
CLAIM_Prod.lib.StaffingQueue.PK_CampaignAudit1CLUSTEREDYY0000never2026-09-27 05:27:42UNUSEDKEEP — primary key
CLAIM_Prod.lib.MeterAudit.PK_TerritoryDaily1CLUSTEREDYY0000never2026-09-27 05:27:42UNUSEDKEEP — primary key
CLAIM_Prod.lib.RosterResult.PK_ShipmentEntry1CLUSTEREDYY0000never2026-09-27 05:27:42UNUSEDKEEP — primary key
CLAIM_Prod.lib.Unit.PK_ForecastLine1CLUSTEREDYY0000never2026-09-27 05:27:42UNUSEDKEEP — primary key
CLAIM_Prod.lib.MeterAudit.PK_ReconcileDaily1CLUSTEREDYY0000never2026-09-27 05:27:42UNUSEDKEEP — primary key
CLAIM_Prod.lib.ContractLog.PK_TerritoryLog1CLUSTEREDYY0000never2026-09-27 05:27:42UNUSEDKEEP — primary key
CLAIM_Prod.lib.CustomerLine.PK_QuotaArchive1CLUSTEREDYY0000never2026-09-27 05:27:43UNUSEDKEEP — primary key
CLAIM_Prod.sm.QuotaHistory.PK_BatchLine1CLUSTEREDYY0000never2026-09-27 05:27:43UNUSEDKEEP — primary key
CLAIM_Prod.sm.InvoiceStaging.PK_QuotaDaily1CLUSTEREDYY0000never2026-09-27 05:27:43UNUSEDKEEP — primary key
CLAIM_Prod.sm.PricingStatus.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-27 05:27:43UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryArchive.PK_TerritoryLine1CLUSTEREDYY0000never2026-09-27 05:27:43UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryArchive.UX_PayrollResult4NONCLUSTEREDY0000never2026-09-27 05:27:43UNUSEDreview carefully — unique
CLAIM_Prod.sm.BookingResult.PK_RosterStaging1CLUSTEREDYY0000never2026-09-27 05:27:43UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryMonthly.PK_BookingAudit1CLUSTEREDYY0000never2026-09-27 05:27:43UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryMonthly.UX_StaffingResult2NONCLUSTEREDY0000never2026-09-27 05:27:43UNUSEDreview carefully — unique
CLAIM_Prod.sm.QuotaDaily.PK_BookingDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.sm.QuotaDaily.UX_QuotaQueue2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
CLAIM_Prod.sm.CatalogResult.PK_SalesStatus1CLUSTEREDYY0000never2026-09-27 05:27:43UNUSEDKEEP — primary key
CLAIM_Prod.sm.BatchAudit.PK_ReconcileHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.sm.ShiftDaily.PK_ClaimHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.sm.OrdersMonthly.PK_PolicyHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.sm.InvoiceLine.PK_PayrollDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.sm.BillingEntry.PK_SettlementArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.sm.ShipmentDaily.PK_CatalogDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.sm.ShipmentDaily.UX_TicketMonthly2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
CLAIM_Prod.sm.PolicyHeader.PK_CustomerSummary1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.sm.PolicyHeader.UX_LedgerDetail2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
CLAIM_Prod.sm.RouteDetail.PK_SalesDetail1CLUSTEREDYY0000never2026-09-27 05:27:44UNUSEDKEEP — primary key
CLAIM_Prod.sm.QuotaStatus.PK_ShiftDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.sm.ContractAudit.PK_ReconcileArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.sm.BookingHeader.PK_ShipmentArchive1CLUSTEREDYY0000never2026-09-27 05:27:44UNUSEDKEEP — primary key
CONTRACT.bm.BOM.PK_MeterHistory1CLUSTEREDYY0000never2026-09-27 05:27:45UNUSEDKEEP — primary key
CONTRACT.bm.CatalogQueue.PK_StaffingSummary1CLUSTEREDYY0000never2026-09-27 05:27:45UNUSEDKEEP — primary key
CONTRACT.bm.ShiftEntry.PK_RouteStatus1CLUSTEREDYY0000never2026-09-27 05:27:45UNUSEDKEEP — primary key
CONTRACT.bm.BillingArchive.PK_AssetMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.bm.ForecastDetail.PK_CatalogLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.dbo.StaffingEntry.PK_AssetStaging1CLUSTEREDYY0000never2026-09-27 05:27:45UNUSEDKEEP — primary key
CONTRACT.dbo.QuotaLine.PK_ClaimSummary1CLUSTEREDYY0000never2026-09-27 05:27:45UNUSEDKEEP — primary key
CONTRACT.dbo.QuotaLine.UX_ForecastSummary2NONCLUSTEREDY0000never2026-09-27 05:27:45UNUSEDreview carefully — unique
CONTRACT.dbo.QuotaResult.PK_SettlementSummary1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.dbo.QuotaResult.IX_BillingLog2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
CONTRACT.lib.Color.PK_ReconcileStaging1CLUSTEREDYY0000never2026-09-27 05:27:46UNUSEDKEEP — primary key
CONTRACT.lib.SalesLine.PK_StaffingEntry1CLUSTEREDYY0000never2026-09-27 05:27:46UNUSEDKEEP — primary key
CONTRACT.lib.SalesLine.UX_QuotaArchive2NONCLUSTEREDY0000never2026-09-27 05:27:46UNUSEDreview carefully — unique
CONTRACT.lib.CustomerLog.PK_ClaimMonthly1CLUSTEREDYY0000never2026-09-27 05:27:46UNUSEDKEEP — primary key
CONTRACT.lib.Item.PK_StaffingDetail1CLUSTEREDYY0000never2026-09-27 05:27:46UNUSEDKEEP — primary key
CONTRACT.lib.Item.UX_CustomerEntry9NONCLUSTEREDY0000never2026-09-27 05:27:46UNUSEDreview carefully — unique
CONTRACT.lib.CustomerArchive.PK_ForecastSummary1CLUSTEREDYY0000never2026-09-27 05:27:47UNUSEDKEEP — primary key
CONTRACT.lib.SettlementHeader.PK_ShiftHeader1CLUSTEREDYY0000never2026-09-27 05:27:47UNUSEDKEEP — primary key
CONTRACT.lib.SettlementHeader.UX_ForecastDaily2NONCLUSTEREDY0000never2026-09-27 05:27:47UNUSEDreview carefully — unique
CONTRACT.lib.SupplierSummary.PK_BookingHeader1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.lib.LedgerSnapshot.PK_ClaimDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.lib.RouteDetail.PK_SalesStaging1CLUSTEREDYY0000never2026-09-27 05:27:47UNUSEDKEEP — primary key
CONTRACT.lib.ReconcileEntry.PK_BatchLog1CLUSTEREDYY0000never2026-09-27 05:27:47UNUSEDKEEP — primary key
CONTRACT.lib.RouteStatus.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-27 05:27:48UNUSEDKEEP — primary key
CONTRACT.lib.InvoiceLine.PK_AssetArchive1CLUSTEREDYY0000never2026-09-27 05:27:48UNUSEDKEEP — primary key
CONTRACT.lib.Size.PK_ClaimArchive1CLUSTEREDYY0000never2026-09-27 05:27:48UNUSEDKEEP — primary key
CONTRACT.lib.StaffingQueue.PK_CampaignAudit1CLUSTEREDYY0000never2026-09-27 05:27:48UNUSEDKEEP — primary key
CONTRACT.lib.MeterAudit.PK_TerritoryDaily1CLUSTEREDYY0000never2026-09-27 05:27:48UNUSEDKEEP — primary key
CONTRACT.lib.RosterResult.PK_ShipmentEntry1CLUSTEREDYY0000never2026-09-27 05:27:48UNUSEDKEEP — primary key
CONTRACT.lib.Unit.PK_ForecastLine1CLUSTEREDYY0000never2026-09-27 05:27:48UNUSEDKEEP — primary key
CONTRACT.lib.MeterAudit.PK_ReconcileDaily1CLUSTEREDYY0000never2026-09-27 05:27:48UNUSEDKEEP — primary key
CONTRACT.lib.ContractLog.PK_TerritoryLog1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.lib.CustomerLine.PK_QuotaArchive1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.QuotaHistory.PK_BatchLine1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.InvoiceStaging.PK_QuotaDaily1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.PricingStatus.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryArchive.PK_TerritoryLine1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryArchive.UX_PayrollResult4NONCLUSTEREDY0000never2026-09-27 05:27:49UNUSEDreview carefully — unique
CONTRACT.sm.BookingResult.PK_RosterStaging1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryMonthly.PK_BookingAudit1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryMonthly.UX_StaffingResult2NONCLUSTEREDY0000never2026-09-27 05:27:49UNUSEDreview carefully — unique
CONTRACT.sm.QuotaDaily.PK_BookingDetail1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.QuotaDaily.UX_QuotaQueue2NONCLUSTEREDY0000never2026-09-27 05:27:49UNUSEDreview carefully — unique
CONTRACT.sm.CatalogResult.PK_SalesStatus1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.BatchAudit.PK_ReconcileHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.ShiftDaily.PK_ClaimHistory1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.OrdersMonthly.PK_PolicyHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.InvoiceLine.PK_PayrollDetail1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.BillingEntry.PK_SettlementArchive1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.ShipmentDaily.PK_CatalogDetail1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.ShipmentDaily.UX_TicketMonthly2NONCLUSTEREDY0000never2026-09-27 05:27:49UNUSEDreview carefully — unique
CONTRACT.sm.PolicyHeader.PK_CustomerSummary1CLUSTEREDYY0000never2026-09-27 05:27:49UNUSEDKEEP — primary key
CONTRACT.sm.PolicyHeader.UX_LedgerDetail2NONCLUSTEREDY0000never2026-09-27 05:27:50UNUSEDreview carefully — unique
CONTRACT.sm.RouteDetail.PK_SalesDetail1CLUSTEREDYY0000never2026-09-27 05:27:50UNUSEDKEEP — primary key
CONTRACT.sm.QuotaStatus.PK_ShiftDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.ContractAudit.PK_ReconcileArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.BookingHeader.PK_ShipmentArchive1CLUSTEREDYY0000never2026-09-27 05:27:50UNUSEDKEEP — primary key