ECTED]'
Subject: RE: [GENERAL] FW: Optimisation of IN condition
Ok, after some suggestions from a colleague, I've refactored the query to
use an outer join, like this:
hdb=> select host.ip as registeredip,arptable.ip as
realip,host.mac,arptable.router,arptable.interface from host,arpta
ntre for Computing Services|
| Imperial College |
+--+
-Original Message-
From: Mayers, Philip J [mailto:[EMAIL PROTECTED]]
Sent: 08 March 2001 11:22
To: '[EMAIL PROTECTED]'
Subject: [GENERAL] FW: Optimisation of IN condition
I'v
I've got some tables:
create table interface (
machineid text,
mac macaddr,
primary key(mac)
);
create table arptable (
router text,
interface int2,
mac macaddr,
ip inet
);
They're big, 10k rows in interface, maybe 35k in arptable. I want to do
this:
hdb=> explain select * from
