On Mon, Nov 18, 2013 at 7:58 PM, Zhan Li <zhanl...@gmail.com> wrote: > Hi All, > > Is there any way to force the optimizer to use a specific join operator? For > example, in SQL Server, I can do this way > > select * from (A inner hash join B on A.a = B.b) inner loop join C on A.a = > C.c > > I did some search but didn't find PostgreSQL had similar join hints except > for enable_* setting which doesn't help in my case.
PostgreSQL doesn't have join hints. With Regards, Amit Kapila. EnterpriseDB: http://www.enterprisedb.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers