Re: [HACKERS] Slow count(*) again...

Поиск
Список
Период
Сортировка
От Nick Lello
Тема Re: [HACKERS] Slow count(*) again...
Дата
Msg-id AANLkTikK86APLfOTdxekudXgK3DNPusbAQZMFfDXoas_@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Slow count(*) again...  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
Список pgsql-performance
Дерево обсуждения

Informix IDS supports hints as well; normally the only need for hints in this engine is when the Table/Index statistics are not being updated on a regular basis (ie: lazy DBA).


On 3 February 2011 22:17, Mark Kirkwood <mark.kirkwood@catalyst.net.nz> wrote:
On 04/02/11 11:08, Josh Berkus wrote:
I don't think that's actually accurate.  Can you give me a list of
DBMSes which support hints other than Oracle?

DB2 LUW (Linux, Unix, Win32 code base) has hint profiles:

http://justdb2chatter.blogspot.com/2008/06/db2-hints-optimizer-selection.html



--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



--
 
 
Nick Lello | Web Architect
o +44 (0) 8433309374 | m +44 (0) 7917 138319
Email: nick.lello at rentrak.com
RENTRAK | www.rentrak.com | NASDAQ: RENT


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

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: [HACKERS] Slow count(*) again...
Следующее
От: Mikkel Lauritsen
Дата:
Сообщение: Different execution plans for semantically equivalent queries