All stories

Query Optimization

The Last SQL Bender

Predicate / Sargability Rewrite

A WHERE clause wrapped in functions disables index seeks. Quentra detected the pattern, suggested a rewrite with AI, and activated the rule — logical reads dropped from 42,409 to 223.

190×
performance gain
42.409 → 223
logical reads
331 MB → 1.7 MB
estimated data read
Optimizing non-sargable SQL with Quentra — a story.
1 of 13

Optimizing non-sargable SQL with Quentra — a story.