Subject Re: slow join?
Author emb_blaster
>> 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.