Parsed SQL [message #38464] |
Thu, 18 April 2002 21:47 |
sulinder singh
Messages: 10 Registered: January 2002
|
Junior Member |
|
|
Hi,
I am using Java to make sql calls,we are using prepare statement and then executing the call.
What i wanted to know was, is this sql reparsed, eg
a select * from table called twiced through java will be parsed..??
Thanks and Regards
Sulinder Singh
|
|
|
Re: Parsed SQL [message #38467 is a reply to message #38464] |
Fri, 19 April 2002 05:55 |
|
Mahesh Rajendran
Messages: 10707 Registered: March 2002 Location: oracleDocoVille
|
Senior Member Account Moderator |
|
|
Yes. ( I beleive so).
Becuase sql prepare statement in Java is just like a placeholder. It does the parsing for every call.
But in oracle, identical sql statements will not be parsed again if the parse information is available in the buffer. that why people recoment to use stored procedures in place of sql statements, so that the statements are not parased repeatedly.
|
|
|