|Subject||Re: slow join?|
>> The big time difference that you observe, will normally be due to different PLANs being chosen (particularly if the only difference is the data).(...)
> -----Original Message-----
> On a different database file
> Same indexs, same tables, same records, etc. Just different data.(...)
> KellyHi 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.