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.