1. System Overview
  2. What's New in Oracle Exadata Database Machine
  3. New Features for Oracle Exadata System Software 24ai
  4. What's New in Oracle Exadata System Software Release 24.1
  5. Features Coupled with Oracle Database 23ai
  6. Smart Scan on Wide Tables

2.1.14.1 Smart Scan on Wide Tables

Oracle Database 23ai introduces support for wide tables containing up to 4096 columns. Wide tables facilitate applications that use denormalized (flat) schemas to avoid SQL joins. Use cases include modern analytics, machine learning, and Internet of Things (IoT) applications.

In conjunction with Oracle Database 23ai, Oracle Exadata System Software release 24.1.0 enables Exadata Smart Scan on wide tables.

Support for wide tables must be configured in the database by setting MAX_COLUMNS=EXTENDED in the database parameter file (init.ora). Once enabled in the database, the full power of Exadata Smart Scan is automatically and transparently applied to wide tables.

Parent topic: Features Coupled with Oracle Database 23ai