Oracle "hints" support
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
Comments (3)
-
repo owner -
repo owner - changed status to duplicate
this ticket is contained within
#921. -
repo owner - removed milestone
Removing milestone: 0.6.xx (automated comment)
- Log in to comment
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.