Inner Join.

Hi ,

I did a inner join on table MSEG and MKPF but it is taking longer time to execute the query eventhough I have mentioned all the primary keys .Why is that both the tables are also transparent tables right ?

I did a SQL trace to check it takes a longer time to execute the query .

Please suggest .

Thanks