Source from

http://www.ideas2work.com/jdbc1.html

__________________
Gokulan E

I don't think performance on PreparedStatemt or Statement can by look
from that point of view.
Of cource creation involves parsing the sql query ,finding indexed columns,optmization ,builing query plan and that's why the creation
process is "slower" both for Statemt and Prepared Statement

Excecution is different...
1.Statemts execution involves all the steps above but some vendors supports statemts caching( eq SQL Server 2000 automatically caches Statements.)
2.Using prepared statemts pool (jakarta DBCP) involves performance
3.A better way is using callable statements

Hope this is interesting
http://www.theserverside.com/article...ared-Statments

Thanks, for link to let us know more about PreparedStatement