Goldman Sachs Interview Question
Software Engineer / DevelopersStored Procedures are used to execute N number of times, update multiple tables at the same time and perform faster than a normal query since the communication from PL SQL Engine to SQL engine can be made faster by using collections. On the other hand, a normal query is just run once and update only one table at a time.
A stored procedure would be faster becacause the step of parsing the SQL is not required for Procedures, because, it will already be parased and kept in the server
- Anon April 27, 2012