Horton

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

Mladen Gogala <mladen.gogala@vmsinfo.com>

View thread
From: Mladen Gogala <mladen.gogala@vmsinfo.com>
To: Mark Kirkwood <mark.kirkwood@catalyst.net.nz>
Cc: "pgsql-performance@postgresql.org" <pgsql-performance@postgresql.org>
Date: 2011-02-03T22:40:17Z
Lists: pgsql-hackers, pgsql-performance 
Mark Kirkwood 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
>
>
>   
SQL Server and MySQL too.

-- 
 
Mladen Gogala 
Sr. Oracle DBA
1500 Broadway
New York, NY 10036
(212) 329-5251
http://www.vmsinfo.com 
The Leader in Integrated Media Intelligence Solutions