parameters in select statements and performance

[Mark Volkmann]

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?