I'm trying to do a performance enhancement for some of my modules. So i just ran a module with SET EXPALIN ON and i see all the SQL's executed are using INDEXPATH & NESTED LOOP to fetch the records.

But i could see the same module is taking long time compared to other modules. I'm a new bee to sqexplain and i dont how to make use of the out file effectively.

What all things should i check in the out file and how to work on that?