>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