Is There A Way To Use The Include Clause When Creating Indexes In Siebel Tools?

(Doc ID 1153490.1)

Last updated on JUNE 16, 2017

Applies to:

Siebel CRM - Version 15.0 [IP2015] and later
Information in this document applies to any platform.

Goal

With SQL Server 2005, it is possible to create indexes that can INCLUDE non-key columns as part of the index. Can this configuration be done in Tools?

Can you create an index in Tools for a SQL Server environment that is non clustered and has "include" columns?

MS SQL Server create index syntax
Create Relational Index
CREATE [ UNIQUE ] [ CLUSTERED | NONCLUSTERED ] INDEX index_name
ON <object> (column [ ASC | DESC ] [ ,...n ] )
[ INCLUDE (column_name [ ,...n ] ) ]
[ WHERE <filter_predicate> ]
[ WITH ( <relational_index_option> [ ,...n ] ) ]
[ ON { partition_scheme_name (column_name)
| filegroup_name
| default
}
]
[ FILESTREAM_ON { filestream_filegroup_name | partition_scheme_name | "NULL" } ]
..
INCLUDE
Specifies the non-key columns to be added to the leaf level of the
nonclustered index. The nonclustered index can be unique or non-unique.

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms