Re:Pipe Syntax in SQL
by wvenable on Sunday August 25, 2024 @01:12PM
(#41349103)
If you use temp tables you're subverting the optimizer. Sometimes that's what you want but often it's not.
[ Parent
| on HN ]
Re:Pipe Syntax in SQL
by RaftPeople on Sunday August 25, 2024 @04:51PM
(#41351306)
I use them on purpose to "help" the optimizer by reducing the search space for query plan ((knowing that query plan optimization is a combinatorial problem and the optimizer frequently can't evaluate enough plans in a reasonable amount of time).