Re: Where are prepared statements stored?
Monday, February 25, 2002 11:04 AM
this depends on the implementation of the driver and the database. each database has its own way of dealing with just about everything so prepared statements are not difference. most likely, you prepared statements are "stored" in the database itself, i.e. once prepared, database stores the execution plan for your prepared query. when that query is presented to the database through JDBC for execution, database already has the execution plan and can skip the optimizer thus helping out the performance. database is the most logical place for prepared statements to be "stored" and driver most likely does not internally store this information on neither client nor server side.