Lock-up query

From: Mikael Carneholm <arch_at_comitnet.com>
Date: Fri, 30 Mar 2001 10:08:54 +0200
Message-ID: <9a1f00$3asvf$1@ID-58279.news.dfncis.de>

Hi,

I wonder if someone has had the following problem:

When selecting one attribute from a table, for example:

select c.cnumber from customers c

...everything's fine. But when running a query that tries to do a difference
using a subquery, like:

select * from customertypes ct where ct.cnumber not in (

    select c.cnumber from customers c
)

...the query hangs (had it running for ~3 hours before killing it). There's
no disc swapping, but CPU usage goes up to ~98% (on a SUN Ultra10 running Solaris 8).

Any ideas..?

---

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

---

Received on Fri Mar 30 2001 - 02:08:54 CST