Re: avoid select expens_expr(col) like unneccessary calculations
От
scott.marlowe
Тема
Re: avoid select expens_expr(col) like unneccessary calculations
Дата
Msg-id
Pine.LNX.4.33.0307071655260.5244-100000@css120.ihs.com
Ответ на
avoid select expens_expr(col) like unneccessary calculations (Markus Bertheau)
Список
Дерево обсуждения
avoid select expens_expr(col) like unneccessary calculations Markus Bertheau <twanger@bluetwanger.de>
Re: avoid select expens_expr(col) like unneccessary calculations Stephan Szabo <sszabo@megazone23.bigpanda.com>
Re: avoid select expens_expr(col) like unneccessary calculations Bruce Momjian <pgman@candle.pha.pa.us>
Re: avoid select expens_expr(col) like unneccessary calculations "scott.marlowe" <scott.marlowe@ihs.com>
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?
В списке pgsql-sql по дате отправления
От: Stephan Szabo
Дата:
