Index Usage — ACME-198-51-100-66
DBA BrainIndex UsageACME-198-51-100-66snapshot 2026-09-16 01:01:12 +07Fleet inventoryServer metricsSLAIndex usage
Index reportsACME-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-155

Index Usage Report — ACME-198-51-100-66

Host: 198.51.100.66

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

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

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

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

MetricCountMeaning
indexes_total677every index on a CatalogHistory table
used376had a seek, scan or lookup
unused195written but never read
cold106never read AND never written since restart
disabled0ALTER INDEX ... DISABLE was run
droppable53nonclustered, not unique, no constraint, never read
fragmented26above the rebuild threshold

By database

DatabaseTotalColdDisabledDroppableRecommend action
host_72657769026review the drop candidates above
ASSET_Prod5527026review the drop candidates above
host-87724401review the drop candidates above
host-87121600no action — cold indexes here are constraints or clustered

Drop candidates (53)

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.LedgerMonthly.IX_CatalogDaily41529357neverUNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_QuotaSnapshot20764686neverUNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_InvoiceSummary20764686neverUNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_CampaignHistory20764686neverUNUSEDreview, then DROP
host_726.emp.SettlementQueue.IX_PolicyAudit22987neverUNUSEDreview, then DROP
host_726.emp.SupplierStaging.IX_StaffingEntry12680neverUNUSEDreview, then DROP
host_726.emp.SalesHeader.IX_BookingSummary2064neverUNUSEDreview, then DROP
host_726.emp.OrdersMonthly.IX_PayrollResult973neverUNUSEDreview, then DROP
ASSET_Prod.dbo.BookingEntry.IX_ShipmentStatus370neverUNUSEDreview, then DROP
ASSET_Prod.dbo.CampaignHeader.IX_SupplierResult308neverUNUSEDreview, then DROP
ASSET_Prod.dbo.PricingHeader.IX_QuotaAudit130neverUNUSEDreview, then DROP
ASSET_Prod.dbo.PricingHeader.IX_StaffingHeader130neverUNUSEDreview, then DROP
host_726.emp.OrdersMonthly.IX_QuotaArchive83neverUNUSEDreview, then DROP
host_726.org.RosterMonthly.IX_AssetDetail12neverUNUSEDreview, then DROP
host_726.org.InvoiceStaging.IX_AssetAudit12neverUNUSEDreview, then DROP
host-877.app.WarehouseStatus.IX_BookingEntry7neverUNUSEDreview, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_ForecastDetail2neverUNUSEDreview, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_QuotaSummary2neverUNUSEDreview, then DROP
ASSET_Prod.dbo.DOB.IX_CustomerSummary0neverCOLDreview, then DROP
ASSET_Prod.dbo.ContractStaging.IX_InvoiceLog0neverCOLDreview, then DROP
ASSET_Prod.dbo.ShipmentLog.IX_ReconcileStatus0neverCOLDreview, then DROP
ASSET_Prod.dbo.BookingSnapshot.IX_ClaimStaging0neverCOLDreview, then DROP
ASSET_Prod.dbo.RosterStaging.IX_BatchArchive0neverCOLDreview, then DROP
ASSET_Prod.dbo.BatchLog.IX_TerritoryArchive0neverCOLDreview, then DROP
ASSET_Prod.dbo.BatchLog.IX_LedgerHistory0neverCOLDreview, then DROP
ASSET_Prod.dbo.ForecastDetail.IX_CampaignStatus0neverCOLDreview, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_ClaimHistory0neverCOLDreview, then DROP
ASSET_Prod.dbo.RosterHeader.IX_ShipmentLog0neverCOLDreview, then DROP
ASSET_Prod.dbo.RosterDaily.IX_ShiftHeader0neverCOLDreview, then DROP
ASSET_Prod.dbo.BookingSnapshot.IX_RouteLine0neverCOLDreview, then DROP
ASSET_Prod.dbo.AssetEntry.IX_TerritoryDetail0neverCOLDreview, then DROP
ASSET_Prod.dbo.RouteArchive.IX_ShiftDaily0neverCOLDreview, then DROP
ASSET_Prod.dbo.RouteSnapshot.IX_ContractHeader0neverCOLDreview, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_StaffingLine0neverCOLDreview, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_ShiftDaily0neverCOLDreview, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_CatalogLog0neverCOLDreview, then DROP
ASSET_Prod.dbo.RosterSummary.IX_ForecastSnapshot0neverCOLDreview, then DROP
ASSET_Prod.dbo.SalesSnapshot.IX_TicketResult0neverCOLDreview, then DROP
host_726.dbo.BatchResult.IX_SettlementStaging0neverCOLDreview, then DROP
host_726.wps.PolicyResult.IX_ContractSnapshot0neverUNUSEDreview, then DROP
host_726.emp.StaffingMonthly.IX_ReconcileEntry0neverUNUSEDreview, then DROP
host_726.dbo.CustomerArchive.IX_BillingHeader0neverUNUSEDreview, then DROP
host_726.dbo.BatchResult.IX_ReconcileEntry0neverUNUSEDreview, then DROP
host_726.guest.TerritoryQueue.IX_InvoiceStaging0neverUNUSEDreview, 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.QuotaEntry.IX_AssetHistory0neverUNUSEDreview, 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.dbo.SalesLine.IX_ReconcileResult0neverCOLDreview, then DROP

Fragmented (26) — 26 partitions across 20 indexes

Total 10,285.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.RosterResult.PK_PricingSummary#p66/21CLUSTERED97.8%1,1358.92026-09-15 22:53:32REBUILD
host_726\schedule.PolicyStatus.PK_PricingDaily#p66/21CLUSTERED97.8%1,2639.92026-09-15 22:54:06REBUILD
host_726\schedule.PolicyStatus.PK_PricingDaily#p55/21CLUSTERED96.9%1,2449.72026-09-15 22:54:06REBUILD
host_726\schedule.RouteAudit.IX_InvoiceHeader1/1NONCLUSTERED96.3%87,146680.82026-09-15 14:01:40REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p66/21CLUSTERED95.8%1,0228.02026-09-15 22:54:11REBUILD
host_726\schedule.RosterResult.PK_PricingSummary#p55/21CLUSTERED95.0%1,1629.12026-09-15 22:53:32REBUILD
host_726\schedule.PolicyStatus.PK_PricingDaily#p44/21CLUSTERED94.3%1,1328.82026-09-15 22:54:06REBUILD
host_726\schedule.BillingDetail.PK_BillingLog#p55/21CLUSTERED93.9%1,1408.92026-09-15 22:54:11REBUILD
host_726\schedule.ShipmentHeader.IX_QuotaSnapshot1/1NONCLUSTERED93.6%144,8341131.52026-09-15 02:15:24REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p44/21CLUSTERED72.6%1,1048.62026-09-15 22:54:00REBUILD
host_726\emp.CampaignResult.IX_ClaimStatus1/1NONCLUSTERED68.2%33,214259.52026-09-15 02:02:19REBUILD
host_726\emp.TicketSnapshot.IX_BookingHistory1/1NONCLUSTERED63.7%11,27688.12026-09-15 02:01:26REBUILD
host_726\emp.BillingAudit.IX_PolicyHeader1/1NONCLUSTERED61.8%7,78160.82026-09-15 19:45:39REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p55/21CLUSTERED60.3%1,35410.62026-09-15 22:54:00REBUILD
host_726\schedule.SettlementLog.PK_CatalogMonthly#p66/21CLUSTERED58.8%1,73113.52026-09-15 22:54:00REORGANIZE
host_726\schedule.ShipmentHeader.IX_InvoiceSummary1/1NONCLUSTERED55.7%168,4381315.92026-09-15 02:17:48REORGANIZE
host_726\schedule.PolicyLine.UX_TerritoryHistory#p99/21NONCLUSTERED50.4%2,14516.82026-09-15 22:55:43REORGANIZE
host_726\schedule.ForecastMonthly.IX_WarehouseDaily1/1NONCLUSTERED49.8%794,0366203.42026-09-15 02:30:54REORGANIZE
host_726\emp.SupplierStaging.IX_StaffingSnapshot1/1NONCLUSTERED46.2%3,26425.52026-09-15 02:00:57REORGANIZE
host_726\schedule.MeterStaging.PK_PolicyArchive#p99/21CLUSTERED45.1%1,78313.92026-09-15 22:54:00REORGANIZE
host_726\schedule.PolicyLine.PK_RouteQueue#p99/21CLUSTERED41.5%3,50227.42026-09-15 22:54:07REORGANIZE
host_726\schedule.TerritoryAudit.UX_BookingHeader1/1NONCLUSTERED36.3%2,29517.92026-09-15 20:27:43REORGANIZE
host_726\schedule.RosterResult.IX_AssetStaging#p99/21NONCLUSTERED35.6%14,685114.72026-09-15 22:53:54REORGANIZE
host_726\emp.SupplierStaging.IX_CampaignResult1/1NONCLUSTERED34.8%2,43119.02026-09-15 02:00:54REORGANIZE
host_726\schedule.CustomerHistory.PK_PayrollAudit#p99/21CLUSTERED34.7%24,535191.72026-09-15 22:55:11REORGANIZE
host_726\schedule.InvoiceAudit.PK_LedgerMonthly#p99/21CLUSTERED30.8%2,95023.02026-09-15 22:53:01REORGANIZE

All indexes (677)

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.ShiftAudit.PK_SettlementResult1CLUSTEREDYY332995810527391938432026-09-16 01:00:432026-09-15 02:00:01USEDKEEP — primary key
host-877.app.ShiftAudit.UX_PayrollAudit2NONCLUSTEREDY13714182208432026-09-16 01:00:322026-09-15 02:00:01USEDkeep — in use
host-877.app.ShiftAudit.UX_ContractSummary7NONCLUSTEREDYY0000never2026-09-15 02:00:01UNUSEDreview carefully — unique
host-877.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-877.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY000701never2026-09-15 02:00:01UNUSEDKEEP — primary key
host-877.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY00064767never2026-09-15 02:00:01UNUSEDKEEP — primary key
host-877.app.ForecastMonthly.IX_StaffingStatus1CLUSTERED000518never2026-09-15 02:00:01UNUSEDKEEP — table storage
host-877.app.App.PK_InvoiceResult1CLUSTEREDYY094107002026-09-16 01:00:432026-09-13 02:00:01USEDKEEP — primary key
host-877.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-877.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY263649210530112026-09-16 01:00:432026-09-15 02:00:01USEDKEEP — primary key
host-877.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY00010never2026-09-15 02:00:01UNUSEDKEEP — primary key
host-877.app.Group.PK_BookingEntry1CLUSTEREDYY138782158072026-09-16 01:00:432026-09-15 02:00:01USEDKEEP — primary key
host-877.app.Group.UX_LedgerSummary2NONCLUSTEREDY0007never2026-09-15 02:00:01UNUSEDreview carefully — unique
host-877.app.PricingLog.PK_AssetResult1CLUSTEREDYY1878600322026-09-16 00:13:312026-09-15 02:00:01USEDKEEP — primary key
host-877.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY06702002026-09-15 23:22:36neverUSEDKEEP — primary key
host-877.app.WarehouseStatus.IX_BookingEntry9NONCLUSTERED0007never2026-09-15 02:00:01UNUSEDreview, then DROP
host-877.app.WarehouseStatus.UX_QuotaLine2NONCLUSTEREDY697630342072026-09-15 23:22:432026-09-15 02:00:01USEDkeep — in use
host-877.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY222264001992026-09-16 01:00:432026-09-15 02:00:01USEDKEEP — primary key
host-877.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY000146never2026-09-15 02:00:01UNUSEDKEEP — primary key
host-877.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY137121750546062026-09-16 01:00:322026-09-13 02:00:01USEDKEEP — primary key
host-877.app.CatalogMonthly.PK_ClaimHeader1CLUSTEREDYY124929194471032026-09-16 01:00:432026-09-13 02:00:01USEDKEEP — primary key
host-877.app.CatalogMonthly.UX_RouteQueue2NONCLUSTEREDY68050022026-09-15 23:22:362026-09-13 02:00:01USEDkeep — in use
host-877.app.ClaimResult.PK_ShipmentStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-877.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-871.app.ShiftAudit.PK_SettlementResult1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.ShiftAudit.UX_PayrollAudit2NONCLUSTEREDY0000never2026-09-13 02:36:11UNUSEDreview carefully — unique
host-871.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-871.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-871.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.App.PK_InvoiceResult1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-871.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.Group.PK_BookingEntry1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.Group.UX_LedgerSummary2NONCLUSTEREDY0000never2026-09-13 02:36:11UNUSEDreview carefully — unique
host-871.app.PricingLog.PK_AssetResult1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-871.app.WarehouseStatus.UX_QuotaLine2NONCLUSTEREDY0000never2026-09-13 02:36:11UNUSEDreview carefully — unique
host-871.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.CatalogMonthly.PK_ClaimHeader1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host-871.app.CatalogMonthly.UX_RouteQueue2NONCLUSTEREDY0000never2026-09-13 02:36:11UNUSEDreview carefully — unique
host-871.app.ClaimResult.PK_ShipmentStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-871.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-13 02:00:03UNUSEDKEEP — primary key
host_726.cfg.QuotaStatus.UX_MeterSummary2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.ContractResult.PK_CampaignResult1CLUSTEREDYY01047010462026-09-16 00:36:122026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.SettlementStaging.PK_TicketStaging1CLUSTEREDYY0001046never2026-09-15 02:00:03UNUSEDKEEP — primary key
host_726.dbo.Jobs.PK_RosterStatus1CLUSTEREDYY02002026-09-10 12:36:402026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.Jobs.UQ_ContractMonthly2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.MeterResult.PK_BookingDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.dbo.OrdersSnapshot.IX_SalesQueue2NONCLUSTERED01002026-09-07 08:29:432026-09-13 02:00:03USEDkeep — in use
host_726.dbo.OrdersSnapshot.PK_PolicyLine1CLUSTEREDYY04002026-09-07 08:29:432026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.SalesLine.IX_ReconcileResult2NONCLUSTERED0000neverneverCOLDreview, then DROP
host_726.dbo.SalesLine.PK_MeterStatus1CLUSTEREDYY01002026-09-07 08:26:53neverUSEDKEEP — primary key
host_726.dbo.InvoiceSummary.PK_LedgerResult1CLUSTEREDYY0000never2026-09-13 02:00:03UNUSEDKEEP — primary key
host_726.dbo.CustomerSummary.PK_TicketStaging1CLUSTEREDYY0000never2026-09-13 02:00:03UNUSEDKEEP — primary key
host_726.dbo.QuotaResult.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-13 02:00:03UNUSEDKEEP — primary key
host_726.dbo.LedgerResult.PK_ForecastMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.dbo.BatchResult.IX_SettlementStaging2NONCLUSTERED0000never2026-09-13 02:00:03COLDreview, then DROP
host_726.dbo.BatchResult.IX_ReconcileEntry3NONCLUSTERED0000never2026-09-13 02:00:03UNUSEDreview, then DROP
host_726.dbo.BatchResult.PK_ContractEntry1CLUSTEREDYY0000never2026-09-13 02:00:03UNUSEDKEEP — primary key
host_726.dbo.PricingLog.PK_RouteLine1CLUSTEREDYY01002026-09-10 12:37:00neverUSEDKEEP — primary key
host_726.dbo.ClaimArchive.PK_StaffingStaging1CLUSTEREDYY0000never2026-09-13 02:00:03UNUSEDKEEP — primary key
host_726.dbo.ClaimArchive.UQ_SupplierResult2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.CustomerArchive.IX_BillingHeader3NONCLUSTERED0000never2026-09-13 02:00:03UNUSEDreview, then DROP
host_726.dbo.CustomerArchive.PK_AssetSummary1CLUSTEREDYY02002026-09-10 12:37:082026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.CustomerArchive.UQ_OrdersMonthly2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.Status.PK_ShiftLine1CLUSTEREDYY01002026-09-07 08:26:372026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.Status.UQ_PricingHeader2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
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.BookingStatus.PK_StaffingEntry1CLUSTEREDYY0000never2026-09-13 02:00:03UNUSEDKEEP — primary key
host_726.dbo.BookingStatus.UQ_CatalogSummary2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.BookingStatus.UQ_ContractEntry3NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.BookingStatus.UQ_RouteLine4NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.BillingHistory.PK_PayrollHistory1CLUSTEREDYY0000never2026-09-13 02:00:03UNUSEDKEEP — primary key
host_726.dbo.TicketQueue.PK_ForecastSnapshot1CLUSTEREDYY0000never2026-09-13 02:00:03UNUSEDKEEP — primary key
host_726.dbo.StaffingStaging.PK_SettlementHeader1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.dbo.WarehouseEntry.PK_ShiftStatus1CLUSTEREDYY730809721002026-09-16 01:00:322026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.WarehouseEntry.UX_CampaignHeader2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.TicketSummary.PK_SalesLine1CLUSTERED04577002026-09-15 23:22:452026-09-13 02:00:03USEDKEEP — table storage
host_726.dbo.TerritoryEntry.PK_SalesSummary1CLUSTEREDYY472173291002026-09-16 01:00:322026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.TerritoryEntry.UX_TerritoryQueue2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.PolicyEntry.PK_TicketEntry1CLUSTEREDYY232998743002026-09-16 01:00:322026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.PolicyEntry.UX_PolicyAudit2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.CampaignHeader.PK_InvoiceSnapshot1CLUSTEREDYY259152841002026-09-16 01:00:322026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.CampaignHeader.UX_BillingLog2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.WarehouseHeader.PK_OrdersQueue1CLUSTEREDYY0404002026-09-15 20:48:572026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.WarehouseHeader.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.RouteQueue.PK_SupplierAudit1CLUSTEREDYY480982291002026-09-16 01:00:322026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.RouteQueue.UX_CampaignQueue2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.CampaignAudit.PK_BatchSnapshot1CLUSTEREDYY232928743002026-09-16 01:00:322026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.CampaignAudit.UX_SupplierArchive2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbo.ShiftDaily.PK_ReconcileStatus1CLUSTEREDYY481682291002026-09-16 01:00:322026-09-13 02:00:03USEDKEEP — primary key
host_726.dbo.ShiftDaily.UX_RouteDaily2NONCLUSTEREDY0000never2026-09-13 02:00:03UNUSEDreview carefully — unique
host_726.dbs.ShipmentStatus.UX_StaffingLog8NONCLUSTEREDYY1000102026-09-15 20:00:442026-09-15 02:00:03USEDkeep — in use
host_726.emp.WarehouseMonthly.PK_PricingHistory1CLUSTEREDYY46818551032026-09-16 00:03:592026-09-13 02:00:04USEDKEEP — primary key
host_726.emp.WarehouseMonthly.UX_CustomerDetail2NONCLUSTEREDYY0003never2026-09-13 02:00:04UNUSEDreview carefully — unique
host_726.emp.SettlementLine.PK_LedgerAudit1CLUSTEREDYY0003never2026-09-13 02:00:04UNUSEDKEEP — primary key
host_726.emp.SalesDetail.PK_BillingLog1CLUSTEREDYY035002026-09-15 19:35:232026-09-13 02:00:04USEDKEEP — primary key
host_726.emp.BatchMonthly.PK_TicketAudit1CLUSTEREDYY0000never2026-09-13 02:00:04UNUSEDKEEP — primary key
host_726.emp.RosterLog.PK_QuotaLog1CLUSTEREDYY10147800507392026-09-16 01:00:242026-09-13 02:00:04USEDKEEP — primary key
host_726.emp.QuotaMonthly.IX_ShipmentEntry2NONCLUSTERED263470006412026-09-16 01:00:322026-09-15 02:00:03USEDkeep — in use
host_726.emp.QuotaMonthly.PK_ReconcileDetail1CLUSTEREDYY7101872634707252026-09-16 01:00:322026-09-15 02:00:03USEDKEEP — primary key
host_726.emp.OrdersEntry.PK_PolicyHeader1CLUSTEREDYY000638never2026-09-15 02:00:04UNUSEDKEEP — primary key
host_726.emp.PayrollSummary.PK_RouteSummary1CLUSTEREDYY035002026-09-15 19:35:232026-09-13 02:00:06USEDKEEP — primary key
host_726.emp.SettlementAudit.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-13 02:00:06UNUSEDKEEP — primary key
host_726.emp.InvoiceLog.PK_BatchEntry1CLUSTEREDYY0000neverneverCOLDKEEP — 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_CustomerMonthly1CLUSTEREDYY128242002026-09-16 00:00:002026-09-13 02:00:06USEDKEEP — primary key
host_726.emp.RouteHistory.UX_CustomerQueue2NONCLUSTEREDY0000never2026-09-13 02:00:06UNUSEDreview carefully — unique
host_726.emp.CustomerHistory.PK_ShiftDaily1CLUSTEREDYY680002026-09-15 20:48:442026-09-13 02:00:06USEDKEEP — primary key
host_726.emp.ForecastEntry.PK_SettlementLog1CLUSTEREDYY122468580282026-09-16 01:00:292026-09-14 02:00:04USEDKEEP — primary key
host_726.emp.ClaimQueue.PK_TerritoryResult1CLUSTEREDYY00032never2026-09-14 02:00:04UNUSEDKEEP — primary key
host_726.emp.PolicyAudit.PK_ContractAudit1CLUSTEREDYY284467520212026-09-16 01:00:292026-09-14 02:00:04USEDKEEP — primary key
host_726.emp.ShipmentSummary.PK_ShiftAudit1CLUSTEREDYY040282026-09-11 17:06:042026-09-15 02:00:05USEDKEEP — primary key
host_726.emp.BatchArchive.PK_ClaimHistory1CLUSTEREDYY2004152466130192026-09-16 01:00:292026-09-14 02:00:04USEDKEEP — primary key
host_726.emp.RosterSnapshot.PK_PolicyStaging1CLUSTEREDYY00019never2026-09-14 02:00:05UNUSEDKEEP — primary key
host_726.emp.MeterResult.IX_LedgerQueue2NONCLUSTERED013184303292026-09-15 23:22:012026-09-15 02:00:05USEDkeep — in use
host_726.emp.MeterResult.PK_CustomerResult1CLUSTEREDYY21382655992803292026-09-16 01:00:482026-09-15 02:00:05USEDKEEP — primary key
host_726.emp.PayrollHeader.PK_TicketHistory1CLUSTEREDYY2332329203292026-09-16 01:00:322026-09-15 02:00:05USEDKEEP — primary key
host_726.emp.OrdersAudit.PK_ShipmentHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.RosterResult.PK_MeterAudit1CLUSTEREDYY0102002026-09-16 00:00:002026-09-13 02:00:07USEDKEEP — primary key
host_726.emp.RouteHeader.PK_StaffingQueue1CLUSTEREDYY0000never2026-09-13 02:00:07UNUSEDKEEP — primary key
host_726.emp.MeterAudit.PK_ClaimLog1CLUSTEREDYY21216161702162026-09-16 00:59:112026-09-15 02:00:05USEDKEEP — primary key
host_726.emp.QuotaStatus.PK_OrdersArchive1CLUSTEREDYY00023never2026-09-15 02:00:05UNUSEDKEEP — primary key
host_726.emp.ShiftLine.IX_PricingAudit3NONCLUSTERED1170002026-09-15 20:53:482026-09-13 02:00:07USEDkeep — in use
host_726.emp.ShiftLine.PK_SettlementStatus1CLUSTEREDYY47139117192026-09-16 00:00:012026-09-13 02:00:07USEDKEEP — primary key
host_726.emp.ShiftLine.UX_BookingDaily2NONCLUSTEREDY0000never2026-09-13 02:00:07UNUSEDreview carefully — unique
host_726.emp.CampaignHeader.PK_BillingQueue1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.MeterStatus.PK_BillingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.WarehouseStaging.PK_CustomerEntry1CLUSTEREDYY00019never2026-09-15 02:00:06UNUSEDKEEP — primary key
host_726.emp.ForecastHeader.IX_WarehouseResult2NONCLUSTERED51030022026-09-15 23:22:452026-09-13 02:00:08USEDkeep — in use
host_726.emp.ForecastHeader.PK_OrdersAudit1CLUSTEREDYY272510322026-09-15 23:22:452026-09-13 02:00:08USEDKEEP — primary key
host_726.emp.SalesLog.PK_AssetStaging1CLUSTEREDYY0000never2026-09-13 02:00:08UNUSEDKEEP — primary key
host_726.emp.AssetDaily.PK_CustomerMonthly1CLUSTEREDYY09367002026-09-15 23:22:452026-09-13 02:00:08USEDKEEP — primary key
host_726.emp.StaffingDaily.PK_BookingLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.ClaimResult.PK_TerritoryQueue1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.CatalogLog.PK_ReconcileHeader1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.ShipmentSnapshot.PK_ReconcileQueue1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.PricingDaily.IX_ShiftAudit2NONCLUSTERED11500212026-09-15 20:44:062026-09-15 02:00:06USEDkeep — in use
host_726.emp.PricingDaily.PK_RouteEntry1CLUSTEREDYY44996115212026-09-15 23:22:452026-09-15 02:00:06USEDKEEP — primary key
host_726.emp.PolicyLog.PK_LedgerHistory1CLUSTEREDYY323982329823292026-09-16 01:00:322026-09-15 02:00:06USEDKEEP — primary key
host_726.emp.PolicyLog.UX_OrdersSnapshot2NONCLUSTEREDY2329921003292026-09-16 01:00:322026-09-15 02:00:06USEDkeep — in use
host_726.emp.RouteAudit.PK_ClaimResult1CLUSTEREDYY00021never2026-09-15 02:00:06UNUSEDKEEP — primary key
host_726.emp.PayrollDaily.IX_BillingStaging2NONCLUSTERED31001562026-09-15 20:50:332026-09-13 02:00:09USEDkeep — in use
host_726.emp.PayrollDaily.PK_OrdersSnapshot1CLUSTEREDYY03101562026-09-15 20:50:332026-09-13 02:00:09USEDKEEP — primary key
host_726.emp.MeterHistory.IX_ContractArchive17NONCLUSTERED65277763703552026-09-16 00:20:022026-09-15 02:00:06USEDkeep — in use
host_726.emp.MeterHistory.PK_BatchLog1CLUSTEREDYY51872738555120457725752026-09-16 01:00:482026-09-15 02:00:06USEDKEEP — primary key
host_726.emp.MeterHistory.UX_BatchLog2NONCLUSTEREDYY000575never2026-09-15 02:00:06UNUSEDreview carefully — unique
host_726.emp.MeterHistory.UX_ForecastHeader20NONCLUSTEREDY47529719003552026-09-16 01:00:322026-09-15 02:00:07USEDkeep — in use
host_726.emp.MeterHistory.UX_CustomerSnapshot3NONCLUSTEREDYY53205752026-09-15 21:11:382026-09-15 02:00:07USEDkeep — in use
host_726.emp.MeterHistory.UX_QuotaStaging4NONCLUSTEREDY2526628703552026-09-16 01:00:462026-09-15 02:00:07USEDkeep — in use
host_726.emp.ShiftSnapshot.IX_ForecastAudit1CLUSTERED000569never2026-09-15 02:00:07UNUSEDKEEP — table storage
host_726.emp.TerritoryLine.PK_LedgerArchive1CLUSTEREDYY65813180060230012026-09-16 00:44:372026-09-13 02:00:10USEDKEEP — primary key
host_726.emp.SalesStaging.PK_PolicyDaily1CLUSTEREDYY7900209022332026-09-16 00:09:242026-09-13 02:00:11USEDKEEP — primary key
host_726.emp.TerritoryDaily.PK_MeterLog1CLUSTEREDYY000942never2026-09-13 02:00:11UNUSEDKEEP — primary key
host_726.emp.SettlementQueue.IX_PolicyAudit2NONCLUSTERED00022987never2026-09-15 02:00:08UNUSEDreview, then DROP
host_726.emp.SettlementQueue.PK_SalesEntry1CLUSTEREDYY0720229872026-09-15 20:53:502026-09-15 02:00:08USEDKEEP — primary key
host_726.emp.StaffingMonthly.IX_ReconcileEntry2NONCLUSTERED0000never2026-09-13 02:00:12UNUSEDreview, then DROP
host_726.emp.StaffingMonthly.IX_SalesQueue3NONCLUSTERED140820002026-09-15 23:22:452026-09-13 02:00:12USEDkeep — in use
host_726.emp.StaffingMonthly.PK_CampaignStatus1CLUSTEREDYY312776550602026-09-15 23:22:452026-09-13 02:00:12USEDKEEP — primary key
host_726.emp.TicketQueue.PK_BatchDaily1CLUSTEREDYY0051496462026-09-15 23:22:452026-09-15 02:00:09USEDKEEP — primary key
host_726.emp.TicketQueue.UX_PayrollDaily2NONCLUSTEREDY5149006462026-09-15 23:22:452026-09-15 02:00:09USEDkeep — in use
host_726.emp.MeterStatus.PK_CustomerDetail1CLUSTEREDYY000646never2026-09-15 02:00:09UNUSEDKEEP — primary key
host_726.emp.OrdersEntry.PK_TerritoryAudit1CLUSTEREDYY05499002026-09-15 23:22:452026-09-13 02:00:12USEDKEEP — primary key
host_726.emp.InvoiceLog.PK_BillingDetail1CLUSTEREDYY000364never2026-09-15 02:00:10UNUSEDKEEP — primary key
host_726.emp.CampaignHistory.IX_QuotaDetail2NONCLUSTERED25191120032026-09-16 01:00:262026-09-13 02:00:15USEDkeep — in use
host_726.emp.CampaignHistory.PK_AssetHeader1CLUSTEREDYY042134251911232026-09-16 01:00:262026-09-13 02:00:15USEDKEEP — primary key
host_726.emp.ContractArchive.PK_BookingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.TicketLine.PK_CampaignEntry1CLUSTEREDYY4748002026-09-15 22:25:052026-09-13 02:00:15USEDKEEP — primary key
host_726.emp.BatchAudit.IX_PolicyArchive20NONCLUSTERED17880882012025322026-09-16 00:58:452026-09-15 02:00:11USEDkeep — in use
host_726.emp.BatchAudit.PK_ForecastSummary1CLUSTEREDYY6013246610348337918037402026-09-16 01:00:342026-09-15 02:00:11USEDKEEP — primary key
host_726.emp.BatchAudit.UX_LedgerStaging2NONCLUSTEREDY63270684012025322026-09-16 01:00:342026-09-15 02:00:11USEDkeep — in use
host_726.emp.ClaimAudit.PK_LedgerDaily1CLUSTEREDYY0005neverneverUNUSEDKEEP — primary key
host_726.emp.ClaimAudit.UX_RouteMonthly2NONCLUSTEREDY05052026-09-15 16:44:39neverUSEDkeep — in use
host_726.emp.PolicyHistory.PK_OrdersDaily1CLUSTEREDYY1200541441018015862026-09-16 01:00:272026-09-15 22:55:18USEDKEEP — primary key
host_726.emp.BillingEntry.PK_StaffingAudit1CLUSTEREDYY0548012003742026-09-16 00:09:232026-09-15 19:08:31USEDKEEP — primary key
host_726.emp.BillingEntry.UX_StaffingLog2NONCLUSTEREDY5991690012003742026-09-16 01:00:272026-09-15 19:08:31USEDkeep — in use
host_726.emp.BillingAudit.IX_PolicyHeader8NONCLUSTERED1209930012003742026-09-16 00:57:292026-09-15 19:45:39USEDkeep — in use
host_726.emp.BillingAudit.PK_PolicyDetail1CLUSTEREDYY0333512003742026-09-15 20:53:482026-09-15 19:45:38USEDKEEP — primary key
host_726.emp.BillingAudit.UX_SupplierSnapshot2NONCLUSTEREDY59914431012003742026-09-16 01:00:272026-09-15 19:45:38USEDkeep — in use
host_726.emp.ShipmentStaging.PK_TerritoryStatus1CLUSTEREDYY03605991632026-09-15 20:53:48neverUSEDKEEP — primary key
host_726.emp.ShipmentStaging.UX_RosterDaily2NONCLUSTEREDY059916305991632026-09-16 01:00:27neverUSEDkeep — in use
host_726.emp.SalesLine.PK_CampaignResult1CLUSTEREDYY161659622018015822026-09-16 01:00:342026-09-15 22:53:50USEDKEEP — primary key
host_726.emp.LedgerSnapshot.PK_CampaignStatus1CLUSTEREDYY000339never2026-09-15 02:00:38UNUSEDKEEP — primary key
host_726.emp.ReconcileDetail.PK_CampaignQueue1CLUSTEREDYY148561301752026-09-15 23:22:452026-09-15 02:00:39USEDKEEP — primary key
host_726.emp.PolicyStaging.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.ReconcileStaging.PK_ContractStaging1CLUSTEREDYY240477002026-09-15 22:25:052026-09-13 02:00:46USEDKEEP — primary key
host_726.emp.ReconcileStaging.UX_OrdersHistory2NONCLUSTEREDY0000never2026-09-13 02:00:46UNUSEDreview carefully — unique
host_726.emp.MeterStatus.PK_ReconcileMonthly1CLUSTEREDYY3327274159483282026-09-16 01:00:322026-09-15 02:00:39USEDKEEP — primary key
host_726.emp.MeterStatus.UX_ReconcileAudit4NONCLUSTEREDY415958001082026-09-16 01:00:322026-09-15 02:00:39USEDkeep — in use
host_726.emp.PricingAudit.PK_ReconcileSnapshot1CLUSTEREDYY00031never2026-09-15 02:00:39UNUSEDKEEP — primary key
host_726.emp.OrdersMonthly.IX_QuotaArchive2NONCLUSTEREDY00083neverneverUNUSEDreview, then DROP
host_726.emp.OrdersMonthly.IX_PayrollResult3NONCLUSTEREDY000973neverneverUNUSEDreview, then DROP
host_726.emp.OrdersMonthly.IX_TicketSnapshot4NONCLUSTERED7253651011452026-09-16 00:59:312026-09-15 02:00:40USEDkeep — in use
host_726.emp.OrdersMonthly.IX_SettlementLine5NONCLUSTERED170011452026-09-15 15:20:542026-09-15 02:00:40USEDkeep — in use
host_726.emp.OrdersMonthly.PK_ShipmentSnapshot1CLUSTEREDYY51089011452026-09-15 23:37:312026-09-15 02:00:40USEDKEEP — primary key
host_726.emp.RosterQueue.PK_SettlementHistory1CLUSTEREDYY1565202882002026-09-16 00:59:112026-09-13 02:00:47USEDKEEP — primary key
host_726.emp.BatchResult.IX_BillingQueue6NONCLUSTERED17541107672026-09-16 00:36:122026-09-15 02:00:46USEDkeep — in use
host_726.emp.BatchResult.PK_InvoiceSummary1CLUSTEREDYY05497672026-09-16 00:17:152026-09-15 02:00:40USEDKEEP — primary key
host_726.emp.TicketAudit.IX_LedgerLog2NONCLUSTERED2300120692026-09-15 20:29:562026-09-13 02:00:48USEDkeep — in use
host_726.emp.TicketAudit.PK_LedgerStatus1CLUSTEREDYY0023120692026-09-15 20:29:562026-09-13 02:00:48USEDKEEP — primary key
host_726.emp.InvoiceResult.PK_ShipmentMonthly1CLUSTEREDYY00012069never2026-09-13 02:00:49UNUSEDKEEP — primary key
host_726.emp.CustomerLog.IX_PolicyDaily18NONCLUSTERED49893073472026-09-15 23:21:382026-09-15 02:00:48USEDkeep — in use
host_726.emp.CustomerLog.IX_PayrollResult21NONCLUSTERED610885410022290146852026-09-16 01:00:262026-09-15 02:00:48USEDkeep — in use
host_726.emp.CustomerLog.PK_StaffingDaily1CLUSTEREDYY330271529611031979146852026-09-16 01:00:262026-09-15 02:00:47USEDKEEP — primary key
host_726.emp.InvoiceAudit.IX_SettlementResult10NONCLUSTERED20865027538070992026-09-16 00:59:312026-09-15 02:00:49USEDkeep — in use
host_726.emp.InvoiceAudit.PK_QuotaEntry1CLUSTEREDYY01362534870992026-09-16 00:52:132026-09-15 02:00:49USEDKEEP — primary key
host_726.emp.MeterSummary.PK_AssetEntry1CLUSTEREDYY0004907never2026-09-15 02:00:50UNUSEDKEEP — primary key
host_726.emp.BatchDaily.IX_SupplierStatus1CLUSTERED00011062never2026-09-15 02:00:51UNUSEDKEEP — table storage
host_726.emp.AssetSummary.PK_SupplierStaging1CLUSTEREDYY09073472026-09-15 01:15:022026-09-15 02:00:51USEDKEEP — primary key
host_726.emp.SupplierStaging.IX_CampaignResult24NONCLUSTERED02470138812026-09-15 23:15:432026-09-15 02:00:54USEDkeep — in use
host_726.emp.SupplierStaging.IX_StaffingSnapshot30NONCLUSTERED19680242890138832026-09-16 01:00:342026-09-15 02:00:57USEDkeep — in use
host_726.emp.SupplierStaging.IX_MeterStaging16NONCLUSTERED28700124472026-09-15 19:07:412026-09-15 02:00:57USEDkeep — in use
host_726.emp.SupplierStaging.IX_StaffingEntry25NONCLUSTERED00012680never2026-09-15 02:00:57UNUSEDreview, then DROP
host_726.emp.SupplierStaging.PK_PayrollMonthly1CLUSTEREDYY10890788060584252138832026-09-16 01:00:352026-09-15 02:00:52USEDKEEP — primary key
host_726.emp.SupplierStaging.IX_OrdersSnapshot26NONCLUSTEREDY365610058512026-09-15 23:32:002026-09-15 02:00:57USEDkeep — in use
host_726.emp.CustomerStatus.IX_ReconcileLine10NONCLUSTERED238118920210203922026-09-16 00:59:312026-09-15 02:00:59USEDkeep — in use
host_726.emp.CustomerStatus.PK_PolicyHistory1CLUSTEREDYY043786482203922026-09-16 00:38:302026-09-15 02:00:58USEDKEEP — primary key
host_726.emp.BillingAudit.PK_CustomerEntry1CLUSTEREDYY00014846never2026-09-15 02:01:00UNUSEDKEEP — primary key
host_726.emp.PolicyLine.PK_OrdersSummary1CLUSTEREDYY4171580152026-09-16 00:38:302026-09-15 02:01:00USEDKEEP — primary key
host_726.emp.RouteStaging.PK_WarehouseLine1CLUSTEREDYY05611002026-09-16 00:38:302026-09-13 02:00:59USEDKEEP — primary key
host_726.emp.CampaignMonthly.PK_OrdersArchive1CLUSTEREDYY91256505932026-09-15 23:56:582026-09-15 02:01:00USEDKEEP — primary key
host_726.emp.CatalogSnapshot.PK_ClaimHistory1CLUSTEREDYY051002026-09-15 19:29:542026-09-13 02:00:59USEDKEEP — primary key
host_726.emp.TerritoryMonthly.IX_LedgerMonthly1CLUSTERED0008680never2026-09-15 02:01:00UNUSEDKEEP — table storage
host_726.emp.BillingDaily.PK_CustomerLine1CLUSTEREDYY065968044100362026-09-15 22:35:422026-09-15 02:01:01USEDKEEP — primary key
host_726.emp.BillingDaily.UX_LedgerDaily2NONCLUSTEREDY832400100362026-09-15 22:35:422026-09-15 02:01:01USEDkeep — in use
host_726.emp.SupplierHistory.PK_WarehouseMonthly1CLUSTEREDYY0130144292026-09-15 01:15:002026-09-15 02:01:01USEDKEEP — primary key
host_726.emp.ShipmentMonthly.IX_SupplierEntry11NONCLUSTERED310665002256152026-09-16 00:59:312026-09-15 02:01:07USEDkeep — in use
host_726.emp.ShipmentMonthly.IX_InvoiceStaging2NONCLUSTERED435708002256152026-09-16 01:00:242026-09-15 02:01:07USEDkeep — in use
host_726.emp.ShipmentMonthly.PK_BatchDaily1CLUSTEREDYY14972383429072271122026-09-16 00:51:492026-09-15 02:01:02USEDKEEP — primary key
host_726.emp.AssetDetail.PK_ReconcileResult1CLUSTEREDYY00098551never2026-09-15 02:01:08UNUSEDKEEP — primary key
host_726.emp.AssetSnapshot.IX_ForecastStatus5NONCLUSTERED175987616600969412026-09-16 01:00:262026-09-15 02:01:11USEDkeep — in use
host_726.emp.AssetSnapshot.IX_SalesDaily2NONCLUSTERED115141838220969412026-09-16 01:00:252026-09-15 02:01:13USEDkeep — in use
host_726.emp.AssetSnapshot.PK_OrdersDetail1CLUSTEREDYY665740241940969412026-09-16 00:57:292026-09-15 02:01:09USEDKEEP — primary key
host_726.emp.PricingStatus.PK_PolicyStatus1CLUSTEREDYY00096937never2026-09-15 02:01:13UNUSEDKEEP — primary key
host_726.emp.TicketSnapshot.IX_BookingHistory15NONCLUSTERED0323901189722026-09-15 23:22:012026-09-15 02:01:26USEDkeep — in use
host_726.emp.TicketSnapshot.PK_CampaignQueue1CLUSTEREDYY295813021231601189722026-09-16 01:00:352026-09-15 02:01:14USEDKEEP — primary key
host_726.emp.TicketSnapshot.IX_ContractEntry19NONCLUSTEREDY20921359601189722026-09-16 01:00:252026-09-15 02:01:26USEDkeep — in use
host_726.emp.MeterEntry.IX_OrdersAudit1CLUSTERED00079216never2026-09-15 02:01:27UNUSEDKEEP — table storage
host_726.emp.ForecastMonthly.PK_CampaignSummary1CLUSTEREDYY0901189382026-09-15 01:15:012026-09-15 02:01:27USEDKEEP — primary key
host_726.emp.PricingStatus.IX_QuotaLog7NONCLUSTERED1911600420892026-09-15 01:59:382026-09-15 02:01:29USEDkeep — in use
host_726.emp.PricingStatus.IX_ClaimEntry2NONCLUSTERED289164260630420892026-09-16 01:00:262026-09-15 02:01:29USEDkeep — in use
host_726.emp.PricingStatus.PK_LedgerResult1CLUSTEREDYY6199066719024420892026-09-16 01:00:352026-09-15 02:01:29USEDKEEP — primary key
host_726.emp.AssetDaily.IX_PayrollDaily1CLUSTERED000337never2026-09-15 02:01:30UNUSEDKEEP — table storage
host_726.emp.PayrollHistory.PK_LedgerQueue1CLUSTEREDYY00042083never2026-09-15 02:01:30UNUSEDKEEP — primary key
host_726.emp.QuotaSummary.IX_StaffingQueue10NONCLUSTERED20330952808035732026-09-16 00:59:312026-09-15 02:01:30USEDkeep — in use
host_726.emp.QuotaSummary.PK_LedgerEntry1CLUSTEREDYY0825194735732026-09-16 00:59:312026-09-15 02:01:30USEDKEEP — primary key
host_726.emp.PricingQueue.PK_PricingStaging1CLUSTEREDYY0002714never2026-09-15 02:01:31UNUSEDKEEP — primary key
host_726.emp.BookingMonthly.IX_ShipmentAudit5NONCLUSTERED2263742784138041052026-09-16 01:00:342026-09-15 02:01:31USEDkeep — in use
host_726.emp.BookingMonthly.PK_WarehouseLog1CLUSTEREDYY440041052026-09-14 22:31:492026-09-15 02:01:31USEDKEEP — primary key
host_726.emp.MeterSnapshot.PK_StaffingSummary1CLUSTEREDYY0004105never2026-09-15 02:01:32UNUSEDKEEP — primary key
host_726.emp.BatchMonthly.IX_ClaimSummary18NONCLUSTERED0240050992026-09-15 23:17:522026-09-15 02:01:35USEDkeep — in use
host_726.emp.BatchMonthly.PK_InvoiceDetail1CLUSTEREDYY33470271556223150992026-09-16 01:00:342026-09-15 02:01:34USEDKEEP — primary key
host_726.emp.BatchMonthly.IX_TerritorySnapshot19NONCLUSTEREDY44331050992026-09-16 00:33:502026-09-15 02:01:35USEDkeep — in use
host_726.emp.WarehouseMonthly.IX_InvoiceStatus1CLUSTERED0001620never2026-09-15 02:01:36UNUSEDKEEP — table storage
host_726.emp.StaffingAudit.PK_ForecastHeader1CLUSTEREDYY09051382026-09-15 01:15:012026-09-15 02:01:36USEDKEEP — primary key
host_726.emp.BatchLog.PK_SalesDetail1CLUSTEREDYY3535172789095060122026-09-16 01:00:342026-09-15 02:01:37USEDKEEP — primary key
host_726.emp.ReconcileSummary.IX_ShipmentDetail1CLUSTERED00037never2026-09-15 02:01:38UNUSEDKEEP — table storage
host_726.emp.RouteHistory.PK_MeterEntry1CLUSTEREDYY0006012never2026-09-15 02:01:38UNUSEDKEEP — primary key
host_726.emp.CampaignResult.IX_ClaimStatus15NONCLUSTERED7676281701232322026-09-16 00:58:432026-09-15 02:02:19USEDkeep — in use
host_726.emp.CampaignResult.IX_ForecastAudit14NONCLUSTERED261856202464082026-09-15 19:04:002026-09-15 15:10:53USEDkeep — in use
host_726.emp.CampaignResult.IX_CustomerQueue6NONCLUSTERED2611603002464642026-09-16 01:00:262026-09-15 15:10:53USEDkeep — in use
host_726.emp.CampaignResult.PK_StaffingArchive1CLUSTEREDYY1898174184036410772466072026-09-16 01:00:262026-09-15 02:01:38USEDKEEP — primary key
host_726.emp.SalesHeader.IX_BookingSummary2NONCLUSTERED0002064never2026-09-15 02:02:23UNUSEDreview, then DROP
host_726.emp.SalesHeader.PK_CatalogQueue1CLUSTEREDYY0002064never2026-09-15 02:02:23UNUSEDKEEP — primary key
host_726.emp.PayrollHistory.PK_CampaignStaging1CLUSTEREDYY84607102862026-09-15 23:22:452026-09-15 02:02:21USEDKEEP — primary key
host_726.emp.TerritoryDaily.PK_RouteArchive1CLUSTEREDYY000286never2026-09-15 02:02:21UNUSEDKEEP — primary key
host_726.emp.CatalogSummary.IX_PricingSnapshot27NONCLUSTERED1289211036822026-09-16 01:00:342026-09-15 02:02:21USEDkeep — in use
host_726.emp.CatalogSummary.IX_WarehouseSnapshot7NONCLUSTERED241752808903992026-09-16 01:00:322026-09-15 02:02:21USEDkeep — in use
host_726.emp.CatalogSummary.IX_ReconcileSummary21NONCLUSTERED970224103992026-09-16 01:00:342026-09-15 02:02:21USEDkeep — in use
host_726.emp.CatalogSummary.IX_AssetEntry26NONCLUSTERED3833602019036822026-09-16 01:00:292026-09-15 02:02:21USEDkeep — in use
host_726.emp.CatalogSummary.PK_ShipmentStaging1CLUSTEREDYY392606364322136014737142026-09-16 01:00:352026-09-15 02:02:21USEDKEEP — primary key
host_726.emp.CatalogSummary.UX_OrdersAudit2NONCLUSTEREDY626503992026-09-16 00:20:022026-09-15 02:02:21USEDkeep — in use
host_726.emp.CatalogSummary.UX_LedgerHistory4NONCLUSTEREDYY1475990037142026-09-16 01:00:082026-09-15 02:02:21USEDkeep — in use
host_726.emp.TicketMonthly.PK_LedgerAudit1CLUSTEREDYY196486808512026-09-15 20:53:502026-09-15 02:02:22USEDKEEP — primary key
host_726.emp.BillingQueue.IX_AssetDetail11NONCLUSTERED1825708882026-09-15 22:55:382026-09-15 02:02:22USEDkeep — in use
host_726.emp.BillingQueue.IX_ContractSummary8NONCLUSTERED1762356308882026-09-16 01:00:342026-09-15 02:02:22USEDkeep — in use
host_726.emp.BillingQueue.PK_ShipmentEntry1CLUSTEREDYY04835317622098882026-09-16 01:00:342026-09-15 02:02:22USEDKEEP — primary key
host_726.emp.CampaignResult.IX_SupplierLine13NONCLUSTERED8860037922026-09-15 20:50:332026-09-15 02:02:22USEDkeep — in use
host_726.emp.CampaignResult.PK_CustomerLine1CLUSTEREDYY097688637922026-09-15 20:50:332026-09-15 02:02:22USEDKEEP — primary key
host_726.guest.TerritoryQueue.IX_InvoiceStaging2NONCLUSTERED0000never2026-09-13 02:01:39UNUSEDreview, then DROP
host_726.org.SettlementSnapshot.PK_org.SettlementSnapshot1CLUSTEREDYY064002026-09-15 08:54:042026-09-13 02:01:50USEDKEEP — primary key
host_726.org.SettlementSnapshot.UX_BillingLine2NONCLUSTEREDY0000never2026-09-13 02:01:50UNUSEDreview carefully — unique
host_726.org.PolicySummary.IX_AssetEntry3NONCLUSTERED511718142930302026-09-16 01:00:342026-09-13 02:01:50USEDkeep — in use
host_726.org.PolicySummary.PK_QuotaAudit1CLUSTEREDYY48613784134575136711032026-09-16 01:00:352026-09-13 02:01:50USEDKEEP — primary key
host_726.org.PolicySummary.UX_ForecastHistory2NONCLUSTEREDYY203300402026-09-15 23:14:202026-09-13 02:01:50USEDkeep — in use
host_726.org.BatchMonthly.PK_WarehouseSummary1CLUSTEREDYY8017540402026-09-15 22:00:032026-09-13 02:01:50USEDKEEP — primary key
host_726.org.BatchMonthly.UX_SalesSnapshot2NONCLUSTEREDYY00040never2026-09-13 02:01:50UNUSEDreview carefully — unique
host_726.org.CampaignQueue.PK_RosterDaily1CLUSTEREDYY00059never2026-09-13 02:01:50UNUSEDKEEP — primary key
host_726.org.TicketLog.PK_WarehouseDetail1CLUSTEREDYY132142101122026-09-15 20:48:442026-09-13 02:01:50USEDKEEP — primary key
host_726.org.TicketLog.UX_SalesMonthly4NONCLUSTEREDY10001122026-09-14 10:08:442026-09-15 02:02:23USEDkeep — in use
host_726.org.BatchDaily.PK_QuotaStaging1CLUSTEREDYY9730482194228102026-09-16 01:00:592026-09-13 02:01:50USEDKEEP — primary key
host_726.org.BatchDaily.UX_PricingResult2NONCLUSTEREDYY081002026-09-15 18:00:572026-09-13 02:01:50USEDkeep — in use
host_726.org.ShipmentAudit.PK_ForecastHeader1CLUSTEREDYY0116106152079202026-09-16 01:01:002026-09-13 02:01:50USEDKEEP — primary key
host_726.org.ShipmentAudit.UX_BatchArchive2NONCLUSTEREDY5189641869002026-09-16 01:01:002026-09-13 02:01:51USEDkeep — in use
host_726.org.WarehouseStaging.PK_MeterHistory1CLUSTEREDYY0000never2026-09-13 02:01:51UNUSEDKEEP — primary key
host_726.org.BookingResult.PK_BillingQueue1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.InvoiceQueue.PK_TicketEntry1CLUSTEREDYY11175002026-09-15 17:14:272026-09-13 02:01:51USEDKEEP — primary key
host_726.org.PricingStatus.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-13 02:01:51UNUSEDKEEP — primary key
host_726.org.CatalogHeader.PK_ShiftStatus1CLUSTEREDYY5482050102026-09-15 22:54:012026-09-13 02:01:51USEDKEEP — primary key
host_726.org.PolicySummary.PK_CatalogQueue1CLUSTEREDYY00010never2026-09-15 02:02:23UNUSEDKEEP — primary key
host_726.org.CatalogAudit.PK_AssetStatus1CLUSTEREDYY0000never2026-09-13 02:01:51UNUSEDKEEP — primary key
host_726.org.OrdersSummary.PK_StaffingAudit1CLUSTEREDYY48015702442026-09-15 13:55:032026-09-15 02:02:23USEDKEEP — primary key
host_726.org.ContractResult.PK_PolicyLine1CLUSTEREDYY000244never2026-09-15 02:02:23UNUSEDKEEP — primary key
host_726.org.SupplierHistory.IX_ShipmentSummary2NONCLUSTERED0000never2026-09-13 02:01:51UNUSEDreview, then DROP
host_726.org.SupplierHistory.PK_CustomerDetail1CLUSTEREDYY057328002026-09-16 00:03:592026-09-13 02:01:51USEDKEEP — 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-13 02:01:51UNUSEDreview, then DROP
host_726.org.BillingHeader.PK_InvoiceMonthly1CLUSTEREDYY014332002026-09-16 00:03:592026-09-13 02:01:51USEDKEEP — primary key
host_726.org.ShipmentSummary.IX_StaffingResult2NONCLUSTERED0000never2026-09-13 02:01:51UNUSEDreview, then DROP
host_726.org.ShipmentSummary.PK_ClaimDetail1CLUSTEREDYY014332002026-09-16 00:03:592026-09-13 02:01:51USEDKEEP — primary key
host_726.org.SalesStatus.IX_ClaimHeader2NONCLUSTEREDY143350002026-09-16 00:03:592026-09-13 02:01:51USEDkeep — in use
host_726.org.SalesStatus.PK_CampaignSnapshot1CLUSTEREDYY001433502026-09-16 00:03:592026-09-13 02:01:51USEDKEEP — primary key
host_726.org.PolicyResult.PK_ForecastStaging1CLUSTEREDYY2656342780042026-09-16 01:00:262026-09-15 02:02:23USEDKEEP — primary key
host_726.org.AssetSummary.PK_TicketStaging1CLUSTEREDYY1526958588002026-09-16 00:59:112026-09-13 02:01:51USEDKEEP — primary key
host_726.org.AssetSummary.UX_ShipmentSummary2NONCLUSTEREDY03855002026-09-16 00:24:262026-09-13 02:01:51USEDkeep — in use
host_726.org.ShipmentQueue.PK_InvoiceStaging1CLUSTEREDYY2220521319387002026-09-16 01:00:352026-09-13 02:01:51USEDKEEP — primary key
host_726.org.PolicyEntry.PK_SettlementSnapshot1CLUSTEREDYY3152289042026-09-16 00:20:022026-09-13 02:01:51USEDKEEP — primary key
host_726.org.PolicyEntry.UX_ShiftSnapshot2NONCLUSTEREDYY0004never2026-09-13 02:01:51UNUSEDreview carefully — unique
host_726.org.MeterAudit.IX_WarehouseQueue6NONCLUSTERED1090002026-09-16 00:20:022026-09-13 02:01:52USEDkeep — in use
host_726.org.MeterAudit.PK_BillingDetail1CLUSTEREDYY30610042026-09-15 23:37:312026-09-13 02:01:51USEDKEEP — primary key
host_726.org.BillingHeader.PK_ContractStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.TicketSnapshot.PK_ForecastSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.CustomerStaging.PK_CustomerHeader1CLUSTEREDYY0004never2026-09-13 02:01:52UNUSEDKEEP — primary key
host_726.org.KPI.PK_ShiftLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.KPI.UX_ShiftHeader2NONCLUSTEREDYY0000neverneverCOLDreview carefully — unique
host_726.org.StaffingArchive.PK_SettlementResult1CLUSTEREDYY063002026-09-15 08:54:05neverUSEDKEEP — primary key
host_726.org.CustomerEntry.PK_RouteSummary1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.PricingDaily.PK_CampaignArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.PricingDaily.UX_BillingArchive2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
host_726.org.TicketLine.PK_SupplierMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.BillingArchive.PK_MeterSummary1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.MeterEntry.PK_SupplierLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.ReconcileAudit.PK_PolicyLog1CLUSTEREDYY13286431412242026-09-16 00:52:352026-09-13 02:01:52USEDKEEP — primary key
host_726.org.ReconcileAudit.UQ_ShipmentResult2NONCLUSTEREDYY2600242026-09-09 08:01:332026-09-13 02:01:52USEDkeep — in use
host_726.org.StaffingAudit.PK_RosterArchive1CLUSTEREDYY00038never2026-09-13 02:01:52UNUSEDKEEP — primary key
host_726.org.ShiftResult.PK_AssetAudit1CLUSTEREDYY381168111183390102026-09-16 01:00:472026-09-13 02:01:52USEDKEEP — primary key
host_726.org.BatchMonthly.PK_SalesLine1CLUSTEREDYY10128220202026-09-16 00:38:302026-09-13 02:01:52USEDKEEP — primary key
host_726.org.RosterMonthly.IX_AssetDetail2NONCLUSTERED00012never2026-09-13 02:01:52UNUSEDreview, then DROP
host_726.org.RosterMonthly.PK_ForecastDaily1CLUSTEREDYY6700122026-09-15 15:08:382026-09-13 02:01:52USEDKEEP — primary key
host_726.org.InvoiceStaging.IX_AssetAudit2NONCLUSTERED00012never2026-09-13 02:01:52UNUSEDreview, then DROP
host_726.org.InvoiceStaging.PK_CustomerMonthly1CLUSTEREDYY00012never2026-09-13 02:01:52UNUSEDKEEP — primary key
host_726.org.StaffingAudit.PK_AssetLog1CLUSTEREDYY00014never2026-09-13 02:01:52UNUSEDKEEP — primary key
host_726.org.Level.PK_ShiftStaging1CLUSTEREDYY3858941775002026-09-16 01:00:292026-09-13 02:01:52USEDKEEP — primary key
host_726.org.Level.UX_SettlementHistory2NONCLUSTEREDYY078002026-09-15 08:54:052026-09-13 02:01:52USEDkeep — in use
host_726.org.ContractHistory.PK_RouteArchive1CLUSTEREDYY0000never2026-09-13 02:01:52UNUSEDKEEP — primary key
host_726.org.QuotaEntry.IX_AssetHistory2NONCLUSTERED0000never2026-09-13 02:01:52UNUSEDreview, then DROP
host_726.org.QuotaEntry.PK_LedgerQueue1CLUSTEREDYY0567945002026-09-16 00:52:522026-09-13 02:01:52USEDKEEP — primary key
host_726.org.ClaimQueue.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-13 02:01:53UNUSEDKEEP — primary key
host_726.org.SupplierLine.PK_InvoiceStatus1CLUSTEREDYY14905502929913042026-09-16 01:00:242026-09-13 02:01:53USEDKEEP — primary key
host_726.org.InvoiceHistory.PK_ContractDaily1CLUSTEREDYY011002026-09-12 10:31:132026-09-13 02:01:53USEDKEEP — primary key
host_726.org.AssetHeader.IX_PayrollAudit2NONCLUSTERED44204280010172026-09-16 01:00:242026-09-13 02:01:53USEDkeep — in use
host_726.org.AssetHeader.PK_LedgerResult1CLUSTEREDYY2030010172026-09-12 10:40:562026-09-13 02:01:53USEDKEEP — primary key
host_726.org.TerritoryStatus.PK_PayrollLine1CLUSTEREDYY0008never2026-09-13 02:01:53UNUSEDKEEP — primary key
host_726.org.RosterLine.PK_BillingDaily1CLUSTEREDYY0004never2026-09-13 02:01:53UNUSEDKEEP — primary key
host_726.org.ForecastArchive.PK_CampaignHeader1CLUSTEREDYY11954112002026-09-16 00:57:292026-09-13 02:01:53USEDKEEP — primary key
host_726.org.PolicySummary.PK_WarehouseSnapshot1CLUSTEREDYY4569451092026-09-16 01:00:242026-09-13 02:01:53USEDKEEP — primary key
host_726.org.ClaimMonthly.PK_RouteArchive1CLUSTEREDYY0000never2026-09-13 02:01:53UNUSEDKEEP — primary key
host_726.org.OrdersEntry.PK_MeterDaily1CLUSTEREDYY0274425002026-09-16 01:00:292026-09-13 02:01:53USEDKEEP — primary key
host_726.org.LedgerStaging.PK_BatchLine1CLUSTEREDYY0000never2026-09-13 02:01:53UNUSEDKEEP — primary key
host_726.org.Position.PK_PolicySummary1CLUSTEREDYY211297918594092026-09-16 01:00:352026-09-13 02:01:53USEDKEEP — primary key
host_726.org.Position.UX_MeterArchive2NONCLUSTEREDYY0009never2026-09-13 02:01:53UNUSEDreview carefully — unique
host_726.org.CampaignQueue.PK_BillingArchive1CLUSTEREDYY1564284879398122026-09-16 00:59:112026-09-13 02:01:53USEDKEEP — primary key
host_726.org.CampaignQueue.UX_TicketDaily2NONCLUSTEREDY511967560102026-09-16 01:00:342026-09-13 02:01:53USEDkeep — in use
host_726.org.MeterResult.PK_CatalogStaging1CLUSTEREDYY060202026-09-10 08:23:262026-09-13 02:01:53USEDKEEP — primary key
host_726.org.QuotaLine.PK_AssetAudit1CLUSTEREDYY255378172026-09-15 08:54:052026-09-13 02:01:53USEDKEEP — primary key
host_726.org.QuotaLine.UX_PricingAudit2NONCLUSTEREDYY0780172026-09-15 08:54:052026-09-13 02:01:53USEDkeep — in use
host_726.org.PayrollLog.PK_PayrollAudit1CLUSTEREDYY0187112026-09-07 14:08:502026-09-13 02:01:53USEDKEEP — primary key
host_726.org.PayrollLog.UX_PayrollDetail2NONCLUSTEREDY700112026-09-07 14:08:472026-09-13 02:01:53USEDkeep — in use
host_726.org.LedgerDaily.PK_ContractHeader1CLUSTEREDYY02092026-09-10 07:23:572026-09-13 02:01:53USEDKEEP — primary key
host_726.org.PricingArchive.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-13 02:01:53UNUSEDKEEP — primary key
host_726.org.PricingArchive.UX_InvoiceAudit2NONCLUSTEREDY0000never2026-09-13 02:01:53UNUSEDreview carefully — unique
host_726.org.ForecastAudit.PK_WarehouseSnapshot1CLUSTEREDYY0402002026-09-15 20:48:572026-09-13 02:01:53USEDKEEP — primary key
host_726.org.ForecastAudit.UX_ClaimArchive2NONCLUSTEREDY0000never2026-09-13 02:01:53UNUSEDreview carefully — unique
host_726.org.PayrollLine.PK_OrdersHistory1CLUSTEREDYY684402002026-09-15 20:53:502026-09-13 02:01:53USEDKEEP — primary key
host_726.org.PayrollLine.UX_ShiftLog2NONCLUSTEREDY0000never2026-09-13 02:01:53UNUSEDreview carefully — unique
host_726.org.BookingStaging.PK_AssetResult1CLUSTEREDYY2865947222938052026-09-16 01:00:352026-09-13 02:01:53USEDKEEP — primary key
host_726.org.ReconcileLine.PK_CustomerLog1CLUSTEREDYY0002never2026-09-15 02:02:24UNUSEDKEEP — primary key
host_726.org.ShiftStaging.PK_BillingHistory1CLUSTEREDYY0000never2026-09-13 02:01:54UNUSEDKEEP — primary key
host_726.org.ShiftStaging.UQ_PolicyAudit2NONCLUSTEREDY0000never2026-09-13 02:01:54UNUSEDreview carefully — unique
host_726.org.CustomerLine.IX_ForecastLine2NONCLUSTERED0000never2026-09-13 02:01:54UNUSEDreview, then DROP
host_726.org.CustomerLine.PK_LedgerEntry1CLUSTEREDYY213623002026-09-16 00:03:592026-09-13 02:01:54USEDKEEP — primary key
host_726.org.CustomerLine.UQ_PayrollLog3NONCLUSTEREDY0000never2026-09-13 02:01:54UNUSEDreview carefully — unique
host_726.org.InvoiceMonthly.PK_WarehouseQueue1CLUSTEREDYY0000never2026-09-13 02:01:54UNUSEDKEEP — primary key
host_726.org.InvoiceMonthly.UQ_MeterAudit2NONCLUSTEREDY0000never2026-09-13 02:01:54UNUSEDreview carefully — unique
host_726.org.QuotaStaging.PK_ShiftStaging1CLUSTEREDYY051362302026-09-16 00:03:592026-09-13 02:01:54USEDKEEP — primary key
host_726.org.QuotaStaging.UQ_ShiftMonthly2NONCLUSTEREDY136230002026-09-16 00:03:592026-09-13 02:01:54USEDkeep — in use
host_726.org.BatchMonthly.PK_WarehouseHeader1CLUSTEREDYY013489002026-09-16 00:03:592026-09-13 02:01:54USEDKEEP — primary key
host_726.org.BatchMonthly.UQ_LedgerStaging2NONCLUSTEREDY0000never2026-09-13 02:01:54UNUSEDreview carefully — unique
host_726.org.ClaimHeader.PK_ClaimArchive1CLUSTEREDYY0000never2026-09-13 02:01:54UNUSEDKEEP — primary key
host_726.org.SupplierResult.PK_ForecastQueue1CLUSTEREDYY3736514002026-09-15 23:22:432026-09-13 02:01:54USEDKEEP — primary key
host_726.org.RouteSummary.PK_RosterAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.RouteSummary.UX_SupplierSummary2NONCLUSTEREDYY0000neverneverCOLDreview carefully — unique
host_726.org.ClaimDetail.PK_RouteMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.ShiftResult.PK_ForecastEntry1CLUSTEREDYY148234201435479206082026-09-16 01:00:342026-09-15 02:02:24USEDKEEP — primary key
host_726.org.ShiftResult.UX_LedgerStaging2NONCLUSTEREDY1435504150206082026-09-16 01:00:342026-09-15 02:02:24USEDkeep — in use
host_726.org.QuotaResult.PK_CampaignDaily1CLUSTEREDYY421931149112026-09-16 01:00:242026-09-13 02:01:54USEDKEEP — primary key
host_726.org.QuotaResult.UX_BatchDaily2NONCLUSTEREDY10012026-09-15 20:22:482026-09-13 02:01:54USEDkeep — in use
host_726.org.QuotaDetail.PK_WarehouseMonthly1CLUSTEREDYY35105210042026-09-16 01:00:262026-09-13 02:01:54USEDKEEP — primary key
host_726.org.BookingLog.PK_MeterStaging1CLUSTEREDYY0004never2026-09-13 02:01:54UNUSEDKEEP — primary key
host_726.org.SettlementAudit.PK_InvoiceSnapshot1CLUSTEREDYY0001never2026-09-13 02:01:54UNUSEDKEEP — primary key
host_726.oth.QuotaSummary.PK_QuotaDetail1CLUSTEREDYY55002026-09-09 22:56:532026-09-13 02:01:55USEDKEEP — primary key
host_726.oth.InvoiceStatus.PK_ShiftQueue1CLUSTEREDYY67540002026-09-16 00:00:002026-09-13 02:01:55USEDKEEP — primary key
host_726.oth.SupplierLine.PK_QuotaDetail1CLUSTEREDYY03002026-09-09 22:56:532026-09-13 02:01:55USEDKEEP — primary key
host_726.oth.SupplierLine.UX_InvoiceHeader2NONCLUSTEREDY0000never2026-09-13 02:01:55UNUSEDreview carefully — unique
host_726.oth.StaffingArchive.IX_InvoiceStaging2NONCLUSTERED0000never2026-09-13 02:01:55UNUSEDreview, then DROP
host_726.oth.StaffingArchive.PK_PricingAudit1CLUSTEREDYY0000never2026-09-13 02:01:55UNUSEDKEEP — primary key
host_726.oth.StaffingArchive.UQ_SalesAudit3NONCLUSTEREDY15671002026-09-15 22:48:232026-09-13 02:01:55USEDkeep — in use
host_726.oth.CustomerQueue.IX_WarehouseResult2NONCLUSTERED85002026-09-09 22:56:532026-09-13 02:01:55USEDkeep — in use
host_726.oth.CustomerQueue.PK_TerritoryResult1CLUSTEREDYY019502026-09-09 22:56:532026-09-13 02:01:55USEDKEEP — primary key
host_726.rec.SettlementQueue.PK_BookingArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.rec.SettlementQueue.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_QuotaLine1CLUSTEREDYY02098509952026-09-16 00:59:112026-09-15 02:02:24USEDKEEP — primary key
host_726.sal.ClaimArchive.IX_RouteDetail2NONCLUSTERED0000never2026-09-13 02:01:56UNUSEDreview, then DROP
host_726.sal.ClaimArchive.PK_LedgerHeader1CLUSTEREDYY0000never2026-09-13 02:01:56UNUSEDKEEP — primary key
host_726.sal.QuotaLine.PK_ContractArchive1CLUSTEREDYY1025449039072026-09-16 01:01:002026-09-15 02:02:25USEDKEEP — primary key
host_726.sal.SalesStatus.PK_ShiftMonthly1CLUSTEREDYY1578747370752026-09-16 00:59:112026-09-15 02:02:25USEDKEEP — primary key
host_726.sal.SettlementQueue.PK_StaffingSnapshot1CLUSTEREDYY01738050685452026-09-16 00:59:112026-09-15 02:02:25USEDKEEP — primary key
host_726.sal.MeterHistory.PK_LedgerSnapshot1CLUSTEREDYY077880685452026-09-16 00:03:592026-09-15 02:02:25USEDKEEP — primary key
host_726.sal.ShipmentAudit.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.sal.RouteResult.PK_OrdersAudit1CLUSTEREDYY0169002026-09-15 20:53:482026-09-13 02:01:57USEDKEEP — primary key
host_726.sal.RouteResult.UX_ContractEntry2NONCLUSTEREDY0000never2026-09-13 02:01:57UNUSEDreview carefully — unique
host_726.sal.WarehouseDaily.PK_SettlementDetail1CLUSTEREDYY323024580142026-09-15 23:22:362026-09-13 02:01:57USEDKEEP — primary key
host_726.sal.WarehouseDaily.UX_BookingAudit2NONCLUSTEREDY200132026-09-09 15:48:182026-09-15 02:02:25USEDkeep — in use
host_726.sal.InvoiceLog.PK_MeterAudit1CLUSTEREDYY911790902026-09-15 20:53:482026-09-13 02:01:57USEDKEEP — primary key
host_726.sal.PolicySnapshot.PK_ReconcileQueue1CLUSTEREDYY020902026-09-09 15:55:252026-09-15 02:02:25USEDKEEP — primary key
host_726.sal.SettlementStatus.PK_ReconcileResult1CLUSTEREDYY6342325436232026-09-15 20:55:522026-09-15 02:02:25USEDKEEP — primary key
host_726.sal.SettlementStatus.UX_StaffingMonthly2NONCLUSTEREDY542106232026-09-15 20:55:522026-09-15 02:02:25USEDkeep — in use
host_726.sal.ReconcileHistory.PK_PayrollHeader1CLUSTEREDYY441181902026-09-15 20:53:482026-09-15 02:02:25USEDKEEP — primary key
host_726.sal.ReconcileHistory.UX_TicketQueue2NONCLUSTEREDY100902026-09-09 14:08:212026-09-15 02:02:25USEDkeep — in use
host_726.sal.InvoiceEntry.PK_RouteQueue1CLUSTEREDYY00090never2026-09-15 02:02:25UNUSEDKEEP — primary key
host_726.sal.BillingQueue.PK_ReconcileHistory1CLUSTEREDYY000621never2026-09-15 02:02:26UNUSEDKEEP — primary key
host_726.sal.RosterDetail.PK_BookingStaging1CLUSTEREDYY00014never2026-09-15 02:02:26UNUSEDKEEP — primary key
host_726.sal.RosterQueue.PK_ShiftQueue1CLUSTEREDYY06832002026-09-16 00:03:592026-09-13 02:01:57USEDKEEP — primary key
host_726.sal.RosterQueue.UX_RosterArchive2NONCLUSTEREDY0000never2026-09-13 02:01:57UNUSEDreview carefully — unique
host_726.sal.WarehouseHeader.PK_RouteEntry1CLUSTEREDYY0140002026-09-16 00:09:232026-09-13 02:01:57USEDKEEP — primary key
host_726.sal.SupplierArchive.PK_SupplierStaging1CLUSTEREDYY035002026-09-15 19:35:302026-09-13 02:01:57USEDKEEP — primary key
host_726.sal.RosterQueue.PK_PolicyLog1CLUSTEREDYY03002026-09-12 08:18:252026-09-13 02:01:58USEDKEEP — primary key
host_726.sal.CustomerSnapshot.PK_RosterEntry1CLUSTEREDYY035002026-09-15 19:35:302026-09-13 02:01:58USEDKEEP — primary key
host_726.sal.LedgerStatus.PK_WarehouseStaging1CLUSTEREDYY33002026-09-12 08:18:252026-09-13 02:01:58USEDKEEP — primary key
host_726.sal.BookingLine.PK_PricingAudit1CLUSTEREDYY0000never2026-09-13 02:01:58UNUSEDKEEP — primary key
host_726.sal.PricingLine.PK_BatchLine1CLUSTEREDYY0000never2026-09-13 02:01:58UNUSEDKEEP — primary key
host_726.sal.WarehouseStaging.PK_SettlementHistory1CLUSTEREDYY0000never2026-09-13 02:01:58UNUSEDKEEP — primary key
host_726.sal.StaffingArchive.PK_CatalogLine1CLUSTEREDYY0000never2026-09-13 02:01:58UNUSEDKEEP — primary key
host_726.sal.WarehouseSummary.PK_RosterArchive1CLUSTEREDYY0000never2026-09-13 02:01:58UNUSEDKEEP — primary key
host_726.schedule.CustomerDetail.PK_CatalogStaging1CLUSTEREDYY0173124945802026-09-16 01:00:262026-09-13 02:01:58USEDKEEP — primary key
host_726.schedule.CustomerDetail.UQ_BillingSnapshot3NONCLUSTEREDY1248542685002026-09-16 01:00:262026-09-13 02:01:58USEDkeep — in use
host_726.schedule.CustomerDetail.UQ_CampaignResult2NONCLUSTEREDY1249591269002026-09-16 01:00:262026-09-13 02:01:58USEDkeep — in use
host_726.schedule.InvoiceHistory.IX_StaffingHeader3NONCLUSTERED0000never2026-09-13 02:01:58UNUSEDreview, then DROP
host_726.schedule.InvoiceHistory.PK_ContractLog1CLUSTEREDYY0000never2026-09-13 02:01:58UNUSEDKEEP — primary key
host_726.schedule.InvoiceHistory.UQ_LedgerResult2NONCLUSTEREDY0000never2026-09-13 02:01:58UNUSEDreview carefully — unique
host_726.schedule.MeterStaging.PK_SettlementMonthly1CLUSTEREDYY1136538006652026-09-16 00:52:522026-09-13 02:01:58USEDKEEP — primary key
host_726.schedule.SettlementLine.PK_CampaignStatus1CLUSTEREDYY131216213402682026-09-16 01:00:472026-09-13 02:01:58USEDKEEP — primary key
host_726.schedule.TicketEntry.PK_CampaignDaily1CLUSTEREDYY13426802682026-09-15 22:54:012026-09-13 02:01:58USEDKEEP — primary key
host_726.schedule.QuotaSummary.PK_LedgerStatus1CLUSTEREDYY3146638170701402026-09-16 01:00:262026-09-13 02:01:58USEDKEEP — primary key
host_726.schedule.ShipmentLog.PK_SalesEntry1CLUSTEREDYY12673410013062026-09-16 01:00:262026-09-15 22:54:01USEDKEEP — primary key
host_726.schedule.PricingResult.PK_CampaignDaily1CLUSTEREDYY1248700106301342026-09-16 01:00:262026-09-13 02:01:58USEDKEEP — primary key
host_726.schedule.SupplierSnapshot.IX_BillingHeader3NONCLUSTERED2786510648042030112026-09-16 01:00:262026-09-15 22:54:03USEDkeep — in use
host_726.schedule.SupplierSnapshot.PK_AssetStatus1CLUSTEREDYY7200342236830295959154690432026-09-16 01:00:272026-09-15 22:54:02USEDKEEP — primary key
host_726.schedule.SupplierSnapshot.IX_ContractLog2NONCLUSTEREDY13893510024984702026-09-16 01:00:272026-09-15 22:54:03USEDkeep — in use
host_726.schedule.BatchDetail.PK_AssetDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.schedule.RosterSummary.IX_BatchDetail2NONCLUSTERED85523934284022727292026-09-16 00:52:522026-09-15 22:54:16USEDkeep — in use
host_726.schedule.RosterSummary.IX_ClaimHeader3NONCLUSTERED134823991411022727292026-09-16 01:00:472026-09-15 22:54:16USEDkeep — in use
host_726.schedule.RosterSummary.PK_CustomerAudit1CLUSTEREDYY3910837816962380245448812026-09-16 01:00:472026-09-15 22:54:16USEDKEEP — primary key
host_726.schedule.BillingDetail.IX_TicketHeader2NONCLUSTERED1658032764229095170702026-09-16 01:00:472026-09-15 22:54:11USEDkeep — in use
host_726.schedule.BillingDetail.PK_BillingLog1CLUSTEREDYY568978158889611698206112211692026-09-16 01:00:472026-09-15 22:54:11USEDKEEP — primary key
host_726.schedule.PolicyStatus.IX_ForecastAudit2NONCLUSTERED959237500197410732026-09-16 00:52:522026-09-15 22:54:06USEDkeep — in use
host_726.schedule.PolicyStatus.IX_SupplierLine3NONCLUSTERED147435451820197410732026-09-16 00:52:522026-09-15 22:54:07USEDkeep — in use
host_726.schedule.PolicyStatus.PK_PricingDaily1CLUSTEREDYY242006884749007072197410732026-09-16 00:52:522026-09-15 22:54:06USEDKEEP — primary key
host_726.schedule.PolicyLine.IX_TerritorySnapshot2NONCLUSTERED17746395269024478882026-09-16 00:52:522026-09-15 22:50:49USEDkeep — in use
host_726.schedule.PolicyLine.PK_BookingAudit1CLUSTEREDYY963616459455658441518432026-09-16 00:52:522026-09-15 22:50:49USEDKEEP — primary key
host_726.schedule.AssetResult.IX_BillingResult2NONCLUSTERED17975080017975082026-09-16 01:00:26neverUSEDkeep — in use
host_726.schedule.AssetResult.PK_TicketQueue1CLUSTEREDYY0001797508neverneverUNUSEDKEEP — primary key
host_726.schedule.InvoiceAudit.IX_StaffingQueue2NONCLUSTERED2541272787068165092026-09-16 00:52:522026-09-15 22:53:01USEDkeep — in use
host_726.schedule.InvoiceAudit.PK_LedgerMonthly1CLUSTEREDYY935391317573852968165092026-09-16 00:52:522026-09-15 22:53:01USEDKEEP — primary key
host_726.schedule.SettlementLog.IX_TicketLine2NONCLUSTERED1611794500227203622026-09-16 00:52:522026-09-15 22:54:01USEDkeep — in use
host_726.schedule.SettlementLog.IX_PolicyLine3NONCLUSTERED2578641920227203622026-09-16 00:52:522026-09-15 22:54:01USEDkeep — in use
host_726.schedule.SettlementLog.PK_CatalogMonthly1CLUSTEREDYY3056322581031846246394802026-09-16 00:52:522026-09-15 22:54:00USEDKEEP — primary key
host_726.schedule.ShiftHeader.IX_TicketStatus4NONCLUSTERED119294050762782026-09-14 08:43:332026-09-15 22:54:04USEDkeep — in use
host_726.schedule.ShiftHeader.IX_ShipmentLine3NONCLUSTERED122509012050762782026-09-16 01:00:472026-09-15 22:54:04USEDkeep — in use
host_726.schedule.ShiftHeader.PK_OrdersArchive1CLUSTEREDYY1291195031029381605588743742026-09-16 01:00:472026-09-15 22:54:01USEDKEEP — primary key
host_726.schedule.ShiftHeader.IX_BookingStatus2NONCLUSTEREDY164961874050762782026-09-15 22:55:312026-09-15 22:54:04USEDkeep — in use
host_726.schedule.PolicyLine.PK_RouteQueue1CLUSTEREDYY518491971754724050762452026-09-16 01:00:472026-09-15 22:54:07USEDKEEP — primary key
host_726.schedule.PolicyLine.UX_TerritoryHistory2NONCLUSTEREDYY0002544197never2026-09-15 22:55:43UNUSEDreview carefully — unique
host_726.schedule.RosterHistory.IX_AssetSummary2NONCLUSTERED959376164671025442162026-09-16 01:00:472026-09-15 22:52:39USEDkeep — in use
host_726.schedule.RosterHistory.PK_WarehouseLine1CLUSTEREDYY418611206426025442162026-09-16 01:00:472026-09-15 22:52:39USEDKEEP — primary key
host_726.schedule.MeterStaging.IX_PayrollAudit2NONCLUSTERED143582831342514025442182026-09-16 01:00:472026-09-15 22:54:00USEDkeep — in use
host_726.schedule.MeterStaging.PK_PolicyArchive1CLUSTEREDYY3184477050244825442182026-09-16 01:00:472026-09-15 22:54:00USEDKEEP — primary key
host_726.schedule.CustomerHistory.IX_LedgerQueue2NONCLUSTERED9511972402310147672402026-09-16 01:00:472026-09-15 22:55:11USEDkeep — in use
host_726.schedule.CustomerHistory.PK_PayrollAudit1CLUSTEREDYY23471030276134240147672402026-09-16 01:00:472026-09-15 22:55:11USEDKEEP — primary key
host_726.schedule.RosterResult.IX_BookingAudit2NONCLUSTERED532789068160102026-09-12 23:51:072026-09-15 22:53:54USEDkeep — in use
host_726.schedule.RosterResult.IX_AssetStaging3NONCLUSTERED3648924258068160102026-09-16 01:00:272026-09-15 22:53:54USEDkeep — in use
host_726.schedule.RosterResult.PK_PricingSummary1CLUSTEREDYY17539765322269750268160102026-09-16 01:00:482026-09-15 22:53:32USEDKEEP — primary key
host_726.schedule.LedgerSnapshot.PK_RouteStatus1CLUSTEREDYY88473776474330122026-09-16 01:00:262026-09-13 02:36:08USEDKEEP — primary key
host_726.schedule.LedgerSnapshot.IX_TicketLine2NONCLUSTEREDY1710122026-09-09 13:01:172026-09-13 02:36:08USEDkeep — in use
host_726.schedule.RosterHistory.PK_MeterLine1CLUSTEREDYY5093980106542026-09-16 01:00:472026-09-13 02:36:08USEDKEEP — primary key
host_726.schedule.AssetStaging.PK_CampaignResult1CLUSTEREDYY378126268506532026-09-16 01:00:262026-09-13 02:36:08USEDKEEP — primary key
host_726.schedule.InvoiceLog.PK_CatalogSummary1CLUSTEREDYY32801943797120589102026-09-16 01:00:352026-09-13 02:01:58USEDKEEP — primary key
host_726.schedule.InvoiceLog.IX_WarehouseHeader2NONCLUSTEREDY2059900102026-09-16 01:00:252026-09-13 02:01:58USEDkeep — in use
host_726.schedule.ContractResult.PK_StaffingSummary1CLUSTEREDYY03699310102026-09-16 01:00:352026-09-13 02:01:58USEDKEEP — primary key
host_726.schedule.ContractResult.UX_CampaignHistory2NONCLUSTEREDYY416611170102026-09-16 01:00:252026-09-13 02:01:58USEDkeep — in use
host_726.schedule.SalesArchive.IX_RosterStatus1CLUSTERED00010never2026-09-13 02:01:58UNUSEDKEEP — table storage
host_726.schedule.CatalogHistory.PK_OrdersStatus1CLUSTEREDYY20033012002026-09-16 01:00:242026-09-13 02:01:58USEDKEEP — primary key
host_726.schedule.CatalogHistory.IX_PricingStatus2NONCLUSTEREDY0000never2026-09-13 02:01:58UNUSEDreview carefully — unique
host_726.schedule.engine.PK_ReconcileDaily1CLUSTEREDYY204062691310368502026-09-16 01:00:272026-09-13 02:23:37USEDKEEP — primary key
host_726.schedule.engine.UQ_MeterQueue2NONCLUSTEREDY31037040002026-09-16 01:00:262026-09-13 02:23:37USEDkeep — in use
host_726.schedule.TerritoryAudit.PK_PayrollSnapshot1CLUSTEREDYY012295388017366012026-09-16 01:00:272026-09-15 02:11:29USEDKEEP — primary key
host_726.schedule.TerritoryAudit.UX_BookingHeader2NONCLUSTEREDYY29538800012173432026-09-16 01:00:272026-09-15 20:27:43USEDkeep — in use
host_726.schedule.WarehouseArchive.IX_CustomerHistory2NONCLUSTERED800025563992026-09-14 10:55:412026-09-15 23:32:01USEDkeep — in use
host_726.schedule.WarehouseArchive.IX_OrdersHeader3NONCLUSTERED130620025025563992026-09-16 01:00:262026-09-15 23:32:01USEDkeep — in use
host_726.schedule.WarehouseArchive.PK_RouteAudit1CLUSTEREDYY453254813062048345325582026-09-16 01:00:272026-09-15 10:27:24USEDKEEP — primary key
host_726.schedule.LedgerMonthly.IX_CatalogDaily2NONCLUSTERED00041529357neverneverUNUSEDreview, then DROP
host_726.schedule.LedgerMonthly.IX_CustomerMonthly3NONCLUSTERED1306200220415293572026-09-16 01:00:26neverUSEDkeep — in use
host_726.schedule.LedgerMonthly.PK_ClaimLine1CLUSTEREDYY62293993220622940222026-09-16 01:00:26neverUSEDKEEP — primary key
host_726.schedule.RouteAudit.IX_InvoiceHeader2NONCLUSTERED40013061962026-09-12 07:28:312026-09-15 14:01:40USEDkeep — in use
host_726.schedule.RouteAudit.IX_SettlementDetail3NONCLUSTEREDY02012781852026-09-08 09:05:17neverUSEDkeep — in use
host_726.schedule.RouteAudit.IX_CatalogArchive4NONCLUSTERED381981013061942026-09-16 00:58:432026-09-15 14:01:40USEDkeep — in use
host_726.schedule.RouteAudit.IX_QuotaStaging5NONCLUSTERED088013061942026-09-14 13:14:152026-09-15 14:01:41USEDkeep — in use
host_726.schedule.RouteAudit.PK_PayrollAudit1CLUSTEREDYY0162397713061942026-09-16 00:58:432026-09-15 14:01:40USEDKEEP — primary key
host_726.schedule.ShipmentHeader.IX_QuotaSnapshot2NONCLUSTERED00020764686never2026-09-15 02:15:24UNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_InvoiceSummary4NONCLUSTERED00020764686never2026-09-15 02:17:48UNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_CampaignHistory3NONCLUSTERED00020764686never2026-09-15 02:18:17UNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.PK_CampaignDetail1CLUSTEREDYY00020764686never2026-09-15 02:12:32UNUSEDKEEP — primary key
host_726.schedule.SupplierEntry.PK_AssetSnapshot1CLUSTEREDYY94742041002026-09-16 01:00:262026-09-13 02:25:59USEDKEEP — primary key
host_726.schedule.TerritoryDetail.PK_ReconcileMonthly1CLUSTEREDYY1900382026-09-12 14:11:242026-09-13 02:25:59USEDKEEP — primary key
host_726.schedule.StaffingEntry.PK_QuotaDetail1CLUSTEREDYY970775085332572026-09-16 01:00:262026-09-13 02:25:59USEDKEEP — primary key
host_726.schedule.StaffingEntry.UQ_TicketDetail2NONCLUSTEREDY1900192026-09-12 14:11:242026-09-13 02:25:59USEDkeep — in use
host_726.schedule.StaffingEntry.UX_PayrollDaily3NONCLUSTEREDYY18967163320382026-09-16 01:00:262026-09-13 02:25:59USEDkeep — in use
host_726.schedule.ForecastMonthly.IX_WarehouseDaily2NONCLUSTERED1800970774512026-09-14 15:35:262026-09-15 02:30:54USEDkeep — in use
host_726.schedule.ForecastMonthly.IX_PayrollHistory3NONCLUSTERED200970774512026-09-08 12:45:322026-09-15 02:34:54USEDkeep — in use
host_726.schedule.ForecastMonthly.IX_BatchMonthly4NONCLUSTERED42220970774512026-09-12 14:15:002026-09-15 02:37:55USEDkeep — in use
host_726.schedule.ForecastMonthly.PK_ForecastHistory1CLUSTEREDYY9707744238691941548932026-09-16 01:00:262026-09-15 02:18:18USEDKEEP — primary key
host_726.schedule.CatalogEntry.PK_PolicyDetail1CLUSTEREDYY189671630002026-09-16 01:00:262026-09-13 02:36:08USEDKEEP — primary key
host_726.schedule.CatalogEntry.UQ_AssetAudit2NONCLUSTEREDY0000never2026-09-13 02:36:08UNUSEDreview carefully — unique
host_726.schedule.ContractAudit.PK_TicketSummary1CLUSTEREDYY970774510002026-09-16 01:00:262026-09-13 02:36:08USEDKEEP — primary key
host_726.schedule.ContractAudit.UQ_OrdersStaging2NONCLUSTEREDY0000never2026-09-13 02:36:08UNUSEDreview carefully — unique
host_726.schedule.ContractAudit.UX_BillingSnapshot3NONCLUSTEREDYY189671630002026-09-16 01:00:262026-09-13 02:36:08USEDkeep — in use
host_726.schedule.SupplierSummary.PK_LedgerEntry1CLUSTEREDYY019002026-09-12 14:11:242026-09-13 02:36:08USEDKEEP — primary key
host_726.schedule.SupplierSummary.UQ_BillingStaging2NONCLUSTEREDY0000never2026-09-13 02:36:08UNUSEDreview carefully — unique
host_726.schedule.PayrollDaily.PK_CustomerQueue1CLUSTEREDYY13979015219988002026-09-16 00:52:522026-09-13 02:36:08USEDKEEP — primary key
host_726.schedule.WarehouseDaily.PK_QuotaAudit1CLUSTEREDYY190002026-09-12 14:11:242026-09-13 02:36:08USEDKEEP — primary key
host_726.schedule.WarehouseDaily.UQ_ShiftEntry2NONCLUSTEREDY0000never2026-09-13 02:36:08UNUSEDreview carefully — unique
host_726.schedule.WarehouseDaily.UX_TerritorySummary3NONCLUSTEREDYY190002026-09-12 14:11:242026-09-13 02:36:08USEDkeep — in use
host_726.schedule.sql.IX_PayrollEntry3NONCLUSTEREDY189671632801862026-09-16 01:00:262026-09-13 02:36:08USEDkeep — in use
host_726.schedule.sql.PK_ContractMonthly1CLUSTEREDYY557232671862026-09-14 15:35:262026-09-13 02:36:08USEDKEEP — primary key
host_726.schedule.sql.UQ_SalesStatus2NONCLUSTEREDY311163032026-09-14 14:07:232026-09-13 02:36:08USEDkeep — in use
host_726.schedule.LedgerStatus.PK_SettlementQueue1CLUSTEREDYY0000never2026-09-13 02:36:08UNUSEDKEEP — primary key
host_726.schedule.LedgerStatus.UQ_QuotaAudit2NONCLUSTEREDY0000never2026-09-13 02:36:08UNUSEDreview carefully — unique
host_726.schedule.OrdersQueue.PK_QuotaQueue1CLUSTEREDYY1900382026-09-12 14:11:242026-09-13 02:36:08USEDKEEP — primary key
host_726.schedule.LedgerStaging.IX_StaffingLog3NONCLUSTERED189677654806962026-09-16 01:00:262026-09-15 02:38:02USEDkeep — in use
host_726.schedule.LedgerStaging.PK_ContractQueue1CLUSTEREDYY9707816042189673096962026-09-16 01:00:262026-09-15 02:38:02USEDKEEP — primary key
host_726.schedule.LedgerStaging.UQ_TicketResult2NONCLUSTEREDY1163801862026-09-12 14:15:002026-09-15 02:38:02USEDkeep — in use
host_726.schedule.LedgerStaging.UX_QuotaHeader4NONCLUSTEREDYY000510never2026-09-15 02:38:02UNUSEDreview carefully — unique
host_726.schedule.step.PK_AssetStaging1CLUSTEREDYY202453810002026-09-16 01:00:272026-09-13 02:36:10USEDKEEP — primary key
host_726.schedule.step.UQ_AssetQueue3NONCLUSTEREDY0000never2026-09-13 02:36:10UNUSEDreview carefully — unique
host_726.schedule.step.UQ_OrdersLine2NONCLUSTEREDY01002026-09-11 20:30:272026-09-13 02:36:10USEDkeep — in use
host_726.schedule.ShipmentResult.PK_MeterSnapshot1CLUSTEREDYY1900382026-09-12 14:11:242026-09-13 02:36:10USEDKEEP — primary key
host_726.schedule.WarehouseEntry.PK_SettlementLine1CLUSTEREDYY9707749018967205002026-09-16 01:00:262026-09-13 02:36:10USEDKEEP — primary key
host_726.schedule.WarehouseEntry.UQ_ShiftSnapshot2NONCLUSTEREDY0000never2026-09-13 02:36:10UNUSEDreview carefully — unique
host_726.schedule.WarehouseEntry.UX_OrdersLog3NONCLUSTEREDYY0000never2026-09-13 02:36:10COLDreview carefully — unique
host_726.wps.ContractStatus.IX_RosterDaily3NONCLUSTERED1900134952026-09-07 10:44:392026-09-13 02:36:10USEDkeep — in use
host_726.wps.ContractStatus.PK_ClaimLog1CLUSTEREDYY01349519134952026-09-16 01:00:432026-09-13 02:36:10USEDKEEP — primary key
host_726.wps.ContractStatus.UX_TerritoryResult2NONCLUSTEREDYY0000never2026-09-13 02:36:10COLDreview carefully — unique
host_726.wps.ContractStatus.UX_SettlementDetail4NONCLUSTEREDY0000never2026-09-13 02:36:10UNUSEDreview carefully — unique
host_726.wps.PolicyResult.IX_ContractSnapshot2NONCLUSTERED0000never2026-09-13 02:36:10UNUSEDreview, then DROP
host_726.wps.PolicyResult.PK_SettlementLine1CLUSTEREDYY92817002026-09-15 23:07:272026-09-13 02:36:10USEDKEEP — primary key
host_726.wps.LedgerMonthly.PK_BookingResult1CLUSTEREDYY0000never2026-09-13 02:36:10UNUSEDKEEP — primary key
host_726.wps.BookingStaging.PK_ClaimHistory1CLUSTEREDYY07002026-09-15 09:15:442026-09-13 02:36:10USEDKEEP — primary key
host_726.wps.SalesHeader.PK_ContractHistory1CLUSTEREDYY0000never2026-09-13 02:36:10UNUSEDKEEP — primary key
host_726.wps.ForecastResult.PK_QuotaLog1CLUSTEREDYY4484380112026-09-16 01:00:242026-09-15 02:38:03USEDKEEP — primary key
host_726.wps.ForecastResult.UQ_ShipmentArchive4NONCLUSTEREDY451540012026-09-16 01:00:242026-09-15 02:38:03USEDkeep — in use
host_726.wps.StaffingResult.PK_RosterStatus1CLUSTEREDYY05938002026-09-16 01:00:592026-09-13 02:36:10USEDKEEP — primary key
host_726.wps.StaffingStaging.PK_PolicyEntry1CLUSTEREDYY0000never2026-09-13 02:36:10UNUSEDKEEP — primary key
host_726.wps.QuotaDetail.PK_BatchQueue1CLUSTEREDYY0000never2026-09-13 02:36:10UNUSEDKEEP — primary key
host_726.wps.OrdersLog.PK_WarehouseArchive1CLUSTEREDYY0000never2026-09-13 02:36:10UNUSEDKEEP — primary key
host_726.wps.TerritoryQueue.IX_InvoiceAudit11NONCLUSTERED556304982026-09-15 19:19:232026-09-15 02:38:03USEDkeep — in use
host_726.wps.TerritoryQueue.PK_RosterSnapshot1CLUSTEREDYY313017474982026-09-15 23:07:272026-09-15 02:38:03USEDKEEP — primary key
host_726.wps.TerritoryQueue.UX_MeterStaging2NONCLUSTEREDY12710670422026-09-15 23:07:272026-09-15 02:38:03USEDkeep — in use
host_726.wps.ContractEntry.PK_PayrollSummary1CLUSTEREDYY00077never2026-09-15 02:38:03UNUSEDKEEP — primary key
host_726.wps.TicketStatus.PK_InvoiceMonthly1CLUSTEREDYY01192002026-09-15 23:07:272026-09-13 02:36:10USEDKEEP — primary key
host_726.wps.SalesDetail.PK_SettlementLine1CLUSTEREDYY0001never2026-09-15 02:38:03UNUSEDKEEP — primary key
host_726.wps.ClaimResult.PK_TicketEntry1CLUSTEREDYY199002026-09-15 09:43:252026-09-13 02:36:10USEDKEEP — primary key
host_726.wps.CatalogSnapshot.PK_ForecastHeader1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host_726.wps.BillingLine.PK_RosterResult1CLUSTEREDYY7434002026-09-15 20:41:342026-09-13 02:36:11USEDKEEP — primary key
host_726.wps.BillingLine.UX_WarehouseLog2NONCLUSTEREDYY0000never2026-09-13 02:36:11COLDreview carefully — unique
host_726.wps.BatchStatus.PK_ClaimLine1CLUSTEREDYY0940136502026-09-15 23:07:272026-09-13 02:36:11USEDKEEP — primary key
host_726.wps.BatchStatus.UQ_CustomerHeader2NONCLUSTEREDY13650002026-09-15 23:07:272026-09-13 02:36:11USEDkeep — in use
host_726.wps.BookingResult.PK_WarehouseMonthly1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
host_726.wps.BookingStaging.PK_ForecastLog1CLUSTEREDYY0000never2026-09-13 02:36:11UNUSEDKEEP — primary key
ASSET_Prod.dbo.PricingHeader.IX_StaffingHeader3NONCLUSTERED000130never2026-08-24 12:48:18UNUSEDreview, then DROP
ASSET_Prod.dbo.PricingHeader.IX_QuotaAudit4NONCLUSTERED000130never2026-08-24 12:48:18UNUSEDreview, then DROP
ASSET_Prod.dbo.PricingHeader.PK_CatalogDaily1CLUSTEREDYY23329433803702026-09-15 21:55:282026-08-24 12:50:52USEDKEEP — primary key
ASSET_Prod.dbo.PricingHeader.UX_QuotaMonthly2NONCLUSTEREDY000130never2026-08-24 12:48:18UNUSEDreview carefully — unique
ASSET_Prod.dbo.RouteSnapshot.IX_ContractHeader2NONCLUSTERED0000never2026-07-29 08:14:24COLDreview, then DROP
ASSET_Prod.dbo.RouteSnapshot.PK_ContractStatus1CLUSTEREDYY01748002026-09-15 17:22:46neverUSEDKEEP — primary key
ASSET_Prod.dbo.RouteArchive.IX_ShiftDaily2NONCLUSTERED0000neverneverCOLDreview, then DROP
ASSET_Prod.dbo.RouteArchive.PK_SupplierResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET_Prod.dbo.AssetEntry.IX_TerritoryDetail2NONCLUSTERED0000never2026-07-29 09:40:40COLDreview, then DROP
ASSET_Prod.dbo.AssetEntry.PK_StaffingSummary1CLUSTEREDYY014002026-09-14 13:17:48neverUSEDKEEP — primary key
ASSET_Prod.dbo.BookingSnapshot.IX_RouteLine2NONCLUSTERED0000never2026-07-29 08:14:24COLDreview, then DROP
ASSET_Prod.dbo.BookingSnapshot.PK_TicketHistory1CLUSTEREDYY032012026-09-15 15:39:43neverUSEDKEEP — primary key
ASSET_Prod.dbo.SalesEntry.PK_BookingAudit1CLUSTEREDYY001102026-09-15 10:01:08neverUSEDKEEP — primary key
ASSET_Prod.dbo.SalesEntry.UX_ShiftSnapshot2NONCLUSTEREDY110002026-09-15 10:01:082026-07-29 08:09:18USEDkeep — in use
ASSET_Prod.dbo.RosterDaily.IX_RouteLine2NONCLUSTERED110002026-09-14 13:17:482026-07-29 09:40:40USEDkeep — in use
ASSET_Prod.dbo.RosterDaily.IX_ShiftHeader3NONCLUSTERED0000never2026-07-29 09:40:40COLDreview, then DROP
ASSET_Prod.dbo.RosterDaily.PK_MeterQueue1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET_Prod.dbo.RosterHeader.IX_ShipmentLog2NONCLUSTERED0000never2026-07-29 09:40:40COLDreview, then DROP
ASSET_Prod.dbo.RosterHeader.PK_RosterMonthly1CLUSTEREDYY012002026-09-14 13:17:48neverUSEDKEEP — primary key
ASSET_Prod.dbo.ContractStaging.IX_InvoiceLog2NONCLUSTERED0000never2026-07-29 08:14:24COLDreview, then DROP
ASSET_Prod.dbo.ContractStaging.PK_TerritorySnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET_Prod.dbo.BookingEntry.IX_ShipmentStatus2NONCLUSTERED000370never2026-08-21 16:55:04UNUSEDreview, then DROP
ASSET_Prod.dbo.BookingEntry.PK_SettlementQueue1CLUSTEREDYY0113703702026-09-15 21:55:06neverUSEDKEEP — primary key
ASSET_Prod.dbo.ReconcileMonthly.IX_ForecastDetail2NONCLUSTERED0002never2026-07-29 08:14:24UNUSEDreview, then DROP
ASSET_Prod.dbo.ReconcileMonthly.IX_QuotaSummary9NONCLUSTEREDY0002never2026-07-29 08:51:33UNUSEDreview, then DROP
ASSET_Prod.dbo.ReconcileMonthly.PK_SettlementDetail1CLUSTEREDYY019010022026-09-15 21:55:282026-07-29 09:58:28USEDKEEP — primary key
ASSET_Prod.dbo.ReconcileMonthly.UX_CustomerDetail3NONCLUSTEREDYY0002never2026-07-29 08:15:18UNUSEDreview carefully — unique
ASSET_Prod.dbo.CampaignHeader.IX_SupplierResult2NONCLUSTERED000308never2026-08-28 09:23:30UNUSEDreview, then DROP
ASSET_Prod.dbo.CampaignHeader.PK_ShiftHeader1CLUSTEREDYY322111303402026-09-15 21:55:062026-08-28 09:24:14USEDKEEP — primary key
ASSET_Prod.dbo.DOB.IX_CustomerSummary2NONCLUSTERED0000never2026-07-30 11:02:10COLDreview, then DROP
ASSET_Prod.dbo.DOB.PK_AssetStatus1CLUSTEREDYY03002026-09-10 13:28:072026-07-31 02:39:58USEDKEEP — primary key
ASSET_Prod.dbo.ShipmentLog.IX_ReconcileStatus2NONCLUSTERED0000never2026-07-29 09:41:32COLDreview, then DROP
ASSET_Prod.dbo.ShipmentLog.PK_ClaimHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET_Prod.dbo.BookingSnapshot.IX_ClaimStaging3NONCLUSTERED0000never2026-07-29 09:40:41COLDreview, then DROP
ASSET_Prod.dbo.BookingSnapshot.PK_RosterSummary1CLUSTEREDYY03002026-09-10 13:28:072026-07-29 09:41:31USEDKEEP — primary key
ASSET_Prod.dbo.BookingSnapshot.UX_RosterStaging2NONCLUSTEREDY0000never2026-07-29 09:40:41COLDreview carefully — unique
ASSET_Prod.dbo.RosterStaging.IX_BatchArchive2NONCLUSTERED0000neverneverCOLDreview, then DROP
ASSET_Prod.dbo.RosterStaging.PK_SupplierStatus1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET_Prod.dbo.BatchLog.IX_LedgerHistory2NONCLUSTERED0000never2026-07-30 11:02:10COLDreview, then DROP
ASSET_Prod.dbo.BatchLog.IX_TerritoryArchive3NONCLUSTERED0000never2026-07-30 11:02:10COLDreview, then DROP
ASSET_Prod.dbo.BatchLog.PK_ClaimLog1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET_Prod.dbo.ForecastDetail.IX_CampaignStatus2NONCLUSTERED0000never2026-07-29 08:16:57COLDreview, then DROP
ASSET_Prod.dbo.ForecastDetail.PK_BillingHistory1CLUSTEREDYY0807002026-09-15 21:55:052026-07-29 08:16:57USEDKEEP — primary key
ASSET_Prod.dbo.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0776002026-09-15 17:22:46neverUSEDKEEP — primary key
ASSET_Prod.dbo.CustomerEntry.IX_ShiftDaily3NONCLUSTERED0000never2026-07-31 02:41:20COLDreview, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_ClaimHistory5NONCLUSTERED0000never2026-07-31 02:41:20COLDreview, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_StaffingLine4NONCLUSTERED0000never2026-07-31 02:41:20COLDreview, then DROP
ASSET_Prod.dbo.CustomerEntry.IX_CatalogLog2NONCLUSTERED0000never2026-07-31 02:41:06COLDreview, then DROP
ASSET_Prod.dbo.CustomerEntry.PK_CampaignHistory1CLUSTEREDYY02002026-09-10 13:28:012026-07-31 02:41:20USEDKEEP — primary key
ASSET_Prod.dbo.RosterSummary.IX_ForecastSnapshot2NONCLUSTERED0000neverneverCOLDreview, then DROP
ASSET_Prod.dbo.SalesSnapshot.IX_BillingQueue3NONCLUSTERED6360002026-09-15 21:44:322026-07-29 11:14:33USEDkeep — in use
ASSET_Prod.dbo.SalesSnapshot.IX_TicketResult4NONCLUSTEREDY0000never2026-07-31 11:16:08COLDreview, then DROP
ASSET_Prod.dbo.SalesSnapshot.PK_WarehouseLog1CLUSTEREDYY00209002026-09-15 17:27:542026-07-31 11:16:08USEDKEEP — primary key
ASSET_Prod.dbo.SalesSnapshot.UX_ShiftResult2NONCLUSTEREDY20900002026-09-15 17:27:542026-07-29 11:14:33USEDkeep — in use
ASSET_Prod.dbo.RouteHistory.PK_BillingArchive1CLUSTEREDYY46470002026-09-15 17:24:322026-07-29 08:07:17USEDKEEP — primary key