Solution : https://service.sap.com/sap/support/notes/892592 (SAP Service marketplace login required)
Key words :
-- begin scriptuse idesgocreate nonclustered index [cdbd_status_act1], --end scriptthen deletion--begin scriptuse idesdelete, performance optimal--begin scriptuse ides-- select, nocheck add constraint [df__cdbd_stat__mandt__7c570027] default, cdbd_status tablecreate clustered index [cl_objnr], cdbd_status tabledrop table cdbd_statusgo-- rename, temporary table-- filter table cdbd_status, sql server log file, [primary]goalter table [dbo], --begin scriptuse idesdelete
Related Notes :
| 1040744 | Conntrans Performance Overview |
| 892238 | Prevention of download of data to CDBD_STATUS from CRM. |