Robert McGehee writes:
> I frequently want to make views that repeat a calculation over and over
> again in lots of columns. In the example below, let’s say it’s (a+b), but
> we can imagine the calculation being much more complicated.
> For example:
> CREATE VIEW AS
> SELECT (a+b)*c as c1, (a+b)*
Hello,
I have a general query optimization question involving repeated
calculations.
I frequently want to make views that repeat a calculation over and over
again in lots of columns. In the example below, let’s say it’s (a+b), but
we can imagine the calculation being much more complicated.
For ex
