SAP ABAP Data Element MSSINDCOLS (Index columns)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ STUN_MSS (Package) Package for new SQL Server monitoring objects

Basic Data

Data Element	MSSINDCOLS
Short Description	Index columns

Data Type

Category of Dictionary Type		Direct Type Entry
Type of Object Referenced		No Information
Domain / Name of Reference Type
Data Type	CHAR	Character String
Length	2078
Decimal Places	0
Output Length	2078
Value Table

Further Characteristics

Search Help: Name
Search Help: Parameters
Parameter ID
Default Component name
Change document	☐
No Input History	☐
Basic direction is set to LTR	☐
No BIDI Filtering	☐

Field Label

	Length	Field Label
Short	10	Columns
Medium	20	Index columns
Long	20	Index columns
Heading	40	Index columns and included columns

Documentation

Definition

A list of index or statistic column names.

Use

The index columns are listed followed by "included" columns within parentheses. An index with included nonkey columns can significantly improve query performance when all columns in the query are included in the index either as key or nonkey columns. Performance gains are achieved because the query optimizer can locate all the column values within the index; table or clustered index data is not accessed resulting in fewer disk I/O operations.

Dependencies

Example

ARBGB,MSGNR (SPRSL,TEXT)

History

Last changed by/on	SAP	20110908
SAP Release Created in	620