Can Siebel Tools Create Custom Index on one column with the Oracle SQL Syntax that Includes Null Values in Oracle RDBMS Index?
(Doc ID 1993281.1)
Last updated on FEBRUARY 01, 2023
Applies to:
Siebel Tools - Version 8.2.2.4.2 [IP2013] and laterInformation in this document applies to any platform.
Goal
Is it possible to use Siebel Tools to create an index like this so that the Oracle RDBMS index will include columns with null values?
Note: Starting in Oracle 11g, there is new "create index" syntax that allows NULL values to be included in the index:
create index
emp_ename_idx
on
emp
(ename asc, 1)
;
Here, the "1" tells Oracle that to index on NULL values within the tables.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |
References |