ok,
thank you , i use it before , i need to chick another fields before insert.

>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?