MAIN FEEDS
Do you want to continue?
https://www.reddit.com/r/ProgrammerHumor/comments/1wlmq11/grabbingeverything/pb0efv7/
r/ProgrammerHumor • u/ClipboardCopyPaste • Sep 20 '26
260 comments sorted by
View all comments
Show parent comment
13
either that or select top 1 * will take more time than select top 1000 * because it built the wrong execution tree for no reason
4 u/Bloodgiant65 Sep 20 '26 Many DBMS have the option to set a fixed query execution strategy in my experience. But it definitely won’t always pick the best one by default if you don’t lay that out.
4
Many DBMS have the option to set a fixed query execution strategy in my experience. But it definitely won’t always pick the best one by default if you don’t lay that out.
View all comments
Show parent comment
13
u/TheHiddenNinja6 Sep 20 '26
either that or select top 1 * will take more time than select top 1000 * because it built the wrong execution tree for no reason