Hi again shine007,
You told me that tables taking more time are especially lookup ones... I guess that's the only ony, isn't it ?
It is normal that lookup ones take less time because if you do not perform any computation on : you just load the data in the memory.
For the others, you first load some data in memory, and then you perform your computations (I mean by computations all the operations (mapping, Java/Perl methods), and output actions (delete, insert, update,...)).
So, in lookups you get the speed of data loading; in the other case, you get the speed of your computations (+ loading your data).
And cursor has just impact on loading the data.
Hope I'm clear and that's what you need.
And hope I'm not mistaken
.
Best regards,
Nicolas