Engineering Atlas
☰ Menu
PortfolioAtlasDeploySQLData ViewsEnvBites
PT
Engineering Atlas / Snippets / SARGable Rolling Date Window
sfmc // SQLPRODUCTION

SARGable Rolling Date Window

Filter recent Data View rows without wrapping the source date column in a function.

sqlperformancedateaddsargable
Context Pack →Open Workspace →
Trust & provenancePRODUCTION
Evidence tierPRODUCTIONOfficial sources1Other sources0Last verified2026-10-05

Evidence tier describes my hands-on relationship with the content. Official sources describe platform contracts/documentation. Production observations should not automatically be treated as official limits.

EvidencePRODUCTION
Difficultyfoundation
Verified2026-10-05
Use when

Filtering large Data Views or Data Extensions by a recent time window.

SELECT
    SubscriberKey,
    JobID,
    EventDate
FROM _Sent
WHERE EventDate >= DATEADD(day, -30, GETDATE())
Why it works

The source column remains directly searchable while the boundary is calculated once on the other side of the predicate.

Operational notes

Salesforce calls non-SARGable predicates a common timeout pattern in Query Activities.

Gotchas

Avoid patterns such as DATEDIFF(day, EventDate, GETDATE()) <= 30 on large sources.

Related
Pre-Aggregate Tracking Before Joining

Reduce event grain before combining behavior tables.

→
Connected knowledge

Keep following the context.

Explicit and inferred relationships from the Atlas model.

View this node in graph →
SnippetDIRECT LINK
Pre-Aggregate Tracking Before Joining

Reduce event grain before combining behavior tables.

Explicit related snippet
SQL GuideDIRECT LINK
SARGable Filtering in Query Activities

On large Data Extensions and Data Views, where the function is applied can decide whether the database can use an index efficiently. Keep searchable columns “bare” on the left side of predicates whenever possible.

Guide → snippet
Data View
_Sent

Subscribers targeted by email sends. Core anchor for send-level tracking joins.

_Sent referenced in snippet
Snippet
Stage Before Large Add/Update

Move expensive transformation into an overwrite staging DE before a large Add/Update write.

Shared context: performance
Snippet
Bounded LookupOrderedRows()

Retrieve a small, ordered rowset instead of scanning an unbounded one-to-many relationship at render time.

Shared context: performance
SQL Guide
Stage Large Queries Instead of Being Clever

When one Query Activity has too many joins, scans and transformations, split the work into deterministic stages. You gain observability, smaller scans and easier failure isolation.

Shared context: performance
SQL Guide
Target Action Is Part of Query Design

The SQL text is only half the Query Activity. The target action changes how the platform writes data and can become the bottleneck as the target grows.

Shared context: performance
Runbook
Query Activity Timeout / Failure

Triage recurring SQL Query Activity failures before blindly retrying.

Shared context: performance
Sources / verification
Salesforce — Query Activity Timeout Error ↗