Query processing in OBIEE
- Logical Request Generation (Logical SQL Request with security)
- Cache service. The server will check to see if this request can be fulfilled via a prior request using the query cache. This is an on-demand, shareable and secure cache that can supports subsets, aggregations and derivations.
- Logical Request (before navigation)
- Logical Execution Plan
- Send Physical SQL
- Sort and join results set