Oracle "hints" support

[Former user]

It could be very useful (at least for me) if SQLAlchemy can support manually add Oracle hints (http://www.adp-gmbh.ch/ora/sql/hints/index.html).

This can be useful because sometimes Oracle (in version 10, the 11 should be better), isn't able to optimize the request the right way, and a little hint like /+ INDEX(TABLE)/ manually added can drastically improve the performance.

I tried to add this feature in SQLAlchemy 0.5.3, but the architecture is a bit complicated for me to understand.

I can try again to modify the source code and propose a patch, but I need a little help on how to "cleanly" integrate this functionnality into SQLAlchemy.

You can contact me at canarix (at) gmail

Thanks in advance,

CanariX

[Mike Bayer]

yah what would be helpful here is how the hints would be presented from both a SQL expression standpoint as well as an ORM standpoint. we'd be looking for something that potentially could be useful for other hint systems like that of MySQLs which means it could just be a very generic expression construct like prefix("SOME HINT", someexpression), something like that.

[Mike Bayer]

this ticket is contained within #921.

[Mike Bayer]

Removing milestone: 0.6.xx (automated comment)