Index Usage — ACME-198-51-100-45
DBA BrainIndex UsageACME-198-51-100-45snapshot 2026-09-12 01:04:16 +07Fleet inventoryServer metricsSLA
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-125ACME-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-11T18:04:16Z

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
used757had a seek, scan or lookup
unused698written but never read
cold209never read AND never written since restart
disabled0ALTER INDEX ... DISABLE was run
droppable85nonclustered, not unique, no constraint, never read
fragmented22above the rebuild threshold

By database

DatabaseTotalColdDisabledDroppableRecommend action
QUOTA328107029review the drop candidates above
ASSET58915029review the drop candidates above
host_72655946026review the drop candidates above
TICKET_Prod24301review the drop candidates above
CLAIM_Prod581900no action — cold indexes here are constraints or clustered
CONTRACT581100no action — cold indexes here are constraints or clustered
BILLING25500no action — cold indexes here are constraints or clustered
WAREHOUSE22300no action — cold indexes here are constraints or clustered

Drop candidates (85)

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_BatchMonthly4850704neverUNUSEDreview, then DROP
host_726.schedule.LedgerMonthly.IX_CatalogDaily1591628neverUNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_QuotaSnapshot795813neverUNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_InvoiceSummary795813neverUNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_CampaignHistory795813neverUNUSEDreview, then DROP
ASSET.schedule.LedgerMonthly.IX_CatalogDaily493199neverUNUSEDreview, then DROP
ASSET.schedule.ShipmentHeader.IX_InvoiceSummary246604neverUNUSEDreview, then DROP
host_726.wps.ContractStatus.IX_RosterDaily70671neverUNUSEDreview, then DROP
host_726.schedule.WarehouseArchive.IX_CustomerHistory59258neverUNUSEDreview, then DROP
ASSET.emp.BillingAudit.IX_PolicyHeader23477neverUNUSEDreview, then DROP
ASSET.schedule.WarehouseArchive.IX_CustomerHistory22142neverUNUSEDreview, then DROP
host_726.emp.SalesHeader.IX_BookingSummary741neverUNUSEDreview, then DROP
ASSET.emp.SalesHeader.IX_BookingSummary412neverUNUSEDreview, then DROP
ASSET.emp.OrdersMonthly.IX_QuotaArchive268neverUNUSEDreview, then DROP
ASSET.emp.SupplierStaging.IX_StaffingEntry189neverUNUSEDreview, then DROP
host_726.emp.SupplierStaging.IX_StaffingEntry155neverUNUSEDreview, then DROP
ASSET.emp.StaffingMonthly.IX_ReconcileEntry92neverUNUSEDreview, then DROP
ASSET.dbo.BatchResult.IX_SettlementStaging25neverUNUSEDreview, then DROP
ASSET.dbo.BatchResult.IX_ReconcileEntry25neverUNUSEDreview, then DROP
ASSET.dbo.CustomerArchive.IX_BillingHeader25neverUNUSEDreview, 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.InvoiceStaging.IX_AssetAudit8neverUNUSEDreview, then DROP
host_726.org.RosterMonthly.IX_AssetDetail8neverUNUSEDreview, then DROP
ASSET.schedule.SalesDaily.IX_QuotaSummary6neverUNUSEDreview, then DROP
host_726.emp.TicketAudit.IX_LedgerLog4neverUNUSEDreview, then DROP
host_726.schedule.ContractStaging.IX_ShiftSummary2neverUNUSEDreview, then DROP
host_726.schedule.SupplierEntry.IX_StaffingDaily2neverUNUSEDreview, then DROP
host_726.org.ShipmentSummary.IX_StaffingResult0neverUNUSEDreview, 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
QUOTA.emp.QuotaMonthly.IX_ShipmentEntry0neverUNUSEDreview, then DROP
QUOTA.emp.MeterResult.IX_LedgerQueue0neverUNUSEDreview, then DROP
QUOTA.emp.ShiftLine.IX_PricingAudit0neverUNUSEDreview, then DROP
QUOTA.emp.ForecastHeader.IX_WarehouseResult0neverUNUSEDreview, then DROP
QUOTA.emp.PricingDaily.IX_ShiftAudit0neverUNUSEDreview, then DROP
QUOTA.emp.MeterHistory.IX_ContractArchive0neverUNUSEDreview, then DROP
QUOTA.emp.CampaignHistory.IX_QuotaDetail0neverUNUSEDreview, then DROP
QUOTA.emp.SupplierStaging.IX_MeterStaging0neverUNUSEDreview, then DROP
QUOTA.emp.ShipmentMonthly.IX_InvoiceStaging0neverUNUSEDreview, then DROP
QUOTA.emp.AssetSnapshot.IX_SalesDaily0neverUNUSEDreview, then DROP
QUOTA.emp.PricingStatus.IX_QuotaLog0neverUNUSEDreview, then DROP
QUOTA.emp.PricingStatus.IX_ClaimEntry0neverUNUSEDreview, then DROP
QUOTA.emp.BookingMonthly.IX_ShipmentAudit0neverUNUSEDreview, then DROP
QUOTA.emp.BillingQueue.IX_ContractSummary0neverUNUSEDreview, then DROP
QUOTA.org.PolicySummary.IX_AssetEntry0neverUNUSEDreview, then DROP
QUOTA.org.RosterMonthly.IX_AssetDetail0neverUNUSEDreview, then DROP
QUOTA.org.InvoiceStaging.IX_AssetAudit0neverUNUSEDreview, then DROP
QUOTA.org.QuotaEntry.IX_AssetHistory0neverUNUSEDreview, then DROP
ASSET.emp.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.org.CustomerLine.IX_ForecastLine0neverUNUSEDreview, 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
host_726.schedule.PricingSnapshot.IX_SettlementStatus0neverCOLDreview, then DROP
host_726.schedule.PricingSnapshot.IX_InvoiceSummary0neverCOLDreview, then DROP
host_726.schedule.PricingSnapshot.IX_WarehouseStaging0neverCOLDreview, then DROP
QUOTA.org.SupplierHistory.IX_ShipmentSummary0neverCOLDreview, then DROP
QUOTA.org.BillingHeader.IX_ShiftHistory0neverCOLDreview, then DROP
QUOTA.org.ShipmentSummary.IX_StaffingResult0neverCOLDreview, then DROP
QUOTA.emp.TicketAudit.IX_LedgerLog0neverCOLDreview, then DROP
QUOTA.emp.StaffingMonthly.IX_SalesQueue0neverCOLDreview, then DROP
QUOTA.emp.StaffingMonthly.IX_ReconcileEntry0neverCOLDreview, then DROP
QUOTA.emp.SettlementQueue.IX_PolicyAudit0neverCOLDreview, then DROP
host_726.schedule.PricingSnapshot.IX_WarehouseStatus0neverCOLDreview, then DROP
QUOTA.emp.CatalogSummary.IX_ReconcileSummary0neverUNUSEDreview, then DROP
QUOTA.emp.CatalogSummary.IX_WarehouseSnapshot0neverUNUSEDreview, then DROP
QUOTA.emp.CampaignResult.IX_CustomerQueue0neverUNUSEDreview, then DROP
QUOTA.emp.CampaignResult.IX_ForecastAudit0neverUNUSEDreview, then DROP
host_726.schedule.InvoiceHistory.IX_StaffingHeader0neverUNUSEDreview, then DROP
host_726.org.BillingHeader.IX_ShiftHistory0neverUNUSEDreview, then DROP
host_726.org.SupplierHistory.IX_ShipmentSummary0neverUNUSEDreview, then DROP
host_726.dbo.QuotaArchive.IX_InvoiceAudit0neverUNUSEDreview, then DROP
TICKET_Prod.dbo.QuotaArchive.IX_InvoiceAudit0neverUNUSEDreview, then DROP

Fragmented (22) — 22 partitions across 19 indexes

Total 3,355.1 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.ShipmentHeader.IX_QuotaSnapshot1/1NONCLUSTERED99.3%1,71413.42026-09-11 01:31:09REBUILD
ASSET\schedule.ShiftHeader.IX_ShipmentLine#p2222/22NONCLUSTERED99.1%4,80837.62026-09-12 01:00:37REBUILD
host_726\schedule.ShiftHeader.IX_ShipmentLine1/1NONCLUSTERED99.1%52,942413.62026-09-11 01:06:03REBUILD
host_726\schedule.ShiftHeader.IX_TicketStatus1/1NONCLUSTERED99.0%35,156274.72026-09-11 01:06:03REBUILD
ASSET\schedule.ShiftHeader.IX_TicketStatus#p2222/22NONCLUSTERED98.9%2,43319.02026-09-12 01:00:36REBUILD
ASSET\schedule.ShipmentHeader.IX_InvoiceSummary1/1NONCLUSTERED97.3%2,64120.62026-09-11 01:31:09REBUILD
ASSET\schedule.ShiftHeader.IX_BookingStatus#p2222/22NONCLUSTERED93.4%1,81014.12026-09-12 01:00:36REBUILD
host_726\schedule.RouteAudit.IX_InvoiceHeader1/1NONCLUSTERED92.5%1,62012.72026-09-11 01:02:41REBUILD
ASSET\schedule.RouteAudit.IX_InvoiceHeader1/1NONCLUSTERED83.7%9,95877.82026-09-11 01:31:07REBUILD
ASSET\schedule.SettlementLog.PK_CatalogMonthly#p1616/22CLUSTERED56.3%13,194103.12026-09-12 01:01:15REORGANIZE
ASSET\schedule.SettlementLog.IX_PolicyLine#p1616/22NONCLUSTERED55.6%2,27717.82026-09-12 01:01:16REORGANIZE
ASSET\schedule.SettlementLog.IX_TicketLine#p1616/22NONCLUSTERED55.0%3,04723.82026-09-12 01:01:15REORGANIZE
ASSET\schedule.SettlementLog.PK_CatalogMonthly#p2222/22CLUSTERED38.0%76,708599.32026-09-12 01:01:15REORGANIZE
ASSET\schedule.BillingDetail.IX_TicketHeader#p2222/22NONCLUSTERED37.9%14,904116.42026-09-12 01:02:42REORGANIZE
ASSET\schedule.SettlementLog.IX_TicketLine#p2222/22NONCLUSTERED36.4%18,156141.82026-09-12 01:01:15REORGANIZE
ASSET\schedule.RouteAudit.IX_CatalogArchive1/1NONCLUSTERED36.4%10,26980.22026-09-11 01:31:07REORGANIZE
ASSET\schedule.RosterResult.IX_AssetStaging#p1616/22NONCLUSTERED36.3%1,58812.42026-09-12 01:03:26REORGANIZE
ASSET\schedule.SettlementLog.IX_PolicyLine#p2222/22NONCLUSTERED36.1%13,487105.42026-09-12 01:01:16REORGANIZE
ASSET\schedule.RosterResult.PK_PricingSummary#p1616/22CLUSTERED35.7%7,96762.22026-09-12 01:03:26REORGANIZE
ASSET\schedule.BillingDetail.PK_BillingLog#p2222/22CLUSTERED34.7%54,315424.32026-09-12 01:02:41REORGANIZE
ASSET\emp.PolicyHistory.PK_OrdersDaily1/1CLUSTERED31.8%89,343698.02026-09-12 01:03:30REORGANIZE
ASSET\schedule.PolicyStatus.PK_PricingDaily#p1616/22CLUSTERED31.1%11,12086.92026-09-12 01:03:17REORGANIZE

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
TICKET_Prod.app.ShiftAudit.PK_SettlementResult1CLUSTEREDYY73969863672722642026-09-11 15:33:082026-09-11 01:00:04USEDKEEP — primary key
TICKET_Prod.app.ShiftAudit.UX_PayrollAudit2NONCLUSTEREDY1110483302532026-09-11 15:33:022026-09-11 01:00:04USEDkeep — in use
TICKET_Prod.app.ShiftAudit.UX_ContractSummary25NONCLUSTEREDYY90092026-08-29 14:04:402026-09-11 01:00:04USEDkeep — in use
TICKET_Prod.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
TICKET_Prod.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY000253never2026-09-11 01:00:05UNUSEDKEEP — primary key
TICKET_Prod.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY00015895never2026-09-12 01:00:04UNUSEDKEEP — primary key
TICKET_Prod.app.App.PK_InvoiceResult1CLUSTEREDYY02506002026-09-11 15:33:022026-09-06 03:30:04USEDKEEP — primary key
TICKET_Prod.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
TICKET_Prod.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY9858438301292026-09-11 15:33:082026-09-11 01:00:06USEDKEEP — primary key
TICKET_Prod.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY000128never2026-09-11 01:00:06UNUSEDKEEP — primary key
TICKET_Prod.app.Group.PK_BookingEntry1CLUSTEREDYY9002125082026-09-11 15:33:082026-09-06 03:30:04USEDKEEP — primary key
TICKET_Prod.app.Group.UX_LedgerSummary2NONCLUSTEREDY0008never2026-09-11 01:00:06UNUSEDreview carefully — unique
TICKET_Prod.app.PricingLog.PK_AssetResult1CLUSTEREDYY3054201542026-09-11 15:33:022026-09-11 01:00:06USEDKEEP — primary key
TICKET_Prod.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY01374002026-09-10 15:53:372026-09-06 03:30:04USEDKEEP — primary key
TICKET_Prod.app.WarehouseStatus.UX_QuotaLine2NONCLUSTEREDY111150160572026-09-11 15:33:082026-09-11 01:00:06USEDkeep — in use
TICKET_Prod.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY4312404542026-09-11 15:33:022026-09-11 01:00:06USEDKEEP — primary key
TICKET_Prod.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY000361never2026-09-11 01:00:06UNUSEDKEEP — primary key
TICKET_Prod.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY8285775062026-09-11 15:02:502026-09-10 01:00:06USEDKEEP — primary key
TICKET_Prod.app.CatalogMonthly.PK_ClaimHeader1CLUSTEREDYY4415161132026-09-11 15:33:022026-09-10 01:00:06USEDKEEP — primary key
TICKET_Prod.app.CatalogMonthly.UX_RouteQueue5NONCLUSTEREDY31061022026-09-10 16:26:102026-09-10 01:00:06USEDkeep — in use
TICKET_Prod.app.ClaimResult.PK_ShipmentStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
TICKET_Prod.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-06 03:30:05UNUSEDKEEP — primary key
TICKET_Prod.dbo.QuotaArchive.IX_AssetResult1CLUSTEREDYY0000never2026-09-06 03:30:05UNUSEDKEEP — primary key
TICKET_Prod.dbo.QuotaArchive.IX_InvoiceAudit2NONCLUSTERED0000never2026-09-06 03:30:05UNUSEDreview, then DROP
WAREHOUSE.app.ShiftAudit.PK_SettlementResult1CLUSTEREDYY0000never2026-09-06 03:30:06UNUSEDKEEP — primary key
WAREHOUSE.app.ShiftAudit.UX_PayrollAudit2NONCLUSTEREDY0000never2026-09-06 03:30:06UNUSEDreview carefully — unique
WAREHOUSE.app.ShiftAudit.UX_ContractSummary25NONCLUSTEREDYY0000never2026-09-06 03:30:06UNUSEDreview carefully — unique
WAREHOUSE.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
WAREHOUSE.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY0000never2026-09-06 03:30:07UNUSEDKEEP — primary key
WAREHOUSE.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY0000never2026-09-06 03:30:07UNUSEDKEEP — primary key
WAREHOUSE.app.App.PK_InvoiceResult1CLUSTEREDYY0000never2026-09-06 03:30:07UNUSEDKEEP — primary key
WAREHOUSE.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
WAREHOUSE.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY0000never2026-09-06 03:30:07UNUSEDKEEP — primary key
WAREHOUSE.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY0000never2026-09-06 03:30:07UNUSEDKEEP — primary key
WAREHOUSE.app.Group.PK_BookingEntry1CLUSTEREDYY0000never2026-09-06 03:30:07UNUSEDKEEP — primary key
WAREHOUSE.app.Group.UX_LedgerSummary2NONCLUSTEREDY0000never2026-09-06 03:30:07UNUSEDreview carefully — unique
WAREHOUSE.app.PricingLog.PK_AssetResult1CLUSTEREDYY0000never2026-09-06 03:30:07UNUSEDKEEP — primary key
WAREHOUSE.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY0000never2026-09-06 03:30:07UNUSEDKEEP — primary key
WAREHOUSE.app.WarehouseStatus.UX_QuotaLine2NONCLUSTEREDY0000never2026-09-06 03:30:08UNUSEDreview carefully — unique
WAREHOUSE.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY0000never2026-09-06 03:30:08UNUSEDKEEP — primary key
WAREHOUSE.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY0000never2026-09-06 03:30:08UNUSEDKEEP — primary key
WAREHOUSE.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY0000never2026-09-06 03:30:08UNUSEDKEEP — primary key
WAREHOUSE.app.CatalogMonthly.PK_ClaimHeader1CLUSTEREDYY0000never2026-09-06 03:30:08UNUSEDKEEP — primary key
WAREHOUSE.app.CatalogMonthly.UX_RouteQueue5NONCLUSTEREDY0000never2026-09-06 03:30:08UNUSEDreview carefully — unique
WAREHOUSE.app.ClaimResult.PK_ShipmentStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
WAREHOUSE.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-06 03:30:08UNUSEDKEEP — primary key
BILLING.app.ShiftAudit.PK_SettlementResult1CLUSTEREDYY26043147926702026-09-11 21:00:002026-09-12 01:00:05USEDKEEP — primary key
BILLING.app.ShiftAudit.UX_PayrollAudit2NONCLUSTEREDY9377140702026-09-11 16:28:192026-09-12 01:00:05USEDkeep — in use
BILLING.app.ShiftAudit.UX_ContractSummary11NONCLUSTEREDYY0000neverneverCOLDreview carefully — unique
BILLING.app.ReconcileDaily.PK_LedgerResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
BILLING.app.SupplierLog.PK_SalesDetail1CLUSTEREDYY00052never2026-09-12 01:00:06UNUSEDKEEP — primary key
BILLING.app.ReconcileQueue.PK_RosterQueue1CLUSTEREDYY000309never2026-09-12 01:00:06UNUSEDKEEP — primary key
BILLING.app.App.PK_InvoiceResult1CLUSTEREDYY01758002026-09-11 16:22:582026-09-06 03:30:10USEDKEEP — primary key
BILLING.app.CampaignAudit.PK_BillingMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
BILLING.app.CampaignDetail.PK_PolicyLine1CLUSTEREDYY0000never2026-09-06 03:30:10UNUSEDKEEP — primary key
BILLING.app.MeterArchive.PK_BillingStaging1CLUSTEREDYY103381800002026-09-11 16:26:162026-09-06 03:30:10USEDKEEP — primary key
BILLING.app.LedgerDaily.PK_CustomerStatus1CLUSTEREDYY0000never2026-09-06 03:30:10UNUSEDKEEP — primary key
BILLING.app.Group.PK_BookingEntry1CLUSTEREDYY963244012026-09-11 16:26:162026-09-06 03:30:10USEDKEEP — primary key
BILLING.app.Group.UX_LedgerSummary6NONCLUSTEREDY0001never2026-09-06 03:30:10UNUSEDreview carefully — unique
BILLING.app.PricingLog.PK_AssetResult1CLUSTEREDYY192000142026-09-11 16:22:582026-09-12 01:00:06USEDKEEP — primary key
BILLING.app.BatchQueue.PK_ShiftHeader1CLUSTEREDYY0537002026-09-11 14:39:402026-09-06 03:30:10USEDKEEP — primary key
BILLING.app.WarehouseStatus.UX_QuotaLine8NONCLUSTEREDY97855930102026-09-11 16:26:162026-09-12 01:00:06USEDkeep — in use
BILLING.app.ShipmentResult.PK_SettlementSummary1CLUSTEREDYY31950062026-09-11 16:23:022026-09-12 01:00:06USEDKEEP — primary key
BILLING.app.TerritoryQueue.PK_SettlementLine1CLUSTEREDYY0006never2026-09-12 01:00:07UNUSEDKEEP — primary key
BILLING.app.InvoiceLine.PK_ClaimSummary1CLUSTEREDYY20724608082026-09-11 16:23:022026-09-06 03:30:11USEDKEEP — primary key
BILLING.app.CatalogMonthly.PK_ClaimHeader1CLUSTEREDYY26241180032026-09-11 16:23:022026-09-11 01:00:09USEDKEEP — primary key
BILLING.app.CatalogMonthly.UX_RouteQueue7NONCLUSTEREDY50022026-09-10 14:15:062026-09-11 01:00:09USEDkeep — in use
BILLING.app.ClaimResult.PK_ShipmentStaging1CLUSTEREDYY0000never2026-09-06 03:30:11UNUSEDKEEP — primary key
BILLING.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-06 03:30:11UNUSEDKEEP — primary key
BILLING.org.CatalogQueue.PK_RouteAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
BILLING.org.SalesArchive.PK_TicketDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
METERBK.dbo.CampaignStaging.PK_BookingDaily1CLUSTEREDYY01002026-09-10 15:37:42neverUSEDKEEP — primary key
host_726.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-06 03:30:12UNUSEDKEEP — primary key
host_726.cfg.QuotaStatus.UX_MeterSummary2NONCLUSTEREDY0000never2026-09-06 03:30:12UNUSEDreview carefully — unique
host_726.dbo.ContractResult.PK_CampaignResult1CLUSTEREDYY0240242026-09-11 02:15:022026-09-06 03:30:13USEDKEEP — primary key
host_726.dbo.SettlementStaging.PK_TicketStaging1CLUSTEREDYY00024never2026-09-12 01:00:08UNUSEDKEEP — 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_ShiftStatus1CLUSTEREDYY43703119002026-09-11 15:00:132026-09-06 03:30:13USEDKEEP — primary key
host_726.dbo.WarehouseEntry.UX_CampaignHeader2NONCLUSTEREDY0000never2026-09-06 03:30:13UNUSEDreview carefully — unique
host_726.dbo.TicketSummary.PK_SalesLine1CLUSTERED06447002026-09-10 14:51:522026-09-06 03:30:13USEDKEEP — table storage
host_726.dbo.TerritoryEntry.PK_SalesSummary1CLUSTEREDYY1338858002026-09-11 14:48:112026-09-06 03:30:13USEDKEEP — primary key
host_726.dbo.TerritoryEntry.UX_TerritoryQueue2NONCLUSTEREDY0000never2026-09-06 03:30:13UNUSEDreview carefully — unique
host_726.dbo.PolicyEntry.PK_TicketEntry1CLUSTEREDYY6742145002026-09-11 14:48:112026-09-06 03:30:13USEDKEEP — primary key
host_726.dbo.PolicyEntry.UX_PolicyAudit2NONCLUSTEREDY0000never2026-09-06 03:30:13UNUSEDreview carefully — unique
host_726.dbo.CampaignHeader.PK_InvoiceSnapshot1CLUSTEREDYY20119144002026-09-11 15:00:132026-09-06 03:30:13USEDKEEP — primary key
host_726.dbo.CampaignHeader.UX_BillingLog2NONCLUSTEREDY0000never2026-09-06 03:30:13UNUSEDreview carefully — unique
host_726.dbo.WarehouseHeader.PK_OrdersQueue1CLUSTEREDYY095002026-09-10 14:31:182026-09-06 03:30:13USEDKEEP — primary key
host_726.dbo.WarehouseHeader.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-06 03:30:13UNUSEDreview carefully — unique
host_726.dbo.RouteQueue.PK_SupplierAudit1CLUSTEREDYY1342958002026-09-11 14:48:112026-09-06 03:30:13USEDKEEP — primary key
host_726.dbo.RouteQueue.UX_CampaignQueue2NONCLUSTEREDY0000never2026-09-06 03:30:13UNUSEDreview carefully — unique
host_726.dbo.CampaignAudit.PK_BatchSnapshot1CLUSTEREDYY6714145002026-09-11 14:48:112026-09-06 03:30:13USEDKEEP — primary key
host_726.dbo.CampaignAudit.UX_SupplierArchive2NONCLUSTEREDY0000never2026-09-06 03:30:14UNUSEDreview carefully — unique
host_726.dbo.ShiftDaily.PK_ReconcileStatus1CLUSTEREDYY1346250002026-09-11 14:48:112026-09-06 03:30:14USEDKEEP — primary key
host_726.dbo.ShiftDaily.UX_RouteDaily2NONCLUSTEREDY0000never2026-09-06 03:30:14UNUSEDreview carefully — unique
host_726.dbo.QuotaArchive.IX_AssetResult1CLUSTEREDYY0000never2026-09-06 03:30:13UNUSEDKEEP — primary key
host_726.dbo.QuotaArchive.IX_InvoiceAudit2NONCLUSTERED0000never2026-09-06 03:30:13UNUSEDreview, then DROP
host_726.emp.WarehouseMonthly.PK_PricingHistory1CLUSTEREDYY6628455002026-09-11 15:33:082026-09-06 03:30:14USEDKEEP — primary key
host_726.emp.WarehouseMonthly.UX_CustomerDetail2NONCLUSTEREDYY0000never2026-09-06 03:30:14UNUSEDreview carefully — unique
host_726.emp.SettlementLine.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-06 03:30:14UNUSEDKEEP — primary key
host_726.emp.SalesDetail.PK_BillingLog1CLUSTEREDYY01178002026-09-12 01:03:562026-09-06 03:30:14USEDKEEP — primary key
host_726.emp.BatchMonthly.PK_TicketAudit1CLUSTEREDYY0000never2026-09-06 03:30:14UNUSEDKEEP — primary key
host_726.emp.RosterLog.PK_QuotaLog1CLUSTEREDYY2856400142822026-09-10 14:28:252026-09-06 03:30:14USEDKEEP — primary key
host_726.emp.QuotaMonthly.IX_ShipmentEntry15NONCLUSTERED1407900642026-09-11 15:00:132026-09-11 01:00:10USEDkeep — in use
host_726.emp.QuotaMonthly.PK_ReconcileDetail1CLUSTEREDYY36514079642026-09-11 15:00:132026-09-11 01:00:10USEDKEEP — primary key
host_726.emp.OrdersEntry.PK_PolicyHeader1CLUSTEREDYY00062never2026-09-11 01:00:11UNUSEDKEEP — primary key
host_726.emp.PayrollSummary.PK_RouteSummary1CLUSTEREDYY01178002026-09-12 01:03:562026-09-06 03:30:15USEDKEEP — primary key
host_726.emp.SettlementAudit.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-06 03:30:15UNUSEDKEEP — primary key
host_726.emp.InvoiceLog.PK_BatchEntry1CLUSTEREDYY0000never2026-09-06 03:30:16UNUSEDKEEP — 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_CustomerMonthly1CLUSTEREDYY5797002026-09-11 15:33:082026-09-06 03:30:16USEDKEEP — primary key
host_726.emp.RouteHistory.UX_CustomerQueue2NONCLUSTEREDY0000never2026-09-06 03:30:16UNUSEDreview carefully — unique
host_726.emp.CustomerHistory.PK_ShiftDaily1CLUSTEREDYY380002026-09-10 11:53:592026-09-06 03:30:16USEDKEEP — primary key
host_726.emp.ForecastEntry.PK_SettlementLog1CLUSTEREDYY014312002026-09-10 15:52:502026-09-06 03:30:16USEDKEEP — primary key
host_726.emp.ClaimQueue.PK_TerritoryResult1CLUSTEREDYY0000never2026-09-06 03:30:16UNUSEDKEEP — primary key
host_726.emp.PolicyAudit.PK_ContractAudit1CLUSTEREDYY014713002026-09-11 14:48:112026-09-06 03:30:16USEDKEEP — primary key
host_726.emp.ShipmentSummary.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-06 03:30:16UNUSEDKEEP — primary key
host_726.emp.BatchArchive.PK_ClaimHistory1CLUSTEREDYY1469024002026-09-11 14:48:112026-09-06 03:30:16USEDKEEP — primary key
host_726.emp.RosterSnapshot.PK_PolicyStaging1CLUSTEREDYY0000never2026-09-06 03:30:17UNUSEDKEEP — primary key
host_726.emp.MeterResult.IX_LedgerQueue11NONCLUSTERED013340332026-09-11 08:10:032026-09-11 01:00:12USEDkeep — in use
host_726.emp.MeterResult.PK_CustomerResult1CLUSTEREDYY9110217730332026-09-11 15:33:082026-09-11 01:00:12USEDKEEP — primary key
host_726.emp.PayrollHeader.PK_TicketHistory1CLUSTEREDYY673140332026-09-11 14:48:112026-09-11 01:00:13USEDKEEP — primary key
host_726.emp.OrdersAudit.PK_ShipmentHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.RosterResult.PK_MeterAudit1CLUSTEREDYY01264002026-09-12 01:03:562026-09-06 03:30:18USEDKEEP — primary key
host_726.emp.RouteHeader.PK_StaffingQueue1CLUSTEREDYY0000never2026-09-06 03:30:18UNUSEDKEEP — primary key
host_726.emp.MeterAudit.PK_ClaimLog1CLUSTEREDYY674440192026-09-11 15:12:322026-09-11 01:00:13USEDKEEP — primary key
host_726.emp.QuotaStatus.PK_OrdersArchive1CLUSTEREDYY0004never2026-09-06 03:30:18UNUSEDKEEP — primary key
host_726.emp.ShiftLine.IX_PricingAudit14NONCLUSTERED530002026-09-11 15:12:112026-09-06 03:30:19USEDkeep — in use
host_726.emp.ShiftLine.PK_SettlementStatus1CLUSTEREDYY1012065802026-09-12 01:03:562026-09-06 03:30:19USEDKEEP — primary key
host_726.emp.ShiftLine.UX_BookingDaily2NONCLUSTEREDY50002026-08-28 13:07:432026-09-06 03:30:19USEDkeep — in use
host_726.emp.CampaignHeader.PK_BillingQueue1CLUSTEREDYY0000never2026-09-06 03:30:19UNUSEDKEEP — primary key
host_726.emp.MeterStatus.PK_BillingStaging1CLUSTEREDYY0000never2026-09-06 03:30:19UNUSEDKEEP — primary key
host_726.emp.WarehouseStaging.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-06 03:30:19UNUSEDKEEP — primary key
host_726.emp.ForecastHeader.IX_WarehouseResult6NONCLUSTERED65710002026-09-11 15:12:112026-09-06 03:30:19USEDkeep — in use
host_726.emp.ForecastHeader.PK_OrdersAudit1CLUSTEREDYY010657002026-09-11 15:12:112026-09-06 03:30:19USEDKEEP — primary key
host_726.emp.SalesLog.PK_AssetStaging1CLUSTEREDYY0000never2026-09-06 03:30:19UNUSEDKEEP — primary key
host_726.emp.AssetDaily.PK_CustomerMonthly1CLUSTEREDYY012913002026-09-10 14:51:522026-09-06 03:30:19USEDKEEP — primary key
host_726.emp.StaffingDaily.PK_BookingLog1CLUSTEREDYY0000never2026-09-06 03:30:19UNUSEDKEEP — primary key
host_726.emp.ClaimResult.PK_TerritoryQueue1CLUSTEREDYY0000never2026-09-06 03:30:20UNUSEDKEEP — primary key
host_726.emp.CatalogLog.PK_ReconcileHeader1CLUSTEREDYY0000never2026-09-06 03:30:20UNUSEDKEEP — primary key
host_726.emp.ShipmentSnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-06 03:30:20UNUSEDKEEP — primary key
host_726.emp.PricingDaily.IX_ShiftAudit2NONCLUSTERED140002026-09-05 10:46:202026-09-06 03:30:20USEDkeep — in use
host_726.emp.PricingDaily.PK_RouteEntry1CLUSTEREDYY065721302026-09-11 15:12:112026-09-06 03:30:20USEDKEEP — primary key
host_726.emp.PolicyLog.PK_LedgerHistory1CLUSTEREDYY2056731332026-09-11 14:48:112026-09-11 01:00:13USEDKEEP — primary key
host_726.emp.PolicyLog.UX_OrdersSnapshot4NONCLUSTEREDY673400332026-09-11 14:48:112026-09-11 01:00:13USEDkeep — in use
host_726.emp.RouteAudit.PK_ClaimResult1CLUSTEREDYY0004never2026-09-06 03:30:20UNUSEDKEEP — primary key
host_726.emp.PayrollDaily.IX_BillingStaging2NONCLUSTERED600302026-09-05 10:46:06neverUSEDkeep — in use
host_726.emp.PayrollDaily.PK_OrdersSnapshot1CLUSTEREDYY060302026-09-05 10:46:06neverUSEDKEEP — primary key
host_726.emp.MeterHistory.IX_ContractArchive11NONCLUSTERED10577460462026-09-12 00:20:582026-09-11 01:00:14USEDkeep — in use
host_726.emp.MeterHistory.PK_BatchLog1CLUSTEREDYY1790814563937841002026-09-12 00:20:582026-09-11 01:00:14USEDKEEP — primary key
host_726.emp.MeterHistory.UX_BatchLog3NONCLUSTEREDYY00076never2026-09-11 01:00:14UNUSEDreview carefully — unique
host_726.emp.MeterHistory.UX_ForecastHeader23NONCLUSTEREDY218631440452026-09-11 15:00:132026-09-11 01:00:14USEDkeep — in use
host_726.emp.MeterHistory.UX_CustomerSnapshot2NONCLUSTEREDYY520752026-09-03 12:58:062026-09-11 01:00:14USEDkeep — in use
host_726.emp.MeterHistory.UX_QuotaStaging13NONCLUSTEREDY63507320452026-09-11 15:33:082026-09-11 01:00:14USEDkeep — in use
host_726.emp.TerritoryLine.PK_LedgerArchive1CLUSTEREDYY135711503242026-09-12 00:05:042026-09-10 01:00:14USEDKEEP — primary key
host_726.emp.SalesStaging.PK_PolicyDaily1CLUSTEREDYY695210020352026-09-12 00:05:042026-09-06 03:30:21USEDKEEP — primary key
host_726.emp.TerritoryDaily.PK_MeterLog1CLUSTEREDYY0002never2026-09-06 03:30:22UNUSEDKEEP — primary key
host_726.emp.SettlementQueue.IX_PolicyAudit2NONCLUSTERED1102732026-08-20 09:14:322026-09-10 01:00:14USEDkeep — in use
host_726.emp.SettlementQueue.PK_SalesEntry1CLUSTEREDYY14012732026-09-11 15:12:112026-09-10 01:00:14USEDKEEP — primary key
host_726.emp.StaffingMonthly.IX_ReconcileEntry2NONCLUSTERED0180802026-08-19 14:42:092026-09-06 03:30:22USEDkeep — in use
host_726.emp.StaffingMonthly.IX_SalesQueue3NONCLUSTERED800930802026-09-11 11:26:582026-09-06 03:30:22USEDkeep — in use
host_726.emp.StaffingMonthly.PK_CampaignStatus1CLUSTEREDYY4424036686802026-09-11 11:26:582026-09-06 03:30:22USEDKEEP — primary key
host_726.emp.TicketQueue.PK_BatchDaily1CLUSTEREDYY006566622026-09-11 15:12:112026-09-11 01:00:15USEDKEEP — primary key
host_726.emp.TicketQueue.UX_PayrollDaily2NONCLUSTEREDY656600622026-09-11 15:12:112026-09-11 01:00:15USEDkeep — in use
host_726.emp.MeterStatus.PK_CustomerDetail1CLUSTEREDYY00062never2026-09-11 01:00:15UNUSEDKEEP — primary key
host_726.emp.OrdersEntry.PK_TerritoryAudit1CLUSTEREDYY08000002026-09-12 01:03:572026-09-06 03:30:22USEDKEEP — primary key
host_726.emp.InvoiceLog.PK_BillingDetail1CLUSTEREDYY00045never2026-09-11 01:00:16UNUSEDKEEP — primary key
host_726.emp.CampaignHistory.IX_QuotaDetail2NONCLUSTERED6005800132026-09-11 15:09:162026-09-11 01:00:16USEDkeep — in use
host_726.emp.CampaignHistory.PK_AssetHeader1CLUSTEREDYY62206760058132026-09-11 15:09:162026-09-11 01:00:16USEDKEEP — primary key
host_726.emp.ContractArchive.PK_BookingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.TicketLine.PK_CampaignEntry1CLUSTEREDYY544926002026-09-11 15:12:112026-09-06 03:30:23USEDKEEP — primary key
host_726.emp.BatchAudit.IX_PolicyArchive15NONCLUSTERED13302400533952026-09-11 15:24:182026-09-12 01:00:09USEDkeep — in use
host_726.emp.BatchAudit.PK_ForecastSummary1CLUSTEREDYY266324010145970800862026-09-11 15:24:182026-09-12 01:00:09USEDKEEP — primary key
host_726.emp.BatchAudit.UX_LedgerStaging2NONCLUSTEREDY19337610533952026-09-12 00:05:042026-09-12 01:00:10USEDkeep — in use
host_726.emp.ClaimAudit.PK_LedgerDaily1CLUSTEREDYY0002neverneverUNUSEDKEEP — primary key
host_726.emp.ClaimAudit.UX_RouteMonthly2NONCLUSTEREDY02022026-09-10 01:11:51neverUSEDkeep — in use
host_726.emp.PolicyHistory.PK_OrdersDaily1CLUSTEREDYY319113310585562026-09-12 00:05:042026-09-12 01:00:11USEDKEEP — primary key
host_726.emp.BillingEntry.PK_StaffingAudit1CLUSTEREDYY035222318612026-09-12 00:05:042026-09-12 01:00:12USEDKEEP — primary key
host_726.emp.BillingEntry.UX_StaffingLog2NONCLUSTEREDY50701210318612026-09-11 15:12:112026-09-12 01:00:12USEDkeep — in use
host_726.emp.BillingAudit.IX_PolicyHeader8NONCLUSTERED1800318612026-09-11 15:12:112026-09-12 01:00:13USEDkeep — in use
host_726.emp.BillingAudit.PK_PolicyDetail1CLUSTEREDYY0021318612026-09-11 15:12:112026-09-12 01:00:13USEDKEEP — primary key
host_726.emp.BillingAudit.UX_SupplierSnapshot2NONCLUSTEREDY50261470318612026-09-11 15:09:172026-09-12 01:00:13USEDkeep — in use
host_726.emp.ShipmentStaging.PK_TerritoryStatus1CLUSTEREDYY0138051602026-09-11 15:12:112026-09-06 03:31:29USEDKEEP — primary key
host_726.emp.ShipmentStaging.UX_RosterDaily2NONCLUSTEREDY4863175051602026-09-11 15:09:172026-09-06 03:31:29USEDkeep — in use
host_726.emp.SalesLine.PK_CampaignResult1CLUSTEREDYY34713160585462026-09-11 15:24:182026-09-12 01:00:20USEDKEEP — primary key
host_726.emp.LedgerSnapshot.PK_CampaignStatus1CLUSTEREDYY00035never2026-09-11 01:02:03UNUSEDKEEP — primary key
host_726.emp.ReconcileDetail.PK_CampaignQueue1CLUSTEREDYY365820202026-09-11 11:26:582026-09-11 01:02:03USEDKEEP — primary key
host_726.emp.PolicyStaging.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.emp.ReconcileStaging.PK_ContractStaging1CLUSTEREDYY329105002026-09-10 14:31:182026-09-06 03:31:30USEDKEEP — primary key
host_726.emp.ReconcileStaging.UX_OrdersHistory2NONCLUSTEREDY0000never2026-09-06 03:31:30UNUSEDreview carefully — unique
host_726.emp.MeterStatus.PK_ReconcileMonthly1CLUSTEREDYY3740820885482026-09-11 15:33:082026-09-11 01:02:03USEDKEEP — primary key
host_726.emp.MeterStatus.UX_ReconcileAudit7NONCLUSTEREDY2088800182026-09-11 15:33:082026-09-11 01:02:03USEDkeep — in use
host_726.emp.PricingAudit.PK_ReconcileSnapshot1CLUSTEREDYY0006never2026-09-06 03:31:31UNUSEDKEEP — primary key
host_726.emp.OrdersMonthly.IX_QuotaArchive2NONCLUSTEREDY0201062026-09-10 09:39:342026-09-11 01:02:04USEDkeep — in use
host_726.emp.OrdersMonthly.IX_PayrollResult3NONCLUSTEREDY01062026-09-10 09:39:202026-09-10 09:39:08USEDkeep — in use
host_726.emp.OrdersMonthly.IX_TicketSnapshot4NONCLUSTERED4995102252026-09-12 00:20:582026-09-11 01:02:04USEDkeep — in use
host_726.emp.OrdersMonthly.IX_SettlementLine5NONCLUSTERED26202252026-09-10 00:20:032026-09-11 01:02:04USEDkeep — in use
host_726.emp.OrdersMonthly.PK_ShipmentSnapshot1CLUSTEREDYY117832252026-09-10 09:44:562026-09-11 01:02:04USEDKEEP — primary key
host_726.emp.RosterQueue.PK_SettlementHistory1CLUSTEREDYY6241115002026-09-11 15:33:082026-09-06 03:31:31USEDKEEP — primary key
host_726.emp.TicketAudit.IX_LedgerLog2NONCLUSTERED0004never2026-09-06 03:31:31UNUSEDreview, then DROP
host_726.emp.TicketAudit.PK_LedgerStatus1CLUSTEREDYY0004never2026-09-06 03:31:31UNUSEDKEEP — primary key
host_726.emp.InvoiceResult.PK_ShipmentMonthly1CLUSTEREDYY0004never2026-09-06 03:31:31UNUSEDKEEP — primary key
host_726.emp.CustomerLog.IX_PolicyDaily20NONCLUSTERED0770272026-09-11 02:15:022026-09-06 03:31:31USEDkeep — in use
host_726.emp.CustomerLog.IX_PayrollResult21NONCLUSTERED1197514660182026-09-11 15:09:162026-09-06 03:31:32USEDkeep — in use
host_726.emp.CustomerLog.PK_StaffingDaily1CLUSTEREDYY705221018958302026-09-11 15:09:162026-09-06 03:31:31USEDKEEP — primary key
host_726.emp.InvoiceAudit.IX_SettlementResult10NONCLUSTERED404360252026-09-11 14:48:112026-09-06 03:31:32USEDkeep — in use
host_726.emp.InvoiceAudit.PK_QuotaEntry1CLUSTEREDYY03712252026-09-11 02:15:022026-09-06 03:31:32USEDKEEP — primary key
host_726.emp.MeterSummary.PK_AssetEntry1CLUSTEREDYY00025never2026-09-06 03:31:32UNUSEDKEEP — primary key
host_726.emp.AssetSummary.PK_SupplierStaging1CLUSTEREDYY0260262026-09-11 02:15:022026-09-06 03:31:32USEDKEEP — primary key
host_726.emp.SupplierStaging.IX_CampaignResult22NONCLUSTERED012001552026-09-11 02:15:022026-09-11 01:02:04USEDkeep — in use
host_726.emp.SupplierStaging.IX_StaffingSnapshot25NONCLUSTERED3216022401152026-09-11 15:24:182026-09-11 01:02:04USEDkeep — in use
host_726.emp.SupplierStaging.IX_MeterStaging16NONCLUSTERED4930001552026-08-24 13:18:082026-09-11 01:02:04USEDkeep — in use
host_726.emp.SupplierStaging.IX_StaffingEntry24NONCLUSTERED000155never2026-09-11 01:02:04UNUSEDreview, then DROP
host_726.emp.SupplierStaging.PK_PayrollMonthly1CLUSTEREDYY4343170150311552026-09-11 15:24:182026-09-11 01:02:04USEDKEEP — primary key
host_726.emp.CustomerStatus.IX_ReconcileLine10NONCLUSTERED500193201242026-09-11 14:48:112026-09-06 03:31:33USEDkeep — in use
host_726.emp.CustomerStatus.PK_PolicyHistory1CLUSTEREDYY08818841242026-09-11 02:15:022026-09-06 03:31:33USEDKEEP — primary key
host_726.emp.BillingAudit.PK_CustomerEntry1CLUSTEREDYY00099never2026-09-06 03:31:33UNUSEDKEEP — primary key
host_726.emp.PolicyLine.PK_OrdersSummary1CLUSTEREDYY323450312026-09-10 09:48:512026-09-06 03:31:33USEDKEEP — primary key
host_726.emp.RouteStaging.PK_WarehouseLine1CLUSTEREDYY036002026-08-21 15:29:492026-09-06 03:31:33USEDKEEP — primary key
host_726.emp.CampaignMonthly.PK_OrdersArchive1CLUSTEREDYY713960482026-09-10 09:48:512026-09-06 03:31:33USEDKEEP — primary key
host_726.emp.CatalogSnapshot.PK_ClaimHistory1CLUSTEREDYY015002026-08-20 08:06:022026-09-06 03:31:33USEDKEEP — primary key
host_726.emp.BillingDaily.PK_CustomerLine1CLUSTEREDYY09494992026-09-08 10:41:012026-09-06 03:31:34USEDKEEP — primary key
host_726.emp.BillingDaily.UX_LedgerDaily2NONCLUSTEREDY9500992026-09-08 10:41:012026-09-06 03:31:34USEDkeep — in use
host_726.emp.SupplierHistory.PK_WarehouseMonthly1CLUSTEREDYY02601722026-09-11 02:15:022026-09-11 01:02:05USEDKEEP — primary key
host_726.emp.ShipmentMonthly.IX_SupplierEntry12NONCLUSTERED48400627092026-09-11 14:48:112026-09-10 01:01:58USEDkeep — in use
host_726.emp.ShipmentMonthly.IX_InvoiceStaging5NONCLUSTERED1229700627092026-09-11 15:00:142026-09-10 01:01:58USEDkeep — in use
host_726.emp.ShipmentMonthly.PK_BatchDaily1CLUSTEREDYY1011785627192026-09-11 15:00:142026-09-10 01:01:58USEDKEEP — primary key
host_726.emp.AssetDetail.PK_ReconcileResult1CLUSTEREDYY00031364never2026-09-10 01:01:58UNUSEDKEEP — primary key
host_726.emp.AssetSnapshot.IX_ForecastStatus6NONCLUSTERED347864750105052026-09-11 15:09:162026-09-11 01:02:05USEDkeep — in use
host_726.emp.AssetSnapshot.IX_SalesDaily5NONCLUSTERED26105210105052026-09-11 14:48:112026-09-11 01:02:06USEDkeep — in use
host_726.emp.AssetSnapshot.PK_OrdersDetail1CLUSTEREDYY814105052026-09-09 13:35:132026-09-11 01:02:05USEDKEEP — primary key
host_726.emp.PricingStatus.PK_PolicyStatus1CLUSTEREDYY020105042026-08-20 10:38:382026-09-11 01:02:06USEDKEEP — primary key
host_726.emp.TicketSnapshot.IX_BookingHistory14NONCLUSTERED024080105502026-09-11 15:00:142026-09-11 01:02:06USEDkeep — in use
host_726.emp.TicketSnapshot.PK_CampaignQueue1CLUSTEREDYY529041350105502026-09-11 15:24:182026-09-11 01:02:06USEDKEEP — primary key
host_726.emp.ForecastMonthly.PK_CampaignSummary1CLUSTEREDYY0240105452026-09-11 02:15:022026-09-11 01:02:07USEDKEEP — primary key
host_726.emp.PricingStatus.IX_QuotaLog8NONCLUSTERED1424300105362026-09-11 13:48:012026-09-11 01:02:08USEDkeep — in use
host_726.emp.PricingStatus.IX_ClaimEntry6NONCLUSTERED572985740105362026-09-11 15:09:162026-09-11 01:02:08USEDkeep — in use
host_726.emp.PricingStatus.PK_LedgerResult1CLUSTEREDYY2586214243105362026-09-11 15:24:182026-09-11 01:02:07USEDKEEP — primary key
host_726.emp.PayrollHistory.PK_LedgerQueue1CLUSTEREDYY00010535never2026-09-11 01:02:08UNUSEDKEEP — primary key
host_726.emp.QuotaSummary.IX_StaffingQueue10NONCLUSTERED4042170292026-09-11 14:48:112026-09-08 01:02:03USEDkeep — in use
host_726.emp.QuotaSummary.PK_LedgerEntry1CLUSTEREDYY044193292026-09-11 02:15:022026-09-08 01:02:02USEDKEEP — primary key
host_726.emp.PricingQueue.PK_PricingStaging1CLUSTEREDYY00028never2026-09-08 01:02:03UNUSEDKEEP — primary key
host_726.emp.BookingMonthly.IX_ShipmentAudit5NONCLUSTERED925860690592026-09-11 15:24:182026-09-11 01:02:08USEDkeep — in use
host_726.emp.BookingMonthly.PK_WarehouseLog1CLUSTEREDYY00059never2026-09-11 01:02:08UNUSEDKEEP — primary key
host_726.emp.MeterSnapshot.PK_StaffingSummary1CLUSTEREDYY020592026-08-20 10:38:382026-09-11 01:02:09USEDKEEP — primary key
host_726.emp.BatchMonthly.IX_ClaimSummary17NONCLUSTERED02100662026-09-11 02:15:022026-09-11 01:02:09USEDkeep — in use
host_726.emp.BatchMonthly.PK_InvoiceDetail1CLUSTEREDYY857561122185672026-09-11 15:24:182026-09-11 01:02:09USEDKEEP — primary key
host_726.emp.StaffingAudit.PK_ForecastHeader1CLUSTEREDYY0280682026-09-11 02:15:022026-09-11 01:02:10USEDKEEP — primary key
host_726.emp.BatchLog.PK_SalesDetail1CLUSTEREDYY168635901562026-09-11 15:24:182026-09-11 01:02:11USEDKEEP — primary key
host_726.emp.RouteHistory.PK_MeterEntry1CLUSTEREDYY000156never2026-09-11 01:02:11UNUSEDKEEP — primary key
host_726.emp.CampaignResult.IX_ClaimStatus14NONCLUSTERED5561843270108842026-09-11 15:24:182026-09-11 01:02:14USEDkeep — in use
host_726.emp.CampaignResult.IX_ForecastAudit13NONCLUSTERED95600157152026-09-08 10:51:252026-09-11 01:02:14USEDkeep — in use
host_726.emp.CampaignResult.IX_CustomerQueue12NONCLUSTERED864000217682026-09-11 15:09:162026-09-11 01:02:15USEDkeep — in use
host_726.emp.CampaignResult.PK_StaffingArchive1CLUSTEREDYY76168102769461247902026-09-11 15:24:182026-09-11 01:02:14USEDKEEP — primary key
host_726.emp.SalesHeader.IX_BookingSummary2NONCLUSTERED000741never2026-09-11 01:02:17UNUSEDreview, then DROP
host_726.emp.SalesHeader.PK_CatalogQueue1CLUSTEREDYY000741never2026-09-11 01:02:17UNUSEDKEEP — primary key
host_726.emp.PayrollHistory.PK_CampaignStaging1CLUSTEREDYY1342511780182026-09-12 01:03:562026-09-06 03:31:42USEDKEEP — primary key
host_726.emp.TerritoryDaily.PK_RouteArchive1CLUSTEREDYY00018never2026-09-06 03:31:42UNUSEDKEEP — primary key
host_726.emp.CatalogSummary.IX_PricingSnapshot24NONCLUSTERED8108702682026-09-12 00:20:582026-09-11 01:02:16USEDkeep — in use
host_726.emp.CatalogSummary.IX_WarehouseSnapshot19NONCLUSTERED1332168002532026-09-11 15:24:182026-09-11 01:02:16USEDkeep — in use
host_726.emp.CatalogSummary.IX_ReconcileSummary16NONCLUSTERED59387002532026-09-12 00:05:042026-09-11 01:02:16USEDkeep — in use
host_726.emp.CatalogSummary.IX_AssetEntry25NONCLUSTERED284972202682026-09-10 09:10:272026-09-11 01:02:16USEDkeep — in use
host_726.emp.CatalogSummary.PK_ShipmentStaging1CLUSTEREDYY867551280764452932026-09-12 00:20:582026-09-11 01:02:16USEDKEEP — primary key
host_726.emp.CatalogSummary.UX_OrdersAudit5NONCLUSTEREDY3513302532026-09-12 00:20:582026-09-11 01:02:16USEDkeep — in use
host_726.emp.CatalogSummary.UX_LedgerHistory12NONCLUSTEREDYY15129002782026-09-11 13:48:002026-09-11 01:02:16USEDkeep — in use
host_726.emp.TicketMonthly.PK_LedgerAudit1CLUSTEREDYY4463260902026-09-11 15:33:082026-09-10 01:02:07USEDKEEP — primary key
host_726.emp.BillingQueue.IX_AssetDetail11NONCLUSTERED04802842026-09-11 01:08:352026-09-11 01:02:16USEDkeep — in use
host_726.emp.BillingQueue.IX_ContractSummary8NONCLUSTERED45574002842026-09-12 00:20:582026-09-11 01:02:16USEDkeep — in use
host_726.emp.BillingQueue.PK_ShipmentEntry1CLUSTEREDYY02523455502842026-09-12 00:20:582026-09-11 01:02:16USEDKEEP — primary key
host_726.emp.CampaignResult.IX_SupplierLine10NONCLUSTERED285002762026-09-10 09:44:292026-09-11 01:02:17USEDkeep — in use
host_726.emp.CampaignResult.PK_CustomerLine1CLUSTEREDYY12912852762026-09-10 09:44:292026-09-11 01:02:17USEDKEEP — primary key
host_726.org.SettlementSnapshot.PK_org.SettlementSnapshot1CLUSTEREDYY026002026-09-10 09:35:252026-09-06 03:31:44USEDKEEP — primary key
host_726.org.SettlementSnapshot.UX_BillingLine2NONCLUSTEREDY0000never2026-09-06 03:31:44UNUSEDreview carefully — unique
host_726.org.PolicySummary.IX_AssetEntry18NONCLUSTERED2918613180332026-09-11 15:11:362026-09-06 03:31:44USEDkeep — in use
host_726.org.PolicySummary.PK_QuotaAudit1CLUSTEREDYY1478973098129379762026-09-11 15:33:082026-09-06 03:31:44USEDKEEP — primary key
host_726.org.PolicySummary.UX_ForecastHistory2NONCLUSTEREDYY28010332026-09-11 15:11:512026-09-06 03:31:44USEDkeep — in use
host_726.org.BatchMonthly.PK_WarehouseSummary1CLUSTEREDYY744580462026-09-10 11:49:482026-09-06 03:31:45USEDKEEP — primary key
host_726.org.BatchMonthly.UX_SalesSnapshot2NONCLUSTEREDYY00046never2026-09-06 03:31:45UNUSEDreview carefully — unique
host_726.org.CampaignQueue.PK_RosterDaily1CLUSTEREDYY010462026-09-03 08:37:262026-09-06 03:31:45USEDKEEP — primary key
host_726.org.TicketLog.PK_WarehouseDetail1CLUSTEREDYY60581552026-09-10 11:53:592026-09-06 03:31:45USEDKEEP — primary key
host_726.org.TicketLog.UX_SalesMonthly4NONCLUSTEREDY100552026-09-10 11:53:592026-09-11 01:02:17USEDkeep — in use
host_726.org.BatchDaily.PK_QuotaStaging1CLUSTEREDYY560351054359312026-09-12 01:04:102026-09-06 03:31:45USEDKEEP — primary key
host_726.org.BatchDaily.UX_PricingResult8NONCLUSTEREDYY094012026-09-10 14:32:392026-09-11 01:02:17USEDkeep — in use
host_726.org.ShipmentAudit.PK_ForecastHeader1CLUSTEREDYY17635764231380142026-09-12 01:04:002026-09-09 01:01:56USEDKEEP — primary key
host_726.org.ShipmentAudit.UX_BatchArchive2NONCLUSTEREDY422591855770142026-09-12 01:04:002026-09-10 01:02:08USEDkeep — in use
host_726.org.WarehouseStaging.PK_MeterHistory1CLUSTEREDYY00010never2026-09-10 01:02:09UNUSEDKEEP — primary key
host_726.org.BookingResult.PK_BillingQueue1CLUSTEREDYY0000never2026-09-06 03:31:46UNUSEDKEEP — primary key
host_726.org.InvoiceQueue.PK_TicketEntry1CLUSTEREDYY4843012026-09-10 11:44:232026-09-06 03:31:46USEDKEEP — primary key
host_726.org.PricingStatus.PK_TerritoryStatus1CLUSTEREDYY0001never2026-09-11 01:02:18UNUSEDKEEP — primary key
host_726.org.CatalogHeader.PK_ShiftStatus1CLUSTEREDYY166644010792026-09-11 01:07:152026-09-06 03:31:46USEDKEEP — primary key
host_726.org.PolicySummary.PK_CatalogQueue1CLUSTEREDYY00077never2026-09-10 01:02:09UNUSEDKEEP — primary key
host_726.org.CatalogAudit.PK_AssetStatus1CLUSTEREDYY0001never2026-09-11 01:02:18UNUSEDKEEP — primary key
host_726.org.OrdersSummary.PK_StaffingAudit1CLUSTEREDYY0550192026-09-11 15:12:322026-09-10 01:02:09USEDKEEP — primary key
host_726.org.ContractResult.PK_PolicyLine1CLUSTEREDYY00019never2026-09-10 01:02:09UNUSEDKEEP — primary key
host_726.org.SupplierHistory.IX_ShipmentSummary2NONCLUSTERED0000never2026-09-06 03:31:46UNUSEDreview, then DROP
host_726.org.SupplierHistory.PK_CustomerDetail1CLUSTEREDYY0233002026-09-10 11:54:242026-09-06 03:31:46USEDKEEP — 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-06 03:31:46UNUSEDreview, then DROP
host_726.org.BillingHeader.PK_InvoiceMonthly1CLUSTEREDYY063002026-09-10 11:54:242026-09-06 03:31:46USEDKEEP — primary key
host_726.org.ShipmentSummary.IX_StaffingResult2NONCLUSTERED0000never2026-09-06 03:31:46UNUSEDreview, then DROP
host_726.org.ShipmentSummary.PK_ClaimDetail1CLUSTEREDYY063002026-09-10 11:54:242026-09-06 03:31:46USEDKEEP — primary key
host_726.org.SalesStatus.IX_ClaimHeader2NONCLUSTEREDY660002026-09-10 11:54:242026-09-06 03:31:46USEDkeep — in use
host_726.org.SalesStatus.PK_CampaignSnapshot1CLUSTEREDYY006602026-09-10 11:54:242026-09-06 03:31:46USEDKEEP — primary key
host_726.org.PolicyResult.PK_ForecastStaging1CLUSTEREDYY648180676002026-09-11 15:09:162026-09-06 03:31:46USEDKEEP — primary key
host_726.org.AssetSummary.PK_TicketStaging1CLUSTEREDYY9571194002026-09-11 15:21:072026-09-06 03:31:46USEDKEEP — primary key
host_726.org.AssetSummary.UX_ShipmentSummary4NONCLUSTEREDY0000never2026-09-06 03:31:46UNUSEDreview carefully — unique
host_726.org.ShipmentQueue.PK_InvoiceStaging1CLUSTEREDYY217350279042026-09-11 15:24:182026-09-06 03:31:46USEDKEEP — primary key
host_726.org.PolicyEntry.PK_SettlementSnapshot1CLUSTEREDYY1542110132026-09-12 00:20:582026-09-06 03:31:47USEDKEEP — primary key
host_726.org.PolicyEntry.UX_ShiftSnapshot9NONCLUSTEREDYY00013never2026-09-11 01:02:18UNUSEDreview carefully — unique
host_726.org.MeterAudit.IX_WarehouseQueue3NONCLUSTERED940092026-09-12 00:20:582026-09-11 01:02:18USEDkeep — in use
host_726.org.MeterAudit.PK_BillingDetail1CLUSTEREDYY3400132026-09-10 09:35:182026-09-11 01:02:18USEDKEEP — primary key
host_726.org.BillingHeader.PK_ContractStaging1CLUSTEREDYY0000never2026-09-06 03:31:47UNUSEDKEEP — primary key
host_726.org.TicketSnapshot.PK_ForecastSnapshot1CLUSTEREDYY0000never2026-09-06 03:31:47UNUSEDKEEP — primary key
host_726.org.CustomerStaging.PK_CustomerHeader1CLUSTEREDYY00013never2026-09-11 01:02:18UNUSEDKEEP — primary key
host_726.org.KPI.PK_ShiftLine1CLUSTEREDYY0000never2026-09-06 03:31:47UNUSEDKEEP — primary key
host_726.org.KPI.UX_ShiftHeader8NONCLUSTEREDYY0000never2026-09-06 03:31:47UNUSEDreview carefully — unique
host_726.org.StaffingArchive.PK_SettlementResult1CLUSTEREDYY026002026-09-10 09:35:252026-09-06 03:31:47USEDKEEP — primary key
host_726.org.CustomerEntry.PK_RouteSummary1CLUSTEREDYY0000never2026-09-06 03:31:47UNUSEDKEEP — primary key
host_726.org.PricingDaily.PK_CampaignArchive1CLUSTEREDYY0000never2026-09-06 03:31:47UNUSEDKEEP — primary key
host_726.org.PricingDaily.UX_BillingArchive2NONCLUSTEREDY0000never2026-09-06 03:31:47UNUSEDreview carefully — unique
host_726.org.TicketLine.PK_SupplierMonthly1CLUSTEREDYY0000never2026-09-06 03:31:47UNUSEDKEEP — primary key
host_726.org.BillingArchive.PK_MeterSummary1CLUSTEREDYY0000never2026-09-06 03:31:47UNUSEDKEEP — primary key
host_726.org.MeterEntry.PK_SupplierLog1CLUSTEREDYY0000never2026-09-06 03:31:47UNUSEDKEEP — primary key
host_726.org.ReconcileAudit.PK_PolicyLog1CLUSTEREDYY130356062026-09-10 16:09:552026-09-06 03:31:47USEDKEEP — primary key
host_726.org.ReconcileAudit.UQ_ShipmentResult2NONCLUSTEREDYY60062026-08-29 10:32:072026-09-06 03:31:47USEDkeep — in use
host_726.org.StaffingAudit.PK_RosterArchive1CLUSTEREDYY00013never2026-09-06 03:31:48UNUSEDKEEP — primary key
host_726.org.ShiftResult.PK_AssetAudit1CLUSTEREDYY16319228269072026-09-12 00:05:042026-09-06 03:31:48USEDKEEP — primary key
host_726.org.BatchMonthly.PK_SalesLine1CLUSTEREDYY3372062026-09-10 10:18:472026-09-06 03:31:48USEDKEEP — primary key
host_726.org.RosterMonthly.IX_AssetDetail2NONCLUSTERED0008never2026-09-06 03:31:48UNUSEDreview, then DROP
host_726.org.RosterMonthly.PK_ForecastDaily1CLUSTEREDYY4257082026-09-10 00:05:042026-09-06 03:31:48USEDKEEP — primary key
host_726.org.InvoiceStaging.IX_AssetAudit2NONCLUSTERED0008never2026-09-06 03:31:48UNUSEDreview, then DROP
host_726.org.InvoiceStaging.PK_CustomerMonthly1CLUSTEREDYY0008never2026-09-06 03:31:48UNUSEDKEEP — primary key
host_726.org.StaffingAudit.PK_AssetLog1CLUSTEREDYY0006never2026-09-06 03:31:48UNUSEDKEEP — primary key
host_726.org.Level.PK_ShiftStaging1CLUSTEREDYY286681571202026-09-10 10:18:022026-09-06 03:31:48USEDKEEP — primary key
host_726.org.Level.UX_SettlementHistory2NONCLUSTEREDYY2510002026-09-10 09:35:252026-09-06 03:31:48USEDkeep — in use
host_726.org.ContractHistory.PK_RouteArchive1CLUSTEREDYY0000never2026-09-06 03:31:48UNUSEDKEEP — primary key
host_726.org.QuotaEntry.IX_AssetHistory2NONCLUSTERED0000never2026-09-06 03:31:48UNUSEDreview, then DROP
host_726.org.QuotaEntry.PK_LedgerQueue1CLUSTEREDYY028440002026-09-11 15:09:172026-09-06 03:31:48USEDKEEP — primary key
host_726.org.ClaimQueue.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-06 03:31:48UNUSEDKEEP — primary key
host_726.org.SupplierLine.PK_InvoiceStatus1CLUSTEREDYY1995289002026-09-10 14:28:252026-09-06 03:31:49USEDKEEP — primary key
host_726.org.InvoiceHistory.PK_ContractDaily1CLUSTEREDYY0000never2026-09-06 03:31:49UNUSEDKEEP — primary key
host_726.org.AssetHeader.IX_PayrollAudit2NONCLUSTERED1995280002026-09-10 14:28:252026-09-06 03:31:49USEDkeep — in use
host_726.org.AssetHeader.PK_LedgerResult1CLUSTEREDYY180002026-09-08 15:18:312026-09-06 03:31:49USEDKEEP — primary key
host_726.org.TerritoryStatus.PK_PayrollLine1CLUSTEREDYY0000never2026-09-06 03:31:49UNUSEDKEEP — primary key
host_726.org.RosterLine.PK_BillingDaily1CLUSTEREDYY0000never2026-09-06 03:31:49UNUSEDKEEP — primary key
host_726.org.ForecastArchive.PK_CampaignHeader1CLUSTEREDYY043002026-09-05 16:14:362026-09-06 03:31:49USEDKEEP — primary key
host_726.org.PolicySummary.PK_WarehouseSnapshot1CLUSTEREDYY049874002026-09-10 14:28:252026-09-06 03:31:49USEDKEEP — primary key
host_726.org.ClaimMonthly.PK_RouteArchive1CLUSTEREDYY0000never2026-09-06 03:31:49UNUSEDKEEP — primary key
host_726.org.OrdersEntry.PK_MeterDaily1CLUSTEREDYY4110580112026-09-10 14:28:252026-09-09 01:01:56USEDKEEP — primary key
host_726.org.LedgerStaging.PK_BatchLine1CLUSTEREDYY00011never2026-09-09 01:01:56UNUSEDKEEP — primary key
host_726.org.Position.PK_PolicySummary1CLUSTEREDYY1006087100202026-09-12 00:20:582026-09-06 03:31:49USEDKEEP — primary key
host_726.org.Position.UX_MeterArchive2NONCLUSTEREDYY00020never2026-09-11 01:02:18UNUSEDreview carefully — unique
host_726.org.CampaignQueue.PK_BillingArchive1CLUSTEREDYY113555217262026-09-11 15:33:082026-09-06 03:31:49USEDKEEP — primary key
host_726.org.CampaignQueue.UX_TicketDaily2NONCLUSTEREDY2917833062026-09-10 16:17:402026-09-06 03:31:49USEDkeep — in use
host_726.org.MeterResult.PK_CatalogStaging1CLUSTEREDYY00012never2026-09-06 03:31:49UNUSEDKEEP — primary key
host_726.org.QuotaLine.PK_AssetAudit1CLUSTEREDYY16790162026-09-10 09:35:252026-09-11 01:02:18USEDKEEP — primary key
host_726.org.QuotaLine.UX_PricingAudit2NONCLUSTEREDYY00016never2026-09-11 01:02:18UNUSEDreview carefully — unique
host_726.org.PayrollLog.PK_PayrollAudit1CLUSTEREDYY0000never2026-09-06 03:31:50UNUSEDKEEP — primary key
host_726.org.PayrollLog.UX_PayrollDetail2NONCLUSTEREDY0000never2026-09-06 03:31:50UNUSEDreview carefully — unique
host_726.org.LedgerDaily.PK_ContractHeader1CLUSTEREDYY00020never2026-09-11 01:02:18UNUSEDKEEP — primary key
host_726.org.PricingArchive.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-06 03:31:50UNUSEDKEEP — primary key
host_726.org.PricingArchive.UX_InvoiceAudit2NONCLUSTEREDY0000never2026-09-06 03:31:50UNUSEDreview carefully — unique
host_726.org.ForecastAudit.PK_WarehouseSnapshot1CLUSTEREDYY079002026-09-10 14:31:182026-09-06 03:31:50USEDKEEP — primary key
host_726.org.ForecastAudit.UX_ClaimArchive2NONCLUSTEREDY0000never2026-09-06 03:31:50UNUSEDreview carefully — unique
host_726.org.PayrollLine.PK_OrdersHistory1CLUSTEREDYY30479002026-09-11 15:12:112026-09-06 03:31:50USEDKEEP — primary key
host_726.org.PayrollLine.UX_ShiftLog2NONCLUSTEREDY0000never2026-09-06 03:31:50UNUSEDreview carefully — unique
host_726.org.BookingStaging.PK_AssetResult1CLUSTEREDYY103354129210922026-09-11 15:24:182026-09-06 03:31:50USEDKEEP — primary key
host_726.org.ReconcileLine.PK_CustomerLog1CLUSTEREDYY00035never2026-09-09 01:01:57UNUSEDKEEP — primary key
host_726.org.ShiftStaging.PK_BillingHistory1CLUSTEREDYY029002026-08-20 10:19:462026-09-06 03:31:50USEDKEEP — primary key
host_726.org.ShiftStaging.UQ_PolicyAudit2NONCLUSTEREDY0000never2026-09-06 03:31:50UNUSEDreview carefully — unique
host_726.org.CustomerLine.IX_ForecastLine3NONCLUSTERED290002026-08-20 10:19:462026-09-06 03:31:50USEDkeep — in use
host_726.org.CustomerLine.PK_LedgerEntry1CLUSTEREDYY0308002026-09-10 11:54:242026-09-06 03:31:50USEDKEEP — primary key
host_726.org.CustomerLine.UQ_PayrollLog2NONCLUSTEREDY0000never2026-09-06 03:31:50UNUSEDreview carefully — unique
host_726.org.InvoiceMonthly.PK_WarehouseQueue1CLUSTEREDYY0000never2026-09-06 03:31:50UNUSEDKEEP — primary key
host_726.org.InvoiceMonthly.UQ_MeterAudit2NONCLUSTEREDY029002026-08-20 10:19:462026-09-06 03:31:50USEDkeep — in use
host_726.org.QuotaStaging.PK_ShiftStaging1CLUSTEREDYY03012302026-09-10 11:54:242026-09-06 03:31:51USEDKEEP — primary key
host_726.org.QuotaStaging.UQ_ShiftMonthly2NONCLUSTEREDY1230002026-09-10 11:54:242026-09-06 03:31:51USEDkeep — in use
host_726.org.BatchMonthly.PK_WarehouseHeader1CLUSTEREDYY261025221474632026-09-03 11:34:542026-09-06 03:31:51USEDKEEP — primary key
host_726.org.BatchMonthly.UQ_LedgerStaging2NONCLUSTEREDY2147004632026-08-20 10:19:462026-09-06 03:31:51USEDkeep — in use
host_726.org.ClaimHeader.PK_ClaimArchive1CLUSTEREDYY0002147never2026-09-06 03:31:51UNUSEDKEEP — primary key
host_726.org.SupplierResult.PK_ForecastQueue1CLUSTEREDYY475807002026-09-11 15:33:082026-09-06 03:31:51USEDKEEP — primary key
host_726.org.RouteSummary.PK_RosterAudit1CLUSTEREDYY0000never2026-09-06 03:31:51UNUSEDKEEP — primary key
host_726.org.RouteSummary.UX_SupplierSummary2NONCLUSTEREDYY0000never2026-09-06 03:31:51COLDreview carefully — unique
host_726.org.ClaimDetail.PK_RouteMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.org.ShiftResult.PK_ForecastEntry1CLUSTEREDYY527774376599502026-09-11 15:24:182026-09-11 01:02:19USEDKEEP — primary key
host_726.org.ShiftResult.UX_LedgerStaging7NONCLUSTEREDY37675009502026-09-11 15:24:182026-09-11 01:02:19USEDkeep — in use
host_726.org.QuotaResult.PK_CampaignDaily1CLUSTEREDYY161685657442026-09-11 01:07:152026-09-11 01:02:19USEDKEEP — primary key
host_726.org.QuotaResult.UX_BatchDaily2NONCLUSTEREDY40042026-09-10 14:31:052026-09-11 01:02:19USEDkeep — in use
host_726.org.QuotaDetail.PK_WarehouseMonthly1CLUSTEREDYY11408380102026-09-11 15:09:162026-09-11 01:02:19USEDKEEP — primary key
host_726.org.BookingLog.PK_MeterStaging1CLUSTEREDYY00010never2026-09-11 01:02:19UNUSEDKEEP — primary key
host_726.org.SettlementAudit.PK_InvoiceSnapshot1CLUSTEREDYY0003never2026-09-11 01:02:19UNUSEDKEEP — primary key
host_726.oth.QuotaSummary.PK_QuotaDetail1CLUSTEREDYY106002026-09-10 12:56:252026-09-06 03:31:52USEDKEEP — primary key
host_726.oth.InvoiceStatus.PK_ShiftQueue1CLUSTEREDYY20106002026-09-11 23:59:592026-09-06 03:31:52USEDKEEP — primary key
host_726.oth.SupplierLine.PK_QuotaDetail1CLUSTEREDYY04002026-08-21 10:16:412026-09-06 03:31:52USEDKEEP — primary key
host_726.oth.SupplierLine.UX_InvoiceHeader2NONCLUSTEREDY0000never2026-09-06 03:31:52UNUSEDreview carefully — unique
host_726.oth.StaffingArchive.IX_InvoiceStaging2NONCLUSTERED0000never2026-09-06 03:31:52UNUSEDreview, then DROP
host_726.oth.StaffingArchive.PK_PricingAudit1CLUSTEREDYY0000never2026-09-06 03:31:52UNUSEDKEEP — primary key
host_726.oth.StaffingArchive.UQ_SalesAudit3NONCLUSTEREDY4116002026-09-10 12:56:252026-09-06 03:31:52USEDkeep — in use
host_726.oth.CustomerQueue.IX_WarehouseResult2NONCLUSTERED376002026-09-10 12:56:252026-09-06 03:31:52USEDkeep — in use
host_726.oth.CustomerQueue.PK_TerritoryResult1CLUSTEREDYY092202026-09-04 10:13:192026-09-06 03:31:52USEDKEEP — 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_QuotaLine1CLUSTEREDYY029002026-08-21 08:46:082026-09-06 03:31:52USEDKEEP — primary key
host_726.sal.ClaimArchive.IX_RouteDetail2NONCLUSTERED0000never2026-09-06 03:31:52UNUSEDreview, then DROP
host_726.sal.ClaimArchive.PK_LedgerHeader1CLUSTEREDYY0000never2026-09-06 03:31:52UNUSEDKEEP — primary key
host_726.sal.QuotaLine.PK_ContractArchive1CLUSTEREDYY61100439032026-09-12 01:04:002026-09-06 03:31:53USEDKEEP — primary key
host_726.sal.SalesStatus.PK_ShiftMonthly1CLUSTEREDYY118813700412026-09-12 01:03:572026-09-12 01:00:23USEDKEEP — primary key
host_726.sal.SettlementQueue.PK_StaffingSnapshot1CLUSTEREDYY02300044052026-09-12 01:03:572026-09-12 01:00:23USEDKEEP — primary key
host_726.sal.MeterHistory.PK_LedgerSnapshot1CLUSTEREDYY050044052026-09-11 15:12:322026-09-12 01:00:24USEDKEEP — primary key
host_726.sal.ShipmentAudit.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
host_726.sal.RouteResult.PK_OrdersAudit1CLUSTEREDYY085002026-09-11 15:33:082026-09-06 03:31:54USEDKEEP — primary key
host_726.sal.RouteResult.UX_ContractEntry2NONCLUSTEREDY0000never2026-09-06 03:31:54UNUSEDreview carefully — unique
host_726.sal.WarehouseDaily.PK_SettlementDetail1CLUSTEREDYY8894859122026-09-11 15:33:082026-09-10 01:02:11USEDKEEP — primary key
host_726.sal.WarehouseDaily.UX_BookingAudit2NONCLUSTEREDY1200122026-09-09 15:46:592026-09-11 01:02:20USEDkeep — in use
host_726.sal.InvoiceLog.PK_MeterAudit1CLUSTEREDYY75880752026-09-11 15:33:082026-09-10 01:02:13USEDKEEP — primary key
host_726.sal.PolicySnapshot.PK_ReconcileQueue1CLUSTEREDYY040752026-08-20 10:38:342026-09-11 01:02:20USEDKEEP — primary key
host_726.sal.SettlementStatus.PK_ReconcileResult1CLUSTEREDYY612841556232026-09-11 15:33:082026-09-11 01:02:20USEDKEEP — primary key
host_726.sal.SettlementStatus.UX_StaffingMonthly2NONCLUSTEREDY155006232026-09-11 15:33:022026-09-11 01:02:20USEDkeep — in use
host_726.sal.ReconcileHistory.PK_PayrollHeader1CLUSTEREDYY42560852026-09-11 14:50:172026-09-11 01:02:20USEDKEEP — primary key
host_726.sal.ReconcileHistory.UX_TicketQueue2NONCLUSTEREDY00085never2026-09-11 01:02:20UNUSEDreview carefully — unique
host_726.sal.InvoiceEntry.PK_RouteQueue1CLUSTEREDYY00085never2026-09-11 01:02:20UNUSEDKEEP — primary key
host_726.sal.BillingQueue.PK_ReconcileHistory1CLUSTEREDYY0206232026-08-20 10:38:342026-09-11 01:02:20USEDKEEP — primary key
host_726.sal.RosterDetail.PK_BookingStaging1CLUSTEREDYY010122026-08-20 10:38:342026-09-11 01:02:21USEDKEEP — primary key
host_726.sal.RosterQueue.PK_ShiftQueue1CLUSTEREDYY0115002026-09-11 15:33:082026-09-06 03:31:55USEDKEEP — primary key
host_726.sal.RosterQueue.UX_RosterArchive2NONCLUSTEREDY0000never2026-09-06 03:31:55UNUSEDreview carefully — unique
host_726.sal.WarehouseHeader.PK_RouteEntry1CLUSTEREDYY0343002026-09-12 00:05:042026-09-06 03:31:55USEDKEEP — primary key
host_726.sal.SupplierArchive.PK_SupplierStaging1CLUSTEREDYY01178002026-09-12 01:03:572026-09-06 03:31:55USEDKEEP — primary key
host_726.sal.RosterQueue.PK_PolicyLog1CLUSTEREDYY09002026-09-10 12:45:232026-09-06 03:31:55USEDKEEP — primary key
host_726.sal.CustomerSnapshot.PK_RosterEntry1CLUSTEREDYY01179002026-09-12 01:03:572026-09-06 03:31:55USEDKEEP — primary key
host_726.sal.LedgerStatus.PK_WarehouseStaging1CLUSTEREDYY913002026-09-10 12:45:312026-09-06 03:31:55USEDKEEP — primary key
host_726.sal.BookingLine.PK_PricingAudit1CLUSTEREDYY01002026-09-10 12:45:312026-09-06 03:31:55USEDKEEP — primary key
host_726.sal.PricingLine.PK_BatchLine1CLUSTEREDYY0000never2026-09-06 03:31:55UNUSEDKEEP — primary key
host_726.sal.WarehouseStaging.PK_SettlementHistory1CLUSTEREDYY01002026-09-10 12:45:312026-09-06 03:31:55USEDKEEP — primary key
host_726.sal.StaffingArchive.PK_CatalogLine1CLUSTEREDYY0000never2026-09-06 03:31:55UNUSEDKEEP — primary key
host_726.sal.WarehouseSummary.PK_RosterArchive1CLUSTEREDYY0000never2026-09-06 03:31:55UNUSEDKEEP — primary key
host_726.schedule.CustomerDetail.PK_CatalogStaging1CLUSTEREDYY01633516302026-09-11 15:09:162026-09-06 03:31:55USEDKEEP — primary key
host_726.schedule.CustomerDetail.UQ_BillingSnapshot3NONCLUSTEREDY34736357002026-09-11 15:09:162026-09-06 03:31:55USEDkeep — in use
host_726.schedule.CustomerDetail.UQ_CampaignResult2NONCLUSTEREDY43015953002026-09-11 15:09:162026-09-06 03:31:55USEDkeep — in use
host_726.schedule.InvoiceHistory.IX_StaffingHeader3NONCLUSTERED0000never2026-09-06 03:31:55UNUSEDreview, then DROP
host_726.schedule.InvoiceHistory.PK_ContractLog1CLUSTEREDYY0000never2026-09-06 03:31:55UNUSEDKEEP — primary key
host_726.schedule.InvoiceHistory.UQ_LedgerResult2NONCLUSTEREDY0000never2026-09-06 03:31:55UNUSEDreview carefully — unique
host_726.schedule.MeterStaging.PK_SettlementMonthly1CLUSTEREDYY6916038055752026-09-11 15:09:172026-09-06 03:31:55USEDKEEP — primary key
host_726.schedule.SettlementLine.PK_CampaignStatus1CLUSTEREDYY7030043801572026-09-11 15:09:162026-09-06 03:31:55USEDKEEP — primary key
host_726.schedule.TicketEntry.PK_CampaignDaily1CLUSTEREDYY2920501562026-09-11 01:07:152026-09-06 03:31:55USEDKEEP — primary key
host_726.schedule.QuotaSummary.PK_LedgerStatus1CLUSTEREDYY144896108600512026-09-12 01:04:112026-09-06 03:31:56USEDKEEP — primary key
host_726.schedule.ShipmentLog.PK_SalesEntry1CLUSTEREDYY4623400111502026-09-11 15:09:162026-09-11 01:07:17USEDKEEP — primary key
host_726.schedule.PricingResult.PK_CampaignDaily1CLUSTEREDYY8141272650792026-09-11 15:09:162026-09-06 03:31:56USEDKEEP — primary key
host_726.schedule.SupplierSnapshot.IX_BillingHeader3NONCLUSTERED3998644201656222026-09-11 15:09:162026-09-12 01:00:24USEDkeep — in use
host_726.schedule.SupplierSnapshot.PK_AssetStatus1CLUSTEREDYY27369324545794942028462026-09-12 01:04:112026-09-12 01:00:24USEDKEEP — primary key
host_726.schedule.SupplierSnapshot.IX_ContractLog2NONCLUSTEREDY2198376780701782026-09-11 09:07:232026-09-12 01:00:25USEDkeep — in use
host_726.schedule.BatchDetail.PK_AssetDetail1CLUSTEREDYY1072019064342026-08-20 08:06:142026-09-06 03:31:57USEDKEEP — primary key
host_726.schedule.RosterSummary.IX_BatchDetail2NONCLUSTERED452479401272692026-09-11 15:09:162026-09-12 01:01:53USEDkeep — in use
host_726.schedule.RosterSummary.IX_ClaimHeader3NONCLUSTERED89520195901272692026-09-11 15:09:162026-09-12 01:01:53USEDkeep — in use
host_726.schedule.RosterSummary.PK_CustomerAudit1CLUSTEREDYY2154919328213392545342026-09-11 15:09:172026-09-12 01:01:53USEDKEEP — primary key
host_726.schedule.BillingDetail.IX_TicketHeader2NONCLUSTERED77082748004803822026-09-11 15:09:172026-09-12 01:01:51USEDkeep — in use
host_726.schedule.BillingDetail.PK_BillingLog1CLUSTEREDYY335749875501595758332026-09-11 15:09:172026-09-12 01:00:28USEDKEEP — primary key
host_726.schedule.PolicyStatus.IX_ForecastAudit2NONCLUSTERED3446160010530072026-09-11 15:09:172026-09-11 01:08:03USEDkeep — in use
host_726.schedule.PolicyStatus.IX_SupplierLine3NONCLUSTERED12338688010530072026-09-12 01:04:152026-09-11 01:08:03USEDkeep — in use
host_726.schedule.PolicyStatus.PK_PricingDaily1CLUSTEREDYY10530659788576810530072026-09-11 15:09:172026-09-11 01:08:02USEDKEEP — primary key
host_726.schedule.PolicyLine.IX_TerritorySnapshot2NONCLUSTERED796263241740960692026-09-11 15:09:172026-09-11 01:02:27USEDkeep — in use
host_726.schedule.PolicyLine.PK_BookingAudit1CLUSTEREDYY53825223307761915142026-09-11 15:09:172026-09-11 01:02:27USEDKEEP — primary key
host_726.schedule.AssetResult.IX_BillingResult2NONCLUSTERED6609200660922026-09-12 01:04:11neverUSEDkeep — in use
host_726.schedule.AssetResult.PK_TicketQueue1CLUSTEREDYY00066092neverneverUNUSEDKEEP — primary key
host_726.schedule.InvoiceAudit.IX_StaffingQueue2NONCLUSTERED1057567803817822026-09-11 15:09:172026-09-11 01:02:27USEDkeep — in use
host_726.schedule.InvoiceAudit.PK_LedgerMonthly1CLUSTEREDYY5351801611337904115142026-09-11 15:09:172026-09-11 01:02:27USEDKEEP — primary key
host_726.schedule.SettlementLog.IX_TicketLine2NONCLUSTERED8219890012661232026-09-11 15:09:172026-09-11 01:07:48USEDkeep — in use
host_726.schedule.SettlementLog.IX_PolicyLine3NONCLUSTERED1586388012661232026-09-11 15:09:172026-09-11 01:07:48USEDkeep — in use
host_726.schedule.SettlementLog.PK_CatalogMonthly1CLUSTEREDYY160501603747313542512026-09-11 15:09:172026-09-11 01:07:48USEDKEEP — 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_TicketStatus4NONCLUSTERED0282601403602026-09-07 15:26:302026-09-11 01:06:03USEDkeep — in use
host_726.schedule.ShiftHeader.IX_ShipmentLine3NONCLUSTERED3829962801403602026-09-11 15:09:172026-09-11 01:06:03USEDkeep — in use
host_726.schedule.ShiftHeader.PK_OrdersArchive1CLUSTEREDYY63969433741325982405832026-09-12 01:04:152026-09-11 01:06:03USEDKEEP — primary key
host_726.schedule.ShiftHeader.IX_BookingStatus2NONCLUSTEREDY8066269201403602026-09-11 01:08:322026-09-11 01:06:03USEDkeep — in use
host_726.schedule.PolicyLine.PK_RouteQueue1CLUSTEREDYY21436558414601403552026-09-11 15:09:172026-09-11 01:02:36USEDKEEP — primary key
host_726.schedule.PolicyLine.UX_TerritoryHistory2NONCLUSTEREDYY391800701932026-08-29 09:26:552026-09-11 01:02:36USEDkeep — in use
host_726.schedule.SalesDaily.IX_ForecastHistory2NONCLUSTERED10022026-08-18 14:16:322026-09-06 04:25:51USEDkeep — in use
host_726.schedule.SalesDaily.IX_QuotaSummary3NONCLUSTERED01022026-08-18 14:16:372026-09-06 04:25:51USEDkeep — in use
host_726.schedule.SalesDaily.PK_ClaimResult1CLUSTEREDYY05022026-08-18 14:22:132026-09-06 04:25:51USEDKEEP — primary key
host_726.schedule.RosterHistory.IX_AssetSummary2NONCLUSTERED3020127670701942026-09-11 15:09:172026-09-11 01:02:36USEDkeep — in use
host_726.schedule.RosterHistory.PK_WarehouseLine1CLUSTEREDYY1644120478701942026-09-11 15:09:172026-09-11 01:02:36USEDKEEP — primary key
host_726.schedule.ContractStaging.IX_StaffingLine2NONCLUSTERED10022026-08-18 14:16:322026-09-06 04:25:51USEDkeep — in use
host_726.schedule.ContractStaging.IX_ShiftSummary3NONCLUSTERED0002never2026-09-06 04:25:51UNUSEDreview, then DROP
host_726.schedule.ContractStaging.PK_PolicyLine1CLUSTEREDYY05022026-08-18 14:16:572026-09-06 04:25:51USEDKEEP — primary key
host_726.schedule.MeterStaging.IX_PayrollAudit2NONCLUSTERED408361310510701942026-09-11 15:09:172026-09-11 01:02:37USEDkeep — in use
host_726.schedule.MeterStaging.PK_PolicyArchive1CLUSTEREDYY1261476472701952026-09-11 15:09:162026-09-11 01:02:37USEDKEEP — primary key
host_726.schedule.SupplierEntry.IX_InvoiceStaging2NONCLUSTERED10022026-08-18 14:16:322026-09-06 04:25:52USEDkeep — in use
host_726.schedule.SupplierEntry.IX_StaffingDaily3NONCLUSTERED0002never2026-09-06 04:25:52UNUSEDreview, then DROP
host_726.schedule.SupplierEntry.PK_MeterQueue1CLUSTEREDYY05022026-08-18 14:16:572026-09-06 04:25:52USEDKEEP — primary key
host_726.schedule.ForecastEntry.IX_ContractHistory2NONCLUSTERED10022026-08-18 14:16:332026-09-06 04:25:52USEDkeep — in use
host_726.schedule.ForecastEntry.IX_ForecastLine3NONCLUSTERED02022026-08-18 14:16:372026-09-06 04:25:52USEDkeep — in use
host_726.schedule.ForecastEntry.PK_MeterSummary1CLUSTEREDYY023022026-08-18 14:22:132026-09-06 04:25:52USEDKEEP — primary key
host_726.schedule.CustomerHistory.IX_LedgerQueue2NONCLUSTERED85228377108271452026-09-12 01:04:142026-09-11 01:08:17USEDkeep — in use
host_726.schedule.CustomerHistory.PK_PayrollAudit1CLUSTEREDYY12826813426878271452026-09-11 15:09:172026-09-11 01:08:17USEDKEEP — primary key
host_726.schedule.QuotaDetail.IX_QuotaMonthly2NONCLUSTERED10022026-08-18 14:16:312026-09-06 04:29:54USEDkeep — in use
host_726.schedule.QuotaDetail.IX_TicketSummary3NONCLUSTERED01022026-08-18 14:16:372026-09-06 04:29:54USEDkeep — in use
host_726.schedule.QuotaDetail.PK_RosterHeader1CLUSTEREDYY011022026-08-18 14:17:362026-09-06 04:29:54USEDKEEP — primary key
host_726.schedule.RosterResult.IX_BookingAudit2NONCLUSTERED22596903783442026-09-08 01:06:192026-09-11 01:08:25USEDkeep — in use
host_726.schedule.RosterResult.IX_AssetStaging3NONCLUSTERED214316227503783442026-09-11 15:09:172026-09-11 01:08:25USEDkeep — in use
host_726.schedule.RosterResult.PK_PricingSummary1CLUSTEREDYY76872520291980623783442026-09-12 01:04:112026-09-11 01:08:25USEDKEEP — primary key
host_726.schedule.MeterSnapshot.IX_StaffingSummary2NONCLUSTERED10022026-08-18 14:16:322026-09-06 04:41:22USEDkeep — in use
host_726.schedule.MeterSnapshot.IX_MeterLog3NONCLUSTERED01022026-08-18 14:16:372026-09-06 04:41:22USEDkeep — in use
host_726.schedule.MeterSnapshot.PK_CampaignSnapshot1CLUSTEREDYY09022026-08-18 14:22:412026-09-06 04:41:22USEDKEEP — primary key
host_726.schedule.LedgerSnapshot.PK_RouteStatus1CLUSTEREDYY26137863322132026-09-12 01:04:112026-09-06 04:41:35USEDKEEP — primary key
host_726.schedule.LedgerSnapshot.IX_TicketLine2NONCLUSTEREDY21032026-09-05 15:31:442026-09-06 04:41:35USEDkeep — in use
host_726.schedule.RosterHistory.PK_MeterLine1CLUSTEREDYY215793715055752026-09-11 15:09:162026-09-10 01:45:00USEDKEEP — primary key
host_726.schedule.AssetStaging.PK_CampaignResult1CLUSTEREDYY105454357055752026-09-11 15:09:162026-09-06 04:41:35USEDKEEP — primary key
host_726.schedule.InvoiceLog.PK_CatalogSummary1CLUSTEREDYY43092821310642026-09-11 15:24:182026-09-06 03:31:56USEDKEEP — primary key
host_726.schedule.InvoiceLog.IX_WarehouseHeader2NONCLUSTEREDY1100042026-08-29 15:36:502026-09-06 03:31:56USEDkeep — in use
host_726.schedule.ContractResult.PK_StaffingSummary1CLUSTEREDYY030357042026-09-11 15:24:182026-09-06 03:31:56USEDKEEP — primary key
host_726.schedule.ContractResult.UX_CampaignHistory2NONCLUSTEREDYY22558042026-09-10 16:26:102026-09-06 03:31:56USEDkeep — in use
host_726.schedule.SalesArchive.IX_RosterStatus1CLUSTERED0004never2026-09-06 03:31:56UNUSEDKEEP — table storage
host_726.schedule.CatalogHistory.PK_OrdersStatus1CLUSTEREDYY275994002026-09-10 14:39:162026-09-06 03:31:56USEDKEEP — primary key
host_726.schedule.CatalogHistory.IX_PricingStatus2NONCLUSTEREDY0000never2026-09-06 03:31:56UNUSEDreview carefully — unique
host_726.schedule.engine.PK_ReconcileDaily1CLUSTEREDYY1041398610153322026-09-12 01:04:152026-09-06 04:41:23USEDKEEP — primary key
host_726.schedule.engine.UQ_MeterQueue2NONCLUSTEREDY1015880012026-09-12 01:04:112026-09-06 04:41:23USEDkeep — in use
host_726.schedule.TerritoryAudit.PK_PayrollSnapshot1CLUSTEREDYY0099480652382026-09-11 14:59:242026-09-11 01:02:41USEDKEEP — primary key
host_726.schedule.TerritoryAudit.UX_BookingHeader2NONCLUSTEREDYY9948000342652026-09-11 14:59:242026-09-11 14:59:14USEDkeep — in use
host_726.schedule.WarehouseArchive.IX_CustomerHistory2NONCLUSTERED00059258neverneverUNUSEDreview, then DROP
host_726.schedule.WarehouseArchive.IX_OrdersHeader3NONCLUSTERED2989310592582026-09-12 01:04:11neverUSEDkeep — in use
host_726.schedule.WarehouseArchive.PK_RouteAudit1CLUSTEREDYY90491298960904932026-09-12 01:04:112026-09-11 14:59:13USEDKEEP — primary key
host_726.schedule.LedgerMonthly.IX_CatalogDaily2NONCLUSTERED0001591628neverneverUNUSEDreview, then DROP
host_726.schedule.LedgerMonthly.IX_CustomerMonthly3NONCLUSTERED298931015916282026-09-12 01:04:11neverUSEDkeep — in use
host_726.schedule.LedgerMonthly.PK_ClaimLine1CLUSTEREDYY23874341023874382026-09-12 01:04:152026-09-11 14:59:13USEDKEEP — primary key
host_726.schedule.RouteAudit.IX_InvoiceHeader2NONCLUSTERED8001639502026-08-22 10:11:072026-09-11 01:02:41USEDkeep — in use
host_726.schedule.RouteAudit.IX_SettlementDetail3NONCLUSTEREDY5547555703032382026-09-03 11:27:42neverUSEDkeep — in use
host_726.schedule.RouteAudit.IX_CatalogArchive4NONCLUSTERED0701639502026-09-11 09:09:552026-09-11 01:02:50USEDkeep — in use
host_726.schedule.RouteAudit.IX_QuotaStaging5NONCLUSTERED0501639502026-08-25 14:29:202026-09-11 01:02:50USEDkeep — in use
host_726.schedule.RouteAudit.PK_PayrollAudit1CLUSTEREDYY7579365155743051812026-09-11 09:09:552026-09-11 01:02:41USEDKEEP — primary key
host_726.schedule.ShipmentHeader.IX_QuotaSnapshot2NONCLUSTERED000795813never2026-09-11 01:03:09UNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_InvoiceSummary4NONCLUSTERED000795813never2026-09-11 01:03:18UNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.IX_CampaignHistory3NONCLUSTERED000795813never2026-09-11 01:03:19UNUSEDreview, then DROP
host_726.schedule.ShipmentHeader.PK_CampaignDetail1CLUSTEREDYY000795813never2026-09-11 01:02:51UNUSEDKEEP — primary key
host_726.schedule.SupplierEntry.PK_AssetSnapshot1CLUSTEREDYY4290991022026-09-12 01:04:102026-09-06 04:41:29USEDKEEP — primary key
host_726.schedule.TerritoryDetail.PK_ReconcileMonthly1CLUSTEREDYY55501122026-09-11 20:30:102026-09-11 01:03:19USEDKEEP — primary key
host_726.schedule.StaffingEntry.PK_QuotaDetail1CLUSTEREDYY4850870171521672026-09-12 01:04:152026-09-11 01:03:19USEDKEEP — primary key
host_726.schedule.StaffingEntry.UQ_TicketDetail2NONCLUSTEREDY5520562026-09-11 20:30:102026-09-11 01:03:19USEDkeep — in use
host_726.schedule.StaffingEntry.UX_PayrollDaily3NONCLUSTEREDYY8582715201122026-09-12 01:04:152026-09-11 01:03:19USEDkeep — in use
host_726.schedule.ForecastMonthly.IX_WarehouseDaily2NONCLUSTERED190048507042026-09-11 13:52:352026-09-11 01:03:56USEDkeep — in use
host_726.schedule.ForecastMonthly.IX_PayrollHistory3NONCLUSTERED20048507042026-08-25 14:20:052026-09-11 01:03:56USEDkeep — in use
host_726.schedule.ForecastMonthly.IX_BatchMonthly4NONCLUSTERED0004850704never2026-09-11 01:03:56UNUSEDreview, then DROP
host_726.schedule.ForecastMonthly.PK_ForecastHistory1CLUSTEREDYY4850699111997014032026-09-12 01:04:152026-09-11 01:03:19USEDKEEP — primary key
host_726.schedule.CatalogEntry.PK_PolicyDetail1CLUSTEREDYY8582742222026-09-12 01:04:152026-09-06 04:41:34USEDKEEP — primary key
host_726.schedule.CatalogEntry.UQ_AssetAudit2NONCLUSTEREDY20012026-08-22 14:54:172026-09-06 04:41:34USEDkeep — in use
host_726.schedule.ContractAudit.PK_TicketSummary1CLUSTEREDYY48507052022026-09-12 01:04:152026-09-06 04:41:34USEDKEEP — primary key
host_726.schedule.ContractAudit.UQ_OrdersStaging2NONCLUSTEREDY0001never2026-09-06 04:41:34UNUSEDreview carefully — unique
host_726.schedule.ContractAudit.UX_BillingSnapshot3NONCLUSTEREDYY8582710022026-09-12 01:04:152026-09-06 04:41:35USEDkeep — in use
host_726.schedule.SupplierSummary.PK_LedgerEntry1CLUSTEREDYY060022026-09-11 20:30:102026-09-06 04:41:35USEDKEEP — primary key
host_726.schedule.SupplierSummary.UQ_BillingStaging2NONCLUSTEREDY0001never2026-09-06 04:41:35UNUSEDreview carefully — unique
host_726.schedule.PayrollDaily.PK_CustomerQueue1CLUSTEREDYY7928092567032026-09-11 15:09:172026-09-06 04:41:35USEDKEEP — primary key
host_726.schedule.WarehouseDaily.PK_QuotaAudit1CLUSTEREDYY558022026-09-11 20:30:102026-09-06 04:41:35USEDKEEP — primary key
host_726.schedule.WarehouseDaily.UQ_ShiftEntry2NONCLUSTEREDY0001never2026-09-06 04:41:35UNUSEDreview carefully — unique
host_726.schedule.WarehouseDaily.UX_TerritorySummary3NONCLUSTEREDYY550022026-09-11 20:30:102026-09-06 04:41:35USEDkeep — in use
host_726.schedule.sql.IX_PayrollEntry3NONCLUSTEREDY8583273102552026-09-12 01:04:152026-09-10 01:45:00USEDkeep — in use
host_726.schedule.sql.PK_ContractMonthly1CLUSTEREDYY656673802552026-09-11 20:32:412026-09-10 01:45:00USEDKEEP — primary key
host_726.schedule.sql.UQ_SalesStatus2NONCLUSTEREDY412104072026-09-11 20:32:412026-09-10 01:45:00USEDkeep — in use
host_726.schedule.LedgerStatus.PK_SettlementQueue1CLUSTEREDYY03022026-08-22 13:50:142026-09-06 04:41:35USEDKEEP — primary key
host_726.schedule.LedgerStatus.UQ_QuotaAudit2NONCLUSTEREDY0001never2026-09-06 04:41:35UNUSEDreview carefully — unique
host_726.schedule.OrdersQueue.PK_QuotaQueue1CLUSTEREDYY55501122026-09-11 20:30:102026-09-11 01:03:57USEDKEEP — primary key
host_726.schedule.LedgerStaging.IX_StaffingLog3NONCLUSTERED85903415607512026-09-12 01:04:152026-09-11 01:03:57USEDkeep — in use
host_726.schedule.LedgerStaging.PK_ContractQueue1CLUSTEREDYY4851425948585017512026-09-12 01:04:152026-09-11 01:03:57USEDKEEP — primary key
host_726.schedule.LedgerStaging.UQ_TicketResult2NONCLUSTEREDY10502482026-09-10 15:11:032026-09-11 01:03:57USEDkeep — in use
host_726.schedule.LedgerStaging.UX_QuotaHeader4NONCLUSTEREDYY000504never2026-09-11 01:03:57UNUSEDreview carefully — unique
host_726.schedule.step.PK_AssetStaging1CLUSTEREDYY10074245222026-09-12 01:04:152026-09-06 04:41:38USEDKEEP — primary key
host_726.schedule.step.UQ_AssetQueue3NONCLUSTEREDY20012026-08-22 14:54:172026-09-06 04:41:38USEDkeep — in use
host_726.schedule.step.UQ_OrdersLine2NONCLUSTEREDY110012026-09-11 20:29:502026-09-06 04:41:38USEDkeep — in use
host_726.schedule.ShipmentResult.PK_MeterSnapshot1CLUSTEREDYY55501122026-09-11 20:30:102026-09-11 01:03:59USEDKEEP — primary key
host_726.schedule.WarehouseEntry.PK_SettlementLine1CLUSTEREDYY4850815858398022026-09-12 01:04:152026-09-06 04:41:40USEDKEEP — primary key
host_726.schedule.WarehouseEntry.UQ_ShiftSnapshot2NONCLUSTEREDY09012026-08-24 09:43:112026-09-06 04:41:40USEDkeep — in use
host_726.schedule.WarehouseEntry.UX_OrdersLog3NONCLUSTEREDYY0002never2026-09-06 04:41:40UNUSEDreview carefully — unique
host_726.wps.ContractStatus.IX_RosterDaily2NONCLUSTERED00070671never2026-09-06 04:41:40UNUSEDreview, then DROP
host_726.wps.ContractStatus.PK_ClaimLog1CLUSTEREDYY0706710706712026-09-12 01:04:112026-09-06 04:41:40USEDKEEP — primary key
host_726.wps.ContractStatus.UX_TerritoryResult3NONCLUSTEREDYY0000never2026-09-06 04:41:40COLDreview carefully — unique
host_726.wps.ContractStatus.UX_SettlementDetail4NONCLUSTEREDY0000never2026-09-06 04:41:40UNUSEDreview carefully — unique
host_726.wps.PolicyResult.IX_ContractSnapshot2NONCLUSTERED30300282026-09-11 13:48:002026-09-11 01:03:59USEDkeep — in use
host_726.wps.PolicyResult.PK_SettlementLine1CLUSTEREDYY59236273282026-09-11 13:48:002026-09-11 01:03:59USEDKEEP — primary key
host_726.wps.LedgerMonthly.PK_BookingResult1CLUSTEREDYY00042never2026-09-11 01:03:59UNUSEDKEEP — primary key
host_726.wps.BookingStaging.PK_ClaimHistory1CLUSTEREDYY191850432026-09-10 15:00:072026-09-11 01:03:59USEDKEEP — primary key
host_726.wps.SalesHeader.PK_ContractHistory1CLUSTEREDYY00070never2026-09-11 01:03:59UNUSEDKEEP — primary key
host_726.wps.ForecastResult.PK_QuotaLog1CLUSTEREDYY494801464915222026-09-11 23:59:002026-09-11 01:03:59USEDKEEP — primary key
host_726.wps.ForecastResult.UQ_ShipmentArchive5NONCLUSTEREDY160122015192026-09-12 00:00:002026-09-11 01:03:59USEDkeep — in use
host_726.wps.StaffingResult.PK_RosterStatus1CLUSTEREDYY84129042026-09-12 01:03:592026-09-06 04:41:41USEDKEEP — primary key
host_726.wps.StaffingStaging.PK_PolicyEntry1CLUSTEREDYY0004never2026-09-10 01:45:03UNUSEDKEEP — primary key
host_726.wps.QuotaDetail.PK_BatchQueue1CLUSTEREDYY0000never2026-09-06 04:41:41UNUSEDKEEP — primary key
host_726.wps.OrdersLog.PK_WarehouseArchive1CLUSTEREDYY0000never2026-09-06 04:41:41UNUSEDKEEP — primary key
host_726.wps.TerritoryQueue.IX_InvoiceAudit10NONCLUSTERED634404492026-09-11 13:48:002026-09-11 01:03:59USEDkeep — in use
host_726.wps.TerritoryQueue.PK_RosterSnapshot1CLUSTEREDYY221765544492026-09-11 13:48:012026-09-11 01:03:59USEDKEEP — primary key
host_726.wps.TerritoryQueue.UX_MeterStaging2NONCLUSTEREDY5024404462026-09-11 13:48:012026-09-11 01:03:59USEDkeep — in use
host_726.wps.ContractEntry.PK_PayrollSummary1CLUSTEREDYY000446never2026-09-11 01:03:59UNUSEDKEEP — primary key
host_726.wps.TicketStatus.PK_InvoiceMonthly1CLUSTEREDYY322420192026-09-11 23:59:002026-09-11 01:03:59USEDKEEP — primary key
host_726.wps.SalesDetail.PK_SettlementLine1CLUSTEREDYY000545never2026-09-11 01:03:59UNUSEDKEEP — primary key
host_726.wps.ClaimResult.PK_TicketEntry1CLUSTEREDYY378012026-09-10 13:20:592026-09-10 01:45:03USEDKEEP — primary key
host_726.wps.CatalogSnapshot.PK_ForecastHeader1CLUSTEREDYY0004never2026-09-10 01:45:03UNUSEDKEEP — primary key
host_726.wps.BillingLine.PK_RosterResult1CLUSTEREDYY7092249052026-09-11 23:59:002026-09-06 04:41:41USEDKEEP — primary key
host_726.wps.BillingLine.UX_WarehouseLog2NONCLUSTEREDYY100052026-09-10 13:21:402026-09-11 01:03:59USEDkeep — in use
host_726.wps.BatchStatus.PK_ClaimLine1CLUSTEREDYY22029352026-09-11 13:48:002026-09-11 01:03:59USEDKEEP — primary key
host_726.wps.BatchStatus.UQ_CustomerHeader2NONCLUSTEREDY930052026-09-10 15:00:072026-09-11 01:03:59USEDkeep — in use
host_726.wps.BookingResult.PK_WarehouseMonthly1CLUSTEREDYY0005never2026-09-11 01:03:59UNUSEDKEEP — primary key
host_726.wps.BookingStaging.PK_ForecastLog1CLUSTEREDYY01610102026-09-10 13:07:202026-09-11 01:03:59USEDKEEP — primary key
QUOTA.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000never2026-09-06 04:41:43UNUSEDKEEP — primary key
QUOTA.cfg.QuotaStatus.UX_MeterSummary2NONCLUSTEREDY0000never2026-09-06 04:41:43UNUSEDreview carefully — unique
QUOTA.dbo.ContractResult.PK_CampaignResult1CLUSTEREDYY0000never2026-09-06 04:41:43UNUSEDKEEP — primary key
QUOTA.dbo.SettlementStaging.PK_TicketStaging1CLUSTEREDYY0000never2026-09-06 04:41:43UNUSEDKEEP — 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-06 04:41:44UNUSEDKEEP — primary key
QUOTA.dbo.WarehouseEntry.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-06 04:41:44UNUSEDKEEP — primary key
QUOTA.dbo.WarehouseEntry.UX_CampaignHeader2NONCLUSTEREDY0000never2026-09-06 04:41:44UNUSEDreview carefully — unique
QUOTA.dbo.TicketSummary.PK_SalesLine1CLUSTERED0000never2026-09-06 04:41:44UNUSEDKEEP — table storage
QUOTA.dbo.TerritoryEntry.PK_SalesSummary1CLUSTEREDYY0000never2026-09-06 04:41:44UNUSEDKEEP — primary key
QUOTA.dbo.TerritoryEntry.UX_TerritoryQueue2NONCLUSTEREDY0000never2026-09-06 04:41:44UNUSEDreview carefully — unique
QUOTA.dbo.PolicyEntry.PK_TicketEntry1CLUSTEREDYY0000never2026-09-06 04:41:44UNUSEDKEEP — primary key
QUOTA.dbo.PolicyEntry.UX_PolicyAudit2NONCLUSTEREDY0000never2026-09-06 04:41:44UNUSEDreview carefully — unique
QUOTA.dbo.CampaignHeader.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-06 04:41:44UNUSEDKEEP — primary key
QUOTA.dbo.CampaignHeader.UX_BillingLog2NONCLUSTEREDY0000never2026-09-06 04:41:44UNUSEDreview carefully — unique
QUOTA.dbo.WarehouseHeader.PK_OrdersQueue1CLUSTEREDYY0000never2026-09-06 04:41:44UNUSEDKEEP — primary key
QUOTA.dbo.WarehouseHeader.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-06 04:41:45UNUSEDreview carefully — unique
QUOTA.dbo.RouteQueue.PK_SupplierAudit1CLUSTEREDYY0000never2026-09-06 04:41:45UNUSEDKEEP — primary key
QUOTA.dbo.RouteQueue.UX_CampaignQueue2NONCLUSTEREDY0000never2026-09-06 04:41:45UNUSEDreview carefully — unique
QUOTA.dbo.CampaignAudit.PK_BatchSnapshot1CLUSTEREDYY0000never2026-09-06 04:41:45UNUSEDKEEP — primary key
QUOTA.dbo.CampaignAudit.UX_SupplierArchive2NONCLUSTEREDY0000never2026-09-06 04:41:45UNUSEDreview carefully — unique
QUOTA.dbo.ShiftDaily.PK_ReconcileStatus1CLUSTEREDYY0000never2026-09-06 04:41:45UNUSEDKEEP — primary key
QUOTA.dbo.ShiftDaily.UX_RouteDaily2NONCLUSTEREDY0000never2026-09-06 04:41:45UNUSEDreview carefully — unique
QUOTA.emp.WarehouseMonthly.PK_PricingHistory1CLUSTEREDYY0000never2026-09-06 04:41:45UNUSEDKEEP — primary key
QUOTA.emp.WarehouseMonthly.UX_CustomerDetail2NONCLUSTEREDYY0000never2026-09-06 04:41:45UNUSEDreview carefully — unique
QUOTA.emp.SettlementLine.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-06 04:41:45UNUSEDKEEP — primary key
QUOTA.emp.SalesDetail.PK_BillingLog1CLUSTEREDYY0000never2026-09-06 04:41:45UNUSEDKEEP — primary key
QUOTA.emp.BatchMonthly.PK_TicketAudit1CLUSTEREDYY0000never2026-09-06 04:41:45UNUSEDKEEP — primary key
QUOTA.emp.RosterLog.PK_QuotaLog1CLUSTEREDYY0000never2026-09-06 04:41:45UNUSEDKEEP — primary key
QUOTA.emp.QuotaMonthly.IX_ShipmentEntry15NONCLUSTERED0000never2026-09-06 04:41:45UNUSEDreview, then DROP
QUOTA.emp.QuotaMonthly.PK_ReconcileDetail1CLUSTEREDYY0000never2026-09-06 04:41:45UNUSEDKEEP — primary key
QUOTA.emp.OrdersEntry.PK_PolicyHeader1CLUSTEREDYY0000never2026-09-06 04:41:46UNUSEDKEEP — primary key
QUOTA.emp.PayrollSummary.PK_RouteSummary1CLUSTEREDYY0000never2026-09-06 04:41:46UNUSEDKEEP — primary key
QUOTA.emp.SettlementAudit.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-06 04:41:46UNUSEDKEEP — primary key
QUOTA.emp.InvoiceLog.PK_BatchEntry1CLUSTEREDYY0000never2026-09-06 04:41:46UNUSEDKEEP — 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-06 04:41:46UNUSEDKEEP — primary key
QUOTA.emp.RouteHistory.UX_CustomerQueue2NONCLUSTEREDY0000never2026-09-06 04:41:46UNUSEDreview carefully — unique
QUOTA.emp.CustomerHistory.PK_ShiftDaily1CLUSTEREDYY0000never2026-09-06 04:41:47UNUSEDKEEP — 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-06 04:41:47UNUSEDreview, then DROP
QUOTA.emp.MeterResult.PK_CustomerResult1CLUSTEREDYY0000never2026-09-06 04:41:47UNUSEDKEEP — primary key
QUOTA.emp.PayrollHeader.PK_TicketHistory1CLUSTEREDYY0000never2026-09-06 04:41:47UNUSEDKEEP — primary key
QUOTA.emp.OrdersAudit.PK_ShipmentHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.RosterResult.PK_MeterAudit1CLUSTEREDYY0000never2026-09-06 04:41:47UNUSEDKEEP — primary key
QUOTA.emp.RouteHeader.PK_StaffingQueue1CLUSTEREDYY0000never2026-09-06 04:41:48UNUSEDKEEP — primary key
QUOTA.emp.MeterAudit.PK_ClaimLog1CLUSTEREDYY0000never2026-09-06 04:41:48UNUSEDKEEP — primary key
QUOTA.emp.QuotaStatus.PK_OrdersArchive1CLUSTEREDYY0000never2026-09-06 04:41:48UNUSEDKEEP — primary key
QUOTA.emp.ShiftLine.IX_PricingAudit13NONCLUSTERED0000never2026-09-06 04:41:48UNUSEDreview, then DROP
QUOTA.emp.ShiftLine.PK_SettlementStatus1CLUSTEREDYY0000never2026-09-06 04:41:48UNUSEDKEEP — primary key
QUOTA.emp.ShiftLine.UX_BookingDaily2NONCLUSTEREDY0000never2026-09-06 04:41:48UNUSEDreview carefully — unique
QUOTA.emp.CampaignHeader.PK_BillingQueue1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.MeterStatus.PK_BillingStaging1CLUSTEREDYY0000never2026-09-06 04:41:48UNUSEDKEEP — primary key
QUOTA.emp.WarehouseStaging.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-06 04:41:48UNUSEDKEEP — primary key
QUOTA.emp.ForecastHeader.IX_WarehouseResult6NONCLUSTERED0000never2026-09-06 04:41:48UNUSEDreview, then DROP
QUOTA.emp.ForecastHeader.PK_OrdersAudit1CLUSTEREDYY0000never2026-09-06 04:41:48UNUSEDKEEP — primary key
QUOTA.emp.SalesLog.PK_AssetStaging1CLUSTEREDYY0000never2026-09-06 04:41:48UNUSEDKEEP — primary key
QUOTA.emp.AssetDaily.PK_CustomerMonthly1CLUSTEREDYY0000never2026-09-06 04:41:48UNUSEDKEEP — primary key
QUOTA.emp.StaffingDaily.PK_BookingLog1CLUSTEREDYY0000never2026-09-06 04:41:49UNUSEDKEEP — primary key
QUOTA.emp.ReconcileDetail.PK_AssetHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ClaimResult.PK_TerritoryQueue1CLUSTEREDYY0000never2026-09-06 04:41:49UNUSEDKEEP — primary key
QUOTA.emp.CatalogLog.PK_ReconcileHeader1CLUSTEREDYY0000never2026-09-06 04:41:49UNUSEDKEEP — primary key
QUOTA.emp.ShipmentSnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-06 04:41:49UNUSEDKEEP — primary key
QUOTA.emp.PricingDaily.IX_ShiftAudit2NONCLUSTERED0000never2026-09-06 04:41:49UNUSEDreview, then DROP
QUOTA.emp.PricingDaily.PK_RouteEntry1CLUSTEREDYY0000never2026-09-06 04:41:49UNUSEDKEEP — primary key
QUOTA.emp.PolicyLog.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-06 04:41:49UNUSEDKEEP — primary key
QUOTA.emp.PolicyLog.UX_OrdersSnapshot4NONCLUSTEREDY0000never2026-09-06 04:41:49UNUSEDreview carefully — unique
QUOTA.emp.RouteAudit.PK_ClaimResult1CLUSTEREDYY0000never2026-09-06 04:41:49UNUSEDKEEP — primary key
QUOTA.emp.WarehouseArchive.PK_StaffingArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.MeterHistory.IX_ContractArchive11NONCLUSTERED0000never2026-09-06 04:41:49UNUSEDreview, then DROP
QUOTA.emp.MeterHistory.PK_BatchLog1CLUSTEREDYY0000never2026-09-06 04:41:49UNUSEDKEEP — primary key
QUOTA.emp.MeterHistory.UX_BatchLog3NONCLUSTEREDYY0000never2026-09-06 04:41:49UNUSEDreview carefully — unique
QUOTA.emp.MeterHistory.UX_ForecastHeader20NONCLUSTEREDY0000never2026-09-06 04:41:49UNUSEDreview carefully — unique
QUOTA.emp.MeterHistory.UX_CustomerSnapshot2NONCLUSTEREDYY0000never2026-09-06 04:41:49UNUSEDreview carefully — unique
QUOTA.emp.MeterHistory.UX_QuotaStaging13NONCLUSTEREDY0000never2026-09-06 04:41:49UNUSEDreview 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-06 04:41:50UNUSEDKEEP — primary key
QUOTA.emp.TicketQueue.UX_PayrollDaily2NONCLUSTEREDY0000never2026-09-06 04:41:50UNUSEDreview carefully — unique
QUOTA.emp.MeterStatus.PK_CustomerDetail1CLUSTEREDYY0000never2026-09-06 04:41:50UNUSEDKEEP — primary key
QUOTA.emp.OrdersEntry.PK_TerritoryAudit1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.InvoiceLog.PK_BillingDetail1CLUSTEREDYY0000never2026-09-06 04:41:50UNUSEDKEEP — primary key
QUOTA.emp.CampaignHistory.IX_QuotaDetail2NONCLUSTERED0000never2026-09-06 04:41:50UNUSEDreview, then DROP
QUOTA.emp.CampaignHistory.PK_AssetHeader1CLUSTEREDYY0000never2026-09-06 04:41:50UNUSEDKEEP — primary key
QUOTA.emp.ContractArchive.PK_BookingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.TicketLine.PK_CampaignEntry1CLUSTEREDYY0000never2026-09-06 04:41:50UNUSEDKEEP — primary key
QUOTA.emp.BatchAudit.PK_ForecastSummary1CLUSTEREDYY0000never2026-09-06 04:41:51UNUSEDKEEP — primary key
QUOTA.emp.BatchAudit.UX_LedgerStaging2NONCLUSTEREDY0000never2026-09-06 04:41:51UNUSEDreview carefully — unique
QUOTA.emp.ClaimAudit.PK_LedgerDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ClaimAudit.UX_RouteMonthly2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.PolicyHistory.PK_OrdersDaily1CLUSTEREDYY0000never2026-09-06 04:41:52UNUSEDKEEP — primary key
QUOTA.emp.BillingEntry.PK_StaffingAudit1CLUSTEREDYY0000never2026-09-06 04:41:52UNUSEDKEEP — primary key
QUOTA.emp.BillingEntry.UX_StaffingLog2NONCLUSTEREDY0000never2026-09-06 04:41:52UNUSEDreview carefully — unique
QUOTA.emp.BillingAudit.PK_PolicyDetail1CLUSTEREDYY0000never2026-09-06 04:41:53UNUSEDKEEP — primary key
QUOTA.emp.BillingAudit.UX_SupplierSnapshot2NONCLUSTEREDY0000never2026-09-06 04:41:53UNUSEDreview carefully — unique
QUOTA.emp.ShipmentStaging.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-06 04:41:53UNUSEDKEEP — primary key
QUOTA.emp.ShipmentStaging.UX_RosterDaily2NONCLUSTEREDY0000never2026-09-06 04:41:53UNUSEDreview carefully — unique
QUOTA.emp.SalesLine.PK_CampaignResult1CLUSTEREDYY0000never2026-09-06 04:41:53UNUSEDKEEP — primary key
QUOTA.emp.ContractLog.PK_BookingSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ContractLog.UX_ClaimDetail2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.LedgerSnapshot.PK_CampaignStatus1CLUSTEREDYY0000never2026-09-06 04:41:54UNUSEDKEEP — primary key
QUOTA.emp.BookingSnapshot.PK_ReconcileStaging1CLUSTEREDYY0000never2026-09-06 04:41:54UNUSEDKEEP — primary key
QUOTA.emp.ReconcileDetail.PK_CampaignQueue1CLUSTEREDYY0000never2026-09-06 04:41:54UNUSEDKEEP — primary key
QUOTA.emp.PolicyStaging.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ReconcileStaging.PK_ContractStaging1CLUSTEREDYY0000never2026-09-06 04:41:54UNUSEDKEEP — primary key
QUOTA.emp.ReconcileStaging.UX_OrdersHistory2NONCLUSTEREDY0000never2026-09-06 04:41:54UNUSEDreview carefully — unique
QUOTA.emp.MeterStatus.PK_ReconcileMonthly1CLUSTEREDYY0000never2026-09-06 04:41:54UNUSEDKEEP — primary key
QUOTA.emp.MeterStatus.UX_ReconcileAudit7NONCLUSTEREDY0000never2026-09-06 04:41:54UNUSEDreview carefully — unique
QUOTA.emp.PricingAudit.PK_ReconcileSnapshot1CLUSTEREDYY0000never2026-09-06 04:41:54UNUSEDKEEP — primary key
QUOTA.emp.RosterQueue.PK_SettlementHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.ContractLog.PK_SupplierStatus1CLUSTEREDYY0000never2026-09-06 04:41:54UNUSEDKEEP — primary key
QUOTA.emp.BatchStatus.PK_QuotaLog1CLUSTEREDYY0000never2026-09-06 04:41:55UNUSEDKEEP — 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-06 04:41:55UNUSEDKEEP — primary key
QUOTA.emp.InvoiceAudit.PK_QuotaEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.MeterSummary.PK_AssetEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.AssetSummary.PK_SupplierStaging1CLUSTEREDYY0000never2026-09-06 04:41:56UNUSEDKEEP — primary key
QUOTA.emp.SupplierStaging.IX_MeterStaging12NONCLUSTERED0000never2026-09-06 04:41:56UNUSEDreview, then DROP
QUOTA.emp.SupplierStaging.PK_PayrollMonthly1CLUSTEREDYY0000never2026-09-06 04:41:56UNUSEDKEEP — primary key
QUOTA.emp.CustomerStatus.PK_PolicyHistory1CLUSTEREDYY0000never2026-09-06 04:41:56UNUSEDKEEP — primary key
QUOTA.emp.BillingAudit.PK_CustomerEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.PolicyLine.PK_OrdersSummary1CLUSTEREDYY0000never2026-09-06 04:41:57UNUSEDKEEP — primary key
QUOTA.emp.RouteStaging.PK_WarehouseLine1CLUSTEREDYY0000never2026-09-06 04:41:57UNUSEDKEEP — primary key
QUOTA.emp.CampaignMonthly.PK_OrdersArchive1CLUSTEREDYY0000never2026-09-06 04:41:57UNUSEDKEEP — primary key
QUOTA.emp.CatalogSnapshot.PK_ClaimHistory1CLUSTEREDYY0000never2026-09-06 04:41:57UNUSEDKEEP — primary key
QUOTA.emp.BillingDaily.PK_CustomerLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.BillingDaily.UX_LedgerDaily2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
QUOTA.emp.SupplierHistory.PK_WarehouseMonthly1CLUSTEREDYY0000never2026-09-06 04:41:57UNUSEDKEEP — primary key
QUOTA.emp.ShipmentMonthly.IX_InvoiceStaging5NONCLUSTERED0000never2026-09-06 04:41:57UNUSEDreview, then DROP
QUOTA.emp.ShipmentMonthly.PK_BatchDaily1CLUSTEREDYY0000never2026-09-06 04:41:57UNUSEDKEEP — primary key
QUOTA.emp.AssetDetail.PK_ReconcileResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.emp.AssetSnapshot.IX_SalesDaily5NONCLUSTERED0000never2026-09-06 04:41:57UNUSEDreview, then DROP
QUOTA.emp.AssetSnapshot.PK_OrdersDetail1CLUSTEREDYY0000never2026-09-06 04:41:57UNUSEDKEEP — primary key
QUOTA.emp.PricingStatus.PK_PolicyStatus1CLUSTEREDYY0000never2026-09-06 04:41:57UNUSEDKEEP — primary key
QUOTA.emp.TicketSnapshot.PK_CampaignQueue1CLUSTEREDYY0000never2026-09-06 04:41:57UNUSEDKEEP — primary key
QUOTA.emp.ForecastMonthly.PK_CampaignSummary1CLUSTEREDYY0000never2026-09-06 04:41:58UNUSEDKEEP — primary key
QUOTA.emp.PricingStatus.IX_QuotaLog8NONCLUSTERED0000never2026-09-06 04:41:58UNUSEDreview, then DROP
QUOTA.emp.PricingStatus.IX_ClaimEntry6NONCLUSTERED0000never2026-09-06 04:41:58UNUSEDreview, then DROP
QUOTA.emp.PricingStatus.PK_LedgerResult1CLUSTEREDYY0000never2026-09-06 04:41:58UNUSEDKEEP — primary key
QUOTA.emp.PayrollHistory.PK_LedgerQueue1CLUSTEREDYY0000never2026-09-06 04:41:58UNUSEDKEEP — primary key
QUOTA.emp.QuotaSummary.PK_LedgerEntry1CLUSTEREDYY0000never2026-09-06 04:41:58UNUSEDKEEP — primary key
QUOTA.emp.PricingQueue.PK_PricingStaging1CLUSTEREDYY0000never2026-09-06 04:41:58UNUSEDKEEP — primary key
QUOTA.emp.BookingMonthly.IX_ShipmentAudit5NONCLUSTERED0000never2026-09-06 04:41:58UNUSEDreview, then DROP
QUOTA.emp.BookingMonthly.PK_WarehouseLog1CLUSTEREDYY0000never2026-09-06 04:41:58UNUSEDKEEP — primary key
QUOTA.emp.MeterSnapshot.PK_StaffingSummary1CLUSTEREDYY0000never2026-09-06 04:41:58UNUSEDKEEP — primary key
QUOTA.emp.BatchMonthly.PK_InvoiceDetail1CLUSTEREDYY0000never2026-09-06 04:41:58UNUSEDKEEP — primary key
QUOTA.emp.StaffingAudit.PK_ForecastHeader1CLUSTEREDYY0000never2026-09-06 04:41:59UNUSEDKEEP — primary key
QUOTA.emp.BatchLog.PK_SalesDetail1CLUSTEREDYY0000never2026-09-06 04:41:59UNUSEDKEEP — primary key
QUOTA.emp.RouteHistory.PK_MeterEntry1CLUSTEREDYY0000never2026-09-06 04:41:59UNUSEDKEEP — primary key
QUOTA.emp.CampaignResult.IX_ForecastAudit9NONCLUSTERED0000never2026-09-06 04:41:59UNUSEDreview, then DROP
QUOTA.emp.CampaignResult.IX_CustomerQueue12NONCLUSTERED0000never2026-09-06 04:41:59UNUSEDreview, then DROP
QUOTA.emp.CampaignResult.PK_StaffingArchive1CLUSTEREDYY0000never2026-09-06 04:41:59UNUSEDKEEP — primary key
QUOTA.emp.PayrollHistory.PK_CampaignStaging1CLUSTEREDYY0000never2026-09-06 04:41:59UNUSEDKEEP — primary key
QUOTA.emp.TerritoryDaily.PK_RouteArchive1CLUSTEREDYY0000never2026-09-06 04:41:59UNUSEDKEEP — primary key
QUOTA.emp.CatalogSummary.IX_WarehouseSnapshot19NONCLUSTERED0000never2026-09-06 04:42:00UNUSEDreview, then DROP
QUOTA.emp.CatalogSummary.IX_ReconcileSummary16NONCLUSTERED0000never2026-09-06 04:42:00UNUSEDreview, then DROP
QUOTA.emp.CatalogSummary.PK_ShipmentStaging1CLUSTEREDYY0000never2026-09-06 04:42:00UNUSEDKEEP — primary key
QUOTA.emp.CatalogSummary.UX_OrdersAudit5NONCLUSTEREDY0000never2026-09-06 04:42:00UNUSEDreview carefully — unique
QUOTA.emp.CatalogSummary.UX_LedgerHistory12NONCLUSTEREDYY0000never2026-09-06 04:42:00UNUSEDreview carefully — unique
QUOTA.emp.TicketMonthly.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-06 04:42:00UNUSEDKEEP — primary key
QUOTA.emp.BillingQueue.IX_ContractSummary8NONCLUSTERED0000never2026-09-06 04:42:00UNUSEDreview, then DROP
QUOTA.emp.BillingQueue.PK_ShipmentEntry1CLUSTEREDYY0000never2026-09-06 04:42:00UNUSEDKEEP — primary key
QUOTA.emp.CampaignResult.PK_CustomerLine1CLUSTEREDYY0000never2026-09-06 04:42:00UNUSEDKEEP — primary key
QUOTA.org.SettlementSnapshot.PK_org.SettlementSnapshot1CLUSTEREDYY0000never2026-09-06 04:42:01UNUSEDKEEP — primary key
QUOTA.org.SettlementSnapshot.UX_BillingLine2NONCLUSTEREDY0000never2026-09-06 04:42:01UNUSEDreview carefully — unique
QUOTA.org.PolicySummary.IX_AssetEntry17NONCLUSTERED0000never2026-09-06 04:42:01UNUSEDreview, then DROP
QUOTA.org.PolicySummary.PK_QuotaAudit1CLUSTEREDYY0000never2026-09-06 04:42:01UNUSEDKEEP — primary key
QUOTA.org.PolicySummary.UX_ForecastHistory2NONCLUSTEREDYY0000never2026-09-06 04:42:01UNUSEDreview carefully — unique
QUOTA.org.CampaignQueue.PK_RosterDaily1CLUSTEREDYY0000never2026-09-06 04:42:01UNUSEDKEEP — primary key
QUOTA.org.TicketLog.PK_WarehouseDetail1CLUSTEREDYY0000never2026-09-06 04:42:01UNUSEDKEEP — primary key
QUOTA.org.TicketLog.UX_SalesMonthly4NONCLUSTEREDY0000never2026-09-06 04:42:01UNUSEDreview carefully — unique
QUOTA.org.BatchDaily.PK_QuotaStaging1CLUSTEREDYY0000never2026-09-06 04:42:01UNUSEDKEEP — primary key
QUOTA.org.BatchDaily.UX_PricingResult8NONCLUSTEREDYY0000never2026-09-06 04:42:01UNUSEDreview carefully — unique
QUOTA.org.ShipmentAudit.PK_ForecastHeader1CLUSTEREDYY0000never2026-09-06 04:42:01UNUSEDKEEP — primary key
QUOTA.org.ShipmentAudit.UX_BatchArchive2NONCLUSTEREDY0000never2026-09-06 04:42:01UNUSEDreview carefully — unique
QUOTA.org.BookingResult.PK_BillingQueue1CLUSTEREDYY0000never2026-09-06 04:42:01UNUSEDKEEP — primary key
QUOTA.org.InvoiceQueue.PK_TicketEntry1CLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDKEEP — primary key
QUOTA.org.PricingStatus.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDKEEP — primary key
QUOTA.org.CatalogAudit.PK_AssetStatus1CLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDKEEP — primary key
QUOTA.org.OrdersSummary.PK_StaffingAudit1CLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDKEEP — primary key
QUOTA.org.ContractResult.PK_PolicyLine1CLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDKEEP — 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-06 04:42:02UNUSEDKEEP — primary key
QUOTA.org.AssetSummary.UX_ShipmentSummary4NONCLUSTEREDY0000never2026-09-06 04:42:02UNUSEDreview carefully — unique
QUOTA.org.ShipmentQueue.PK_InvoiceStaging1CLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDKEEP — primary key
QUOTA.org.PolicyEntry.PK_SettlementSnapshot1CLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDKEEP — primary key
QUOTA.org.PolicyEntry.UX_ShiftSnapshot9NONCLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDreview carefully — unique
QUOTA.org.MeterAudit.PK_BillingDetail1CLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDKEEP — primary key
QUOTA.org.BillingHeader.PK_ContractStaging1CLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDKEEP — primary key
QUOTA.org.TicketSnapshot.PK_ForecastSnapshot1CLUSTEREDYY0000never2026-09-06 04:42:02UNUSEDKEEP — primary key
QUOTA.org.CustomerStaging.PK_CustomerHeader1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.KPI.PK_ShiftLine1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.KPI.UX_ShiftHeader8NONCLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDreview carefully — unique
QUOTA.org.StaffingArchive.PK_SettlementResult1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.CustomerEntry.PK_RouteSummary1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.PricingDaily.PK_CampaignArchive1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.PricingDaily.UX_BillingArchive2NONCLUSTEREDY0000never2026-09-06 04:42:03UNUSEDreview carefully — unique
QUOTA.org.TicketLine.PK_SupplierMonthly1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.BillingArchive.PK_MeterSummary1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.MeterEntry.PK_SupplierLog1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.ShiftResult.PK_AssetAudit1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.BatchMonthly.PK_SalesLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.RosterMonthly.IX_AssetDetail2NONCLUSTERED0000never2026-09-06 04:42:03UNUSEDreview, then DROP
QUOTA.org.RosterMonthly.PK_ForecastDaily1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.InvoiceStaging.IX_AssetAudit2NONCLUSTERED0000never2026-09-06 04:42:03UNUSEDreview, then DROP
QUOTA.org.InvoiceStaging.PK_CustomerMonthly1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.StaffingAudit.PK_AssetLog1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.Level.PK_ShiftStaging1CLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDKEEP — primary key
QUOTA.org.Level.UX_SettlementHistory2NONCLUSTEREDYY0000never2026-09-06 04:42:03UNUSEDreview carefully — unique
QUOTA.org.ContractHistory.PK_RouteArchive1CLUSTEREDYY0000never2026-09-06 04:42:04UNUSEDKEEP — primary key
QUOTA.org.QuotaEntry.IX_AssetHistory2NONCLUSTERED0000never2026-09-06 04:42:04UNUSEDreview, then DROP
QUOTA.org.QuotaEntry.PK_LedgerQueue1CLUSTEREDYY0000never2026-09-06 04:42:04UNUSEDKEEP — primary key
QUOTA.org.ClaimQueue.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-06 04:42:04UNUSEDKEEP — primary key
QUOTA.org.Position.PK_PolicySummary1CLUSTEREDYY0000never2026-09-06 04:42:04UNUSEDKEEP — primary key
QUOTA.org.Position.UX_MeterArchive2NONCLUSTEREDYY0000never2026-09-06 04:42:04UNUSEDreview carefully — unique
QUOTA.org.CampaignQueue.PK_BillingArchive1CLUSTEREDYY0000never2026-09-06 04:42:04UNUSEDKEEP — primary key
QUOTA.org.CampaignQueue.UX_TicketDaily2NONCLUSTEREDY0000never2026-09-06 04:42:04UNUSEDreview carefully — unique
QUOTA.org.MeterResult.PK_CatalogStaging1CLUSTEREDYY0000never2026-09-06 04:42:04UNUSEDKEEP — primary key
QUOTA.org.LedgerDaily.PK_ContractHeader1CLUSTEREDYY0000never2026-09-06 04:42:04UNUSEDKEEP — 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-06 04:42:04UNUSEDKEEP — primary key
QUOTA.org.ReconcileLine.PK_CustomerLog1CLUSTEREDYY0000never2026-09-06 04:42:05UNUSEDKEEP — primary key
QUOTA.org.SupplierResult.PK_ForecastQueue1CLUSTEREDYY0000never2026-09-06 04:42:05UNUSEDKEEP — primary key
QUOTA.org.RouteSummary.PK_RosterAudit1CLUSTEREDYY0000never2026-09-06 04:42:05UNUSEDKEEP — primary key
QUOTA.org.RouteSummary.UX_SupplierSummary2NONCLUSTEREDYY0000never2026-09-06 04:42:05COLDreview carefully — unique
QUOTA.org.ClaimDetail.PK_RouteMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.org.ShiftResult.PK_ForecastEntry1CLUSTEREDYY0000never2026-09-06 04:42:05UNUSEDKEEP — primary key
QUOTA.org.ShiftResult.UX_LedgerStaging7NONCLUSTEREDY0000never2026-09-06 04:42:05UNUSEDreview carefully — unique
QUOTA.org.QuotaResult.PK_CampaignDaily1CLUSTEREDYY0000never2026-09-06 04:42:05UNUSEDKEEP — primary key
QUOTA.org.QuotaResult.UX_BatchDaily2NONCLUSTEREDY0000never2026-09-06 04:42:05UNUSEDreview carefully — unique
QUOTA.org.SettlementAudit.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-06 04:42:05UNUSEDKEEP — 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-06 04:42:06UNUSEDKEEP — primary key
QUOTA.sal.SettlementQueue.PK_StaffingSnapshot1CLUSTEREDYY0000never2026-09-06 04:42:06UNUSEDKEEP — primary key
QUOTA.sal.SettlementQueue.UX_BillingResult2NONCLUSTEREDY0000never2026-09-06 04:42:06UNUSEDreview carefully — unique
QUOTA.sal.MeterHistory.PK_LedgerSnapshot1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.ShipmentAudit.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.RouteResult.PK_OrdersAudit1CLUSTEREDYY0000never2026-09-06 04:42:06UNUSEDKEEP — primary key
QUOTA.sal.RouteResult.UX_ContractEntry2NONCLUSTEREDY0000never2026-09-06 04:42:06UNUSEDreview carefully — unique
QUOTA.sal.OrdersHeader.PK_PayrollResult1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
QUOTA.sal.WarehouseDaily.PK_SettlementDetail1CLUSTEREDYY0000never2026-09-06 04:42:06UNUSEDKEEP — primary key
QUOTA.sal.WarehouseDaily.UX_BookingAudit2NONCLUSTEREDY0000never2026-09-06 04:42:06UNUSEDreview carefully — unique
QUOTA.sal.InvoiceLog.PK_MeterAudit1CLUSTEREDYY0000never2026-09-06 04:42:06UNUSEDKEEP — primary key
QUOTA.sal.PolicySnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-06 04:42:06UNUSEDKEEP — primary key
QUOTA.sal.SettlementStatus.PK_ReconcileResult1CLUSTEREDYY0000never2026-09-06 04:42:06UNUSEDKEEP — primary key
QUOTA.sal.SettlementStatus.UX_StaffingMonthly2NONCLUSTEREDY0000never2026-09-06 04:42:06UNUSEDreview carefully — unique
QUOTA.sal.ReconcileHistory.PK_PayrollHeader1CLUSTEREDYY0000never2026-09-06 04:42:07UNUSEDKEEP — primary key
QUOTA.sal.ReconcileHistory.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-06 04:42:07UNUSEDreview carefully — unique
QUOTA.sal.InvoiceEntry.PK_RouteQueue1CLUSTEREDYY0000never2026-09-06 04:42:07UNUSEDKEEP — primary key
QUOTA.sal.BillingQueue.PK_ReconcileHistory1CLUSTEREDYY0000never2026-09-06 04:42:07UNUSEDKEEP — primary key
QUOTA.sal.RosterDetail.PK_BookingStaging1CLUSTEREDYY0000never2026-09-06 04:42:07UNUSEDKEEP — primary key
QUOTA.sal.RosterQueue.PK_ShiftQueue1CLUSTEREDYY0000never2026-09-06 04:42:07UNUSEDKEEP — primary key
QUOTA.sal.RosterQueue.UX_RosterArchive2NONCLUSTEREDY0000never2026-09-06 04:42:07UNUSEDreview carefully — unique
QUOTA.sal.WarehouseHeader.PK_RouteEntry1CLUSTEREDYY0000never2026-09-06 04:42:07UNUSEDKEEP — 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-06 04:42:10UNUSEDKEEP — primary key
ASSET.cfg.QuotaStatus.UX_MeterSummary2NONCLUSTEREDY0000never2026-09-06 04:42:10UNUSEDreview carefully — unique
ASSET.dbo.ContractResult.PK_CampaignResult1CLUSTEREDYY0240242026-09-11 02:15:022026-09-06 04:42:10USEDKEEP — primary key
ASSET.dbo.SettlementStaging.PK_TicketStaging1CLUSTEREDYY00024never2026-09-11 01:04:04UNUSEDKEEP — primary key
ASSET.dbo.Jobs.PK_RosterStatus1CLUSTEREDYY265051179002026-09-12 01:00:032026-09-06 04:42:10USEDKEEP — primary key
ASSET.dbo.Jobs.UQ_ContractMonthly2NONCLUSTEREDY0000never2026-09-06 04:42:10UNUSEDreview carefully — unique
ASSET.dbo.MeterResult.PK_BookingDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.OrdersSnapshot.IX_SalesQueue2NONCLUSTERED0590088352026-09-12 01:00:032026-09-11 01:04:04USEDkeep — in use
ASSET.dbo.OrdersSnapshot.PK_PolicyLine1CLUSTEREDYY5477717681176702026-09-12 01:00:032026-09-11 01:04:04USEDKEEP — primary key
ASSET.dbo.SalesLine.IX_ReconcileResult2NONCLUSTERED589109505892026-09-12 01:00:032026-09-11 01:04:05USEDkeep — in use
ASSET.dbo.SalesLine.PK_MeterStatus1CLUSTEREDYY067205892026-09-12 01:00:022026-09-11 01:04:05USEDKEEP — primary key
ASSET.dbo.InvoiceSummary.PK_LedgerResult1CLUSTEREDYY5897657017672026-09-12 01:00:032026-09-11 01:04:05USEDKEEP — primary key
ASSET.dbo.CustomerSummary.PK_TicketStaging1CLUSTEREDYY2238223560229712026-09-12 01:00:032026-09-11 01:04:05USEDKEEP — primary key
ASSET.dbo.QuotaResult.PK_TerritoryStatus1CLUSTEREDYY223820002026-09-12 01:00:012026-09-06 04:42:12USEDKEEP — primary key
ASSET.dbo.LedgerResult.PK_ForecastMonthly1CLUSTEREDYY0176705892026-09-12 01:00:022026-09-11 01:04:05USEDKEEP — primary key
ASSET.dbo.BatchResult.IX_SettlementStaging2NONCLUSTERED00025never2026-09-11 01:04:05UNUSEDreview, then DROP
ASSET.dbo.BatchResult.IX_ReconcileEntry3NONCLUSTERED00025never2026-09-11 01:04:05UNUSEDreview, then DROP
ASSET.dbo.BatchResult.PK_ContractEntry1CLUSTEREDYY00025never2026-09-11 01:04:05UNUSEDKEEP — primary key
ASSET.dbo.PricingLog.PK_RouteLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.dbo.ClaimArchive.PK_StaffingStaging1CLUSTEREDYY8246589002026-09-12 01:00:032026-09-06 04:42:13USEDKEEP — primary key
ASSET.dbo.ClaimArchive.UQ_SupplierResult2NONCLUSTEREDY0000never2026-09-06 04:42:13UNUSEDreview carefully — unique
ASSET.dbo.CustomerArchive.IX_BillingHeader3NONCLUSTERED00025never2026-09-06 04:42:13UNUSEDreview, then DROP
ASSET.dbo.CustomerArchive.PK_AssetSummary1CLUSTEREDYY7570680252026-09-12 01:00:012026-09-06 04:42:13USEDKEEP — primary key
ASSET.dbo.CustomerArchive.UQ_OrdersMonthly2NONCLUSTEREDY0000never2026-09-06 04:42:13UNUSEDreview carefully — unique
ASSET.dbo.Status.PK_ShiftLine1CLUSTEREDYY412301767002026-09-12 01:00:032026-09-06 04:42:13USEDKEEP — primary key
ASSET.dbo.Status.UQ_PricingHeader2NONCLUSTEREDY0000never2026-09-06 04:42:13UNUSEDreview carefully — unique
ASSET.dbo.CatalogLine.PK_PricingQueue1CLUSTEREDYY00050never2026-09-11 01:04:05UNUSEDKEEP — primary key
ASSET.dbo.SupplierDetail.PK_ShiftResult1CLUSTEREDYY0000never2026-09-06 04:42:13UNUSEDKEEP — primary key
ASSET.dbo.CampaignResult.PK_InvoiceSnapshot1CLUSTEREDYY0000never2026-09-06 04:42:14UNUSEDKEEP — primary key
ASSET.dbo.TicketQueue.PK_CampaignEntry1CLUSTEREDYY0000never2026-09-06 04:42:14UNUSEDKEEP — primary key
ASSET.dbo.WarehouseEntry.PK_ShiftStatus1CLUSTEREDYY6716142002026-09-11 21:00:002026-09-06 04:42:14USEDKEEP — primary key
ASSET.dbo.WarehouseEntry.UX_CampaignHeader2NONCLUSTEREDY0000never2026-09-06 04:42:14UNUSEDreview carefully — unique
ASSET.dbo.TicketSummary.PK_SalesLine1CLUSTERED01009002026-09-11 15:52:082026-09-06 04:42:14USEDKEEP — table storage
ASSET.dbo.TerritoryEntry.PK_SalesSummary1CLUSTEREDYY259067002026-09-11 16:22:372026-09-06 04:42:14USEDKEEP — primary key
ASSET.dbo.TerritoryEntry.UX_TerritoryQueue2NONCLUSTEREDY0000never2026-09-06 04:42:14UNUSEDreview carefully — unique
ASSET.dbo.PolicyEntry.PK_TicketEntry1CLUSTEREDYY1386163002026-09-11 16:22:372026-09-06 04:42:14USEDKEEP — primary key
ASSET.dbo.PolicyEntry.UX_PolicyAudit2NONCLUSTEREDY0000never2026-09-06 04:42:14UNUSEDreview carefully — unique
ASSET.dbo.CampaignHeader.PK_InvoiceSnapshot1CLUSTEREDYY3078167002026-09-11 21:00:002026-09-06 04:42:14USEDKEEP — primary key
ASSET.dbo.CampaignHeader.UX_BillingLog2NONCLUSTEREDY0000never2026-09-06 04:42:14UNUSEDreview carefully — unique
ASSET.dbo.WarehouseHeader.PK_OrdersQueue1CLUSTEREDYY080002026-09-11 15:51:242026-09-06 04:42:14USEDKEEP — primary key
ASSET.dbo.WarehouseHeader.UX_TicketQueue2NONCLUSTEREDY0000never2026-09-06 04:42:14UNUSEDreview carefully — unique
ASSET.dbo.RouteQueue.PK_SupplierAudit1CLUSTEREDYY264467002026-09-11 16:22:372026-09-06 04:42:14USEDKEEP — primary key
ASSET.dbo.RouteQueue.UX_CampaignQueue2NONCLUSTEREDY0000never2026-09-06 04:42:15UNUSEDreview carefully — unique
ASSET.dbo.CampaignAudit.PK_BatchSnapshot1CLUSTEREDYY1338163002026-09-11 16:22:372026-09-06 04:42:15USEDKEEP — primary key
ASSET.dbo.CampaignAudit.UX_SupplierArchive2NONCLUSTEREDY0000never2026-09-06 04:42:15UNUSEDreview carefully — unique
ASSET.dbo.ShiftHistory.IX_SupplierLog2NONCLUSTEREDY0000never2026-09-06 04:42:15UNUSEDreview carefully — unique
ASSET.dbo.ShiftDaily.PK_ReconcileStatus1CLUSTEREDYY265747002026-09-11 16:22:372026-09-06 04:42:15USEDKEEP — primary key
ASSET.dbo.ShiftDaily.UX_RouteDaily2NONCLUSTEREDY0000never2026-09-06 04:42:15UNUSEDreview carefully — unique
ASSET.emp.WarehouseMonthly.PK_PricingHistory1CLUSTEREDYY371278802026-09-11 15:52:082026-09-06 04:42:15USEDKEEP — primary key
ASSET.emp.WarehouseMonthly.UX_CustomerDetail2NONCLUSTEREDYY80002026-09-11 09:36:232026-09-06 04:42:15USEDkeep — in use
ASSET.emp.SettlementLine.PK_LedgerAudit1CLUSTEREDYY0000never2026-09-06 04:42:15UNUSEDKEEP — primary key
ASSET.emp.SalesDetail.PK_BillingLog1CLUSTEREDYY0294002026-09-11 23:27:022026-09-06 04:42:15USEDKEEP — primary key
ASSET.emp.BatchMonthly.PK_TicketAudit1CLUSTEREDYY0000never2026-09-06 04:42:15UNUSEDKEEP — primary key
ASSET.emp.RosterLog.PK_QuotaLog1CLUSTEREDYY464002322026-09-11 13:32:012026-09-06 04:42:15USEDKEEP — primary key
ASSET.emp.QuotaMonthly.IX_ShipmentEntry19NONCLUSTERED269200892026-09-11 21:00:002026-09-11 01:04:06USEDkeep — in use
ASSET.emp.QuotaMonthly.PK_ReconcileDetail1CLUSTEREDYY69102692892026-09-11 21:00:002026-09-09 01:56:59USEDKEEP — primary key
ASSET.emp.OrdersEntry.PK_PolicyHeader1CLUSTEREDYY00089never2026-09-11 01:04:07UNUSEDKEEP — primary key
ASSET.emp.PayrollSummary.PK_RouteSummary1CLUSTEREDYY0294002026-09-11 23:27:022026-09-06 04:42:17USEDKEEP — primary key
ASSET.emp.SettlementAudit.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-06 04:42:17UNUSEDKEEP — primary key
ASSET.emp.InvoiceLog.PK_BatchEntry1CLUSTEREDYY02002026-09-08 08:22:112026-09-06 04:42:17USEDKEEP — 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_CustomerMonthly1CLUSTEREDYY9997002026-09-10 08:43:012026-09-06 04:42:17USEDKEEP — primary key
ASSET.emp.RouteHistory.UX_CustomerQueue2NONCLUSTEREDY0000never2026-09-06 04:42:17UNUSEDreview carefully — unique
ASSET.emp.CustomerHistory.PK_ShiftDaily1CLUSTEREDYY220002026-09-11 15:51:252026-09-06 04:42:17USEDKEEP — primary key
ASSET.emp.ForecastEntry.PK_SettlementLog1CLUSTEREDYY0298002026-09-11 16:28:192026-09-06 04:42:17USEDKEEP — primary key
ASSET.emp.ClaimQueue.PK_TerritoryResult1CLUSTEREDYY0000never2026-09-06 04:42:17UNUSEDKEEP — primary key
ASSET.emp.PolicyAudit.PK_ContractAudit1CLUSTEREDYY01295002026-09-11 16:28:192026-09-06 04:42:18USEDKEEP — primary key
ASSET.emp.ShipmentSummary.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-06 04:42:18UNUSEDKEEP — primary key
ASSET.emp.BatchArchive.PK_ClaimHistory1CLUSTEREDYY128411002026-09-11 16:28:192026-09-06 04:42:18USEDKEEP — primary key
ASSET.emp.RosterSnapshot.PK_PolicyStaging1CLUSTEREDYY0000never2026-09-06 04:42:18UNUSEDKEEP — primary key
ASSET.emp.MeterResult.IX_LedgerQueue9NONCLUSTERED015880452026-09-11 15:57:352026-09-11 01:04:07USEDkeep — in use
ASSET.emp.MeterResult.PK_CustomerResult1CLUSTEREDYY2514110070452026-09-11 21:00:002026-09-09 01:57:00USEDKEEP — primary key
ASSET.emp.PayrollHeader.PK_TicketHistory1CLUSTEREDYY138300452026-09-11 16:22:372026-09-09 01:57:01USEDKEEP — primary key
ASSET.emp.OrdersAudit.PK_ShipmentHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.RosterResult.PK_MeterAudit1CLUSTEREDYY0350002026-09-12 00:00:002026-09-06 04:42:19USEDKEEP — primary key
ASSET.emp.RouteHeader.PK_StaffingQueue1CLUSTEREDYY0000never2026-09-06 04:42:20UNUSEDKEEP — primary key
ASSET.emp.MeterAudit.PK_ClaimLog1CLUSTEREDYY710860172026-09-11 15:52:082026-09-09 01:57:02USEDKEEP — primary key
ASSET.emp.QuotaStatus.PK_OrdersArchive1CLUSTEREDYY0001never2026-09-06 04:42:20UNUSEDKEEP — primary key
ASSET.emp.ShiftLine.IX_PricingAudit13NONCLUSTERED470002026-09-08 08:22:112026-09-06 04:42:20USEDkeep — in use
ASSET.emp.ShiftLine.PK_SettlementStatus1CLUSTEREDYY423504702026-09-11 23:27:022026-09-06 04:42:20USEDKEEP — primary key
ASSET.emp.ShiftLine.UX_BookingDaily2NONCLUSTEREDY0000never2026-09-06 04:42:20UNUSEDreview carefully — unique
ASSET.emp.CampaignHeader.PK_BillingQueue1CLUSTEREDYY011002026-09-11 12:43:192026-09-06 04:42:21USEDKEEP — primary key
ASSET.emp.MeterStatus.PK_BillingStaging1CLUSTEREDYY0000never2026-09-06 04:42:21UNUSEDKEEP — primary key
ASSET.emp.WarehouseStaging.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-06 04:42:21UNUSEDKEEP — primary key
ASSET.emp.ForecastHeader.IX_WarehouseResult3NONCLUSTERED10770002026-09-11 15:52:082026-09-06 04:42:21USEDkeep — in use
ASSET.emp.ForecastHeader.PK_OrdersAudit1CLUSTEREDYY015107702026-09-11 15:52:082026-09-06 04:42:21USEDKEEP — primary key
ASSET.emp.SalesLog.PK_AssetStaging1CLUSTEREDYY0000never2026-09-06 04:42:21UNUSEDKEEP — primary key
ASSET.emp.AssetDaily.PK_CustomerMonthly1CLUSTEREDYY02080002026-09-11 15:52:082026-09-06 04:42:21USEDKEEP — primary key
ASSET.emp.StaffingDaily.PK_BookingLog1CLUSTEREDYY062002026-09-11 14:45:542026-09-06 04:42:21USEDKEEP — primary key
ASSET.emp.ClaimResult.PK_TerritoryQueue1CLUSTEREDYY0000never2026-09-06 04:42:21UNUSEDKEEP — primary key
ASSET.emp.CatalogLog.PK_ReconcileHeader1CLUSTEREDYY0000never2026-09-06 04:42:21UNUSEDKEEP — primary key
ASSET.emp.ShipmentSnapshot.PK_ReconcileQueue1CLUSTEREDYY0000never2026-09-06 04:42:21UNUSEDKEEP — primary key
ASSET.emp.PricingDaily.IX_ShiftAudit2NONCLUSTERED10720002026-09-11 15:52:082026-09-06 04:42:22USEDkeep — in use
ASSET.emp.PricingDaily.PK_RouteEntry1CLUSTEREDYY010107202026-09-11 15:52:082026-09-06 04:42:22USEDKEEP — primary key
ASSET.emp.PolicyLog.PK_LedgerHistory1CLUSTEREDYY35101384452026-09-11 16:22:372026-09-09 01:57:02USEDKEEP — primary key
ASSET.emp.PolicyLog.UX_OrdersSnapshot5NONCLUSTEREDY138500452026-09-11 16:22:372026-09-11 01:04:08USEDkeep — in use
ASSET.emp.RouteAudit.PK_ClaimResult1CLUSTEREDYY0001never2026-09-06 04:42:22UNUSEDKEEP — primary key
ASSET.emp.PayrollDaily.IX_BillingStaging2NONCLUSTERED40092026-08-20 08:08:192026-09-06 04:42:22USEDkeep — in use
ASSET.emp.PayrollDaily.PK_OrdersSnapshot1CLUSTEREDYY00292026-08-20 08:08:192026-09-06 04:42:22USEDKEEP — primary key
ASSET.emp.MeterHistory.IX_ContractArchive19NONCLUSTERED2280980852026-09-12 01:02:192026-09-11 01:04:09USEDkeep — in use
ASSET.emp.MeterHistory.PK_BatchLog1CLUSTEREDYY788763778120581252026-09-12 01:04:102026-09-09 01:57:02USEDKEEP — primary key
ASSET.emp.MeterHistory.UX_BatchLog2NONCLUSTEREDYY000101never2026-09-11 01:04:09UNUSEDreview carefully — unique
ASSET.emp.MeterHistory.UX_ForecastHeader23NONCLUSTEREDY4664540852026-09-11 21:00:002026-09-11 01:04:09USEDkeep — in use
ASSET.emp.MeterHistory.UX_CustomerSnapshot3NONCLUSTEREDYY0701012026-09-07 11:03:592026-09-11 01:04:09USEDkeep — in use
ASSET.emp.MeterHistory.UX_QuotaStaging4NONCLUSTEREDY11099430852026-09-11 21:00:002026-09-11 01:04:09USEDkeep — in use
ASSET.emp.TerritoryLine.PK_LedgerArchive1CLUSTEREDYY161464550146412026-09-12 00:05:112026-09-10 01:45:15USEDKEEP — primary key
ASSET.emp.SalesStaging.PK_PolicyDaily1CLUSTEREDYY22465330292026-09-12 00:06:002026-09-06 04:42:24USEDKEEP — primary key
ASSET.emp.TerritoryDaily.PK_MeterLog1CLUSTEREDYY0003never2026-09-06 04:42:24UNUSEDKEEP — primary key
ASSET.emp.SettlementQueue.IX_PolicyAudit2NONCLUSTERED800113972026-08-21 08:13:382026-09-11 01:04:10USEDkeep — in use
ASSET.emp.SettlementQueue.PK_SalesEntry1CLUSTEREDYY1538113972026-08-27 07:28:312026-09-11 01:04:10USEDKEEP — primary key
ASSET.emp.StaffingMonthly.IX_ReconcileEntry8NONCLUSTERED00092never2026-09-06 04:42:25UNUSEDreview, then DROP
ASSET.emp.StaffingMonthly.IX_SalesQueue9NONCLUSTERED224400922026-09-11 15:52:192026-09-06 04:42:25USEDkeep — in use
ASSET.emp.StaffingMonthly.PK_CampaignStatus1CLUSTEREDYY3926021093922026-09-11 15:52:192026-09-06 04:42:25USEDKEEP — primary key
ASSET.emp.TicketQueue.PK_BatchDaily1CLUSTEREDYY001078902026-09-11 15:52:082026-09-09 01:57:04USEDKEEP — primary key
ASSET.emp.TicketQueue.UX_PayrollDaily2NONCLUSTEREDY107800902026-09-11 15:52:082026-09-09 01:57:04USEDkeep — in use
ASSET.emp.MeterStatus.PK_CustomerDetail1CLUSTEREDYY00090never2026-09-11 01:04:11UNUSEDKEEP — primary key
ASSET.emp.OrdersEntry.PK_TerritoryAudit1CLUSTEREDYY01596002026-09-11 23:27:022026-09-06 04:42:25USEDKEEP — primary key
ASSET.emp.InvoiceLog.PK_BillingDetail1CLUSTEREDYY00082never2026-09-11 01:04:11UNUSEDKEEP — primary key
ASSET.emp.CampaignHistory.IX_QuotaDetail2NONCLUSTERED240501042026-09-11 15:53:032026-09-10 01:45:18USEDkeep — in use
ASSET.emp.CampaignHistory.PK_AssetHeader1CLUSTEREDYY27292405042026-09-12 01:02:402026-09-06 04:42:26USEDKEEP — primary key
ASSET.emp.ContractArchive.PK_BookingStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.TicketLine.PK_CampaignEntry1CLUSTEREDYY3810002026-09-11 15:51:232026-09-06 04:42:26USEDKEEP — primary key
ASSET.emp.BatchAudit.IX_ShiftSnapshot23NONCLUSTERED7489130265602026-09-12 01:03:292026-09-11 01:04:12USEDkeep — in use
ASSET.emp.BatchAudit.PK_ForecastSummary1CLUSTEREDYY1328713378095398312026-09-12 01:04:012026-09-11 01:04:12USEDKEEP — primary key
ASSET.emp.BatchAudit.UX_LedgerStaging10NONCLUSTEREDY8716240265602026-09-12 01:04:102026-09-11 01:04:12USEDkeep — 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_OrdersDaily1CLUSTEREDYY234427330367522026-09-12 01:03:382026-09-12 01:03:30USEDKEEP — primary key
ASSET.emp.ForecastQueue.IX_BookingLine12NONCLUSTERED0000never2026-09-06 04:42:46UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_InvoiceMonthly15NONCLUSTERED0000never2026-09-06 04:42:48UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_RouteStatus13NONCLUSTERED0000never2026-09-06 04:42:50UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.IX_ForecastMonthly14NONCLUSTERED0000never2026-09-06 04:42:52UNUSEDreview, then DROP
ASSET.emp.ForecastQueue.PK_CustomerHistory1CLUSTEREDYY0000never2026-09-06 04:42:45UNUSEDKEEP — primary key
ASSET.emp.ForecastQueue.IX_ForecastMonthly2NONCLUSTEREDY0000never2026-09-06 04:42:53UNUSEDreview carefully — unique
ASSET.emp.ShipmentArchive.PK_ReconcileStaging1CLUSTEREDYY0000never2026-09-06 04:42:54UNUSEDKEEP — primary key
ASSET.emp.BillingEntry.PK_StaffingAudit1CLUSTEREDYY036937234772026-09-12 00:05:522026-09-11 01:04:18USEDKEEP — primary key
ASSET.emp.BillingEntry.UX_StaffingLog2NONCLUSTEREDY10180640234772026-09-12 01:03:302026-09-11 01:11:28USEDkeep — in use
ASSET.emp.BillingAudit.IX_PolicyHeader9NONCLUSTERED00023477never2026-09-11 01:11:29UNUSEDreview, then DROP
ASSET.emp.BillingAudit.PK_PolicyDetail1CLUSTEREDYY0247234772026-09-04 11:14:182026-09-11 01:11:29USEDKEEP — primary key
ASSET.emp.BillingAudit.UX_SupplierSnapshot2NONCLUSTEREDY101121030234772026-09-12 01:03:302026-09-11 01:11:29USEDkeep — in use
ASSET.emp.ShipmentStaging.PK_TerritoryStatus1CLUSTEREDYY0150102042026-08-27 07:28:292026-09-06 04:42:57USEDKEEP — primary key
ASSET.emp.ShipmentStaging.UX_RosterDaily2NONCLUSTEREDY101041000102042026-09-12 01:03:302026-09-06 04:42:57USEDkeep — in use
ASSET.emp.SalesLine.PK_CampaignResult1CLUSTEREDYY29098350367472026-09-12 01:03:402026-09-11 01:11:30USEDKEEP — primary key
ASSET.emp.LedgerSnapshot.PK_CampaignStatus1CLUSTEREDYY00046never2026-09-11 01:11:33UNUSEDKEEP — primary key
ASSET.emp.ReconcileDetail.PK_CampaignQueue1CLUSTEREDYY511150162026-09-11 15:52:082026-09-09 02:01:40USEDKEEP — primary key
ASSET.emp.PolicyStaging.PK_PolicyStaging1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.emp.ReconcileStaging.PK_ContractStaging1CLUSTEREDYY466117002026-09-11 16:03:592026-09-06 04:43:14USEDKEEP — primary key
ASSET.emp.ReconcileStaging.UX_OrdersHistory2NONCLUSTEREDY0000never2026-09-06 04:43:14UNUSEDreview carefully — unique
ASSET.emp.MeterStatus.PK_ReconcileMonthly1CLUSTEREDYY23103311322026-09-11 21:00:002026-09-09 02:01:40USEDKEEP — primary key
ASSET.emp.MeterStatus.UX_ReconcileAudit5NONCLUSTEREDY331200172026-09-11 21:00:002026-09-09 02:01:40USEDkeep — in use
ASSET.emp.PricingAudit.PK_ReconcileSnapshot1CLUSTEREDYY0002never2026-09-06 04:43:15UNUSEDKEEP — primary key
ASSET.emp.OrdersMonthly.IX_QuotaArchive5NONCLUSTEREDY000268never2026-09-11 01:11:34UNUSEDreview, then DROP
ASSET.emp.OrdersMonthly.IX_PayrollResult4NONCLUSTEREDY030102026-09-08 11:11:102026-09-11 01:11:34USEDkeep — in use
ASSET.emp.OrdersMonthly.IX_TicketSnapshot2NONCLUSTERED150224404622026-09-12 00:20:022026-09-11 01:11:34USEDkeep — in use
ASSET.emp.OrdersMonthly.IX_SettlementLine3NONCLUSTERED17404622026-09-08 11:23:392026-09-11 01:11:34USEDkeep — in use
ASSET.emp.OrdersMonthly.PK_ShipmentSnapshot1CLUSTEREDYY4266594642026-09-11 10:30:032026-09-11 01:11:34USEDKEEP — primary key
ASSET.emp.MeterAudit.PK_BatchDaily1CLUSTEREDYY0000never2026-09-06 04:43:16UNUSEDKEEP — primary key
ASSET.emp.ContractMonthly.PK_CustomerEntry1CLUSTEREDYY0000never2026-09-06 04:43:16UNUSEDKEEP — primary key
ASSET.emp.RosterQueue.PK_SettlementHistory1CLUSTEREDYY74724002026-09-11 15:51:312026-09-06 04:43:16USEDKEEP — primary key
ASSET.emp.TicketAudit.IX_LedgerLog2NONCLUSTERED00010never2026-09-11 01:11:34UNUSEDreview, then DROP
ASSET.emp.TicketAudit.PK_LedgerStatus1CLUSTEREDYY00010never2026-09-11 01:11:34UNUSEDKEEP — primary key
ASSET.emp.InvoiceResult.PK_ShipmentMonthly1CLUSTEREDYY00010never2026-09-11 01:11:34UNUSEDKEEP — primary key
ASSET.emp.CustomerLog.IX_PayrollResult20NONCLUSTERED462746210262026-09-12 01:02:412026-09-10 01:55:33USEDkeep — in use
ASSET.emp.CustomerLog.PK_StaffingDaily1CLUSTEREDYY30548297137362026-09-12 01:02:412026-09-10 01:55:33USEDKEEP — primary key
ASSET.emp.InvoiceAudit.IX_SettlementResult10NONCLUSTERED10001080252026-09-11 16:28:192026-09-06 04:43:16USEDkeep — in use
ASSET.emp.InvoiceAudit.PK_QuotaEntry1CLUSTEREDYY02685252026-09-11 02:15:022026-09-06 04:43:16USEDKEEP — primary key
ASSET.emp.MeterSummary.PK_AssetEntry1CLUSTEREDYY00025never2026-09-06 04:43:17UNUSEDKEEP — primary key
ASSET.emp.AssetSummary.PK_SupplierStaging1CLUSTEREDYY0260302026-09-11 02:15:022026-09-10 01:55:33USEDKEEP — primary key
ASSET.emp.SupplierStaging.IX_StaffingSnapshot24NONCLUSTERED16787127601922026-09-12 01:02:412026-09-11 01:11:34USEDkeep — in use
ASSET.emp.SupplierStaging.IX_MeterStaging17NONCLUSTERED1536001662026-08-24 13:30:162026-09-11 01:11:34USEDkeep — in use
ASSET.emp.SupplierStaging.IX_StaffingEntry23NONCLUSTERED000189never2026-09-11 01:11:34UNUSEDreview, then DROP
ASSET.emp.SupplierStaging.PK_PayrollMonthly1CLUSTEREDYY6577208416982112026-09-11 16:28:192026-09-11 01:11:34USEDKEEP — primary key
ASSET.emp.CustomerStatus.IX_ReconcileLine10NONCLUSTERED10637340682026-09-11 16:28:192026-09-11 01:11:35USEDkeep — in use
ASSET.emp.CustomerStatus.PK_PolicyHistory1CLUSTEREDYY060700682026-09-11 16:23:242026-09-11 01:11:35USEDKEEP — primary key
ASSET.emp.BillingAudit.PK_CustomerEntry1CLUSTEREDYY00057never2026-09-11 01:11:35UNUSEDKEEP — primary key
ASSET.emp.PolicyLine.PK_OrdersSummary1CLUSTEREDYY0126012026-09-11 16:23:242026-09-06 04:43:18USEDKEEP — primary key
ASSET.emp.RouteStaging.PK_WarehouseLine1CLUSTEREDYY012002026-09-11 10:34:122026-09-06 04:43:18USEDKEEP — primary key
ASSET.emp.CampaignMonthly.PK_OrdersArchive1CLUSTEREDYY91410102026-09-11 16:23:242026-09-06 04:43:18USEDKEEP — primary key
ASSET.emp.CatalogSnapshot.PK_ClaimHistory1CLUSTEREDYY01002026-08-19 15:27:542026-09-06 04:43:18USEDKEEP — primary key
ASSET.emp.BillingDaily.PK_CustomerLine1CLUSTEREDYY025691122026-09-11 13:33:042026-09-11 01:11:35USEDKEEP — primary key
ASSET.emp.BillingDaily.UX_LedgerDaily2NONCLUSTEREDY116001122026-09-11 13:33:042026-09-11 01:11:35USEDkeep — in use
ASSET.emp.BillingHistory.PK_TerritorySummary1CLUSTEREDYY0000never2026-09-06 04:43:18UNUSEDKEEP — primary key
ASSET.emp.SupplierHistory.PK_WarehouseMonthly1CLUSTEREDYY02401812026-09-11 02:15:022026-09-11 01:11:35USEDKEEP — primary key
ASSET.emp.ShipmentMonthly.IX_SupplierEntry12NONCLUSTERED10060010292026-09-11 16:28:192026-09-10 01:55:35USEDkeep — in use
ASSET.emp.ShipmentMonthly.IX_InvoiceStaging5NONCLUSTERED12890010292026-09-11 21:00:002026-09-10 01:55:35USEDkeep — in use
ASSET.emp.ShipmentMonthly.PK_BatchDaily1CLUSTEREDYY470108510762026-09-11 21:00:002026-09-10 01:55:35USEDKEEP — primary key
ASSET.emp.AssetDetail.PK_ReconcileResult1CLUSTEREDYY000838never2026-09-10 01:55:35UNUSEDKEEP — primary key
ASSET.emp.AssetSnapshot.IX_ForecastStatus7NONCLUSTERED142863420922026-09-12 01:02:402026-09-10 01:55:35USEDkeep — in use
ASSET.emp.AssetSnapshot.IX_SalesDaily5NONCLUSTERED250300922026-09-11 16:28:192026-09-10 01:55:35USEDkeep — in use
ASSET.emp.AssetSnapshot.PK_OrdersDetail1CLUSTEREDYY2501922026-09-09 09:11:002026-09-10 01:55:35USEDKEEP — primary key
ASSET.emp.PricingStatus.PK_PolicyStatus1CLUSTEREDYY00087never2026-09-10 01:55:35UNUSEDKEEP — primary key
ASSET.emp.TicketSnapshot.PK_CampaignQueue1CLUSTEREDYY21278224801812026-09-12 01:02:402026-09-10 01:55:35USEDKEEP — primary key
ASSET.emp.ForecastMonthly.PK_CampaignSummary1CLUSTEREDYY02401762026-09-11 02:15:022026-09-10 01:55:36USEDKEEP — primary key
ASSET.emp.PricingStatus.IX_QuotaLog8NONCLUSTERED157001122026-09-11 07:30:002026-09-10 01:55:36USEDkeep — in use
ASSET.emp.PricingStatus.IX_ClaimEntry6NONCLUSTERED15576136201122026-09-12 01:02:402026-09-10 01:55:36USEDkeep — in use
ASSET.emp.PricingStatus.PK_LedgerResult1CLUSTEREDYY48412921571122026-09-11 13:32:502026-09-10 01:55:36USEDKEEP — primary key
ASSET.emp.PayrollHistory.PK_LedgerQueue1CLUSTEREDYY000107never2026-09-10 01:55:36UNUSEDKEEP — primary key
ASSET.emp.QuotaSummary.IX_StaffingQueue10NONCLUSTERED9993980252026-09-11 16:28:192026-09-06 04:43:20USEDkeep — in use
ASSET.emp.QuotaSummary.PK_LedgerEntry1CLUSTEREDYY036375252026-09-11 15:10:002026-09-06 04:43:20USEDKEEP — primary key
ASSET.emp.PricingQueue.PK_PricingStaging1CLUSTEREDYY00025never2026-09-06 04:43:20UNUSEDKEEP — primary key
ASSET.emp.BookingMonthly.IX_ShipmentAudit5NONCLUSTERED7006335310792026-09-12 01:02:402026-09-11 01:11:36USEDkeep — in use
ASSET.emp.BookingMonthly.PK_WarehouseLog1CLUSTEREDYY00079never2026-09-11 01:11:35UNUSEDKEEP — primary key
ASSET.emp.MeterSnapshot.PK_StaffingSummary1CLUSTEREDYY00079never2026-09-11 01:11:36UNUSEDKEEP — primary key
ASSET.emp.BatchMonthly.PK_InvoiceDetail1CLUSTEREDYY211951942301172026-09-12 01:02:402026-09-11 01:11:36USEDKEEP — primary key
ASSET.emp.StaffingAudit.PK_ForecastHeader1CLUSTEREDYY02401262026-09-11 02:15:022026-09-11 01:11:36USEDKEEP — primary key
ASSET.emp.BatchLog.PK_SalesDetail1CLUSTEREDYY363899602602026-09-12 01:02:402026-09-11 01:11:36USEDKEEP — primary key
ASSET.emp.RouteHistory.PK_MeterEntry1CLUSTEREDYY000260never2026-09-11 01:11:36UNUSEDKEEP — primary key
ASSET.emp.CampaignResult.IX_ClaimStatus14NONCLUSTERED11396217010662026-09-12 01:02:412026-09-08 01:14:37USEDkeep — in use
ASSET.emp.CampaignResult.IX_ForecastAudit8NONCLUSTERED02021112026-09-10 10:29:462026-09-08 01:14:37USEDkeep — in use
ASSET.emp.CampaignResult.IX_CustomerQueue13NONCLUSTERED150210021322026-09-12 01:02:412026-09-08 01:14:37USEDkeep — in use
ASSET.emp.CampaignResult.PK_StaffingArchive1CLUSTEREDYY1607910672529621502026-09-12 01:02:412026-09-08 01:14:37USEDKEEP — primary key
ASSET.emp.SalesHeader.IX_BookingSummary2NONCLUSTERED000412never2026-09-11 01:11:40UNUSEDreview, then DROP
ASSET.emp.SalesHeader.PK_CatalogQueue1CLUSTEREDYY000412never2026-09-11 01:11:40UNUSEDKEEP — primary key
ASSET.emp.PayrollHistory.PK_CampaignStaging1CLUSTEREDYY2121294072026-09-11 23:27:022026-09-09 02:01:50USEDKEEP — primary key
ASSET.emp.TerritoryDaily.PK_RouteArchive1CLUSTEREDYY0007never2026-09-09 02:01:50UNUSEDKEEP — primary key
ASSET.emp.CatalogSummary.IX_PricingSnapshot25NONCLUSTERED20111310942026-09-12 00:20:012026-09-11 01:11:37USEDkeep — in use
ASSET.emp.CatalogSummary.IX_WarehouseSnapshot21NONCLUSTERED114113820932026-09-12 01:02:192026-09-11 01:11:37USEDkeep — in use
ASSET.emp.CatalogSummary.IX_ReconcileSummary23NONCLUSTERED506600932026-09-12 00:05:112026-09-11 01:11:37USEDkeep — in use
ASSET.emp.CatalogSummary.IX_AssetEntry26NONCLUSTERED422300942026-09-11 16:28:192026-09-11 01:11:37USEDkeep — in use
ASSET.emp.CatalogSummary.PK_ShipmentStaging1CLUSTEREDYY4483786488721122026-09-12 01:02:192026-09-11 01:11:37USEDKEEP — primary key
ASSET.emp.CatalogSummary.UX_OrdersAudit14NONCLUSTEREDY381200932026-09-12 00:20:022026-09-11 01:11:37USEDkeep — in use
ASSET.emp.CatalogSummary.UX_LedgerHistory15NONCLUSTEREDYY222100972026-09-11 16:22:492026-09-11 01:11:37USEDkeep — in use
ASSET.emp.TicketMonthly.PK_LedgerAudit1CLUSTEREDYY1822620342026-09-10 11:00:462026-09-11 01:11:38USEDKEEP — primary key
ASSET.emp.BillingQueue.IX_AssetDetail11NONCLUSTERED47101762026-09-12 01:04:102026-09-11 01:11:38USEDkeep — in use
ASSET.emp.BillingQueue.IX_ContractSummary8NONCLUSTERED21389201762026-09-12 01:04:102026-09-11 01:11:38USEDkeep — in use
ASSET.emp.BillingQueue.PK_ShipmentEntry1CLUSTEREDYY02406213551762026-09-12 01:04:102026-09-11 01:11:38USEDKEEP — primary key
ASSET.emp.CampaignResult.IX_SupplierLine14NONCLUSTERED176001092026-09-11 14:41:472026-09-11 01:11:39USEDkeep — in use
ASSET.emp.CampaignResult.PK_CustomerLine1CLUSTEREDYY0981761092026-09-11 14:41:472026-09-11 01:11:39USEDKEEP — primary key
ASSET.org.SettlementSnapshot.PK_org.SettlementSnapshot1CLUSTEREDYY078002026-09-08 15:53:522026-09-06 04:43:27USEDKEEP — primary key
ASSET.org.SettlementSnapshot.UX_BillingLine3NONCLUSTEREDY0000never2026-09-06 04:43:27UNUSEDreview carefully — unique
ASSET.org.PolicySummary.IX_AssetEntry11NONCLUSTERED24171780002026-09-11 16:28:192026-09-06 04:43:27USEDkeep — in use
ASSET.org.PolicySummary.PK_QuotaAudit1CLUSTEREDYY206353858255402026-09-11 16:28:192026-09-06 04:43:27USEDKEEP — primary key
ASSET.org.PolicySummary.UX_ForecastHistory4NONCLUSTEREDYY1370002026-09-10 08:29:372026-09-06 04:43:27USEDkeep — in use
ASSET.org.BatchMonthly.PK_WarehouseSummary1CLUSTEREDYY044002026-09-10 08:29:372026-09-06 04:43:27USEDKEEP — primary key
ASSET.org.BatchMonthly.UX_SalesSnapshot2NONCLUSTEREDYY0000never2026-09-06 04:43:27UNUSEDreview carefully — unique
ASSET.org.CampaignQueue.PK_RosterDaily1CLUSTEREDYY0000never2026-09-06 04:43:28UNUSEDKEEP — primary key
ASSET.org.TicketLog.PK_WarehouseDetail1CLUSTEREDYY341617322026-09-11 15:51:272026-09-06 04:43:28USEDKEEP — primary key
ASSET.org.TicketLog.UX_SalesMonthly4NONCLUSTEREDY1700322026-09-11 15:51:252026-09-11 01:11:40USEDkeep — in use
ASSET.org.BatchDaily.PK_QuotaStaging1CLUSTEREDYY2015940666002026-09-12 01:04:002026-09-06 04:43:28USEDKEEP — primary key
ASSET.org.BatchDaily.UX_PricingResult7NONCLUSTEREDYY0000never2026-09-06 04:43:28UNUSEDreview carefully — unique
ASSET.org.ShipmentAudit.PK_ForecastHeader1CLUSTEREDYY10259741413923102026-09-12 01:04:002026-09-06 04:43:28USEDKEEP — primary key
ASSET.org.ShipmentAudit.UX_BatchArchive2NONCLUSTEREDY141241116020102026-09-12 01:04:002026-09-10 01:55:40USEDkeep — in use
ASSET.org.WarehouseStaging.PK_MeterHistory1CLUSTEREDYY00010never2026-09-10 01:55:40UNUSEDKEEP — primary key
ASSET.org.BookingResult.PK_BillingQueue1CLUSTEREDYY0000never2026-09-06 04:43:28UNUSEDKEEP — primary key
ASSET.org.InvoiceQueue.PK_TicketEntry1CLUSTEREDYY5786002026-09-09 13:26:502026-09-06 04:43:28USEDKEEP — primary key
ASSET.org.PricingStatus.PK_TerritoryStatus1CLUSTEREDYY0000never2026-09-06 04:43:28UNUSEDKEEP — primary key
ASSET.org.CatalogHeader.PK_ShiftStatus1CLUSTEREDYY17902010292026-09-12 01:02:192026-09-06 04:43:28USEDKEEP — primary key
ASSET.org.PolicySummary.PK_CatalogQueue1CLUSTEREDYY00028never2026-09-10 01:55:40UNUSEDKEEP — primary key
ASSET.org.CatalogAudit.PK_AssetStatus1CLUSTEREDYY0000never2026-09-06 04:43:29UNUSEDKEEP — primary key
ASSET.org.OrdersSummary.PK_StaffingAudit1CLUSTEREDYY029002026-09-11 09:36:232026-09-06 04:43:29USEDKEEP — primary key
ASSET.org.ContractResult.PK_PolicyLine1CLUSTEREDYY0000never2026-09-06 04:43:29UNUSEDKEEP — primary key
ASSET.org.SupplierHistory.IX_ShipmentSummary2NONCLUSTERED0000never2026-09-06 04:43:29UNUSEDreview, then DROP
ASSET.org.SupplierHistory.PK_CustomerDetail1CLUSTEREDYY013002026-08-27 09:21:162026-09-06 04:43:29USEDKEEP — primary key
ASSET.org.ContractStaging.PK_CatalogDetail1CLUSTEREDYY0000never2026-09-06 04:43:29UNUSEDKEEP — primary key
ASSET.org.BatchSummary.PK_SettlementHistory1CLUSTEREDYY0000never2026-09-06 04:43:29UNUSEDKEEP — primary key
ASSET.org.BillingHeader.IX_ShiftHistory2NONCLUSTERED0000never2026-09-06 04:43:29UNUSEDreview, then DROP
ASSET.org.BillingHeader.PK_InvoiceMonthly1CLUSTEREDYY05002026-08-27 09:21:162026-09-06 04:43:29USEDKEEP — primary key
ASSET.org.ShipmentSummary.IX_StaffingResult2NONCLUSTERED0000never2026-09-06 04:43:29UNUSEDreview, then DROP
ASSET.org.ShipmentSummary.PK_ClaimDetail1CLUSTEREDYY05002026-08-27 09:21:162026-09-06 04:43:29USEDKEEP — primary key
ASSET.org.SalesStatus.IX_ClaimHeader2NONCLUSTEREDY50002026-08-27 09:21:162026-09-06 04:43:29USEDkeep — in use
ASSET.org.SalesStatus.PK_CampaignSnapshot1CLUSTEREDYY00502026-08-27 09:21:162026-09-06 04:43:29USEDKEEP — primary key
ASSET.org.PolicyResult.PK_ForecastStaging1CLUSTEREDYY136675206002026-09-12 01:02:222026-09-06 04:43:29USEDKEEP — primary key
ASSET.org.AssetSummary.PK_TicketStaging1CLUSTEREDYY1431715002026-09-11 16:26:162026-09-06 04:43:29USEDKEEP — primary key
ASSET.org.AssetSummary.UX_ShipmentSummary4NONCLUSTEREDY0000never2026-09-06 04:43:29UNUSEDreview carefully — unique
ASSET.org.ShipmentQueue.PK_InvoiceStaging1CLUSTEREDYY388946600052026-09-12 01:03:282026-09-06 04:43:29USEDKEEP — primary key
ASSET.org.PolicyEntry.PK_SettlementSnapshot1CLUSTEREDYY1627320252026-09-12 00:20:022026-09-06 04:43:29USEDKEEP — primary key
ASSET.org.PolicyEntry.UX_ShiftSnapshot5NONCLUSTEREDYY00023never2026-09-09 02:01:56UNUSEDreview carefully — unique
ASSET.org.MeterAudit.IX_WarehouseQueue3NONCLUSTERED630002026-09-12 00:20:022026-09-09 09:47:32USEDkeep — in use
ASSET.org.MeterAudit.PK_BillingDetail1CLUSTEREDYY511350232026-09-09 07:19:362026-09-09 02:01:56USEDKEEP — primary key
ASSET.org.BillingHeader.PK_ContractStaging1CLUSTEREDYY0000never2026-09-06 04:43:30UNUSEDKEEP — primary key
ASSET.org.TicketSnapshot.PK_ForecastSnapshot1CLUSTEREDYY0000never2026-09-06 04:43:30UNUSEDKEEP — primary key
ASSET.org.CustomerStaging.PK_CustomerHeader1CLUSTEREDYY010232026-09-03 09:42:462026-09-09 02:01:56USEDKEEP — primary key
ASSET.org.KPI.PK_ShiftLine1CLUSTEREDYY0000never2026-09-06 04:43:30UNUSEDKEEP — primary key
ASSET.org.KPI.UX_ShiftHeader4NONCLUSTEREDYY0000never2026-09-06 04:43:30UNUSEDreview carefully — unique
ASSET.org.StaffingArchive.PK_SettlementResult1CLUSTEREDYY078002026-09-08 15:53:522026-09-06 04:43:30USEDKEEP — primary key
ASSET.org.CustomerEntry.PK_RouteSummary1CLUSTEREDYY0000never2026-09-06 04:43:30UNUSEDKEEP — primary key
ASSET.org.PricingDaily.PK_CampaignArchive1CLUSTEREDYY0000never2026-09-06 04:43:30UNUSEDKEEP — primary key
ASSET.org.PricingDaily.UX_BillingArchive5NONCLUSTEREDY0000never2026-09-06 04:43:30UNUSEDreview carefully — unique
ASSET.org.TicketLine.PK_SupplierMonthly1CLUSTEREDYY0000never2026-09-06 04:43:30UNUSEDKEEP — primary key
ASSET.org.BillingArchive.PK_MeterSummary1CLUSTEREDYY0000never2026-09-06 04:43:30UNUSEDKEEP — primary key
ASSET.org.MeterEntry.PK_SupplierLog1CLUSTEREDYY0000never2026-09-06 04:43:30UNUSEDKEEP — primary key
ASSET.org.ReconcileAudit.PK_PolicyLog1CLUSTEREDYY102272012026-09-11 16:28:192026-09-06 04:43:30USEDKEEP — primary key
ASSET.org.ReconcileAudit.UQ_ShipmentResult2NONCLUSTEREDYY70012026-08-29 10:20:352026-09-06 04:43:30USEDkeep — in use
ASSET.org.StaffingAudit.PK_RosterArchive1CLUSTEREDYY0007never2026-09-06 04:43:30UNUSEDKEEP — primary key
ASSET.org.ShiftResult.PK_AssetAudit1CLUSTEREDYY6337629005072026-09-12 01:03:522026-09-06 04:43:30USEDKEEP — primary key
ASSET.org.BatchMonthly.PK_SalesLine1CLUSTEREDYY12147450242026-09-12 00:05:062026-09-06 04:43:31USEDKEEP — primary key
ASSET.org.RosterMonthly.IX_AssetDetail2NONCLUSTERED00010never2026-09-06 04:43:31UNUSEDreview, then DROP
ASSET.org.RosterMonthly.PK_ForecastDaily1CLUSTEREDYY5146470102026-09-12 00:05:062026-09-06 04:43:31USEDKEEP — primary key
ASSET.org.InvoiceStaging.IX_AssetAudit2NONCLUSTERED00010never2026-09-06 04:43:31UNUSEDreview, then DROP
ASSET.org.InvoiceStaging.PK_CustomerMonthly1CLUSTEREDYY00010never2026-09-06 04:43:31UNUSEDKEEP — primary key
ASSET.org.StaffingAudit.PK_AssetLog1CLUSTEREDYY0007never2026-09-06 04:43:31UNUSEDKEEP — primary key
ASSET.org.Level.PK_ShiftStaging1CLUSTEREDYY965364002026-09-11 16:28:192026-09-06 04:43:31USEDKEEP — primary key
ASSET.org.Level.UX_SettlementHistory2NONCLUSTEREDYY1628002026-09-05 10:32:592026-09-06 04:43:31USEDkeep — in use
ASSET.org.ContractHistory.PK_RouteArchive1CLUSTEREDYY0000never2026-09-06 04:43:31UNUSEDKEEP — primary key
ASSET.org.QuotaEntry.IX_AssetHistory2NONCLUSTERED110392026-08-28 12:33:312026-09-06 04:43:31USEDkeep — in use
ASSET.org.QuotaEntry.PK_LedgerQueue1CLUSTEREDYY2098382392026-09-12 01:03:292026-09-06 04:43:31USEDKEEP — primary key
ASSET.org.ClaimQueue.PK_LedgerHistory1CLUSTEREDYY00019never2026-09-06 04:43:31UNUSEDKEEP — primary key
ASSET.org.SupplierLine.PK_CatalogStaging1CLUSTEREDYY23364002026-09-09 13:20:462026-09-06 04:43:31USEDKEEP — primary key
ASSET.org.InvoiceHistory.PK_BillingLog1CLUSTEREDYY0000never2026-09-06 04:43:32UNUSEDKEEP — primary key
ASSET.org.AssetHeader.IX_PayrollAudit2NONCLUSTERED23360002026-09-09 13:20:462026-09-06 04:43:32USEDkeep — in use
ASSET.org.AssetHeader.PK_LedgerResult1CLUSTEREDYY510002026-09-04 09:48:262026-09-06 04:43:32USEDKEEP — primary key
ASSET.org.TerritoryStatus.PK_PayrollLine1CLUSTEREDYY0000never2026-09-06 04:43:32UNUSEDKEEP — primary key
ASSET.org.RosterLine.PK_LedgerStaging1CLUSTEREDYY0000never2026-09-06 04:43:32UNUSEDKEEP — primary key
ASSET.org.ForecastArchive.PK_PricingHistory1CLUSTEREDYY07002026-09-10 08:04:522026-09-06 04:43:32USEDKEEP — primary key
ASSET.org.PolicySummary.PK_ForecastQueue1CLUSTEREDYY0584002026-09-09 13:20:462026-09-06 04:43:32USEDKEEP — primary key
ASSET.org.ClaimMonthly.PK_BookingDetail1CLUSTEREDYY0000never2026-09-06 04:43:32UNUSEDKEEP — primary key
ASSET.org.OrdersEntry.PK_MeterDaily1CLUSTEREDYY3956062026-09-09 13:57:282026-09-09 02:01:56USEDKEEP — primary key
ASSET.org.LedgerStaging.PK_BatchLine1CLUSTEREDYY0006never2026-09-10 01:55:40UNUSEDKEEP — primary key
ASSET.org.Position.PK_PolicySummary1CLUSTEREDYY1455021520252026-09-12 00:20:022026-09-06 04:43:32USEDKEEP — primary key
ASSET.org.Position.UX_MeterArchive5NONCLUSTEREDYY00025never2026-09-09 02:01:56UNUSEDreview carefully — unique
ASSET.org.CampaignQueue.PK_BillingArchive1CLUSTEREDYY7838016722026-09-11 09:35:042026-09-06 04:43:32USEDKEEP — primary key
ASSET.org.CampaignQueue.UX_TicketDaily2NONCLUSTEREDY2359106022026-09-11 16:28:192026-09-06 04:43:32USEDkeep — in use
ASSET.org.MeterResult.PK_CatalogStaging1CLUSTEREDYY0008never2026-09-06 04:43:33UNUSEDKEEP — primary key
ASSET.org.QuotaLine.PK_AssetAudit1CLUSTEREDYY532240552026-09-08 15:54:082026-09-09 02:01:57USEDKEEP — primary key
ASSET.org.QuotaLine.UX_PricingAudit2NONCLUSTEREDYY00055never2026-09-09 02:01:57UNUSEDreview carefully — unique
ASSET.org.PayrollLog.PK_PayrollAudit1CLUSTEREDYY0878412026-09-08 13:05:512026-09-06 04:43:33USEDKEEP — primary key
ASSET.org.PayrollLog.UX_PayrollDetail2NONCLUSTEREDY840012026-09-08 13:05:512026-09-06 04:43:33USEDkeep — in use
ASSET.org.LedgerDaily.PK_ContractHeader1CLUSTEREDYY00025never2026-09-09 02:01:57UNUSEDKEEP — primary key
ASSET.org.PricingArchive.PK_ShiftStatus1CLUSTEREDYY0000never2026-09-06 04:43:33UNUSEDKEEP — primary key
ASSET.org.PricingArchive.UX_InvoiceAudit4NONCLUSTEREDY0000never2026-09-06 04:43:33UNUSEDreview carefully — unique
ASSET.org.ForecastAudit.PK_WarehouseSnapshot1CLUSTEREDYY079002026-09-11 15:51:242026-09-06 04:43:33USEDKEEP — primary key
ASSET.org.ForecastAudit.UX_ClaimArchive2NONCLUSTEREDY0000never2026-09-06 04:43:33UNUSEDreview carefully — unique
ASSET.org.PayrollLine.PK_OrdersHistory1CLUSTEREDYY0124002026-09-11 15:51:242026-09-06 04:43:33USEDKEEP — primary key
ASSET.org.PayrollLine.UX_ShiftLog2NONCLUSTEREDY0240002026-08-27 07:28:302026-09-06 04:43:33USEDkeep — in use
ASSET.org.BookingStaging.PK_AssetResult1CLUSTEREDYY4073795500302026-09-12 01:03:522026-09-06 04:43:33USEDKEEP — primary key
ASSET.org.ReconcileLine.PK_CustomerLog1CLUSTEREDYY020102026-08-27 14:13:582026-09-10 01:55:40USEDKEEP — primary key
ASSET.org.ShiftStaging.PK_BillingHistory1CLUSTEREDYY0000never2026-09-06 04:43:34UNUSEDKEEP — primary key
ASSET.org.ShiftStaging.UQ_PolicyAudit2NONCLUSTEREDY0000never2026-09-06 04:43:34UNUSEDreview carefully — unique
ASSET.org.CustomerLine.IX_ForecastLine3NONCLUSTERED0000never2026-09-06 04:43:34UNUSEDreview, then DROP
ASSET.org.CustomerLine.PK_LedgerEntry1CLUSTEREDYY097002026-09-11 09:36:232026-09-06 04:43:34USEDKEEP — primary key
ASSET.org.CustomerLine.UQ_PayrollLog2NONCLUSTEREDY0000never2026-09-06 04:43:34UNUSEDreview carefully — unique
ASSET.org.InvoiceMonthly.PK_WarehouseQueue1CLUSTEREDYY0000never2026-09-06 04:43:34UNUSEDKEEP — primary key
ASSET.org.InvoiceMonthly.UQ_MeterAudit2NONCLUSTEREDY0000never2026-09-06 04:43:34UNUSEDreview carefully — unique
ASSET.org.QuotaStaging.PK_ShiftStaging1CLUSTEREDYY081402026-09-11 09:36:232026-09-06 04:43:34USEDKEEP — primary key
ASSET.org.QuotaStaging.UQ_ShiftMonthly2NONCLUSTEREDY140002026-09-11 09:36:232026-09-06 04:43:34USEDkeep — in use
ASSET.org.BatchMonthly.PK_WarehouseHeader1CLUSTEREDYY097002026-09-11 09:36:232026-09-06 04:43:34USEDKEEP — primary key
ASSET.org.BatchMonthly.UQ_LedgerStaging2NONCLUSTEREDY0000never2026-09-06 04:43:34UNUSEDreview carefully — unique
ASSET.org.ClaimHeader.PK_ClaimArchive1CLUSTEREDYY0000never2026-09-06 04:43:34UNUSEDKEEP — primary key
ASSET.org.SupplierResult.PK_ForecastQueue1CLUSTEREDYY216416002026-09-11 16:26:162026-09-06 04:43:34USEDKEEP — primary key
ASSET.org.RouteSummary.PK_RosterAudit1CLUSTEREDYY0000never2026-09-06 04:43:34UNUSEDKEEP — primary key
ASSET.org.RouteSummary.UX_SupplierSummary2NONCLUSTEREDYY0000never2026-09-06 04:43:34UNUSEDreview carefully — unique
ASSET.org.ClaimDetail.PK_RouteMonthly1CLUSTEREDYY0000never2026-09-06 04:43:34UNUSEDKEEP — primary key
ASSET.org.ShiftResult.PK_ForecastEntry1CLUSTEREDYY1581211175512452026-09-12 01:02:192026-09-11 01:11:40USEDKEEP — primary key
ASSET.org.ShiftResult.UX_LedgerStaging7NONCLUSTEREDY17566002452026-09-12 01:02:192026-09-11 01:11:40USEDkeep — in use
ASSET.org.QuotaResult.PK_CampaignDaily1CLUSTEREDYY18941663312026-09-12 01:02:192026-09-06 04:43:34USEDKEEP — primary key
ASSET.org.QuotaResult.UX_BatchDaily5NONCLUSTEREDY30012026-09-04 11:21:352026-09-06 04:43:34USEDkeep — in use
ASSET.org.QuotaDetail.PK_WarehouseMonthly1CLUSTEREDYY8503910172026-09-12 01:02:402026-09-06 04:43:34USEDKEEP — primary key
ASSET.org.BookingLog.PK_MeterStaging1CLUSTEREDYY00017never2026-09-06 04:43:34UNUSEDKEEP — primary key
ASSET.org.SettlementAudit.PK_InvoiceSnapshot1CLUSTEREDYY0003never2026-09-06 04:43:34UNUSEDKEEP — primary key
ASSET.oth.QuotaSummary.PK_QuotaDetail1CLUSTEREDYY04002026-09-08 08:21:372026-09-06 04:43:35USEDKEEP — primary key
ASSET.oth.InvoiceStatus.PK_ShiftQueue1CLUSTEREDYY753002026-09-12 00:00:002026-09-06 04:43:35USEDKEEP — primary key
ASSET.oth.SupplierLine.PK_QuotaDetail1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.oth.SupplierLine.UX_InvoiceHeader2NONCLUSTEREDY0000never2026-09-06 04:43:36UNUSEDreview carefully — unique
ASSET.oth.StaffingArchive.IX_InvoiceStaging2NONCLUSTERED0000never2026-09-06 04:43:36UNUSEDreview, then DROP
ASSET.oth.StaffingArchive.PK_PricingAudit1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.oth.StaffingArchive.UQ_SalesAudit3NONCLUSTEREDY16011002026-09-08 08:23:552026-09-06 04:43:36USEDkeep — in use
ASSET.oth.CustomerQueue.IX_WarehouseResult2NONCLUSTERED1604002026-09-08 08:23:562026-09-06 04:43:36USEDkeep — in use
ASSET.oth.CustomerQueue.PK_TerritoryResult1CLUSTEREDYY0320002026-09-08 08:23:562026-09-06 04:43:36USEDKEEP — primary key
ASSET.rec.SettlementQueue.PK_BookingArchive1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.SettlementQueue.UX_CatalogLine2NONCLUSTEREDY0000never2026-09-06 04:43:36UNUSEDreview carefully — unique
ASSET.rec.AssetEntry.PK_BatchArchive1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.ShipmentDetail.PK_QuotaResult1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.ShipmentDetail.UX_SalesLog2NONCLUSTEREDY0000never2026-09-06 04:43:36UNUSEDreview carefully — unique
ASSET.rec.CustomerLine.PK_ShiftStaging1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.SettlementAudit.PK_PricingHeader1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.PricingResult.PK_AssetHistory1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — 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-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.MeterArchive.PK_ForecastResult1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.MeterArchive.UX_PayrollLine2NONCLUSTEREDY0000never2026-09-06 04:43:36UNUSEDreview carefully — unique
ASSET.rec.PayrollStatus.PK_ForecastMonthly1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.CampaignStatus.PK_InvoiceHistory1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.ReconcileStatus.PK_BatchDaily1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.ShipmentMonthly.PK_ContractEntry1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.rec.ForecastSummary.PK_ReconcileLog1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.CustomerDetail.PK_SalesSnapshot1CLUSTEREDYY0000never2026-09-06 04:43:36UNUSEDKEEP — primary key
ASSET.rec.AssetSnapshot.PK_PolicyResult1CLUSTEREDYY014002026-09-08 08:52:332026-09-06 04:43:36USEDKEEP — primary key
ASSET.rec.AssetSnapshot.UX_ContractArchive2NONCLUSTEREDY0000never2026-09-06 04:43:36UNUSEDreview carefully — unique
ASSET.rec.CustomerQueue.PK_InvoiceLog1CLUSTEREDYY02002026-09-08 08:22:122026-09-06 04:43:36USEDKEEP — primary key
ASSET.rec.BatchSnapshot.PK_TicketLine1CLUSTEREDYY0000never2026-09-06 04:43:37UNUSEDKEEP — primary key
ASSET.rec.StaffingLine.PK_RosterSnapshot1CLUSTEREDYY0000never2026-09-06 04:43:37UNUSEDKEEP — primary key
ASSET.rec.LedgerStatus.PK_InvoiceDetail1CLUSTEREDYY0000never2026-09-06 04:43:37UNUSEDKEEP — primary key
ASSET.sal.SalesHistory.PK_QuotaLine1CLUSTEREDYY0000never2026-09-06 04:43:37UNUSEDKEEP — primary key
ASSET.sal.ClaimArchive.IX_RouteDetail2NONCLUSTERED0000never2026-09-06 04:43:37UNUSEDreview, then DROP
ASSET.sal.ClaimArchive.PK_LedgerHeader1CLUSTEREDYY0000never2026-09-06 04:43:37UNUSEDKEEP — primary key
ASSET.sal.QuotaLine.PK_ContractArchive1CLUSTEREDYY235286002026-09-12 01:04:002026-09-06 04:43:37USEDKEEP — primary key
ASSET.sal.SalesStatus.PK_ShiftMonthly1CLUSTEREDYY1914270302026-09-11 23:27:022026-09-06 04:43:37USEDKEEP — primary key
ASSET.sal.SettlementQueue.PK_StaffingSnapshot1CLUSTEREDYY0455046492026-09-11 23:27:022026-09-06 04:43:37USEDKEEP — primary key
ASSET.sal.MeterHistory.PK_LedgerSnapshot1CLUSTEREDYY012046492026-08-22 16:02:182026-09-06 04:43:38USEDKEEP — primary key
ASSET.sal.ShipmentAudit.PK_BatchDaily1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
ASSET.sal.RouteResult.PK_OrdersAudit1CLUSTEREDYY079002026-08-27 07:54:152026-09-06 04:43:38USEDKEEP — primary key
ASSET.sal.RouteResult.UX_ContractEntry2NONCLUSTEREDY0000never2026-09-06 04:43:38UNUSEDreview carefully — unique
ASSET.sal.WarehouseDaily.PK_SettlementDetail1CLUSTEREDYY5103529142026-09-11 14:39:402026-09-06 04:43:38USEDKEEP — primary key
ASSET.sal.WarehouseDaily.UX_BookingAudit2NONCLUSTEREDY900142026-09-10 15:03:202026-09-06 04:43:38USEDkeep — in use
ASSET.sal.InvoiceLog.PK_MeterAudit1CLUSTEREDYY1047801042026-08-27 07:54:152026-09-06 04:43:38USEDKEEP — primary key
ASSET.sal.PolicySnapshot.PK_ReconcileQueue1CLUSTEREDYY000104never2026-09-06 04:43:38UNUSEDKEEP — primary key
ASSET.sal.SettlementStatus.PK_ReconcileResult1CLUSTEREDYY10411335310442026-09-11 08:49:362026-09-06 04:43:39USEDKEEP — primary key
ASSET.sal.SettlementStatus.UX_StaffingMonthly2NONCLUSTEREDY530010442026-09-11 08:49:362026-09-06 04:43:39USEDkeep — in use
ASSET.sal.ReconcileHistory.PK_PayrollHeader1CLUSTEREDYY917801822026-08-27 07:54:152026-09-06 04:43:39USEDKEEP — primary key
ASSET.sal.ReconcileHistory.UX_TicketQueue2NONCLUSTEREDY000182never2026-09-06 04:43:39UNUSEDreview carefully — unique
ASSET.sal.InvoiceEntry.PK_RouteQueue1CLUSTEREDYY000182never2026-09-06 04:43:39UNUSEDKEEP — primary key
ASSET.sal.BillingQueue.PK_ReconcileHistory1CLUSTEREDYY0001044never2026-09-06 04:43:39UNUSEDKEEP — primary key
ASSET.sal.RosterDetail.PK_BookingStaging1CLUSTEREDYY00014never2026-09-06 04:43:39UNUSEDKEEP — primary key
ASSET.sal.RosterQueue.PK_ShiftQueue1CLUSTEREDYY054002026-09-11 09:36:232026-09-06 04:43:39USEDKEEP — primary key
ASSET.sal.RosterQueue.UX_RosterArchive2NONCLUSTEREDY0000never2026-09-06 04:43:39UNUSEDreview carefully — unique
ASSET.sal.WarehouseHeader.PK_RouteEntry1CLUSTEREDYY0139002026-09-12 00:05:122026-09-06 04:43:39USEDKEEP — primary key
ASSET.sal.SupplierArchive.PK_SupplierStaging1CLUSTEREDYY0294002026-09-11 23:27:032026-09-06 04:43:39USEDKEEP — primary key
ASSET.sal.RosterQueue.PK_PolicyLog1CLUSTEREDYY0000never2026-09-06 04:43:40UNUSEDKEEP — primary key
ASSET.sal.CustomerSnapshot.PK_RosterEntry1CLUSTEREDYY0294002026-09-11 23:27:032026-09-06 04:43:40USEDKEEP — primary key
ASSET.sal.LedgerStatus.PK_WarehouseStaging1CLUSTEREDYY0000never2026-09-06 04:43:40UNUSEDKEEP — primary key
ASSET.sal.BookingLine.PK_PricingAudit1CLUSTEREDYY0000never2026-09-06 04:43:40UNUSEDKEEP — primary key
ASSET.sal.PricingLine.PK_BatchLine1CLUSTEREDYY0000never2026-09-06 04:43:40UNUSEDKEEP — primary key
ASSET.sal.WarehouseStaging.PK_SettlementHistory1CLUSTEREDYY0000never2026-09-06 04:43:40UNUSEDKEEP — primary key
ASSET.sal.StaffingArchive.PK_CatalogLine1CLUSTEREDYY0000never2026-09-06 04:43:40UNUSEDKEEP — primary key
ASSET.sal.WarehouseSummary.PK_RosterArchive1CLUSTEREDYY0000never2026-09-06 04:43:40UNUSEDKEEP — primary key
ASSET.schedule.CustomerDetail.PK_CatalogStaging1CLUSTEREDYY04921326002026-09-12 01:02:192026-09-06 04:43:40USEDKEEP — primary key
ASSET.schedule.CustomerDetail.UQ_BillingSnapshot2NONCLUSTEREDY12828404002026-09-12 01:02:192026-09-06 04:43:40USEDkeep — in use
ASSET.schedule.CustomerDetail.UQ_CampaignResult3NONCLUSTEREDY15404366002026-09-12 01:02:192026-09-06 04:43:40USEDkeep — in use
ASSET.schedule.InvoiceHistory.IX_StaffingHeader3NONCLUSTERED01002026-08-22 08:13:532026-09-06 04:43:40USEDkeep — in use
ASSET.schedule.InvoiceHistory.PK_ContractLog1CLUSTEREDYY02002026-08-22 14:42:052026-09-06 04:43:40USEDKEEP — primary key
ASSET.schedule.InvoiceHistory.UQ_LedgerResult2NONCLUSTEREDY0000never2026-09-06 04:43:40UNUSEDreview carefully — unique
ASSET.schedule.MeterStaging.PK_SettlementMonthly1CLUSTEREDYY266291015982026-09-12 01:03:282026-09-06 04:43:42USEDKEEP — primary key
ASSET.schedule.SettlementLine.PK_CampaignStatus1CLUSTEREDYY2705944204562026-09-12 01:02:192026-09-06 04:43:42USEDKEEP — primary key
ASSET.schedule.TicketEntry.PK_CampaignDaily1CLUSTEREDYY168604562026-09-12 01:02:192026-09-06 04:43:43USEDKEEP — primary key
ASSET.schedule.QuotaSummary.PK_LedgerStatus1CLUSTEREDYY4686022700692026-09-12 01:02:192026-09-06 04:43:43USEDKEEP — primary key
ASSET.schedule.ShipmentLog.PK_SalesEntry1CLUSTEREDYY1812119032032026-09-12 01:02:222026-09-12 01:02:21USEDKEEP — primary key
ASSET.schedule.PricingResult.PK_CampaignDaily1CLUSTEREDYY13058109102282026-09-12 01:02:192026-09-06 04:43:43USEDKEEP — primary key
ASSET.schedule.SupplierSnapshot.IX_BillingHeader12NONCLUSTERED540813990644372026-09-12 01:03:512026-09-12 01:00:38USEDkeep — in use
ASSET.schedule.SupplierSnapshot.PK_AssetStatus1CLUSTEREDYY97576108740226794742026-09-12 01:03:512026-09-12 01:00:37USEDKEEP — primary key
ASSET.schedule.SupplierSnapshot.IX_ContractLog2NONCLUSTEREDY380268562026-09-10 16:19:212026-09-12 01:00:38USEDkeep — in use
ASSET.schedule.BatchDetail.PK_AssetDetail1CLUSTEREDYY2320151013702026-09-01 01:02:172026-09-06 04:43:51USEDKEEP — primary key
ASSET.schedule.RosterSummary.IX_BatchDetail3NONCLUSTERED12453160507332026-09-12 01:02:182026-09-11 20:26:55USEDkeep — in use
ASSET.schedule.RosterSummary.IX_ClaimHeader2NONCLUSTERED2542444310507332026-09-12 01:02:482026-09-11 20:26:55USEDkeep — in use
ASSET.schedule.RosterSummary.PK_CustomerAudit1CLUSTEREDYY850285109534171010422026-09-12 01:03:042026-09-11 20:26:55USEDKEEP — primary key
ASSET.schedule.BillingDetail.IX_TicketHeader2NONCLUSTERED408466154602010472026-09-12 01:03:182026-09-12 01:02:42USEDkeep — in use
ASSET.schedule.BillingDetail.PK_BillingLog1CLUSTEREDYY1216960193184822386702026-09-12 01:03:552026-09-12 01:02:41USEDKEEP — primary key
ASSET.schedule.PolicyStatus.IX_ForecastAudit2NONCLUSTERED240258004263842026-09-12 01:03:272026-09-12 01:03:18USEDkeep — in use
ASSET.schedule.PolicyStatus.IX_SupplierLine3NONCLUSTERED28508071304263842026-09-12 01:03:242026-09-12 01:03:18USEDkeep — in use
ASSET.schedule.PolicyStatus.PK_PricingDaily1CLUSTEREDYY5086231731750964263842026-09-12 01:03:282026-09-12 01:03:17USEDKEEP — primary key
ASSET.schedule.PolicyLine.IX_TerritorySnapshot2NONCLUSTERED3413069660436932026-09-12 01:03:242026-09-11 20:27:05USEDkeep — in use
ASSET.schedule.PolicyLine.PK_BookingAudit1CLUSTEREDYY20669354911382813042026-09-12 01:03:182026-09-11 20:27:05USEDKEEP — primary key
ASSET.schedule.AssetResult.IX_BillingResult2NONCLUSTERED2566200256622026-09-12 01:02:18neverUSEDkeep — in use
ASSET.schedule.AssetResult.PK_TicketQueue1CLUSTEREDYY00025662neverneverUNUSEDKEEP — primary key
ASSET.schedule.InvoiceAudit.IX_StaffingQueue2NONCLUSTERED41739069701510122026-09-12 01:03:232026-09-11 20:27:03USEDkeep — in use
ASSET.schedule.InvoiceAudit.PK_LedgerMonthly1CLUSTEREDYY20633524171911566312026-09-12 01:03:192026-09-11 20:27:03USEDKEEP — primary key
ASSET.schedule.SettlementLog.IX_TicketLine2NONCLUSTERED341615204958092026-09-12 01:03:232026-09-12 01:01:15USEDkeep — in use
ASSET.schedule.SettlementLog.IX_PolicyLine3NONCLUSTERED5434671204958092026-09-12 01:02:592026-09-12 01:01:16USEDkeep — in use
ASSET.schedule.SettlementLog.PK_CatalogMonthly1CLUSTEREDYY617654051905274372026-09-12 01:03:192026-09-12 01:01:15USEDKEEP — primary key
ASSET.schedule.PricingSnapshot.IX_SettlementStatus15NONCLUSTERED0000never2026-09-06 04:48:14UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_InvoiceSummary3NONCLUSTERED0000never2026-09-06 04:48:15UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_WarehouseStaging4NONCLUSTERED0000never2026-09-06 04:48:16UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.IX_WarehouseStatus2NONCLUSTERED0000never2026-09-06 04:48:18UNUSEDreview, then DROP
ASSET.schedule.PricingSnapshot.PK_RosterEntry1CLUSTEREDYY0000never2026-09-06 04:48:12UNUSEDKEEP — primary key
ASSET.schedule.ShiftHeader.IX_TicketStatus3NONCLUSTERED1898050597842026-09-07 16:20:002026-09-12 01:00:36USEDkeep — in use
ASSET.schedule.ShiftHeader.IX_ShipmentLine4NONCLUSTERED20733000597842026-09-12 01:03:292026-09-12 01:00:37USEDkeep — in use
ASSET.schedule.ShiftHeader.PK_OrdersArchive1CLUSTEREDYY2525710629593661529802026-09-12 01:03:522026-09-12 01:00:36USEDKEEP — primary key
ASSET.schedule.ShiftHeader.IX_BookingStatus2NONCLUSTEREDY35884620597842026-09-12 01:03:522026-09-12 01:00:36USEDkeep — in use
ASSET.schedule.PolicyLine.PK_RouteQueue1CLUSTEREDYY876869332200593952026-09-12 01:04:012026-09-11 01:25:51USEDKEEP — primary key
ASSET.schedule.PolicyLine.UX_TerritoryHistory2NONCLUSTEREDYY408010302312026-08-29 09:27:362026-09-11 01:25:51USEDkeep — in use
ASSET.schedule.SalesDaily.IX_ForecastHistory2NONCLUSTERED120042026-09-10 10:30:142026-09-10 10:29:17USEDkeep — in use
ASSET.schedule.SalesDaily.IX_QuotaSummary3NONCLUSTERED0006never2026-09-10 10:29:17UNUSEDreview, then DROP
ASSET.schedule.SalesDaily.PK_ClaimResult1CLUSTEREDYY021082026-09-10 10:30:182026-09-10 10:29:17USEDKEEP — primary key
ASSET.schedule.RosterHistory.IX_AssetSummary2NONCLUSTERED12274929080300122026-09-12 01:03:052026-09-11 01:26:07USEDkeep — in use
ASSET.schedule.RosterHistory.PK_WarehouseLine1CLUSTEREDYY64343101239300122026-09-12 01:03:282026-09-11 01:26:07USEDKEEP — primary key
ASSET.schedule.ContractStaging.IX_StaffingLine2NONCLUSTERED80042026-09-10 10:29:182026-09-11 01:26:07USEDkeep — in use
ASSET.schedule.ContractStaging.IX_ShiftSummary3NONCLUSTERED02062026-09-10 10:29:282026-09-11 01:26:07USEDkeep — in use
ASSET.schedule.ContractStaging.PK_PolicyLine1CLUSTEREDYY018062026-09-10 10:30:182026-09-11 01:26:07USEDKEEP — primary key
ASSET.schedule.MeterStaging.IX_PayrollAudit2NONCLUSTERED169126153900301672026-09-12 01:03:452026-09-11 01:26:07USEDkeep — in use
ASSET.schedule.MeterStaging.PK_PolicyArchive1CLUSTEREDYY49083101546302532026-09-12 01:02:442026-09-11 01:26:07USEDKEEP — primary key
ASSET.schedule.SupplierEntry.IX_InvoiceStaging2NONCLUSTERED80042026-09-10 10:29:182026-09-11 01:26:08USEDkeep — in use
ASSET.schedule.SupplierEntry.IX_StaffingDaily3NONCLUSTERED03062026-09-10 10:29:282026-09-11 01:26:08USEDkeep — in use
ASSET.schedule.SupplierEntry.PK_MeterQueue1CLUSTEREDYY017062026-09-10 10:30:182026-09-11 01:26:07USEDKEEP — primary key
ASSET.schedule.ForecastEntry.IX_ContractHistory2NONCLUSTERED38301182026-09-10 10:30:182026-09-11 01:26:08USEDkeep — in use
ASSET.schedule.ForecastEntry.IX_ForecastLine3NONCLUSTERED02743701202026-09-11 20:22:302026-09-11 01:26:08USEDkeep — in use
ASSET.schedule.ForecastEntry.PK_MeterSummary1CLUSTEREDYY081927433274892026-09-11 20:22:302026-09-11 01:26:08USEDKEEP — primary key
ASSET.schedule.CustomerHistory.IX_LedgerQueue2NONCLUSTERED42518853103260652026-09-12 01:03:242026-09-12 01:03:23USEDkeep — in use
ASSET.schedule.CustomerHistory.PK_PayrollAudit1CLUSTEREDYY49580337123533260652026-09-12 01:03:242026-09-12 01:03:23USEDKEEP — primary key
ASSET.schedule.QuotaDetail.IX_QuotaMonthly2NONCLUSTERED1000634782026-09-10 10:29:292026-09-11 01:27:47USEDkeep — in use
ASSET.schedule.QuotaDetail.IX_TicketSummary3NONCLUSTERED020634802026-09-10 10:29:292026-09-11 01:27:55USEDkeep — in use
ASSET.schedule.QuotaDetail.PK_RosterHeader1CLUSTEREDYY0273920635952026-09-11 20:23:452026-09-11 01:27:43USEDKEEP — primary key
ASSET.schedule.RosterResult.IX_BookingAudit2NONCLUSTERED15141001480342026-09-11 20:09:452026-09-12 01:03:26USEDkeep — in use
ASSET.schedule.RosterResult.IX_AssetStaging3NONCLUSTERED949791531201480342026-09-12 01:03:512026-09-12 01:03:26USEDkeep — in use
ASSET.schedule.RosterResult.PK_PricingSummary1CLUSTEREDYY29877726184596951480342026-09-12 01:03:552026-09-12 01:03:26USEDKEEP — primary key
ASSET.schedule.MeterSnapshot.IX_StaffingSummary2NONCLUSTERED11001257932026-09-10 10:29:292026-09-11 01:30:54USEDkeep — in use
ASSET.schedule.MeterSnapshot.IX_MeterLog3NONCLUSTERED0201257952026-09-10 10:29:292026-09-11 01:31:06USEDkeep — in use
ASSET.schedule.MeterSnapshot.PK_CampaignSnapshot1CLUSTEREDYY02739501259102026-09-11 20:23:452026-09-11 01:30:47USEDKEEP — primary key
ASSET.schedule.LedgerSnapshot.PK_RouteStatus1CLUSTEREDYY10598416478012026-09-12 01:02:412026-09-06 04:54:56USEDKEEP — primary key
ASSET.schedule.LedgerSnapshot.IX_TicketLine2NONCLUSTEREDY14012026-09-01 01:02:172026-09-06 04:54:56USEDkeep — in use
ASSET.schedule.RosterHistory.PK_MeterLine1CLUSTEREDYY83968840015962026-09-12 01:02:222026-09-06 04:54:56USEDKEEP — primary key
ASSET.schedule.AssetStaging.PK_CampaignResult1CLUSTEREDYY39885411015962026-09-12 01:02:402026-09-10 02:14:10USEDKEEP — primary key
ASSET.schedule.RouteLine.PK_MeterLine1CLUSTEREDYY56042026-09-09 15:22:522026-09-09 15:11:36USEDKEEP — primary key
ASSET.schedule.InvoiceLog.PK_CatalogSummary1CLUSTEREDYY73651589107102026-09-11 16:28:192026-09-06 04:43:43USEDKEEP — primary key
ASSET.schedule.InvoiceLog.IX_WarehouseHeader2NONCLUSTEREDY11700102026-09-11 16:28:192026-09-06 04:43:43USEDkeep — in use
ASSET.schedule.ContractResult.PK_StaffingSummary1CLUSTEREDYY064920102026-09-11 16:23:242026-09-06 04:43:43USEDKEEP — primary key
ASSET.schedule.ContractResult.UX_CampaignHistory2NONCLUSTEREDYY2539100102026-09-11 16:28:192026-09-06 04:43:43USEDkeep — in use
ASSET.schedule.SalesArchive.IX_RosterStatus1CLUSTERED00010never2026-09-06 04:43:43UNUSEDKEEP — table storage
ASSET.schedule.CatalogHistory.PK_OrdersStatus1CLUSTEREDYY107111002026-09-11 16:23:242026-09-06 04:43:43USEDKEEP — primary key
ASSET.schedule.CatalogHistory.IX_PricingStatus2NONCLUSTEREDY01002026-08-22 07:45:482026-09-06 04:43:43USEDkeep — in use
ASSET.schedule.engine.PK_ReconcileDaily1CLUSTEREDYY47550584278502026-09-12 01:03:292026-09-06 04:53:41USEDKEEP — primary key
ASSET.schedule.engine.UQ_MeterQueue2NONCLUSTEREDY428501002026-09-12 01:02:182026-09-06 04:53:41USEDkeep — in use
ASSET.schedule.TerritoryAudit.PK_PayrollSnapshot1CLUSTEREDYY0334964220922026-09-12 01:01:492026-09-11 01:31:07USEDKEEP — primary key
ASSET.schedule.TerritoryAudit.UX_BookingHeader2NONCLUSTEREDYY3496400129072026-09-12 01:01:492026-09-11 01:31:07USEDkeep — in use
ASSET.schedule.WarehouseArchive.IX_CustomerHistory2NONCLUSTERED00022142never2026-09-11 12:42:27UNUSEDreview, then DROP
ASSET.schedule.WarehouseArchive.IX_OrdersHeader3NONCLUSTERED11675170221422026-09-12 01:02:182026-09-11 12:42:27USEDkeep — in use
ASSET.schedule.WarehouseArchive.PK_RouteAudit1CLUSTEREDYY35200116830352092026-09-12 01:03:292026-09-11 13:36:17USEDKEEP — primary key
ASSET.schedule.LedgerMonthly.IX_CatalogDaily2NONCLUSTERED000493199neverneverUNUSEDreview, then DROP
ASSET.schedule.LedgerMonthly.IX_CustomerMonthly3NONCLUSTERED116751704931992026-09-12 01:02:18neverUSEDkeep — in use
ASSET.schedule.LedgerMonthly.PK_ClaimLine1CLUSTEREDYY7397731307397902026-09-12 01:03:29neverUSEDKEEP — primary key
ASSET.schedule.RouteAudit.IX_InvoiceHeader2NONCLUSTERED2001354642026-09-03 15:27:062026-09-11 01:31:07USEDkeep — in use
ASSET.schedule.RouteAudit.IX_SettlementDetail16NONCLUSTEREDY5461548002640112026-09-10 14:06:47neverUSEDkeep — in use
ASSET.schedule.RouteAudit.IX_CatalogArchive3NONCLUSTERED32701354642026-09-11 20:29:262026-09-11 01:31:07USEDkeep — in use
ASSET.schedule.RouteAudit.IX_QuotaStaging4NONCLUSTERED02501354642026-09-11 20:27:212026-09-11 01:31:08USEDkeep — in use
ASSET.schedule.RouteAudit.PK_PayrollAudit1CLUSTEREDYY7093074555152663352026-09-11 20:29:262026-09-11 01:31:07USEDKEEP — primary key
ASSET.schedule.ShipmentHeader.IX_QuotaSnapshot2NONCLUSTERED1102466042026-09-03 15:27:062026-09-11 01:31:09USEDkeep — in use
ASSET.schedule.ShipmentHeader.IX_InvoiceSummary4NONCLUSTERED000246604never2026-09-11 01:31:09UNUSEDreview, then DROP
ASSET.schedule.ShipmentHeader.IX_CampaignHistory3NONCLUSTERED0202466042026-09-03 15:29:512026-09-11 01:31:09USEDkeep — in use
ASSET.schedule.ShipmentHeader.PK_CampaignDetail1CLUSTEREDYY1312466042026-09-04 09:02:002026-09-11 01:31:09USEDKEEP — primary key
ASSET.schedule.SupplierEntry.PK_AssetSnapshot1CLUSTEREDYY1694194002026-09-12 01:03:242026-09-06 04:53:52USEDKEEP — primary key
ASSET.schedule.TerritoryDetail.PK_ReconcileMonthly1CLUSTEREDYY65801302026-09-11 20:22:102026-09-11 01:31:09USEDKEEP — primary key
ASSET.schedule.StaffingEntry.PK_QuotaDetail1CLUSTEREDYY1916577207461952026-09-12 01:03:292026-09-11 01:31:09USEDKEEP — primary key
ASSET.schedule.StaffingEntry.UQ_TicketDetail2NONCLUSTEREDY6530652026-09-11 20:22:102026-09-11 01:31:09USEDkeep — in use
ASSET.schedule.StaffingEntry.UX_PayrollDaily3NONCLUSTEREDYY3392734701302026-09-12 01:03:242026-09-11 01:31:09USEDkeep — in use
ASSET.schedule.ForecastMonthly.IX_WarehouseDaily2NONCLUSTERED70019163802026-09-11 20:29:262026-09-11 01:32:39USEDkeep — in use
ASSET.schedule.ForecastMonthly.IX_PayrollHistory3NONCLUSTERED91019163802026-09-03 15:24:232026-09-11 01:32:39USEDkeep — in use
ASSET.schedule.ForecastMonthly.IX_BatchMonthly4NONCLUSTERED365019163802026-09-10 14:08:432026-09-11 01:33:05USEDkeep — in use
ASSET.schedule.ForecastMonthly.PK_ForecastHistory1CLUSTEREDYY191621714538325972026-09-12 01:03:292026-09-11 01:31:10USEDKEEP — primary key
ASSET.schedule.CatalogEntry.PK_PolicyDetail1CLUSTEREDYY3392734302026-09-12 01:03:242026-09-06 04:54:56USEDKEEP — primary key
ASSET.schedule.CatalogEntry.UQ_AssetAudit2NONCLUSTEREDY31002026-08-22 13:42:212026-09-06 04:54:56USEDkeep — in use
ASSET.schedule.ContractAudit.PK_TicketSummary1CLUSTEREDYY19163804002026-09-12 01:03:292026-09-06 04:54:56USEDKEEP — primary key
ASSET.schedule.ContractAudit.UQ_OrdersStaging2NONCLUSTEREDY01002026-08-22 07:45:482026-09-06 04:54:56USEDkeep — in use
ASSET.schedule.ContractAudit.UX_BillingSnapshot3NONCLUSTEREDYY3392730002026-09-12 01:03:242026-09-06 04:54:56USEDkeep — in use
ASSET.schedule.SupplierSummary.PK_LedgerEntry1CLUSTEREDYY077202026-09-11 20:22:102026-09-06 04:54:56USEDKEEP — primary key
ASSET.schedule.SupplierSummary.UQ_BillingStaging2NONCLUSTEREDY21002026-08-22 07:45:482026-09-06 04:54:56USEDkeep — in use
ASSET.schedule.PayrollDaily.PK_CustomerQueue1CLUSTEREDYY29334020210012026-09-12 01:03:242026-09-06 04:54:56USEDKEEP — primary key
ASSET.schedule.WarehouseDaily.PK_QuotaAudit1CLUSTEREDYY6510002026-09-11 20:22:102026-09-06 04:54:56USEDKEEP — primary key
ASSET.schedule.WarehouseDaily.UQ_ShiftEntry2NONCLUSTEREDY01002026-08-22 07:45:482026-09-06 04:54:56USEDkeep — in use
ASSET.schedule.WarehouseDaily.UX_TerritorySummary3NONCLUSTEREDYY650002026-09-11 20:22:102026-09-06 04:54:56USEDkeep — in use
ASSET.schedule.sql.IX_PayrollEntry3NONCLUSTEREDY33928010402422026-09-12 01:03:242026-09-10 02:14:10USEDkeep — in use
ASSET.schedule.sql.PK_ContractMonthly1CLUSTEREDYY673845442422026-09-11 20:32:362026-09-10 02:14:10USEDKEEP — primary key
ASSET.schedule.sql.UQ_SalesStatus2NONCLUSTEREDY531472062026-09-11 20:32:362026-09-10 02:14:10USEDkeep — in use
ASSET.schedule.LedgerStatus.PK_SettlementQueue1CLUSTEREDYY04002026-08-22 14:41:592026-09-06 04:54:57USEDKEEP — primary key
ASSET.schedule.LedgerStatus.UQ_QuotaAudit2NONCLUSTEREDY01002026-08-22 07:45:482026-09-06 04:54:57USEDkeep — in use
ASSET.schedule.OrdersQueue.PK_QuotaQueue1CLUSTEREDYY65801302026-09-11 20:22:102026-09-11 01:33:06USEDKEEP — primary key
ASSET.schedule.LedgerStaging.IX_StaffingLog4NONCLUSTERED340635187010752026-09-12 01:03:242026-09-11 01:33:07USEDkeep — in use
ASSET.schedule.LedgerStaging.PK_ContractQueue1CLUSTEREDYY191745914133984110752026-09-12 01:03:292026-09-11 01:33:07USEDKEEP — primary key
ASSET.schedule.LedgerStaging.UQ_TicketResult2NONCLUSTEREDY56802312026-09-11 20:29:262026-09-11 01:33:07USEDkeep — in use
ASSET.schedule.LedgerStaging.UX_QuotaHeader3NONCLUSTEREDYY000844never2026-09-11 01:33:07UNUSEDreview carefully — unique
ASSET.schedule.step.PK_AssetStaging1CLUSTEREDYY4600589402026-09-12 01:03:292026-09-06 04:55:01USEDKEEP — primary key
ASSET.schedule.step.UQ_AssetQueue2NONCLUSTEREDY34002026-09-03 09:02:172026-09-06 04:55:01USEDkeep — in use
ASSET.schedule.step.UQ_OrdersLine5NONCLUSTEREDY55002026-09-11 20:21:432026-09-06 04:55:01USEDkeep — in use
ASSET.schedule.ShipmentResult.PK_MeterSnapshot1CLUSTEREDYY661201302026-09-11 20:22:102026-09-11 01:33:08USEDKEEP — primary key
ASSET.schedule.WarehouseEntry.PK_SettlementLine1CLUSTEREDYY1916512339414002026-09-12 01:03:292026-09-06 04:55:04USEDKEEP — primary key
ASSET.schedule.WarehouseEntry.UQ_ShiftSnapshot2NONCLUSTEREDY01002026-08-22 07:45:482026-09-06 04:55:04USEDkeep — in use
ASSET.schedule.WarehouseEntry.UX_OrdersLog3NONCLUSTEREDYY30002026-09-03 09:02:172026-09-06 04:55:04USEDkeep — in use
ASSET.wps.ContractStatus.IX_RosterDaily4NONCLUSTERED49300437032026-09-12 00:27:582026-09-06 04:55:04USEDkeep — in use
ASSET.wps.ContractStatus.PK_ClaimLog1CLUSTEREDYY043703493437032026-09-12 01:03:462026-09-06 04:55:04USEDKEEP — primary key
ASSET.wps.ContractStatus.UX_TerritoryResult14NONCLUSTEREDYY0000never2026-09-06 04:55:04COLDreview carefully — unique
ASSET.wps.ContractStatus.UX_SettlementDetail2NONCLUSTEREDY0000never2026-09-06 04:55:04UNUSEDreview carefully — unique
ASSET.wps.PolicyResult.IX_ContractSnapshot2NONCLUSTERED29900112026-09-11 07:30:002026-09-08 01:31:57USEDkeep — in use
ASSET.wps.PolicyResult.PK_SettlementLine1CLUSTEREDYY382228237112026-09-11 07:30:002026-09-08 01:31:57USEDKEEP — primary key
ASSET.wps.LedgerMonthly.PK_LedgerMonthly1CLUSTEREDYY00016never2026-09-08 01:31:57UNUSEDKEEP — primary key
ASSET.wps.BookingStaging.PK_ClaimHistory1CLUSTEREDYY01420142026-09-07 15:07:552026-09-08 01:31:57USEDKEEP — primary key
ASSET.wps.SalesHeader.PK_ContractHistory1CLUSTEREDYY00020never2026-09-08 01:31:57UNUSEDKEEP — primary key
ASSET.wps.ForecastResult.PK_QuotaLog1CLUSTEREDYY2702209212885872026-09-11 23:59:002026-09-11 01:33:08USEDKEEP — primary key
ASSET.wps.ForecastResult.UQ_ShipmentArchive5NONCLUSTEREDY219871005782026-09-12 00:00:002026-09-11 01:33:08USEDkeep — in use
ASSET.wps.StaffingResult.PK_RosterStatus1CLUSTEREDYY147097072026-09-12 01:04:002026-09-06 04:55:05USEDKEEP — primary key
ASSET.wps.StaffingStaging.PK_PolicyEntry1CLUSTEREDYY01072026-09-07 10:42:472026-09-08 01:31:57USEDKEEP — primary key
ASSET.wps.CustomerSnapshot.PK_WarehouseArchive1CLUSTEREDYY0000never2026-09-06 04:55:05UNUSEDKEEP — primary key
ASSET.wps.LedgerQueue.PK_BatchQueue1CLUSTEREDYY0000never2026-09-06 04:55:05UNUSEDKEEP — primary key
ASSET.wps.TerritoryQueue.IX_InvoiceAudit10NONCLUSTERED1413143026102026-09-11 07:30:002026-09-08 01:31:57USEDkeep — in use
ASSET.wps.TerritoryQueue.PK_RosterSnapshot1CLUSTEREDYY129620283026102026-09-11 07:30:002026-09-08 01:31:57USEDKEEP — primary key
ASSET.wps.TerritoryQueue.UX_MeterStaging2NONCLUSTEREDY266220025902026-09-11 07:30:002026-09-08 01:31:57USEDkeep — in use
ASSET.wps.ContractEntry.PK_PayrollSummary1CLUSTEREDYY0002590never2026-09-08 01:31:58UNUSEDKEEP — primary key
ASSET.wps.TicketStatus.PK_InvoiceMonthly1CLUSTEREDYY2311325118642026-09-11 23:59:002026-09-11 01:33:08USEDKEEP — primary key
ASSET.wps.TicketStatus.UQ_OrdersQueue2NONCLUSTEREDY11800552026-09-11 07:30:002026-09-11 01:33:08USEDkeep — in use
ASSET.wps.SalesDetail.PK_SettlementLine1CLUSTEREDYY000578never2026-09-11 01:33:08UNUSEDKEEP — primary key
ASSET.wps.ClaimResult.PK_TicketEntry1CLUSTEREDYY515194082026-09-12 00:27:582026-09-06 04:55:06USEDKEEP — primary key
ASSET.wps.CatalogSnapshot.PK_ForecastHeader1CLUSTEREDYY00014never2026-09-08 01:31:58UNUSEDKEEP — primary key
ASSET.wps.BillingLine.PK_RosterResult1CLUSTEREDYY587810146032026-09-12 00:27:582026-09-06 04:55:06USEDKEEP — primary key
ASSET.wps.BillingLine.UX_WarehouseLog2NONCLUSTEREDYY60032026-09-07 13:57:142026-09-08 01:31:58USEDkeep — in use
ASSET.wps.BatchStatus.PK_ClaimLine1CLUSTEREDYY0142210412026-09-11 07:30:002026-09-06 04:55:06USEDKEEP — primary key
ASSET.wps.BatchStatus.UQ_CustomerHeader2NONCLUSTEREDY1040012026-09-10 15:40:022026-09-06 04:55:06USEDkeep — in use
ASSET.wps.BookingResult.PK_WarehouseMonthly1CLUSTEREDYY0001never2026-09-06 04:55:06UNUSEDKEEP — primary key
ASSET.wps.BookingStaging.PK_ForecastLog1CLUSTEREDYY012062026-09-07 12:50:112026-09-08 01:31:58USEDKEEP — primary key
CLAIM_Prod.bm.BOM.PK_MeterHistory1CLUSTEREDYY0000never2026-09-06 04:55:07UNUSEDKEEP — primary key
CLAIM_Prod.bm.CatalogQueue.PK_StaffingSummary1CLUSTEREDYY0000never2026-09-06 04:55:07UNUSEDKEEP — primary key
CLAIM_Prod.bm.ShiftEntry.PK_RouteStatus1CLUSTEREDYY0000never2026-09-06 04:55:07UNUSEDKEEP — primary key
CLAIM_Prod.bm.BillingArchive.PK_AssetMonthly1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.bm.ForecastDetail.PK_CatalogLog1CLUSTEREDYY0000never2026-09-06 04:55:07UNUSEDKEEP — primary key
CLAIM_Prod.cfg.QuotaStatus.PK_StaffingLine1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CLAIM_Prod.dbo.StaffingEntry.PK_AssetStaging1CLUSTEREDYY0000never2026-09-06 04:55:07UNUSEDKEEP — primary key
CLAIM_Prod.dbo.QuotaLine.PK_ClaimSummary1CLUSTEREDYY0000never2026-09-06 04:55:07UNUSEDKEEP — primary key
CLAIM_Prod.dbo.QuotaLine.UX_ForecastSummary2NONCLUSTEREDY0000never2026-09-06 04:55:07UNUSEDreview 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-06 04:55:07UNUSEDKEEP — primary key
CLAIM_Prod.lib.SalesLine.PK_StaffingEntry1CLUSTEREDYY0000never2026-09-06 04:55:07UNUSEDKEEP — primary key
CLAIM_Prod.lib.SalesLine.UX_QuotaArchive2NONCLUSTEREDY0000never2026-09-06 04:55:07UNUSEDreview carefully — unique
CLAIM_Prod.lib.CustomerLog.PK_ClaimMonthly1CLUSTEREDYY0000never2026-09-06 04:55:07UNUSEDKEEP — primary key
CLAIM_Prod.lib.BillingArchive.PK_StaffingDetail1CLUSTEREDYY0000never2026-09-06 04:55:08UNUSEDKEEP — primary key
CLAIM_Prod.lib.BillingArchive.UX_CustomerEntry9NONCLUSTEREDY0000never2026-09-06 04:55:08UNUSEDreview carefully — unique
CLAIM_Prod.lib.CustomerArchive.PK_ForecastSummary1CLUSTEREDYY0000never2026-09-06 04:55:09UNUSEDKEEP — primary key
CLAIM_Prod.lib.SettlementHeader.PK_ShiftHeader1CLUSTEREDYY0000never2026-09-06 04:55:09UNUSEDKEEP — primary key
CLAIM_Prod.lib.SettlementHeader.UX_ForecastDaily2NONCLUSTEREDY0000never2026-09-06 04:55:09UNUSEDreview 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-06 04:55:09UNUSEDKEEP — primary key
CLAIM_Prod.lib.ReconcileEntry.PK_BatchLog1CLUSTEREDYY0000never2026-09-06 04:55:09UNUSEDKEEP — primary key
CLAIM_Prod.lib.RouteStatus.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-06 04:55:09UNUSEDKEEP — primary key
CLAIM_Prod.lib.InvoiceLine.PK_AssetArchive1CLUSTEREDYY0000never2026-09-06 04:55:09UNUSEDKEEP — primary key
CLAIM_Prod.lib.Size.PK_ClaimArchive1CLUSTEREDYY0000never2026-09-06 04:55:09UNUSEDKEEP — primary key
CLAIM_Prod.lib.StaffingQueue.PK_CampaignAudit1CLUSTEREDYY0000never2026-09-06 04:55:10UNUSEDKEEP — primary key
CLAIM_Prod.lib.MeterAudit.PK_TerritoryDaily1CLUSTEREDYY0000never2026-09-06 04:55:10UNUSEDKEEP — primary key
CLAIM_Prod.lib.RosterResult.PK_ShipmentEntry1CLUSTEREDYY0000never2026-09-06 04:55:10UNUSEDKEEP — primary key
CLAIM_Prod.lib.BookingResult.PK_ForecastLine1CLUSTEREDYY0000never2026-09-06 04:55:10UNUSEDKEEP — primary key
CLAIM_Prod.lib.MeterAudit.PK_ReconcileDaily1CLUSTEREDYY0000never2026-09-06 04:55:10UNUSEDKEEP — primary key
CLAIM_Prod.lib.ContractLog.PK_TerritoryLog1CLUSTEREDYY0000never2026-09-06 04:55:10UNUSEDKEEP — primary key
CLAIM_Prod.lib.CustomerLine.PK_QuotaArchive1CLUSTEREDYY0000never2026-09-06 04:55:10UNUSEDKEEP — primary key
CLAIM_Prod.sm.QuotaHistory.PK_BatchLine1CLUSTEREDYY0000never2026-09-06 04:55:10UNUSEDKEEP — primary key
CLAIM_Prod.sm.InvoiceStaging.PK_QuotaDaily1CLUSTEREDYY0000never2026-09-06 04:55:11UNUSEDKEEP — primary key
CLAIM_Prod.sm.PricingStatus.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-06 04:55:11UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryArchive.PK_TerritoryLine1CLUSTEREDYY0000never2026-09-06 04:55:11UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryArchive.UX_PayrollResult4NONCLUSTEREDY0000never2026-09-06 04:55:11UNUSEDreview carefully — unique
CLAIM_Prod.sm.BookingResult.PK_RosterStaging1CLUSTEREDYY0000never2026-09-06 04:55:11UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryMonthly.PK_BookingAudit1CLUSTEREDYY0000never2026-09-06 04:55:11UNUSEDKEEP — primary key
CLAIM_Prod.sm.TerritoryMonthly.UX_StaffingResult2NONCLUSTEREDY0000never2026-09-06 04:55:11UNUSEDreview 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-06 04:55:11UNUSEDKEEP — 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-06 04:55:12UNUSEDKEEP — 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-06 04:55:12UNUSEDKEEP — primary key
CONTRACT.bm.BOM.PK_MeterHistory1CLUSTEREDYY0000never2026-09-06 04:55:13UNUSEDKEEP — primary key
CONTRACT.bm.CatalogQueue.PK_StaffingSummary1CLUSTEREDYY0000never2026-09-06 04:55:13UNUSEDKEEP — primary key
CONTRACT.bm.ShiftEntry.PK_RouteStatus1CLUSTEREDYY0000never2026-09-06 04:55:13UNUSEDKEEP — 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-06 04:55:13UNUSEDKEEP — primary key
CONTRACT.dbo.QuotaLine.PK_ClaimSummary1CLUSTEREDYY0000never2026-09-06 04:55:13UNUSEDKEEP — primary key
CONTRACT.dbo.QuotaLine.UX_ForecastSummary2NONCLUSTEREDY0000never2026-09-06 04:55:13UNUSEDreview carefully — unique
CONTRACT.dbo.QuotaResult.PK_SettlementSummary1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.dbo.QuotaResult.IX_BillingLog2NONCLUSTEREDY0000neverneverCOLDreview carefully — unique
CONTRACT.lib.Color.PK_ReconcileStaging1CLUSTEREDYY0000never2026-09-06 04:55:14UNUSEDKEEP — primary key
CONTRACT.lib.SalesLine.PK_StaffingEntry1CLUSTEREDYY0000never2026-09-06 04:55:14UNUSEDKEEP — primary key
CONTRACT.lib.SalesLine.UX_QuotaArchive2NONCLUSTEREDY0000never2026-09-06 04:55:14UNUSEDreview carefully — unique
CONTRACT.lib.CustomerLog.PK_ClaimMonthly1CLUSTEREDYY0000never2026-09-06 04:55:14UNUSEDKEEP — primary key
CONTRACT.lib.BillingArchive.PK_StaffingDetail1CLUSTEREDYY0000never2026-09-06 04:55:14UNUSEDKEEP — primary key
CONTRACT.lib.BillingArchive.UX_CustomerEntry9NONCLUSTEREDY0000never2026-09-06 04:55:14UNUSEDreview carefully — unique
CONTRACT.lib.CustomerArchive.PK_ForecastSummary1CLUSTEREDYY0000never2026-09-06 04:55:15UNUSEDKEEP — primary key
CONTRACT.lib.SettlementHeader.PK_ShiftHeader1CLUSTEREDYY0000never2026-09-06 04:55:15UNUSEDKEEP — primary key
CONTRACT.lib.SettlementHeader.UX_ForecastDaily2NONCLUSTEREDY0000never2026-09-06 04:55:15UNUSEDreview carefully — unique
CONTRACT.lib.SupplierSummary.PK_BookingHeader1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.lib.LedgerSnapshot.PK_ClaimDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.lib.RouteDetail.PK_SalesStaging1CLUSTEREDYY0000never2026-09-06 04:55:15UNUSEDKEEP — primary key
CONTRACT.lib.ReconcileEntry.PK_BatchLog1CLUSTEREDYY0000never2026-09-06 04:55:15UNUSEDKEEP — primary key
CONTRACT.lib.RouteStatus.PK_ShiftAudit1CLUSTEREDYY0000never2026-09-06 04:55:15UNUSEDKEEP — primary key
CONTRACT.lib.InvoiceLine.PK_AssetArchive1CLUSTEREDYY0000never2026-09-06 04:55:16UNUSEDKEEP — primary key
CONTRACT.lib.Size.PK_ClaimArchive1CLUSTEREDYY0000never2026-09-06 04:55:16UNUSEDKEEP — primary key
CONTRACT.lib.StaffingQueue.PK_CampaignAudit1CLUSTEREDYY0000never2026-09-06 04:55:16UNUSEDKEEP — primary key
CONTRACT.lib.MeterAudit.PK_TerritoryDaily1CLUSTEREDYY0000never2026-09-06 04:55:16UNUSEDKEEP — primary key
CONTRACT.lib.RosterResult.PK_ShipmentEntry1CLUSTEREDYY0000never2026-09-06 04:55:16UNUSEDKEEP — primary key
CONTRACT.lib.BookingResult.PK_ForecastLine1CLUSTEREDYY0000never2026-09-06 04:55:16UNUSEDKEEP — primary key
CONTRACT.lib.MeterAudit.PK_ReconcileDaily1CLUSTEREDYY0000never2026-09-06 04:55:16UNUSEDKEEP — primary key
CONTRACT.lib.ContractLog.PK_TerritoryLog1CLUSTEREDYY0000never2026-09-06 04:55:16UNUSEDKEEP — primary key
CONTRACT.lib.CustomerLine.PK_QuotaArchive1CLUSTEREDYY0000never2026-09-06 04:55:16UNUSEDKEEP — primary key
CONTRACT.sm.QuotaHistory.PK_BatchLine1CLUSTEREDYY0000never2026-09-06 04:55:16UNUSEDKEEP — primary key
CONTRACT.sm.InvoiceStaging.PK_QuotaDaily1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.PricingStatus.PK_LedgerHistory1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryArchive.PK_TerritoryLine1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryArchive.UX_PayrollResult4NONCLUSTEREDY0000never2026-09-06 04:55:17UNUSEDreview carefully — unique
CONTRACT.sm.BookingResult.PK_RosterStaging1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryMonthly.PK_BookingAudit1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.TerritoryMonthly.UX_StaffingResult2NONCLUSTEREDY0000never2026-09-06 04:55:17UNUSEDreview carefully — unique
CONTRACT.sm.QuotaDaily.PK_BookingDetail1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.QuotaDaily.UX_QuotaQueue2NONCLUSTEREDY0000never2026-09-06 04:55:17UNUSEDreview carefully — unique
CONTRACT.sm.CatalogResult.PK_SalesStatus1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.BatchAudit.PK_ReconcileHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.ShiftDaily.PK_ClaimHistory1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.OrdersMonthly.PK_PolicyHistory1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.InvoiceLine.PK_PayrollDetail1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.BillingEntry.PK_SettlementArchive1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.ShipmentDaily.PK_CatalogDetail1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.ShipmentDaily.UX_TicketMonthly2NONCLUSTEREDY0000never2026-09-06 04:55:17UNUSEDreview carefully — unique
CONTRACT.sm.PolicyHeader.PK_CustomerSummary1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.PolicyHeader.UX_LedgerDetail2NONCLUSTEREDY0000never2026-09-06 04:55:17UNUSEDreview carefully — unique
CONTRACT.sm.RouteDetail.PK_SalesDetail1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key
CONTRACT.sm.QuotaStatus.PK_ShiftDetail1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.ContractAudit.PK_ReconcileArchive1CLUSTEREDYY0000neverneverCOLDKEEP — primary key
CONTRACT.sm.BookingHeader.PK_ShipmentArchive1CLUSTEREDYY0000never2026-09-06 04:55:17UNUSEDKEEP — primary key