Stephan Szabo wrote:
On 8 Jul 2003, Markus Bertheau wrote:
when you have
select expensive_expression(column), * from table offset 20 limit 40
can you somehow save the cost for the first 20 calculations of
expensive_expression?
Right now the only way I can think of that might work
Hi,
when you have
select expensive_expression(column), * from table offset 20 limit 40
can you somehow save the cost for the first 20 calculations of
expensive_expression?
--
Markus Bertheau.
Berlin, Berlin.
Germany.
---(end of broadcast)---
TIP
On 8 Jul 2003, Markus Bertheau wrote:
when you have
select expensive_expression(column), * from table offset 20 limit 40
can you somehow save the cost for the first 20 calculations of
expensive_expression?
Right now the only way I can think of that might work is to push the
offset/limit
On 8 Jul 2003, Markus Bertheau wrote:
Hi,
when you have
select expensive_expression(column), * from table offset 20 limit 40
can you somehow save the cost for the first 20 calculations of
expensive_expression?
Might a functional or partial index work here?