Solution : https://service.sap.com/sap/support/notes/499858 (SAP Service marketplace login required)
Key words :
<sec>goalter table <tab> drop constraint <tab0>gocreate nonclustered index <sec>, -clustered primary keyalter table <tab> add constraint <tab0> primary key nonclustered, [primary]goalter table <tab> add constraint <tab0> primary key clustered, --delete primary keyalter table <tab> drop constraint <tab0>, --create clustered secondary indexcreate clustered index <sec>, alter table mytable drop constraint [mytable~0], --delete secondary indexdrop index <tab>, posnr 1 sign parname clustered text, posnr 2 sign parname clustered text, clustered primary key constraint
Related Notes :
| 1554667 | Where-used list: Index creation performance in MSSQL |
| 965530 | 601 Errors in SQL Server |
| 942396 | Performance: RESB access on SQL Server database |
| 574849 | RSDRC/FORM DISPATCHER_RECEIVE An SQL Error occurred |
| 565710 | SQL Server: Database error 1205 (deadlock) |
| 443404 | Performance: CE4xxxx tables on SQL server |