Re: performance strategies for many joins

From: Brian E Dick <bdick_at_cox.net>
Date: Fri, 31 Jan 2003 17:32:01 GMT
Message-ID: <lqy_9.71150$GX4.2927230@news2.east.cox.net>

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E3AAADB.B5179B79_at_exesolutions.com...
>
> SELECT DISTINCT s.srvr_id
> FROM servers s, serv_inst i
> WHERE s.srvr_id = i.srvr_id;
>
> SELECT DISTINCT srvr_id
> FROM servers
> WHERE srvr_id NOT IN (
> SELECT srvr_id
> FROM servers
> MINUS
> SELECT srvr_id
> FROM serv_inst);

I'll bite. Since you're looking for non-intuitive answers, I would say the second query would tend to do full table scans. Multiblock reads may make it faster, though.

Do I win a prize (booby or otherwise)?

Later,
BEDick Received on Fri Jan 31 2003 - 11:32:01 CST