Can Siebel Tools Create Custom Index on one column with the Oracle SQL Syntax that Includes Null Values in Oracle RDBMS Index?
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 18.104.22.168.2 [IP2013] and later
Information in this document applies to any platform.
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:
(ename asc, 1)
Here, the "1" tells Oracle that to index on NULL values within the tables.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms