ABAP Performance issue
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.