>Running queries on few huges tables in methodagain and again for each row in the main scan will run eternity .
>
>>Use queries instead. They don't change anything in the open tables.
>>
>>>
>>>1. I run 'scan' on few tables (table and sub tables) with 'scan \ scan while' index/es.
>>>2. I have method that giving other information from that tabless - also with same way of scan indexes.
>>>3. I have to run the first scan, and to retrieving information from the method.
>>>
>>>I affraid that the method will change my index record in main scan.
>>>
Can you give more specifics of your process? Post some of your code to see the problem.
If it's not broken, fix it until it is.
My Blog