SAP ABAP Message Class SMMSS_DDIC Message Number 009 (FILEGROUP is not set for the table and the clustered index)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-MSS (Application Component) Microsoft SQL Server
     ⤷ SMSS_DDIC (Package) Data Dictionary Porting for Microsoft SQL Server

Attribute

Message class	SMMSS_DDIC
Short Description	DDIC Messages for Microsoft SQL Server
Message Number	009
Documentation status		Space: object requires documentation
Authorization check Error Message	☐
Changed On	20130531

Message Text

FILEGROUP is not set for the table and the clustered index

Help Document

Diagnosis

You have set CLUSTERED YES for an index; FILEGROUP is neither set for the index nor the table. However, the table and index exist in the database and are located in different filegroups. During conversion, the table would first be created in its current filegroup and then moved to the filegroup selected for the index. Depending on the size of the table, this could be very expensive.

System Response

Procedure

If you do not want to convert the table, but rather move it into the filegroup you selected for the index by creating a new index (activate and adjust database) for which you have set CLUSTERED YES, you do not have to do anything. However, if you want to convert the table, you should set CLUSTERED YES for the filegroup of the index.

Procedure for System Administration

History

Last changed on/by	20130531	SAP
SAP Release Created in