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@xxxxxxxxxxxxxxx> wrote:
On 04/02/11 11:08, Josh Berkus wrote:DB2 LUW (Linux, Unix, Win32 code base) has hint profiles:
I don't think that's actually accurate. Can you give me a list of
DBMSes which support hints other than Oracle?
http://justdb2chatter.blogspot.com/2008/06/db2-hints-optimizer-selection.html
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
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