2 ms·

Hmm? This doesn't make much sense. MSSQL does these already I think (except the first) . - Inlining scalar function calls (less impactful now with Sql Server

Hmm? This doesn't make much sense. MSSQL does these already I think (except the first) . - Inlining scalar function calls (less impactful now with Sql Server 2019) write them as table valued funcs and it'll inline them for you (ugly but it works and is easy) . - Removing joins from a query when we know it won't impact the number of records That's just tree pruning. It does that . - Deepening where conditions against derived tables If I understand you that's predicate pushdown. MSSQL does it well. . - Killing "branches" of union queries when they can be determined to not matter statically Not sure what you mean. Can you give an example?

i_s 5y ago
> This doesn't make much sense. MSSQL does these already I think (except the first) We tested all of these before taking the time to do the rewriting, and no, either they don't, or they way they did it isn't good enough. You can say I'm lying if you want, I'm not going to spend time arguing about it.
- zasdffaa 5y ago
  You could post some working examples and show them failing.