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.
>>
Thank you
Chaim