Database optimization duty this week. Saved the team 1 hr/day of execution time. Non-sargable operations and duplicate table scans were the biggest culprits so far
October 30, 2026 at 8:26 PM
Database optimization duty this week. Saved the team 1 hr/day of execution time. Non-sargable operations and duplicate table scans were the biggest culprits so far
October 27, 2026 at 8:02 AM
What do you call a WHERE clause wrapped in six functions?
Non-sargable.
What do you call the person who wrote it?
You, eight months ago, in a hurry.
Come make peace with your past. T-SQL That Doesn't Suck: #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
Non-sargable.
What do you call the person who wrote it?
You, eight months ago, in a hurry.
Come make peace with your past. T-SQL That Doesn't Suck: #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
October 8, 2026 at 2:04 PM
What do you call a WHERE clause wrapped in six functions?
Non-sargable.
What do you call the person who wrote it?
You, eight months ago, in a hurry.
Come make peace with your past. T-SQL That Doesn't Suck: #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
Non-sargable.
What do you call the person who wrote it?
You, eight months ago, in a hurry.
Come make peace with your past. T-SQL That Doesn't Suck: #PASSDataSummit West precon.
passdatacommunitysummit.com/west/
A search condition is considered SARGable (Search ARGument ABLE) when SQL Server can use an index to efficiently locate rows. So, ask not what an index can do for you, but what you can do for your index. #SQLServer #SQL #Sargable sqlmct.com/writing-sarg...
Writing SARGable Expressions in T‑SQL
Learn to write SARGable expressions in T-SQL for efficient SQL Server queries. Improve performance and reduce CPU usage.
sqlmct.com
May 28, 2026 at 11:32 AM
A search condition is considered SARGable (Search ARGument ABLE) when SQL Server can use an index to efficiently locate rows. So, ask not what an index can do for you, but what you can do for your index. #SQLServer #SQL #Sargable sqlmct.com/writing-sarg...
SARGability is one of the highest return on investment performance skills a SQL developer can learn. Small changes to predicates can turn expensive scans into efficient seeks; often without adding or changing indexes. sqlmct.com/writing-sarg...
Writing SARGable Expressions in T‑SQL
Learn to write SARGable expressions in T-SQL for efficient SQL Server queries. Improve performance and reduce CPU usage.
sqlmct.com
March 10, 2026 at 9:34 AM
SARGability is one of the highest return on investment performance skills a SQL developer can learn. Small changes to predicates can turn expensive scans into efficient seeks; often without adding or changing indexes. sqlmct.com/writing-sarg...
The #SQL analysis report in Oracle AI Database 26ai shows potential problems in a query
Cartesian products
UNION
Non sargable filters (can’t use indexes)
You can use this to find queries in the cursor cache which you may be able to improve
Cartesian products
UNION
Non sargable filters (can’t use indexes)
You can use this to find queries in the cursor cache which you may be able to improve
October 16, 2025 at 5:31 PM
The #SQL analysis report in Oracle AI Database 26ai shows potential problems in a query
Cartesian products
UNION
Non sargable filters (can’t use indexes)
You can use this to find queries in the cursor cache which you may be able to improve
Cartesian products
UNION
Non sargable filters (can’t use indexes)
You can use this to find queries in the cursor cache which you may be able to improve
December 3, 2024 at 12:41 AM
SARGable queries are more important than LIEUTENANTable queries.
December 2, 2024 at 11:40 PM
SARGable queries are more important than LIEUTENANTable queries.
SARGable queries are more important than LIEUTENANTable queries.
November 27, 2024 at 5:01 AM
SARGable queries are more important than LIEUTENANTable queries.
November 26, 2024 at 4:12 PM
SARGable queries are more important than LIEUTENANTable queries.
November 26, 2024 at 2:56 PM
SARGable queries are more important than LIEUTENANTable queries.
Me in a job interview answering a question about non-SARGable predicates in queries.
May 4, 2025 at 1:17 AM
Me in a job interview answering a question about non-SARGable predicates in queries.
Nice eye to notice and fix this so it's now sargable.
March 13, 2024 at 1:46 AM
Nice eye to notice and fix this so it's now sargable.
Avoid non-sargable queries! Applying functions to indexed columns forces full table scans, killing performance. Instead, use indexed computed columns or case-insensitive collations for efficient filtering. #QueryOptimization 4/6
October 19, 2025 at 4:00 PM
Avoid non-sargable queries! Applying functions to indexed columns forces full table scans, killing performance. Instead, use indexed computed columns or case-insensitive collations for efficient filtering. #QueryOptimization 4/6
Hey SQL experts, don’t use ISNULL() to search in your tables. You can do it better, don’t you?
www.db-berater.de/2024/11/isnu...
#sqlserver #sqlfamily
www.db-berater.de/2024/11/isnu...
#sqlserver #sqlfamily
ISNULL() and SARGable queries
Database developers like to use the ISNULL() function to check two conditions and compare them with a search value. This is often done with the intention of fin
www.db-berater.de
November 23, 2024 at 11:45 AM
Hey SQL experts, don’t use ISNULL() to search in your tables. You can do it better, don’t you?
www.db-berater.de/2024/11/isnu...
#sqlserver #sqlfamily
www.db-berater.de/2024/11/isnu...
#sqlserver #sqlfamily
Non-sargable predicates 😲
Repeated across your database 😫
Crushing secret performance 😵
👇 Solved with one quick index 💪
andybrownsword.co.uk/2024/10/08/e...
Repeated across your database 😫
Crushing secret performance 😵
👇 Solved with one quick index 💪
andybrownsword.co.uk/2024/10/08/e...
Eliminating Bad Code Smells with Indexing Computed Columns
Bad code smells can run through a system, and one instance can quickly spread when code is recycled. Simon recently looked at a non-sargable example and was able to fix it by using an index and ref…
andybrownsword.co.uk
October 9, 2024 at 4:19 PM
Non-sargable predicates 😲
Repeated across your database 😫
Crushing secret performance 😵
👇 Solved with one quick index 💪
andybrownsword.co.uk/2024/10/08/e...
Repeated across your database 😫
Crushing secret performance 😵
👇 Solved with one quick index 💪
andybrownsword.co.uk/2024/10/08/e...
If they’re stored a sql_nftable are they sargable?
March 7, 2025 at 9:33 PM
If they’re stored a sql_nftable are they sargable?
It’s odd, but we don’t typically use the term SARGable in Oracle - it’s an IBM term from the late 70’s. ‘Tis useful though.
October 18, 2025 at 2:16 AM
It’s odd, but we don’t typically use the term SARGable in Oracle - it’s an IBM term from the late 70’s. ‘Tis useful though.
Do you write generic predicates like:
WHERE p1 IS NULL OR "col" > p1
Don't do that in PostgreSQL! If you use prepared statements, be sure to force custom plans. If you use hardcoded values, be sure the predicate is sargable. Examples in a new blog post:
dev.to/franckpachot...
WHERE p1 IS NULL OR "col" > p1
Don't do that in PostgreSQL! If you use prepared statements, be sure to force custom plans. If you use hardcoded values, be sure the predicate is sargable. Examples in a new blog post:
dev.to/franckpachot...
WHERE $1::timestamptz IS NULL OR "timestamp" > $1
SQL is quite flexible, making it easy to write a single query that works for two situations: one...
dev.to
July 27, 2026 at 4:03 PM
Do you write generic predicates like:
WHERE p1 IS NULL OR "col" > p1
Don't do that in PostgreSQL! If you use prepared statements, be sure to force custom plans. If you use hardcoded values, be sure the predicate is sargable. Examples in a new blog post:
dev.to/franckpachot...
WHERE p1 IS NULL OR "col" > p1
Don't do that in PostgreSQL! If you use prepared statements, be sure to force custom plans. If you use hardcoded values, be sure the predicate is sargable. Examples in a new blog post:
dev.to/franckpachot...
It's Monday morning and already I'm trying to teach a low-coder about sargable WHERE clauses.
Am I crazy?
Am I crazy?
November 13, 2023 at 4:14 PM
It's Monday morning and already I'm trying to teach a low-coder about sargable WHERE clauses.
Am I crazy?
Am I crazy?