Skip to Content

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

about inner join's performance


In a select statement i used 7 inner join clauses.

But someone tell me I should not use so many inner join clauses and there should be at most 3 inner join clauses in a select statement.

It's another way to do the same work.Split more select statement from the one and then combin the internal tables.

I think the select statement that used 7 inner join clauses is optimized by system.It's performance is better than the other one through examination(se30).

I need your advises.Thanks.

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