Index Usage — ACME-198-51-100-45
DBA BrainIndex UsageACME-198-51-100-45snapshot 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-45

Host: 198.51.100.45

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

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

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_total1664every index on a CatalogHistory table
used773had a seek, scan or lookup
unused682written but never read
cold209never read AND never written since restart
disabled0ALTER INDEX ... DISABLE was run
droppable82nonclustered, not unique, no constraint, never read
fragmented12above the rebuild threshold

By database

DatabaseTotalColdDisabledDroppableRecommend action
QUOTA328107029review the drop candidates above
ASSET58915027review the drop candidates above
host_72655946025review 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

Drop candidates (82)

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.ForecastMonthly.IX_BatchMonthly5209454neverUNUSEDreview, then DROP
host_726.schedule.LedgerMonthly.IX_CatalogDaily1728764neverUNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_QuotaSnapshot864382neverUNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_InvoiceSummary864382neverUNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_CampaignHistory864382neverUNUSEDreview, then DROP
ASSET.schedule.LedgerMonthly.IX_CatalogDaily629488neverUNUSEDreview, then DROP
ASSET.schedule.ShipmentHeader.IX_InvoiceSummary314748neverUNUSEDreview, then DROP
host_726.wps.ContractStatus.IX_RosterDaily82183neverUNUSEDreview, then DROP
host_726.schedule.WarehouseArchive.IX_CustomerHistory65501neverUNUSEDreview, then DROP
ASSET.schedule.WarehouseArchive.IX_CustomerHistory28181neverUNUSEDreview, then DROP
host_726.emp.SalesHeader.IX_BookingSummary921neverUNUSEDreview, then DROP
ASSET.emp.SalesHeader.IX_BookingSummary700neverUNUSEDreview, then DROP
ASSET.emp.OrdersMonthly.IX_QuotaArchive379neverUNUSEDreview, then DROP
host_726.emp.SupplierStaging.IX_StaffingEntry232neverUNUSEDreview, then DROP
ASSET.emp.SupplierStaging.IX_StaffingEntry206neverUNUSEDreview, then DROP
ASSET.emp.StaffingMonthly.IX_ReconcileEntry92neverUNUSEDreview, then DROP
ASSET.dbo.BatchResult.IX_SettlementStaging29neverUNUSEDreview, then DROP
ASSET.dbo.BatchResult.IX_ReconcileEntry29neverUNUSEDreview, then DROP
ASSET.dbo.CustomerArchive.IX_BillingHeader29neverUNUSEDreview, then DROP
ASSET.emp.TicketAudit.IX_LedgerLog10neverUNUSEDreview, then DROP
ASSET.org.RosterMonthly.IX_AssetDetail10neverUNUSEDreview, then DROP
ASSET.org.InvoiceStaging.IX_AssetAudit10neverUNUSEDreview, then DROP
host_726.org.RosterMonthly.IX_AssetDetail8neverUNUSEDreview, then DROP
host_726.org.InvoiceStaging.IX_AssetAudit8neverUNUSEDreview, then DROP
ASSET.schedule.SalesDaily.IX_QuotaSummary6neverUNUSEDreview, then DROP
host_726.schedule.ContractStaging.IX_ShiftSummary2neverUNUSEDreview, then DROP
host_726.schedule.SupplierEntry.IX_StaffingDaily2neverUNUSEDreview, then DROP
host-877.dbo.QuotaArchive.IX_InvoiceAudit0neverUNUSEDreview, then DROP
host_726.dbo.QuotaArchive.IX_InvoiceAudit0neverUNUSEDreview, then DROP
host_726.org.QuotaEntry.IX_AssetHistory0neverUNUSEDreview, 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
QUOTA.emp.BillingQueue.IX_ContractSummary0neverUNUSEDreview, then DROP
QUOTA.org.PolicySummary.IX_AssetEntry0neverUNUSEDreview, 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.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
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
host_726.org.SupplierHistory.IX_ShipmentSummary0neverUNUSEDreview, then DROP
host_726.org.BillingHeader.IX_ShiftHistory0neverUNUSEDreview, then DROP
host_726.org.ShipmentSummary.IX_StaffingResult0neverUNUSEDreview, 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.CampaignHistory.IX_QuotaDetail0neverUNUSEDreview, then DROP
QUOTA.emp.QuotaMonthly.IX_ShipmentEntry0neverUNUSEDreview, then DROP
QUOTA.emp.MeterHistory.IX_ContractArchive0neverUNUSEDreview, 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.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.org.SupplierHistory.IX_ShipmentSummary0neverUNUSEDreview, then DROP
ASSET.org.BillingHeader.IX_ShiftHistory0neverUNUSEDreview, then DROP
ASSET.org.ShipmentSummary.IX_StaffingResult0neverUNUSEDreview, then DROP
ASSET.oth.StaffingArchive.IX_InvoiceStaging0neverUNUSEDreview, then DROP
ASSET.sal.ClaimArchive.IX_RouteDetail0neverUNUSEDreview, 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
QUOTA.org.SupplierHistory.IX_ShipmentSummary0neverCOLDreview, then DROP
QUOTA.org.BillingHeader.IX_ShiftHistory0neverCOLDreview, then DROP
QUOTA.org.ShipmentSummary.IX_StaffingResult0neverCOLDreview, then DROP

Fragmented (12)

Total 1,167.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
ASSET\schedule.ShiftHeader.IX_TicketStatus#p2222/22NONCLUSTERED99.3%3,53927.62026-09-15 03:42:01REBUILD
ASSET\schedule.ShiftHeader.IX_ShipmentLine#p2222/22NONCLUSTERED99.3%5,30741.52026-09-15 03:42:01REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus1/1NONCLUSTERED99.1%39,325307.22026-09-16 01:00:47REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine1/1NONCLUSTERED99.0%58,935460.42026-09-16 01:00:47REBUILD
host_726\schedule.RouteAudit.IX_InvoiceHeader1/1NONCLUSTERED96.5%1,67913.12026-09-16 01:01:00REBUILD
ASSET\schedule.SettlementLog.PK_CatalogMonthly#p1616/22CLUSTERED56.1%13,222103.32026-09-16 01:00:51REORGANIZE
ASSET\schedule.SettlementLog.IX_TicketLine#p1616/22NONCLUSTERED54.4%3,02723.62026-09-16 01:00:52REORGANIZE
ASSET\schedule.SettlementLog.IX_PolicyLine#p1616/22NONCLUSTERED54.3%2,25817.62026-09-16 01:00:52REORGANIZE
ASSET\schedule.RosterResult.PK_PricingSummary#p1616/22CLUSTERED36.5%8,08363.12026-09-15 03:47:05REORGANIZE
ASSET\schedule.RosterResult.IX_AssetStaging#p1616/22NONCLUSTERED34.3%1,58412.42026-09-15 03:47:51REORGANIZE
ASSET\schedule.ShipmentHeader.IX_QuotaSnapshot1/1NONCLUSTERED32.9%1,47611.52026-09-15 03:48:03REORGANIZE
ASSET\schedule.PolicyStatus.PK_PricingDaily#p1616/22CLUSTERED30.8%11,08786.62026-09-16 01:01:01REORGANIZE

All indexes (1664)

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_SettlementResult1CLUSTEREDYY86127172689143292026-09-15 15:10:202026-09-16 01:00:04USEDKEEP — primary key
host-877.app.ShiftAudit.UX_PayrollAudit2NONCLUSTEREDY1131053903182026-09-15 15:10:202026-09-16 01:00:04USEDkeep — in use
host-877.app.ShiftAudit.UX_ContractSummary25NONCLUSTEREDYY90092026-08-29 14:04:402026-09-16 01:00:04USEDkeep — in use
host-877.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-877.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY000316never2026-09-16 01:00:05UNUSEDKEEP — primary key
host-877.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY00016040never2026-09-16 01:00:06UNUSEDKEEP — primary key
host-877.app.App.PK_InvoiceResult1CLUSTEREDYY02836002026-09-15 15:08:572026-09-13 03:30:04USEDKEEP — primary key
host-877.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-877.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY14051477201302026-09-15 15:09:002026-09-16 01:00:06USEDKEEP — primary key
host-877.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY000129never2026-09-16 01:00:06UNUSEDKEEP — primary key
host-877.app.Group.PK_BookingEntry1CLUSTEREDYY13054155082026-09-15 15:08:572026-09-13 03:30:04USEDKEEP — primary key
host-877.app.Group.UX_LedgerSummary2NONCLUSTEREDY0008never2026-09-13 03:30:04UNUSEDreview carefully — unique
host-877.app.PricingLog.PK_AssetResult1CLUSTEREDYY3422201662026-09-15 15:08:572026-09-16 01:00:06USEDKEEP — primary key
host-877.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY01501002026-09-15 10:27:012026-09-13 03:30:04USEDKEEP — primary key
host-877.app.WarehouseStatus.UX_QuotaLine2NONCLUSTEREDY130384250652026-09-15 15:08:572026-09-16 01:00:06USEDkeep — in use
host-877.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY4883404872026-09-15 15:09:002026-09-16 01:00:06USEDKEEP — primary key
host-877.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY000394never2026-09-16 01:00:06UNUSEDKEEP — primary key
host-877.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY9416876062026-09-15 15:09:002026-09-13 03:30:05USEDKEEP — primary key
host-877.app.CatalogMonthly.PK_ClaimHeader1CLUSTEREDYY5725895142026-09-15 15:09:002026-09-15 01:00:06USEDKEEP — primary key
host-877.app.CatalogMonthly.UX_RouteQueue5NONCLUSTEREDY33461032026-09-15 10:27:012026-09-15 01:00:06USEDkeep — in use
host-877.app.ClaimResult.PK_ShipmentStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-877.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-13 03:30:05UNUSEDKEEP — primary key
host-877.dbo.QuotaArchive.IX_AssetResult1CLUSTEREDYY0000never2026-09-13 03:30:05UNUSEDKEEP — primary key
host-877.dbo.QuotaArchive.IX_InvoiceAudit2NONCLUSTERED0000never2026-09-13 03:30:05UNUSEDreview, then DROP
host-400.app.ShiftAudit.PK_SettlementResult1CLUSTEREDYY0000never2026-09-13 03:30:06UNUSEDKEEP — primary key
host-400.app.ShiftAudit.UX_PayrollAudit2NONCLUSTEREDY0000never2026-09-13 03:30:06UNUSEDreview carefully — unique
host-400.app.ShiftAudit.UX_ContractSummary25NONCLUSTEREDYY0000never2026-09-13 03:30:06UNUSEDreview carefully — unique
host-400.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-400.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY0000never2026-09-13 03:30:07UNUSEDKEEP — primary key
host-400.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY0000never2026-09-13 03:30:07UNUSEDKEEP — primary key
host-400.app.App.PK_InvoiceResult1CLUSTEREDYY0000never2026-09-13 03:30:07UNUSEDKEEP — primary key
host-400.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-400.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY0000never2026-09-13 03:30:07UNUSEDKEEP — primary key
host-400.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY0000never2026-09-13 03:30:07UNUSEDKEEP — primary key
host-400.app.Group.PK_BookingEntry1CLUSTEREDYY0000never2026-09-13 03:30:07UNUSEDKEEP — primary key
host-400.app.Group.UX_LedgerSummary2NONCLUSTEREDY0000never2026-09-13 03:30:07UNUSEDreview carefully — unique
host-400.app.PricingLog.PK_AssetResult1CLUSTEREDYY0000never2026-09-13 03:30:07UNUSEDKEEP — primary key
host-400.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY0000never2026-09-13 03:30:07UNUSEDKEEP — primary key
host-400.app.WarehouseStatus.UX_QuotaLine2NONCLUSTEREDY0000never2026-09-13 03:30:07UNUSEDreview carefully — unique
host-400.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY0000never2026-09-13 03:30:07UNUSEDKEEP — primary key
host-400.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY0000never2026-09-13 03:30:08UNUSEDKEEP — primary key
host-400.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY0000never2026-09-13 03:30:08UNUSEDKEEP — primary key
host-400.app.CatalogMonthly.PK_ClaimHeader1CLUSTEREDYY0000never2026-09-13 03:30:08UNUSEDKEEP — primary key
host-400.app.CatalogMonthly.UX_RouteQueue5NONCLUSTEREDY0000never2026-09-13 03:30:08UNUSEDreview carefully — unique
host-400.app.ClaimResult.PK_ShipmentStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-400.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-13 03:30:08UNUSEDKEEP — primary key
host-727.app.ShiftAudit.PK_SettlementResult1CLUSTEREDYY310471793541322026-09-15 21:00:002026-09-16 01:00:07USEDKEEP — primary key
host-727.app.ShiftAudit.UX_PayrollAudit2NONCLUSTEREDY112531701322026-09-15 16:22:312026-09-16 01:00:07USEDkeep — in use
host-727.app.ShiftAudit.UX_ContractSummary11NONCLUSTEREDYY0000neverneverCOLDreview carefully — unique
host-727.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-727.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY000114never2026-09-16 01:00:08UNUSEDKEEP — primary key
host-727.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY000365never2026-09-16 01:00:08UNUSEDKEEP — primary key
host-727.app.App.PK_InvoiceResult1CLUSTEREDYY02208002026-09-15 16:22:312026-09-13 03:30:10USEDKEEP — primary key
host-727.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-727.app.CampaignDetail.PK_PolicyLine1CLUSTEREDYY0000never2026-09-13 03:30:10UNUSEDKEEP — primary key
host-727.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY125132492002026-09-15 16:24:062026-09-13 03:30:10USEDKEEP — primary key
host-727.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY0000never2026-09-13 03:30:10UNUSEDKEEP — primary key
host-727.app.Group.PK_BookingEntry1CLUSTEREDYY1168756022026-09-15 16:24:062026-09-13 03:30:10USEDKEEP — primary key
host-727.app.Group.UX_LedgerSummary6NONCLUSTEREDY0002never2026-09-13 03:30:10UNUSEDreview carefully — unique
host-727.app.PricingLog.PK_AssetResult1CLUSTEREDYY248700202026-09-15 16:22:312026-09-13 03:30:10USEDKEEP — primary key
host-727.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY0740002026-09-15 15:54:452026-09-13 03:30:10USEDKEEP — primary key
host-727.app.WarehouseStatus.UX_QuotaLine8NONCLUSTEREDY130666750102026-09-15 16:24:062026-09-13 03:30:10USEDkeep — in use
host-727.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY391900102026-09-15 16:22:312026-09-13 03:30:10USEDKEEP — primary key
host-727.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY00010never2026-09-13 03:30:10UNUSEDKEEP — primary key
host-727.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY24665667082026-09-15 16:22:312026-09-13 03:30:10USEDKEEP — primary key
host-727.app.CatalogMonthly.PK_ClaimHeader1CLUSTEREDYY31311613032026-09-15 16:22:312026-09-13 03:30:11USEDKEEP — primary key
host-727.app.CatalogMonthly.UX_RouteQueue7NONCLUSTEREDY50022026-09-10 14:15:062026-09-13 03:30:11USEDkeep — in use
host-727.app.ClaimResult.PK_ShipmentStaging1CLUSTEREDYY0000never2026-09-13 03:30:11UNUSEDKEEP — primary key
host-727.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-13 03:30:11UNUSEDKEEP — primary key
host-727.org.CatalogQueue.PK_RouteAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-727.org.SalesArchive.PK_TicketDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host-931.dbo.CampaignStaging.PK_BookingDaily1CLUSTEREDYY01002026-09-10 15:37:42neverUSEDKEEP — primary key
host_726.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-13 03:30:12UNUSEDKEEP — primary key
host_726.cfg.QuotaStatus.UX_MeterSummary2NONCLUSTEREDY0000never2026-09-13 03:30:12UNUSEDreview carefully — unique
host_726.dbo.ContractResult.PK_CampaignResult1CLUSTEREDYY0280282026-09-15 02:15:022026-09-13 03:30:12USEDKEEP — primary key
host_726.dbo.SettlementStaging.PK_TicketStaging1CLUSTEREDYY00028never2026-09-16 01:00:09UNUSEDKEEP — 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_ShiftStatus1CLUSTEREDYY46007158002026-09-15 15:12:252026-09-13 03:30:12USEDKEEP — primary key
host_726.dbo.WarehouseEntry.UX_CampaignHeader2NONCLUSTEREDY0000never2026-09-13 03:30:12UNUSEDreview carefully — unique
host_726.dbo.TicketSummary.PK_SalesLine1CLUSTERED06603002026-09-15 10:13:542026-09-13 03:30:12USEDKEEP — table storage
host_726.dbo.TerritoryEntry.PK_SalesSummary1CLUSTEREDYY1389295002026-09-15 15:10:202026-09-13 03:30:12USEDKEEP — primary key
host_726.dbo.TerritoryEntry.UX_TerritoryQueue2NONCLUSTEREDY0000never2026-09-13 03:30:12UNUSEDreview carefully — unique
host_726.dbo.PolicyEntry.PK_TicketEntry1CLUSTEREDYY7006187002026-09-15 15:12:252026-09-13 03:30:12USEDKEEP — primary key
host_726.dbo.PolicyEntry.UX_PolicyAudit2NONCLUSTEREDY0000never2026-09-13 03:30:12UNUSEDreview carefully — unique
host_726.dbo.CampaignHeader.PK_InvoiceSnapshot1CLUSTEREDYY21756191002026-09-15 15:12:252026-09-13 03:30:13USEDKEEP — primary key
host_726.dbo.CampaignHeader.UX_BillingLog2NONCLUSTEREDY0000never2026-09-13 03:30:13UNUSEDreview carefully — unique
host_726.dbo.WarehouseHeader.PK_OrdersQueue1CLUSTEREDYY0132002026-09-15 15:12:252026-09-13 03:30:13USEDKEEP — primary key
host_726.dbo.WarehouseHeader.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-13 03:30:13UNUSEDreview carefully — unique
host_726.dbo.RouteQueue.PK_SupplierAudit1CLUSTEREDYY1394595002026-09-15 15:10:202026-09-13 03:30:13USEDKEEP — primary key
host_726.dbo.RouteQueue.UX_CampaignQueue2NONCLUSTEREDY0000never2026-09-13 03:30:13UNUSEDreview carefully — unique
host_726.dbo.CampaignAudit.PK_BatchSnapshot1CLUSTEREDYY6967187002026-09-15 15:12:252026-09-13 03:30:13USEDKEEP — primary key
host_726.dbo.CampaignAudit.UX_SupplierArchive2NONCLUSTEREDY0000never2026-09-13 03:30:13UNUSEDreview carefully — unique
host_726.dbo.ShiftDaily.PK_ReconcileStatus1CLUSTEREDYY1399283002026-09-15 15:10:202026-09-13 03:30:13USEDKEEP — primary key
host_726.dbo.ShiftDaily.UX_RouteDaily2NONCLUSTEREDY0000never2026-09-13 03:30:13UNUSEDreview carefully — unique
host_726.dbo.QuotaArchive.IX_AssetResult1CLUSTEREDYY0000never2026-09-13 03:30:12UNUSEDKEEP — primary key
host_726.dbo.QuotaArchive.IX_InvoiceAudit2NONCLUSTERED0000never2026-09-13 03:30:12UNUSEDreview, then DROP
host_726.emp.WarehouseMonthly.PK_PricingHistory1CLUSTEREDYY6778509002026-09-15 15:02:072026-09-13 03:30:13USEDKEEP — primary key
host_726.emp.WarehouseMonthly.UX_CustomerDetail2NONCLUSTEREDYY0000never2026-09-13 03:30:13UNUSEDreview carefully — unique
host_726.emp.SettlementLine.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-13 03:30:13UNUSEDKEEP — primary key
host_726.emp.SalesDetail.PK_BillingLog1CLUSTEREDYY01369002026-09-16 00:59:492026-09-13 03:30:13USEDKEEP — primary key
host_726.emp.BatchMonthly.PK_TicketAudit1CLUSTEREDYY0000never2026-09-13 03:30:13UNUSEDKEEP — primary key
host_726.emp.RosterLog.PK_QuotaLog1CLUSTEREDYY2871800143592026-09-15 13:16:112026-09-13 03:30:13USEDKEEP — primary key
host_726.emp.QuotaMonthly.IX_ShipmentEntry15NONCLUSTERED1809400872026-09-15 15:00:162026-09-16 01:00:09USEDkeep — in use
host_726.emp.QuotaMonthly.PK_ReconcileDetail1CLUSTEREDYY49718094872026-09-15 15:00:162026-09-16 01:00:09USEDKEEP — primary key
host_726.emp.OrdersEntry.PK_PolicyHeader1CLUSTEREDYY00085never2026-09-16 01:00:10UNUSEDKEEP — primary key
host_726.emp.PayrollSummary.PK_RouteSummary1CLUSTEREDYY11369002026-09-16 00:59:492026-09-13 03:30:14USEDKEEP — primary key
host_726.emp.SettlementAudit.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-13 03:30:15UNUSEDKEEP — primary key
host_726.emp.InvoiceLog.PK_BatchEntry1CLUSTEREDYY0000never2026-09-13 03:30:15UNUSEDKEEP — 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_CustomerMonthly1CLUSTEREDYY59121002026-09-15 15:02:072026-09-13 03:30:15USEDKEEP — primary key
host_726.emp.RouteHistory.UX_CustomerQueue2NONCLUSTEREDY0000never2026-09-13 03:30:15UNUSEDreview carefully — unique
host_726.emp.CustomerHistory.PK_ShiftDaily1CLUSTEREDYY540002026-09-15 08:09:442026-09-13 03:30:15USEDKEEP — primary key
host_726.emp.ForecastEntry.PK_SettlementLog1CLUSTEREDYY014451002026-09-15 13:18:532026-09-13 03:30:15USEDKEEP — primary key
host_726.emp.ClaimQueue.PK_TerritoryResult1CLUSTEREDYY0000never2026-09-13 03:30:15UNUSEDKEEP — primary key
host_726.emp.PolicyAudit.PK_ContractAudit1CLUSTEREDYY015059002026-09-15 13:48:382026-09-13 03:30:15USEDKEEP — primary key
host_726.emp.ShipmentSummary.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-13 03:30:16UNUSEDKEEP — primary key
host_726.emp.BatchArchive.PK_ClaimHistory1CLUSTEREDYY1503525002026-09-15 13:48:382026-09-13 03:30:16USEDKEEP — primary key
host_726.emp.RosterSnapshot.PK_PolicyStaging1CLUSTEREDYY0000never2026-09-13 03:30:16UNUSEDKEEP — primary key
host_726.emp.MeterResult.IX_LedgerQueue11NONCLUSTERED015650462026-09-15 15:08:582026-09-16 01:00:11USEDkeep — in use
host_726.emp.MeterResult.PK_CustomerResult1CLUSTEREDYY10028544700462026-09-15 15:08:572026-09-16 01:00:10USEDKEEP — primary key
host_726.emp.PayrollHeader.PK_TicketHistory1CLUSTEREDYY698760462026-09-15 13:48:372026-09-16 01:00:12USEDKEEP — primary key
host_726.emp.OrdersAudit.PK_ShipmentHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.RosterResult.PK_MeterAudit1CLUSTEREDYY01472002026-09-16 00:59:492026-09-13 03:30:17USEDKEEP — primary key
host_726.emp.RouteHeader.PK_StaffingQueue1CLUSTEREDYY0000never2026-09-13 03:30:17UNUSEDKEEP — primary key
host_726.emp.MeterAudit.PK_ClaimLog1CLUSTEREDYY978240272026-09-15 10:13:542026-09-16 01:00:12USEDKEEP — primary key
host_726.emp.QuotaStatus.PK_OrdersArchive1CLUSTEREDYY0007never2026-09-16 01:00:12UNUSEDKEEP — primary key
host_726.emp.ShiftLine.IX_PricingAudit14NONCLUSTERED540002026-09-12 08:26:562026-09-13 03:30:18USEDkeep — in use
host_726.emp.ShiftLine.PK_SettlementStatus1CLUSTEREDYY1514086002026-09-16 00:59:492026-09-13 03:30:18USEDKEEP — primary key
host_726.emp.ShiftLine.UX_BookingDaily2NONCLUSTEREDY60002026-09-15 10:10:302026-09-13 03:30:18USEDkeep — in use
host_726.emp.CampaignHeader.PK_BillingQueue1CLUSTEREDYY0000never2026-09-13 03:30:18UNUSEDKEEP — primary key
host_726.emp.MeterStatus.PK_BillingStaging1CLUSTEREDYY0000never2026-09-13 03:30:18UNUSEDKEEP — primary key
host_726.emp.WarehouseStaging.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-13 03:30:18UNUSEDKEEP — primary key
host_726.emp.ForecastHeader.IX_WarehouseResult6NONCLUSTERED67450002026-09-15 10:13:542026-09-13 03:30:18USEDkeep — in use
host_726.emp.ForecastHeader.PK_OrdersAudit1CLUSTEREDYY011674402026-09-15 10:13:542026-09-13 03:30:18USEDKEEP — primary key
host_726.emp.SalesLog.PK_AssetStaging1CLUSTEREDYY0000never2026-09-13 03:30:19UNUSEDKEEP — primary key
host_726.emp.AssetDaily.PK_CustomerMonthly1CLUSTEREDYY013243002026-09-15 14:06:582026-09-13 03:30:19USEDKEEP — primary key
host_726.emp.StaffingDaily.PK_BookingLog1CLUSTEREDYY0000never2026-09-13 03:30:19UNUSEDKEEP — primary key
host_726.emp.ClaimResult.PK_TerritoryQueue1CLUSTEREDYY0000never2026-09-13 03:30:19UNUSEDKEEP — primary key
host_726.emp.CatalogLog.PK_ReconcileHeader1CLUSTEREDYY0000never2026-09-13 03:30:19UNUSEDKEEP — primary key
host_726.emp.ShipmentSnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-13 03:30:19UNUSEDKEEP — primary key
host_726.emp.PricingDaily.IX_ShiftAudit2NONCLUSTERED160002026-09-15 08:07:482026-09-13 03:30:19USEDkeep — in use
host_726.emp.PricingDaily.PK_RouteEntry1CLUSTEREDYY067381502026-09-15 10:13:542026-09-13 03:30:19USEDKEEP — primary key
host_726.emp.PolicyLog.PK_LedgerHistory1CLUSTEREDYY2876987462026-09-15 14:06:552026-09-16 01:00:13USEDKEEP — primary key
host_726.emp.PolicyLog.UX_OrdersSnapshot4NONCLUSTEREDY699100462026-09-15 14:06:552026-09-16 01:00:13USEDkeep — in use
host_726.emp.RouteAudit.PK_ClaimResult1CLUSTEREDYY0007never2026-09-16 01:00:13UNUSEDKEEP — primary key
host_726.emp.PayrollDaily.IX_BillingStaging2NONCLUSTERED1000512026-09-15 08:11:17neverUSEDkeep — in use
host_726.emp.PayrollDaily.PK_OrdersSnapshot1CLUSTEREDYY0100512026-09-15 08:11:17neverUSEDKEEP — primary key
host_726.emp.MeterHistory.IX_ContractArchive11NONCLUSTERED11000520752026-09-16 00:20:532026-09-16 01:00:13USEDkeep — in use
host_726.emp.MeterHistory.PK_BatchLog1CLUSTEREDYY19555752011034481342026-09-16 00:20:532026-09-16 01:00:13USEDKEEP — primary key
host_726.emp.MeterHistory.UX_BatchLog3NONCLUSTEREDYY000106never2026-09-16 01:00:13UNUSEDreview carefully — unique
host_726.emp.MeterHistory.UX_ForecastHeader23NONCLUSTEREDY287481580742026-09-15 15:08:582026-09-16 01:00:13USEDkeep — in use
host_726.emp.MeterHistory.UX_CustomerSnapshot2NONCLUSTEREDYY5201052026-09-03 12:58:062026-09-16 01:00:13USEDkeep — in use
host_726.emp.MeterHistory.UX_QuotaStaging13NONCLUSTEREDY67199380742026-09-15 15:00:162026-09-16 01:00:14USEDkeep — in use
host_726.emp.TerritoryLine.PK_LedgerArchive1CLUSTEREDYY173421404012026-09-16 00:05:232026-09-15 01:00:13USEDKEEP — primary key
host_726.emp.SalesStaging.PK_PolicyDaily1CLUSTEREDYY715811140392026-09-16 00:05:242026-09-13 03:30:21USEDKEEP — primary key
host_726.emp.TerritoryDaily.PK_MeterLog1CLUSTEREDYY0002never2026-09-13 03:30:21UNUSEDKEEP — primary key
host_726.emp.SettlementQueue.IX_PolicyAudit2NONCLUSTERED1103502026-08-20 09:14:322026-09-15 01:00:14USEDkeep — in use
host_726.emp.SettlementQueue.PK_SalesEntry1CLUSTEREDYY14013502026-09-11 15:12:112026-09-15 01:00:14USEDKEEP — primary key
host_726.emp.StaffingMonthly.IX_ReconcileEntry2NONCLUSTERED0180802026-08-19 14:42:092026-09-13 03:30:22USEDkeep — in use
host_726.emp.StaffingMonthly.IX_SalesQueue3NONCLUSTERED1083930802026-09-15 13:27:062026-09-13 03:30:22USEDkeep — in use
host_726.emp.StaffingMonthly.PK_CampaignStatus1CLUSTEREDYY4428626860802026-09-15 13:43:322026-09-13 03:30:22USEDKEEP — primary key
host_726.emp.TicketQueue.PK_BatchDaily1CLUSTEREDYY026741862026-09-15 10:13:542026-09-15 08:10:59USEDKEEP — primary key
host_726.emp.TicketQueue.UX_PayrollDaily2NONCLUSTEREDY674100862026-09-15 10:13:542026-09-15 08:10:59USEDkeep — in use
host_726.emp.MeterStatus.PK_CustomerDetail1CLUSTEREDYY00086never2026-09-16 01:00:15UNUSEDKEEP — primary key
host_726.emp.OrdersEntry.PK_TerritoryAudit1CLUSTEREDYY08354002026-09-16 00:59:492026-09-13 03:30:22USEDKEEP — primary key
host_726.emp.InvoiceLog.PK_BillingDetail1CLUSTEREDYY00075never2026-09-16 01:00:15UNUSEDKEEP — primary key
host_726.emp.CampaignHistory.IX_QuotaDetail2NONCLUSTERED6559620152026-09-15 13:15:292026-09-15 01:00:15USEDkeep — in use
host_726.emp.CampaignHistory.PK_AssetHeader1CLUSTEREDYY72232165596152026-09-15 13:15:292026-09-15 01:00:15USEDKEEP — primary key
host_726.emp.ContractArchive.PK_BookingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.TicketLine.PK_CampaignEntry1CLUSTEREDYY545230002026-09-15 08:07:022026-09-13 03:30:22USEDKEEP — primary key
host_726.emp.BatchAudit.IX_PolicyArchive15NONCLUSTERED14618720591332026-09-15 15:08:572026-09-16 01:00:16USEDkeep — in use
host_726.emp.BatchAudit.PK_ForecastSummary1CLUSTEREDYY294964154162340886922026-09-15 15:08:572026-09-16 01:00:15USEDKEEP — primary key
host_726.emp.BatchAudit.UX_LedgerStaging2NONCLUSTEREDY21256610591332026-09-16 00:05:232026-09-16 01:00:16USEDkeep — in use
host_726.emp.ClaimAudit.PK_LedgerDaily1CLUSTEREDYY0003neverneverUNUSEDKEEP — primary key
host_726.emp.ClaimAudit.UX_RouteMonthly2NONCLUSTEREDY03032026-09-15 01:10:12neverUSEDkeep — in use
host_726.emp.PolicyHistory.PK_OrdersDaily1CLUSTEREDYY364193480659132026-09-16 00:05:232026-09-16 01:00:17USEDKEEP — primary key
host_726.emp.BillingEntry.PK_StaffingAudit1CLUSTEREDYY038822363502026-09-16 00:05:232026-09-16 01:00:18USEDKEEP — primary key
host_726.emp.BillingEntry.UX_StaffingLog2NONCLUSTEREDY66851270363502026-09-15 13:15:302026-09-16 01:00:18USEDkeep — in use
host_726.emp.BillingAudit.IX_PolicyHeader8NONCLUSTERED2700363502026-09-15 13:16:422026-09-16 01:00:19USEDkeep — in use
host_726.emp.BillingAudit.PK_PolicyDetail1CLUSTEREDYY0021363502026-09-11 15:12:112026-09-16 01:00:19USEDKEEP — primary key
host_726.emp.BillingAudit.UX_SupplierSnapshot2NONCLUSTEREDY66371570363502026-09-15 13:15:302026-09-16 01:00:19USEDkeep — in use
host_726.emp.ShipmentStaging.PK_TerritoryStatus1CLUSTEREDYY0176067812026-09-15 01:10:002026-09-13 03:30:26USEDKEEP — primary key
host_726.emp.ShipmentStaging.UX_RosterDaily2NONCLUSTEREDY6446175067812026-09-15 13:15:302026-09-13 03:30:26USEDkeep — in use
host_726.emp.SalesLine.PK_CampaignResult1CLUSTEREDYY40113250659032026-09-15 15:08:572026-09-16 01:00:20USEDKEEP — primary key
host_726.emp.LedgerSnapshot.PK_CampaignStatus1CLUSTEREDYY00049never2026-09-16 01:00:21UNUSEDKEEP — primary key
host_726.emp.ReconcileDetail.PK_CampaignQueue1CLUSTEREDYY367650282026-09-15 10:13:542026-09-16 01:00:21USEDKEEP — primary key
host_726.emp.PolicyStaging.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.ReconcileStaging.PK_ContractStaging1CLUSTEREDYY365138002026-09-15 15:12:252026-09-13 03:30:28USEDKEEP — primary key
host_726.emp.ReconcileStaging.UX_OrdersHistory2NONCLUSTEREDY0000never2026-09-13 03:30:28UNUSEDreview carefully — unique
host_726.emp.MeterStatus.PK_ReconcileMonthly1CLUSTEREDYY4241022747572026-09-15 15:00:162026-09-16 01:00:21USEDKEEP — primary key
host_726.emp.MeterStatus.UX_ReconcileAudit7NONCLUSTEREDY2275100262026-09-15 15:00:162026-09-16 01:00:21USEDkeep — in use
host_726.emp.PricingAudit.PK_ReconcileSnapshot1CLUSTEREDYY00010never2026-09-16 01:00:22UNUSEDKEEP — primary key
host_726.emp.OrdersMonthly.IX_QuotaArchive2NONCLUSTEREDY0202122026-09-10 09:39:342026-09-15 01:01:48USEDkeep — in use
host_726.emp.OrdersMonthly.IX_PayrollResult3NONCLUSTEREDY01062026-09-10 09:39:202026-09-15 01:01:48USEDkeep — in use
host_726.emp.OrdersMonthly.IX_TicketSnapshot4NONCLUSTERED8778803422026-09-16 00:20:532026-09-15 01:01:48USEDkeep — in use
host_726.emp.OrdersMonthly.IX_SettlementLine5NONCLUSTERED26203422026-09-10 00:20:032026-09-15 01:01:48USEDkeep — in use
host_726.emp.OrdersMonthly.PK_ShipmentSnapshot1CLUSTEREDYY124833422026-09-14 15:47:462026-09-15 01:01:48USEDKEEP — primary key
host_726.emp.RosterQueue.PK_SettlementHistory1CLUSTEREDYY8481255002026-09-15 15:12:252026-09-13 03:30:29USEDKEEP — primary key
host_726.emp.TicketAudit.IX_LedgerLog2NONCLUSTERED100112026-09-14 14:03:582026-09-15 01:01:48USEDkeep — in use
host_726.emp.TicketAudit.PK_LedgerStatus1CLUSTEREDYY001112026-09-14 14:03:582026-09-15 01:01:48USEDKEEP — primary key
host_726.emp.InvoiceResult.PK_ShipmentMonthly1CLUSTEREDYY00011never2026-09-15 01:01:48UNUSEDKEEP — primary key
host_726.emp.CustomerLog.IX_PolicyDaily20NONCLUSTERED01190492026-09-15 13:16:572026-09-16 01:00:22USEDkeep — in use
host_726.emp.CustomerLog.IX_PayrollResult21NONCLUSTERED1311926180582026-09-15 13:18:282026-09-16 01:00:22USEDkeep — in use
host_726.emp.CustomerLog.PK_StaffingDaily1CLUSTEREDYY7670010201109702026-09-15 13:48:382026-09-16 01:00:22USEDKEEP — primary key
host_726.emp.InvoiceAudit.IX_SettlementResult10NONCLUSTERED616430442026-09-15 13:48:382026-09-16 01:00:22USEDkeep — in use
host_726.emp.InvoiceAudit.PK_QuotaEntry1CLUSTEREDYY023212442026-09-15 13:18:252026-09-16 01:00:22USEDKEEP — primary key
host_726.emp.MeterSummary.PK_AssetEntry1CLUSTEREDYY00041never2026-09-16 01:00:23UNUSEDKEEP — primary key
host_726.emp.AssetSummary.PK_SupplierStaging1CLUSTEREDYY0300482026-09-15 02:15:022026-09-16 01:00:23USEDKEEP — primary key
host_726.emp.SupplierStaging.IX_CampaignResult22NONCLUSTERED028302482026-09-15 11:00:042026-09-16 01:00:23USEDkeep — in use
host_726.emp.SupplierStaging.IX_StaffingSnapshot25NONCLUSTERED3595333402082026-09-15 15:08:582026-09-16 01:00:23USEDkeep — in use
host_726.emp.SupplierStaging.IX_MeterStaging16NONCLUSTERED4950002242026-09-14 14:21:492026-09-16 01:00:23USEDkeep — in use
host_726.emp.SupplierStaging.IX_StaffingEntry24NONCLUSTERED000232never2026-09-16 01:00:23UNUSEDreview, then DROP
host_726.emp.SupplierStaging.PK_PayrollMonthly1CLUSTEREDYY5803179852712482026-09-15 15:08:582026-09-16 01:00:23USEDKEEP — primary key
host_726.emp.CustomerStatus.IX_ReconcileLine10NONCLUSTERED752233101692026-09-15 13:49:322026-09-16 01:00:24USEDkeep — in use
host_726.emp.CustomerStatus.PK_PolicyHistory1CLUSTEREDYY09222691692026-09-15 13:49:322026-09-16 01:00:24USEDKEEP — primary key
host_726.emp.BillingAudit.PK_CustomerEntry1CLUSTEREDYY000134never2026-09-16 01:00:24UNUSEDKEEP — primary key
host_726.emp.PolicyLine.PK_OrdersSummary1CLUSTEREDYY324190312026-09-15 13:49:322026-09-13 03:30:31USEDKEEP — primary key
host_726.emp.RouteStaging.PK_WarehouseLine1CLUSTEREDYY046002026-09-15 13:15:112026-09-13 03:30:31USEDKEEP — primary key
host_726.emp.CampaignMonthly.PK_OrdersArchive1CLUSTEREDYY714680482026-09-15 13:49:322026-09-13 03:30:31USEDKEEP — primary key
host_726.emp.CatalogSnapshot.PK_ClaimHistory1CLUSTEREDYY015002026-08-20 08:06:022026-09-13 03:30:31USEDKEEP — primary key
host_726.emp.BillingDaily.PK_CustomerLine1CLUSTEREDYY01101341752026-09-14 14:21:492026-09-15 01:01:51USEDKEEP — primary key
host_726.emp.BillingDaily.UX_LedgerDaily2NONCLUSTEREDY168001752026-09-14 14:21:492026-09-15 01:01:51USEDkeep — in use
host_726.emp.SupplierHistory.PK_WarehouseMonthly1CLUSTEREDYY03002632026-09-15 02:15:022026-09-16 01:00:24USEDKEEP — primary key
host_726.emp.ShipmentMonthly.IX_SupplierEntry12NONCLUSTERED73300627712026-09-15 13:48:382026-09-16 01:00:24USEDkeep — in use
host_726.emp.ShipmentMonthly.IX_InvoiceStaging5NONCLUSTERED1301600627712026-09-15 15:00:162026-09-16 01:00:24USEDkeep — in use
host_726.emp.ShipmentMonthly.PK_BatchDaily1CLUSTEREDYY1912419627902026-09-15 15:00:162026-09-16 01:00:24USEDKEEP — primary key
host_726.emp.AssetDetail.PK_ReconcileResult1CLUSTEREDYY00031396never2026-09-16 01:00:25UNUSEDKEEP — primary key
host_726.emp.AssetSnapshot.IX_ForecastStatus6NONCLUSTERED376925840105352026-09-15 13:16:422026-09-16 01:00:25USEDkeep — in use
host_726.emp.AssetSnapshot.IX_SalesDaily5NONCLUSTERED26847210105352026-09-15 15:00:082026-09-16 01:00:25USEDkeep — in use
host_726.emp.AssetSnapshot.PK_OrdersDetail1CLUSTEREDYY42122105352026-09-15 13:16:422026-09-16 01:00:25USEDKEEP — primary key
host_726.emp.PricingStatus.PK_PolicyStatus1CLUSTEREDYY020105342026-08-20 10:38:382026-09-16 01:00:26USEDKEEP — primary key
host_726.emp.TicketSnapshot.IX_BookingHistory14NONCLUSTERED029690105692026-09-15 15:08:582026-09-16 01:00:26USEDkeep — in use
host_726.emp.TicketSnapshot.PK_CampaignQueue1CLUSTEREDYY572562280105692026-09-15 15:00:082026-09-16 01:00:26USEDKEEP — primary key
host_726.emp.ForecastMonthly.PK_CampaignSummary1CLUSTEREDYY0280105642026-09-15 02:15:022026-09-16 01:00:29USEDKEEP — primary key
host_726.emp.PricingStatus.IX_QuotaLog8NONCLUSTERED1425900105532026-09-15 13:48:002026-09-16 01:00:30USEDkeep — in use
host_726.emp.PricingStatus.IX_ClaimEntry6NONCLUSTERED609336560105532026-09-15 15:08:582026-09-16 01:00:30USEDkeep — in use
host_726.emp.PricingStatus.PK_LedgerResult1CLUSTEREDYY3490214259105532026-09-15 14:26:272026-09-16 01:00:29USEDKEEP — primary key
host_726.emp.PayrollHistory.PK_LedgerQueue1CLUSTEREDYY00010552never2026-09-16 01:00:31UNUSEDKEEP — primary key
host_726.emp.QuotaSummary.IX_StaffingQueue10NONCLUSTERED6133700382026-09-15 13:48:382026-09-16 01:00:32USEDkeep — in use
host_726.emp.QuotaSummary.PK_LedgerEntry1CLUSTEREDYY048341382026-09-15 13:18:322026-09-16 01:00:31USEDKEEP — primary key
host_726.emp.PricingQueue.PK_PricingStaging1CLUSTEREDYY00036never2026-09-16 01:00:33UNUSEDKEEP — primary key
host_726.emp.BookingMonthly.IX_ShipmentAudit5NONCLUSTERED1393934930762026-09-15 15:08:572026-09-16 01:00:33USEDkeep — in use
host_726.emp.BookingMonthly.PK_WarehouseLog1CLUSTEREDYY00076never2026-09-16 01:00:33UNUSEDKEEP — primary key
host_726.emp.MeterSnapshot.PK_StaffingSummary1CLUSTEREDYY020762026-08-20 10:38:382026-09-16 01:00:33USEDKEEP — primary key
host_726.emp.BatchMonthly.IX_ClaimSummary17NONCLUSTERED03070972026-09-15 11:00:052026-09-16 01:00:34USEDkeep — in use
host_726.emp.BatchMonthly.PK_InvoiceDetail1CLUSTEREDYY933331360278982026-09-15 15:08:572026-09-16 01:00:34USEDKEEP — primary key
host_726.emp.StaffingAudit.PK_ForecastHeader1CLUSTEREDYY03201022026-09-15 02:15:022026-09-16 01:00:35USEDKEEP — primary key
host_726.emp.BatchLog.PK_SalesDetail1CLUSTEREDYY289391602302026-09-15 15:08:572026-09-16 01:00:35USEDKEEP — primary key
host_726.emp.RouteHistory.PK_MeterEntry1CLUSTEREDYY000230never2026-09-16 01:00:36UNUSEDKEEP — primary key
host_726.emp.CampaignResult.IX_ClaimStatus14NONCLUSTERED5657643890109062026-09-15 15:08:582026-09-15 01:02:01USEDkeep — in use
host_726.emp.CampaignResult.IX_ForecastAudit13NONCLUSTERED179700157582026-09-15 13:15:302026-09-15 01:02:01USEDkeep — in use
host_726.emp.CampaignResult.IX_CustomerQueue12NONCLUSTERED1351000218122026-09-15 13:15:302026-09-15 01:02:01USEDkeep — in use
host_726.emp.CampaignResult.PK_StaffingArchive1CLUSTEREDYY79086117275577248342026-09-15 15:08:582026-09-15 01:02:01USEDKEEP — primary key
host_726.emp.SalesHeader.IX_BookingSummary2NONCLUSTERED000921never2026-09-15 01:02:04UNUSEDreview, then DROP
host_726.emp.SalesHeader.PK_CatalogQueue1CLUSTEREDYY000921never2026-09-15 01:02:04UNUSEDKEEP — primary key
host_726.emp.PayrollHistory.PK_CampaignStaging1CLUSTEREDYY1373213690182026-09-16 00:59:492026-09-13 03:30:40USEDKEEP — primary key
host_726.emp.TerritoryDaily.PK_RouteArchive1CLUSTEREDYY00018never2026-09-13 03:30:40UNUSEDKEEP — primary key
host_726.emp.CatalogSummary.IX_PricingSnapshot24NONCLUSTERED119214203012026-09-16 00:20:532026-09-15 01:02:03USEDkeep — in use
host_726.emp.CatalogSummary.IX_WarehouseSnapshot19NONCLUSTERED1678188302852026-09-15 15:08:572026-09-15 01:02:03USEDkeep — in use
host_726.emp.CatalogSummary.IX_ReconcileSummary16NONCLUSTERED60558002852026-09-16 00:05:232026-09-15 01:02:03USEDkeep — in use
host_726.emp.CatalogSummary.IX_AssetEntry25NONCLUSTERED286823403012026-09-15 13:18:532026-09-15 01:02:03USEDkeep — in use
host_726.emp.CatalogSummary.PK_ShipmentStaging1CLUSTEREDYY956542120783613272026-09-16 00:20:532026-09-15 01:02:03USEDKEEP — primary key
host_726.emp.CatalogSummary.UX_OrdersAudit5NONCLUSTEREDY4524702852026-09-16 00:20:532026-09-15 01:02:03USEDkeep — in use
host_726.emp.CatalogSummary.UX_LedgerHistory12NONCLUSTEREDYY15425003122026-09-15 13:48:002026-09-15 01:02:03USEDkeep — in use
host_726.emp.TicketMonthly.PK_LedgerAudit1CLUSTEREDYY4533390902026-09-15 10:10:252026-09-13 03:30:41USEDKEEP — primary key
host_726.emp.BillingQueue.IX_AssetDetail11NONCLUSTERED05203522026-09-15 01:10:092026-09-15 01:02:03USEDkeep — in use
host_726.emp.BillingQueue.IX_ContractSummary8NONCLUSTERED49921003522026-09-16 00:20:532026-09-15 01:02:03USEDkeep — in use
host_726.emp.BillingQueue.PK_ShipmentEntry1CLUSTEREDYY02944498953522026-09-16 00:20:532026-09-15 01:02:03USEDKEEP — primary key
host_726.emp.CampaignResult.IX_SupplierLine10NONCLUSTERED353003102026-09-15 08:11:172026-09-15 01:02:04USEDkeep — in use
host_726.emp.CampaignResult.PK_CustomerLine1CLUSTEREDYY12983533102026-09-15 10:10:252026-09-15 01:02:04USEDKEEP — primary key
host_726.org.SettlementSnapshot.PK_org.SettlementSnapshot1CLUSTEREDYY028002026-09-12 08:29:542026-09-13 03:30:42USEDKEEP — primary key
host_726.org.SettlementSnapshot.UX_BillingLine2NONCLUSTEREDY0000never2026-09-13 03:30:42UNUSEDreview carefully — unique
host_726.org.PolicySummary.IX_AssetEntry18NONCLUSTERED2974814670332026-09-15 15:08:572026-09-13 03:30:42USEDkeep — in use
host_726.org.PolicySummary.PK_QuotaAudit1CLUSTEREDYY1537593171429944762026-09-15 15:08:582026-09-13 03:30:42USEDKEEP — primary key
host_726.org.PolicySummary.UX_ForecastHistory2NONCLUSTEREDYY28310332026-09-14 14:54:192026-09-13 03:30:42USEDkeep — in use
host_726.org.BatchMonthly.PK_WarehouseSummary1CLUSTEREDYY744780462026-09-15 09:43:482026-09-13 03:30:43USEDKEEP — primary key
host_726.org.BatchMonthly.UX_SalesSnapshot2NONCLUSTEREDYY00046never2026-09-13 03:30:43UNUSEDreview carefully — unique
host_726.org.CampaignQueue.PK_RosterDaily1CLUSTEREDYY010462026-09-03 08:37:262026-09-13 03:30:43USEDKEEP — primary key
host_726.org.TicketLog.PK_WarehouseDetail1CLUSTEREDYY82801772026-09-15 08:09:442026-09-13 03:30:43USEDKEEP — primary key
host_726.org.TicketLog.UX_SalesMonthly4NONCLUSTEREDY100772026-09-10 11:53:592026-09-16 01:00:36USEDkeep — in use
host_726.org.BatchDaily.PK_QuotaStaging1CLUSTEREDYY6607312345611422026-09-16 01:01:002026-09-13 03:30:43USEDKEEP — primary key
host_726.org.BatchDaily.UX_PricingResult8NONCLUSTEREDYY0115022026-09-15 09:49:392026-09-16 01:00:36USEDkeep — in use
host_726.org.ShipmentAudit.PK_ForecastHeader1CLUSTEREDYY24687734957367212026-09-16 01:01:002026-09-13 03:30:43USEDKEEP — primary key
host_726.org.ShipmentAudit.UX_BatchArchive2NONCLUSTEREDY495184856450212026-09-16 01:01:002026-09-16 01:00:36USEDkeep — in use
host_726.org.WarehouseStaging.PK_MeterHistory1CLUSTEREDYY00017never2026-09-16 01:00:36UNUSEDKEEP — primary key
host_726.org.BookingResult.PK_BillingQueue1CLUSTEREDYY0000never2026-09-13 03:30:43UNUSEDKEEP — primary key
host_726.org.InvoiceQueue.PK_TicketEntry1CLUSTEREDYY6173022026-09-15 15:02:432026-09-13 03:30:43USEDKEEP — primary key
host_726.org.PricingStatus.PK_TerritoryStatus1CLUSTEREDYY0002never2026-09-16 01:00:37UNUSEDKEEP — primary key
host_726.org.CatalogHeader.PK_ShiftStatus1CLUSTEREDYY181244060872026-09-15 10:58:582026-09-13 03:30:44USEDKEEP — primary key
host_726.org.PolicySummary.PK_CatalogQueue1CLUSTEREDYY00085never2026-09-15 01:02:05UNUSEDKEEP — primary key
host_726.org.CatalogAudit.PK_AssetStatus1CLUSTEREDYY0002never2026-09-16 01:00:37UNUSEDKEEP — primary key
host_726.org.OrdersSummary.PK_StaffingAudit1CLUSTEREDYY0550192026-09-11 15:12:322026-09-13 03:30:44USEDKEEP — primary key
host_726.org.ContractResult.PK_PolicyLine1CLUSTEREDYY00019never2026-09-13 03:30:44UNUSEDKEEP — primary key
host_726.org.SupplierHistory.IX_ShipmentSummary2NONCLUSTERED0000never2026-09-13 03:30:44UNUSEDreview, then DROP
host_726.org.SupplierHistory.PK_CustomerDetail1CLUSTEREDYY0289002026-09-14 15:04:022026-09-13 03:30:44USEDKEEP — 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 03:30:44UNUSEDreview, then DROP
host_726.org.BillingHeader.PK_InvoiceMonthly1CLUSTEREDYY077002026-09-14 15:04:022026-09-13 03:30:44USEDKEEP — primary key
host_726.org.ShipmentSummary.IX_StaffingResult2NONCLUSTERED0000never2026-09-13 03:30:44UNUSEDreview, then DROP
host_726.org.ShipmentSummary.PK_ClaimDetail1CLUSTEREDYY077002026-09-14 15:04:022026-09-13 03:30:44USEDKEEP — primary key
host_726.org.SalesStatus.IX_ClaimHeader2NONCLUSTEREDY800002026-09-14 15:04:022026-09-13 03:30:44USEDkeep — in use
host_726.org.SalesStatus.PK_CampaignSnapshot1CLUSTEREDYY008002026-09-14 15:04:022026-09-13 03:30:44USEDKEEP — primary key
host_726.org.PolicyResult.PK_ForecastStaging1CLUSTEREDYY7131954350102026-09-15 13:15:292026-09-15 01:02:05USEDKEEP — primary key
host_726.org.AssetSummary.PK_TicketStaging1CLUSTEREDYY11811529002026-09-15 15:08:572026-09-13 03:30:44USEDKEEP — primary key
host_726.org.AssetSummary.UX_ShipmentSummary4NONCLUSTEREDY0000never2026-09-13 03:30:44UNUSEDreview carefully — unique
host_726.org.ShipmentQueue.PK_InvoiceStaging1CLUSTEREDYY295958446052026-09-15 15:08:582026-09-13 03:30:44USEDKEEP — primary key
host_726.org.PolicyEntry.PK_SettlementSnapshot1CLUSTEREDYY1673180132026-09-16 00:20:532026-09-13 03:30:44USEDKEEP — primary key
host_726.org.PolicyEntry.UX_ShiftSnapshot9NONCLUSTEREDYY00013never2026-09-13 03:30:44UNUSEDreview carefully — unique
host_726.org.MeterAudit.IX_WarehouseQueue3NONCLUSTERED1930092026-09-16 00:20:532026-09-13 03:30:45USEDkeep — in use
host_726.org.MeterAudit.PK_BillingDetail1CLUSTEREDYY3600132026-09-12 08:29:122026-09-13 03:30:45USEDKEEP — primary key
host_726.org.BillingHeader.PK_ContractStaging1CLUSTEREDYY0000never2026-09-13 03:30:45UNUSEDKEEP — primary key
host_726.org.TicketSnapshot.PK_ForecastSnapshot1CLUSTEREDYY0000never2026-09-13 03:30:45UNUSEDKEEP — primary key
host_726.org.CustomerStaging.PK_CustomerHeader1CLUSTEREDYY00013never2026-09-13 03:30:45UNUSEDKEEP — primary key
host_726.org.KPI.PK_ShiftLine1CLUSTEREDYY0000never2026-09-13 03:30:45UNUSEDKEEP — primary key
host_726.org.KPI.UX_ShiftHeader8NONCLUSTEREDYY0000never2026-09-13 03:30:45UNUSEDreview carefully — unique
host_726.org.StaffingArchive.PK_SettlementResult1CLUSTEREDYY028002026-09-12 08:29:542026-09-13 03:30:45USEDKEEP — primary key
host_726.org.CustomerEntry.PK_RouteSummary1CLUSTEREDYY0000never2026-09-13 03:30:45UNUSEDKEEP — primary key
host_726.org.PricingDaily.PK_CampaignArchive1CLUSTEREDYY0000never2026-09-13 03:30:45UNUSEDKEEP — primary key
host_726.org.PricingDaily.UX_BillingArchive2NONCLUSTEREDY0000never2026-09-13 03:30:45UNUSEDreview carefully — unique
host_726.org.TicketLine.PK_SupplierMonthly1CLUSTEREDYY0000never2026-09-13 03:30:45UNUSEDKEEP — primary key
host_726.org.BillingArchive.PK_MeterSummary1CLUSTEREDYY0000never2026-09-13 03:30:45UNUSEDKEEP — primary key
host_726.org.MeterEntry.PK_SupplierLog1CLUSTEREDYY0000never2026-09-13 03:30:45UNUSEDKEEP — primary key
host_726.org.ReconcileAudit.PK_PolicyLog1CLUSTEREDYY167266062026-09-15 15:12:252026-09-13 03:30:45USEDKEEP — primary key
host_726.org.ReconcileAudit.UQ_ShipmentResult2NONCLUSTEREDYY60062026-08-29 10:32:072026-09-13 03:30:45USEDkeep — in use
host_726.org.StaffingAudit.PK_RosterArchive1CLUSTEREDYY00013never2026-09-13 03:30:45UNUSEDKEEP — primary key
host_726.org.ShiftResult.PK_AssetAudit1CLUSTEREDYY17745732434072026-09-16 00:05:232026-09-13 03:30:45USEDKEEP — primary key
host_726.org.BatchMonthly.PK_SalesLine1CLUSTEREDYY3479062026-09-15 15:12:252026-09-13 03:30:46USEDKEEP — primary key
host_726.org.RosterMonthly.IX_AssetDetail2NONCLUSTERED0008never2026-09-13 03:30:46UNUSEDreview, then DROP
host_726.org.RosterMonthly.PK_ForecastDaily1CLUSTEREDYY4293082026-09-15 15:12:252026-09-13 03:30:46USEDKEEP — primary key
host_726.org.InvoiceStaging.IX_AssetAudit2NONCLUSTERED0008never2026-09-13 03:30:46UNUSEDreview, then DROP
host_726.org.InvoiceStaging.PK_CustomerMonthly1CLUSTEREDYY0008never2026-09-13 03:30:46UNUSEDKEEP — primary key
host_726.org.StaffingAudit.PK_AssetLog1CLUSTEREDYY0006never2026-09-13 03:30:46UNUSEDKEEP — primary key
host_726.org.Level.PK_ShiftStaging1CLUSTEREDYY289052621502026-09-15 13:18:532026-09-13 03:30:46USEDKEEP — primary key
host_726.org.Level.UX_SettlementHistory2NONCLUSTEREDYY2812002026-09-12 08:30:002026-09-13 03:30:46USEDkeep — in use
host_726.org.ContractHistory.PK_RouteArchive1CLUSTEREDYY0000never2026-09-13 03:30:46UNUSEDKEEP — primary key
host_726.org.QuotaEntry.IX_AssetHistory2NONCLUSTERED0000never2026-09-13 03:30:46UNUSEDreview, then DROP
host_726.org.QuotaEntry.PK_LedgerQueue1CLUSTEREDYY030746002026-09-15 13:15:152026-09-13 03:30:46USEDKEEP — primary key
host_726.org.ClaimQueue.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-13 03:30:46UNUSEDKEEP — primary key
host_726.org.SupplierLine.PK_InvoiceStatus1CLUSTEREDYY2002849002026-09-15 13:16:422026-09-13 03:30:46USEDKEEP — primary key
host_726.org.InvoiceHistory.PK_ContractDaily1CLUSTEREDYY0000never2026-09-13 03:30:46UNUSEDKEEP — primary key
host_726.org.AssetHeader.IX_PayrollAudit2NONCLUSTERED2002840002026-09-15 13:16:422026-09-13 03:30:46USEDkeep — in use
host_726.org.AssetHeader.PK_LedgerResult1CLUSTEREDYY180002026-09-08 15:18:312026-09-13 03:30:46USEDKEEP — primary key
host_726.org.TerritoryStatus.PK_PayrollLine1CLUSTEREDYY0000never2026-09-13 03:30:46UNUSEDKEEP — primary key
host_726.org.RosterLine.PK_BillingDaily1CLUSTEREDYY0000never2026-09-13 03:30:46UNUSEDKEEP — primary key
host_726.org.ForecastArchive.PK_CampaignHeader1CLUSTEREDYY043002026-09-05 16:14:362026-09-13 03:30:46USEDKEEP — primary key
host_726.org.PolicySummary.PK_WarehouseSnapshot1CLUSTEREDYY049991002026-09-15 13:16:412026-09-13 03:30:46USEDKEEP — primary key
host_726.org.ClaimMonthly.PK_RouteArchive1CLUSTEREDYY0000never2026-09-13 03:30:47UNUSEDKEEP — primary key
host_726.org.OrdersEntry.PK_MeterDaily1CLUSTEREDYY7112490162026-09-15 13:15:272026-09-16 01:00:37USEDKEEP — primary key
host_726.org.LedgerStaging.PK_BatchLine1CLUSTEREDYY00016never2026-09-16 01:00:37UNUSEDKEEP — primary key
host_726.org.Position.PK_PolicySummary1CLUSTEREDYY1040739340202026-09-16 00:20:532026-09-13 03:30:47USEDKEEP — primary key
host_726.org.Position.UX_MeterArchive2NONCLUSTEREDYY00020never2026-09-13 03:30:47UNUSEDreview carefully — unique
host_726.org.CampaignQueue.PK_BillingArchive1CLUSTEREDYY136060518962026-09-15 15:02:072026-09-13 03:30:47USEDKEEP — primary key
host_726.org.CampaignQueue.UX_TicketDaily2NONCLUSTEREDY2975436062026-09-15 14:26:272026-09-13 03:30:47USEDkeep — in use
host_726.org.MeterResult.PK_CatalogStaging1CLUSTEREDYY00012never2026-09-13 03:30:47UNUSEDKEEP — primary key
host_726.org.QuotaLine.PK_AssetAudit1CLUSTEREDYY16840162026-09-12 08:31:492026-09-13 03:30:47USEDKEEP — primary key
host_726.org.QuotaLine.UX_PricingAudit2NONCLUSTEREDYY00016never2026-09-13 03:30:47UNUSEDreview carefully — unique
host_726.org.PayrollLog.PK_PayrollAudit1CLUSTEREDYY0000never2026-09-13 03:30:47UNUSEDKEEP — primary key
host_726.org.PayrollLog.UX_PayrollDetail2NONCLUSTEREDY0000never2026-09-13 03:30:47UNUSEDreview carefully — unique
host_726.org.LedgerDaily.PK_ContractHeader1CLUSTEREDYY00020never2026-09-13 03:30:47UNUSEDKEEP — primary key
host_726.org.PricingArchive.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-13 03:30:47UNUSEDKEEP — primary key
host_726.org.PricingArchive.UX_InvoiceAudit2NONCLUSTEREDY0000never2026-09-13 03:30:47UNUSEDreview carefully — unique
host_726.org.ForecastAudit.PK_WarehouseSnapshot1CLUSTEREDYY0104002026-09-15 15:12:252026-09-13 03:30:47USEDKEEP — primary key
host_726.org.ForecastAudit.UX_ClaimArchive2NONCLUSTEREDY0000never2026-09-13 03:30:47UNUSEDreview carefully — unique
host_726.org.PayrollLine.PK_OrdersHistory1CLUSTEREDYY304104002026-09-15 15:12:252026-09-13 03:30:48USEDKEEP — primary key
host_726.org.PayrollLine.UX_ShiftLog2NONCLUSTEREDY0000never2026-09-13 03:30:48UNUSEDreview carefully — unique
host_726.org.BookingStaging.PK_AssetResult1CLUSTEREDYY111783138090972026-09-15 15:09:002026-09-16 01:00:37USEDKEEP — primary key
host_726.org.ReconcileLine.PK_CustomerLog1CLUSTEREDYY00040never2026-09-16 01:00:37UNUSEDKEEP — primary key
host_726.org.ShiftStaging.PK_BillingHistory1CLUSTEREDYY036002026-09-14 15:01:512026-09-13 03:30:48USEDKEEP — primary key
host_726.org.ShiftStaging.UQ_PolicyAudit2NONCLUSTEREDY0000never2026-09-13 03:30:48UNUSEDreview carefully — unique
host_726.org.CustomerLine.IX_ForecastLine3NONCLUSTERED360002026-09-14 15:01:512026-09-13 03:30:48USEDkeep — in use
host_726.org.CustomerLine.PK_LedgerEntry1CLUSTEREDYY0378002026-09-14 15:04:022026-09-13 03:30:48USEDKEEP — primary key
host_726.org.CustomerLine.UQ_PayrollLog2NONCLUSTEREDY0000never2026-09-13 03:30:48UNUSEDreview carefully — unique
host_726.org.InvoiceMonthly.PK_WarehouseQueue1CLUSTEREDYY0000never2026-09-13 03:30:48UNUSEDKEEP — primary key
host_726.org.InvoiceMonthly.UQ_MeterAudit2NONCLUSTEREDY036002026-09-14 15:01:512026-09-13 03:30:48USEDkeep — in use
host_726.org.QuotaStaging.PK_ShiftStaging1CLUSTEREDYY63914422026-09-14 15:04:022026-09-13 03:30:48USEDKEEP — primary key
host_726.org.QuotaStaging.UQ_ShiftMonthly2NONCLUSTEREDY1440022026-09-14 15:04:022026-09-15 01:02:05USEDkeep — in use
host_726.org.BatchMonthly.PK_WarehouseHeader1CLUSTEREDYY346931427127572026-09-14 15:01:542026-09-13 03:30:48USEDKEEP — primary key
host_726.org.BatchMonthly.UQ_LedgerStaging2NONCLUSTEREDY2712007572026-09-14 14:52:562026-09-15 01:02:05USEDkeep — in use
host_726.org.ClaimHeader.PK_ClaimArchive1CLUSTEREDYY0002938never2026-09-15 01:02:05UNUSEDKEEP — primary key
host_726.org.SupplierResult.PK_ForecastQueue1CLUSTEREDYY589408002026-09-15 15:12:252026-09-13 03:30:48USEDKEEP — primary key
host_726.org.RouteSummary.PK_RosterAudit1CLUSTEREDYY0000never2026-09-13 03:30:49UNUSEDKEEP — primary key
host_726.org.RouteSummary.UX_SupplierSummary2NONCLUSTEREDYY0000never2026-09-13 03:30:49COLDreview carefully — unique
host_726.org.ClaimDetail.PK_RouteMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.ShiftResult.PK_ForecastEntry1CLUSTEREDYY5279594116610342026-09-15 15:08:572026-09-15 01:02:05USEDKEEP — primary key
host_726.org.ShiftResult.UX_LedgerStaging7NONCLUSTEREDY411820010342026-09-15 14:26:272026-09-15 01:02:06USEDkeep — in use
host_726.org.QuotaResult.PK_CampaignDaily1CLUSTEREDYY162705733442026-09-15 13:15:272026-09-13 03:30:49USEDKEEP — primary key
host_726.org.QuotaResult.UX_BatchDaily2NONCLUSTEREDY42042026-09-15 12:06:412026-09-13 03:30:49USEDkeep — in use
host_726.org.QuotaDetail.PK_WarehouseMonthly1CLUSTEREDYY11524250102026-09-15 13:15:292026-09-13 03:30:49USEDKEEP — primary key
host_726.org.BookingLog.PK_MeterStaging1CLUSTEREDYY00010never2026-09-13 03:30:49UNUSEDKEEP — primary key
host_726.org.SettlementAudit.PK_InvoiceSnapshot1CLUSTEREDYY0003never2026-09-13 03:30:49UNUSEDKEEP — primary key
host_726.oth.QuotaSummary.PK_QuotaDetail1CLUSTEREDYY106002026-09-10 12:56:252026-09-13 03:30:49USEDKEEP — primary key
host_726.oth.InvoiceStatus.PK_ShiftQueue1CLUSTEREDYY21118002026-09-16 00:00:002026-09-13 03:30:50USEDKEEP — primary key
host_726.oth.SupplierLine.PK_QuotaDetail1CLUSTEREDYY04002026-08-21 10:16:412026-09-13 03:30:50USEDKEEP — primary key
host_726.oth.SupplierLine.UX_InvoiceHeader2NONCLUSTEREDY0000never2026-09-13 03:30:50UNUSEDreview carefully — unique
host_726.oth.StaffingArchive.IX_InvoiceStaging2NONCLUSTERED0000never2026-09-13 03:30:50UNUSEDreview, then DROP
host_726.oth.StaffingArchive.PK_PricingAudit1CLUSTEREDYY0000never2026-09-13 03:30:50UNUSEDKEEP — primary key
host_726.oth.StaffingArchive.UQ_SalesAudit3NONCLUSTEREDY4117002026-09-12 08:29:062026-09-13 03:30:50USEDkeep — in use
host_726.oth.CustomerQueue.IX_WarehouseResult2NONCLUSTERED376002026-09-10 12:56:252026-09-13 03:30:50USEDkeep — in use
host_726.oth.CustomerQueue.PK_TerritoryResult1CLUSTEREDYY092202026-09-04 10:13:192026-09-13 03:30:50USEDKEEP — 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_PolicyResult1CLUSTEREDYY03002026-08-29 15:20:49neverUSEDKEEP — 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_QuotaLine1CLUSTEREDYY040002026-09-14 15:03:312026-09-13 03:30:50USEDKEEP — primary key
host_726.sal.ClaimArchive.IX_RouteDetail2NONCLUSTERED0000never2026-09-13 03:30:50UNUSEDreview, then DROP
host_726.sal.ClaimArchive.PK_LedgerHeader1CLUSTEREDYY0000never2026-09-13 03:30:50UNUSEDKEEP — primary key
host_726.sal.QuotaLine.PK_ContractArchive1CLUSTEREDYY79117736032026-09-16 01:01:002026-09-13 03:30:50USEDKEEP — primary key
host_726.sal.SalesStatus.PK_ShiftMonthly1CLUSTEREDYY142315650412026-09-16 00:59:492026-09-13 03:30:51USEDKEEP — primary key
host_726.sal.SettlementQueue.PK_StaffingSnapshot1CLUSTEREDYY02737044052026-09-16 00:59:492026-09-13 03:30:51USEDKEEP — primary key
host_726.sal.MeterHistory.PK_LedgerSnapshot1CLUSTEREDYY061044052026-09-14 15:04:022026-09-13 03:30:51USEDKEEP — primary key
host_726.sal.ShipmentAudit.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.sal.RouteResult.PK_OrdersAudit1CLUSTEREDYY088002026-09-15 08:14:592026-09-13 03:30:52USEDKEEP — primary key
host_726.sal.RouteResult.UX_ContractEntry2NONCLUSTEREDY0000never2026-09-13 03:30:52UNUSEDreview carefully — unique
host_726.sal.WarehouseDaily.PK_SettlementDetail1CLUSTEREDYY9945389122026-09-15 10:15:352026-09-13 03:30:52USEDKEEP — primary key
host_726.sal.WarehouseDaily.UX_BookingAudit2NONCLUSTEREDY1200122026-09-09 15:46:592026-09-13 03:30:52USEDkeep — in use
host_726.sal.InvoiceLog.PK_MeterAudit1CLUSTEREDYY75910752026-09-15 08:14:592026-09-13 03:30:52USEDKEEP — primary key
host_726.sal.PolicySnapshot.PK_ReconcileQueue1CLUSTEREDYY040752026-08-20 10:38:342026-09-13 03:30:52USEDKEEP — primary key
host_726.sal.SettlementStatus.PK_ReconcileResult1CLUSTEREDYY612871786232026-09-15 08:14:592026-09-13 03:30:52USEDKEEP — primary key
host_726.sal.SettlementStatus.UX_StaffingMonthly2NONCLUSTEREDY178006232026-09-14 16:07:232026-09-13 03:30:52USEDkeep — in use
host_726.sal.ReconcileHistory.PK_PayrollHeader1CLUSTEREDYY42590852026-09-15 08:14:592026-09-13 03:30:52USEDKEEP — primary key
host_726.sal.ReconcileHistory.UX_TicketQueue2NONCLUSTEREDY00085never2026-09-13 03:30:52UNUSEDreview carefully — unique
host_726.sal.InvoiceEntry.PK_RouteQueue1CLUSTEREDYY00085never2026-09-13 03:30:52UNUSEDKEEP — primary key
host_726.sal.BillingQueue.PK_ReconcileHistory1CLUSTEREDYY0206232026-08-20 10:38:342026-09-13 03:30:52USEDKEEP — primary key
host_726.sal.RosterDetail.PK_BookingStaging1CLUSTEREDYY010122026-08-20 10:38:342026-09-13 03:30:53USEDKEEP — primary key
host_726.sal.RosterQueue.PK_ShiftQueue1CLUSTEREDYY0127002026-09-15 12:15:432026-09-13 03:30:53USEDKEEP — primary key
host_726.sal.RosterQueue.UX_RosterArchive2NONCLUSTEREDY0000never2026-09-13 03:30:53UNUSEDreview carefully — unique
host_726.sal.WarehouseHeader.PK_RouteEntry1CLUSTEREDYY0381002026-09-16 00:05:232026-09-13 03:30:53USEDKEEP — primary key
host_726.sal.SupplierArchive.PK_SupplierStaging1CLUSTEREDYY01369002026-09-16 00:59:502026-09-13 03:30:53USEDKEEP — primary key
host_726.sal.RosterQueue.PK_PolicyLog1CLUSTEREDYY09002026-09-10 12:45:232026-09-13 03:30:53USEDKEEP — primary key
host_726.sal.CustomerSnapshot.PK_RosterEntry1CLUSTEREDYY01370002026-09-16 00:59:502026-09-13 03:30:53USEDKEEP — primary key
host_726.sal.LedgerStatus.PK_WarehouseStaging1CLUSTEREDYY913002026-09-10 12:45:312026-09-13 03:30:53USEDKEEP — primary key
host_726.sal.BookingLine.PK_PricingAudit1CLUSTEREDYY01002026-09-10 12:45:312026-09-13 03:30:53USEDKEEP — primary key
host_726.sal.PricingLine.PK_BatchLine1CLUSTEREDYY0000never2026-09-13 03:30:53UNUSEDKEEP — primary key
host_726.sal.WarehouseStaging.PK_SettlementHistory1CLUSTEREDYY01002026-09-10 12:45:312026-09-13 03:30:53USEDKEEP — primary key
host_726.sal.StaffingArchive.PK_CatalogLine1CLUSTEREDYY0000never2026-09-13 03:30:53UNUSEDKEEP — primary key
host_726.sal.WarehouseSummary.PK_RosterArchive1CLUSTEREDYY0000never2026-09-13 03:30:53UNUSEDKEEP — primary key
host_726.schedule.CustomerDetail.PK_CatalogStaging1CLUSTEREDYY01693789402026-09-15 13:15:292026-09-13 03:30:53USEDKEEP — primary key
host_726.schedule.CustomerDetail.UQ_BillingSnapshot3NONCLUSTEREDY37419396002026-09-15 13:15:292026-09-13 03:30:53USEDkeep — in use
host_726.schedule.CustomerDetail.UQ_CampaignResult2NONCLUSTEREDY45751963002026-09-15 13:15:292026-09-13 03:30:53USEDkeep — in use
host_726.schedule.InvoiceHistory.IX_StaffingHeader3NONCLUSTERED0000never2026-09-13 03:30:53UNUSEDreview, then DROP
host_726.schedule.InvoiceHistory.PK_ContractLog1CLUSTEREDYY0000never2026-09-13 03:30:53UNUSEDKEEP — primary key
host_726.schedule.InvoiceHistory.UQ_LedgerResult2NONCLUSTEREDY0000never2026-09-13 03:30:53UNUSEDreview carefully — unique
host_726.schedule.MeterStaging.PK_SettlementMonthly1CLUSTEREDYY7380638056432026-09-15 13:15:152026-09-13 03:30:53USEDKEEP — primary key
host_726.schedule.SettlementLine.PK_CampaignStatus1CLUSTEREDYY7587148201672026-09-15 13:49:422026-09-13 03:30:53USEDKEEP — primary key
host_726.schedule.TicketEntry.PK_CampaignDaily1CLUSTEREDYY3021901662026-09-15 01:08:352026-09-13 03:30:53USEDKEEP — primary key
host_726.schedule.QuotaSummary.PK_LedgerStatus1CLUSTEREDYY153682109710542026-09-15 13:15:292026-09-13 03:30:53USEDKEEP — primary key
host_726.schedule.ShipmentLog.PK_SalesEntry1CLUSTEREDYY4926200112862026-09-15 13:15:292026-09-15 01:08:37USEDKEEP — primary key
host_726.schedule.PricingResult.PK_CampaignDaily1CLUSTEREDYY10829273190842026-09-15 13:15:292026-09-13 03:30:54USEDKEEP — primary key
host_726.schedule.SupplierSnapshot.IX_BillingHeader3NONCLUSTERED4982044201779322026-09-15 13:15:292026-09-16 01:00:38USEDkeep — in use
host_726.schedule.SupplierSnapshot.PK_AssetStatus1CLUSTEREDYY29045926563874222180482026-09-15 13:15:302026-09-16 01:00:38USEDKEEP — primary key
host_726.schedule.SupplierSnapshot.IX_ContractLog2NONCLUSTEREDY2198385440756222026-09-15 13:15:302026-09-16 01:00:38USEDkeep — in use
host_726.schedule.BatchDetail.PK_AssetDetail1CLUSTEREDYY1072019064342026-08-20 08:06:142026-09-13 03:30:55USEDKEEP — primary key
host_726.schedule.RosterSummary.IX_BatchDetail2NONCLUSTERED6650111901364252026-09-15 13:49:422026-09-16 01:00:41USEDkeep — in use
host_726.schedule.RosterSummary.IX_ClaimHeader3NONCLUSTERED93535272501364252026-09-15 13:15:142026-09-16 01:00:41USEDkeep — in use
host_726.schedule.RosterSummary.PK_CustomerAudit1CLUSTEREDYY2313884696817032728462026-09-15 13:49:422026-09-16 01:00:41USEDKEEP — primary key
host_726.schedule.BillingDetail.IX_TicketHeader2NONCLUSTERED83840365405192952026-09-15 13:49:422026-09-16 01:00:39USEDkeep — in use
host_726.schedule.BillingDetail.PK_BillingLog1CLUSTEREDYY3592218136018626216132026-09-15 13:49:422026-09-16 01:00:39USEDKEEP — primary key
host_726.schedule.PolicyStatus.IX_ForecastAudit2NONCLUSTERED3968590011331212026-09-15 13:15:152026-09-16 01:00:42USEDkeep — in use
host_726.schedule.PolicyStatus.IX_SupplierLine3NONCLUSTERED127465911011331212026-09-15 13:15:152026-09-16 01:00:42USEDkeep — in use
host_726.schedule.PolicyStatus.PK_PricingDaily1CLUSTEREDYY115464310390198911331212026-09-15 13:15:152026-09-16 01:00:42USEDKEEP — primary key
host_726.schedule.PolicyLine.IX_TerritorySnapshot2NONCLUSTERED8682282594101075142026-09-15 13:15:152026-09-16 01:00:44USEDkeep — in use
host_726.schedule.PolicyLine.PK_BookingAudit1CLUSTEREDYY580742285012212098262026-09-15 13:15:152026-09-16 01:00:44USEDKEEP — primary key
host_726.schedule.AssetResult.IX_BillingResult2NONCLUSTERED7103100710312026-09-15 13:15:29neverUSEDkeep — in use
host_726.schedule.AssetResult.PK_TicketQueue1CLUSTEREDYY00071031neverneverUNUSEDKEEP — primary key
host_726.schedule.InvoiceAudit.IX_StaffingQueue2NONCLUSTERED11878431104092502026-09-15 13:15:152026-09-16 01:00:44USEDkeep — in use
host_726.schedule.InvoiceAudit.PK_LedgerMonthly1CLUSTEREDYY5697121611381744389822026-09-15 13:15:152026-09-16 01:00:44USEDKEEP — primary key
host_726.schedule.SettlementLog.IX_TicketLine2NONCLUSTERED9108130013576832026-09-15 13:15:152026-09-16 01:00:45USEDkeep — in use
host_726.schedule.SettlementLog.IX_PolicyLine3NONCLUSTERED17060311013576832026-09-15 13:15:152026-09-16 01:00:45USEDkeep — in use
host_726.schedule.SettlementLog.PK_CatalogMonthly1CLUSTEREDYY171629604669014548652026-09-15 13:15:152026-09-16 01:00:45USEDKEEP — 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_TicketStatus4NONCLUSTERED0288601521582026-09-14 15:25:342026-09-16 01:00:47USEDkeep — in use
host_726.schedule.ShiftHeader.IX_ShipmentLine3NONCLUSTERED4124642901521582026-09-15 13:49:422026-09-16 01:00:47USEDkeep — in use
host_726.schedule.ShiftHeader.PK_OrdersArchive1CLUSTEREDYY68757463761444992610572026-09-15 13:49:422026-09-16 01:00:47USEDKEEP — primary key
host_726.schedule.ShiftHeader.IX_BookingStatus2NONCLUSTEREDY8066275601521582026-09-15 01:10:042026-09-16 01:00:47USEDkeep — in use
host_726.schedule.PolicyLine.PK_RouteQueue1CLUSTEREDYY23233579190801521532026-09-15 13:49:422026-09-16 01:00:54USEDKEEP — primary key
host_726.schedule.PolicyLine.UX_TerritoryHistory2NONCLUSTEREDYY391800762072026-08-29 09:26:552026-09-16 01:00:54USEDkeep — in use
host_726.schedule.SalesDaily.IX_ForecastHistory2NONCLUSTERED10022026-08-18 14:16:322026-09-13 03:59:02USEDkeep — in use
host_726.schedule.SalesDaily.IX_QuotaSummary3NONCLUSTERED01022026-08-18 14:16:372026-09-13 03:59:02USEDkeep — in use
host_726.schedule.SalesDaily.PK_ClaimResult1CLUSTEREDYY05022026-08-18 14:22:132026-09-13 03:59:02USEDKEEP — primary key
host_726.schedule.RosterHistory.IX_AssetSummary2NONCLUSTERED3256299790762082026-09-15 13:49:422026-09-16 01:00:54USEDkeep — in use
host_726.schedule.RosterHistory.PK_WarehouseLine1CLUSTEREDYY1765490652762082026-09-15 13:49:422026-09-16 01:00:54USEDKEEP — primary key
host_726.schedule.ContractStaging.IX_StaffingLine2NONCLUSTERED10022026-08-18 14:16:322026-09-13 03:59:02USEDkeep — in use
host_726.schedule.ContractStaging.IX_ShiftSummary3NONCLUSTERED0002never2026-09-13 03:59:02UNUSEDreview, then DROP
host_726.schedule.ContractStaging.PK_PolicyLine1CLUSTEREDYY05022026-08-18 14:16:572026-09-13 03:59:02USEDKEEP — primary key
host_726.schedule.MeterStaging.IX_PayrollAudit2NONCLUSTERED441158341930762082026-09-15 13:49:422026-09-16 01:00:55USEDkeep — in use
host_726.schedule.MeterStaging.PK_PolicyArchive1CLUSTEREDYY1360326643762092026-09-15 13:49:422026-09-16 01:00:54USEDKEEP — primary key
host_726.schedule.SupplierEntry.IX_InvoiceStaging2NONCLUSTERED10022026-08-18 14:16:322026-09-13 03:59:03USEDkeep — in use
host_726.schedule.SupplierEntry.IX_StaffingDaily3NONCLUSTERED0002never2026-09-13 03:59:03UNUSEDreview, then DROP
host_726.schedule.SupplierEntry.PK_MeterQueue1CLUSTEREDYY05022026-08-18 14:16:572026-09-13 03:59:03USEDKEEP — primary key
host_726.schedule.ForecastEntry.IX_ContractHistory2NONCLUSTERED10022026-08-18 14:16:332026-09-13 03:59:03USEDkeep — in use
host_726.schedule.ForecastEntry.IX_ForecastLine3NONCLUSTERED02022026-08-18 14:16:372026-09-13 03:59:03USEDkeep — in use
host_726.schedule.ForecastEntry.PK_MeterSummary1CLUSTEREDYY023022026-08-18 14:22:132026-09-13 03:59:03USEDKEEP — primary key
host_726.schedule.CustomerHistory.IX_LedgerQueue2NONCLUSTERED90140503508866582026-09-15 15:09:002026-09-16 01:00:55USEDkeep — in use
host_726.schedule.CustomerHistory.PK_PayrollAudit1CLUSTEREDYY13761953545278866582026-09-15 13:49:422026-09-16 01:00:55USEDKEEP — primary key
host_726.schedule.QuotaDetail.IX_QuotaMonthly2NONCLUSTERED10022026-08-18 14:16:312026-09-13 03:59:04USEDkeep — in use
host_726.schedule.QuotaDetail.IX_TicketSummary3NONCLUSTERED01022026-08-18 14:16:372026-09-13 03:59:04USEDkeep — in use
host_726.schedule.QuotaDetail.PK_RosterHeader1CLUSTEREDYY011022026-08-18 14:17:362026-09-13 03:59:04USEDKEEP — primary key
host_726.schedule.RosterResult.IX_BookingAudit2NONCLUSTERED22596904058112026-09-08 01:06:192026-09-16 01:00:57USEDkeep — in use
host_726.schedule.RosterResult.IX_AssetStaging3NONCLUSTERED236368228004058112026-09-15 13:49:422026-09-16 01:00:57USEDkeep — in use
host_726.schedule.RosterResult.PK_PricingSummary1CLUSTEREDYY833797203091102524058112026-09-15 13:49:432026-09-16 01:00:56USEDKEEP — primary key
host_726.schedule.MeterSnapshot.IX_StaffingSummary2NONCLUSTERED10022026-08-18 14:16:322026-09-13 03:59:06USEDkeep — in use
host_726.schedule.MeterSnapshot.IX_MeterLog3NONCLUSTERED01022026-08-18 14:16:372026-09-13 03:59:06USEDkeep — in use
host_726.schedule.MeterSnapshot.PK_CampaignSnapshot1CLUSTEREDYY09022026-08-18 14:22:412026-09-13 03:59:06USEDKEEP — primary key
host_726.schedule.LedgerSnapshot.PK_RouteStatus1CLUSTEREDYY28161166507132026-09-15 13:15:302026-09-13 04:00:11USEDKEEP — primary key
host_726.schedule.LedgerSnapshot.IX_TicketLine2NONCLUSTEREDY21032026-09-05 15:31:442026-09-13 04:00:11USEDkeep — in use
host_726.schedule.RosterHistory.PK_MeterLine1CLUSTEREDYY232616793056432026-09-15 13:49:422026-09-13 04:00:11USEDKEEP — primary key
host_726.schedule.AssetStaging.PK_CampaignResult1CLUSTEREDYY113989396056432026-09-15 13:15:292026-09-15 03:09:18USEDKEEP — primary key
host_726.schedule.InvoiceLog.PK_CatalogSummary1CLUSTEREDYY57202872313242026-09-15 15:09:002026-09-13 03:30:54USEDKEEP — primary key
host_726.schedule.InvoiceLog.IX_WarehouseHeader2NONCLUSTEREDY1360042026-09-15 13:18:062026-09-13 03:30:54USEDkeep — in use
host_726.schedule.ContractResult.PK_StaffingSummary1CLUSTEREDYY031741042026-09-15 15:09:002026-09-13 03:30:54USEDKEEP — primary key
host_726.schedule.ContractResult.UX_CampaignHistory2NONCLUSTEREDYY28188042026-09-15 13:18:532026-09-13 03:30:54USEDkeep — in use
host_726.schedule.SalesArchive.IX_RosterStatus1CLUSTERED0004never2026-09-13 03:30:54UNUSEDKEEP — table storage
host_726.schedule.CatalogHistory.PK_OrdersStatus1CLUSTEREDYY279154002026-09-15 13:49:322026-09-13 03:30:54USEDKEEP — primary key
host_726.schedule.CatalogHistory.IX_PricingStatus2NONCLUSTEREDY0000never2026-09-13 03:30:54UNUSEDreview carefully — unique
host_726.schedule.engine.PK_ReconcileDaily1CLUSTEREDYY1108391610964722026-09-15 13:15:302026-09-13 03:59:07USEDKEEP — primary key
host_726.schedule.engine.UQ_MeterQueue2NONCLUSTEREDY1097040012026-09-15 13:15:292026-09-13 03:59:07USEDkeep — in use
host_726.schedule.TerritoryAudit.PK_PayrollSnapshot1CLUSTEREDYY00106142694792026-09-15 13:15:302026-09-16 01:00:59USEDKEEP — primary key
host_726.schedule.TerritoryAudit.UX_BookingHeader2NONCLUSTEREDYY10614200366882026-09-15 13:15:302026-09-16 01:00:59USEDkeep — in use
host_726.schedule.WarehouseArchive.IX_CustomerHistory2NONCLUSTERED00065501neverneverUNUSEDreview, then DROP
host_726.schedule.WarehouseArchive.IX_OrdersHeader3NONCLUSTERED3306810655012026-09-15 13:15:29neverUSEDkeep — in use
host_726.schedule.WarehouseArchive.PK_RouteAudit1CLUSTEREDYY1004603307101004612026-09-15 13:15:30neverUSEDKEEP — primary key
host_726.schedule.LedgerMonthly.IX_CatalogDaily2NONCLUSTERED0001728764neverneverUNUSEDreview, then DROP
host_726.schedule.LedgerMonthly.IX_CustomerMonthly3NONCLUSTERED330681017287642026-09-15 13:15:29neverUSEDkeep — in use
host_726.schedule.LedgerMonthly.PK_ClaimLine1CLUSTEREDYY25931411025931432026-09-15 13:15:30neverUSEDKEEP — primary key
host_726.schedule.RouteAudit.IX_InvoiceHeader2NONCLUSTERED8001671262026-08-22 10:11:072026-09-16 01:01:00USEDkeep — in use
host_726.schedule.RouteAudit.IX_SettlementDetail3NONCLUSTEREDY5547555703063602026-09-03 11:27:42neverUSEDkeep — in use
host_726.schedule.RouteAudit.IX_CatalogArchive4NONCLUSTERED0701671262026-09-11 09:09:552026-09-16 01:01:00USEDkeep — in use
host_726.schedule.RouteAudit.IX_QuotaStaging5NONCLUSTERED0501671262026-08-25 14:29:202026-09-16 01:01:00USEDkeep — in use
host_726.schedule.RouteAudit.PK_PayrollAudit1CLUSTEREDYY7579365155743083572026-09-11 09:09:552026-09-16 01:00:59USEDKEEP — primary key
host_726.schedule.ShipmentHeader.IX_QuotaSnapshot2NONCLUSTERED000864382never2026-09-15 03:07:14UNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_InvoiceSummary4NONCLUSTERED000864382never2026-09-15 03:07:30UNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_CampaignHistory3NONCLUSTERED000864382never2026-09-15 03:07:35UNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.PK_CampaignDetail1CLUSTEREDYY000864382never2026-09-16 01:01:01UNUSEDKEEP — primary key
host_726.schedule.SupplierEntry.PK_AssetSnapshot1CLUSTEREDYY4608011022026-09-15 13:15:292026-09-13 03:59:21USEDKEEP — primary key
host_726.schedule.TerritoryDetail.PK_ReconcileMonthly1CLUSTEREDYY57501162026-09-12 14:11:202026-09-13 03:59:21USEDKEEP — primary key
host_726.schedule.StaffingEntry.PK_QuotaDetail1CLUSTEREDYY5209626177531732026-09-15 13:15:302026-09-13 03:59:21USEDKEEP — primary key
host_726.schedule.StaffingEntry.UQ_TicketDetail2NONCLUSTEREDY5720582026-09-12 14:11:202026-09-13 03:59:21USEDkeep — in use
host_726.schedule.StaffingEntry.UX_PayrollDaily3NONCLUSTEREDYY9218995301162026-09-15 13:15:292026-09-13 03:59:21USEDkeep — in use
host_726.schedule.ForecastMonthly.IX_WarehouseDaily2NONCLUSTERED190052094542026-09-11 13:52:352026-09-15 03:08:43USEDkeep — in use
host_726.schedule.ForecastMonthly.IX_PayrollHistory3NONCLUSTERED20052094542026-08-25 14:20:052026-09-15 03:08:59USEDkeep — in use
host_726.schedule.ForecastMonthly.IX_BatchMonthly4NONCLUSTERED0005209454never2026-09-15 03:09:17UNUSEDreview, then DROP
host_726.schedule.ForecastMonthly.PK_ForecastHistory1CLUSTEREDYY52094501119104189042026-09-15 13:15:302026-09-15 03:07:36USEDKEEP — primary key
host_726.schedule.CatalogEntry.PK_PolicyDetail1CLUSTEREDYY9219022322026-09-15 13:15:292026-09-13 04:00:10USEDKEEP — primary key
host_726.schedule.CatalogEntry.UQ_AssetAudit2NONCLUSTEREDY30012026-09-14 15:36:352026-09-13 04:00:10USEDkeep — in use
host_726.schedule.ContractAudit.PK_TicketSummary1CLUSTEREDYY52094552022026-09-15 13:15:302026-09-13 04:00:10USEDKEEP — primary key
host_726.schedule.ContractAudit.UQ_OrdersStaging2NONCLUSTEREDY0001never2026-09-13 04:00:10UNUSEDreview carefully — unique
host_726.schedule.ContractAudit.UX_BillingSnapshot3NONCLUSTEREDYY9218990022026-09-15 13:15:292026-09-13 04:00:11USEDkeep — in use
host_726.schedule.SupplierSummary.PK_LedgerEntry1CLUSTEREDYY063022026-09-14 15:36:352026-09-13 04:00:11USEDKEEP — primary key
host_726.schedule.SupplierSummary.UQ_BillingStaging2NONCLUSTEREDY0001never2026-09-13 04:00:11UNUSEDreview carefully — unique
host_726.schedule.PayrollDaily.PK_CustomerQueue1CLUSTEREDYY8498812736032026-09-15 13:15:152026-09-13 04:00:11USEDKEEP — primary key
host_726.schedule.WarehouseDaily.PK_QuotaAudit1CLUSTEREDYY579022026-09-14 15:36:352026-09-13 04:00:11USEDKEEP — primary key
host_726.schedule.WarehouseDaily.UQ_ShiftEntry2NONCLUSTEREDY0001never2026-09-13 04:00:11UNUSEDreview carefully — unique
host_726.schedule.WarehouseDaily.UX_TerritorySummary3NONCLUSTEREDYY570022026-09-12 14:11:202026-09-13 04:00:11USEDkeep — in use
host_726.schedule.sql.IX_PayrollEntry3NONCLUSTEREDY9219573502752026-09-15 13:15:292026-09-13 04:00:11USEDkeep — in use
host_726.schedule.sql.PK_ContractMonthly1CLUSTEREDYY696684102752026-09-14 15:36:352026-09-13 04:00:11USEDKEEP — primary key
host_726.schedule.sql.UQ_SalesStatus2NONCLUSTEREDY453182072026-09-14 14:07:162026-09-13 04:00:11USEDkeep — in use
host_726.schedule.LedgerStatus.PK_SettlementQueue1CLUSTEREDYY03022026-08-22 13:50:142026-09-13 04:00:12USEDKEEP — primary key
host_726.schedule.LedgerStatus.UQ_QuotaAudit2NONCLUSTEREDY0001never2026-09-13 04:00:12UNUSEDreview carefully — unique
host_726.schedule.OrdersQueue.PK_QuotaQueue1CLUSTEREDYY57501162026-09-12 14:11:202026-09-13 04:00:12USEDKEEP — primary key
host_726.schedule.LedgerStaging.IX_StaffingLog3NONCLUSTERED92279616009552026-09-15 13:15:292026-09-15 03:09:18USEDkeep — in use
host_726.schedule.LedgerStaging.PK_ContractQueue1CLUSTEREDYY52103741019221469552026-09-15 13:15:302026-09-15 03:09:18USEDKEEP — primary key
host_726.schedule.LedgerStaging.UQ_TicketResult2NONCLUSTEREDY91502682026-09-12 14:13:472026-09-15 03:09:18USEDkeep — in use
host_726.schedule.LedgerStaging.UX_QuotaHeader4NONCLUSTEREDYY000688never2026-09-15 03:09:18UNUSEDreview carefully — unique
host_726.schedule.step.PK_AssetStaging1CLUSTEREDYY10741745322026-09-15 13:15:302026-09-13 04:00:14USEDKEEP — primary key
host_726.schedule.step.UQ_AssetQueue3NONCLUSTEREDY30012026-09-14 15:36:352026-09-13 04:00:14USEDkeep — in use
host_726.schedule.step.UQ_OrdersLine2NONCLUSTEREDY110012026-09-11 20:29:502026-09-13 04:00:14USEDkeep — in use
host_726.schedule.ShipmentResult.PK_MeterSnapshot1CLUSTEREDYY57501162026-09-12 14:11:202026-09-13 04:00:16USEDKEEP — primary key
host_726.schedule.WarehouseEntry.PK_SettlementLine1CLUSTEREDYY5209569922031022026-09-15 13:15:302026-09-13 04:00:16USEDKEEP — primary key
host_726.schedule.WarehouseEntry.UQ_ShiftSnapshot2NONCLUSTEREDY09012026-08-24 09:43:112026-09-13 04:00:16USEDkeep — in use
host_726.schedule.WarehouseEntry.UX_OrdersLog3NONCLUSTEREDYY0002never2026-09-13 04:00:16UNUSEDreview carefully — unique
host_726.wps.ContractStatus.IX_RosterDaily2NONCLUSTERED00082183never2026-09-13 04:00:16UNUSEDreview, then DROP
host_726.wps.ContractStatus.PK_ClaimLog1CLUSTEREDYY0821830821832026-09-16 01:01:032026-09-13 04:00:16USEDKEEP — primary key
host_726.wps.ContractStatus.UX_TerritoryResult3NONCLUSTEREDYY0000never2026-09-13 04:00:16COLDreview carefully — unique
host_726.wps.ContractStatus.UX_SettlementDetail4NONCLUSTEREDY0000never2026-09-13 04:00:16UNUSEDreview carefully — unique
host_726.wps.PolicyResult.IX_ContractSnapshot2NONCLUSTERED30600282026-09-15 13:48:002026-09-13 04:00:16USEDkeep — in use
host_726.wps.PolicyResult.PK_SettlementLine1CLUSTEREDYY120736276282026-09-15 13:48:002026-09-13 04:00:16USEDKEEP — primary key
host_726.wps.LedgerMonthly.PK_BookingResult1CLUSTEREDYY00042never2026-09-13 04:00:16UNUSEDKEEP — primary key
host_726.wps.BookingStaging.PK_ClaimHistory1CLUSTEREDYY191850432026-09-10 15:00:072026-09-13 04:00:16USEDKEEP — primary key
host_726.wps.SalesHeader.PK_ContractHistory1CLUSTEREDYY00070never2026-09-13 04:00:16UNUSEDKEEP — primary key
host_726.wps.ForecastResult.PK_QuotaLog1CLUSTEREDYY514802017815332026-09-15 23:59:002026-09-15 03:09:19USEDKEEP — primary key
host_726.wps.ForecastResult.UQ_ShipmentArchive5NONCLUSTEREDY217462015302026-09-16 00:00:002026-09-15 03:09:19USEDkeep — in use
host_726.wps.StaffingResult.PK_RosterStatus1CLUSTEREDYY89901042026-09-16 01:01:002026-09-13 04:00:16USEDKEEP — primary key
host_726.wps.StaffingStaging.PK_PolicyEntry1CLUSTEREDYY0004never2026-09-13 04:00:16UNUSEDKEEP — primary key
host_726.wps.QuotaDetail.PK_BatchQueue1CLUSTEREDYY0000never2026-09-13 04:00:17UNUSEDKEEP — primary key
host_726.wps.OrdersLog.PK_WarehouseArchive1CLUSTEREDYY0000never2026-09-13 04:00:17UNUSEDKEEP — primary key
host_726.wps.TerritoryQueue.IX_InvoiceAudit10NONCLUSTERED6784404492026-09-15 13:48:002026-09-13 04:00:17USEDkeep — in use
host_726.wps.TerritoryQueue.PK_RosterSnapshot1CLUSTEREDYY221765594492026-09-15 13:48:002026-09-13 04:00:17USEDKEEP — primary key
host_726.wps.TerritoryQueue.UX_MeterStaging2NONCLUSTEREDY5104504462026-09-15 13:48:002026-09-13 04:00:17USEDkeep — in use
host_726.wps.ContractEntry.PK_PayrollSummary1CLUSTEREDYY000446never2026-09-13 04:00:17UNUSEDKEEP — primary key
host_726.wps.TicketStatus.PK_InvoiceMonthly1CLUSTEREDYY353290282026-09-15 23:59:002026-09-15 03:09:20USEDKEEP — primary key
host_726.wps.SalesDetail.PK_SettlementLine1CLUSTEREDYY000556never2026-09-15 03:09:20UNUSEDKEEP — primary key
host_726.wps.ClaimResult.PK_TicketEntry1CLUSTEREDYY378012026-09-10 13:20:592026-09-13 04:00:17USEDKEEP — primary key
host_726.wps.CatalogSnapshot.PK_ForecastHeader1CLUSTEREDYY0004never2026-09-13 04:00:17UNUSEDKEEP — primary key
host_726.wps.BillingLine.PK_RosterResult1CLUSTEREDYY19484705052026-09-15 23:59:002026-09-13 04:00:17USEDKEEP — primary key
host_726.wps.BillingLine.UX_WarehouseLog2NONCLUSTEREDYY100052026-09-10 13:21:402026-09-13 04:00:17USEDkeep — in use
host_726.wps.BatchStatus.PK_ClaimLine1CLUSTEREDYY28189452026-09-15 13:48:002026-09-13 04:00:17USEDKEEP — primary key
host_726.wps.BatchStatus.UQ_CustomerHeader2NONCLUSTEREDY940052026-09-12 08:29:062026-09-13 04:00:17USEDkeep — in use
host_726.wps.BookingResult.PK_WarehouseMonthly1CLUSTEREDYY0005never2026-09-13 04:00:17UNUSEDKEEP — primary key
host_726.wps.BookingStaging.PK_ForecastLog1CLUSTEREDYY01610102026-09-10 13:07:202026-09-13 04:00:17USEDKEEP — primary key
QUOTA.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-13 04:00:18UNUSEDKEEP — primary key
QUOTA.cfg.QuotaStatus.UX_MeterSummary2NONCLUSTEREDY0000never2026-09-13 04:00:18UNUSEDreview carefully — unique
QUOTA.dbo.ContractResult.PK_CampaignResult1CLUSTEREDYY0000never2026-09-13 04:00:18UNUSEDKEEP — primary key
QUOTA.dbo.SettlementStaging.PK_TicketStaging1CLUSTEREDYY0000never2026-09-13 04:00:18UNUSEDKEEP — 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-13 04:00:19UNUSEDKEEP — primary key
QUOTA.dbo.WarehouseEntry.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-13 04:00:19UNUSEDKEEP — primary key
QUOTA.dbo.WarehouseEntry.UX_CampaignHeader2NONCLUSTEREDY0000never2026-09-13 04:00:19UNUSEDreview carefully — unique
QUOTA.dbo.TicketSummary.PK_SalesLine1CLUSTERED0000never2026-09-13 04:00:19UNUSEDKEEP — table storage
QUOTA.dbo.TerritoryEntry.PK_SalesSummary1CLUSTEREDYY0000never2026-09-13 04:00:19UNUSEDKEEP — primary key
QUOTA.dbo.TerritoryEntry.UX_TerritoryQueue2NONCLUSTEREDY0000never2026-09-13 04:00:19UNUSEDreview carefully — unique
QUOTA.dbo.PolicyEntry.PK_TicketEntry1CLUSTEREDYY0000never2026-09-13 04:00:19UNUSEDKEEP — primary key
QUOTA.dbo.PolicyEntry.UX_PolicyAudit2NONCLUSTEREDY0000never2026-09-13 04:00:19UNUSEDreview carefully — unique
QUOTA.dbo.CampaignHeader.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-13 04:00:19UNUSEDKEEP — primary key
QUOTA.dbo.CampaignHeader.UX_BillingLog2NONCLUSTEREDY0000never2026-09-13 04:00:19UNUSEDreview carefully — unique
QUOTA.dbo.WarehouseHeader.PK_OrdersQueue1CLUSTEREDYY0000never2026-09-13 04:00:19UNUSEDKEEP — primary key
QUOTA.dbo.WarehouseHeader.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-13 04:00:19UNUSEDreview carefully — unique
QUOTA.dbo.RouteQueue.PK_SupplierAudit1CLUSTEREDYY0000never2026-09-13 04:00:19UNUSEDKEEP — primary key
QUOTA.dbo.RouteQueue.UX_CampaignQueue2NONCLUSTEREDY0000never2026-09-13 04:00:19UNUSEDreview carefully — unique
QUOTA.dbo.CampaignAudit.PK_BatchSnapshot1CLUSTEREDYY0000never2026-09-13 04:00:19UNUSEDKEEP — primary key
QUOTA.dbo.CampaignAudit.UX_SupplierArchive2NONCLUSTEREDY0000never2026-09-13 04:00:19UNUSEDreview carefully — unique
QUOTA.dbo.ShiftDaily.PK_ReconcileStatus1CLUSTEREDYY0000never2026-09-13 04:00:19UNUSEDKEEP — primary key
QUOTA.dbo.ShiftDaily.UX_RouteDaily2NONCLUSTEREDY0000never2026-09-13 04:00:19UNUSEDreview carefully — unique
QUOTA.emp.WarehouseMonthly.PK_PricingHistory1CLUSTEREDYY0000never2026-09-13 04:00:20UNUSEDKEEP — primary key
QUOTA.emp.WarehouseMonthly.UX_CustomerDetail2NONCLUSTEREDYY0000never2026-09-13 04:00:20UNUSEDreview carefully — unique
QUOTA.emp.SettlementLine.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-13 04:00:20UNUSEDKEEP — primary key
QUOTA.emp.SalesDetail.PK_BillingLog1CLUSTEREDYY0000never2026-09-13 04:00:20UNUSEDKEEP — primary key
QUOTA.emp.BatchMonthly.PK_TicketAudit1CLUSTEREDYY0000never2026-09-13 04:00:20UNUSEDKEEP — primary key
QUOTA.emp.RosterLog.PK_QuotaLog1CLUSTEREDYY0000never2026-09-13 04:00:20UNUSEDKEEP — primary key
QUOTA.emp.QuotaMonthly.IX_ShipmentEntry15NONCLUSTERED0000never2026-09-13 04:00:20UNUSEDreview, then DROP
QUOTA.emp.QuotaMonthly.PK_ReconcileDetail1CLUSTEREDYY0000never2026-09-13 04:00:20UNUSEDKEEP — primary key
QUOTA.emp.OrdersEntry.PK_PolicyHeader1CLUSTEREDYY0000never2026-09-13 04:00:20UNUSEDKEEP — primary key
QUOTA.emp.PayrollSummary.PK_RouteSummary1CLUSTEREDYY0000never2026-09-13 04:00:20UNUSEDKEEP — primary key
QUOTA.emp.SettlementAudit.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-13 04:00:21UNUSEDKEEP — primary key
QUOTA.emp.InvoiceLog.PK_BatchEntry1CLUSTEREDYY0000never2026-09-13 04:00:21UNUSEDKEEP — 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-13 04:00:21UNUSEDKEEP — primary key
QUOTA.emp.RouteHistory.UX_CustomerQueue2NONCLUSTEREDY0000never2026-09-13 04:00:21UNUSEDreview carefully — unique
QUOTA.emp.CustomerHistory.PK_ShiftDaily1CLUSTEREDYY0000never2026-09-13 04:00:21UNUSEDKEEP — 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-13 04:00:22UNUSEDreview, then DROP
QUOTA.emp.MeterResult.PK_CustomerResult1CLUSTEREDYY0000never2026-09-13 04:00:21UNUSEDKEEP — primary key
QUOTA.emp.PayrollHeader.PK_TicketHistory1CLUSTEREDYY0000never2026-09-13 04:00:22UNUSEDKEEP — primary key
QUOTA.emp.OrdersAudit.PK_ShipmentHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.RosterResult.PK_MeterAudit1CLUSTEREDYY0000never2026-09-13 04:00:22UNUSEDKEEP — primary key
QUOTA.emp.RouteHeader.PK_StaffingQueue1CLUSTEREDYY0000never2026-09-13 04:00:22UNUSEDKEEP — primary key
QUOTA.emp.MeterAudit.PK_ClaimLog1CLUSTEREDYY0000never2026-09-13 04:00:22UNUSEDKEEP — primary key
QUOTA.emp.QuotaStatus.PK_OrdersArchive1CLUSTEREDYY0000never2026-09-13 04:00:22UNUSEDKEEP — primary key
QUOTA.emp.ShiftLine.IX_PricingAudit13NONCLUSTERED0000never2026-09-13 04:00:22UNUSEDreview, then DROP
QUOTA.emp.ShiftLine.PK_SettlementStatus1CLUSTEREDYY0000never2026-09-13 04:00:22UNUSEDKEEP — primary key
QUOTA.emp.ShiftLine.UX_BookingDaily2NONCLUSTEREDY0000never2026-09-13 04:00:22UNUSEDreview carefully — unique
QUOTA.emp.CampaignHeader.PK_BillingQueue1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.MeterStatus.PK_BillingStaging1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.WarehouseStaging.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.ForecastHeader.IX_WarehouseResult6NONCLUSTERED0000never2026-09-13 04:00:23UNUSEDreview, then DROP
QUOTA.emp.ForecastHeader.PK_OrdersAudit1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.SalesLog.PK_AssetStaging1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.AssetDaily.PK_CustomerMonthly1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.StaffingDaily.PK_BookingLog1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.ReconcileDetail.PK_AssetHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ClaimResult.PK_TerritoryQueue1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.CatalogLog.PK_ReconcileHeader1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.ShipmentSnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.PricingDaily.IX_ShiftAudit2NONCLUSTERED0000never2026-09-13 04:00:23UNUSEDreview, then DROP
QUOTA.emp.PricingDaily.PK_RouteEntry1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.PolicyLog.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-13 04:00:23UNUSEDKEEP — primary key
QUOTA.emp.PolicyLog.UX_OrdersSnapshot4NONCLUSTEREDY0000never2026-09-13 04:00:23UNUSEDreview carefully — unique
QUOTA.emp.RouteAudit.PK_ClaimResult1CLUSTEREDYY0000never2026-09-13 04:00:24UNUSEDKEEP — primary key
QUOTA.emp.WarehouseArchive.PK_StaffingArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.MeterHistory.IX_ContractArchive11NONCLUSTERED0000never2026-09-13 04:00:24UNUSEDreview, then DROP
QUOTA.emp.MeterHistory.PK_BatchLog1CLUSTEREDYY0000never2026-09-13 04:00:24UNUSEDKEEP — primary key
QUOTA.emp.MeterHistory.UX_BatchLog3NONCLUSTEREDYY0000never2026-09-13 04:00:24UNUSEDreview carefully — unique
QUOTA.emp.MeterHistory.UX_ForecastHeader20NONCLUSTEREDY0000never2026-09-13 04:00:24UNUSEDreview carefully — unique
QUOTA.emp.MeterHistory.UX_CustomerSnapshot2NONCLUSTEREDYY0000never2026-09-13 04:00:24UNUSEDreview carefully — unique
QUOTA.emp.MeterHistory.UX_QuotaStaging13NONCLUSTEREDY0000never2026-09-13 04:00:24UNUSEDreview 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-13 04:00:24UNUSEDKEEP — primary key
QUOTA.emp.TicketQueue.UX_PayrollDaily2NONCLUSTEREDY0000never2026-09-13 04:00:24UNUSEDreview carefully — unique
QUOTA.emp.MeterStatus.PK_CustomerDetail1CLUSTEREDYY0000never2026-09-13 04:00:24UNUSEDKEEP — primary key
QUOTA.emp.OrdersEntry.PK_TerritoryAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.InvoiceLog.PK_BillingDetail1CLUSTEREDYY0000never2026-09-13 04:00:24UNUSEDKEEP — primary key
QUOTA.emp.CampaignHistory.IX_QuotaDetail2NONCLUSTERED0000never2026-09-13 04:00:24UNUSEDreview, then DROP
QUOTA.emp.CampaignHistory.PK_AssetHeader1CLUSTEREDYY0000never2026-09-13 04:00:24UNUSEDKEEP — primary key
QUOTA.emp.ContractArchive.PK_BookingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.TicketLine.PK_CampaignEntry1CLUSTEREDYY0000never2026-09-13 04:00:25UNUSEDKEEP — primary key
QUOTA.emp.BatchAudit.PK_ForecastSummary1CLUSTEREDYY0000never2026-09-13 04:00:25UNUSEDKEEP — primary key
QUOTA.emp.BatchAudit.UX_LedgerStaging2NONCLUSTEREDY0000never2026-09-13 04:00:25UNUSEDreview carefully — unique
QUOTA.emp.ClaimAudit.PK_LedgerDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ClaimAudit.UX_RouteMonthly2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.PolicyHistory.PK_OrdersDaily1CLUSTEREDYY0000never2026-09-13 04:00:26UNUSEDKEEP — primary key
QUOTA.emp.BillingEntry.PK_StaffingAudit1CLUSTEREDYY0000never2026-09-13 04:00:26UNUSEDKEEP — primary key
QUOTA.emp.BillingEntry.UX_StaffingLog2NONCLUSTEREDY0000never2026-09-13 04:00:26UNUSEDreview carefully — unique
QUOTA.emp.BillingAudit.PK_PolicyDetail1CLUSTEREDYY0000never2026-09-13 04:00:27UNUSEDKEEP — primary key
QUOTA.emp.BillingAudit.UX_SupplierSnapshot2NONCLUSTEREDY0000never2026-09-13 04:00:27UNUSEDreview carefully — unique
QUOTA.emp.ShipmentStaging.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-13 04:00:27UNUSEDKEEP — primary key
QUOTA.emp.ShipmentStaging.UX_RosterDaily2NONCLUSTEREDY0000never2026-09-13 04:00:27UNUSEDreview carefully — unique
QUOTA.emp.SalesLine.PK_CampaignResult1CLUSTEREDYY0000never2026-09-13 04:00:27UNUSEDKEEP — primary key
QUOTA.emp.ContractLog.PK_BookingSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ContractLog.UX_ClaimDetail2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.LedgerSnapshot.PK_CampaignStatus1CLUSTEREDYY0000never2026-09-13 04:00:27UNUSEDKEEP — primary key
QUOTA.emp.BookingSnapshot.PK_ReconcileStaging1CLUSTEREDYY0000never2026-09-13 04:00:27UNUSEDKEEP — primary key
QUOTA.emp.ReconcileDetail.PK_CampaignQueue1CLUSTEREDYY0000never2026-09-13 04:00:27UNUSEDKEEP — primary key
QUOTA.emp.PolicyStaging.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ReconcileStaging.PK_ContractStaging1CLUSTEREDYY0000never2026-09-13 04:00:28UNUSEDKEEP — primary key
QUOTA.emp.ReconcileStaging.UX_OrdersHistory2NONCLUSTEREDY0000never2026-09-13 04:00:28UNUSEDreview carefully — unique
QUOTA.emp.MeterStatus.PK_ReconcileMonthly1CLUSTEREDYY0000never2026-09-13 04:00:28UNUSEDKEEP — primary key
QUOTA.emp.MeterStatus.UX_ReconcileAudit7NONCLUSTEREDY0000never2026-09-13 04:00:28UNUSEDreview carefully — unique
QUOTA.emp.PricingAudit.PK_ReconcileSnapshot1CLUSTEREDYY0000never2026-09-13 04:00:28UNUSEDKEEP — primary key
QUOTA.emp.RosterQueue.PK_SettlementHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ContractLog.PK_SupplierStatus1CLUSTEREDYY0000never2026-09-13 04:00:28UNUSEDKEEP — primary key
QUOTA.emp.BatchStatus.PK_QuotaLog1CLUSTEREDYY0000never2026-09-13 04:00:28UNUSEDKEEP — 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-13 04:00:28UNUSEDKEEP — primary key
QUOTA.emp.InvoiceAudit.PK_QuotaEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.MeterSummary.PK_AssetEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.AssetSummary.PK_SupplierStaging1CLUSTEREDYY0000never2026-09-13 04:00:29UNUSEDKEEP — primary key
QUOTA.emp.SupplierStaging.IX_MeterStaging12NONCLUSTERED0000never2026-09-13 04:00:29UNUSEDreview, then DROP
QUOTA.emp.SupplierStaging.PK_PayrollMonthly1CLUSTEREDYY0000never2026-09-13 04:00:29UNUSEDKEEP — primary key
QUOTA.emp.CustomerStatus.PK_PolicyHistory1CLUSTEREDYY0000never2026-09-13 04:00:30UNUSEDKEEP — primary key
QUOTA.emp.BillingAudit.PK_CustomerEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.PolicyLine.PK_OrdersSummary1CLUSTEREDYY0000never2026-09-13 04:00:30UNUSEDKEEP — primary key
QUOTA.emp.RouteStaging.PK_WarehouseLine1CLUSTEREDYY0000never2026-09-13 04:00:30UNUSEDKEEP — primary key
QUOTA.emp.CampaignMonthly.PK_OrdersArchive1CLUSTEREDYY0000never2026-09-13 04:00:30UNUSEDKEEP — primary key
QUOTA.emp.CatalogSnapshot.PK_ClaimHistory1CLUSTEREDYY0000never2026-09-13 04:00:31UNUSEDKEEP — primary key
QUOTA.emp.BillingDaily.PK_CustomerLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.BillingDaily.UX_LedgerDaily2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.SupplierHistory.PK_WarehouseMonthly1CLUSTEREDYY0000never2026-09-13 04:00:31UNUSEDKEEP — primary key
QUOTA.emp.ShipmentMonthly.IX_InvoiceStaging5NONCLUSTERED0000never2026-09-13 04:00:31UNUSEDreview, then DROP
QUOTA.emp.ShipmentMonthly.PK_BatchDaily1CLUSTEREDYY0000never2026-09-13 04:00:31UNUSEDKEEP — primary key
QUOTA.emp.AssetDetail.PK_ReconcileResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.AssetSnapshot.IX_SalesDaily5NONCLUSTERED0000never2026-09-13 04:00:31UNUSEDreview, then DROP
QUOTA.emp.AssetSnapshot.PK_OrdersDetail1CLUSTEREDYY0000never2026-09-13 04:00:31UNUSEDKEEP — primary key
QUOTA.emp.PricingStatus.PK_PolicyStatus1CLUSTEREDYY0000never2026-09-13 04:00:31UNUSEDKEEP — primary key
QUOTA.emp.TicketSnapshot.PK_CampaignQueue1CLUSTEREDYY0000never2026-09-13 04:00:31UNUSEDKEEP — primary key
QUOTA.emp.ForecastMonthly.PK_CampaignSummary1CLUSTEREDYY0000never2026-09-13 04:00:31UNUSEDKEEP — primary key
QUOTA.emp.PricingStatus.IX_QuotaLog8NONCLUSTERED0000never2026-09-13 04:00:31UNUSEDreview, then DROP
QUOTA.emp.PricingStatus.IX_ClaimEntry6NONCLUSTERED0000never2026-09-13 04:00:31UNUSEDreview, then DROP
QUOTA.emp.PricingStatus.PK_LedgerResult1CLUSTEREDYY0000never2026-09-13 04:00:31UNUSEDKEEP — primary key
QUOTA.emp.PayrollHistory.PK_LedgerQueue1CLUSTEREDYY0000never2026-09-13 04:00:31UNUSEDKEEP — primary key
QUOTA.emp.QuotaSummary.PK_LedgerEntry1CLUSTEREDYY0000never2026-09-13 04:00:31UNUSEDKEEP — primary key
QUOTA.emp.PricingQueue.PK_PricingStaging1CLUSTEREDYY0000never2026-09-13 04:00:32UNUSEDKEEP — primary key
QUOTA.emp.BookingMonthly.IX_ShipmentAudit5NONCLUSTERED0000never2026-09-13 04:00:32UNUSEDreview, then DROP
QUOTA.emp.BookingMonthly.PK_WarehouseLog1CLUSTEREDYY0000never2026-09-13 04:00:32UNUSEDKEEP — primary key
QUOTA.emp.MeterSnapshot.PK_StaffingSummary1CLUSTEREDYY0000never2026-09-13 04:00:32UNUSEDKEEP — primary key
QUOTA.emp.BatchMonthly.PK_InvoiceDetail1CLUSTEREDYY0000never2026-09-13 04:00:32UNUSEDKEEP — primary key
QUOTA.emp.StaffingAudit.PK_ForecastHeader1CLUSTEREDYY0000never2026-09-13 04:00:32UNUSEDKEEP — primary key
QUOTA.emp.BatchLog.PK_SalesDetail1CLUSTEREDYY0000never2026-09-13 04:00:32UNUSEDKEEP — primary key
QUOTA.emp.RouteHistory.PK_MeterEntry1CLUSTEREDYY0000never2026-09-13 04:00:32UNUSEDKEEP — primary key
QUOTA.emp.CampaignResult.IX_ForecastAudit9NONCLUSTERED0000never2026-09-13 04:00:32UNUSEDreview, then DROP
QUOTA.emp.CampaignResult.IX_CustomerQueue12NONCLUSTERED0000never2026-09-13 04:00:32UNUSEDreview, then DROP
QUOTA.emp.CampaignResult.PK_StaffingArchive1CLUSTEREDYY0000never2026-09-13 04:00:32UNUSEDKEEP — primary key
QUOTA.emp.PayrollHistory.PK_CampaignStaging1CLUSTEREDYY0000never2026-09-13 04:00:33UNUSEDKEEP — primary key
QUOTA.emp.TerritoryDaily.PK_RouteArchive1CLUSTEREDYY0000never2026-09-13 04:00:33UNUSEDKEEP — primary key
QUOTA.emp.CatalogSummary.IX_WarehouseSnapshot19NONCLUSTERED0000never2026-09-13 04:00:33UNUSEDreview, then DROP
QUOTA.emp.CatalogSummary.IX_ReconcileSummary16NONCLUSTERED0000never2026-09-13 04:00:33UNUSEDreview, then DROP
QUOTA.emp.CatalogSummary.PK_ShipmentStaging1CLUSTEREDYY0000never2026-09-13 04:00:33UNUSEDKEEP — primary key
QUOTA.emp.CatalogSummary.UX_OrdersAudit5NONCLUSTEREDY0000never2026-09-13 04:00:33UNUSEDreview carefully — unique
QUOTA.emp.CatalogSummary.UX_LedgerHistory12NONCLUSTEREDYY0000never2026-09-13 04:00:33UNUSEDreview carefully — unique
QUOTA.emp.TicketMonthly.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-13 04:00:33UNUSEDKEEP — primary key
QUOTA.emp.BillingQueue.IX_ContractSummary8NONCLUSTERED0000never2026-09-13 04:00:33UNUSEDreview, then DROP
QUOTA.emp.BillingQueue.PK_ShipmentEntry1CLUSTEREDYY0000never2026-09-13 04:00:33UNUSEDKEEP — primary key
QUOTA.emp.CampaignResult.PK_CustomerLine1CLUSTEREDYY0000never2026-09-13 04:00:34UNUSEDKEEP — primary key
QUOTA.org.SettlementSnapshot.PK_org.SettlementSnapshot1CLUSTEREDYY0000never2026-09-13 04:00:34UNUSEDKEEP — primary key
QUOTA.org.SettlementSnapshot.UX_BillingLine2NONCLUSTEREDY0000never2026-09-13 04:00:34UNUSEDreview carefully — unique
QUOTA.org.PolicySummary.IX_AssetEntry17NONCLUSTERED0000never2026-09-13 04:00:34UNUSEDreview, then DROP
QUOTA.org.PolicySummary.PK_QuotaAudit1CLUSTEREDYY0000never2026-09-13 04:00:34UNUSEDKEEP — primary key
QUOTA.org.PolicySummary.UX_ForecastHistory2NONCLUSTEREDYY0000never2026-09-13 04:00:34UNUSEDreview carefully — unique
QUOTA.org.CampaignQueue.PK_RosterDaily1CLUSTEREDYY0000never2026-09-13 04:00:34UNUSEDKEEP — primary key
QUOTA.org.TicketLog.PK_WarehouseDetail1CLUSTEREDYY0000never2026-09-13 04:00:34UNUSEDKEEP — primary key
QUOTA.org.TicketLog.UX_SalesMonthly4NONCLUSTEREDY0000never2026-09-13 04:00:34UNUSEDreview carefully — unique
QUOTA.org.BatchDaily.PK_QuotaStaging1CLUSTEREDYY0000never2026-09-13 04:00:34UNUSEDKEEP — primary key
QUOTA.org.BatchDaily.UX_PricingResult8NONCLUSTEREDYY0000never2026-09-13 04:00:34UNUSEDreview carefully — unique
QUOTA.org.ShipmentAudit.PK_ForecastHeader1CLUSTEREDYY0000never2026-09-13 04:00:34UNUSEDKEEP — primary key
QUOTA.org.ShipmentAudit.UX_BatchArchive2NONCLUSTEREDY0000never2026-09-13 04:00:34UNUSEDreview carefully — unique
QUOTA.org.BookingResult.PK_BillingQueue1CLUSTEREDYY0000never2026-09-13 04:00:35UNUSEDKEEP — primary key
QUOTA.org.InvoiceQueue.PK_TicketEntry1CLUSTEREDYY0000never2026-09-13 04:00:35UNUSEDKEEP — primary key
QUOTA.org.PricingStatus.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-13 04:00:35UNUSEDKEEP — primary key
QUOTA.org.CatalogAudit.PK_AssetStatus1CLUSTEREDYY0000never2026-09-13 04:00:35UNUSEDKEEP — primary key
QUOTA.org.OrdersSummary.PK_StaffingAudit1CLUSTEREDYY0000never2026-09-13 04:00:35UNUSEDKEEP — primary key
QUOTA.org.ContractResult.PK_PolicyLine1CLUSTEREDYY0000never2026-09-13 04:00:35UNUSEDKEEP — 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-13 04:00:35UNUSEDKEEP — primary key
QUOTA.org.AssetSummary.UX_ShipmentSummary4NONCLUSTEREDY0000never2026-09-13 04:00:35UNUSEDreview carefully — unique
QUOTA.org.ShipmentQueue.PK_InvoiceStaging1CLUSTEREDYY0000never2026-09-13 04:00:35UNUSEDKEEP — primary key
QUOTA.org.PolicyEntry.PK_SettlementSnapshot1CLUSTEREDYY0000never2026-09-13 04:00:35UNUSEDKEEP — primary key
QUOTA.org.PolicyEntry.UX_ShiftSnapshot9NONCLUSTEREDYY0000never2026-09-13 04:00:35UNUSEDreview carefully — unique
QUOTA.org.MeterAudit.PK_BillingDetail1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.BillingHeader.PK_ContractStaging1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.TicketSnapshot.PK_ForecastSnapshot1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.CustomerStaging.PK_CustomerHeader1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.KPI.PK_ShiftLine1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.KPI.UX_ShiftHeader8NONCLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDreview carefully — unique
QUOTA.org.StaffingArchive.PK_SettlementResult1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.CustomerEntry.PK_RouteSummary1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.PricingDaily.PK_CampaignArchive1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.PricingDaily.UX_BillingArchive2NONCLUSTEREDY0000never2026-09-13 04:00:36UNUSEDreview carefully — unique
QUOTA.org.TicketLine.PK_SupplierMonthly1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.BillingArchive.PK_MeterSummary1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.MeterEntry.PK_SupplierLog1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.ShiftResult.PK_AssetAudit1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.BatchMonthly.PK_SalesLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.RosterMonthly.IX_AssetDetail2NONCLUSTERED0000never2026-09-13 04:00:36UNUSEDreview, then DROP
QUOTA.org.RosterMonthly.PK_ForecastDaily1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.InvoiceStaging.IX_AssetAudit2NONCLUSTERED0000never2026-09-13 04:00:36UNUSEDreview, then DROP
QUOTA.org.InvoiceStaging.PK_CustomerMonthly1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.StaffingAudit.PK_AssetLog1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.Level.PK_ShiftStaging1CLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDKEEP — primary key
QUOTA.org.Level.UX_SettlementHistory2NONCLUSTEREDYY0000never2026-09-13 04:00:36UNUSEDreview carefully — unique
QUOTA.org.ContractHistory.PK_RouteArchive1CLUSTEREDYY0000never2026-09-13 04:00:37UNUSEDKEEP — primary key
QUOTA.org.QuotaEntry.IX_AssetHistory2NONCLUSTERED0000never2026-09-13 04:00:37UNUSEDreview, then DROP
QUOTA.org.QuotaEntry.PK_LedgerQueue1CLUSTEREDYY0000never2026-09-13 04:00:37UNUSEDKEEP — primary key
QUOTA.org.ClaimQueue.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-13 04:00:37UNUSEDKEEP — primary key
QUOTA.org.Position.PK_PolicySummary1CLUSTEREDYY0000never2026-09-13 04:00:37UNUSEDKEEP — primary key
QUOTA.org.Position.UX_MeterArchive2NONCLUSTEREDYY0000never2026-09-13 04:00:37UNUSEDreview carefully — unique
QUOTA.org.CampaignQueue.PK_BillingArchive1CLUSTEREDYY0000never2026-09-13 04:00:37UNUSEDKEEP — primary key
QUOTA.org.CampaignQueue.UX_TicketDaily2NONCLUSTEREDY0000never2026-09-13 04:00:37UNUSEDreview carefully — unique
QUOTA.org.MeterResult.PK_CatalogStaging1CLUSTEREDYY0000never2026-09-13 04:00:37UNUSEDKEEP — primary key
QUOTA.org.LedgerDaily.PK_ContractHeader1CLUSTEREDYY0000never2026-09-13 04:00:37UNUSEDKEEP — 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-13 04:00:37UNUSEDKEEP — primary key
QUOTA.org.ReconcileLine.PK_CustomerLog1CLUSTEREDYY0000never2026-09-13 04:00:38UNUSEDKEEP — primary key
QUOTA.org.SupplierResult.PK_ForecastQueue1CLUSTEREDYY0000never2026-09-13 04:00:38UNUSEDKEEP — primary key
QUOTA.org.RouteSummary.PK_RosterAudit1CLUSTEREDYY0000never2026-09-13 04:00:38UNUSEDKEEP — primary key
QUOTA.org.RouteSummary.UX_SupplierSummary2NONCLUSTEREDYY0000never2026-09-13 04:00:38COLDreview carefully — unique
QUOTA.org.ClaimDetail.PK_RouteMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.ShiftResult.PK_ForecastEntry1CLUSTEREDYY0000never2026-09-13 04:00:38UNUSEDKEEP — primary key
QUOTA.org.ShiftResult.UX_LedgerStaging7NONCLUSTEREDY0000never2026-09-13 04:00:38UNUSEDreview carefully — unique
QUOTA.org.QuotaResult.PK_CampaignDaily1CLUSTEREDYY0000never2026-09-13 04:00:38UNUSEDKEEP — primary key
QUOTA.org.QuotaResult.UX_BatchDaily2NONCLUSTEREDY0000never2026-09-13 04:00:38UNUSEDreview carefully — unique
QUOTA.org.SettlementAudit.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-13 04:00:38UNUSEDKEEP — primary key
QUOTA.rec.SettlementQueue.PK_BookingArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.rec.SettlementQueue.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-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.SettlementQueue.PK_StaffingSnapshot1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.SettlementQueue.UX_BillingResult2NONCLUSTEREDY0000never2026-09-13 04:00:39UNUSEDreview carefully — unique
QUOTA.sal.MeterHistory.PK_LedgerSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.ShipmentAudit.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.RouteResult.PK_OrdersAudit1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.RouteResult.UX_ContractEntry2NONCLUSTEREDY0000never2026-09-13 04:00:39UNUSEDreview carefully — unique
QUOTA.sal.OrdersHeader.PK_PayrollResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.WarehouseDaily.PK_SettlementDetail1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.WarehouseDaily.UX_BookingAudit2NONCLUSTEREDY0000never2026-09-13 04:00:39UNUSEDreview carefully — unique
QUOTA.sal.InvoiceLog.PK_MeterAudit1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.PolicySnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.SettlementStatus.PK_ReconcileResult1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.SettlementStatus.UX_StaffingMonthly2NONCLUSTEREDY0000never2026-09-13 04:00:39UNUSEDreview carefully — unique
QUOTA.sal.ReconcileHistory.PK_PayrollHeader1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.ReconcileHistory.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-13 04:00:39UNUSEDreview carefully — unique
QUOTA.sal.InvoiceEntry.PK_RouteQueue1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.BillingQueue.PK_ReconcileHistory1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.RosterDetail.PK_BookingStaging1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.RosterQueue.PK_ShiftQueue1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — primary key
QUOTA.sal.RosterQueue.UX_RosterArchive2NONCLUSTEREDY0000never2026-09-13 04:00:39UNUSEDreview carefully — unique
QUOTA.sal.WarehouseHeader.PK_RouteEntry1CLUSTEREDYY0000never2026-09-13 04:00:39UNUSEDKEEP — 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-13 04:00:41UNUSEDKEEP — primary key
ASSET.cfg.QuotaStatus.UX_MeterSummary2NONCLUSTEREDY0000never2026-09-13 04:00:41UNUSEDreview carefully — unique
ASSET.dbo.ContractResult.PK_CampaignResult1CLUSTEREDYY0280282026-09-15 02:15:032026-09-13 04:00:41USEDKEEP — primary key
ASSET.dbo.SettlementStaging.PK_TicketStaging1CLUSTEREDYY00028never2026-09-15 03:09:27UNUSEDKEEP — primary key
ASSET.dbo.Jobs.PK_RosterStatus1CLUSTEREDYY308251371002026-09-16 01:00:032026-09-13 04:00:41USEDKEEP — primary key
ASSET.dbo.Jobs.UQ_ContractMonthly2NONCLUSTEREDY0000never2026-09-13 04:00:41UNUSEDreview carefully — unique
ASSET.dbo.MeterResult.PK_BookingDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.OrdersSnapshot.IX_SalesQueue2NONCLUSTERED06860102752026-09-16 01:00:032026-09-15 03:09:27USEDkeep — in use
ASSET.dbo.OrdersSnapshot.PK_PolicyLine1CLUSTEREDYY6370520561205502026-09-16 01:00:032026-09-15 03:09:27USEDKEEP — primary key
ASSET.dbo.SalesLine.IX_ReconcileResult2NONCLUSTERED685128706852026-09-16 01:00:032026-09-15 03:09:27USEDkeep — in use
ASSET.dbo.SalesLine.PK_MeterStatus1CLUSTEREDYY076806852026-09-16 01:00:032026-09-15 03:09:27USEDKEEP — primary key
ASSET.dbo.InvoiceSummary.PK_LedgerResult1CLUSTEREDYY6858905020552026-09-16 01:00:032026-09-15 03:09:27USEDKEEP — primary key
ASSET.dbo.CustomerSummary.PK_TicketStaging1CLUSTEREDYY2603027400267152026-09-16 01:00:032026-09-15 03:09:27USEDKEEP — primary key
ASSET.dbo.QuotaResult.PK_TerritoryStatus1CLUSTEREDYY260300002026-09-16 01:00:022026-09-13 04:00:42USEDKEEP — primary key
ASSET.dbo.LedgerResult.PK_ForecastMonthly1CLUSTEREDYY0205506852026-09-16 01:00:032026-09-15 03:09:27USEDKEEP — primary key
ASSET.dbo.BatchResult.IX_SettlementStaging2NONCLUSTERED00029never2026-09-15 03:09:27UNUSEDreview, then DROP
ASSET.dbo.BatchResult.IX_ReconcileEntry3NONCLUSTERED00029never2026-09-15 03:09:27UNUSEDreview, then DROP
ASSET.dbo.BatchResult.PK_ContractEntry1CLUSTEREDYY00029never2026-09-15 03:09:27UNUSEDKEEP — primary key
ASSET.dbo.PricingLog.PK_RouteLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.ClaimArchive.PK_StaffingStaging1CLUSTEREDYY9590685002026-09-16 01:00:032026-09-13 04:00:42USEDKEEP — primary key
ASSET.dbo.ClaimArchive.UQ_SupplierResult2NONCLUSTEREDY0000never2026-09-13 04:00:42UNUSEDreview carefully — unique
ASSET.dbo.CustomerArchive.IX_BillingHeader3NONCLUSTERED00029never2026-09-13 04:00:42UNUSEDreview, then DROP
ASSET.dbo.CustomerArchive.PK_AssetSummary1CLUSTEREDYY8782200292026-09-16 01:00:012026-09-13 04:00:42USEDKEEP — primary key
ASSET.dbo.CustomerArchive.UQ_OrdersMonthly2NONCLUSTEREDY0000never2026-09-13 04:00:42UNUSEDreview carefully — unique
ASSET.dbo.Status.PK_ShiftLine1CLUSTEREDYY479502055002026-09-16 01:00:032026-09-13 04:00:42USEDKEEP — primary key
ASSET.dbo.Status.UQ_PricingHeader2NONCLUSTEREDY0000never2026-09-13 04:00:42UNUSEDreview carefully — unique
ASSET.dbo.CatalogLine.PK_PricingQueue1CLUSTEREDYY00058never2026-09-15 03:09:27UNUSEDKEEP — primary key
ASSET.dbo.SupplierDetail.PK_ShiftResult1CLUSTEREDYY0000never2026-09-13 04:00:42UNUSEDKEEP — primary key
ASSET.dbo.CampaignResult.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-13 04:00:42UNUSEDKEEP — primary key
ASSET.dbo.TicketQueue.PK_CampaignEntry1CLUSTEREDYY0000never2026-09-13 04:00:42UNUSEDKEEP — primary key
ASSET.dbo.WarehouseEntry.PK_ShiftStatus1CLUSTEREDYY8044198002026-09-15 21:00:002026-09-13 04:00:42USEDKEEP — primary key
ASSET.dbo.WarehouseEntry.UX_CampaignHeader2NONCLUSTEREDY0000never2026-09-13 04:00:42UNUSEDreview carefully — unique
ASSET.dbo.TicketSummary.PK_SalesLine1CLUSTERED01233002026-09-15 16:13:112026-09-13 04:00:43USEDKEEP — table storage
ASSET.dbo.TerritoryEntry.PK_SalesSummary1CLUSTEREDYY3086109002026-09-15 16:13:112026-09-13 04:00:43USEDKEEP — primary key
ASSET.dbo.TerritoryEntry.UX_TerritoryQueue2NONCLUSTEREDY0000never2026-09-13 04:00:43UNUSEDreview carefully — unique
ASSET.dbo.PolicyEntry.PK_TicketEntry1CLUSTEREDYY1651229002026-09-15 16:13:112026-09-13 04:00:43USEDKEEP — primary key
ASSET.dbo.PolicyEntry.UX_PolicyAudit2NONCLUSTEREDY0000never2026-09-13 04:00:43UNUSEDreview carefully — unique
ASSET.dbo.CampaignHeader.PK_InvoiceSnapshot1CLUSTEREDYY3688233002026-09-15 21:00:002026-09-13 04:00:43USEDKEEP — primary key
ASSET.dbo.CampaignHeader.UX_BillingLog2NONCLUSTEREDY0000never2026-09-13 04:00:43UNUSEDreview carefully — unique
ASSET.dbo.WarehouseHeader.PK_OrdersQueue1CLUSTEREDYY0131002026-09-15 15:53:202026-09-13 04:00:43USEDKEEP — primary key
ASSET.dbo.WarehouseHeader.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-13 04:00:43UNUSEDreview carefully — unique
ASSET.dbo.RouteQueue.PK_SupplierAudit1CLUSTEREDYY3160109002026-09-15 16:13:112026-09-13 04:00:43USEDKEEP — primary key
ASSET.dbo.RouteQueue.UX_CampaignQueue2NONCLUSTEREDY0000never2026-09-13 04:00:43UNUSEDreview carefully — unique
ASSET.dbo.CampaignAudit.PK_BatchSnapshot1CLUSTEREDYY1594229002026-09-15 16:13:112026-09-13 04:00:43USEDKEEP — primary key
ASSET.dbo.CampaignAudit.UX_SupplierArchive2NONCLUSTEREDY0000never2026-09-13 04:00:43UNUSEDreview carefully — unique
ASSET.dbo.ShiftHistory.IX_SupplierLog2NONCLUSTEREDY0000never2026-09-13 04:00:43UNUSEDreview carefully — unique
ASSET.dbo.ShiftDaily.PK_ReconcileStatus1CLUSTEREDYY318585002026-09-15 16:13:112026-09-13 04:00:43USEDKEEP — primary key
ASSET.dbo.ShiftDaily.UX_RouteDaily2NONCLUSTEREDY0000never2026-09-13 04:00:43UNUSEDreview carefully — unique
ASSET.emp.WarehouseMonthly.PK_PricingHistory1CLUSTEREDYY96158917122026-09-15 16:13:112026-09-13 04:00:43USEDKEEP — primary key
ASSET.emp.WarehouseMonthly.UX_CustomerDetail2NONCLUSTEREDYY1700122026-09-12 15:32:362026-09-13 04:00:43USEDkeep — in use
ASSET.emp.SettlementLine.PK_LedgerAudit1CLUSTEREDYY00012never2026-09-13 04:00:44UNUSEDKEEP — primary key
ASSET.emp.SalesDetail.PK_BillingLog1CLUSTEREDYY0342002026-09-15 23:27:022026-09-13 04:00:44USEDKEEP — primary key
ASSET.emp.BatchMonthly.PK_TicketAudit1CLUSTEREDYY0000never2026-09-13 04:00:44UNUSEDKEEP — primary key
ASSET.emp.RosterLog.PK_QuotaLog1CLUSTEREDYY520002602026-09-15 10:53:292026-09-13 04:00:44USEDKEEP — primary key
ASSET.emp.QuotaMonthly.IX_ShipmentEntry19NONCLUSTERED3309001172026-09-15 21:00:002026-09-13 04:00:44USEDkeep — in use
ASSET.emp.QuotaMonthly.PK_ReconcileDetail1CLUSTEREDYY791333091172026-09-15 21:00:002026-09-13 04:00:44USEDKEEP — primary key
ASSET.emp.OrdersEntry.PK_PolicyHeader1CLUSTEREDYY000115never2026-09-13 04:00:45UNUSEDKEEP — primary key
ASSET.emp.PayrollSummary.PK_RouteSummary1CLUSTEREDYY0342002026-09-15 23:27:022026-09-13 04:00:45USEDKEEP — primary key
ASSET.emp.SettlementAudit.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-13 04:00:45UNUSEDKEEP — primary key
ASSET.emp.InvoiceLog.PK_BatchEntry1CLUSTEREDYY02002026-09-08 08:22:112026-09-13 04:00:45USEDKEEP — 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_CustomerMonthly1CLUSTEREDYY126104002026-09-15 16:11:582026-09-13 04:00:45USEDKEEP — primary key
ASSET.emp.RouteHistory.UX_CustomerQueue2NONCLUSTEREDY0000never2026-09-13 04:00:45UNUSEDreview carefully — unique
ASSET.emp.CustomerHistory.PK_ShiftDaily1CLUSTEREDYY440002026-09-15 15:53:092026-09-13 04:00:45USEDKEEP — primary key
ASSET.emp.ForecastEntry.PK_SettlementLog1CLUSTEREDYY0435002026-09-14 11:27:032026-09-13 04:00:46USEDKEEP — primary key
ASSET.emp.ClaimQueue.PK_TerritoryResult1CLUSTEREDYY0000never2026-09-13 04:00:46UNUSEDKEEP — primary key
ASSET.emp.PolicyAudit.PK_ContractAudit1CLUSTEREDYY01517002026-09-15 10:47:152026-09-13 04:00:46USEDKEEP — primary key
ASSET.emp.ShipmentSummary.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-13 04:00:46UNUSEDKEEP — primary key
ASSET.emp.BatchArchive.PK_ClaimHistory1CLUSTEREDYY150611002026-09-15 10:47:152026-09-13 04:00:46USEDKEEP — primary key
ASSET.emp.RosterSnapshot.PK_PolicyStaging1CLUSTEREDYY0000never2026-09-13 04:00:46UNUSEDKEEP — primary key
ASSET.emp.MeterResult.IX_LedgerQueue9NONCLUSTERED020680602026-09-15 16:13:322026-09-13 04:00:46USEDkeep — in use
ASSET.emp.MeterResult.PK_CustomerResult1CLUSTEREDYY3161413170602026-09-15 23:59:002026-09-13 04:00:46USEDKEEP — primary key
ASSET.emp.PayrollHeader.PK_TicketHistory1CLUSTEREDYY164500602026-09-15 16:13:112026-09-13 04:00:47USEDKEEP — primary key
ASSET.emp.OrdersAudit.PK_ShipmentHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.RosterResult.PK_MeterAudit1CLUSTEREDYY0403002026-09-16 00:00:002026-09-13 04:00:47USEDKEEP — primary key
ASSET.emp.RouteHeader.PK_StaffingQueue1CLUSTEREDYY0000never2026-09-13 04:00:47UNUSEDKEEP — primary key
ASSET.emp.MeterAudit.PK_ClaimLog1CLUSTEREDYY919350282026-09-15 16:13:112026-09-13 04:00:48USEDKEEP — primary key
ASSET.emp.QuotaStatus.PK_OrdersArchive1CLUSTEREDYY0003never2026-09-13 04:00:48UNUSEDKEEP — primary key
ASSET.emp.ShiftLine.IX_PricingAudit13NONCLUSTERED740002026-09-15 16:11:582026-09-13 04:00:48USEDkeep — in use
ASSET.emp.ShiftLine.PK_SettlementStatus1CLUSTEREDYY443997402026-09-15 23:27:022026-09-13 04:00:48USEDKEEP — primary key
ASSET.emp.ShiftLine.UX_BookingDaily2NONCLUSTEREDY0000never2026-09-13 04:00:48UNUSEDreview carefully — unique
ASSET.emp.CampaignHeader.PK_BillingQueue1CLUSTEREDYY012002026-09-12 14:08:582026-09-13 04:00:48USEDKEEP — primary key
ASSET.emp.MeterStatus.PK_BillingStaging1CLUSTEREDYY0000never2026-09-13 04:00:48UNUSEDKEEP — primary key
ASSET.emp.WarehouseStaging.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-13 04:00:48UNUSEDKEEP — primary key
ASSET.emp.ForecastHeader.IX_WarehouseResult3NONCLUSTERED13260002026-09-15 16:13:112026-09-13 04:00:49USEDkeep — in use
ASSET.emp.ForecastHeader.PK_OrdersAudit1CLUSTEREDYY024132602026-09-15 16:13:112026-09-13 04:00:48USEDKEEP — primary key
ASSET.emp.SalesLog.PK_AssetStaging1CLUSTEREDYY0000never2026-09-13 04:00:49UNUSEDKEEP — primary key
ASSET.emp.AssetDaily.PK_CustomerMonthly1CLUSTEREDYY02525002026-09-15 16:13:112026-09-13 04:00:49USEDKEEP — primary key
ASSET.emp.StaffingDaily.PK_BookingLog1CLUSTEREDYY073002026-09-15 14:54:492026-09-13 04:00:49USEDKEEP — primary key
ASSET.emp.ClaimResult.PK_TerritoryQueue1CLUSTEREDYY0000never2026-09-13 04:00:49UNUSEDKEEP — primary key
ASSET.emp.CatalogLog.PK_ReconcileHeader1CLUSTEREDYY0000never2026-09-13 04:00:49UNUSEDKEEP — primary key
ASSET.emp.ShipmentSnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-13 04:00:49UNUSEDKEEP — primary key
ASSET.emp.PricingDaily.IX_ShiftAudit2NONCLUSTERED13270002026-09-15 16:13:112026-09-13 04:00:49USEDkeep — in use
ASSET.emp.PricingDaily.PK_RouteEntry1CLUSTEREDYY013132702026-09-15 16:13:112026-09-13 04:00:49USEDKEEP — primary key
ASSET.emp.PolicyLog.PK_LedgerHistory1CLUSTEREDYY41121631602026-09-15 16:13:112026-09-13 04:00:49USEDKEEP — primary key
ASSET.emp.PolicyLog.UX_OrdersSnapshot5NONCLUSTEREDY163300602026-09-15 16:13:112026-09-13 04:00:50USEDkeep — in use
ASSET.emp.RouteAudit.PK_ClaimResult1CLUSTEREDYY0003never2026-09-13 04:00:50UNUSEDKEEP — primary key
ASSET.emp.PayrollDaily.IX_BillingStaging2NONCLUSTERED1000242026-09-15 15:53:092026-09-13 04:00:50USEDkeep — in use
ASSET.emp.PayrollDaily.PK_OrdersSnapshot1CLUSTEREDYY005242026-09-15 15:53:092026-09-13 04:00:50USEDKEEP — primary key
ASSET.emp.MeterHistory.IX_ContractArchive19NONCLUSTERED283410301412026-09-16 01:00:222026-09-13 04:00:50USEDkeep — in use
ASSET.emp.MeterHistory.PK_BatchLog1CLUSTEREDYY949514693141451862026-09-16 01:01:082026-09-13 04:00:50USEDKEEP — primary key
ASSET.emp.MeterHistory.UX_BatchLog2NONCLUSTEREDYY000158never2026-09-13 04:00:50UNUSEDreview carefully — unique
ASSET.emp.MeterHistory.UX_ForecastHeader23NONCLUSTEREDY56945601412026-09-15 21:00:002026-09-13 04:00:50USEDkeep — in use
ASSET.emp.MeterHistory.UX_CustomerSnapshot3NONCLUSTEREDYY0701582026-09-07 11:03:592026-09-13 04:00:50USEDkeep — in use
ASSET.emp.MeterHistory.UX_QuotaStaging4NONCLUSTEREDY120014301412026-09-15 21:00:002026-09-13 04:00:51USEDkeep — in use
ASSET.emp.TerritoryLine.PK_LedgerArchive1CLUSTEREDYY163794610146452026-09-16 00:05:142026-09-13 04:00:51USEDKEEP — primary key
ASSET.emp.SalesStaging.PK_PolicyDaily1CLUSTEREDYY26686170332026-09-16 00:05:472026-09-13 04:00:52USEDKEEP — primary key
ASSET.emp.TerritoryDaily.PK_MeterLog1CLUSTEREDYY0003never2026-09-13 04:00:52UNUSEDKEEP — primary key
ASSET.emp.SettlementQueue.IX_PolicyAudit2NONCLUSTERED800114012026-08-21 08:13:382026-09-13 04:00:52USEDkeep — in use
ASSET.emp.SettlementQueue.PK_SalesEntry1CLUSTEREDYY1718114012026-09-15 16:11:592026-09-13 04:00:52USEDKEEP — primary key
ASSET.emp.StaffingMonthly.IX_ReconcileEntry8NONCLUSTERED00092never2026-09-13 04:00:53UNUSEDreview, then DROP
ASSET.emp.StaffingMonthly.IX_SalesQueue9NONCLUSTERED293300922026-09-15 16:13:112026-09-13 04:00:53USEDkeep — in use
ASSET.emp.StaffingMonthly.PK_CampaignStatus1CLUSTEREDYY3932951325922026-09-15 16:13:112026-09-13 04:00:53USEDKEEP — primary key
ASSET.emp.TicketQueue.PK_BatchDaily1CLUSTEREDYY0013281182026-09-15 16:13:112026-09-13 04:00:53USEDKEEP — primary key
ASSET.emp.TicketQueue.UX_PayrollDaily2NONCLUSTEREDY1328001182026-09-15 16:13:112026-09-13 04:00:53USEDkeep — in use
ASSET.emp.MeterStatus.PK_CustomerDetail1CLUSTEREDYY000118never2026-09-13 04:00:53UNUSEDKEEP — primary key
ASSET.emp.OrdersEntry.PK_TerritoryAudit1CLUSTEREDYY02041002026-09-15 23:27:022026-09-13 04:00:53USEDKEEP — primary key
ASSET.emp.InvoiceLog.PK_BillingDetail1CLUSTEREDYY000138never2026-09-13 04:00:53UNUSEDKEEP — primary key
ASSET.emp.CampaignHistory.IX_QuotaDetail2NONCLUSTERED294031052026-09-15 16:25:432026-09-13 04:00:54USEDkeep — in use
ASSET.emp.CampaignHistory.PK_AssetHeader1CLUSTEREDYY28952940352026-09-16 01:00:322026-09-13 04:00:54USEDKEEP — primary key
ASSET.emp.ContractArchive.PK_BookingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.TicketLine.PK_CampaignEntry1CLUSTEREDYY6019002026-09-15 16:11:592026-09-13 04:00:54USEDKEEP — primary key
ASSET.emp.BatchAudit.IX_ShiftSnapshot23NONCLUSTERED10070130322262026-09-15 23:59:002026-09-15 03:09:37USEDkeep — in use
ASSET.emp.BatchAudit.PK_ForecastSummary1CLUSTEREDYY1612414393071483302026-09-15 16:24:062026-09-15 03:09:36USEDKEEP — primary key
ASSET.emp.BatchAudit.UX_LedgerStaging10NONCLUSTEREDY10472050322262026-09-16 00:05:372026-09-15 03:09:39USEDkeep — in use
ASSET.emp.ClaimAudit.PK_LedgerDaily1CLUSTEREDYY0001neverneverUNUSEDKEEP — primary key
ASSET.emp.ClaimAudit.UX_RouteMonthly12NONCLUSTEREDY01012026-09-09 01:06:10neverUSEDkeep — in use
ASSET.emp.PolicyHistory.PK_OrdersDaily1CLUSTEREDYY277148340438482026-09-16 00:05:372026-09-15 03:13:15USEDKEEP — primary key
ASSET.emp.ForecastQueue.IX_BookingLine12NONCLUSTERED0000never2026-09-13 04:00:59UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_InvoiceMonthly15NONCLUSTERED0000never2026-09-13 04:01:00UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_RouteStatus13NONCLUSTERED0000never2026-09-13 04:01:00UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_ForecastMonthly14NONCLUSTERED0000never2026-09-13 04:01:00UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.PK_CustomerHistory1CLUSTEREDYY0000never2026-09-13 04:00:59UNUSEDKEEP — primary key
ASSET.emp.ForecastQueue.IX_ForecastMonthly2NONCLUSTEREDY0000never2026-09-13 04:01:00UNUSEDreview carefully — unique
ASSET.emp.ShipmentArchive.PK_ReconcileStaging1CLUSTEREDYY0000never2026-09-13 04:01:01UNUSEDKEEP — primary key
ASSET.emp.BillingEntry.PK_StaffingAudit1CLUSTEREDYY043752277402026-09-16 00:05:392026-09-15 03:13:27USEDKEEP — primary key
ASSET.emp.BillingEntry.UX_StaffingLog2NONCLUSTEREDY11625640277402026-09-15 16:11:592026-09-15 03:20:35USEDkeep — in use
ASSET.emp.BillingAudit.IX_PolicyHeader9NONCLUSTERED030277402026-09-15 16:11:582026-09-15 03:20:35USEDkeep — in use
ASSET.emp.BillingAudit.PK_PolicyDetail1CLUSTEREDYY03010277402026-09-15 16:11:582026-09-15 03:20:35USEDKEEP — primary key
ASSET.emp.BillingAudit.UX_SupplierSnapshot2NONCLUSTEREDY115401050277402026-09-15 16:07:542026-09-15 03:20:35USEDkeep — in use
ASSET.emp.ShipmentStaging.PK_TerritoryStatus1CLUSTEREDYY0240116342026-09-15 16:11:582026-09-13 04:01:02USEDKEEP — primary key
ASSET.emp.ShipmentStaging.UX_RosterDaily2NONCLUSTEREDY115321020116342026-09-15 16:07:542026-09-13 04:01:02USEDkeep — in use
ASSET.emp.SalesLine.PK_CampaignResult1CLUSTEREDYY33778350438432026-09-15 16:24:062026-09-15 03:20:48USEDKEEP — primary key
ASSET.emp.LedgerSnapshot.PK_CampaignStatus1CLUSTEREDYY00061never2026-09-13 04:01:06UNUSEDKEEP — primary key
ASSET.emp.ReconcileDetail.PK_CampaignQueue1CLUSTEREDYY513600272026-09-15 16:13:112026-09-13 04:01:06USEDKEEP — primary key
ASSET.emp.PolicyStaging.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.ReconcileStaging.PK_ContractStaging1CLUSTEREDYY498168002026-09-15 15:53:202026-09-13 04:01:07USEDKEEP — primary key
ASSET.emp.ReconcileStaging.UX_OrdersHistory2NONCLUSTEREDY0000never2026-09-13 04:01:07UNUSEDreview carefully — unique
ASSET.emp.MeterStatus.PK_ReconcileMonthly1CLUSTEREDYY27244573442026-09-15 21:00:002026-09-13 04:01:07USEDKEEP — primary key
ASSET.emp.MeterStatus.UX_ReconcileAudit5NONCLUSTEREDY457500282026-09-15 21:00:002026-09-13 04:01:07USEDkeep — in use
ASSET.emp.PricingAudit.PK_ReconcileSnapshot1CLUSTEREDYY0005never2026-09-13 04:01:07UNUSEDKEEP — primary key
ASSET.emp.OrdersMonthly.IX_QuotaArchive5NONCLUSTEREDY000379never2026-09-13 04:01:07UNUSEDreview, then DROP
ASSET.emp.OrdersMonthly.IX_PayrollResult4NONCLUSTEREDY030102026-09-08 11:11:102026-09-13 04:01:07USEDkeep — in use
ASSET.emp.OrdersMonthly.IX_TicketSnapshot2NONCLUSTERED174932405812026-09-16 00:20:022026-09-13 04:01:07USEDkeep — in use
ASSET.emp.OrdersMonthly.IX_SettlementLine3NONCLUSTERED17405812026-09-08 11:23:392026-09-13 04:01:07USEDkeep — in use
ASSET.emp.OrdersMonthly.PK_ShipmentSnapshot1CLUSTEREDYY4266595832026-09-11 10:30:032026-09-13 04:01:07USEDKEEP — primary key
ASSET.emp.MeterAudit.PK_BatchDaily1CLUSTEREDYY0000never2026-09-13 04:01:07UNUSEDKEEP — primary key
ASSET.emp.ContractMonthly.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-13 04:01:08UNUSEDKEEP — primary key
ASSET.emp.RosterQueue.PK_SettlementHistory1CLUSTEREDYY707901002026-09-15 16:12:172026-09-13 04:01:08USEDKEEP — primary key
ASSET.emp.TicketAudit.IX_LedgerLog2NONCLUSTERED00010never2026-09-13 04:01:08UNUSEDreview, then DROP
ASSET.emp.TicketAudit.PK_LedgerStatus1CLUSTEREDYY00010never2026-09-13 04:01:08UNUSEDKEEP — primary key
ASSET.emp.InvoiceResult.PK_ShipmentMonthly1CLUSTEREDYY00010never2026-09-13 04:01:08UNUSEDKEEP — primary key
ASSET.emp.CustomerLog.IX_PayrollResult20NONCLUSTERED5726078301452026-09-15 16:07:542026-09-15 03:20:52USEDkeep — in use
ASSET.emp.CustomerLog.PK_StaffingDaily1CLUSTEREDYY36701324211431552026-09-16 01:00:382026-09-15 03:20:52USEDKEEP — primary key
ASSET.emp.InvoiceAudit.IX_SettlementResult10NONCLUSTERED10924560372026-09-15 10:47:152026-09-15 03:20:52USEDkeep — in use
ASSET.emp.InvoiceAudit.PK_QuotaEntry1CLUSTEREDYY054427372026-09-15 08:01:592026-09-15 03:20:52USEDKEEP — primary key
ASSET.emp.MeterSummary.PK_AssetEntry1CLUSTEREDYY00035never2026-09-15 03:20:52UNUSEDKEEP — primary key
ASSET.emp.AssetSummary.PK_SupplierStaging1CLUSTEREDYY0340772026-09-15 02:15:032026-09-15 03:20:52USEDKEEP — primary key
ASSET.emp.SupplierStaging.IX_StaffingSnapshot24NONCLUSTERED19820151202202026-09-16 01:00:372026-09-15 03:20:53USEDkeep — in use
ASSET.emp.SupplierStaging.IX_MeterStaging17NONCLUSTERED1536001832026-08-24 13:30:162026-09-15 03:20:53USEDkeep — in use
ASSET.emp.SupplierStaging.IX_StaffingEntry23NONCLUSTERED000206never2026-09-15 03:20:53UNUSEDreview, then DROP
ASSET.emp.SupplierStaging.PK_PayrollMonthly1CLUSTEREDYY7067239617852392026-09-15 16:24:062026-09-15 03:20:53USEDKEEP — primary key
ASSET.emp.CustomerStatus.IX_ReconcileLine10NONCLUSTERED11649930902026-09-15 10:47:152026-09-15 03:20:53USEDkeep — in use
ASSET.emp.CustomerStatus.PK_PolicyHistory1CLUSTEREDYY068952902026-09-15 02:15:032026-09-15 03:20:53USEDKEEP — primary key
ASSET.emp.BillingAudit.PK_CustomerEntry1CLUSTEREDYY00076never2026-09-15 03:20:53UNUSEDKEEP — primary key
ASSET.emp.PolicyLine.PK_OrdersSummary1CLUSTEREDYY0169012026-09-12 14:07:072026-09-13 04:01:10USEDKEEP — primary key
ASSET.emp.RouteStaging.PK_WarehouseLine1CLUSTEREDYY015002026-09-12 09:00:552026-09-13 04:01:10USEDKEEP — primary key
ASSET.emp.CampaignMonthly.PK_OrdersArchive1CLUSTEREDYY91830102026-09-12 14:07:072026-09-13 04:01:10USEDKEEP — primary key
ASSET.emp.CatalogSnapshot.PK_ClaimHistory1CLUSTEREDYY01002026-08-19 15:27:542026-09-13 04:01:10USEDKEEP — primary key
ASSET.emp.BillingDaily.PK_CustomerLine1CLUSTEREDYY030851502026-09-12 14:18:282026-09-13 04:01:10USEDKEEP — primary key
ASSET.emp.BillingDaily.UX_LedgerDaily2NONCLUSTEREDY154001502026-09-12 14:18:282026-09-13 04:01:10USEDkeep — in use
ASSET.emp.BillingHistory.PK_TerritorySummary1CLUSTEREDYY0000never2026-09-13 04:01:10UNUSEDKEEP — primary key
ASSET.emp.SupplierHistory.PK_WarehouseMonthly1CLUSTEREDYY03202062026-09-15 02:15:032026-09-15 03:20:54USEDKEEP — primary key
ASSET.emp.ShipmentMonthly.IX_SupplierEntry12NONCLUSTERED10990010402026-09-15 10:47:152026-09-15 03:20:54USEDkeep — in use
ASSET.emp.ShipmentMonthly.IX_InvoiceStaging5NONCLUSTERED13900010402026-09-15 21:00:002026-09-15 03:20:54USEDkeep — in use
ASSET.emp.ShipmentMonthly.PK_BatchDaily1CLUSTEREDYY470117910872026-09-15 21:00:002026-09-15 03:20:54USEDKEEP — primary key
ASSET.emp.AssetDetail.PK_ReconcileResult1CLUSTEREDYY000845never2026-09-15 03:20:54UNUSEDKEEP — primary key
ASSET.emp.AssetSnapshot.IX_ForecastStatus7NONCLUSTERED145814480972026-09-16 01:00:372026-09-15 03:20:54USEDkeep — in use
ASSET.emp.AssetSnapshot.IX_SalesDaily5NONCLUSTERED511100972026-09-15 11:02:352026-09-15 03:20:54USEDkeep — in use
ASSET.emp.AssetSnapshot.PK_OrdersDetail1CLUSTEREDYY2501972026-09-09 09:11:002026-09-15 03:20:54USEDKEEP — primary key
ASSET.emp.PricingStatus.PK_PolicyStatus1CLUSTEREDYY040922026-09-12 10:04:312026-09-15 03:20:54USEDKEEP — primary key
ASSET.emp.TicketSnapshot.PK_CampaignQueue1CLUSTEREDYY24448253701872026-09-16 01:00:372026-09-15 03:20:55USEDKEEP — primary key
ASSET.emp.ForecastMonthly.PK_CampaignSummary1CLUSTEREDYY02801822026-09-15 02:15:032026-09-15 03:20:55USEDKEEP — primary key
ASSET.emp.PricingStatus.IX_QuotaLog8NONCLUSTERED166001182026-09-15 07:30:002026-09-15 03:20:55USEDkeep — in use
ASSET.emp.PricingStatus.IX_ClaimEntry6NONCLUSTERED15819415601182026-09-16 01:00:372026-09-15 03:20:55USEDkeep — in use
ASSET.emp.PricingStatus.PK_LedgerResult1CLUSTEREDYY50903171661182026-09-15 16:24:062026-09-15 03:20:55USEDKEEP — primary key
ASSET.emp.PayrollHistory.PK_LedgerQueue1CLUSTEREDYY000113never2026-09-15 03:20:55UNUSEDKEEP — primary key
ASSET.emp.QuotaSummary.IX_StaffingQueue10NONCLUSTERED10844280292026-09-15 10:47:152026-09-13 04:01:12USEDkeep — in use
ASSET.emp.QuotaSummary.PK_LedgerEntry1CLUSTEREDYY040401292026-09-15 10:20:542026-09-13 04:01:12USEDKEEP — primary key
ASSET.emp.PricingQueue.PK_PricingStaging1CLUSTEREDYY00029never2026-09-13 04:01:12UNUSEDKEEP — primary key
ASSET.emp.BookingMonthly.IX_ShipmentAudit5NONCLUSTERED7274394150912026-09-16 01:00:322026-09-13 04:01:12USEDkeep — in use
ASSET.emp.BookingMonthly.PK_WarehouseLog1CLUSTEREDYY00091never2026-09-13 04:01:12UNUSEDKEEP — primary key
ASSET.emp.MeterSnapshot.PK_StaffingSummary1CLUSTEREDYY040912026-09-12 10:04:312026-09-13 04:01:12USEDKEEP — primary key
ASSET.emp.BatchMonthly.PK_InvoiceDetail1CLUSTEREDYY240132276201332026-09-16 01:00:322026-09-13 04:01:12USEDKEEP — primary key
ASSET.emp.StaffingAudit.PK_ForecastHeader1CLUSTEREDYY03201422026-09-15 02:15:032026-09-13 04:01:13USEDKEEP — primary key
ASSET.emp.BatchLog.PK_SalesDetail1CLUSTEREDYY364500702732026-09-16 01:00:322026-09-13 04:01:13USEDKEEP — primary key
ASSET.emp.RouteHistory.PK_MeterEntry1CLUSTEREDYY000273never2026-09-13 04:01:13UNUSEDKEEP — primary key
ASSET.emp.CampaignResult.IX_ClaimStatus14NONCLUSTERED16801229011462026-09-15 23:59:002026-09-13 04:01:13USEDkeep — in use
ASSET.emp.CampaignResult.IX_ForecastAudit8NONCLUSTERED02022682026-09-10 10:29:462026-09-13 04:01:13USEDkeep — in use
ASSET.emp.CampaignResult.IX_CustomerQueue13NONCLUSTERED178020022912026-09-15 16:07:542026-09-13 04:01:13USEDkeep — in use
ASSET.emp.CampaignResult.PK_StaffingArchive1CLUSTEREDYY1899113503141523192026-09-16 01:00:382026-09-13 04:01:13USEDKEEP — primary key
ASSET.emp.SalesHeader.IX_BookingSummary2NONCLUSTERED000700never2026-09-13 04:01:18UNUSEDreview, then DROP
ASSET.emp.SalesHeader.PK_CatalogQueue1CLUSTEREDYY000700never2026-09-13 04:01:18UNUSEDKEEP — primary key
ASSET.emp.PayrollHistory.PK_CampaignStaging1CLUSTEREDYY2578342092026-09-15 23:27:022026-09-13 04:01:14USEDKEEP — primary key
ASSET.emp.TerritoryDaily.PK_RouteArchive1CLUSTEREDYY0009never2026-09-13 04:01:14UNUSEDKEEP — primary key
ASSET.emp.CatalogSummary.IX_PricingSnapshot25NONCLUSTERED201725101442026-09-16 00:20:022026-09-13 04:01:15USEDkeep — in use
ASSET.emp.CatalogSummary.IX_WarehouseSnapshot21NONCLUSTERED1348165701432026-09-16 01:00:222026-09-13 04:01:15USEDkeep — in use
ASSET.emp.CatalogSummary.IX_ReconcileSummary23NONCLUSTERED5933201432026-09-16 00:05:152026-09-13 04:01:15USEDkeep — in use
ASSET.emp.CatalogSummary.IX_AssetEntry26NONCLUSTERED5773001442026-09-15 10:47:162026-09-13 04:01:15USEDkeep — in use
ASSET.emp.CatalogSummary.PK_ShipmentStaging1CLUSTEREDYY521601048123841622026-09-16 01:00:222026-09-13 04:01:15USEDKEEP — primary key
ASSET.emp.CatalogSummary.UX_OrdersAudit14NONCLUSTEREDY4673401432026-09-16 00:20:022026-09-13 04:01:15USEDkeep — in use
ASSET.emp.CatalogSummary.UX_LedgerHistory15NONCLUSTEREDYY4571001472026-09-15 23:59:002026-09-13 04:01:15USEDkeep — in use
ASSET.emp.TicketMonthly.PK_LedgerAudit1CLUSTEREDYY2173590372026-09-15 16:30:532026-09-13 04:01:16USEDKEEP — primary key
ASSET.emp.BillingQueue.IX_AssetDetail11NONCLUSTERED47302762026-09-15 01:05:392026-09-13 04:01:16USEDkeep — in use
ASSET.emp.BillingQueue.IX_ContractSummary8NONCLUSTERED25156202762026-09-16 00:20:022026-09-13 04:01:16USEDkeep — in use
ASSET.emp.BillingQueue.PK_ShipmentEntry1CLUSTEREDYY02940251212762026-09-16 01:00:222026-09-13 04:01:16USEDKEEP — primary key
ASSET.emp.CampaignResult.IX_SupplierLine14NONCLUSTERED280001592026-09-15 15:54:452026-09-13 04:01:17USEDkeep — in use
ASSET.emp.CampaignResult.PK_CustomerLine1CLUSTEREDYY01062801592026-09-15 15:54:452026-09-13 04:01:17USEDKEEP — primary key
ASSET.org.SettlementSnapshot.PK_org.SettlementSnapshot1CLUSTEREDYY078002026-09-08 15:53:522026-09-13 04:01:18USEDKEEP — primary key
ASSET.org.SettlementSnapshot.UX_BillingLine3NONCLUSTEREDY0000never2026-09-13 04:01:18UNUSEDreview carefully — unique
ASSET.org.PolicySummary.IX_AssetEntry11NONCLUSTERED25782034002026-09-15 16:24:062026-09-13 04:01:18USEDkeep — in use
ASSET.org.PolicySummary.PK_QuotaAudit1CLUSTEREDYY258294735272102026-09-15 23:59:002026-09-13 04:01:18USEDKEEP — primary key
ASSET.org.PolicySummary.UX_ForecastHistory4NONCLUSTEREDYY1430002026-09-15 14:58:372026-09-13 04:01:18USEDkeep — in use
ASSET.org.BatchMonthly.PK_WarehouseSummary1CLUSTEREDYY047002026-09-12 10:24:392026-09-13 04:01:18USEDKEEP — primary key
ASSET.org.BatchMonthly.UX_SalesSnapshot2NONCLUSTEREDYY0000never2026-09-13 04:01:18UNUSEDreview carefully — unique
ASSET.org.CampaignQueue.PK_RosterDaily1CLUSTEREDYY0000never2026-09-13 04:01:18UNUSEDKEEP — primary key
ASSET.org.TicketLog.PK_WarehouseDetail1CLUSTEREDYY561738542026-09-15 15:54:422026-09-13 04:01:19USEDKEEP — primary key
ASSET.org.TicketLog.UX_SalesMonthly4NONCLUSTEREDY3800542026-09-15 15:53:092026-09-13 04:01:19USEDkeep — in use
ASSET.org.BatchDaily.PK_QuotaStaging1CLUSTEREDYY2505147598002026-09-16 01:01:002026-09-13 04:01:19USEDKEEP — primary key
ASSET.org.BatchDaily.UX_PricingResult7NONCLUSTEREDYY0000never2026-09-13 04:01:19UNUSEDreview carefully — unique
ASSET.org.ShipmentAudit.PK_ForecastHeader1CLUSTEREDYY13314471644356132026-09-16 01:01:002026-09-13 04:01:19USEDKEEP — primary key
ASSET.org.ShipmentAudit.UX_BatchArchive2NONCLUSTEREDY164278316770132026-09-16 01:01:002026-09-13 04:01:19USEDkeep — in use
ASSET.org.WarehouseStaging.PK_MeterHistory1CLUSTEREDYY00013never2026-09-13 04:01:19UNUSEDKEEP — primary key
ASSET.org.BookingResult.PK_BillingQueue1CLUSTEREDYY0000never2026-09-13 04:01:19UNUSEDKEEP — primary key
ASSET.org.InvoiceQueue.PK_TicketEntry1CLUSTEREDYY5898002026-09-14 14:56:052026-09-13 04:01:19USEDKEEP — primary key
ASSET.org.PricingStatus.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-13 04:01:19UNUSEDKEEP — primary key
ASSET.org.CatalogHeader.PK_ShiftStatus1CLUSTEREDYY21402120992026-09-16 01:00:212026-09-15 03:20:56USEDKEEP — primary key
ASSET.org.PolicySummary.PK_CatalogQueue1CLUSTEREDYY010842026-09-12 15:49:012026-09-15 03:20:56USEDKEEP — primary key
ASSET.org.CatalogAudit.PK_AssetStatus1CLUSTEREDYY0000never2026-09-13 04:01:20UNUSEDKEEP — primary key
ASSET.org.OrdersSummary.PK_StaffingAudit1CLUSTEREDYY2104401062026-09-15 16:12:172026-09-13 04:01:20USEDKEEP — primary key
ASSET.org.ContractResult.PK_PolicyLine1CLUSTEREDYY000106never2026-09-13 04:01:20UNUSEDKEEP — primary key
ASSET.org.SupplierHistory.IX_ShipmentSummary2NONCLUSTERED0000never2026-09-13 04:01:20UNUSEDreview, then DROP
ASSET.org.SupplierHistory.PK_CustomerDetail1CLUSTEREDYY0126002026-09-14 09:25:442026-09-13 04:01:20USEDKEEP — primary key
ASSET.org.ContractStaging.PK_CatalogDetail1CLUSTEREDYY0000never2026-09-13 04:01:20UNUSEDKEEP — primary key
ASSET.org.BatchSummary.PK_SettlementHistory1CLUSTEREDYY0000never2026-09-13 04:01:20UNUSEDKEEP — primary key
ASSET.org.BillingHeader.IX_ShiftHistory2NONCLUSTERED0000never2026-09-13 04:01:20UNUSEDreview, then DROP
ASSET.org.BillingHeader.PK_InvoiceMonthly1CLUSTEREDYY044002026-09-14 09:25:442026-09-13 04:01:20USEDKEEP — primary key
ASSET.org.ShipmentSummary.IX_StaffingResult2NONCLUSTERED0000never2026-09-13 04:01:20UNUSEDreview, then DROP
ASSET.org.ShipmentSummary.PK_ClaimDetail1CLUSTEREDYY044002026-09-14 09:25:442026-09-13 04:01:20USEDKEEP — primary key
ASSET.org.SalesStatus.IX_ClaimHeader2NONCLUSTEREDY440002026-09-14 09:25:442026-09-13 04:01:20USEDkeep — in use
ASSET.org.SalesStatus.PK_CampaignSnapshot1CLUSTEREDYY004402026-09-14 09:25:442026-09-13 04:01:20USEDKEEP — primary key
ASSET.org.PolicyResult.PK_ForecastStaging1CLUSTEREDYY147589540042026-09-16 01:00:252026-09-13 04:01:20USEDKEEP — primary key
ASSET.org.AssetSummary.PK_TicketStaging1CLUSTEREDYY7752091102026-09-15 16:22:312026-09-13 04:01:20USEDKEEP — primary key
ASSET.org.AssetSummary.UX_ShipmentSummary4NONCLUSTEREDY10002026-09-12 15:32:472026-09-13 04:01:20USEDkeep — in use
ASSET.org.ShipmentQueue.PK_InvoiceStaging1CLUSTEREDYY410251533052026-09-16 01:00:212026-09-13 04:01:20USEDKEEP — primary key
ASSET.org.PolicyEntry.PK_SettlementSnapshot1CLUSTEREDYY1708250252026-09-16 00:20:022026-09-13 04:01:20USEDKEEP — primary key
ASSET.org.PolicyEntry.UX_ShiftSnapshot5NONCLUSTEREDYY00023never2026-09-13 04:01:20UNUSEDreview carefully — unique
ASSET.org.MeterAudit.IX_WarehouseQueue3NONCLUSTERED1560002026-09-16 00:20:022026-09-13 04:01:20USEDkeep — in use
ASSET.org.MeterAudit.PK_BillingDetail1CLUSTEREDYY511350232026-09-09 07:19:362026-09-13 04:01:20USEDKEEP — primary key
ASSET.org.BillingHeader.PK_ContractStaging1CLUSTEREDYY0000never2026-09-13 04:01:20UNUSEDKEEP — primary key
ASSET.org.TicketSnapshot.PK_ForecastSnapshot1CLUSTEREDYY0000never2026-09-13 04:01:21UNUSEDKEEP — primary key
ASSET.org.CustomerStaging.PK_CustomerHeader1CLUSTEREDYY010232026-09-03 09:42:462026-09-13 04:01:21USEDKEEP — primary key
ASSET.org.KPI.PK_ShiftLine1CLUSTEREDYY0000never2026-09-13 04:01:21UNUSEDKEEP — primary key
ASSET.org.KPI.UX_ShiftHeader4NONCLUSTEREDYY0000never2026-09-13 04:01:21UNUSEDreview carefully — unique
ASSET.org.StaffingArchive.PK_SettlementResult1CLUSTEREDYY078002026-09-08 15:53:522026-09-13 04:01:21USEDKEEP — primary key
ASSET.org.CustomerEntry.PK_RouteSummary1CLUSTEREDYY0000never2026-09-13 04:01:21UNUSEDKEEP — primary key
ASSET.org.PricingDaily.PK_CampaignArchive1CLUSTEREDYY0000never2026-09-13 04:01:21UNUSEDKEEP — primary key
ASSET.org.PricingDaily.UX_BillingArchive5NONCLUSTEREDY0000never2026-09-13 04:01:21UNUSEDreview carefully — unique
ASSET.org.TicketLine.PK_SupplierMonthly1CLUSTEREDYY0000never2026-09-13 04:01:21UNUSEDKEEP — primary key
ASSET.org.BillingArchive.PK_MeterSummary1CLUSTEREDYY0000never2026-09-13 04:01:21UNUSEDKEEP — primary key
ASSET.org.MeterEntry.PK_SupplierLog1CLUSTEREDYY0000never2026-09-13 04:01:21UNUSEDKEEP — primary key
ASSET.org.ReconcileAudit.PK_PolicyLog1CLUSTEREDYY131780012026-09-15 15:20:122026-09-13 04:01:21USEDKEEP — primary key
ASSET.org.ReconcileAudit.UQ_ShipmentResult2NONCLUSTEREDYY70012026-08-29 10:20:352026-09-13 04:01:21USEDkeep — in use
ASSET.org.StaffingAudit.PK_RosterArchive1CLUSTEREDYY0007never2026-09-13 04:01:21UNUSEDKEEP — primary key
ASSET.org.ShiftResult.PK_AssetAudit1CLUSTEREDYY7696632721072026-09-16 01:00:562026-09-13 04:01:21USEDKEEP — primary key
ASSET.org.BatchMonthly.PK_SalesLine1CLUSTEREDYY12147550242026-09-12 13:18:292026-09-13 04:01:22USEDKEEP — primary key
ASSET.org.RosterMonthly.IX_AssetDetail2NONCLUSTERED00010never2026-09-13 04:01:22UNUSEDreview, then DROP
ASSET.org.RosterMonthly.PK_ForecastDaily1CLUSTEREDYY5146470102026-09-12 00:05:062026-09-13 04:01:22USEDKEEP — primary key
ASSET.org.InvoiceStaging.IX_AssetAudit2NONCLUSTERED00010never2026-09-13 04:01:22UNUSEDreview, then DROP
ASSET.org.InvoiceStaging.PK_CustomerMonthly1CLUSTEREDYY00010never2026-09-13 04:01:22UNUSEDKEEP — primary key
ASSET.org.StaffingAudit.PK_AssetLog1CLUSTEREDYY0007never2026-09-13 04:01:22UNUSEDKEEP — primary key
ASSET.org.Level.PK_ShiftStaging1CLUSTEREDYY1292418002026-09-15 14:54:492026-09-13 04:01:22USEDKEEP — primary key
ASSET.org.Level.UX_SettlementHistory2NONCLUSTEREDYY1628002026-09-05 10:32:592026-09-13 04:01:22USEDkeep — in use
ASSET.org.ContractHistory.PK_RouteArchive1CLUSTEREDYY0000never2026-09-13 04:01:22UNUSEDKEEP — primary key
ASSET.org.QuotaEntry.IX_AssetHistory2NONCLUSTERED110392026-08-28 12:33:312026-09-13 04:01:22USEDkeep — in use
ASSET.org.QuotaEntry.PK_LedgerQueue1CLUSTEREDYY20121782392026-09-15 16:07:542026-09-13 04:01:22USEDKEEP — primary key
ASSET.org.ClaimQueue.PK_LedgerHistory1CLUSTEREDYY00019never2026-09-13 04:01:22UNUSEDKEEP — primary key
ASSET.org.SupplierLine.PK_CatalogStaging1CLUSTEREDYY24084002026-09-14 11:27:182026-09-13 04:01:22USEDKEEP — primary key
ASSET.org.InvoiceHistory.PK_BillingLog1CLUSTEREDYY0000never2026-09-13 04:01:22UNUSEDKEEP — primary key
ASSET.org.AssetHeader.IX_PayrollAudit2NONCLUSTERED24080002026-09-14 11:27:182026-09-13 04:01:23USEDkeep — in use
ASSET.org.AssetHeader.PK_LedgerResult1CLUSTEREDYY510002026-09-04 09:48:262026-09-13 04:01:22USEDKEEP — primary key
ASSET.org.TerritoryStatus.PK_PayrollLine1CLUSTEREDYY0000never2026-09-13 04:01:23UNUSEDKEEP — primary key
ASSET.org.RosterLine.PK_LedgerStaging1CLUSTEREDYY0000never2026-09-13 04:01:23UNUSEDKEEP — primary key
ASSET.org.ForecastArchive.PK_PricingHistory1CLUSTEREDYY07002026-09-10 08:04:522026-09-13 04:01:23USEDKEEP — primary key
ASSET.org.PolicySummary.PK_ForecastQueue1CLUSTEREDYY0602002026-09-14 11:27:182026-09-13 04:01:23USEDKEEP — primary key
ASSET.org.ClaimMonthly.PK_BookingDetail1CLUSTEREDYY0000never2026-09-13 04:01:23UNUSEDKEEP — primary key
ASSET.org.OrdersEntry.PK_MeterDaily1CLUSTEREDYY61007092026-09-15 11:02:292026-09-13 04:01:23USEDKEEP — primary key
ASSET.org.LedgerStaging.PK_BatchLine1CLUSTEREDYY0009never2026-09-15 03:20:57UNUSEDKEEP — primary key
ASSET.org.Position.PK_PolicySummary1CLUSTEREDYY1697125230252026-09-16 00:20:022026-09-13 04:01:23USEDKEEP — primary key
ASSET.org.Position.UX_MeterArchive5NONCLUSTEREDYY00025never2026-09-13 04:01:23UNUSEDreview carefully — unique
ASSET.org.CampaignQueue.PK_BillingArchive1CLUSTEREDYY71240218122026-09-15 16:12:172026-09-13 04:01:23USEDKEEP — primary key
ASSET.org.CampaignQueue.UX_TicketDaily2NONCLUSTEREDY2532106022026-09-15 15:54:422026-09-13 04:01:23USEDkeep — in use
ASSET.org.MeterResult.PK_CatalogStaging1CLUSTEREDYY0008never2026-09-13 04:01:23UNUSEDKEEP — primary key
ASSET.org.QuotaLine.PK_AssetAudit1CLUSTEREDYY532240552026-09-08 15:54:082026-09-13 04:01:23USEDKEEP — primary key
ASSET.org.QuotaLine.UX_PricingAudit2NONCLUSTEREDYY00055never2026-09-13 04:01:23UNUSEDreview carefully — unique
ASSET.org.PayrollLog.PK_PayrollAudit1CLUSTEREDYY0878412026-09-08 13:05:512026-09-13 04:01:24USEDKEEP — primary key
ASSET.org.PayrollLog.UX_PayrollDetail2NONCLUSTEREDY840012026-09-08 13:05:512026-09-13 04:01:24USEDkeep — in use
ASSET.org.LedgerDaily.PK_ContractHeader1CLUSTEREDYY00025never2026-09-13 04:01:24UNUSEDKEEP — primary key
ASSET.org.PricingArchive.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-13 04:01:24UNUSEDKEEP — primary key
ASSET.org.PricingArchive.UX_InvoiceAudit4NONCLUSTEREDY0000never2026-09-13 04:01:24UNUSEDreview carefully — unique
ASSET.org.ForecastAudit.PK_WarehouseSnapshot1CLUSTEREDYY0121002026-09-15 15:53:202026-09-13 04:01:24USEDKEEP — primary key
ASSET.org.ForecastAudit.UX_ClaimArchive2NONCLUSTEREDY0000never2026-09-13 04:01:24UNUSEDreview carefully — unique
ASSET.org.PayrollLine.PK_OrdersHistory1CLUSTEREDYY57184002026-09-15 16:11:592026-09-13 04:01:24USEDKEEP — primary key
ASSET.org.PayrollLine.UX_ShiftLog2NONCLUSTEREDY0336002026-09-12 10:04:282026-09-13 04:01:24USEDkeep — in use
ASSET.org.BookingStaging.PK_AssetResult1CLUSTEREDYY47201102500342026-09-16 01:00:322026-09-13 04:01:24USEDKEEP — primary key
ASSET.org.ReconcileLine.PK_CustomerLog1CLUSTEREDYY020132026-08-27 14:13:582026-09-15 03:20:57USEDKEEP — primary key
ASSET.org.ShiftStaging.PK_BillingHistory1CLUSTEREDYY021002026-09-14 15:01:372026-09-13 04:01:24USEDKEEP — primary key
ASSET.org.ShiftStaging.UQ_PolicyAudit2NONCLUSTEREDY0000never2026-09-13 04:01:24UNUSEDreview carefully — unique
ASSET.org.CustomerLine.IX_ForecastLine3NONCLUSTERED210002026-09-14 15:01:372026-09-13 04:01:24USEDkeep — in use
ASSET.org.CustomerLine.PK_LedgerEntry1CLUSTEREDYY02424002026-09-15 15:56:552026-09-13 04:01:24USEDKEEP — primary key
ASSET.org.CustomerLine.UQ_PayrollLog2NONCLUSTEREDY0000never2026-09-13 04:01:24UNUSEDreview carefully — unique
ASSET.org.InvoiceMonthly.PK_WarehouseQueue1CLUSTEREDYY0000never2026-09-13 04:01:24UNUSEDKEEP — primary key
ASSET.org.InvoiceMonthly.UQ_MeterAudit2NONCLUSTEREDY021002026-09-14 15:01:372026-09-13 04:01:24USEDkeep — in use
ASSET.org.QuotaStaging.PK_ShiftStaging1CLUSTEREDYY12417942026-09-15 15:56:552026-09-13 04:01:24USEDKEEP — primary key
ASSET.org.QuotaStaging.UQ_ShiftMonthly2NONCLUSTEREDY790042026-09-15 15:56:552026-09-15 03:20:57USEDkeep — in use
ASSET.org.BatchMonthly.PK_WarehouseHeader1CLUSTEREDYY1379242711302492026-09-15 15:56:552026-09-13 04:01:25USEDKEEP — primary key
ASSET.org.BatchMonthly.UQ_LedgerStaging2NONCLUSTEREDY1130002492026-09-12 09:48:032026-09-13 04:01:25USEDkeep — in use
ASSET.org.ClaimHeader.PK_ClaimArchive1CLUSTEREDYY0001582never2026-09-15 03:20:57UNUSEDKEEP — primary key
ASSET.org.SupplierResult.PK_ForecastQueue1CLUSTEREDYY287765002026-09-15 16:24:062026-09-13 04:01:25USEDKEEP — primary key
ASSET.org.RouteSummary.PK_RosterAudit1CLUSTEREDYY0000never2026-09-13 04:01:25UNUSEDKEEP — primary key
ASSET.org.RouteSummary.UX_SupplierSummary2NONCLUSTEREDYY0000never2026-09-13 04:01:25UNUSEDreview carefully — unique
ASSET.org.ClaimDetail.PK_RouteMonthly1CLUSTEREDYY0000never2026-09-13 04:01:25UNUSEDKEEP — primary key
ASSET.org.ShiftResult.PK_ForecastEntry1CLUSTEREDYY1701334203233232026-09-16 01:00:222026-09-13 04:01:25USEDKEEP — primary key
ASSET.org.ShiftResult.UX_LedgerStaging7NONCLUSTEREDY20347003232026-09-16 01:00:222026-09-13 04:01:25USEDkeep — in use
ASSET.org.QuotaResult.PK_CampaignDaily1CLUSTEREDYY20001765312026-09-16 01:00:222026-09-13 04:01:25USEDKEEP — primary key
ASSET.org.QuotaResult.UX_BatchDaily5NONCLUSTEREDY30012026-09-04 11:21:352026-09-13 04:01:25USEDkeep — in use
ASSET.org.QuotaDetail.PK_WarehouseMonthly1CLUSTEREDYY8616500172026-09-16 01:00:322026-09-13 04:01:25USEDKEEP — primary key
ASSET.org.BookingLog.PK_MeterStaging1CLUSTEREDYY00017never2026-09-13 04:01:25UNUSEDKEEP — primary key
ASSET.org.SettlementAudit.PK_InvoiceSnapshot1CLUSTEREDYY0003never2026-09-13 04:01:25UNUSEDKEEP — primary key
ASSET.oth.QuotaSummary.PK_QuotaDetail1CLUSTEREDYY05002026-09-12 10:32:452026-09-13 04:01:26USEDKEEP — primary key
ASSET.oth.InvoiceStatus.PK_ShiftQueue1CLUSTEREDYY762002026-09-16 00:00:002026-09-13 04:01:26USEDKEEP — primary key
ASSET.oth.SupplierLine.PK_QuotaDetail1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.oth.SupplierLine.UX_InvoiceHeader2NONCLUSTEREDY0000never2026-09-13 04:01:26UNUSEDreview carefully — unique
ASSET.oth.StaffingArchive.IX_InvoiceStaging2NONCLUSTERED0000never2026-09-13 04:01:26UNUSEDreview, then DROP
ASSET.oth.StaffingArchive.PK_PricingAudit1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.oth.StaffingArchive.UQ_SalesAudit3NONCLUSTEREDY16012002026-09-12 10:32:452026-09-13 04:01:26USEDkeep — in use
ASSET.oth.CustomerQueue.IX_WarehouseResult2NONCLUSTERED1605002026-09-12 10:32:452026-09-13 04:01:26USEDkeep — in use
ASSET.oth.CustomerQueue.PK_TerritoryResult1CLUSTEREDYY0320002026-09-08 08:23:562026-09-13 04:01:26USEDKEEP — primary key
ASSET.rec.SettlementQueue.PK_BookingArchive1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.rec.SettlementQueue.UX_CatalogLine2NONCLUSTEREDY0000never2026-09-13 04:01:26UNUSEDreview carefully — unique
ASSET.rec.AssetEntry.PK_BatchArchive1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.rec.ShipmentDetail.PK_QuotaResult1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.rec.ShipmentDetail.UX_SalesLog2NONCLUSTEREDY0000never2026-09-13 04:01:26UNUSEDreview carefully — unique
ASSET.rec.CustomerLine.PK_ShiftStaging1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.rec.SettlementAudit.PK_PricingHeader1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.rec.PricingResult.PK_AssetHistory1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — 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-13 04:01:26UNUSEDKEEP — primary key
ASSET.rec.MeterArchive.PK_ForecastResult1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.rec.MeterArchive.UX_PayrollLine2NONCLUSTEREDY0000never2026-09-13 04:01:26UNUSEDreview carefully — unique
ASSET.rec.PayrollStatus.PK_ForecastMonthly1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.rec.CampaignStatus.PK_InvoiceHistory1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.rec.ReconcileStatus.PK_BatchDaily1CLUSTEREDYY0000never2026-09-13 04:01:26UNUSEDKEEP — primary key
ASSET.rec.ShipmentMonthly.PK_ContractEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.rec.ForecastSummary.PK_ReconcileLog1CLUSTEREDYY0000never2026-09-13 04:01:27UNUSEDKEEP — primary key
ASSET.rec.CustomerDetail.PK_SalesSnapshot1CLUSTEREDYY0000never2026-09-13 04:01:27UNUSEDKEEP — primary key
ASSET.rec.AssetSnapshot.PK_PolicyResult1CLUSTEREDYY014002026-09-08 08:52:332026-09-13 04:01:27USEDKEEP — primary key
ASSET.rec.AssetSnapshot.UX_ContractArchive2NONCLUSTEREDY0000never2026-09-13 04:01:27UNUSEDreview carefully — unique
ASSET.rec.CustomerQueue.PK_InvoiceLog1CLUSTEREDYY02002026-09-08 08:22:122026-09-13 04:01:27USEDKEEP — primary key
ASSET.rec.BatchSnapshot.PK_TicketLine1CLUSTEREDYY0000never2026-09-13 04:01:27UNUSEDKEEP — primary key
ASSET.rec.StaffingLine.PK_RosterSnapshot1CLUSTEREDYY0000never2026-09-13 04:01:27UNUSEDKEEP — primary key
ASSET.rec.LedgerStatus.PK_InvoiceDetail1CLUSTEREDYY0000never2026-09-13 04:01:27UNUSEDKEEP — primary key
ASSET.sal.SalesHistory.PK_QuotaLine1CLUSTEREDYY014002026-09-14 09:25:422026-09-13 04:01:27USEDKEEP — primary key
ASSET.sal.ClaimArchive.IX_RouteDetail2NONCLUSTERED0000never2026-09-13 04:01:27UNUSEDreview, then DROP
ASSET.sal.ClaimArchive.PK_LedgerHeader1CLUSTEREDYY0000never2026-09-13 04:01:27UNUSEDKEEP — primary key
ASSET.sal.QuotaLine.PK_ContractArchive1CLUSTEREDYY8141161052026-09-16 01:01:002026-09-13 04:01:27USEDKEEP — primary key
ASSET.sal.SalesStatus.PK_ShiftMonthly1CLUSTEREDYY9995730622026-09-15 23:27:022026-09-13 04:01:27USEDKEEP — primary key
ASSET.sal.SettlementQueue.PK_StaffingSnapshot1CLUSTEREDYY01221080992026-09-15 23:27:032026-09-13 04:01:27USEDKEEP — primary key
ASSET.sal.MeterHistory.PK_LedgerSnapshot1CLUSTEREDYY048075472026-09-15 16:12:172026-09-13 04:01:28USEDKEEP — primary key
ASSET.sal.ShipmentAudit.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.sal.RouteResult.PK_OrdersAudit1CLUSTEREDYY099002026-09-15 16:13:322026-09-13 04:01:28USEDKEEP — primary key
ASSET.sal.RouteResult.UX_ContractEntry2NONCLUSTEREDY0000never2026-09-13 04:01:28UNUSEDreview carefully — unique
ASSET.sal.WarehouseDaily.PK_SettlementDetail1CLUSTEREDYY72744533172026-09-15 16:22:312026-09-13 04:01:28USEDKEEP — primary key
ASSET.sal.WarehouseDaily.UX_BookingAudit2NONCLUSTEREDY3300172026-09-15 15:54:032026-09-13 04:01:28USEDkeep — in use
ASSET.sal.InvoiceLog.PK_MeterAudit1CLUSTEREDYY1289401282026-09-15 16:13:322026-09-13 04:01:28USEDKEEP — primary key
ASSET.sal.PolicySnapshot.PK_ReconcileQueue1CLUSTEREDYY0801282026-09-12 10:04:242026-09-13 04:01:28USEDKEEP — primary key
ASSET.sal.SettlementStatus.PK_ReconcileResult1CLUSTEREDYY12561717412602026-09-15 16:13:322026-09-13 04:01:29USEDKEEP — primary key
ASSET.sal.SettlementStatus.UX_StaffingMonthly2NONCLUSTEREDY740012602026-09-15 15:54:032026-09-13 04:01:29USEDkeep — in use
ASSET.sal.ReconcileHistory.PK_PayrollHeader1CLUSTEREDYY1129602242026-09-15 16:13:322026-09-13 04:01:29USEDKEEP — primary key
ASSET.sal.ReconcileHistory.UX_TicketQueue2NONCLUSTEREDY000224never2026-09-13 04:01:29UNUSEDreview carefully — unique
ASSET.sal.InvoiceEntry.PK_RouteQueue1CLUSTEREDYY000224never2026-09-13 04:01:29UNUSEDKEEP — primary key
ASSET.sal.BillingQueue.PK_ReconcileHistory1CLUSTEREDYY04012602026-09-12 10:04:242026-09-13 04:01:29USEDKEEP — primary key
ASSET.sal.RosterDetail.PK_BookingStaging1CLUSTEREDYY020172026-09-12 10:04:242026-09-13 04:01:29USEDKEEP — primary key
ASSET.sal.RosterQueue.PK_ShiftQueue1CLUSTEREDYY076002026-09-15 16:11:262026-09-13 04:01:29USEDKEEP — primary key
ASSET.sal.RosterQueue.UX_RosterArchive2NONCLUSTEREDY0000never2026-09-13 04:01:29UNUSEDreview carefully — unique
ASSET.sal.WarehouseHeader.PK_RouteEntry1CLUSTEREDYY0160002026-09-16 00:05:152026-09-13 04:01:29USEDKEEP — primary key
ASSET.sal.SupplierArchive.PK_SupplierStaging1CLUSTEREDYY0342002026-09-15 23:27:052026-09-13 04:01:29USEDKEEP — primary key
ASSET.sal.RosterQueue.PK_PolicyLog1CLUSTEREDYY0000never2026-09-13 04:01:29UNUSEDKEEP — primary key
ASSET.sal.CustomerSnapshot.PK_RosterEntry1CLUSTEREDYY0342002026-09-15 23:27:052026-09-13 04:01:30USEDKEEP — primary key
ASSET.sal.LedgerStatus.PK_WarehouseStaging1CLUSTEREDYY01002026-09-12 09:53:312026-09-13 04:01:30USEDKEEP — primary key
ASSET.sal.BookingLine.PK_PricingAudit1CLUSTEREDYY0000never2026-09-13 04:01:30UNUSEDKEEP — primary key
ASSET.sal.PricingLine.PK_BatchLine1CLUSTEREDYY0000never2026-09-13 04:01:30UNUSEDKEEP — primary key
ASSET.sal.WarehouseStaging.PK_SettlementHistory1CLUSTEREDYY0000never2026-09-13 04:01:30UNUSEDKEEP — primary key
ASSET.sal.StaffingArchive.PK_CatalogLine1CLUSTEREDYY0000never2026-09-13 04:01:30UNUSEDKEEP — primary key
ASSET.sal.WarehouseSummary.PK_RosterArchive1CLUSTEREDYY0000never2026-09-13 04:01:30UNUSEDKEEP — primary key
ASSET.schedule.CustomerDetail.PK_CatalogStaging1CLUSTEREDYY05011575102026-09-16 01:00:222026-09-13 04:01:30USEDKEEP — primary key
ASSET.schedule.CustomerDetail.UQ_BillingSnapshot2NONCLUSTEREDY15281440002026-09-16 01:00:222026-09-13 04:01:30USEDkeep — in use
ASSET.schedule.CustomerDetail.UQ_CampaignResult3NONCLUSTEREDY17914371002026-09-16 01:00:222026-09-13 04:01:30USEDkeep — in use
ASSET.schedule.InvoiceHistory.IX_StaffingHeader3NONCLUSTERED01002026-08-22 08:13:532026-09-13 04:01:30USEDkeep — in use
ASSET.schedule.InvoiceHistory.PK_ContractLog1CLUSTEREDYY02002026-08-22 14:42:052026-09-13 04:01:30USEDKEEP — primary key
ASSET.schedule.InvoiceHistory.UQ_LedgerResult2NONCLUSTEREDY0000never2026-09-13 04:01:30UNUSEDreview carefully — unique
ASSET.schedule.MeterStaging.PK_SettlementMonthly1CLUSTEREDYY313661016732026-09-16 01:00:212026-09-13 04:01:32USEDKEEP — primary key
ASSET.schedule.SettlementLine.PK_CampaignStatus1CLUSTEREDYY3208748304722026-09-16 01:00:222026-09-13 04:01:32USEDKEEP — primary key
ASSET.schedule.TicketEntry.PK_CampaignDaily1CLUSTEREDYY171004722026-09-16 01:00:212026-09-13 04:01:32USEDKEEP — primary key
ASSET.schedule.QuotaSummary.PK_LedgerStatus1CLUSTEREDYY5505523840772026-09-16 01:00:222026-09-13 04:01:33USEDKEEP — primary key
ASSET.schedule.ShipmentLog.PK_SalesEntry1CLUSTEREDYY2108331033532026-09-16 01:00:252026-09-15 03:20:58USEDKEEP — primary key
ASSET.schedule.PricingResult.PK_CampaignDaily1CLUSTEREDYY15519115102362026-09-16 01:00:222026-09-13 04:01:33USEDKEEP — primary key
ASSET.schedule.SupplierSnapshot.IX_BillingHeader12NONCLUSTERED671524350764312026-09-16 01:00:322026-09-15 03:21:00USEDkeep — in use
ASSET.schedule.SupplierSnapshot.PK_AssetStatus1CLUSTEREDYY112988117150687942782026-09-16 01:00:322026-09-15 03:20:59USEDKEEP — primary key
ASSET.schedule.SupplierSnapshot.IX_ContractLog2NONCLUSTEREDY3100318522026-09-15 16:15:122026-09-15 03:21:00USEDkeep — in use
ASSET.schedule.BatchDetail.PK_AssetDetail1CLUSTEREDYY2320151013702026-09-01 01:02:172026-09-13 04:01:36USEDKEEP — primary key
ASSET.schedule.RosterSummary.IX_BatchDetail3NONCLUSTERED152927850601022026-09-16 01:00:182026-09-15 08:26:17USEDkeep — in use
ASSET.schedule.RosterSummary.IX_ClaimHeader2NONCLUSTERED3084347170601022026-09-16 01:00:462026-09-15 08:26:17USEDkeep — in use
ASSET.schedule.RosterSummary.PK_CustomerAudit1CLUSTEREDYY1013822256256221197862026-09-16 01:01:082026-09-15 08:26:17USEDKEEP — primary key
ASSET.schedule.BillingDetail.IX_TicketHeader2NONCLUSTERED487537173102407582026-09-16 01:00:582026-09-16 01:00:38USEDkeep — in use
ASSET.schedule.BillingDetail.PK_BillingLog1CLUSTEREDYY1446351233800602853832026-09-16 01:01:082026-09-16 01:00:38USEDKEEP — primary key
ASSET.schedule.PolicyStatus.IX_ForecastAudit2NONCLUSTERED280566105080932026-09-16 01:01:092026-09-16 01:01:02USEDkeep — in use
ASSET.schedule.PolicyStatus.IX_SupplierLine3NONCLUSTERED35422080705080932026-09-16 01:01:092026-09-16 01:01:02USEDkeep — in use
ASSET.schedule.PolicyStatus.PK_PricingDaily1CLUSTEREDYY5985021822210905080932026-09-16 01:01:112026-09-16 01:01:01USEDKEEP — primary key
ASSET.schedule.PolicyLine.IX_TerritorySnapshot2NONCLUSTERED41746214320553962026-09-16 01:01:092026-09-15 08:26:28USEDkeep — in use
ASSET.schedule.PolicyLine.PK_BookingAudit1CLUSTEREDYY249059629131831000092026-09-16 01:01:112026-09-15 08:26:28USEDKEEP — primary key
ASSET.schedule.AssetResult.IX_BillingResult2NONCLUSTERED3037000303702026-09-16 01:00:06neverUSEDkeep — in use
ASSET.schedule.AssetResult.PK_TicketQueue1CLUSTEREDYY00030370neverneverUNUSEDKEEP — primary key
ASSET.schedule.InvoiceAudit.IX_StaffingQueue2NONCLUSTERED54704877701790532026-09-16 01:01:082026-09-15 08:26:26USEDkeep — in use
ASSET.schedule.InvoiceAudit.PK_LedgerMonthly1CLUSTEREDYY24470324200951846722026-09-16 01:01:072026-09-15 08:26:26USEDKEEP — primary key
ASSET.schedule.SettlementLog.IX_TicketLine2NONCLUSTERED422016205892022026-09-16 01:01:092026-09-16 01:00:52USEDkeep — in use
ASSET.schedule.SettlementLog.IX_PolicyLine3NONCLUSTERED6465280605892022026-09-16 01:00:542026-09-16 01:00:52USEDkeep — in use
ASSET.schedule.SettlementLog.PK_CatalogMonthly1CLUSTEREDYY741929062366300402026-09-16 01:01:092026-09-16 01:00:51USEDKEEP — primary key
ASSET.schedule.PricingSnapshot.IX_SettlementStatus15NONCLUSTERED0000never2026-09-13 04:02:24UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_InvoiceSummary3NONCLUSTERED0000never2026-09-13 04:02:24UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_WarehouseStaging4NONCLUSTERED0000never2026-09-13 04:02:24UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_WarehouseStatus2NONCLUSTERED0000never2026-09-13 04:02:24UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.PK_RosterEntry1CLUSTEREDYY0000never2026-09-13 04:02:24UNUSEDKEEP — primary key
ASSET.schedule.ShiftHeader.IX_TicketStatus3NONCLUSTERED1899590711962026-09-12 15:13:432026-09-15 03:42:01USEDkeep — in use
ASSET.schedule.ShiftHeader.IX_ShipmentLine4NONCLUSTERED24295500711962026-09-16 01:01:082026-09-15 03:42:01USEDkeep — in use
ASSET.schedule.ShiftHeader.PK_OrdersArchive1CLUSTEREDYY3008611712719991788782026-09-16 01:01:102026-09-15 03:42:01USEDKEEP — primary key
ASSET.schedule.ShiftHeader.IX_BookingStatus2NONCLUSTEREDY35885750711962026-09-16 01:00:252026-09-15 03:42:30USEDkeep — in use
ASSET.schedule.PolicyLine.PK_RouteQueue1CLUSTEREDYY1054582435410708122026-09-16 01:01:092026-09-15 03:42:39USEDKEEP — primary key
ASSET.schedule.PolicyLine.UX_TerritoryHistory2NONCLUSTEREDYY408020360252026-09-14 14:30:172026-09-15 03:42:39USEDkeep — in use
ASSET.schedule.SalesDaily.IX_ForecastHistory2NONCLUSTERED120042026-09-10 10:30:142026-09-13 04:02:36USEDkeep — in use
ASSET.schedule.SalesDaily.IX_QuotaSummary3NONCLUSTERED0006never2026-09-13 04:02:36UNUSEDreview, then DROP
ASSET.schedule.SalesDaily.PK_ClaimResult1CLUSTEREDYY021082026-09-10 10:30:182026-09-13 04:02:36USEDKEEP — primary key
ASSET.schedule.RosterHistory.IX_AssetSummary2NONCLUSTERED14616932390358022026-09-16 01:01:092026-09-15 03:42:40USEDkeep — in use
ASSET.schedule.RosterHistory.PK_WarehouseLine1CLUSTEREDYY75949401414358022026-09-16 01:00:562026-09-15 03:42:40USEDKEEP — primary key
ASSET.schedule.ContractStaging.IX_StaffingLine2NONCLUSTERED80042026-09-10 10:29:182026-09-13 04:02:37USEDkeep — in use
ASSET.schedule.ContractStaging.IX_ShiftSummary3NONCLUSTERED02062026-09-10 10:29:282026-09-13 04:02:37USEDkeep — in use
ASSET.schedule.ContractStaging.PK_PolicyLine1CLUSTEREDYY018062026-09-10 10:30:182026-09-13 04:02:36USEDKEEP — primary key
ASSET.schedule.MeterStaging.IX_PayrollAudit2NONCLUSTERED200955186600359572026-09-16 01:01:082026-09-15 03:42:40USEDkeep — in use
ASSET.schedule.MeterStaging.PK_PolicyArchive1CLUSTEREDYY58777101702360432026-09-16 01:00:422026-09-15 03:42:40USEDKEEP — primary key
ASSET.schedule.SupplierEntry.IX_InvoiceStaging2NONCLUSTERED80042026-09-10 10:29:182026-09-13 04:02:37USEDkeep — in use
ASSET.schedule.SupplierEntry.IX_StaffingDaily3NONCLUSTERED03062026-09-10 10:29:282026-09-13 04:02:37USEDkeep — in use
ASSET.schedule.SupplierEntry.PK_MeterQueue1CLUSTEREDYY017062026-09-10 10:30:182026-09-13 04:02:37USEDKEEP — primary key
ASSET.schedule.ForecastEntry.IX_ContractHistory2NONCLUSTERED38301312026-09-10 10:30:182026-09-15 03:42:41USEDkeep — in use
ASSET.schedule.ForecastEntry.IX_ForecastLine3NONCLUSTERED03349101332026-09-15 08:24:492026-09-15 03:42:41USEDkeep — in use
ASSET.schedule.ForecastEntry.PK_MeterSummary1CLUSTEREDYY095933487335552026-09-15 09:25:022026-09-15 03:42:41USEDKEEP — primary key
ASSET.schedule.CustomerHistory.IX_LedgerQueue2NONCLUSTERED59380932903867312026-09-16 01:00:092026-09-15 03:44:16USEDkeep — in use
ASSET.schedule.CustomerHistory.PK_PayrollAudit1CLUSTEREDYY57948942242323870002026-09-15 16:07:532026-09-15 03:44:14USEDKEEP — primary key
ASSET.schedule.QuotaDetail.IX_QuotaMonthly2NONCLUSTERED1000773212026-09-10 10:29:292026-09-15 03:44:18USEDkeep — in use
ASSET.schedule.QuotaDetail.IX_TicketSummary3NONCLUSTERED020773232026-09-10 10:29:292026-09-15 03:44:18USEDkeep — in use
ASSET.schedule.QuotaDetail.PK_RosterHeader1CLUSTEREDYY0334450774512026-09-15 08:26:082026-09-15 03:44:17USEDKEEP — primary key
ASSET.schedule.RosterResult.IX_BookingAudit2NONCLUSTERED15141001760422026-09-11 20:09:452026-09-15 03:47:13USEDkeep — in use
ASSET.schedule.RosterResult.IX_AssetStaging3NONCLUSTERED1050941557501760422026-09-15 16:07:552026-09-15 03:47:51USEDkeep — in use
ASSET.schedule.RosterResult.PK_PricingSummary1CLUSTEREDYY37554026195603311763102026-09-16 01:00:062026-09-15 03:47:05USEDKEEP — primary key
ASSET.schedule.MeterSnapshot.IX_StaffingSummary2NONCLUSTERED11001540262026-09-10 10:29:292026-09-15 03:47:54USEDkeep — in use
ASSET.schedule.MeterSnapshot.IX_MeterLog3NONCLUSTERED0201540282026-09-10 10:29:292026-09-15 03:47:54USEDkeep — in use
ASSET.schedule.MeterSnapshot.PK_CampaignSnapshot1CLUSTEREDYY03344801541562026-09-15 08:26:082026-09-15 03:47:54USEDKEEP — primary key
ASSET.schedule.LedgerSnapshot.PK_RouteStatus1CLUSTEREDYY12551119528012026-09-16 01:00:382026-09-13 04:06:14USEDKEEP — primary key
ASSET.schedule.LedgerSnapshot.IX_TicketLine2NONCLUSTEREDY14012026-09-01 01:02:172026-09-13 04:06:14USEDkeep — in use
ASSET.schedule.RosterHistory.PK_MeterLine1CLUSTEREDYY99611914016732026-09-16 01:00:252026-09-13 04:06:14USEDKEEP — primary key
ASSET.schedule.AssetStaging.PK_CampaignResult1CLUSTEREDYY48033450016712026-09-16 01:00:322026-09-13 04:06:14USEDKEEP — primary key
ASSET.schedule.RouteLine.PK_MeterLine1CLUSTEREDYY56042026-09-09 15:22:522026-09-13 04:01:32USEDKEEP — primary key
ASSET.schedule.InvoiceLog.PK_CatalogSummary1CLUSTEREDYY80581973123102026-09-15 16:24:072026-09-13 04:01:33USEDKEEP — primary key
ASSET.schedule.InvoiceLog.IX_WarehouseHeader2NONCLUSTEREDY13300102026-09-12 14:06:292026-09-13 04:01:33USEDkeep — in use
ASSET.schedule.ContractResult.PK_StaffingSummary1CLUSTEREDYY070320102026-09-15 16:24:072026-09-13 04:01:33USEDKEEP — primary key
ASSET.schedule.ContractResult.UX_CampaignHistory2NONCLUSTEREDYY3092100102026-09-15 16:09:532026-09-13 04:01:33USEDkeep — in use
ASSET.schedule.SalesArchive.IX_RosterStatus1CLUSTERED00010never2026-09-13 04:01:33UNUSEDKEEP — table storage
ASSET.schedule.CatalogHistory.PK_OrdersStatus1CLUSTEREDYY126111002026-09-15 16:07:002026-09-13 04:01:33USEDKEEP — primary key
ASSET.schedule.CatalogHistory.IX_PricingStatus2NONCLUSTEREDY01002026-08-22 07:45:482026-09-13 04:01:33USEDkeep — in use
ASSET.schedule.engine.PK_ReconcileDaily1CLUSTEREDYY54213885053902026-09-16 01:01:092026-09-13 04:04:08USEDKEEP — primary key
ASSET.schedule.engine.UQ_MeterQueue2NONCLUSTEREDY506061002026-09-16 01:00:062026-09-13 04:04:08USEDkeep — in use
ASSET.schedule.TerritoryAudit.PK_PayrollSnapshot1CLUSTEREDYY0341083259962026-09-15 16:07:542026-09-15 03:47:55USEDKEEP — primary key
ASSET.schedule.TerritoryAudit.UX_BookingHeader2NONCLUSTEREDYY4108300151232026-09-15 16:07:542026-09-15 03:47:55USEDkeep — in use
ASSET.schedule.WarehouseArchive.IX_CustomerHistory2NONCLUSTERED00028181never2026-09-15 15:54:45UNUSEDreview, then DROP
ASSET.schedule.WarehouseArchive.IX_OrdersHeader3NONCLUSTERED14721170281812026-09-16 01:00:062026-09-15 15:54:45USEDkeep — in use
ASSET.schedule.WarehouseArchive.PK_RouteAudit1CLUSTEREDYY44784147290447942026-09-16 01:00:06neverUSEDKEEP — primary key
ASSET.schedule.LedgerMonthly.IX_CatalogDaily2NONCLUSTERED000629488neverneverUNUSEDreview, then DROP
ASSET.schedule.LedgerMonthly.IX_CustomerMonthly3NONCLUSTERED147211706294882026-09-16 01:00:06neverUSEDkeep — in use
ASSET.schedule.LedgerMonthly.PK_ClaimLine1CLUSTEREDYY9442051309442232026-09-16 01:01:09neverUSEDKEEP — primary key
ASSET.schedule.RouteAudit.IX_InvoiceHeader2NONCLUSTERED2001385092026-09-03 15:27:062026-09-15 03:47:56USEDkeep — in use
ASSET.schedule.RouteAudit.IX_SettlementDetail16NONCLUSTEREDY5461548002670302026-09-10 14:06:47neverUSEDkeep — in use
ASSET.schedule.RouteAudit.IX_CatalogArchive3NONCLUSTERED310901385092026-09-15 09:24:282026-09-15 03:47:56USEDkeep — in use
ASSET.schedule.RouteAudit.IX_QuotaStaging4NONCLUSTERED02501385092026-09-11 20:27:212026-09-15 03:47:56USEDkeep — in use
ASSET.schedule.RouteAudit.PK_PayrollAudit1CLUSTEREDYY7093074855972693802026-09-15 09:24:282026-09-15 03:47:56USEDKEEP — primary key
ASSET.schedule.ShipmentHeader.IX_QuotaSnapshot2NONCLUSTERED1103147482026-09-03 15:27:062026-09-15 03:48:03USEDkeep — in use
ASSET.schedule.ShipmentHeader.IX_InvoiceSummary4NONCLUSTERED000314748never2026-09-15 03:48:06UNUSEDreview, then DROP
ASSET.schedule.ShipmentHeader.IX_CampaignHistory3NONCLUSTERED0203147482026-09-03 15:29:512026-09-15 03:48:06USEDkeep — in use
ASSET.schedule.ShipmentHeader.PK_CampaignDetail1CLUSTEREDYY1313147482026-09-04 09:02:002026-09-15 03:47:57USEDKEEP — primary key
ASSET.schedule.SupplierEntry.PK_AssetSnapshot1CLUSTEREDYY2010614002026-09-16 01:01:092026-09-13 04:04:19USEDKEEP — primary key
ASSET.schedule.TerritoryDetail.PK_ReconcileMonthly1CLUSTEREDYY67801342026-09-12 13:44:062026-09-13 04:04:19USEDKEEP — primary key
ASSET.schedule.StaffingEntry.PK_QuotaDetail1CLUSTEREDYY2279812213482012026-09-16 01:01:092026-09-13 04:04:19USEDKEEP — primary key
ASSET.schedule.StaffingEntry.UQ_TicketDetail2NONCLUSTEREDY6730672026-09-12 13:44:062026-09-13 04:04:20USEDkeep — in use
ASSET.schedule.StaffingEntry.UX_PayrollDaily3NONCLUSTEREDYY4027104901342026-09-16 01:01:092026-09-13 04:04:20USEDkeep — in use
ASSET.schedule.ForecastMonthly.IX_WarehouseDaily2NONCLUSTERED70022796092026-09-11 20:29:262026-09-15 03:48:10USEDkeep — in use
ASSET.schedule.ForecastMonthly.IX_PayrollHistory3NONCLUSTERED91022796092026-09-03 15:24:232026-09-15 03:48:10USEDkeep — in use
ASSET.schedule.ForecastMonthly.IX_BatchMonthly4NONCLUSTERED366022796092026-09-14 15:34:002026-09-15 03:48:10USEDkeep — in use
ASSET.schedule.ForecastMonthly.PK_ForecastHistory1CLUSTEREDYY227944524645590542026-09-16 01:01:092026-09-15 03:48:09USEDKEEP — primary key
ASSET.schedule.CatalogEntry.PK_PolicyDetail1CLUSTEREDYY4027104502026-09-16 01:01:092026-09-13 04:06:14USEDKEEP — primary key
ASSET.schedule.CatalogEntry.UQ_AssetAudit2NONCLUSTEREDY51002026-09-14 15:40:312026-09-13 04:06:14USEDkeep — in use
ASSET.schedule.ContractAudit.PK_TicketSummary1CLUSTEREDYY22796094002026-09-16 01:01:092026-09-13 04:06:14USEDKEEP — primary key
ASSET.schedule.ContractAudit.UQ_OrdersStaging2NONCLUSTEREDY01002026-08-22 07:45:482026-09-13 04:06:14USEDkeep — in use
ASSET.schedule.ContractAudit.UX_BillingSnapshot3NONCLUSTEREDYY4027100002026-09-16 01:01:092026-09-13 04:06:14USEDkeep — in use
ASSET.schedule.SupplierSummary.PK_LedgerEntry1CLUSTEREDYY082202026-09-14 15:40:312026-09-13 04:06:14USEDKEEP — primary key
ASSET.schedule.SupplierSummary.UQ_BillingStaging2NONCLUSTEREDY21002026-08-22 07:45:482026-09-13 04:06:14USEDkeep — in use
ASSET.schedule.PayrollDaily.PK_CustomerQueue1CLUSTEREDYY34665625442012026-09-15 16:07:532026-09-13 04:06:14USEDKEEP — primary key
ASSET.schedule.WarehouseDaily.PK_QuotaAudit1CLUSTEREDYY6712002026-09-14 15:40:312026-09-13 04:06:14USEDKEEP — primary key
ASSET.schedule.WarehouseDaily.UQ_ShiftEntry2NONCLUSTEREDY01002026-08-22 07:45:482026-09-13 04:06:14USEDkeep — in use
ASSET.schedule.WarehouseDaily.UX_TerritorySummary3NONCLUSTEREDYY670002026-09-12 13:44:062026-09-13 04:06:14USEDkeep — in use
ASSET.schedule.sql.IX_PayrollEntry3NONCLUSTEREDY40271912104352026-09-16 01:01:092026-09-15 03:48:12USEDkeep — in use
ASSET.schedule.sql.PK_ContractMonthly1CLUSTEREDYY10601038304352026-09-14 16:08:472026-09-15 03:48:12USEDKEEP — primary key
ASSET.schedule.sql.UQ_SalesStatus2NONCLUSTEREDY782890092026-09-14 16:08:472026-09-15 03:48:12USEDkeep — in use
ASSET.schedule.LedgerStatus.PK_SettlementQueue1CLUSTEREDYY04002026-08-22 14:41:592026-09-13 04:06:15USEDKEEP — primary key
ASSET.schedule.LedgerStatus.UQ_QuotaAudit2NONCLUSTEREDY01002026-08-22 07:45:482026-09-13 04:06:15USEDkeep — in use
ASSET.schedule.OrdersQueue.PK_QuotaQueue1CLUSTEREDYY67801342026-09-12 13:44:062026-09-13 04:06:15USEDKEEP — primary key
ASSET.schedule.LedgerStaging.IX_StaffingLog4NONCLUSTERED404812194020392026-09-16 01:01:092026-09-15 03:48:12USEDkeep — in use
ASSET.schedule.LedgerStaging.PK_ContractQueue1CLUSTEREDYY228151317140342220392026-09-16 01:01:092026-09-15 03:48:12USEDKEEP — primary key
ASSET.schedule.LedgerStaging.UQ_TicketResult2NONCLUSTEREDY376804232026-09-14 15:59:482026-09-15 03:48:12USEDkeep — in use
ASSET.schedule.LedgerStaging.UX_QuotaHeader3NONCLUSTEREDYY0001616never2026-09-15 03:48:12UNUSEDreview carefully — unique
ASSET.schedule.step.PK_AssetStaging1CLUSTEREDYY52651710602026-09-16 01:01:092026-09-13 04:06:16USEDKEEP — primary key
ASSET.schedule.step.UQ_AssetQueue2NONCLUSTEREDY54002026-09-14 15:40:312026-09-13 04:06:16USEDkeep — in use
ASSET.schedule.step.UQ_OrdersLine5NONCLUSTEREDY55002026-09-11 20:21:432026-09-13 04:06:16USEDkeep — in use
ASSET.schedule.ShipmentResult.PK_MeterSnapshot1CLUSTEREDYY681201342026-09-12 13:44:062026-09-13 04:06:17USEDKEEP — primary key
ASSET.schedule.WarehouseEntry.PK_SettlementLine1CLUSTEREDYY2279745402857002026-09-16 01:01:092026-09-13 04:06:17USEDKEEP — primary key
ASSET.schedule.WarehouseEntry.UQ_ShiftSnapshot2NONCLUSTEREDY01002026-08-22 07:45:482026-09-13 04:06:17USEDkeep — in use
ASSET.schedule.WarehouseEntry.UX_OrdersLog3NONCLUSTEREDYY30002026-09-03 09:02:172026-09-13 04:06:17USEDkeep — in use
ASSET.wps.ContractStatus.IX_RosterDaily4NONCLUSTERED63800494592026-09-15 23:58:032026-09-13 04:06:17USEDkeep — in use
ASSET.wps.ContractStatus.PK_ClaimLog1CLUSTEREDYY049459638494592026-09-16 01:00:582026-09-13 04:06:17USEDKEEP — primary key
ASSET.wps.ContractStatus.UX_TerritoryResult14NONCLUSTEREDYY0000never2026-09-13 04:06:17COLDreview carefully — unique
ASSET.wps.ContractStatus.UX_SettlementDetail2NONCLUSTEREDY0000never2026-09-13 04:06:17UNUSEDreview carefully — unique
ASSET.wps.PolicyResult.IX_ContractSnapshot2NONCLUSTERED30500112026-09-15 07:30:002026-09-13 04:06:17USEDkeep — in use
ASSET.wps.PolicyResult.PK_SettlementLine1CLUSTEREDYY589128243112026-09-15 23:59:002026-09-13 04:06:17USEDKEEP — primary key
ASSET.wps.LedgerMonthly.PK_LedgerMonthly1CLUSTEREDYY00016never2026-09-13 04:06:17UNUSEDKEEP — primary key
ASSET.wps.BookingStaging.PK_ClaimHistory1CLUSTEREDYY01420142026-09-07 15:07:552026-09-13 04:06:17USEDKEEP — primary key
ASSET.wps.SalesHeader.PK_ContractHistory1CLUSTEREDYY00020never2026-09-13 04:06:18UNUSEDKEEP — primary key
ASSET.wps.ForecastResult.PK_QuotaLog1CLUSTEREDYY2739209398856092026-09-15 23:59:002026-09-15 03:48:15USEDKEEP — primary key
ASSET.wps.ForecastResult.UQ_ShipmentArchive5NONCLUSTEREDY406521006002026-09-16 00:00:002026-09-15 03:48:15USEDkeep — in use
ASSET.wps.StaffingResult.PK_RosterStatus1CLUSTEREDYY1412862072026-09-16 01:01:002026-09-13 04:06:18USEDKEEP — primary key
ASSET.wps.StaffingStaging.PK_PolicyEntry1CLUSTEREDYY01072026-09-07 10:42:472026-09-13 04:06:18USEDKEEP — primary key
ASSET.wps.CustomerSnapshot.PK_WarehouseArchive1CLUSTEREDYY0000never2026-09-13 04:06:18UNUSEDKEEP — primary key
ASSET.wps.LedgerQueue.PK_BatchQueue1CLUSTEREDYY0000never2026-09-13 04:06:18UNUSEDKEEP — primary key
ASSET.wps.TerritoryQueue.IX_InvoiceAudit10NONCLUSTERED3482143026102026-09-15 23:59:002026-09-13 04:06:18USEDkeep — in use
ASSET.wps.TerritoryQueue.PK_RosterSnapshot1CLUSTEREDYY129620283826102026-09-15 07:30:002026-09-13 04:06:18USEDKEEP — primary key
ASSET.wps.TerritoryQueue.UX_MeterStaging2NONCLUSTEREDY267820025902026-09-15 07:30:002026-09-13 04:06:18USEDkeep — in use
ASSET.wps.ContractEntry.PK_PayrollSummary1CLUSTEREDYY0002590never2026-09-13 04:06:18UNUSEDKEEP — primary key
ASSET.wps.TicketStatus.PK_InvoiceMonthly1CLUSTEREDYY2321662148792026-09-15 23:59:002026-09-15 03:48:15USEDKEEP — primary key
ASSET.wps.TicketStatus.UQ_OrdersQueue2NONCLUSTEREDY14800702026-09-15 07:30:002026-09-15 03:48:15USEDkeep — in use
ASSET.wps.SalesDetail.PK_SettlementLine1CLUSTEREDYY000600never2026-09-15 03:48:15UNUSEDKEEP — primary key
ASSET.wps.ClaimResult.PK_TicketEntry1CLUSTEREDYY660194082026-09-15 23:58:032026-09-13 04:06:19USEDKEEP — primary key
ASSET.wps.CatalogSnapshot.PK_ForecastHeader1CLUSTEREDYY00014never2026-09-13 04:06:19UNUSEDKEEP — primary key
ASSET.wps.BillingLine.PK_RosterResult1CLUSTEREDYY1017618420032026-09-15 23:59:002026-09-13 04:06:19USEDKEEP — primary key
ASSET.wps.BillingLine.UX_WarehouseLog2NONCLUSTEREDYY60032026-09-07 13:57:142026-09-13 04:06:19USEDkeep — in use
ASSET.wps.BatchStatus.PK_ClaimLine1CLUSTEREDYY0349110412026-09-15 23:59:002026-09-13 04:06:19USEDKEEP — primary key
ASSET.wps.BatchStatus.UQ_CustomerHeader2NONCLUSTEREDY1040012026-09-10 15:40:022026-09-13 04:06:19USEDkeep — in use
ASSET.wps.BookingResult.PK_WarehouseMonthly1CLUSTEREDYY0001never2026-09-13 04:06:19UNUSEDKEEP — primary key
ASSET.wps.BookingStaging.PK_ForecastLog1CLUSTEREDYY012062026-09-07 12:50:112026-09-13 04:06:19USEDKEEP — primary key
CLAIM_Prod.bm.BOM.PK_MeterHistory1CLUSTEREDYY0000never2026-09-13 04:06:20UNUSEDKEEP — primary key
CLAIM_Prod.bm.CatalogQueue.PK_StaffingSummary1CLUSTEREDYY0000never2026-09-13 04:06:20UNUSEDKEEP — primary key
CLAIM_Prod.bm.ShiftEntry.PK_RouteStatus1CLUSTEREDYY0000never2026-09-13 04:06:20UNUSEDKEEP — primary key
CLAIM_Prod.bm.BillingArchive.PK_AssetMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.bm.ForecastDetail.PK_CatalogLog1CLUSTEREDYY0000never2026-09-13 04:06:20UNUSEDKEEP — primary key
CLAIM_Prod.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.dbo.StaffingEntry.PK_AssetStaging1CLUSTEREDYY0000never2026-09-13 04:06:20UNUSEDKEEP — primary key
CLAIM_Prod.dbo.QuotaLine.PK_ClaimSummary1CLUSTEREDYY0000never2026-09-13 04:06:20UNUSEDKEEP — primary key
CLAIM_Prod.dbo.QuotaLine.UX_ForecastSummary2NONCLUSTEREDY0000never2026-09-13 04:06:20UNUSEDreview 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-13 04:06:20UNUSEDKEEP — primary key
CLAIM_Prod.lib.SalesLine.PK_StaffingEntry1CLUSTEREDYY0000never2026-09-13 04:06:20UNUSEDKEEP — primary key
CLAIM_Prod.lib.SalesLine.UX_QuotaArchive2NONCLUSTEREDY0000never2026-09-13 04:06:20UNUSEDreview carefully — unique
CLAIM_Prod.lib.CustomerLog.PK_ClaimMonthly1CLUSTEREDYY0000never2026-09-13 04:06:20UNUSEDKEEP — primary key
CLAIM_Prod.lib.BillingArchive.PK_StaffingDetail1CLUSTEREDYY0000never2026-09-13 04:06:20UNUSEDKEEP — primary key
CLAIM_Prod.lib.BillingArchive.UX_CustomerEntry9NONCLUSTEREDY0000never2026-09-13 04:06:20UNUSEDreview carefully — unique
CLAIM_Prod.lib.CustomerArchive.PK_ForecastSummary1CLUSTEREDYY0000never2026-09-13 04:06:21UNUSEDKEEP — primary key
CLAIM_Prod.lib.SettlementHeader.PK_ShiftHeader1CLUSTEREDYY0000never2026-09-13 04:06:21UNUSEDKEEP — primary key
CLAIM_Prod.lib.SettlementHeader.UX_ForecastDaily2NONCLUSTEREDY0000never2026-09-13 04:06:21UNUSEDreview 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-13 04:06:21UNUSEDKEEP — primary key
CLAIM_Prod.lib.ReconcileEntry.PK_BatchLog1CLUSTEREDYY0000never2026-09-13 04:06:22UNUSEDKEEP — primary key
CLAIM_Prod.lib.RouteStatus.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-13 04:06:22UNUSEDKEEP — primary key
CLAIM_Prod.lib.InvoiceLine.PK_AssetArchive1CLUSTEREDYY0000never2026-09-13 04:06:22UNUSEDKEEP — primary key
CLAIM_Prod.lib.Size.PK_ClaimArchive1CLUSTEREDYY0000never2026-09-13 04:06:22UNUSEDKEEP — primary key
CLAIM_Prod.lib.StaffingQueue.PK_CampaignAudit1CLUSTEREDYY0000never2026-09-13 04:06:22UNUSEDKEEP — primary key
CLAIM_Prod.lib.MeterAudit.PK_TerritoryDaily1CLUSTEREDYY0000never2026-09-13 04:06:22UNUSEDKEEP — primary key
CLAIM_Prod.lib.RosterResult.PK_ShipmentEntry1CLUSTEREDYY0000never2026-09-13 04:06:22UNUSEDKEEP — primary key
CLAIM_Prod.lib.BookingResult.PK_ForecastLine1CLUSTEREDYY0000never2026-09-13 04:06:22UNUSEDKEEP — primary key
CLAIM_Prod.lib.MeterAudit.PK_ReconcileDaily1CLUSTEREDYY0000never2026-09-13 04:06:22UNUSEDKEEP — primary key
CLAIM_Prod.lib.ContractLog.PK_TerritoryLog1CLUSTEREDYY0000never2026-09-13 04:06:23UNUSEDKEEP — primary key
CLAIM_Prod.lib.CustomerLine.PK_QuotaArchive1CLUSTEREDYY0000never2026-09-13 04:06:23UNUSEDKEEP — primary key
CLAIM_Prod.sm.QuotaHistory.PK_BatchLine1CLUSTEREDYY0000never2026-09-13 04:06:23UNUSEDKEEP — primary key
CLAIM_Prod.sm.InvoiceStaging.PK_QuotaDaily1CLUSTEREDYY0000never2026-09-13 04:06:23UNUSEDKEEP — primary key
CLAIM_Prod.sm.PricingStatus.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-13 04:06:23UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryArchive.PK_TerritoryLine1CLUSTEREDYY0000never2026-09-13 04:06:23UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryArchive.UX_PayrollResult4NONCLUSTEREDY0000never2026-09-13 04:06:23UNUSEDreview carefully — unique
CLAIM_Prod.sm.BookingResult.PK_RosterStaging1CLUSTEREDYY0000never2026-09-13 04:06:23UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryMonthly.PK_BookingAudit1CLUSTEREDYY0000never2026-09-13 04:06:23UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryMonthly.UX_StaffingResult2NONCLUSTEREDY0000never2026-09-13 04:06:23UNUSEDreview 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-13 04:06:23UNUSEDKEEP — 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-13 04:06:24UNUSEDKEEP — 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-13 04:06:24UNUSEDKEEP — primary key
CONTRACT.bm.BOM.PK_MeterHistory1CLUSTEREDYY0000never2026-09-13 04:06:25UNUSEDKEEP — primary key
CONTRACT.bm.CatalogQueue.PK_StaffingSummary1CLUSTEREDYY0000never2026-09-13 04:06:25UNUSEDKEEP — primary key
CONTRACT.bm.ShiftEntry.PK_RouteStatus1CLUSTEREDYY0000never2026-09-13 04:06:25UNUSEDKEEP — 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-13 04:06:25UNUSEDKEEP — primary key
CONTRACT.dbo.QuotaLine.PK_ClaimSummary1CLUSTEREDYY0000never2026-09-13 04:06:25UNUSEDKEEP — primary key
CONTRACT.dbo.QuotaLine.UX_ForecastSummary2NONCLUSTEREDY0000never2026-09-13 04:06:25UNUSEDreview carefully — unique
CONTRACT.dbo.QuotaResult.PK_SettlementSummary1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.dbo.QuotaResult.IX_BillingLog2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
CONTRACT.lib.Color.PK_ReconcileStaging1CLUSTEREDYY0000never2026-09-13 04:06:26UNUSEDKEEP — primary key
CONTRACT.lib.SalesLine.PK_StaffingEntry1CLUSTEREDYY0000never2026-09-13 04:06:26UNUSEDKEEP — primary key
CONTRACT.lib.SalesLine.UX_QuotaArchive2NONCLUSTEREDY0000never2026-09-13 04:06:26UNUSEDreview carefully — unique
CONTRACT.lib.CustomerLog.PK_ClaimMonthly1CLUSTEREDYY0000never2026-09-13 04:06:26UNUSEDKEEP — primary key
CONTRACT.lib.BillingArchive.PK_StaffingDetail1CLUSTEREDYY0000never2026-09-13 04:06:26UNUSEDKEEP — primary key
CONTRACT.lib.BillingArchive.UX_CustomerEntry9NONCLUSTEREDY0000never2026-09-13 04:06:26UNUSEDreview carefully — unique
CONTRACT.lib.CustomerArchive.PK_ForecastSummary1CLUSTEREDYY0000never2026-09-13 04:06:27UNUSEDKEEP — primary key
CONTRACT.lib.SettlementHeader.PK_ShiftHeader1CLUSTEREDYY0000never2026-09-13 04:06:27UNUSEDKEEP — primary key
CONTRACT.lib.SettlementHeader.UX_ForecastDaily2NONCLUSTEREDY0000never2026-09-13 04:06:27UNUSEDreview carefully — unique
CONTRACT.lib.SupplierSummary.PK_BookingHeader1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.lib.LedgerSnapshot.PK_ClaimDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.lib.RouteDetail.PK_SalesStaging1CLUSTEREDYY0000never2026-09-13 04:06:27UNUSEDKEEP — primary key
CONTRACT.lib.ReconcileEntry.PK_BatchLog1CLUSTEREDYY0000never2026-09-13 04:06:27UNUSEDKEEP — primary key
CONTRACT.lib.RouteStatus.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-13 04:06:27UNUSEDKEEP — primary key
CONTRACT.lib.InvoiceLine.PK_AssetArchive1CLUSTEREDYY0000never2026-09-13 04:06:27UNUSEDKEEP — primary key
CONTRACT.lib.Size.PK_ClaimArchive1CLUSTEREDYY0000never2026-09-13 04:06:27UNUSEDKEEP — primary key
CONTRACT.lib.StaffingQueue.PK_CampaignAudit1CLUSTEREDYY0000never2026-09-13 04:06:27UNUSEDKEEP — primary key
CONTRACT.lib.MeterAudit.PK_TerritoryDaily1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.lib.RosterResult.PK_ShipmentEntry1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.lib.BookingResult.PK_ForecastLine1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.lib.MeterAudit.PK_ReconcileDaily1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.lib.ContractLog.PK_TerritoryLog1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.lib.CustomerLine.PK_QuotaArchive1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.sm.QuotaHistory.PK_BatchLine1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.sm.InvoiceStaging.PK_QuotaDaily1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.sm.PricingStatus.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryArchive.PK_TerritoryLine1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryArchive.UX_PayrollResult4NONCLUSTEREDY0000never2026-09-13 04:06:28UNUSEDreview carefully — unique
CONTRACT.sm.BookingResult.PK_RosterStaging1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryMonthly.PK_BookingAudit1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryMonthly.UX_StaffingResult2NONCLUSTEREDY0000never2026-09-13 04:06:28UNUSEDreview carefully — unique
CONTRACT.sm.QuotaDaily.PK_BookingDetail1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.sm.QuotaDaily.UX_QuotaQueue2NONCLUSTEREDY0000never2026-09-13 04:06:28UNUSEDreview carefully — unique
CONTRACT.sm.CatalogResult.PK_SalesStatus1CLUSTEREDYY0000never2026-09-13 04:06:28UNUSEDKEEP — primary key
CONTRACT.sm.BatchAudit.PK_ReconcileHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.ShiftDaily.PK_ClaimHistory1CLUSTEREDYY0000never2026-09-13 04:06:29UNUSEDKEEP — primary key
CONTRACT.sm.OrdersMonthly.PK_PolicyHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.InvoiceLine.PK_PayrollDetail1CLUSTEREDYY0000never2026-09-13 04:06:29UNUSEDKEEP — primary key
CONTRACT.sm.BillingEntry.PK_SettlementArchive1CLUSTEREDYY0000never2026-09-13 04:06:29UNUSEDKEEP — primary key
CONTRACT.sm.ShipmentDaily.PK_CatalogDetail1CLUSTEREDYY0000never2026-09-13 04:06:29UNUSEDKEEP — primary key
CONTRACT.sm.ShipmentDaily.UX_TicketMonthly2NONCLUSTEREDY0000never2026-09-13 04:06:29UNUSEDreview carefully — unique
CONTRACT.sm.PolicyHeader.PK_CustomerSummary1CLUSTEREDYY0000never2026-09-13 04:06:29UNUSEDKEEP — primary key
CONTRACT.sm.PolicyHeader.UX_LedgerDetail2NONCLUSTEREDY0000never2026-09-13 04:06:29UNUSEDreview carefully — unique
CONTRACT.sm.RouteDetail.PK_SalesDetail1CLUSTEREDYY0000never2026-09-13 04:06:29UNUSEDKEEP — primary key
CONTRACT.sm.QuotaStatus.PK_ShiftDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.ContractAudit.PK_ReconcileArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.BookingHeader.PK_ShipmentArchive1CLUSTEREDYY0000never2026-09-13 04:06:29UNUSEDKEEP — primary key