Why so? Basic form "case lvalue when rvalue then out ... end" is much like switch.
The "case when condition then out ... end" is different, more complex beast, but first one is essentially a switch. If it is now trnasformed into
"case when lvalue = rvalue1 then out1 when lvalue=rvalue2 then out2 ... end" then this can be optimized and this would benefit many users, not only ones that use partitioning.
* Vitalii Tymchyshyn (tivv00@gmail.com) wrote: > There is switch-like sql case:
[...]
> It should work like C switch statement.
It does and it doesn't. It behaves generally like a C switch statement, but is much more flexible and therefore can't be optimized like a C switch statement can be.