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