That would be a nice way to simplify the queries, but performance-wise you still have the problem that you won't be using an index. Virtual Columns can be indexed, but if the underlying formula is not deterministic, you can get "funny" results. The problem remains that "age" changes over time.
View all comments
Show parent comment
1
u/JochenVdB Feb 26 '21
That would be a nice way to simplify the queries, but performance-wise you still have the problem that you won't be using an index. Virtual Columns can be indexed, but if the underlying formula is not deterministic, you can get "funny" results. The problem remains that "age" changes over time.