Re: Lock-up query

From: Mikael Carneholm <arch_at_comitnet.com>
Date: Fri, 30 Mar 2001 15:48:59 +0200
Message-ID: <9a22tm$3813b$1@ID-58279.news.dfncis.de>

Thanks!

The /*+HASH_AJ(<table alias>) */ hint worked great! (the query completed in 8 seconds instead of hanging).

Now all I need to do is to optimize it so that it completes in less than 1 second! ;-)

Regards,

• Mikael.

  ---

Mikael Carneholm
Systems Developer
Comitnet AB, Sweden
mikael.carneholm_at_comitnet.com
+46 33 101020

---

Received on Fri Mar 30 2001 - 07:48:59 CST