3 ms·
The first part I’m saying is a bad example because you wouldn’t store the price + vat in a column let alone a calculated column. The second part I’m giving an
by philliphaydon 7y ago
The first part I’m saying is a bad example because you wouldn’t store the price + vat in a column let alone a calculated column.
The second part I’m giving an example where doing:
where created + period > now() - '3 days'::interval
Having to calculate the value in a where clause is inefficient.
Making a calculated column adding created and period then indexing it is more efficient.