On Feb 3, 2011, at 17:08, Josh Berkus wrote: > On 2/3/11 1:18 PM, Chris Browne wrote: >> mladen.gogala@xxxxxxxxxxx (Mladen Gogala) writes: >>> I must say that this purist attitude is extremely surprising to >>> me. All the major DB vendors support optimizer hints, > > I don't think that's actually accurate. Can you give me a list of > DBMSes which support hints other than Oracle? 1 minute of Googling shows results for: db2: <http://publib.boulder.ibm.com/infocenter/dzichelp/v2r2/index.jsp?topic=/com.ibm.db2.doc.admin/p9li375.htm> informix: <http://www.ibm.com/developerworks/data/zones/informix/library/techarticle/0502fan/0502fan.html> sybase: <http://searchenterpriselinux.techtarget.com/answer/Query-hints-to-override-optimizer> mysql: <http://dev.mysql.com/doc/refman/5.0/en/index-hints.html> I haven't read much of the rest of this thread, so others may have brought these up before. Michael Glaesemann grzm seespotcode net -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
