Performance of JDBC template service vs Custom SQL vs Dynamic SQL

Hi,

I want to understand how the performance of JDBC Template service, custom SQL and dynamic SQL differs.

As per my understanding, Template services and Custom SQL works as PREPARED statements so they behave identical in term of performance, where as Dynamic SQL are complied at runtime and they degrade performance. I could not find much in JDBC adapter user guide.

I want to understand the exact nature of all these SQL statements and how exactly they differ in terms of performance.

Any explanation or reference to any documentation will be highly appreciative.

Thanks in Advance.

Please go through the below mentioned URL and hopefully it will answer all your queries.

http://download.oracle.com/docs/cd/B10501_01/appdev.920/a97269/pc_13dyn.htm#588