SQL Processing

SQL Processing

The SAP HANA SQL process starts with a SELECT statement, which is then looked up in the cache, parsed, checked, optimized, and made into a final execution plan. An overview is shown below:

The main components involved in processing an SQL query are the session, the SQL frontend, the SQL optimizer, and the execution plan.

Query Optimization Steps: Overview