Re: SortMerge--HashJoin

>I have a query that on 5.0 is doing a 'sort merge', and 7.3 doing a 'dynamic hash join'. The 5.0 instance is about twice as fast. Is there a way for me to force 7.3 to do a Sort Merge? You can try setting OPTCOMPIND to 0 in your onconfig file and bouncing 7.3. You should also make sure you have similar indexes and that you've run UPDATE STATISTICS. >Also, I have a couple of off-topic questions: > >1) If I have my physical and logical logs in the root dbspace, would this in any way effect query (no update/insert) performance? (Disregarding checkpoints) I don't think so. But loading up your data initially or on a refresh basis would be slower. >2) Same question as above but with buffered/unbuffered logging status? Assuming then that 1) is unlogged? Well, even worse! Possibly *much* worse (on the loading side.) HTH. -- "I'll Be Back" Obnoxio ************************************************ Sane? Hell, if I was sane, why would I be here? ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com