Re: is it helpful for the optimiser/planner to add LIMIT 1

Поиск
Список
Период
Сортировка
От Gregory Stark
Тема Re: is it helpful for the optimiser/planner to add LIMIT 1
Дата
Msg-id 87ve2x2aam.fsf@oxford.xeocode.com
обсуждение исходный текст
Ответ на Re: is it helpful for the optimiser/planner to add LIMIT 1  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Список pgsql-general
"Ivan Sergio Borgonovo" <mail@webthatworks.it> writes:

> Summarising it up: is it worth to add it here and there as an
> optimisation flag?

Probably not. Unless you're not planning on reading all the resulting records
anyways and want the planner to optimize with that assumption.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com
  Ask me about EnterpriseDB's PostGIS support!

В списке pgsql-general по дате отправления:

Предыдущее
От: "William Temperley"
Дата:
Сообщение: Re: Secure "where in(a,b,c)" clause.
Следующее
От: Colin Fox
Дата:
Сообщение: Re: Autograph Annoucement (ERD Tool)