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...)
For this case, if clustered index impact performance? for example, if maybe change primary key index as non-clustered can improve performance?