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
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,arptable where
host.mac = arptable.mac and host.ip = arptable.ip
hdb-> union
hdb
