Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Question on create clustered index on non-primary key columns

My case is ase 12.5.

By default for each table, when create a primary key, there is a clustered index also created on the primary key column by default.

Also, only one clustered index allowed on on table.

Suppose I have a table mytab with single column primary key, say mytab(id,  col1, col2, col3...)

then I want to best performance for insert like

insert into mytab(id,  col1, col2, col3...)

values (.....)

For this case, if clustered index impact performance? for example, if maybe change primary key index as non-clustered can improve performance?

Former Member
Not what you were looking for? View more on this topic or Ask a question