A look at Parsing and Sharing of Cursors
Parsing is the first stage in processing a SQL statement – the other two being Execute and Fetch stages. Parse once – execute many is a very important performance tuning goal. What does parsing involve Syntax check – is the SQL statement syntactically correct Semantic check – is the SQL statement meaningful or semantically correct. […]