Yes, almost all databases will cache the execution plans for queries with ? in them.
Some will also try to do the same with values in them, too, but that is not as common. Larry On 2/22/07, Mark Volkmann <[EMAIL PROTECTED]> wrote:
Just checking my understanding ... Is it the case that select statements that use # placeholders perform better than those using $ placeholders when executed multiple times? Is this because the compiled query is saved by the database so it can be reused later with different parameter values when # placeholders are used, but not when $ placeholders are used?
