Unfortunately, I do not have the resources to test that.
If I can find a non used machine, I'll try setting up PS and making a partitioned table, fill it with data and then run some queries against it with the WHEN CASE THEN ELSE END statements in it like the original query.
@raghavendra
Unfortunately, I do not have the resources to test that.
If I can find a non used machine, I'll try setting up PS and making a partitioned table, fill it with data and then run some queries against it with the WHEN CASE THEN ELSE END statements in it like the original query.