Skip to Content

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

ABAP Performance issue

Dear Team,

I have one doubt about the performance issue.

I have one select statement where i am using inner join and for all entries. There is no key field in the where condition.


In production system it contains around 100000 entries, so what is the best way to using this. Secondary index is already created.

Shall i break this statement into 2 statement's.

Another option i have used HINT statement  to change the database parameter value  %_HINTS MSSQLNT '&max_blocking_factor 10&' or

                                                                                                                              %_HINTS MSSQLNT '&prefer_join 0&'.

. But the performance is same in both cases.

Please suggest how i can proceed further.

Thanks

Nishant

Helpful Answer

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