View Single Post

  #2 (permalink)  
Old 05-11-2007, 03:48 PM
rachelle rachelle is offline
Senior Member
 
Join Date: Apr 2006
Posts: 122
rachelle is on a distinguished road
Yes you have hard parse with oracle called as Oracle can also parse the statement itself. As soon as a SQL query is given oracle retrieves the plan of the statement provided the statement has been given already by the user. On the other hand if the statement is given not only oracle takes the process of parsing by which optimized execution paths and various parameters for best performance of query execution are calculated by oracle database.
Reply With Quote