OracleParameterizer |
Parameterization for Oracle is the same as the base Parameterizer, except that all constants are parameterized, not just strings. Not parameterizing all constants can severely hinder Oracle's a bility to scale, because it will reparse the sql and generate a new execution plan for each unique query. Having literals in the queries causes them to not exactly match. This is configurable behavior within Oracle, but we should assume that most devs don't have the ability to tweak the Oracle query analyzer. |