1. System Overview
  2. What's New in Oracle Exadata Database Machine
  3. New Features for Oracle Exadata System Software Release 12.x
  4. What's New in Oracle Exadata Database Machine 12c Release 1 (12.1.1.1.1)
  5. Additional SQL Operators and Conditions for LOB and CLOB

9.7.1 Additional SQL Operators and Conditions for LOB and CLOB

Oracle Exadata Storage Server Software supports offload of many SQL operators and conditions for predicate evaluation. Offload of the following SQL operators and conditions are now supported by Oracle Exadata Storage Server Software:

  • LOB and CLOB Conditions

    • LIKE

    • REGEXP_LIKE

Smart Scan evaluates the LOB operators and conditions only when a LOB is inlined (stored in the table row). In addition, Smart Scan handles Secure File compression. Using Secure File compression helps reduce the size of LOBs so that they can be inlined.

Minimum software: Oracle Database release 12.1.0.2 for offload of LOB/CLOB

See Also:

Oracle Database SecureFiles and Large Objects Developer's Guide for information about inline LOBs

Parent topic: What's New in Oracle Exadata Database Machine 12c Release 1 (12.1.1.1.1)