No,

I mean refine your select command. only one field index can't enought.

like:

insert INTO mstr ;
 Select * From main2 Where ;
  file_date Not In ;
   (Select  file_date From mstr)

>thank you i try with one field only samething,
>

>USE main2
>select main2
>INDEX on file_date TO ll
>
>USE mstr
>select mstr
>INDEX on file_date TO tt
>
>insert INTO mstr ;
> Select * From main2 Where ;
>  DtoS(file_date) + DtoS(intervdate)+Str(num) Not In ;
>   (Select  DtoS(file_date) + DtoS(intervdate)+Str(num) ;
>    From mstr)
>

>thanks.
>
>>If you don't use "dtos" and "+" and can create your query field by field and index per field per tables I'm sure your query will be more faster.
>>
>>>hi Metin,
>>>thank you for reply.
>>>i try as under but the same time,
>>>

>>>USE main2
>>>select main2
>>>INDEX on DtoS(file_date) + DtoS(intervdate)+Str(num) TO ll
>>>
>>>USE mstr
>>>select mstr
>>>INDEX on DtoS(file_date) + DtoS(intervdate)+Str(num) TO tt
>>>insert INTO mstr ;
>>> Select * From main2 Where ;
>>>  DtoS(file_date) + DtoS(intervdate)+Str(num) Not In ;
>>>   (Select  DtoS(file_date) + DtoS(intervdate)+Str(num) ;
>>>    From mstr)
>>>

>>>thanks.
>>>>Hi Muhammed,
>>>>
>>>>Did you try create indexes with "DtoS(file_date) + DtoS(intervdate)+Str(num)" both of two files?