Re: Performance problem

From: Philip Chee <philip_at_aleytys.pc.my>
Date: Mon, 19 Jul 99 14:22:06 GMT
Message-ID: <932394126.4764snx@aleytys.pc.my>

In article <oEEk3.3$CC2.1112_at_news.cwix.com> gocham_at_cwix.com writes:

>I forgot to mention tables, including indexes, data, extents, etc. are
>completely identical.
>I use indexes in both cases. Only thing that increases query run time is
>distinct clause, otherwise qury is running very fast.
>I also understand that Solaris is faster, but not 50 times faster, right?

Did you run Explain Plan on both platforms to see if there is any difference in execution path?

Philip

---=====================================================================---

 Philip Chee: Tasek Corporation Berhad, P.O.Box 254, 30908 Ipoh, MALAYSIA   e-mail: philip_at_aleytys.pc.my Voice:+60-5-545-1011 Fax:+60-5-547-3932    Guard us from the she-wolf and the wolf, and guard us from the thief,

                  oh Night, and so be good for us to pass.

---
 þ 10188.69 þ What part of "NO" didn't you understand...? Received on Mon Jul 19 1999 - 09:22:06 CDT