2.1.14.8 Transparent Cross-Tier Scan

In conjunction with Oracle Database 23ai and Oracle Database In-Memory, Oracle Exadata System Software release 24.1.0 enables a single query to utilize the combined power of in-memory columnar scan on the database servers along with Exadata Smart Scan and columnar cache on the storage servers. Previously, a single query could use an in-memory columnar scan on the database servers or Exadata Smart Scan and columnar cache on the storage servers, but not both.

Known as Transparent Cross-Tier Scan, this capability enables a query to efficiently utilize all available system resources and data representations to deliver better query performance. A Transparent Cross-Tier Scan ideally suits analytical queries on large tables where the data is spread across the database servers and storage servers.