In conjunction with Oracle Database 23ai, Oracle Exadata System Software release 24.1.0 introduces support for Exadata Smart Scan on index-organized tables (IOTs), including all types of compressed IOTs.

This capability substantially improves query performance for applications that use index-organized tables and requires no initial configuration or ongoing administration.

You can verify the usage of Smart Scan on IOTs by viewing the query execution plan generated using the EXPLAIN PLAN SQL command. In the output, Smart Scan on an IOT is indicated when either of the following STORAGE operations appear:

• INDEX STORAGE FAST FULL SCAN

• INDEX STORAGE FULL SCAN