Sergey (and others),

The original message said that this took about 1 minute in FP but now takes 7+ minutes.

Shouldn't there be some reason other than the code/data that makes the difference?

Just thinking out loud.

>Can you open table tmpperf exclusevly?
>Do you have indexes on airport, carrier and loc_code in CUSTWAIT?
>
>>Sergey,
>>
>>Thanks but it also takes 7 minutes from your codes.
>>Any new way to try,please suggest me.
>>
>>Regards,
>>PP