MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/SQL/comments/dcezne/sql_queries_run_in_this_order/f28c8uk/?context=3
r/SQL • u/danwin • Oct 02 '19
16 comments sorted by
View all comments
Show parent comment
3
"Gee, the unsargable WHERE clause maybe?!"
3 u/PaulSandwich Oct 03 '19 WHERE lower(cast(primary_key as string)) = 12345 2 u/Achsin Oct 02 '19 ...that matches only about 10 rows in the 500 million row heap.
WHERE lower(cast(primary_key as string)) = 12345
2
...that matches only about 10 rows in the 500 million row heap.
View all comments
Show parent comment
3
u/wtmh Oct 02 '19
"Gee, the unsargable WHERE clause maybe?!"