>> The big time difference that you observe, will normally be due to different PLANs being chosen (particularly if the only difference is the data).
>>
>> Set
>>
> -----Original Message-----
>
> Hi--
>
> On a different database file

(...)

> Same indexs, same tables, same records, etc. Just different data.

(...)

> Kelly

Hi Kelly,
don´t know how much deep you are in it, but only addinig in SET comment:
differents plans may be because of index selectivity...
you can try SET STATISTICS indexname; on all index of the tables in yor select.
if solves your problem, take a search in old messages here, you will see many usefull info.

Regards,