Domain Index :UDT OPERATOR RETURNING NULL WHEN CALLED FROM A VIEW (Doc ID 3070638.1)

Last updated on FEBRUARY 04, 2025

Applies to:

Symptoms

On : 18.3.0.0.0 version, Creating/Maintaining context indexes

ACTUAL BEHAVIOR
---------------
The issue on the value of SQL result when creating domain index

The issue on the value of SQL result when creating domain index
 - If you create an Oracle domain index and query only that column, that is, when only the domain index scan occurs without table scan, the result value comes out as null even though it exists.
- As a result, only the domain index scan occurs in SQL without the table scan
- Consequently, only SQL with normal index and domain index's BITMAP CONVERSION without table scan
- Not on Oracle 12c, but on 18c, 19c.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.