2011/2/4 Mladen Gogala <mladen.gogala@xxxxxxxxxxx>
Josh Berkus wrote:Actually, I don't want Oracle hints. Oracle hints are ugly and cumbersome. I would prefer something like this:
However, since this system wasn't directly compatible with Oracle Hints,
folks pushing for hints dropped the solution as unsatisfactory. This is
the discussion we have every time: the users who want hints specifically
want hints which work exactly like Oracle's, and aren't interested in a
system designed for PostgreSQL. It's gotten very boring; it's like the
requests to support MySQL-only syntax.
As far as I can see, this should be embedded into query, should not it? You can achive something like this by setting variables right before query (usually even in same sall by embedding multiple statements into execute query call).
E.g. "set random_page_cost=1;select something that need index; set random_page_to to default;". Yes this is as ugly as a hack may look and can't be used on per-table basis in complex statement, but you have it.
--
Best regards,
Vitalii Tymchyshyn
