[AJUG] JDBC Prepared Statement

["Crothers.Dean" <Dean.Crothers@IGT.com>]

Hi,

this might be a little off the beaten path, but I was wondering if I execute
the following command multiple times whether the database, in my case SQL
Server 2000, re-generates the query plan everytime, or has the smarts to
return a cached query plan instead?

ps = con.prepareStatement("select * from order where order_id = ?");



thanks,


Dean