Oh, you mean optimizing the SQL as SQL, not optimizing the query execution? Well, some of these transformations are useful, like the one you presented. But any

Oh, you mean optimizing the SQL as SQL, not optimizing the query execution? Well, some of these transformations are useful, like the one you presented. But any non-trivial transformation may be either beneficial or detrimental, depending on a myriad of factors including memory layout, compression, distribution of data, computing hardware etc.