On 28. 02. 2013 04:29, Greg Sabino Mullane wrote:
I can't think of a clean way to abstract that anyway, as just needing an index hint for MySQL does mean the same is needed on Oracle, and vice-versa.
Please don't use index hints on Oracle ... since 9i you get far better performances using CBO (cost based optimizer) rather that RBO (rule based optimizer). You use index optimizer hints only when you have an edge case (or an incompetent DBA). If you have performance issues with CBO you just have to tweak the stats on indexes and leave the actual query optimization to the DB.
LP, Jure