Therefore, you might have to add an ABAP optimizer hint. For example, to enforce the ABAP index IN1 (name of the index in SAP DDIC) on table ERPTEST, you have to add the following hint: %_HINTS MSSQLNT ‘TABLE ERPTEST abindex(IN1)’. Take care that …

Read full article here..

  • https://blogs.msdn.microsoft.com/saponsqlserver/2017/12/18/customer-experience-with-columnstore-on-erp/