Welcome to our Blog !  Sign in,  and write something ..

Processing SQL queries in Oracle and PostgreSQL

Initial parsing phase of SQL query processing is pretty much similar for the both Oracle and PostgreSQL databases.

However, when paersing completed, there is a big difference,.Oracle stores compiled queries in a Global Library Cache, which is available for all sessions for a running Oracle Instance. PostgreSQL, stores pre-processed queries in a process local memory.